← Back to team overview

mythbuntu-bugs team mailing list archive

[Bug 579094] Re: 10.04 Upgrade, backend no longer communicating with mysql database

 

I re-read your requests, and yes mysql is NOT running.

@htpc:/etc/mythtv$ mysqladmin -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
@htpc:/etc/mythtv$ ls /var/run/mysqld/
@htpc:/etc/mythtv$ ls
config.xml  mysql.txt  mythweb-canned_searches.conf.php  mythweb-config.php  session-settings
@htpc:/etc/mythtv$ /etc/init
@htpc:/etc/mythtv$ /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql status

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status(8) utility, e.g. status mysql
mysql respawn/post-start, (post-start) process 833
@htpc:/etc/mythtv$ status mysql
mysql respawn/post-start, (post-start) process 833
@htpc:/etc/mythtv$ service mysql status
mysql respawn/post-start, (post-start) process 833
@htpc:/etc/mythtv$
@htpc:/etc/mythtv$ /etc/init.d/mysql
Usage: /etc/init.d/mysql COMMAND
@htpc:/etc/mythtv$ /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
@htpc:/etc/mythtv$ start mysql
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.70" (uid=1000 pid=24805 comm="start) interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init"))
@htpc:/etc/mythtv$ ls /var/run/mysqld/

-- 
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...





References