that threw an error:

Code:

Updating (update) row id 2382 last sync: 2381
01 05/11/13 18:09:38.622 Query failed (Duplicate entry '2231' for key 'PRIMARY'): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 (1) <0xb774f6d0>
05 05/11/13 18:09:38.622 Resetting mysql connection <0xb774f6d0>
01 05/11/13 18:09:38.627 Query failed (Duplicate entry '2231' for key 'PRIMARY'): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 (1) <0xb774f6d0>
05 05/11/13 18:09:38.627 Resetting mysql connection <0xb774f6d0>
01 05/11/13 18:09:38.628 Query failed (): UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382 retry: -1 <0xb774f6d0>
Failed to update row: UPDATE `DeviceTemplate` SET `CommandLine`=NULL, `Comments`=NULL, `ConfigureScript`=NULL, `Define`='', `Description`='Tuner - OTARadio', `DestinationDir`=NULL, `FK_CommMethod`=NULL, `FK_DeviceCategory`='103', `FK_Distro`=NULL, `FK_InfraredGroup`=NULL, `FK_Licensing`=NULL, `FK_Manufacturer`='185', `FK_OperatingSystem`=NULL, `FK_Package`=NULL, `FK_PnpLevel`=NULL, `FK_StabilityStatus`=NULL, `FK_Users_Maintainer`='1', `HelpURL`=NULL, `IRFrequency`=NULL, `ImplementsDCE`='0', `InheritsMacFromPC`='0', `InternalURLSuffix`=NULL, `IsEmbedded`='0', `IsIPBased`='0', `IsPlugAndPlay`='0', `IsPlugIn`='0', `ManufacturerURL`=NULL, `PK_DeviceTemplate`='2231', `WizardURL`=NULL, `psc_frozen`=NULL, `psc_restrict`=NULL, psc_batch=3855, psc_user=39176 WHERE psc_id=2382
Transaction 0xbfa75ebc is open.  Rolling back
System error: Rolling back an incomplete transaction
Doing a rollback
Update threw exception: Failed to insert row

yes.

I mentioned this to TSCHAK last night and he said it might have something to do with some database changes that have been made recently

for starters, I would suggest configuring your internal device per the instructions:

http://wiki.linuxmce.org/index.php/Linksys_WRT54G

differences being - turning off the firewall and setting the IP address within the allowed range of LMCE (192.168.80.129-254 as std)

I am trying to find a template that Whateverfits has submitted and cannot find it.  The template uses manufacturer: Radio Thermostats and the description is: 3M50

I do not have the manufacturer in the manufacturer list. Possy confirmed that the Manufacturer exists in his list

I made sure my core was upto date - apt-get Update and Upgrade then

I did a sqlCVS Diff, reverted everything and did and "sqlCVS Update".

My understanding is that the templates should be upto date - am I doing something wrong?

Have you checked the template in or is it just 2254 in your setup?

Take a look at #2235, this is the template I created with Tschak's help, but since then I have been talking to Aviator.  See the wiki page http://wiki.linuxmce.org/index.php/Radio_Thermostat for some code snipets

Netflix working via Linux is news to me.  Using the computing menu to use it is fine. We do that already for many sites. I will have to try this

Iam using a Atom 330 ION as an MD in 1004

The Device Template was updated, submitted and approved with the two changes in this thread.  The DS9490R should work now with the stock template

Asram,

I use X10 (cheap - lights, outlets and PIR) and 1-wire (very cheap - temp and soon Humidity).  Do you own your condo? meaning are you willing to run structured wiring? Cat5e/6 around

Armor Gnome,
I don't use Nest but do use a Filtrete 3M-50 that I am trying to add support for  (it is cheaper and not as Apple-esque).

Anderson01,
What would you fit if you were just buying a normal alarm system?  think of what you would want to cover then apply that to LMCE.  PIR's, window/door sensors are all readily available in LMCE.  Add camera's, sirens, alerts via email and phone

In general, I like the ability to use sensors for multiple things - for instance PIR's are used for security and to trigger lighting.  Temp sensors help with heating system and (hopefully - when I work this out) fire alarms (if the sensor is over a certain temperature - FIRE!!!)

For TV's I specifically bought Sharp and LG with RS232 ports (from BestBuy ). Just did my research first and therefore did not need to ask the 'experts' anything

Thom,

unfortunately, most people are just going to buy stuff that suits their pockets and buy them from places like Best Buy or they have already got their equipement before deciding they want to take it to the next level.

Jamo,

Code:

I know CEC is poorly supported at present but it is an option

What do you mean?  CEC is in place on lots of HDMI equipment now but not neccesarily common codes - therefore DT's would need to be made for each device rather than each type of device (TV's, Blu-ray, PVR, Receiver).

I think support for a common, low cost 'USB-CEC injector' would be good step forward for LMCE.   

it would be great if they behaved very much like songs in an album

the one sensor that was disconnected was still appearing in the log on reboot - this is after the device was physically disconnected and shows that it is connected properly:

Code:

========== NEW LOG SECTION ==========
1 02/16/13 10:43:50 118 (spawning-device) Starting... 1
1 02/16/13 10:43:50 118 (spawning-device) Found /usr/pluto/bin/OneWire
01 02/16/13 10:43:51.543 TranslateSerialUSB pci0000:00/0000:00:12.0+1 result /dev/ttyUSB1 <0xb77506d0>
01 02/16/13 10:43:51.543 Opening port: /dev/ttyUSB1 <0xb77506d0>
05 02/16/13 10:43:52.164 Creating child 130 <0xb77506d0>
05 02/16/13 10:43:52.164 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77506d0>
05 02/16/13 10:43:52.165 Creating child 131 <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77506d0>
05 02/16/13 10:43:52.165 Creating child 132 <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77506d0>
05 02/16/13 10:43:52.165 Creating child 133 <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77506d0>
05 02/16/13 10:43:52.165 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77506d0>
05 02/16/13 11:39:31.712 Got a reload command from 0  <0xb61ffb70>
05 02/16/13 11:39:31.966 void ClientSocket::Disconnect() on this socket: 0x80b4350 (m_Socket: 7) <0xb77506d0>
Return code: 2
2 02/16/13 11:39:31 118 (spawning-device) Device requests restart... count=1/50 dev=118
Sat Feb 16 11:39:32 CST 2013 Restart

then after device 132 was deleted:

Code:

========== NEW LOG SECTION ==========
1 02/16/13 11:47:26 118 (spawning-device) Starting... 1
1 02/16/13 11:47:26 118 (spawning-device) Found /usr/pluto/bin/OneWire
01 02/16/13 11:47:26.321 TranslateSerialUSB pci0000:00/0000:00:12.0+1 result /dev/ttyUSB1 <0xb77a26d0>
01 02/16/13 11:47:26.321 Opening port: /dev/ttyUSB1 <0xb77a26d0>
05 02/16/13 11:47:26.708 Creating child 130 <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77a26d0>
05 02/16/13 11:47:26.709 Creating child 131 <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77a26d0>
05 02/16/13 11:47:26.709 Creating child 133 <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom event handler for.  It will not fire events. <0xb77a26d0>
05 02/16/13 11:47:26.709 Note: Device manager has attached a device of type 1946 that this has no custom handler for.  This is normal for IR. <0xb77a26d0>

it seems like it doesn't find the device.  When I installed them less than a week ago they were discovered almost immediately.

So I have 4 Temperature sensors installed in my 1-Wire network.

2 days back 1 was accidentally unplugged.  Since then the temperature has remained constant at the temp that was being reported - even after a reload and reboot.  what is the correct process for getting this to work again?

It is the JSON template I was asking about a few weeks ago in the IRC.  I have struggled with it and havent really got very far. Aviator had it working, cant find him though