|Converting R6 Standalone to MBE - cannot login to database
|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
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?
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|
I couldn't figure out how to restart mysql since /etc/init.d/mysql restart doesn't work on R6.
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:
| 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:
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.
|Page 1 of 1||All times are UTC - 6 hours|
|Powered by phpBB® Forum Software © phpBB Group