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.

Related Posts

Blog Traffic Exchange Related Posts
  • Mandriva 2006 upgrade on Inspiron 8000 laptop saga Part I I had a chance today to start the upgrade process for Mandriva 2006 on my laptop (Dell Inspiron 8000). Now, let's see.... a bit of background. Mandriva (Mandrive/Mandrake) has been my favorite distro since converting to linux several years back (around Mandrake 8.1 or 8.2) I've had it running on......
  • Google Voice Review | I got the golden ticket.... Last Thursday I opened up my GMail and found to my surprise that I had an invite to Google Voice. I didn't have time to deal with it at that time, so I saved it as new until Thursday evening and spent some time then playing with it. I had......
  • Building Deb packages from source.... Openvpn has been one of the tools of choice this week, so as I was tinkering on my ubuntu boxen.... I thought why don't I install openvpn there as well for a little broader testing. So, I did, but was a bit disappointed to see that the version was not......
Blog Traffic Exchange Related Websites
  • How To Start An Online Article Directory Article marketing is a great way for online businesses to market not only their business but themselves through the content they write. A key to article marketing though is placing the article somewhere where people will be able to see it, which is where article directories come in. This article......
  • Download Microsoft Windows 7 RC Hi Folks, Microsoft has released Windows 7 RC. Here's what you need to know: This is pre-release software, so please read the following to get an idea of the risks and key things you need to know before you try the RC. You don't need to rush to get the......
  • Vuze - My Favorite BitTorrent Client I have been using Vuze for about 2 years and as for now I am very satisfied with this software. The main reason that I like this software is the torrent search function and the software does not interrupt my internet browsing bandwidth. Vuze was previously known as Azureus and......
PDF24    Send article as PDF   

Similar Posts


See what happened this day in history from either BBC Wikipedia
Search:
Keywords:
Amazon Logo

Comments are closed.


Switch to our mobile site