mysql

  1. K

    ZFS optimization for MariaDB/MySQL server?

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

    freeRADIUS help needed

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

    Working with terminal in mysql with different encodings on freebsd

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

    Solved php 8.1 pdo_mysql broken

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

    Solved FreeBSD running out of memory - MySQL

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

    Solved InnoDB: Upgrade after a crash is not supported

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

    mysql can't start after upgrade

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

    Solved Nextcloud issues.

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

    Solved problem with sieve ... Postfix + mysql+ postfixadmin + dovecot + sieve + amavisd (with spamassassin and clamav)

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

    new article on nginx, php-fpm, and mysql 8 on FreeBSD 12 for Wordpress hosting

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

    Solved Can't connect to mysql database after upgrading to mariadb 10.4.13_3

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

    Update mysql/eject mysql from kde plasma

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

    mysql broken after upgrading freebsd

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

    MariaDB won't start automatically

    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 #...
  15. W

    Solved Dovecot password missmatch after lastest update 01/2020

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

    FreeBSD doesn't starting after restart

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

    failed on start mysql80-server on FreeBSD12.0

    Hi! I installed mysql80-server today, but I cant not start it. root@VM_0_11_freebsd:/usr/ports/database s/mysql80-server # p root@VM_0_11_freebsd:/usr/ports/databases/mysql80-server # pwd_mkdb -p /e tc/master.passwd root@VM_0_11_freebsd:/usr/ports/databases/mysql80-server # sysrc mysql_en...
  18. goshanecr

    database/mysql57-client Linking fails on 11.2 i386

    Good day! I have a server uname -a FreeBSD db_mysql 11.2-STABLE FreeBSD 11.2-STABLE #0 r338358: Thu Aug 30 01:29:38 +05 2018 user@BSD-TENNIS:/usr/obj/usr/src/sys/BSDSERV i386 And on that server works several jails. One named db_mysql has mysql57-{server,client}. pkg info | grep mysql...
  19. T

    Cannot login to Maia mailguard

    Hi, I'm running maia mailguard 1.0.3 (A Virus and Spam Management Solution for Email ) and have set 2 primary account as administrator, and I’ve tried switch account as primary from account1 to account2. After that I cannot login with new primary account with error : Login for user...
  20. Maelstorm

    PHP can't connect to MySQL

    I am running FreeBSD 11.1, PHP 7.2, Apache 2.4, and some version of MySQL. The problem is that when I try to access the test page from the web, I get an error that says "Failed to connect to database: could not find driver." I made sure that pdo_mysql was installed, and it shows up on the list...
Top