[mythtv-users] mythfilldatabse fails!!
Teruel de Campo
chusty at attglobal.net
Mon Jan 31 19:56:23 EST 2005
It seems that mythfilldatabase can not connect with mythconverg. The more I look into it the more
I believe is a problem of permission but I do not know where to check it. Everything that I have checked
looks ok (at leat to me).
I appreciate any help where should I look for.
TIA
-=terry(Denver)=-
Teruel de Campo wrote:
> 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)=-
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list