View previous topic :: View next topic |
Author |
Message |
Brain Fury Guru
Joined: 10 Jul 2003 Posts: 357 Location: Düsseldorf (Germany)
|
Posted: Sun Jan 16, 2005 10:43 pm Post subject: mythtv doesn't work |
|
|
I have just emerged mythtv and wanted to start it
I did things acording to the documentation: Code: | USE="mysql" emerge mythtv
mysql_install_db |
That is how far it worked.
The next step seemed to me to be optional, so I wasn't worried when it didn't work: Code: | # mysql < /usr/share/mythtv/database/mc.sql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
The Documentation tells something about cd setup and ./setup to set mythtv up. I can't find a directory called setup in /usr/share/mythtv so I assume that mythsetup is the one meant by the documentation. So I did "mythsetup" and got: Code: | Unable to connect to database!
Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
I think it has something to do with mysql, but I have never ever before done anything with mysql so i am a total mysql-noob. Can anyone help me here? _________________ shift HAPPENS |
|
Back to top |
|
|
rowbin hod n00b
Joined: 08 Jan 2005 Posts: 50
|
Posted: Sun Jan 16, 2005 10:48 pm Post subject: |
|
|
It's a mysql problem. have you checked that the mysql server is actually running? IIRC it's started by running mysqld_safe (should be in your path). |
|
Back to top |
|
|
Brain Fury Guru
Joined: 10 Jul 2003 Posts: 357 Location: Düsseldorf (Germany)
|
Posted: Sun Jan 16, 2005 11:10 pm Post subject: |
|
|
okay, that worked. Next problem: Code: | $ mythsetup
Unable to connect to database!
Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)
Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES) |
_________________ shift HAPPENS |
|
Back to top |
|
|
Xamindar Veteran
Joined: 03 Oct 2004 Posts: 1155 Location: California
|
Posted: Sat Feb 19, 2005 8:31 am Post subject: |
|
|
I get the same problem, and so are a lot of other people. There must be a simple command to fix this but the documentation doesn't explain it at all. |
|
Back to top |
|
|
ewie n00b
Joined: 23 Mar 2004 Posts: 27 Location: Delft, Holland
|
Posted: Mon Feb 21, 2005 10:40 am Post subject: |
|
|
Xamindar wrote: | I get the same problem, and so are a lot of other people. There must be a simple command to fix this but the documentation doesn't explain it at all. |
You should create a mysql user and create a password for the user. You can do this with a front-end such as phpmyadmin. You should allow this user to get full control on the mythconverg database. This user and password you should enter in the mythtv configuration file (/etc/mythtv/mythtv.txt if i remember correcttly).
If you really dont't want to do this, use root with a blank password. Enter these in /etc/mythtv/mythtv.txt. It's the default mysql user. But be careful with such lazyness... |
|
Back to top |
|
|
wbrokow1 Guru
Joined: 03 Jan 2005 Posts: 372
|
Posted: Fri Feb 25, 2005 1:31 am Post subject: |
|
|
Yes, I have that problem too.
It seems if you connect to the mysql database manually:
mysql -u root -h 192.168.0.6 mythconverg
you get the errors access denied , 1045 etc. But it you leave out the host (-h ) name
you can get in!
Although if you put the proper settings in during mythsetup and try to leave the host name out you still get the "can't connect to database" error.
There has to be a fix. Is the problem with the way mythtv transfers to login info to mysql...It seems that way.
Is there a certain build of mysql we all should be using? Should we go back to 0.16 ?
Can anyone share their errors?
Try to duplicate my error. Login manually with and without the -h in the name and see if you can get in.
THanks |
|
Back to top |
|
|
|