[mythtv-users] Two separate Master servers?

Mark Knecht markknecht at gmail.com
Fri May 22 01:51:56 UTC 2009


On Thu, May 21, 2009 at 6:00 PM, Robert Johnston <anaerin at gmail.com> wrote:
> On Thu, May 21, 2009 at 18:48, Mark Knecht <markknecht at gmail.com> wrote:
>> The new server has X on it but it doesn't currently have a Window
>> manager so I cannot run mythtv-setup on that machine directly.
>
> SSH, with X forwarding?
>
> As to your actual question, no there's no way of doing that at the
> moment. I'm sure a little sed hackery could solve the problem for you,
> giving you 2 shell scripts to run to switch (and start) your frontend
> pointed to the "correct" backend.
> --
> Robert "Anaerin" Johnston

Thanks to all for the answers so far.

Yes, I've already put together some scripts for changing which one I
want to talk to. I had hoped that there might be an undocumented
command like option, etc., but it's not to be I suppose.

Since I first posted this is once again looking like one of the harder
problems I have had EVERY time I set up a new server which is getting
mysql functional over the network with the right permissions and
privledges.

OK, now going to my older, currently functional backend I use:

ssh -X -Y -C sector9

and then run

mythtv-setup --geometry 640x480

and because this machine is previously 'set up' I get a nice windowed
version of the setup program and can look at how it's set.

In the case of the newer server which is not 'set up' yet I use

ssh -X -Y -C macmini

and run

mythtv-setup --geometry 640x480

This is what I see:
mark at MacMini ~ $ mythtv-setup --geometry 640x480
2009-05-21 18:43:15.558 Using runtime prefix = /usr
2009-05-21 18:43:15.579 DPMS is active.
2009-05-21 18:43:15.581 Empty LocalHostName.
2009-05-21 18:43:15.582 Using localhost value of MacMini
2009-05-21 18:43:15.583 Testing network connectivity to 192.168.1.61
2009-05-21 18:43:15.615 New DB connection, total: 1
2009-05-21 18:43:15.622 Unable to connect to database!
2009-05-21 18:43:15.623 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'MacMini' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-05-21 18:43:15.676 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...

2009-05-21 18:43:16.320 UPnPautoconf() - Found one UPnP backend
2009-05-21 18:43:16.360 MythXMLClient::GetConnectionInfo Failed -
(604) No Security Pin assigned. Run mythtv-setup to set one.
2009-05-21 18:43:16.501 Primary screen 0.
2009-05-21 18:43:16.502 Using screen 0, 1280x1024 at 0,0
2009-05-21 18:43:16.503 No theme dir: /home/mark/.mythtv/themes/blue
2009-05-21 18:43:16.505 Switching to square mode (blue)
2009-05-21 18:43:16.575 Using the Qt painter
2009-05-21 18:43:16.576 JoystickMenuClient Error: Joystick disabled -
Failed to read /home/mark/.mythtv/joystickmenurc
Illegal instruction
mark at MacMini ~ $

So, the first problem seems to be no access to the database. However
the server is running and I can get to it from the command line:

mark at MacMini ~ $ mysql -p -u mythtv mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.70-log Gentoo Linux mysql-5.0.70-r1

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mythconverg        |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> exit;
Bye
mark at MacMini ~ $

However if I look in mythbackend.log it seem that the program isn't
being allowed in:

 2009-05-21 17:54:57.009 Using runtime prefix = /usr
2009-05-21 17:54:57.018 Unable to read configuration file mysql.txt
2009-05-21 17:54:57.019 Empty LocalHostName.
2009-05-21 17:54:57.020 Using localhost value of MacMini
2009-05-21 17:54:57.038 New DB connection, total: 1
2009-05-21 17:54:57.046 Connected to database 'mythconverg' at host: localhost
2009-05-21 17:54:57.091 Closing DB connection named 'DBManager0'
2009-05-21 17:54:57.093 Connected to database 'mythconverg' at host: localhost
2009-05-21 17:54:57.105 New DB connection, total: 2
2009-05-21 17:54:57.107 Connected to database 'mythconverg' at host: localhost
2009-05-21 17:54:57.114 Current Schema Version: 1214
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.

It looks like it's complaining about localhost but I can get to it
that way also:

mark at MacMini ~ $ mysql -p -u mythtv -h localhost mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.70-log Gentoo Linux mysql-5.0.70-r1

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit;

But it doesn't like it by name:

mark at MacMini ~ $ mysql -p -u mythtv -h MacMini mythconverg
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'MacMini' (using
password: YES)
mark at MacMini ~ $


I actually took the 'no security' option when I chose how to tell
mysel to act but it's not working for me.

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

Sort of lost at this point, once again. This is the 4th server I've
set up over the last 3-4 years. EVERY time I've tried this I have
similar problems.

Sorry.

- Mark


More information about the mythtv-users mailing list