[mythtv-users] Cannot get the backend to run

Fri May 22 21:57:55 UTC 2009

On Fri, May 22, 2009 at 2:25 PM, Greg Woods <greg at gregandeva.net> wrote:
> On Fri, 2009-05-22 at 12:44 -0700, Mark Knecht wrote:
>
>> I'm not actually trying to run the frontend. Right now the frontend
>> will NOT work because mythtvbackend itself isn't running.
>
> The error message you quoted clearly states that it cannot find the
> mysql.txt file. So that's a problem even if the privileges in MySQL are
> set correctly.

Humm...OK. You are correct about that, but on the new server it's
there in these accounts: mark, mythtv and root. The contents look like
this:

MacMini ~ # cat .mythtv/mysql.txt
DBHostName=192.168.1.61
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3
MacMini ~ #

The IP Address above is correct for the new server.

>
> The backend may be running as root, in which case you may need the
> mysql.txt file in root's directory rather than mythtv's. I have been
> burned by this.

Again, I'm confused by the comment 'The backend may be running as
root'. My problem right now is the backend won't run at all:

MacMini ~ # ps aux | grep myth
root     22873  0.0  0.1   2060   580 pts/3    R+   14:49   0:00 grep
--colour=auto myth
MacMini ~ #

MacMini ~ # /etc/init.d/mythbackend status
 * Caching service dependencies ...                                       [ ok ]
 * status:  stopped
MacMini ~ # /etc/init.d/mythbackend start
 * Starting MythTV Backend ...                                            [ ok ]
MacMini ~ # /etc/init.d/mythbackend status
 * status:  stopped
MacMini ~ #

So it didn't start. When I look at the backend log file I get back to
the cannot find the mysql.txt file and I've gone around the circle one
more time:

2009-05-22 14:50:28.147 Using runtime prefix = /usr
2009-05-22 14:50:28.252 Unable to read configuration file mysql.txt
2009-05-22 14:50:28.253 Empty LocalHostName.
2009-05-22 14:50:28.254 Using localhost value of MacMini
2009-05-22 14:50:28.272 New DB connection, total: 1
2009-05-22 14:50:28.290 Connected to database 'mythconverg' at host: localhost
2009-05-22 14:50:28.292 Closing DB connection named 'DBManager0'
2009-05-22 14:50:28.294 Connected to database 'mythconverg' at host: localhost
2009-05-22 14:50:28.312 New DB connection, total: 2
2009-05-22 14:50:28.315 Connected to database 'mythconverg' at host: localhost
2009-05-22 14:50:28.322 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.
MacMini ~ #

I *think* that the important part is the last two lines:

No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.

When I try and run mythtv-setup then I get the message about not being
able to access the database:

MacMini ~ # mythtv-setup
2009-05-22 14:53:27.249 Using runtime prefix = /usr
2009-05-22 14:53:27.292 DPMS is active.
2009-05-22 14:53:27.294 Empty LocalHostName.
2009-05-22 14:53:27.294 Using localhost value of MacMini
2009-05-22 14:53:27.295 Testing network connectivity to 192.168.1.61
2009-05-22 14:53:27.362 New DB connection, total: 1
2009-05-22 14:53:27.391 Unable to connect to database!
2009-05-22 14:53:27.391 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-22 14:53:27.445 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...

2009-05-22 14:53:28.048 UPnPautoconf() - Found one UPnP backend
2009-05-22 14:53:28.091 MythXMLClient::GetConnectionInfo Failed -
(604) No Security Pin assigned. Run mythtv-setup to set one.

Most importantly, I think:

Database error was:
Access denied for user 'mythtv'@'MacMini' (using password: YES)

Which seems to be this:

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

but mysql is running and allows me to access the database if I drop the -h

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

>
> Try running mythbackend under strace to see what files it's actually
> trying to open. Something like:
>
> # strace -o /tmp/mythbackend.trace mythbackend [args]

strace is not currently on the machine and I have an emerge running.
I'll add it later when I can.

>
> Then look for open calls in the trace file or grep for mysql.txt
>
> --Greg
>

Thanks!

- Mark

>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>