LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-30-2007, 06:02 PM   #1
snares
Member
 
Registered: Mar 2006
Distribution: Ubuntu Gusty Gibbon
Posts: 108

Rep: Reputation: 16
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.
 
Old 01-30-2007, 06:12 PM   #2
pljvaldez
LQ Guru
 
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094

Rep: Reputation: 273Reputation: 273Reputation: 273
It seems like you forgot to add the mythtv user to the mysql database.
 
Old 01-30-2007, 06:33 PM   #3
snares
Member
 
Registered: Mar 2006
Distribution: Ubuntu Gusty Gibbon
Posts: 108

Original Poster
Rep: Reputation: 16
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?
 
Old 01-31-2007, 11:56 AM   #4
pljvaldez
LQ Guru
 
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094

Rep: Reputation: 273Reputation: 273Reputation: 273
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
yum install mythtv-suite, Mythtv, nothing found, atrpms THOR_Fedora Linux - Software 5 11-29-2006 03:13 PM
mythtv mysql database setup help carmat06 Debian 3 09-27-2005 05:41 PM
Set up Database for Mythtv SHERB142 Fedora 2 06-08-2005 07:40 PM
MythTV and MySQL database on same Computer linux-rulz Linux - Software 4 05-19-2005 06:15 PM
mythtv database errors tgkspike Linux - Software 1 06-08-2004 03:55 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:22 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration