Thanks for point out where the mariadb log file was.. .in my my.cnf it was at /opt/local/var/db/mariadb/localhost.err. I will update my my.cnf to be a log file tosfatula wrote:In /opt/local/etc/mariadb/my.cnf, you can specify where you want any log files. I don't know if there is a default (mine is always custom), if there was, I would expect it to be in /opt/local/var/log and possibly under mariadb there. Looking at the macports defailts, it might actually be /opt/local/var/db/mariadb/localhost.err? It sounds sort of like mariadb might be having issues and stopping now and then which would then give you the errors. The log file would show any issues. You sure you didn't also change mariadb versions (major ones), and if you did, you do need to run the upgrade on the database. Or, you may also have crashed tables or other odd issues. The log would tell you. Since you say it connects sometimes, it should not have anything to do with user or passwords.
Code: Select all
[log-error=/opt/local/var/log/mariadb/localhost.log
i used for 0.28
Code: Select all
sudo port install mythtv-core.28 +mariadb+mariadb55+python27+perl5_24
Code: Select all
sudo port install mythtv-core.27
+mariadb+mariadb55+python27+perl5_16
Here is the log file results from over 1 week ago when I rebooted. I haven't seen anything else in the log file since.
Also, I have sleep = never.
160923 7:32:17 [Note] /opt/local/lib/mariadb/bin/mysqld: Normal shutdown
160923 7:32:21 [Note] Event Scheduler: Purging the queue. 0 events
160923 7:32:23 InnoDB: Starting shutdown...
160923 7:32:24 InnoDB: Waiting for 1 pages to be flushed
160923 7:32:25 InnoDB: Shutdown completed; log sequence number 1001324168
160923 7:32:28 [Note] /opt/local/lib/mariadb/bin/mysqld: Shutdown complete
160923 7:38:30 InnoDB: The InnoDB memory heap is disabled
160923 7:38:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160923 7:38:30 InnoDB: Compressed tables use zlib 1.2.8
160923 7:38:30 InnoDB: Initializing buffer pool, size = 128.0M
160923 7:38:30 InnoDB: Completed initialization of buffer pool
160923 7:38:30 InnoDB: highest supported file format is Barracuda.
160923 7:38:30 InnoDB: Waiting for the background threads to start
160923 7:38:31 Percona XtraDB (http://www.percona.com) 5.5.48-MariaDB-37.8 started; log sequence number 1001324168
160923 7:38:31 [Note] Server socket created on IP: '::'.
160923 7:38:31 [Note] Event Scheduler: Loaded 0 events
160923 7:38:31 [Note] /opt/local/lib/mariadb/bin/mysqld: ready for connections.
Version: '5.5.49-MariaDB' socket: '/opt/local/var/run/mariadb/mysqld.sock' port: 3306 Source distribution
160923 7:38:50 [Warning] IP address '192.168.1.8' could not be resolved: nodename nor servname provided, or not known
160923 7:42:01 [Warning] IP address '192.168.1.19' could not be resolved: nodename nor servname provided, or not known
160923 7:42:21 [Warning] IP address '192.168.1.9' could not be resolved: nodename nor servname provided, or not known