LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 05-27-2006, 08:30 PM   #1
raytheyounger
LQ Newbie
 
Registered: Jul 2005
Distribution: SUSE 10.2
Posts: 4

Rep: Reputation: 0
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 194.168.1.4 -p mythconverg
where 194.168.1.4 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.
 
Old 05-27-2006, 08:36 PM   #2
sasho
Member
 
Registered: Jan 2005
Distribution: Arch
Posts: 120

Rep: Reputation: 17
Code:
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
Sounds like your remote mythfrontend has an older mysql library.

Here are helpful hints (it worked for me):
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Go for the OLD_PASSWORD trick.
 
Old 05-27-2006, 09:09 PM   #3
raytheyounger
LQ Newbie
 
Registered: Jul 2005
Distribution: SUSE 10.2
Posts: 4

Original Poster
Rep: Reputation: 0
That did the trick sasho. I appreciate it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MythTV Backend Jongi Suse/Novell 3 04-23-2006 08:42 PM
mythtv frontend can't play recorded shows from main computer LiquidSlumber Linux - Software 2 02-11-2006 11:25 PM
MythTV backend Server Problems on LM10 and saa7134 mindmeddler2003 Linux - Software 0 09-13-2004 05:35 PM
Mythtv backend server doesn't capture sound ranjo Linux - Software 2 08-26-2004 05:18 AM
Backend -Frontend Interaction unbeknown Linux - Software 1 07-29-2003 03:33 PM


All times are GMT -5. The time now is 01:30 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration