[mythtv-users] Mythtv - database; MySQL good - Myth Lost -

[Jeremy Thompson]

Ok,
Changed it, restarted mysql (worked!), however I now get this error:

[root at mythtv etc]# mythtv
2005-10-03 18:16:30.848 New DB connection, total: 1
Total desktop width=1024, height=768, numscreens=1
2005-10-03 18:16:30.857 Using screen 0, 1024x768 at 0,0
2005-10-03 18:16:30.897 Switching to square mode (G.A.N.T.)
mythtv: could not connect to socket
mythtv: No such file or directory
lirc_init failed for mythtv, see preceding messages
2005-10-03 18:16:31.578 Joystick disabled.
2005-10-03 18:16:31.739 New DB connection, total: 2
2005-10-03 18:16:31.766 Connecting to backend server:
127.0.0.1:6543<http://127.0.0.1:6543>(try 1 of 5)
Connection timed out.
You probably should modify the Master Server settings
in the setup program and set the proper IP address.
2005-10-03 18:16:34.122 Changing from None to None

I changed the backend to localhost, mythtv, 127.0.0.1 <http://127.0.0.1>,
and my actual ip. I got this error for actual IP

2005-10-03 18:21:40.952 Database not open while trying to save setting:
Language
2005-10-03 18:21:40.953 Unable to connect to database!
2005-10-03 18:21:40.953 Driver error was [1/1130]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.1.103 <http://192.168.1.103>' is not allowed to connect to
this MySQL server

for localhost, 127.0.0.1 <http://127.0.0.1> and mythtv I get:

2005-10-03 18:23:36.950 Writing settings file /root/.mythtv/mysql.txt
QInputContext: cannot create input context for non-toplevel widgets
QInputContext: cannot create input context for non-toplevel widgets
2005-10-03 18:23:36.954 Unable to connect to database!
2005-10-03 18:23:36.954 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on 'mythtv' (111)

2005-10-03 18:23:36.954 Failed to init MythContext, exiting.





On 10/3/05, Jeremy Thompson <jeremy.a.thompson at googlemail.com> wrote:
>
> What version are you running and what on?
>
>
>
> On 10/3/05, Greg Woods <greg at gregandeva.net> wrote:
> >
> > On Mon, 2005-10-03 at 15:39 +0000, Jeremy Thompson wrote:
> >
> > > Just check in var/lib/mysql/mythconverg and it's full of .MYI&D files.
> > >
> > > should I change the cnf to
> > >
> > > datadir=/var/lib/mysql/
> >
> > Yes (without the trailing slash). That's what mine has. MySQL can handle
> > multiple databases, so datadir is set to where all the databases are.
> > Each database (like "mythconverg") then has its own subdirectory under
> > that.
> >
> > --Greg
> >
> >
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20051003/f966b546/attachment.htm