MYSQL
Posts: 158
I have been trying to install mythtv but receive the following error
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
There is no directory /mysqld in /var/run/
Can someone tell me what I have to do to make mythtv work?
pringle1944
MYSQL
Posts: 158
Thanks Dave_L
mysql-server-5.0 is installed
How do I configure it?
I will settle for having mysql work
vaya con dias

Is MySQL Running
Posts: 5513
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
MYSQL
Posts: 158
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
MYSQL SOLVED
Posts: 158
Found the answers in Mepislovers.
mysql appears to be running.
Thanks for all the help.
George
vaya con dias

My Mistake
Posts: 5513
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
MYSQL
Posts: 158
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

Great!
Posts: 5513
Glad it worked. Let us know how the whole mythtv thing works for you too 
Jon

mythtv
Posts: 4864
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.
mysql-server
Posts: 380
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.