mythbuntu-bugs team mailing list archive

[MarcRandolph <mrand@xxxxxxxxx>]

Howdy, and thank you for helping to improve Mythbuntu by opening this ticket.
First off, is mysql running?  top or ps or System Monitor should help in that regard.

If it is running, there may be a problem (bug) with the upgrade with respect to passwords.
mysql.txt has been depreciated and the config.xml is now the focus.  There is likely one of each in the mythtv users home directory, as well as /etc/mythtv.  Please double check that the information in all copies match.

If there is no problem there, perhaps reset root and myth passwords by:

dpkg-reconfigure mysql-server-5.0

and then setup a db using

dpkg-reconfigure mythtv-database

** Changed in: mythbuntu
   Importance: Undecided => Medium

** Changed in: mythbuntu
       Status: New => Incomplete

-- 
10.04 Upgrade, backend no longer communicating with mysql database
https://bugs.launchpad.net/bugs/579094
You received this bug notification because you are a member of Mythbuntu
Bug Team, which is subscribed to Mythbuntu.

Status in Mythbuntu, Ubuntu derivative focused upon MythTV: Incomplete

Bug description:
After performing the upgrade to 10.04 I no longer was able to access mythtv. whenever I try running setup the results tell me there is no connection to mysql database or upnp. I cant seem to see any posts since the relase just like this.

@htpc:~/.mythtv$ mythbackend
2010-05-11 21:09:31.867 mythbackend version: branches/release-0-23-fixes [24158] www.mythtv.org
2010-05-11 21:09:31.868 Using runtime prefix = /usr
2010-05-11 21:09:31.868 Using configuration directory = /home/shrabok/.mythtv
2010-05-11 21:09:31.868 Empty LocalHostName.
2010-05-11 21:09:31.868 Using localhost value of htpc
2010-05-11 21:09:31.869 Testing network connectivity to '192.168.0.101'
2010-05-11 21:09:31.880 New DB connection, total: 1
2010-05-11 21:09:31.880 Unable to connect to database!
2010-05-11 21:09:31.880 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.101' (111)

2010-05-11 21:09:31.881 MCP::InitUPnP() - HttpServer Create Error
2010-05-11 21:09:31.881 Deleting UPnP client...