ref: -mythtv-0.17 -mysql Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64) -ivtv-0.3.2b -Server and client in the same machine -amd64
Problem: after ./setup and run mythfilldatabase, it does not complete. Everything else is working ok.
Before run mythfilldatabase I am sure that mysql is running. I check mythconverg and it is ok. I have reviewd almost everything I can find and I have followed the instructions one by one and it is always the same problem. This is not due to mythtv 0.17 because the same happened with 0.16. I was hopping that the new version would it solve it but.... Please give any direction where to look at it. I am sure that some of you went through the same problem.
----------------------- [EMAIL PROTECTED]:~/multimedia/mythtv-0.17/setup> mythfilldatabase Refreshing Tomorrow's data Retrieving datadirect data... Grabbing data for Fri Feb 11 2005 offset 1 From : Sat Feb 12 07:00:00 2005 To : Sun Feb 13 07:00:00 2005 (UTC) --15:28:31-- 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]
[ <=> ] 164,335 37.44K/s
15:28:38 (29.91 KB/s) - `-' saved [164,335]
Your subscription expires on 04/02/2005 11:00:10 PM Grab complete. Actual data from Sat Feb 12 07:00:00 2005 to Sun Feb 13 07:00:00 2005 (UTC) Clearing data for source... Clearing from Sat Feb 12 00:00:00 2005 to Sun Feb 13 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 Fri Feb 11 2005 Retrieving datadirect data... Grabbing data for Fri Feb 11 2005 offset 0 From : Fri Feb 11 07:00:00 2005 To : Sat Feb 12 07:00:00 2005 (UTC) --15:28:41-- 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]
[ <=> ] 186,462 38.36K/s
15:28:48 (30.91 KB/s) - `-' saved [186,462]
Your subscription expires on 04/02/2005 11:00:10 PM Grab complete. Actual data from Fri Feb 11 07:00:00 2005 to Sat Feb 12 07:00:00 2005 (UTC) Clearing data for source... Clearing from Fri Feb 11 00:00:00 2005 to Sat Feb 12 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, descrip tion, showtype, category, category_type, airdate, stars, previouslyshown, stereo , subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalaird ate, colorcode, syndicatedepisodenumber, programid) SELECT chanid, starttime, en dtime, title, subtitle, description, showtype, dd_genre.class, category_type, ai rdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumb er, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd _v_program.programid FROM dd_v_program LEFT JOIN dd_genre ON (dd_v_program.progr amid = 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
DB Error (Inserting into programrating table): Query was: INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chan id, starttime, 'MPAA', mpaarating FROM dd_v_program WHERE mpaarating != ''; Driver error was [2/2002]: QMYSQL3: Unable to execute query Database error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ( 111)
......................other days and the finishes.................................... ata is already present for Thu Feb 24 2005, skipping Adjusting program database end times... fix_end_times: SELECT chanid, starttime, endtime FROM program WHERE (DATE_FORMAT(endtime,"%H%i") = "0000") ORDER BY chanid, starttime; failed! fix_end_times failed! DB Error (KickDatabase): Query was: SELECT NULL; Driver error was [2/2002]: QMYSQL3: Unable to execute query Database error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Marking repeats...found -1 Unmarking repeats from grabber that fall within our new episode window...found 4 2005-02-11 15:28:51.847 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5) Connection timed out. You probably should modify the Master Server settings in the setup program and set the proper IP address. error resceduling id -1 in ScheduledRecording::signalChange
TIA
-=terry(Denver)=-
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
