401 UnAuthorized Error Revisited?

[coffee412]

I noticed today that my tv listings didnt upgrade and my system went to all unknown.
I checked my settings.

1. I can login to schedules direct ok.
2. My account shows active (Ive paid the 15)
3. my logins are not uppercase in anyway.


error in mythfilldatabase:

Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized


Did the site address change?

Any input anyone?

coffee

[coffee412]

Here is something else I found but not sure if it relates?

2007-09-20 22:06:10.598 DataDirect, Error: UpdateProgramViewTable no dd_state!

Im sure it cannot be good.

coffee

[coffee412]

SOLVED.

For some reason the rest of my login was missing ( @comcast.net). Now its working fine.

Life once again is good. All is good in the world!


coffee

[no2u]

Previously my SD username was my email address which contains an underscore. Worked fine through 9/14, and then started getting the "Authorization failed" and "no dd_state" errors. Picking a new username on the SD website, shorter length and without the @ and the underscore, (and updating the lineups in MythTV setup accordingly) seemed to fix the problem for me.

[mythdragon]

I'm trying to use my trial pass to make sure everything is working.

It's not. I'm getting the 401 error. I'm willing to shell out the 20.-..... as soon as I see it work.

Thanks,

Wade

[aerobiotic]

I've tried all the standard odd ball fixes of making my user id and password lowercase. Made my password shorter, and no special characters in it or my user id. I am still getting 401 UnAuthorized Error.

Are there tables missing in the database after conversion to Schedules direct?

dd_v_program and dd_state are not in the database and these are causing the error output. See below:

mythfilldatabase -v all | tee r0.txt

looking into the output near the error, here's my output:
2007-10-20 08:01:20.063 MSqlQuery: SELECT sawrepeat, sawnew FROM dd_state
2007-10-20 08:01:20.063 DataDirect, Error: UpdateProgramViewTable no dd_state!
2007-10-20 08:01:20.064 MSqlQuery: SELECT count(*) from dd_v_program;
2007-10-20 08:01:20.064 Did not find any new program data.

So I opened the database as follows:
mysql -u root -p
mysql> show databases;
mysql> use mythconverg;
mysql> show tables;
+-----------------------+
| Tables_in_mythconverg |
+-----------------------+
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| codecparams |
| credits |
| customexample |
| diseqc_config |
| diseqc_tree |
| dtv_multiplex |
| dtv_privatetypes |
| eit_cache |
| favorites |
| housekeeping |
| inuseprograms |
| jobqueue |
| jumppoints |
| keybindings |
| keyword |
| mythlog |
| networkiconmap |
| oldfind |
| oldprogram |
| oldrecorded |
| people |
| pidcache |
| playgroup |
| profilegroups |
| program |
| programgenres |
| programrating |
| recgrouppassword |
| record |
| recorded |
| recordedcredits |
| recordedmarkup |
| recordedprogram |
| recordedrating |
| recordedseek |
| recordingprofiles |
| recordmatch |
| schemalock |
| settings |
| tvchain |
| videobookmarks |
| videosource |
+-----------------------+
46 rows in set (0.00 sec)

I'm using ubuntu 7.04 and the mythtv 0.20.2-0ubuntu0.7.04.1 from multiverse.

It seems like this may not be the root cause of the 401 UnAuthorized Error, since I can get listings occasionally. I just keep running mythfilldatabase and every once in a while it will grab some but not all listings. This makes me think it's something on the schedule directs backend.


Still getting output like this:
2007-10-20 09:45:33.943 Grabbing listing data
--09:45:33-- http://webservices.schedulesdirect.tmsd ... tvdService
=> `-'
Resolving webservices.schedulesdirect.tmsdatadirect.com... 206.18.98.175
Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Failed writing HTTP request: Bad file descriptor.
Retrying.

--09:45:35-- http://webservices.schedulesdirect.tmsd ... tvdService
(try: 2) => `-'
Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to webservices.schedulesdirect.tmsdatadirect.com:80.
HTTP request sent, awaiting response... 403 Forbidden
09:45:35 ERROR 403: Forbidden.

2007-10-20 09:45:35.193 Grab complete. Actual data from to (UTC)
2007-10-20 09:45:35.194 Main temp tables populated.

[aerobiotic]

Here are some more details on the errors of missing tables errors in the mythfilldatabase process. The dd_state tables are temporary tables and are created by the myth fill database program and are therefore present.

from my output from: mythfilldatabase -v all | tee r0.txt

2007-10-20 08:01:20.228 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_state ( sawrepeat bool, sawnew bool );
2007-10-20 08:01:20.229 MSqlQuery: TRUNCATE TABLE dd_state;

I looked at the mythtv source code and all this message means is that there wasn't anything in the table when it was queried. See snippet.

void DataDirectProcessor::UpdateProgramViewTable(uint sourceid)
{
MSqlQuery query(MSqlQuery::DDCon());

query.prepare(
"SELECT sawrepeat, sawnew "
"FROM dd_state");

if (!query.exec())
{
MythContext::DBError("Querying into dd_state", query);
return;
}

if (!query.next())
{
VERBOSE(VB_IMPORTANT, LOC_ERR + "UpdateProgramViewTable no dd_state!");
return;
}

Are there tables missing in the database after conversion to Schedules direct? answer, No

I am even more convinced that this has nothing to do with the "401 UnAuthorized Error".