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
  • Zotob worm bites big media outlets According to several reports there are several big media outlets seeing what is reported as the zotob worm which exploits a Microsoft Windows vulnerability (MS05-039) disclosed last week. There seems to be no better way for something to make the news than for it to affect the companies that bring......
  • More linux software raid fun OK, I know there are probably quite a few looking at this thinking.... "Hello where has he been?" when I'm talking about playing around with software raid under ubuntu linux, but.... in spite of all I've done supporting desktop systems and even small business servers I've never had an opportunity......
  • The 2nd journey begins… Mandriva 2006 upgrade 2 - Part 10 I think it's time to wrap things up. The KDE start new session option is back after the changes I mentioned to the /etc/kde/kdm/kdmrc file I mentioned in a previous post. There are no outstanding issues from the upgrade. (I need to adjust the font sizes down a bit, but......
Blog Traffic Exchange Related Websites
  • More Tips on Buying Violins With the vast assortment violins to choose from, buying a new instrument can be quite a challenging endeavor. However, this task can be much easier if you do some research ahead of time. The following are some points to remember when buying a new or used violin. If you are......
  • Not Allowed To Edit Post In Wordpress Another Wordpress Error! [/caption] Nothing like getting a dreaded wordpress error message. At first I was going to document how I solved my problem. 26 frustrating hours later, I decided to just point you in the right direction because the answer isn't a one size fits all answer. The only......
  • Lobster Elite Model 3 Tennis Ball Machine One of the best ways to practice tennis is to use a ball machine, but these can be expensive. If you have your own home court, or you play at a public court system where there isn’t a ball machine on site, buying your own is an option that many......
www.pdf24.org    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