[mythtv-users] Cannot get the backend to run
Mark Knecht
markknecht at gmail.com
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
>
More information about the mythtv-users
mailing list