Remote mythtv frontend can't connect to backend
I recently set up mythtv on a computer with SUSE 10.0. I have the backend and frontend working on that computer. I installed the mythtv frontend on a Ubuntu 5.04 computer. When trying to run the frontend on the Ubuntu computer, I receive the following messages:
2006-05-27 20:57:29.131 Unable to connect to database!
2006-05-27 20:57:29.132 Driver error was [1/1251]:
QMYSQL3: Unable to connect
Database error was:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
couldn't open db
2006-05-27 20:57:29.132 Switching to square mode (blue)
QSqlDatabaseManager::database: unable to open database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2): QMYSQL3: Unable to connect
2006-05-27 20:57:30.049 Joystick disabled.
mythtv: could not connect to socket
mythtv: No such file or directory
lirc_init failed for mythtv, see preceding messages
2006-05-27 20:57:37.891 User canceled database configuration
couldn't open db
I am then taken to the mythfrontend configuration screen where I can enter the remote host, user, password, etc. All of the information appears to be correct. I checked the local ~/.mythtv/mysql.txt file, and it appeared to have the appropriate values.
I have already upgraded the MySQL client. With it, I successfully issued the following command:
mysql -u mythtv -h 22.214.171.124 -p mythconverg
where 126.96.36.199 is the remote host. I was able to view the tables in the mythconverg database. So it appears that my mysql client can connect to the remote server.
I noticed that one of the error messages states that the program was unable to connect to the local MySQL server. Maybe that is my mistake. I want it to try to connect to the remove MySQL server, not the local (nonexistent) one.
In any case, I am unsure of how to solve my problem. I appreciate any assistance you can give.