mysql

  1. 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...
  2. 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...
  3. 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...
  4. L

    MariaDB socket in jail not created at host boot

    There's a jail for MariaDB mysql Ver 15.1 Distrib 10.2.15-MariaDB, for FreeBSD11.1 (amd64) using readline 5.1. A socket should be created in /var/run/mysql [client] port = 3306 socket = /var/run/mysql/mysql.sock [mysqld] port = 3306 socket =...
  5. fullauto2012

    mysql56 and phpbb3/nextcloud

    root@kif:/var/db/mysql # uname -a FreeBSD kif 10.3-RELEASE FreeBSD 10.3-RELEASE #0 r297264: Fri Mar 25 02:10:02 UTC 2016 root@releng1.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC amd64 Had databases/mysql80-server installed with www/nextcloud running. Wanted to add a www/phpbb3 instance...
  6. G

    Solved .mysql_secret not found for mysql56

    FreeBSD 10.3. Installing mysql56, but cannot find .mysql_secret in either /root or /home/USERNAME. Have reinstalled without success. Have searched for file using FIND command. Where is this file?
  7. M

    MySQL - login issue

    freebsd-version: 11.1-RELEASE mysql version: 5.6.38 I have a script the requires mysql, cron_create_tables.pl: #!/usr/local/bin/perl -w -- use DBI; use strict; my $dbh = DBI->connect('DBI:mysql:mymud', 'mymud', '') or die "unable to connect to MyMUD database"; ... $ perl...
  8. R

    Unable to load modules gmysql for powerdns

    Installed Powerdns and mysql57-server and client still I am facing this problem #pdns_server --daemon=no --guardian=no --loglevel=9 Aug 19 09:26:46 Reading random entropy from '/dev/urandom' Aug 19 09:26:46 Loading '/usr/local/lib/pdns/libgmysqlbackend.so' Aug 19 09:26:46 Unable to load module...
  9. M

    Solved MySQL 5.5 Upgrade Issue

    I'm trying to upgrade databases/mysql55-server from 5.5.55 to 5.5.55_1. This is the errors I am receiving. Is it safe to continue with the upgrade? $ sudo portmaster mysql55-server-5.5.55 ===>>> Currently installed version: mysql55-server-5.5.55 ===>>> Port directory...
  10. Itproman

    Solved Apache24 Mysql PHP install problem

    Apache 24 install,configuration and start successful. Mysql install is the problem: pkg install mysql57-server mysql57-client Error message: http://http://pkg.freebsd.org/FreeBSD:11:amd64/latest/All/pkg.FreeBSD.org/FreeBSD:11:amd64/quarterly/All/mysql57-server-5.7.17_3.txz: Not Found I...
  11. MMacD

    MariaDB still not reading my.cnf?

    Apologies if this isn't the right place for this. Am I doing something stupid, or not doing something I should be doing? Because if not, MariaDB still isn't interpreting my.cnf, although it complains if it's not in /usr/local/etc/mysql. The command: 13:59:57 Thu, 16 Feb...
  12. formaltux

    Failed upgrade mysql 5.6.34 to 5.6.35 (portupgrade)

    Hi, Yesterday morning around 8 am (GMT+1), I performed what should of been standard MySQL upgrade from MySQL 5.6.34 to MySQL 5.6.35 using portupgrade, but ended up losing InnoDB tables completely and spending whole day getting them restored. I ran mysql_upgrade after database restart and...
  13. IPTRACE

    10.3->11.0 (mysql does not start)

    Hello! Next problem after upgrade to 11.0-RELEASE. MySQL does not start. No data in logs. Reinstallation didn't help. @db1:~ % sudo service mysql-server status mysql is not running. @db1:~ % sudo service mysql-server start Starting mysql. @db1:~ % sudo service mysql-server status mysql is not...
  14. G

    Problem starting MySQL

    Hi All, I have a problem starting MySQL, (5.7.13_1). From my err.log Shared object "liblz4.so.1" not found, required by "mysqld" Bit of background, this was an old FreeBSD 9.x server that I updated to 10.2 some time ago. I recently upgraded MySQL, all went fine at the time. Was forced to...
  15. FKEinternet

    Data no longer accessible after upgrade from MySQL 5.6 to 5.7

    I upgraded my server from MySQL 5.6 to 5.7 via pkg install mysql57-server. After getting the changed configuration issues sorted out so I could run mysql_upgrade -u root -p successfully, it reported that practically all of my existing tables don't exist - because they are stored on disk with...
  16. Neveroldmilk

    Have problems to start MySQL 5.7

    I used pkg to install MySQL 5.7 by this command: $ sudo pkg install mysql57-server Then I have problems to start MySQL, and the command and output is listed below: $ sudo sysrc mysql_enable=yes mysql_enable: -> yes $ sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING...
  17. L

    ZFS Benchmark for measuring storage performance

    Benchmark to measure the storage performance when I send database query. I install Mysql because it has its own benchmark mysqlslp. I use also sysbench. The problem is how to measuring storage performance when the query is sent, and what is the most important parameters to be put under stress...
  18. F

    ERROR 2002 (HY00): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    How can I backup the databases in MySQL 5.6 if it will not run? It will not create an mysql.sock so I can't do a dump. I have also reinstalled MySQL 5.6 two times without errors and will not create mysql.sock to get the MySQL running to perform the dump / backup. I have the mysql directory...
  19. cytopia

    Porting mysqldump-secure (port maintainer?)

    Hi guys, I am trying to fully port mysqldump-secure over to FreeBSD. It is already at the state that the script itself is 100% fully working (POSIX shell without any bashism: #!/bin/sh). I have one request as well as one error and one problem. 1. The request I would like to get this as a...
  20. nonTechnical

    MySQL installed - but without config example files - why?

    I've just installed databases/mysql57-server on a new server, but can't see the example config files in /usr/local/share/mysql or anywhere to copy to run the server. I've used: $ sudo find / -name "mysql*" 2>/dev/null and /usr/local/share/mysql/ has: my-default.cnf mysql-log-rotate...
Top