MYSQL

I don't know anything about mythtv, but from synaptic I see that it depends on mysql-server. So you probably need to have mysql-server installed, configured and running in order to use mythtv.

Thanks Dave_L
mysql-server-5.0 is installed
How do I configure it?
I will settle for having mysql work

vaya con dias

pringle1944, do you have mysql running?

From a konsole, enter the command "ps -ef | grep mysql". You should see at least one line that begins with "/usr/sbin/mysqld...". Also, you should have services set up to be started when the box is powered up. Perform the command "ls -lad /etc/rc*d/*mysql*" to see if the startup links have been created. You should see something like:

$ ls -lad /etc/rc*d/*mysql*
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc0.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc1.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc2.d/S20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc3.d/S20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc4.d/S20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc5.d/S20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 15 Oct 19  2005 /etc/rc6.d/K20mysql -> ../init.d/mysql
$

If that's been taken care of, but you installed mysql after mythtv then you may need to uninstall mythtv and reinstall it. I have not worked with mythtv (yet), but it likes to create its own user, password, and database in mysql, so it's easier, if you haven't started yet, to remove/reinstall than to try to do all of the steps by hand.

Jon

Jon
this is the output in konsole

root@1[george]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@1[george]# ps -ef | grep mysql
root 20339 5042 0 18:08 pts/1 00:00:00 grep mysql
root@1[george]# ls -lad /etc/rc*d/*mysql*
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc0.d/K19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc0.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc0.d/K21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc1.d/K19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc1.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc1.d/K21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc2.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc2.d/S19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc2.d/S21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc3.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc3.d/S19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc3.d/S21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc4.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc4.d/S19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc4.d/S21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc5.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc5.d/S19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc5.d/S21mysql-ndb -> ../init.d/mysql-ndb
lrwxrwxrwx 1 root root 23 2006-10-04 00:41 /etc/rc6.d/K19mysql-ndb-mgm -> ../init.d/mysql-ndb-mgm
lrwxrwxrwx 1 root root 15 2006-09-21 16:49 /etc/rc6.d/K20mysql -> ../init.d/mysql
lrwxrwxrwx 1 root root 19 2006-10-04 00:41 /etc/rc6.d/K21mysql-ndb -> ../init.d/mysql-ndb
root@1[george]#

I am not sure what it all means
pringle1944

vaya con dias

Found the answers in Mepislovers.
mysql appears to be running.
Thanks for all the help.
George

vaya con dias

Sorry pringle1944, I gave you some (slightly) wrong advice. I was looking on one of my older systems when I showed you the output from /etc/rc*d. I'm not looking on my NEW system and the mysql-ndb and mysql-ndb-mgm are management packages for mysql. Check that you have the mysql init scripts in place too. Perform "ls -lad /etc/init.d/*mysql*" and you should see:

/etc/init.d/mysql
/etc/init.d/mysql-ndb
/etc/init.d/mysql-ndb-mgm

If /etc/init.d/mysql is there, then you just need to create the startup links. As user root do the following:

ln -s ../init.d/mysql /etc/rc0.d/K20mysql
ln -s ../init.d/mysql /etc/rc1.d/K20mysql
ln -s ../init.d/mysql /etc/rc2.d/K20mysql
ln -s ../init.d/mysql /etc/rc3.d/K20mysql
ln -s ../init.d/mysql /etc/rc4.d/K20mysql
ln -s ../init.d/mysql /etc/rc5.d/K20mysql
ln -s ../init.d/mysql /etc/rc6.d/K20mysql
ln -s ../init.d/mysql /etc/rc2.d/S23mysql
ln -s ../init.d/mysql /etc/rc3.d/S23mysql
ln -s ../init.d/mysql /etc/rc4.d/S23mysql
ln -s ../init.d/mysql /etc/rc5.d/S23mysql

(I know there's an easier way to do the above, but I can't remember at the moment

Then, make sure that mysql itself is running (as root):

/etc/init.d/mysql restart

Jon

Thanks Jon
In the meantime I found the following in a mepislovers forum

"In a terminal session, as root from "/etc/init.d"

ln -s /etc/init.d/mysql /etc/rc5.d/S99mysql
ln -s /etc/init.d/mysql /etc/rc0.d/K01mysql

Reboot, then set up MySQL as you normally would. When I do a fresh install, this is the first thing that gets done for MySQL. I always set up my grant permissions, too.

Hope this helps.

Pastor Ron"

The system now responds as you have described
Thanks again
George

vaya con dias

Glad it worked. Let us know how the whole mythtv thing works for you too

Jon

i did get mythtv installed and working on mepis 6.0, using the ubuntu packages.
but it would throw a fault on every reboot and never start.
so, I did the usual thing, i removed it and went back to configuring freevo.