[mythtv-users] UK listings problem

[sven waeyenbergh]

Dear list,

I'm still having the same problem, but it's looking like the problem is
actually the database, and not the RT site.

At the moment i have a mythtv backend with a PVR500 and a PVR150, both
connected to my analog line (with belgian listings)
this works great, also for updating the listings.

Now i got myself a sattelite dish and SKY box. combination works great
directly to my TV.
I also got a serial box capable of changing the channel on my SKY box. that
should work with mythtv.

I connected my SKY box to the PVR150, stopped mythtv, run mythtv-setup and
added a sourceid for UK (both for RT and bleb)
I changed the PVR150 to use the UK sourceid, and not the belgian one. next i
exitted mythtv-setup

I tried to run "mythfilldatabase --sourceid 2 --manual" and this takes like
1 hour and ends in:


Lost connection to MySQL server at 'reading authorization packet', system
error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-08-21 16:51:37.034 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
QSqlQuery::prepare: database not open
QSqlQuery::exec: database not open
###
### New channel found
###
### name     = ARY Digital
### callsign =
### channum  = ARY Digital
### finetune =
### tvformat = Default
### icon     = /home/mythtv/.mythtv/channels/ary_digital.jpg
###
Choose a channel ID (positive integer)  [0]  ###
### Channel skipped
###
2007-08-21 16:54:13.755 Unable to connect to database!
2007-08-21 16:54:13.770 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading authorization packet', system
error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-08-21 16:55:24.089 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
QSqlQuery::prepare: database not open
QSqlQuery::exec: database not open
###
### New channel found
###
### name     = Animal Planet
### callsign =
### channum  = Animal Planet
### finetune =
### tvformat = Default
### icon     = /home/mythtv/.mythtv/channels/animalplanet.jpg
###
Choose a channel ID (positive integer)  [0]

After filling in the channel ID it continues ..

Choose a channel ID (positive integer)  [0]  25
Choose a channel name (any string, long version)  [Animal Planet]
Choose a channel callsign (any string, short version) animal
Choose a channel number (just like xawtv)  [Animal Planet]
Choose a channel fine tune offset (just like xawtv)
Choose a TV format (PAL/SECAM/NTSC/ATSC/Default)  [Default]
Choose a channel icon image (any path name)  [
http://www.lyngsat-logo.com/logo/tv/aa/animalplanet.jpg]
2007-08-21 17:14:57.068 New DB connection, total: 5
2007-08-21 17:15:04.842 Connected to database 'mythconverg' at host: mysql
###
### Channel inserted
###
2007-08-21 17:17:35.806 Unable to connect to database!
2007-08-21 17:17:36.051 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading authorization packet', system
error: 0

QSqlQuery::exec: database not open


However, my belgian listings still run fine, so the database should be ok.

Do i have to do anything more to get the UK listings ?
maybe there are some belgian listings still in the DB for the PVR150,
do i have to delete them somewhere before i change the pvr150 to UK ?

I'm at a loss.

NOTES:
- mysql server runs on different server then backend
- both backend and mysql actually run inside a xen VM.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070821/dea25eff/attachment.htm