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/ |