[SOLVED] Slackware 15.0+ roll to new rc.mysqld from Feb 18 2024 cannot connect to database
by rocknrobin from LinuxQuestions.org on (#6MHGZ)
Hell-o. I was updating some new files from slackpkg updates and one of the new ones I rolled to was /etc/rc.d/rc.mysqld.new.
Code:
root@robrutrm:/etc/rc.d# ls -l | grep rc.mysqld
-rwxr-xr-x 1 root root 2683 Jul 15 2023 rc.mysqld*
-rwxr-xr-x 1 root root 2517 Feb 18 17:20 rc.mysqld.new*
-rwxr-xr-x 1 root root 2766 Mar 27 2019 rc.mysqld.old*
-rwxr-xr-x 1 root root 2764 Mar 27 2019 rc.mysqld_bak*When I did this I could no longer connect either to the main database or the mythtv database.
Code:
root@robrutrm:/var/log# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local server through socket '/var/run/mysql/mysql.sock' (2)
root@robrutrm:/var/log# mysql -u root -h 10.160.134.69 -p
Enter password:
ERROR 2002 (HY000): Can't connect to server on '10.160.134.69' (115)
root@robrutrm:/etc/rc.d# mysql -u mythtv -h 10.160.134.69 -p mythconverg
Enter password:
ERROR 2002 (HY000): Can't connect to server on '10.160.134.69' (115)Of course this doesn't allow the mythtv backend to start since it cannot connect to the mythtv database.
I rolled back to the original rc.mysqld and now I can connect to the database again.
Code:
root@robrutrm:/etc/rc.d# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.11.7-MariaDB Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
root@robrutrm:/etc/rc.d# mysql -u mythtv -h 10.160.134.69 -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.11.7-MariaDB Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [mythconverg]>And now mythtv works again.
Anybody have any ideas how the new rc.mysqld broke mariadb?
Code:
root@robrutrm:/etc/rc.d# ls -l | grep rc.mysqld
-rwxr-xr-x 1 root root 2683 Jul 15 2023 rc.mysqld*
-rwxr-xr-x 1 root root 2517 Feb 18 17:20 rc.mysqld.new*
-rwxr-xr-x 1 root root 2766 Mar 27 2019 rc.mysqld.old*
-rwxr-xr-x 1 root root 2764 Mar 27 2019 rc.mysqld_bak*When I did this I could no longer connect either to the main database or the mythtv database.
Code:
root@robrutrm:/var/log# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local server through socket '/var/run/mysql/mysql.sock' (2)
root@robrutrm:/var/log# mysql -u root -h 10.160.134.69 -p
Enter password:
ERROR 2002 (HY000): Can't connect to server on '10.160.134.69' (115)
root@robrutrm:/etc/rc.d# mysql -u mythtv -h 10.160.134.69 -p mythconverg
Enter password:
ERROR 2002 (HY000): Can't connect to server on '10.160.134.69' (115)Of course this doesn't allow the mythtv backend to start since it cannot connect to the mythtv database.
I rolled back to the original rc.mysqld and now I can connect to the database again.
Code:
root@robrutrm:/etc/rc.d# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.11.7-MariaDB Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
root@robrutrm:/etc/rc.d# mysql -u mythtv -h 10.160.134.69 -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.11.7-MariaDB Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [mythconverg]>And now mythtv works again.
Anybody have any ideas how the new rc.mysqld broke mariadb?