[mythtvnz] Problems connecting to database

[Ross and Jemima Knudsen]

Hi James,

I have been doing a few reinstalls lately and have trouble with mysql 
connections from time to time.  If your remote frontends are not able to 
access the backend you could try doing a port scan from one of those 
machines to see if the mysql service is available.  On Ubuntu there is a 
network tools utility in System > Administration > Network tools.  Use 
the port scan screen and enter the IP address.  It should find an open 
port (I think 3306) which it recognises as the mysql service.  If this 
isn't available you'll need to edit your /etc/mysql/my.conf file on the 
backend.  Make sure the bind-address setting is commented out to make 
the service available on all network adapters.

If the service is available you could try using phpmyadmin from a remote 
machine and try logging in with the mythtv credentials.  Problems I 
seemed to have related to the myth-user permissions not allowing access 
from remote locations.  You can fix this from phpmyadmin.  I found 
deleting the user (don't remove the database by accident!) and 
re-entering them fixed my problems.

Ross

james at booths.net.nz wrote:
> After much frustration I ended up manually resetting the MySQL admin  
> password and mythtv user name and password, and everything else I  
> could think of, rerunning all the myth configs, and now it works (at  
> least my combined unit does). Never had any problems with this before,  
> though I also upgraded MySQL at the same time as MythTV - is this  
> something that tends to happen when upgrading MySQL? Any comments  
> welcome, as I am really not sure what went wrong, just fixed it  
> through blind hacking.
>
> ----- Forwarded message from james at booths.net.nz -----
>      Date: Sat, 11 Jul 2009 12:48:47 +1200
>      From: james at booths.net.nz
> Reply-To: james at booths.net.nz
>   Subject: Problems connecting to database
>        To: MythTV in NZ <mythtvnz at lists.linuxnut.co.nz>
>
> I run a combined frontend/backend and a remote frontend as well. I
> have upgraded to JYA's latest release for MythTV, and now my frontends
> cannot connect to the MySQL database. All connection settings seem
> correct, mysqld is running, backend is running, etc - I can't see
> anything obviously wrong, but it jut will not connect. Can anyone make
> some suggestions on what else I could check? Below is the output when
> running mythfrontend -v all
>
>
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>