LinHES Forums
http://forums.linhes.org/

Converting R6 Standalone to MBE - cannot login to database
http://forums.linhes.org/viewtopic.php?f=1&t=20811
Page 1 of 1

Author:  jmhunt [ Sat Jan 30, 2010 7:11 pm ]
Post subject:  Converting R6 Standalone to MBE - cannot login to database

I upgraded from R5.5 to R6 and mistakenly choose Standalone instead of MBE. I am now trying to remedy that to restore peace in our house as my wife can no longer watch her shows from her computer.

I have (actually it has been this way for a while) configured the IP address to be 192.168.1.4 and set a security PIN.

When I try connecting from a remote frontend, it finds the backend, prompts me for the security pin, which I enter, then offers to save the databbase or backend settings (or not). Whatever I try I get the error

Code:
Cannot login to database?


I suspect it is something in the mysql setup, but under R6 I'm not sure where to find it since /etc/mysql doesn't exist.

What do I need to do to fix this and restore harmony in the home?

Thanks,
Jon

p.s. I'm loving the peformance and stability of R6 (LinHES) on my main machine/TV. I can once again watch live HD TV and HD recordings reliably.

Author:  jmhunt [ Sat Jan 30, 2010 8:12 pm ]
Post subject:  Found my.cnf in /etc

I commented out the skip-networking line in the /etc/my.cnf file and rebooted, since I couldn't figure out how to restart mysql since /etc/init.d/mysql restart doesn't work on R6.

Author:  manicmike [ Sun Jan 31, 2010 4:35 am ]
Post subject:  Re: Found my.cnf in /etc

jmhunt wrote:
I couldn't figure out how to restart mysql since /etc/init.d/mysql restart doesn't work on R6.


As root:

Code:
sv restart mysql


Regarding the problem, I added a remote frontend later on. What you need to do is to enable login as mysql user remotely. At the moment the entry (first few columns anyway) in the DB mysql -> user for mysql is:
Quote:
| localhost | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC


Now, what you should do here is to change localhost here to your FE host (either IP or hostname in /etc/hosts or nameserver). If this fails you can use '%' as the hostname (a wild card), thusly:

Code:
echo 'UPDATE user SET Host="%" WHERE Host="localhost" and User="mysql"'|mysql -u root mysql


Test the connection on the FE machine by manually attempting to connect to the BE's mythconverg db via the mysql client.

Mike

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/