mysql

I was hoping to migrate from MySQL to Percona, but I no longer see in the ports system. Why was it removed?

according to the https://daemonforums.org/showthread.php?t=193 guide , I'm installing an MTA, and MDA and so on. I didn't find schema of the following cf files: # touch /usr/local/etc/postfix/mysql_virtual_domains_maps.cf # vim /usr/local/etc/postfix/mysql_virtual_domains_maps.cf user = postfix...

I have uploaded a CodeIgniter 4 website that's working perfectly fine on web hosting and local server into a FreeBSD server running with PHP, PHP-FPM, Apache, and MySQL. The virtual hosts has been set up to use the 'public' directory as the root. But when accessing the website via the domain...

I'm not too skilled in SQL software in general and always relied on mysqldump command to do complete and comprehensive "snapshot-type" backup of everything. However I found out recently that it doesn't work properly on some complex databases, such as the one created by Magento. Backups would be...

I'm planning to set my MariaDB SQL server with the following options on FreeBSD 13.1 + ZFS. I'm planning a modest, non-dangerous set of options: skip-innodb_doublewrite symbolic-links=0 max_allowed_packet=512M max_connections=250 innodb_io_capacity=15000 innodb_doublewrite = 0...

Hello, Just looking for someone to help of exploring freeRADIUS server. I need to somehow get familiar with server in order to apply additional profiles to the NAS, but now I'm somewhere close of being alone because of some tragic situation in local area. Please help, even might pay for...

Hello, I'm trying to "work" with KOI-8R scripts on new FreeBSD installation, but there is one problem, the Russian characters itself looks like mess. On Linux where my production server is, before accessing mysql I'm typing some magic "source 2koi", and on locale command have such: # locale...

Hello! It seems like databases/php81-pdo_mysql doesn't build, is it still needed? I can't get pdo_mysql to work in any other way. Thanks for any help.

My 12.2-RELEASE-p3 server is running out of memory then crashing, most of the memory is used by mysql57-server-5.7.32 The server is using ZFS, any ideas what should I check/change? % sysctl hw.physmem hw.physmem: 137297674240 % sysctl hw.ncpu hw.ncpu: 72 /var/log/messages says things like Jan...

I upgraded my mariadb to 105 and get the following error message after running upgraded my mariadb to 105 and get the following error message after running /usr/local/libexec/mysqld my error: /root{106}# tail -f /var/log/mysql/mysqld.err 2022-01-01 3:12:40 0 [Note] InnoDB: Initializing buffer...

I upgrade my freebsd and all of my packages, But mysql can't start after upgrade. How do I start it? By the way, My MySQL doesn't create any log messages.

Installed Nextcloud a while back and ran into some issues. I immediately ran into some health/family issues so I left if as it was and am now just getting back to it.. When I check the log file I get: Some info for the minds here to help: FreeBSD Bender 13.0-RELEASE FreeBSD 13.0-RELEASE #0...

Hi there got problem with sieve (it doesn't move mails to directories i mean spam to "Junk" folder. In logs there is no information about any errors. Spamassassin is called from amavisd and tags mail (as spam) properly but sieve doesn't move mails. installed packages: amavisd-new-2.12.0_1,1...

Hi fellow enthusiasts, I wrote a short article on securing a FreeBSD 12 web server with nginx, php-fpm and mysql 8 by focusing on website isolation. Specifically, the goal was to create different php-fpm pools for each nginx virtual server, with them sharing a unique socket for each website. In...

After upgrading to mariadb 10.4.13_3 I'm unable to connect to mysql server via the normal port method. I can connect from the command line and via socket though. Anyone have any idea why that might be? I've read UPDATING and all the stuff about the new config file locations, etc. and everything...

Once I install kde plasma on my desktop, it uses mysql57. However I want to upgrade it to mysql 80 and "eject" the dependency it from kde plasma. IF I do pkg remove -f mysql57 the system works fine as it is not used much, however when I try to install mysql80 it tries to "update" my packages and...

So, I upgraded freebsd from 11.1 to 12.1 after this I updated ports and upgraded softwares like mysql, php etc. So, most software work even though there's warnings because configs are using outdated stuff. However, most software still runs and works. Mysql is the only thing that's broken. It...

Hello, I have problems with MariaDB. Installation works well, MariaDB is running fine, too. But it won't start after boot automatically and service command do not work. root@thesaurus:/home/XXX # /usr/local/etc/rc.d/mysql-server status mysql is running as pid 1417. root@thesaurus:/home/XXX #...

After enable all log and debug, have found where the problem occour on auth-worker which is getting plain password and not hashing it: ... SHA512-CRYPT(plainpasswordhere) != 'HASH value from mysql' Then occours password missmatch error. Someone have same issue? PS.: Happen on last update of...

I have Hyper-V with Freebsd 12 on vitrual machine. I intalled web server (apache, php, mysql) on freebsd. After hard restarting my hyper-v server (press power button on server) FreeBSD doesn't work, mysql doesn't mount database. I have more troubles with database files. But, if i stoping all...