View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 7 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat Sep 25, 2004 6:43 am 
Offline
Joined: Sat Apr 17, 2004 9:28 am
Posts: 56
Location: St. Louis, Missouri
After apt-get iinstall I get the following messages in my backend log when trying to restart the backend


Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)

Couldn't open database


As far as I can tell the password in mysql.txt and in the mysql permissions tables are both mythtv.

I have removed the debs and reinstalled them and still get the same error. I have not run mythtv-setup......

Any ideas or help would be appreciated

Thanks in advance for you help


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 8:43 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
This came up with the R4V4 upgrades too. You may need to either fix the password on the DB or the scripts. Which one you pick depends on which seems like the way that'll cause you the least grief in the long run. Search the forum for details...

OBTW - What are you upgrading from? I didn't have any issues with an upgrade from an R4V4 base system which had previously been upgraded with 0.15.1 debs. Of course I may have fixed a DB password issue at the time of that original upgrade and forgotten it....


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 9:26 am 
Offline
Joined: Sat Apr 17, 2004 9:28 am
Posts: 56
Location: St. Louis, Missouri
Same as you. R4V4 w/ 15.1....

I thought I had all my passwords synched to 'mythtv'

Using Webmin I changed the mythtv user password to mythtv (I say changed because it is encrypted so I set it again to mythtv)

Using vim I checked that the password in mysql.txt was set to mythtv

Are there any other places I should check?

Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 10:02 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
I don't remember, that's why I suggested a search...


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 10:06 am 
Offline
Joined: Fri Dec 26, 2003 2:25 pm
Posts: 244
I just asked this question last night. A solution is posted in that thread.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 11:26 am 
Offline
Joined: Sat Apr 17, 2004 9:28 am
Posts: 56
Location: St. Louis, Missouri
tjc wrote:
I don't remember, that's why I suggested a search...


I forgot to mention that I searched prior to posting. I have not had any success with my searches. I'll keep looking. Thanks for trying.

Dinki wrote:
I just asked this question last night. A solution is posted in that thread.


My problem is not the same. Yours appears to deal with running mythtv-setup twice and having to back some of the changes out of the database and trying again. I don't see anything having to do with database access denied errors. Unless you have a different post that I didn't see. Thanks for the idea

I am sure this is primarily a password synchronization issue...


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 12:18 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Search for "mysql password mythtv" and requiring all terms should come up with ~29 articles. You want ones from back around May/June when R4V4 came out and was followed up by R4V4.1, there are a number of them that appear relevant including this one: http://mysettopbox.tv/phpBB2/viewtopic.php?t=1554

Other than that I'd suggest a similar search over on the myth users mailing list at: http://www.gossamer-threads.com/lists/mythtv/users/ The answer from there seems to be that these are the two relevant places.

Further research may turn up the need to "grant" access or something if fixing the password in the database and the mysql.txt file doesn't solve your problem.

You may also want to restart the servers to make sure that they don't have bad values cached.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: Bing [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu