Messages

1

Users / DVB-card triplication in MythTV.

« on: December 17, 2010, 04:03:53 pm »

Hi, Comrades! 

810-snapshot for 05.12.2010
Core/Hybrid with 2 tuners TT-budget S-1500
MD with 2 tuners TT-budget S-1500

Problem:
By some reason, first (1 of 2) DVB-card on each machine duplicates, or even triplicates.
I.e. I see 2 cards in MythTV Setup, but "max recordings" = 3 on FIRST(/dev/dvb/adapter0/frontend0) card, even if i set it to 1, after exiting setup it turns back to 3.

Tried to delete manualy those unexisting tuners directly in sql, but after reload they are here again, under new id numbers.

And it could be OK, it works well, shows and records using all inputs... BUT! System THINKS there are 4 more tuners and it tries to use them for recording TV, causing not even conflicts, but just missing records.

SQL:

Code: [Select]

select cardid, videodevice, hostname from capturecard;

cardid  videodevice     hostname
1       /dev/dvb/adapter0/frontend0     dcerouter
2       /dev/dvb/adapter1/frontend0     dcerouter
3       /dev/dvb/adapter1/frontend0     moon58
4       /dev/dvb/adapter0/frontend0     moon58
73      /dev/dvb/adapter0/frontend0     dcerouter
74      /dev/dvb/adapter0/frontend0     dcerouter
77      /dev/dvb/adapter0/frontend0     moon58
78      /dev/dvb/adapter0/frontend0     moon58

Table "cardinput" has the same strings, with same "cardid" values as "capturecard".

Code: [Select]

select cardid, inputname, displayname from cardinput;

cardid  inputname       displayname
1       DVBInput        a0
2       DVBInput        a1
3       DVBInput        b1
4       DVBInput        b0
73      MPEG2
74      MPEG2
77      MPEG2
78      MPEG2

More detailed export from mythconverg.capturecard:

Code: [Select]

"1";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"dcerouter";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"5500";"9500";"0";"0";"0";"0";"0";"2";"1"
"2";"/dev/dvb/adapter1/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"dcerouter";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"5250";"9250";"0";"0";"0";"0";"0";"3";"1"
"3";"/dev/dvb/adapter1/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"moon58";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"5750";"9750";"0";"0";"0";"0";"0";"5";"1"
"4";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"moon58";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"5500";"9500";"0";"0";"0";"0";"0";"7";"1"
"73";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"MPEG2";NULL;"dcerouter";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"1000";"3000";"0";"0";"0";"0";"0";NULL;"1"
"74";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"dcerouter";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"1000";"3000";"0";"0";"0";"0";"0";NULL;"1"
"77";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"moon58";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"1000";"3000";"0";"0";"0";"0";"0";NULL;"1"
"78";"/dev/dvb/adapter0/frontend0";NULL;NULL;"DVB";"DVBInput";NULL;"moon58";"0";"0";"1";"0";"0";NULL;"0";NULL;"0";"1000";"3000";"0";"0";"0";"0";"0";NULL;"1"

I tried to insert sql-script in the end of MythTVSyncDB.sh, that deletes those cards with cardid>4 from tables, it works, no more exessive tuners, but it causes constant restart of backend and errors in MythTV Plugin log, looks like mythfilldatabase tries to run.

So... Any ideas? 

2

Users / Re: "MythTV is ready. However ..." Repeats constantly

« on: December 17, 2010, 03:15:37 pm »

Hi guys!!!!

SOLVED - sounds sooo sweet...

Coley: Thank's! It works now.
MANDINGO: I'm happy to help

Insert string for TT-1500 template now looks like this:

Code: [Select]

INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput','<%=HOST%>');
Well, universe doesn't want my life to become TOO sweet I explain:
By some reason, first (1 of 2) DVB-card on each machine duplicates, or even triplicates.
I.e. I see 2 cards in MythTV Setup, but "max recordings" = 3 on first card, even if i set it to 1, after exiting setup it turns back to 3.
...But I'd better create another post for this problem...

Thank's again!

3

Users / "MythTV is ready. However ..." Repeats constantly - SOLVED

« on: December 10, 2010, 11:32:00 am »

Hi, Comrades!

810-snapshot for 05.12.2010
Core/Hybrid with 2 tuners TT-budget S-1500
MD with 2 tuners TT-budget S-1500

In pre-pre-previous installation everything was OK about it, but...

Problem:
After installing tuners in MythTV Setup, I continuesly get theese messages:
"MythTV is ready. However ..."
[ OK ]
and
"It will take about few minutes to retreive your channel listings. ...."
[ OK ]
After every reload system tells me (box in left-top corner of screen), it has added all my tuners. Again.

I can scan channels, it's ok, but after exiting from Setup, TV almost can not work (well, few times by couple seconds there was picture), seems, those messages appears each time backend restarts or mythfilldatabase runs and restarts backend.

Here is part of MythTV-Plugin log:

Code: [Select]

05 12/10/10 13:15:09.760 MythTV_PlugIn::CMD_Sync_Providers_and_Cards cardid 0 is invalid <0x7ccccb90>
01 12/10/10 13:15:09.766 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''dcerouter),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.766 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.767 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''dcerouter),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.767 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.767 Query failed (): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   retry: 0 <0x7ccccb90>
05 12/10/10 13:15:09.768 MythTV_PlugIn::CMD_Sync_Providers_and_Cards cardid 0 is invalid <0x7ccccb90>
01 12/10/10 13:15:09.770 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''dcerouter),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.770 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.770 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''dcerouter),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.770 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.770 Query failed (): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'dcerouter),   retry: 0 <0x7ccccb90>
05 12/10/10 13:15:09.772 MythTV_PlugIn::CMD_Sync_Providers_and_Cards cardid 0 is invalid <0x7ccccb90>
01 12/10/10 13:15:09.773 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''moon58),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.773 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.773 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''moon58),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.773 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.773 Query failed (): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   retry: 0 <0x7ccccb90>
05 12/10/10 13:15:09.775 MythTV_PlugIn::CMD_Sync_Providers_and_Cards cardid 0 is invalid <0x7ccccb90>
01 12/10/10 13:15:09.776 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''moon58),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.776 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.777 Query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''moon58),' at line 1): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   (1) <0x7ccccb90>
05 12/10/10 13:15:09.777 Resetting db_wrapper connection <0x7ccccb90>
01 12/10/10 13:15:09.777 Query failed (): INSERT INTO `capturecard`(videodevice,cardtype,defaultinput,hostname) VALUES ('/dev/dvb/adapter0/frontend0','DVB','DVBInput', 'moon58),   retry: 0 <0x7ccccb90>


I understand, the error is in absence of ' after 'moon58 and 'dcerouter in the end of each line, but i can not find a way to fix it.
It cannot be that I am the one, who has such problem... Any ideas how to deal with it?