Sorry, forgot that, this was just the response to shutting down and leaving it off overnight part of the previous suggestion
That was the whole dialog though.
I meant for you to rerun the following command:BradleyinDC wrote: ↑Tue Sep 20, 2022 4:53 pmSorry, forgot that, this was just the response to shutting down and leaving it off overnight part of the previous suggestion
That was the whole dialog though.
Code: Select all
sudo tail -n 50 /opt/dvr/var/db/mariadb/localhost.err
Code: Select all
sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mariadb-server.plist
Craig, these should do the trick:
Code: Select all
if sudo -u "_mysql" test -w '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "writable";else echo "not-writable";fi
if sudo -u "_mysql" test -r '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "readable";else echo "not-readable";fi
Last login: Tue Sep 20 10:01:08 on ttys000pvr4me wrote: ↑Tue Sep 20, 2022 5:20 pm
I meant for you to rerun the following command:
CraigCode: Select all
sudo tail -n 50 /opt/dvr/var/db/mariadb/localhost.err
no issues with either of thosejhoyt wrote: ↑Tue Sep 20, 2022 11:34 pmAlso - it might be worth going into Preference -> Security & Privacy first to check the "General" tab to see if security is blocking mysqld.
It's also worth checking the firewall settings to see if a connection needs to be added (or approved) for mysqld. An easy check of the firewall theory would be to temporarily disable the firewall, startup mysqld, and see if anything improves. BUT - make sure to turn your firewall back on after testing...
Finally, you may need to go into the Privacy tab and give mysqld access to the filesystem.
Code: Select all
220920 6:31:49 InnoDB: The InnoDB memory heap is disabled
220920 6:31:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
220920 6:31:49 InnoDB: Compressed tables use zlib 1.2.10
220920 6:31:49 InnoDB: Initializing buffer pool, size = 128.0M
220920 6:31:49 InnoDB: Completed initialization of buffer pool
220920 6:31:49 InnoDB: highest supported file format is Barracuda.
220920 6:31:49 InnoDB: Waiting for the background threads to start
220920 6:31:50 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 1597945
220920 6:31:50 [Note] Server socket created on IP: '::'.
220920 6:31:50 [Note] Event Scheduler: Loaded 0 events
220920 6:31:50 [Note] /opt/dvr/lib/mariadb/bin/mysqld: ready for connections.
Version: '5.5.52-MariaDB' socket: '/opt/dvr/var/run/mariadb/mysqld.sock' port: 3306 Source distribution
220920 10:01:14 [ERROR] mysqld: Can't lock aria control file '/opt/dvr/var/db/mariadb/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
220920 10:01:45 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/opt/dvr/var/db/mariadb/aria_log_control'
220920 10:01:45 [ERROR] Plugin 'Aria' init function returned error.
220920 10:01:45 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
ERROR: 1017 Can't find file: '/var/tmp/#sql14ccf_1_3' (errno: 2)
220920 10:01:45 [ERROR] Aborting
220920 10:01:46 [Note] /opt/dvr/lib/mariadb/bin/mysqld: Shutdown complete
@bradleyindc you should run these commands in Terminal and let us know the results.jhoyt wrote: ↑Tue Sep 20, 2022 10:49 pmCraig, these should do the trick:
Code: Select all
if sudo -u "_mysql" test -w '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "writable";else echo "not-writable";fi if sudo -u "_mysql" test -r '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "readable";else echo "not-readable";fi
Code: Select all
sudo ps -Ax |grep my
Restored session: Wed Sep 21 01:01:39 EDT 2022pvr4me wrote: ↑Wed Sep 21, 2022 12:10 pm@bradleyindc you should run these commands in Terminal and let us know the results.jhoyt wrote: ↑Tue Sep 20, 2022 10:49 pmCraig, these should do the trick:
Code: Select all
if sudo -u "_mysql" test -w '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "writable";else echo "not-writable";fi if sudo -u "_mysql" test -r '/opt/dvr/var/db/mariadb/aria_log_control'; then echo "readable";else echo "not-readable";fi
Craig
Activity Monitory was showing "My processes" but when switched to "All processes" still nothing (from the search bar).pvr4me wrote: ↑Wed Sep 21, 2022 12:23 pmBTW, when using Activity Monitor to check for mysqld, you may have to change a setting. In the View menu for that application, make sure that "All processes" is checked rather than "My processes".
Another way to check if mysqld is running is the following command in Terminal:
CraigCode: Select all
sudo ps -Ax |grep my
Code: Select all
mysql -u root < /opt/dvr/share/mythtv/database/mythconverg_init.sql
Code: Select all
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
jbradleyjansen@MacBook-Pro-BigSur ~ % mysql -u root < /opt/dvr/share/mythtv/database/mythconverg_init.sqlpvr4me wrote: ↑Wed Sep 21, 2022 3:41 pmWell, there you go -- mysqld IS running. Now we just have to finish the configuration. Try this command:
It has been a while and I can't recall if there is any output from this or not. No output for sure means it worked. If that is the case, you can try the next command:Code: Select all
mysql -u root < /opt/dvr/share/mythtv/database/mythconverg_init.sql
You will get a series of warning messages. These are no cause for alarm unless your specific time zone fails to process.Code: Select all
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
If those both work, you should be able to carry on with mythtv-setup.
Craig