The 2nd journey begins… Mandriva 2006 upgrade 2 – Part 9
Still running the qemu image (and downloaded another image from the freeoszoo while I was waiting for the installer.) Anyway… I’ve turned my attention to mythtv and since it’s the same version went to test if it was working well. Let’s see… for starters, since the local machine had seen a mysql upgrade (and the installer didn’t think I needed to run mysql at boot…) I had to do…
#chkconfig –level 345 mysqld on
#mysqld start
#service mythbackend restart
On the local machine (encoding machine.) Tested and mythfrontend found things fine… so the next step was to see if network mythfrontend clients could still connect. They couldn’t and complained about not being able to connect to the mysql server.
The default setup for Mandriva is pretty good when you think about it. Mysql (d) is configured by default to NOT listen on the network, but to use a socket file for localhost only connections. Now, since long ago I’d done the database permission change to allow other mythfrontends to use the database I just had to remember where to allow it to listen on a tcp port. The /etc/my.cnf file seemed promising, but adding port=3306 there didn’t make a difference. (In fact it failed to load.)
So, after reading the /etc/rc.d/init.d/mysqld file for clues, I noticed that in Mandriva, mysqld looks in /etc/sysconfig/mysqld for extra options… where I found the following line…
MYSQLD_OPTIONS=”–skip-networking”
commented it out and restarted mysqld (service mysqld restart), tested with…
netstat -a | grep mysql and saw
tcp 0 0 *:mysql *:* LISTEN
Which looked promising, then tested from remote to prove that all was good.