[mythtv-users] database connection just stopped working

[Newbury]

Sent from my iPhone

On 2011-10-18, at 14:25, backuppc at sundquist.imapmail.org wrote:

> 
> On Sun, 16 Oct 2011 23:16:23 -0400, backuppc at sundquist.imapmail.org
> said:
>> Hi all.  Used to lurk (and sometimes post) here lots back when first
>> getting set up, but haven't been back for a while because it "just plain
>> worked" (TM) and "if it ain't broke, don't fix it".
>> 
>> After a couple of years, my pcHDTV 5500 died.  Actually, whole system
>> froze up, couldn't figure out anything so did a reinstall and it would
>> freeze up again when scanning for channels with that card.  Took it out
>> and just went with my HDHR and everything worked great.
>> 
>> Decided to do the mythbuntu 10.04 LTS since this was before 11.11 came
>> out anyway, and wanted the long term support.  Installation went really
>> really well (once I took out the pcHDTV).  Was all too easy.
>> 
>> But Thursday night I installed boxee and huludesktop, and something must
>> have happened, which I just noticed tonight (was busy with "real life"
>> over the weekend).
> 
> SNIP
> 
>> 2011-10-14 16:27:04.336 Running mythfilldatabase
>> 2011-10-14 16:27:04.479 Using runtime prefix = /usr
>> 2011-10-14 16:27:04.480 Using configuration directory = /home/mythtv/.mythtv
>> 2011-10-14 16:27:04.480 Unable to read configuration file mysql.txt
>> 2011-10-14 16:27:04.481 Empty LocalHostName.
>> 2011-10-14 16:27:04.481 Using localhost value of mythtv
>> 2011-10-14 16:27:04.522 New DB connection, total: 1
>> 2011-10-14 16:27:04.544 Unable to connect to database!
>> 2011-10-14 16:27:04.545 Driver error was [1/1045]:
>> QMYSQL: Unable to connect
>> Database error was:
>> Access denied for user 'mythtv'@'localhost' (using password: YES)
>> 
>> 
>> I've gone through all the database troubleshoots, and it seems things
>> work fine.  For example:
>> 
>> user at mythtv:~$ mysql -u mythtv -p
>> Enter password: 
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 1035
>> Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
>> 
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>> 
>> mysql> 
>> 
>> Also, it says can't find mysql.txt, but...
>> 
>> user at mythtv:~$ locate mysql.txt
>> /etc/mythtv/mysql.txt
>> /home/user/.mythtv/mysql.txt
>> /home/mythtv/.mythtv/mysql.txt
>> /usr/share/mythtv/mysql.txt.dist
>> user at mythtv:~$ 
>> 
>> and all those files (except the .dist one) are links to the one in /etc:
>> 
>> user at mythtv:~$ for i in `locate mysql.txt`; do file $i; done
>> /etc/mythtv/mysql.txt: ASCII English text
>> /home/user/.mythtv/mysql.txt: symbolic link to `/etc/mythtv/mysql.txt'
>> /home/mythtv/.mythtv/mysql.txt: symbolic link to `/etc/mythtv/mysql.txt'
>> /usr/share/mythtv/mysql.txt.dist: ASCII text
>> user at mythtv:~$
> 
> But the solution was super simple.  I had inadvertently changed the
> ownership of this file (/etc/mythtv/mysql.txt) to be "user", whereas it
> was supposed to be "mythtv".
> 
> Once I changed the ownership back, things worked perfectly.  In fact, it
> started recording a show right away that was in progress and was
> scheduled for recording.
> 

Well! That should remind you not to frix it when it wasn't boken.

G