[mythtv-users] Database problem?

Peter Crighton mythtv at p-cright.demon.co.uk
Mon Oct 9 11:38:55 UTC 2006 

On Fri, 06 Oct 2006 14:52:52 -0400, you wrote:

>Peter Crighton wrote:
>> On Fri, 6 Oct 2006 10:46:17 -0500, you wrote:
>> 
>>> On 10/6/06, Peter Crighton <mythtv at p-cright.demon.co.uk> wrote:
>>>> Host name: mythtv
>>>> Database: mythconverg
>>>> User:
>>>> Password:
>>>> Database type: Mysql
>>> Is the hostname 'mythtv' registered in your /etc/hosts file, or on a
>>> dns server somewhere? I'd try localhost instead.
>> 
>> Tried that - no different, although "mysql mythconverg -h localhost -u
>> mythtv -pmythtv" successfully connects to the database.
>
>localhost should always work for the mysql client to talk to the mysql 
>server on the same machine.
>Your problem is likely that your mythtv frontend thinks your mysql 
>server is on some other machine...you may have entered mythtv or mythbox 
>or something in mythtv-setup, but that exact name does not also appear 
>in /etc/hosts so that the frontend (or backend) actually sends the mysql 
>requests to the correct place.
>
>Go into mythtv-setup and replace all references to computers with 
>127.0.0.1 and make sure that you have '127.0.0.1 localhost' in /etc/hosts.
>
>This works for all single computer setups (back and frontend on the same 
>machine). Fails for two computer setups.
>

This has not worked, as have none of the other suggestions. Maybe it's
not entirely a database issue. I have captured the output from
executing mythtv-setup and pasted it below in the hope that it might
help.  Not captured (displayed on screen) where also multiple
"QSqlQuery::exec: database not open" responses and a final line
"QMultiInputContext::changeInputMethod(): index=0, slave=xim.

---

2006-10-09 12:32:03.741 Using runtime prefix = /usr/local
2006-10-09 12:32:03.757 DPMS is active.
2006-10-09 12:32:03.766 New DB connection, total: 1
2006-10-09 12:32:03.767 Unable to connect to database!
2006-10-09 12:32:03.768 No error type from QSqlError?  Strange...
2006-10-09 12:32:03.839 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:03.897 Unable to connect to database!
2006-10-09 12:32:03.900 No error type from QSqlError?  Strange...
2006-10-09 12:32:03.953 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.007 Database not open while trying to load
setting: GuiVidModeResolution
2006-10-09 12:32:04.008 Unable to connect to database!
2006-10-09 12:32:04.008 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.065 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.119 Database not open while trying to load
setting: GuiVidModeWidth
2006-10-09 12:32:04.120 Unable to connect to database!
2006-10-09 12:32:04.120 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.173 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.228 Database not open while trying to load
setting: GuiVidModeHeight
2006-10-09 12:32:04.233 Unable to connect to database!
2006-10-09 12:32:04.233 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.285 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.337 Database not open while trying to load
setting: DisplaySizeResolution
2006-10-09 12:32:04.338 Unable to connect to database!
2006-10-09 12:32:04.338 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.389 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.441 Database not open while trying to load
setting: DisplaySizeWidth
2006-10-09 12:32:04.442 Unable to connect to database!
2006-10-09 12:32:04.442 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.493 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.545 Database not open while trying to load
setting: DisplaySizeHeight
2006-10-09 12:32:04.546 Unable to connect to database!
2006-10-09 12:32:04.546 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.598 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.650 Database not open while trying to load
setting: TVVidModeResolution
2006-10-09 12:32:04.650 Unable to connect to database!
2006-10-09 12:32:04.651 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.702 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.754 Database not open while trying to load
setting: TVVidModeWidth
2006-10-09 12:32:04.754 Unable to connect to database!
2006-10-09 12:32:04.755 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.806 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.859 Database not open while trying to load
setting: TVVidModeHeight
2006-10-09 12:32:04.860 Unable to connect to database!
2006-10-09 12:32:04.860 No error type from QSqlError?  Strange...
2006-10-09 12:32:04.912 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:04.964 Database not open while trying to load
setting: VidModeResolution0
2006-10-09 12:32:04.964 Unable to connect to database!
2006-10-09 12:32:04.964 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.016 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.068 Database not open while trying to load
setting: VidModeWidth0
2006-10-09 12:32:05.068 Unable to connect to database!
2006-10-09 12:32:05.068 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.120 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.172 Database not open while trying to load
setting: VidModeHeight0
2006-10-09 12:32:05.172 Unable to connect to database!
2006-10-09 12:32:05.173 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.225 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.277 Database not open while trying to load
setting: TVVidModeResolution0
2006-10-09 12:32:05.277 Unable to connect to database!
2006-10-09 12:32:05.277 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.329 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.381 Database not open while trying to load
setting: TVVidModeWidth0
2006-10-09 12:32:05.381 Unable to connect to database!
2006-10-09 12:32:05.381 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.433 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.485 Database not open while trying to load
setting: TVVidModeHeight0
2006-10-09 12:32:05.490 Unable to connect to database!
2006-10-09 12:32:05.491 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.544 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.596 Database not open while trying to load
setting: UseVideoModes
2006-10-09 12:32:05.596 Total desktop dim: 1024x768, with 1 screen[s].
2006-10-09 12:32:05.600 Unable to connect to database!
2006-10-09 12:32:05.601 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.654 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.706 Database not open while trying to load
setting: RunFrontendInWindow
2006-10-09 12:32:05.707 Using screen 0, 1024x768 at 0,0
2006-10-09 12:32:05.707 Unable to connect to database!
2006-10-09 12:32:05.707 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.759 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.811 Database not open while trying to load
setting: Style
2006-10-09 12:32:05.811 Unable to connect to database!
2006-10-09 12:32:05.811 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.863 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:05.915 Database not open while trying to load
setting: Theme
2006-10-09 12:32:05.916 Switching to square mode (blue)
2006-10-09 12:32:05.916 Unable to connect to database!
2006-10-09 12:32:05.916 No error type from QSqlError?  Strange...
2006-10-09 12:32:05.968 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.020 Database not open while trying to load
setting: GuiOffsetX
2006-10-09 12:32:06.020 Unable to connect to database!
2006-10-09 12:32:06.020 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.073 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.125 Database not open while trying to load
setting: GuiOffsetY
2006-10-09 12:32:06.125 Unable to connect to database!
2006-10-09 12:32:06.125 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.177 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.229 Database not open while trying to load
setting: GuiResolution
2006-10-09 12:32:06.229 Unable to connect to database!
2006-10-09 12:32:06.229 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.282 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.334 Database not open while trying to load
setting: GuiWidth
2006-10-09 12:32:06.334 Unable to connect to database!
2006-10-09 12:32:06.334 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.386 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.438 Database not open while trying to load
setting: GuiHeight
2006-10-09 12:32:06.520 Unable to connect to database!
2006-10-09 12:32:06.521 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.575 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.627 Database not open while trying to load
setting: MenuTheme
2006-10-09 12:32:06.627 Unable to connect to database!
2006-10-09 12:32:06.627 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.680 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.732 Database not open while trying to load
setting: QtFontBig
2006-10-09 12:32:06.732 Unable to connect to database!
2006-10-09 12:32:06.732 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.784 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.836 Database not open while trying to load
setting: QtFontMedium
2006-10-09 12:32:06.836 Unable to connect to database!
2006-10-09 12:32:06.836 No error type from QSqlError?  Strange...
2006-10-09 12:32:06.888 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:06.940 Database not open while trying to load
setting: QtFontSmall
2006-10-09 12:32:06.987 Unable to connect to database!
2006-10-09 12:32:06.988 No error type from QSqlError?  Strange...
2006-10-09 12:32:07.041 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:07.093 Database not open while trying to load
setting: ThemePainter
2006-10-09 12:32:07.093 Using the Qt painter
2006-10-09 12:32:07.094 Unable to connect to database!
2006-10-09 12:32:07.094 No error type from QSqlError?  Strange...
2006-10-09 12:32:07.147 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:07.199 Database not open while trying to load
setting: HideMouseCursor
2006-10-09 12:32:07.199 Unable to connect to database!
2006-10-09 12:32:07.199 No error type from QSqlError?  Strange...
2006-10-09 12:32:07.251 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:07.303 Database not open while trying to load
setting: RunFrontendInWindow
2006-10-09 12:32:08.262 Unable to connect to database!
2006-10-09 12:32:08.262 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.266 Joystick disabled.
2006-10-09 12:32:08.314 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.367 Unable to connect to database!
2006-10-09 12:32:08.368 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.419 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.472 Unable to connect to database!
2006-10-09 12:32:08.472 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.523 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.576 Unable to connect to database!
2006-10-09 12:32:08.576 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.627 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.680 Unable to connect to database!
2006-10-09 12:32:08.680 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.731 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.784 Unable to connect to database!
2006-10-09 12:32:08.784 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.836 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.889 Unable to connect to database!
2006-10-09 12:32:08.889 No error type from QSqlError?  Strange...
2006-10-09 12:32:08.940 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:08.993 Unable to connect to database!
2006-10-09 12:32:08.993 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.044 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.097 Unable to connect to database!
2006-10-09 12:32:09.097 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.148 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.200 Unable to connect to database!
2006-10-09 12:32:09.201 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.252 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.304 Unable to connect to database!
2006-10-09 12:32:09.305 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.356 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.408 Unable to connect to database!
2006-10-09 12:32:09.409 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.460 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.512 Unable to connect to database!
2006-10-09 12:32:09.513 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.564 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.616 Unable to connect to database!
2006-10-09 12:32:09.617 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.668 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.720 Unable to connect to database!
2006-10-09 12:32:09.721 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.772 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.824 Unable to connect to database!
2006-10-09 12:32:09.825 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.876 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:09.928 Unable to connect to database!
2006-10-09 12:32:09.929 No error type from QSqlError?  Strange...
2006-10-09 12:32:09.980 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.032 Unable to connect to database!
2006-10-09 12:32:10.033 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.084 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.136 Unable to connect to database!
2006-10-09 12:32:10.137 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.188 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.240 Unable to connect to database!
2006-10-09 12:32:10.241 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.292 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.344 Unable to connect to database!
2006-10-09 12:32:10.345 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.396 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.448 Unable to connect to database!
2006-10-09 12:32:10.449 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.500 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.552 Unable to connect to database!
2006-10-09 12:32:10.552 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.604 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.656 Unable to connect to database!
2006-10-09 12:32:10.656 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.708 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.761 Unable to connect to database!
2006-10-09 12:32:10.761 No error type from QSqlError?  Strange...
2006-10-09 12:32:10.813 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:10.865 Database not open while trying to load
setting: Language
2006-10-09 12:32:13.549 Unable to connect to database!
2006-10-09 12:32:13.549 No error type from QSqlError?  Strange...
2006-10-09 12:32:13.602 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:13.653 Database not open while trying to save
setting: Language
2006-10-09 12:32:13.654 Unable to connect to database!
2006-10-09 12:32:13.654 No error type from QSqlError?  Strange...
2006-10-09 12:32:13.705 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:13.757 Database not open while trying to load
setting: Language
2006-10-09 12:32:13.759 Unable to connect to database!
2006-10-09 12:32:13.760 No error type from QSqlError?  Strange...
2006-10-09 12:32:13.811 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:13.863 Database not open while trying to save
setting: Language
2006-10-09 12:32:13.865 Unable to connect to database!
2006-10-09 12:32:13.865 No error type from QSqlError?  Strange...
2006-10-09 12:32:13.917 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-09 12:32:16.160 User canceled database configuration
2006-10-09 12:32:16.221 Failed to init MythContext, exiting.
--

Peter Crighton

More information about the mythtv-users mailing list