[mythtvnz] Problems connecting to database

[James Booth]

Thanks Ross (and Wade). I was still having problems with my remote front end 
and it turned out I had to explicitly grant access permissions for the mythtv 
user from the remote front end address, even though I had been through this in 
the myth setup config. I assume that was my problem on the combined 
frontend/backend as well. I'm now thinking the post-upgrade configuration fell 
over for some reason.

On Sat, 11 Jul 2009 19:26:32 Ross and Jemima Knudsen wrote:
> 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/
>
> _______________________________________________
> 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/