I'm seeing a lot of messages like this one from Feb 11th on this list without a lot of responses. Is this a common error I should be ignoring?
When I run mythfilldatabase, it seems to be working and, peeking with mysql, the programs table is getting filled with data, but the run inevatably ends as follows: --11:00:42-- 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] [ <=> ] 15,637 11.80K/s 11:00:44 (11.80 KB/s) - `-' saved [15637] 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 I've checked the Master Server settings. The IP addresses are correct.. This machine is/will be the Master Server. Mysql runs here. I've granted priviliges to mythtv@<this machine> where <this machine> is represented by localhost, by ip and by hostname. On Fri, 11 Feb 2005 16:10:28 -0700, Teruel de Campo <[EMAIL PROTECTED]> wrote: > 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 >
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
