mysql

I thought this might be of interest to some in the FreeBSD community: An opportunity to ask questions that could get FreeBSD more on the radar for MariaDB plc, or just to ask any awkward question you might want to hear Monty answer, who after all is a bit of an open source legend (despite the...

Hello. I installed mariadb114-client and mariadb114-server from pkg on FreeBSD 14.1-RELEASE-p2. Despite being a fresh install I'm unable to start mysql-server. Running (as root) service mysql-server start shows the Starting mysql. message right after but it takes about 10 seconds for the command...

I'm about to set up mysql on a machine, and I know that in the past I've read about setting up specifically tweaked dedicated zfs datasets for it. I've never done that for mysql before, but I figure now if ever is the time to try it out. So, I searched for info about this to refresh my memory...

I briefly knocked my personal web server offline while upgrading the database. In this thread I explain the errors I encountered and how to fix them. 1. Different lower_case_table_names settings for server ('0') and data dictionary ('1'). Probably best to back up your config file before...

Hi. I'd like to move my mail server (postfix+dovecot) from OpenBSD to FreeBSD 14. Under OpenBSD, there is a package of Postfix with SASL2 and MySQL support together (postfix-3.8-sasl2-mysql). Is there anything like that under FreeBSD, containing both SASL and MySQL support as a single package...

I seem to recall kde depending on mysql, but my notes on this are ancient and I'm not using kde. But, my question is, is there a preference for one over the other in FreeBSD? I don't have a personal preference.

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...