Master Backend Server?

[mwacky]

Upgraded from Feisty to Gusty, then added Mythbuntu by launching from website.

Capture Card (lspci):

00:11.0 Multimedia video controller: Brooktree Corporation Bt878 Video Capture (rev 02)
00:11.1 Multimedia controller: Brooktree Corporation Bt878 Audio Capture (rev 02)

Had tried MythTV before but have always received this error when trying to watch tv:

Could not connect to the master backend server -- is it running? Is the IP address set for it in the setup program correct?

Seems like I have everything set in the Backend and Frontend Setup properly, looks good from the Mythbuntu Control Centre.

Has decent video for an older card, but has no sound with TV Time which I believe is related to Launchpad Bug #29789. The sound problem shouldn't stop mythtv from running or have a problem with the backend server, right?

[superm1]

Originally Posted by mwacky Upgraded from Feisty to Gusty, then added Mythbuntu by launching from website. Capture Card (lspci): 00:11.0 Multimedia video controller: Brooktree Corporation Bt878 Video Capture (rev 02) 00:11.1 Multimedia controller: Brooktree Corporation Bt878 Audio Capture (rev 02) Had tried MythTV before but have always received this error when trying to watch tv: Seems like I have everything set in the Backend and Frontend Setup properly, looks good from the Mythbuntu Control Centre. Has decent video for an older card, but has no sound with TV Time which I believe is related to Launchpad Bug #29789. The sound problem shouldn't stop mythtv from running or have a problem with the backend server, right?

First:
Checkout /var/log/mythtv/mythbackend.log. Check for any errors with permissions or startup.

Next:
Also check and make sure you don't have a ~/.mythtv/mysql.txt. Make sure you don't have a /home/mythtv/.mythtv/mysql.txt too. If you have either, get rid of it.

Lastly:
Configure the backend by going into mythbuntu control centre, and choosing the mythtv-setup button.

[mwacky]

First: Checkout /var/log/mythtv/mythbackend.log. Check for any errors with permissions or startup.

Nothing in the log

Next: Also check and make sure you don't have a ~/.mythtv/mysql.txt. Make sure you don't have a /home/mythtv/.mythtv/mysql.txt too. If you have either, get rid of it.

mwacker@Barney:~$ ls /home/mwacker/.mythtv/
channels  mysql.txt  themecache
mwacker@Barney:~$ sudo rm /home/mwacker/.mythtv/mysql.txt

Lastly: Configure the backend by going into mythbuntu control centre, and choosing the mythtv-setup button.

After running MythTv Setup from Control Center it became stuck on Configuring Automatic Login and attempt to send a bug report, but failed doing that.

Then ran updates and received this message:

MythTV-Database reconfigure required

The mythtv-database package was upgraded or installed, but was unable to contact a MySQL server.
If you were in the process of dist-upgrading, this is normal as mysql-server is stopped for a portion of the upgrade.
If this is a fresh package installation, verify that mysql-server is installed and running.  Once you have verified the server is running, you can reconfigure the package by running 'sudo dpkg-reconfigure mythtv-database'.
If your root password or location of the MySQL server are non standard, you can also update them via 'sudo dpkg-reconfigure mythtv-database'.

Will restart and see if the setup works and make sure mysql is running.

[palmnut]

Originally Posted by superm1 Next: Also check and make sure you don't have a ~/.mythtv/mysql.txt. Make sure you don't have a /home/mythtv/.mythtv/mysql.txt too. If you have either, get rid of it.

If you're running Myth split between two machines, would you do this on the backend, frontend or both machines?

I'm running the backend on one laptop and am trying to run the front end on another over the network; alas I'm having troubel accessing both the MySQL DB reliably (sometimes it opens, mosttimes it fails) and the backend server at all. The irony is that I can get it to work perfectly if I access it from Windoze using MyTV Player on the wife's machine. This is annoying, so I'm clutching at straws.

[superm1]

Originally Posted by palmnut If you're running Myth split between two machines, would you do this on the backend, frontend or both machines? I'm running the backend on one laptop and am trying to run the front end on another over the network; alas I'm having troubel accessing both the MySQL DB reliably (sometimes it opens, mosttimes it fails) and the backend server at all. The irony is that I can get it to work perfectly if I access it from Windoze using MyTV Player on the wife's machine. This is annoying, so I'm clutching at straws.

You shouldn't have ~/.mythtv/mysql.txt or /home/mythtv/.mythtv/mysql.txt on *any* machines.

On the frontend, you will have to call
dpkg-reconfigure mythtv-common to update the systemwide mysql.txt

[rothgar]

I sorta have the same issue.

my frontend/backend connects just fine when all the IP addresses are set to 127.0.0.1. I can go into mythtv-setup and change the IP address of the backend to 192.168.2.20 (the IP of my machine) and everything works fine. But when I go to the frontend -> setup -> general and change the IP there to 192.168.2.20 I cannot connect. I commented out bind-address in /et/mysql/my.cnf and I set the mysql permissions to allow all IP addresses

$ mysql -u root mythconverg mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv"; mysql> flush privileges;

and I deleted the mysql.txt file. I still cannot connect if I try to connect to 192.168.2.20. Anything else I am supposed to do? If I delete the mysql.txt file does the mythtv password change?

[arrhn]

If you still have problems connecting but all the user-password combinations seem to work when you try them by hand, search in /var for an old mysql.txt and delete it. I found one in /var/lib/mythtv/.mythtv that was being read by mythtv-backend instead of the intended one in /etc/mythtv.

[mwacky]

Will restart and see if the setup works and make sure mysql is running.

Well still receiving the same error but looked at the latest log:

2007-10-07 18:11:59.783 Using runtime prefix = /usr
2007-10-07 18:11:59.933 New DB connection, total: 1
2007-10-07 18:11:59.956 Unable to connect to database!
2007-10-07 18:11:59.957 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-10-07 18:12:00.020 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-10-07 18:12:00.075 Failed to init MythContext, exiting.
2007-10-08 19:13:06.075 Using runtime prefix = /usr
2007-10-08 19:13:06.409 New DB connection, total: 1
2007-10-08 19:13:06.436 Unable to connect to database!
2007-10-08 19:13:06.438 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-10-08 19:13:06.500 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-10-08 19:13:06.568 Failed to init MythContext, exiting.

I can look at MySql with Webmin and see the mythtv user, tried giving user full permissions.

[superm1]

Originally Posted by mwacky Well still receiving the same error but looked at the latest log: 2007-10-07 18:11:59.783 Using runtime prefix = /usr 2007-10-07 18:11:59.933 New DB connection, total: 1 2007-10-07 18:11:59.956 Unable to connect to database! 2007-10-07 18:11:59.957 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access denied for user 'mythtv'@'localhost' (using password: YES) QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2007-10-07 18:12:00.020 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2007-10-07 18:12:00.075 Failed to init MythContext, exiting. 2007-10-08 19:13:06.075 Using runtime prefix = /usr 2007-10-08 19:13:06.409 New DB connection, total: 1 2007-10-08 19:13:06.436 Unable to connect to database! 2007-10-08 19:13:06.438 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access denied for user 'mythtv'@'localhost' (using password: YES) QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2007-10-08 19:13:06.500 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2007-10-08 19:13:06.568 Failed to init MythContext, exiting. I can look at MySql with Webmin and see the mythtv user, tried giving user full permissions.

Did you follow what I said and rm ~/.mythtv/mysql.txt?

As long as you don't touch the mythtv password, it is all read from /etc/mythtv/mysql.txt

[mwacky]

Originally Posted by superm1 Did you follow what I said and rm ~/.mythtv/mysql.txt? As long as you don't touch the mythtv password, it is all read from /etc/mythtv/mysql.txt

Yes, after I delete mysql.txt MythTV frontend sends me through the setup again. If I do not change to the proper password, I am just sent through the setup again and again. But if I do change the password for the mythtv user, I get the same IP error for the backend server and mysql.txt is created again. Unfortunately I have altered the mythtv password. How can I reset the mythtv user password without having setup create mysql.txt?

Thanks!