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?
[EMAIL PROTECTED]:~> 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?
[EMAIL PROTECTED]:~> 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 [EMAIL PROTECTED]:~> 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 [EMAIL PROTECTED]:~> 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.
[EMAIL PROTECTED]:~> 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)=-
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users