[mythtv-users] Frontend connection problem

[Nick Morrott]

On 21/06/2008, The GUIGuy <linux at finalfiler.com> wrote:
> Nick Morrott wrote:
>  >
>  > LocalHostName is configured by a user if  they do not want to use
>  > their machine's hostname to store settings against in the database.
>  > This is used in situations where your 'real' hostname changes
>  > regularly - mythfrontend will continualy lose its settings in this
>  > scenario unless you use the LocalHostName unique identifier.
>  >
>
>
> Thanks Nick.
>
>  I didn't post the rest of the relevant shell output, so
>
>  [OUTPUT]
>  2008-06-21 09:42:59.627 Using runtime prefix = /usr, libdir = /usr/lib
>  2008-06-21 09:43:00.155 DPMS is active.
>  2008-06-21 09:43:00.156 Empty LocalHostName.
>  2008-06-21 09:43:00.156 Using localhost value of <localpc>
>  2008-06-21 09:43:00.195 New DB connection, total: 1
>  2008-06-21 09:43:00.206 Unable to connect to database!
>  2008-06-21 09:43:00.207 Driver error was [1/2003]:
>  QMYSQL3: Unable to connect
>  Database error was:
>  Can't connect to MySQL server on '192.168.1.6' (111
>  [/OUTPUT]
>
>  I am stuck on the error "Can't connect to MySQL server on '192.168.1.6'
>  (111)", despite this being the valid backend server which I can access
>  OK from another front end. AFAIK the network is connected OK.

Can you connect to the remote MySQL server from the command line on
the new frontend?

$ mysql -h 192.168.1.6 -u mythtv mythconverg -p

Do your ~/.mythtv/mysql.txt and/or ~/.mythtv/config.xml files contain
the correct DB access information?

Does your new frontend have privileges to connect to the database?

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin