[mythtv-users] MythArchive: Separate front-/back-end "Can't connect to local MySQL server through socket"

[Jon Whitear]

Hello list,

I'm running 0.21-fixes on a separate frontend/backend setup. I'm  
trying to run MythArchive on the frontend. When I kick a job off, I  
get an error along the lines of "Failed to run mytharchivehelper to  
get mysql database parameters! Exit code: 127" and mythburn.log shows  
this:-

mythtv at fe1 /var/tmp/logs $ cat mythburn.log
Using simple_fix_rtl
mythburn.py (0.1.20080726-1-fixes) starting up...
script path:/usr/local/share/mythtv/mytharchive/scripts
myth share path:/usr/local/share/mythtv
passed job file: /var/tmp/config/mydata.xml
passed progress log file: /var/tmp/logs/progress.log
mythburn.py (0.1.20080726-1-fixes) starting up...
Failed to run mytharchivehelper to get mysql database parameters! Exit  
code: 127
Traceback (most recent call last):
   File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",  
line 5458, in ?
     main()
   File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",  
line 5318, in main
     saveSetting("MythArchiveLastRunStart", time.strftime("%Y-%m-%d %H: 
%M:%S "))
   File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",  
line 871, in saveSetting
     db = getDatabaseConnection()
   File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",  
line 352, in getDatabaseConnection
     return MySQLdb.connect(host=mysql_host, user=mysql_user,  
passwd=mysql_passwd, db=mysql_db)
   File "/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py", line  
74, in Connect
     return Connection(*args, **kwargs)
   File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py",  
line 170, in __init__
     super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local  
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)")

So it looks like it's trying to connect to a local MySQL server, when  
it should be connecting to the backend. However, mytharchivehelper  
shows this:-

mythtv at fe1 /var/tmp/logs $ mytharchivehelper -p out
mythtv at fe1 /var/tmp/logs $ cat out
192.168.1.100
mythtv
mythtv
mythconverg
fe1
/usr/local

and I have a ~/.mythtv/mysql.txt with the appropriate values.

I understand that separate front- and backends aren't supported in  
MythArchive, but does anybody have this working? If so, any tips on  
how to get around this problem?

Cheers,

Jon