Recent Posts

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

try doing an sqlCVS update via the command line:

Code:

/usr/pluto/bin/sqlCVS -H schema.linuxmce.org -R 3999 -U anonymous~anonymous -r dce update

-Thom

Works for me! 

I do recall there being an error on submission due to my failure to update my instance before checking in and it caused a conflict. In case that helps.

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

You did sqlCVS update all repos, didn't you

Hi Guys

Thought you might be interested in this product:

http://www.fxitech.com/cotton-candy/what-is-it/

Its basically i PC in a flash drive size enclosure using a usb port for power and has hdmi output, bluetooth and wifi built in.

  Argh! All is now well. Thanks Techstyle. You were correct and the wiki supplied the answer.  I can now grab my laptop and IP address 192.168.80.129 accesses the internal router. 192.168.1.1 accesses the external router. Problem solved.

Twodogs (embarrassed)

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'm trying to correctly set up two wireless networks with two WRT54GS routers. The first is external to LMCE , so that my wife can always log on regardless of what I'm doing with LCME. The second is the internal LMCE network. I have this partially working, but I always get locked out of the the web-based configuration utility of the LMCE router. If I need to get in, then I have to hit the button that resets it to factory. Seems like I'm doing something wrong. Here is my network configuration:

-DSL Modem
-WRT54GS external, set up as router ( DHCP server enabled, wireless chan 1, IP 192.168.1.1, with its own SSID and security password)
-LMCE Core
-WRT54GS internal, set up as wireless access point (DHCP server disabled, wireless chan 11, IP 192.168.1.2, with its own SSID and security password)

I thought this was the correct way to configure the network, but it behaves strangely.  I can connect my laptop to the internal wireless network and surf the web just fine, but when I try to enter the configuration utility I get "Firefox can't establish a connection to the server at 192.168.1.2." So I turn off the wireless on the laptop and connect via cable. Again I can surf the web just fine, but I get the same error when trying to connect to the WRT54G.

Now I check to see if I can access the external router from the internal network. I thought that this might not work because if could be invisible behind the LMCE core. I enter 192.168.1.1 and get right in to the config utility of the external router.  This blows my mind.

So the bottom line is that I can reach the configuration utility of the external router (set up as a DHCP enabled router) from either the internal or external network. I can't reach the config utility of the internal WRT54GS (set up as DHCP disabled WAP) from either the internal or external network until I do a factory reset and dump my config.

This differs from my expectations. I thought that, to reach the external WRT54GS, I'd have to connect to the external network and enter 192.168.1.1. Then to reach the internal WRT54GS, I'd have to connect to the internal network and enter 192.168.1.2.

Can any smart guys show me the error of my ways?

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?