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

Mon Oct 3 23:33:54 UTC 2005

On Mon, 3 Oct 2005 18:24:50 +0200, Jeremy Thompson wrote:

[root at mythtv etc]# mythtv
2005-10-03 18:16:30.848 New DB connection, total: 1
Total desktop width=3D1024, height=3D768, numscreens=3D1
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

For this one, you have some sort of error with lirc not being compiled or
loaded properly. There should be an lirc entry in modprobe.conf (or
whatever your distro uses)... Also check the output of lsmod.

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 am thoroughly convinced that mythtv-setup does NOT work properly. Every
time I have tried to make any changes to the name or IP of the mythtv
system it has failed. And attempting to change back will not work either.
First check that you have a  ~/mythtv/.mythtv/mysql.txt file and that it
has the correct entries. Also check whether there is a similar file under
/root/.mythtv/  Chances are that they differ. If you have done an 'su' to
fix something and forgotten to exit before calling mythtv-setup, then you
will likely be using the wrong file!

If that does not work, I suggest that, as root, you delete the mythconverg
folder and start again by running the mc.sql script. You can run that as
individual commands in mysql after logging in with 'mysql -u root -p
<enter>' and giving your password.

>From my experience, there is no easy way to correct these errors. The
Mythtv how-to describes how to dump and restore the database. (About
Chapter 22.5 or so). Not particularly easy to do but worthwhile if you
must save the data. If you are just setting up then there is no real data
yet.

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

This says that host '192.168.1.103' is not a proper mysql user....there
are probably only 2 proper users: mythtv ('granted' by the mc.sql script
and the mysql root user.

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)

This seems to say that you have named the host machine as 'mythtv' (rather
than being user mythtv at my-new-PVR-box)

If you sign in to mysql as root you can run "select * from settings;'  
which will show you all of the entries in the settings 'database' (form).
There are 450 odd entries. The third column is "hostname". After running
into the same sort of error and attempting to go back to using
'localhost', I had 179 entries still with the old and wrong hostname... I
had to use a Replace command in mysql to change those entries... This had
the unfortunate side effect of apparently also deleting all of the
settings. I had attempted the replacement route as a surrogate for just
deleting mythconverg and starting again.

And I bought O'Reilly: Mysql in a Nutshell  yesterday afternoon...

Geoff

R. Geoffrey Newbury                          newbury at mandamus.org
Barrister and Solicitor                         Telephone: 905-271-9600                 
Mississauga,Ontario, Canada              Facsimile:   905-271-1638