[mythtv-users] Problem with Ubuntu upgrade

[Damian]

  On 19/10/2010 23:36, Damian wrote:
>  On 19/10/2010 13:07, Damian wrote:
>>  On 18/10/2010 23:48, Damian wrote:
>>>  PS
>>>
>>> I've just noticed that my SqueezeBoxes (SliMP3 and Squeeze box 2) 
>>> are not connecting to the Squeeze Centre backend/database either.
>>>
>>> Not sure what's going on or how to go about fixing it :-(
>>>
>>> Damian
>>
>> PPS
>>
>> I'm thinking that the problem may be to do with Apache2. Is seems to 
>> be running, but none of the 'tests' 
>> (http://yourserveripaddress/testphp.php, 
>> http://localhost/testphp.php, http://yourserverip/apache2-default/) 
>> are giving me the feedback I'd hope for.
>>
>> I'm really at the limit of my knowledge now. Does this help to debug 
>> anything?
>>
>> Damian
>
> Just tried this check for Apache ...
>
> To check the status of your PHP installation:
>
>  $ gksudo "gedit /var/www/testphp.php"
>
> and insert the following line
>
> <?php phpinfo(); ?>
>
> View this page on a web browser at 
> http://yourserveripaddress/testphp.php or http://localhost/testphp.php
>
> And it seemed to work fine.
>
> Ahh, what's going on??
>
> D

Here's the latest entry in my Myth Backend log:

................................................................................
2010-10-20 00:01:03.493 UPnPautoconf() - No UPnP backends found
2010-10-20 00:01:03.496 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
[console is not interactive, using default 'no']
2010-10-20 00:01:03.607 Deleting UPnP client...
2010-10-20 00:01:04.298 Failed to init MythContext, exiting.
2010-10-20 00:01:05.058 mythbackend version: branches/release-0-23-fixes 
[26437] www.mythtv.org
2010-10-20 00:01:05.060 Using runtime prefix = /usr
2010-10-20 00:01:05.087 Using configuration directory = /home/mythtv/.mythtv
2010-10-20 00:01:05.107 Empty LocalHostName.
2010-10-20 00:01:05.127 Using localhost value of MythBox
2010-10-20 00:01:05.162 New DB connection, total: 1
2010-10-20 00:01:05.169 Unable to connect to database!
2010-10-20 00:01:05.176 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'MythBox' (using password: YES)


The Squeezebox server (music system) log looks like this:

[10-10-20 00:04:21.3041] Slim::Schema::init (129) Error: Couldn't 
connect to database! Fatal error: [] Exiting!
[10-10-20 00:04:21.3044] Slim::Schema::init (129) Backtrace:

    frame 0: Slim::Utils::Log::logBacktrace 
(/usr/share/perl5/Slim/Schema.pm line 129)
    frame 1: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm 
line 744)
    frame 2: Slim::Music::Import::_checkLibraryStatus 
(/usr/share/perl5/Slim/Music/Import.pm line 677)
    frame 3: Slim::Music::Import::useImporter 
(/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 48)
    frame 4: Slim::Music::MusicFolderScan::init 
(/usr/sbin/squeezeboxserver line 435)
    frame 5: main::init (/usr/sbin/squeezeboxserver line 578)
    frame 6: main::main (/usr/sbin/squeezeboxserver line 1072)

[10-10-20 00:04:21.3048] Slim::Schema::forceCommit (1622) Warning: 
Trying to commit transactions before DB is initialized!
2010-10-20 00:04:21 Squeezebox Server died. Restarting.
[10-10-20 00:04:22.3100] main::init (323) Starting Squeezebox Server 
(v7.5.1, r30836, Tue Jun  1 05:57:28 PDT 2010) perl 5.010001


I can log into phpmyadmin as root and also as mythtv using the relevant 
passwords.

Does this help at all?
D