LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mythtv/Database Problem (https://www.linuxquestions.org/questions/linux-software-2/mythtv-database-problem-524202/)

snares 01-30-2007 06:02 PM

Mythtv/Database Problem
 
Trying to build a Linux Media Center instead of going to Windows. Downloaded and installed mythtv through Adept(Linux Distro:Kubuntu 6.1 Edgy). I believe there is a problem with the database. Perhaps a MySql package? Not sure though. Relative noob. I tried reinstalling mythtv-database in Synaptic and get this message:

E: mythtv-database: subprocess post-installation script returned error exit status 1
E: mythtv: dependency problems - leaving unconfigured

Adept won't let me reinstall. This is the result from running mythv-setup in the terminal:

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-01-30 17:59:40.503 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-01-30 17:59:40.559 Database not open while trying to save setting: Language
2007-01-30 17:59:40.559 Unable to connect to database!
2007-01-30 17:59:40.559 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-01-30 17:59:40.615 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-01-30 17:59:41.443 User canceled database configuration
2007-01-30 17:59:41.445 Failed to init MythContext, exiting.

This seems to be a pretty common problem but I haven't been able to find a solution yet. Thank you for your help.

pljvaldez 01-30-2007 06:12 PM

It seems like you forgot to add the mythtv user to the mysql database.

snares 01-30-2007 06:33 PM

I saw that as an answer to this problem but I'm not sure how to go abotu doing this. Can you give me a howto or direct me to one?

pljvaldez 01-31-2007 11:56 AM

Try mysql -u root mysql from a command line. It should give you a mysql> prompt. Then do
Code:

UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
FLUSH PRIVILEGES;
quit



All times are GMT -5. The time now is 10:14 AM.