Connection problem to RTV Units
Status: Abandoned
Brought to you by:
leethompson
Menu
▾
▴
#2 Connection problem to RTV Units
I just installed and configured the software and I am
having a problem getting information from my two
ReplayTV units. I had it working briefly after getting
replaySchedule.exe from the CVS. I think it might be a
permissions problem, but I am not sure. I am running on
Windows2000 Server, with IIS 5 and mySQL.
If I access the Guide from the web page I get the
following error:
Refreshing Bedroom ... Failed
Refreshing Den ... Failed
If I access the Guide from a command promt, I get
rtvaddress not defined for either unit.
My log has the following information in it:
2003-09-11 14:11:51 DEBUG->main::SQLStmt::SELECT
* FROM replayunits ORDER BY replayaddress; posted to
SQL [main::SQLStmt called from 276 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 Defined ReplayTVs: 13,12
2003-09-11 14:11:52 13) 'Bedroom' at 192.168.0.104
2003-09-11 14:11:52 12) 'Den' at 192.168.0.112
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM channels WHERE hidden = 0 ORDER BY tuning;
posted to SQL [main::SQLStmt called from 391 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 Channel Range is 3 to 595 (153)
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM tvlistings WHERE tuning = 3 ORDER BY
starttime; posted to SQL [main::SQLStmt called from
493 of c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 Listings Range is 20030911 to
20030912
2003-09-11 14:11:52 Display Grid for 2003-09-11
14:00:00 through 2003-09-11 16:59:59
2003-09-11 14:11:52 Display Grid with 30 minute slots
2003-09-11 14:11:52 Display Grid containing channels
3 - 595
2003-09-11 14:11:52 Creating schedule bar for 'Bedroom'
2003-09-11 14:11:52 SQL: SELECT * FROM
schedule,tvlistings WHERE (replayid = 13) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 0) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime;
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM schedule,tvlistings WHERE (replayid = 13) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 0) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime; posted to
SQL [main::SQLStmt called from 750 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 SQL: SELECT * FROM
schedule,tvlistings WHERE (replayid = 13) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 1) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime;
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM schedule,tvlistings WHERE (replayid = 13) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 1) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime; posted to
SQL [main::SQLStmt called from 750 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 Creating schedule bar for 'Den'
2003-09-11 14:11:52 SQL: SELECT * FROM
schedule,tvlistings WHERE (replayid = 12) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 0) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime;
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM schedule,tvlistings WHERE (replayid = 12) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 0) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime; posted to
SQL [main::SQLStmt called from 750 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 SQL: SELECT * FROM
schedule,tvlistings WHERE (replayid = 12) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 1) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime;
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM schedule,tvlistings WHERE (replayid = 12) AND
(schedule.programid = tvlistings.programid) AND
(schedule.conflict = 1) AND ((starttime BETWEEN '2003-
09-11 14:00:00' AND '2003-09-11 16:59:59') OR
(endtime BETWEEN '2003-09-11 14:15:00' AND '2003-09-
11 17:00:00')) ORDER BY tvlistings.starttime; posted to
SQL [main::SQLStmt called from 750 of
c:\inetpub\scripts\replayguide.plx]
2003-09-11 14:11:52 SQL: SELECT * FROM tvlistings,
channels WHERE ((((starttime BETWEEN '2003-09-11
14:00:00' AND '2003-09-11 16:59:59' OR endtime
BETWEEN '2003-09-11 14:15:00' AND '2003-09-11
17:00:00') AND tvlistings.tuning BETWEEN 3 AND 595)
AND tvlistings.tuning = channels.tuning) AND
tvlistings.channel = channels.channel) AND
channels.hidden = 0 ORDER BY tvlistings.tuning,
tvlistings.channel, starttime;
2003-09-11 14:11:52 DEBUG->main::SQLStmt::SELECT
* FROM tvlistings, channels WHERE ((((starttime
BETWEEN '2003-09-11 14:00:00' AND '2003-09-11
16:59:59' OR endtime BETWEEN '2003-09-11 14:15:00'
AND '2003-09-11 17:00:00') AND tvlistings.tuning
BETWEEN 3 AND 595) AND tvlistings.tuning =
channels.tuning) AND tvlistings.channel =
channels.channel) AND channels.hidden = 0 ORDER BY
tvlistings.tuning, tvlistings.channel, starttime; posted to
SQL [main::SQLStmt called from 871 of
c:\inetpub\scripts\replayguide.plx]
Any ideas? I also posted this to the Help section, but
I'm not sure that anyone is reading it.
Thanks!
Rob Weiss
ReplayGuide Log