[mythtv-users] mythfilldatabse fails!!
Teruel de Campo
chusty at attglobal.net
Sun Jan 30 12:43:38 EST 2005
This is almost a whole month trying to have mythfilldatabase working. Thanks to John Johnson and Rich Deeming for some great tips.
PROBLEM: I lost connection with the server when I run mythfilldatabase. I'll will try to provide you as much "useful" information as I can.
---------REF:
* asus kv8 deluxe with amd64
* wintTV pvr-350
* SATA raptor
* ATI 9600 pro
* SuSE 9.2
* mysql Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64)
* backend/front end same machine
--------PRESENT STATUS
1. ivtv working well both in <watch tv mode> with mplayer and mythtv.
2. mpg file ok playback in mplayer and kaffeine
3. after the initial ./setup of mythtv IF i do not run mythfilldatabase and run the frontend I can see all the channel and the programing for the following day. So it seems I do not have any problems
with mythtv.
4. I am in the usa and I use the <datadirect.webservices.zap2it.com>
5. I log on as user <tdec> instead of the default mythtv.
This is the content of myth.txr:
DBHostName=localhost
DBUserName=tdec
DBPassword=mythtv
DBName=mythconverg
--------WALKTHROUGH after complete mythtv ./setup and before i run mythfilldatabase:
**Permissions seems to be ok?
tdec at amd64:~> ls -al /var/lib/mysql
total 88
drwxr-xr-x 6 mysql mysql 28672 2005-01-30 10:20 .
drwxr-xr-x 33 root root 4096 2005-01-29 22:06 ..
drwx------ 2 mysql mysql 48 2005-01-08 20:54 info
drwx------ 2 mysql mysql 4096 2005-01-01 17:07 mysql
-rw-rw---- 1 mysql mysql 398 2005-01-30 10:20 mysqld.log
-rw-r--r-- 1 root root 836 2005-01-30 04:15 mysqld.log-20050130.gz
-rw-rw---- 1 mysql mysql 5 2005-01-30 10:20 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 2005-01-30 10:20 mysql.sock
drwx------ 2 mysql mysql 12288 2005-01-30 09:49 mythconverg
drwx------ 2 mysql mysql 1 2005-01-01 17:07 test
**MySQL seems to be running and ok?
tdec at amd64:~> ps ax | grep mysql
5562 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
8777 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
tdec at amd64:~> nmap localhost
Starting nmap 3.75 ( http://www.insecure.org/nmap/ ) at 2005-01-30 10:14 MST
Interesting ports on localhost (127.0.0.1):
(The 1658 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
111/tcp open rpcbind
631/tcp open ipp
3306/tcp open mysql
Nmap run completed -- 1 IP address (1 host up) scanned in 0.147 seconds
tdec at amd64:~> mysql -utdec -pmythtv mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.21
**Tables in mythconverg are present
mysql> SHOW tables;
+----------------------------+
| Tables_in_mythconverg |
+----------------------------+
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| codecparams |
| conflictresolutionany |
| conflictresolutionoverride |
| conflictresolutionsingle |
| credits |
| dvb_channel |
| dvb_pids |
| dvb_sat |
| dvb_signal_quality |
| favorites |
| housekeeping |
| jumppoints |
| keybindings |
| keyword |
| mythlog |
| networkiconmap |
| oldprogram |
| oldrecorded |
| people |
| profilegroups |
| program |
| programgenres |
| programrating |
| recgrouppassword |
| record |
| recorded |
| recordedmarkup |
| recordingprofiles |
| recordoverride |
| settings |
| transcoding |
| videosource |
+----------------------------+
36 rows in set (0.00 sec)
mysql> DESCRIBE program;
+-------------------------+------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+------------------+------+-----+---------------------+-------+
| chanid | int(10) unsigned | | PRI | 0 | |
| starttime | datetime | | PRI | 0000-00-00 00:00:00 | |
| endtime | datetime | | MUL | 0000-00-00 00:00:00 | |
| title | varchar(128) | | MUL | | |
| subtitle | varchar(128) | | | | |
| description | text | | | | |
| category | varchar(64) | | | | |
| category_type | varchar(64) | | | | |
| airdate | year(4) | | | 0000 | |
| stars | float unsigned | | | 0 | |
| previouslyshown | tinyint(4) | | | 0 | |
| title_pronounce | varchar(128) | | MUL | | |
| stereo | tinyint(1) | YES | | NULL | |
| subtitled | tinyint(1) | YES | | NULL | |
| hdtv | tinyint(1) | YES | | NULL | |
| closecaptioned | tinyint(1) | YES | | NULL | |
| partnumber | int(11) | YES | | NULL | |
| parttotal | int(11) | YES | | NULL | |
| seriesid | varchar(12) | | MUL | | |
| originalairdate | date | YES | | NULL | |
| showtype | varchar(30) | | | | |
| colorcode | varchar(20) | | | | |
| syndicatedepisodenumber | varchar(20) | | | | |
| programid | varchar(12) | | MUL | | |
+-------------------------+------------------+------+-----+---------------------+-------+
24 rows in set (0.00 sec)
Now I will run mythfilldatabase as user <tdec> and it will produce the error that lost connection with the server.
** mythfilldatabase was run after ./setup and running all the steps above. The following is the run until the first error. Multiple errors come later but they are all
related to the lost of the connection to the server.
tdec at amd64:~> mythfilldatabase
Refreshing Tomorrow's data
Retrieving datadirect data...
Grabbing data for Sun Jan 30 2005 offset 1
From : Mon Jan 31 07:00:00 2005 To : Tue Feb 1 07:00:00 2005 (UTC)
--10:20:02-- http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
=> `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
[ <=> ] 187,980 38.39K/s
10:20:09 (31.67 KB/s) - `-' saved [187,980]
Your subscription expires on 04/02/2005 11:00:10 PM
Grab complete. Actual data from Mon Jan 31 07:00:00 2005 to Tue Feb 1 07:00:00 2005 (UTC)
Clearing data for source...
Clearing from Mon Jan 31 00:00:00 2005 to Tue Feb 1 00:00:00 2005 (localtime)
Data for source cleared...
Main temp tables populated. Updating myth channels...
Updating icons for sourceid: 1
Channels updated.. Updating programs...
Fetching data for Sun Jan 30 2005
Retrieving datadirect data...
Grabbing data for Sun Jan 30 2005 offset 0
From : Sun Jan 30 07:00:00 2005 To : Mon Jan 31 07:00:00 2005 (UTC)
--10:20:12-- http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
=> `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
[ <=> ] 160,644 38.38K/s
10:20:19 (31.05 KB/s) - `-' saved [160,644]
Your subscription expires on 04/02/2005 11:00:10 PM
Grab complete. Actual data from Sun Jan 30 07:00:00 2005 to Mon Jan 31 07:00:00 2005 (UTC)
Clearing data for source...
Clearing from Sun Jan 30 00:00:00 2005 to Mon Jan 31 00:00:00 2005 (localtime)
Data for source cleared...
Main temp tables populated. Updating myth channels...
Updating icons for sourceid: 1
Channels updated.. Updating programs...
DB Error (Inserting into program table):
Query was:
INSERT IGNORE INTO program (chanid, starttime, endtime, title, subtitle, description, showtype, category, category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned,
partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, programid) SELECT chanid, starttime, endtime, title, subtitle, description, showtype, dd_genre.class,
category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd_v_program.programid
FROM dd_v_program LEFT JOIN dd_genre ON (dd_v_program.programid = dd_genre.programid AND dd_genre.relevance = '0');
Driver error was [2/2013]:
QMYSQL3: Unable to execute query
Database error was:
Lost connection to MySQL server during query
TXKS for any tips I have run out of any path to follow :-( .
-=terry(Denver)=-
More information about the mythtv-users
mailing list