IVR in language french is't possible Asterisk 1004

[hanafi]

my dcerouter



Query failed (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=16 (1) <0x6a5bab70>
01   01/09/13 16:57:51.195      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6a5bab70>
01   01/09/13 16:57:51.206      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=16 (1) <0x6afbbb70>
01   01/09/13 16:57:51.206      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.107      Query failed (MySQL server has gone away): UPDATE Device SET Status='TRIPPED',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x6afbbb70>
01   01/09/13 16:57:52.107      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.107      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.107      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:52.107      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.107      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:52.157      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:52.157      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.353      Query failed (MySQL server has gone away): UPDATE Device SET Status='TRIPPED',psc_mod=psc_mod WHERE PK_Device=53 (1) <0x6afbbb70>
01   01/09/13 16:57:52.353      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.353      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.353      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=53] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:52.353      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:52.353      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:52.403      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:52.403      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:53.918      Query failed (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)): SELECT PK_Device,FK_DeviceCategory,FK_DeviceTemplate,FK_Device_ControlledVia FROM Device JOIN DeviceTemplate ON FK_DeviceTemplate=PK_DeviceTemplate LEFT JOIN Device_DeviceData ON FK_Device=PK_Device AND FK_DeviceData=195 WHERE FK_DeviceCategory IN (155,158,59,144,165,166) AND (IK_DeviceData IS NULL OR IK_DeviceData<>0) (1) <0x83fe3b70>
01   01/09/13 16:57:53.918      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:53.918      Query failed (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)): DELETE `pluto_media`.File FROM `pluto_media`.File LEFT JOIN `pluto_main`.Device ON EK_Device=PK_Device WHERE EK_Device IS NOT NULL AND EK_Device>0 AND PK_Device IS NULL (1) <0x83fe3b70>
01   01/09/13 16:57:53.918      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:53.968      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:53.968      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.431      Query failed (MySQL server has gone away): SELECT PK_Device,FK_DeviceCategory,FK_DeviceTemplate,FK_Device_ControlledVia FROM Device JOIN DeviceTemplate ON FK_DeviceTemplate=PK_DeviceTemplate LEFT JOIN Device_DeviceData ON FK_Device=PK_Device AND FK_DeviceData=195 WHERE FK_DeviceCategory IN (155,158,59,144,165,166) AND (IK_DeviceData IS NULL OR IK_DeviceData<>0) (1) <0x83fe3b70>
01   01/09/13 16:57:54.431      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:54.431      Query failed (MySQL server has gone away): DELETE `pluto_media`.File FROM `pluto_media`.File LEFT JOIN `pluto_main`.Device ON EK_Device=PK_Device WHERE EK_Device IS NOT NULL AND EK_Device>0 AND PK_Device IS NULL (1) <0x83fe3b70>
01   01/09/13 16:57:54.431      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:54.481      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:54.481      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.547      Query failed (MySQL server has gone away): UPDATE Device SET Status='NORMAL',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x6afbbb70>
01   01/09/13 16:57:54.547      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.548      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.548      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.548      Query failed (MySQL server has gone away): UPDATE Device SET State=',,',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x6afbbb70>
01   01/09/13 16:57:54.548      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.548      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.548      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.548      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.548      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.598      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:54.598      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.638      Query failed (MySQL server has gone away): UPDATE Device SET Status='NORMAL',psc_mod=psc_mod WHERE PK_Device=53 (1) <0x6afbbb70>
01   01/09/13 16:57:54.638      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.638      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.638      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=53] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.639      Query failed (MySQL server has gone away): UPDATE Device SET State=',,',psc_mod=psc_mod WHERE PK_Device=53 (1) <0x6afbbb70>
01   01/09/13 16:57:54.639      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.639      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.639      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=53] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.639      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:54.639      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] MySQL server has gone away reconnect: 0 result2: -1 <0x6afbbb70>
01   01/09/13 16:57:54.688      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:54.688      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:57:55.754      Query failed (MySQL server has gone away): SELECT PK_Device,FK_DeviceCategory,FK_DeviceTemplate,FK_Device_ControlledVia FROM Device JOIN DeviceTemplate ON FK_DeviceTemplate=PK_DeviceTemplate LEFT JOIN Device_DeviceData ON FK_Device=PK_Device AND FK_DeviceData=195 WHERE FK_DeviceCategory IN (155,158,59,144,165,166) AND (IK_DeviceData IS NULL OR IK_DeviceData<>0) (1) <0x83fe3b70>
01   01/09/13 16:57:55.754      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:55.754      Query failed (MySQL server has gone away): DELETE `pluto_media`.File FROM `pluto_media`.File LEFT JOIN `pluto_main`.Device ON EK_Device=PK_Device WHERE EK_Device IS NOT NULL AND EK_Device>0 AND PK_Device IS NULL (1) <0x83fe3b70>
01   01/09/13 16:57:55.754      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x83fe3b70>
01   01/09/13 16:57:55.804      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x6afbbb70>
01   01/09/13 16:57:55.804      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x6afbbb70>
01   01/09/13 16:58:01.457      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=16 (1) <0x4ebf1b70>
01   01/09/13 16:58:01.457      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x4ebf1b70>
01   01/09/13 16:58:01.457      Query failed (MySQL server has gone away): UPDATE Device SET Registered=1,psc_mod=psc_mod WHERE PK_Device=16 (1) <0x4ebf1b70>
01   01/09/13 16:58:01.457      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x4ebf1b70>
01   01/09/13 16:58:11.457      Query failed (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)): SELECT FK_Device_ControlledVia FROM Device WHERE PK_Device=16 (1) <0x8f3f5b70>
01   01/09/13 16:58:11.458      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x8f3f5b70>
01   01/09/13 16:58:11.458      Query failed (MySQL server has gone away): SELECT IK_DeviceData FROM Device_DeviceData WHERE FK_Device=16 AND FK_DeviceData=133 (1) <0x8f3f5b70>
01   01/09/13 16:58:11.458      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x8f3f5b70>
01   01/09/13 16:58:16.746      Query failed (MySQL server has gone away): UPDATE Device SET Status='TRIPPED',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x69bb9b70>
01   01/09/13 16:58:16.746      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:16.746      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:16.746      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x69bb9b70>
01   01/09/13 16:58:16.746      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:16.746      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] MySQL server has gone away reconnect: 0 result2: -1 <0x69bb9b70>
01   01/09/13 16:58:16.796      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x69bb9b70>
01   01/09/13 16:58:16.796      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Query failed (MySQL server has gone away): UPDATE Device SET Status='NORMAL',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x69bb9b70>
01   01/09/13 16:58:23.156      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x69bb9b70>
01   01/09/13 16:58:23.156      Query failed (MySQL server has gone away): UPDATE Device SET State=',,',psc_mod=psc_mod WHERE PK_Device=54 (1) <0x69bb9b70>
01   01/09/13 16:58:23.156      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Table_Device::FetchRow Cannot perform query [select * from Device where `PK_Device`=54] MySQL server has gone away reconnect: 0 result2: -1 <0x69bb9b70>
01   01/09/13 16:58:23.156      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 16:58:23.156      Table_Datapoints::Commit Cannot perform query [insert into Datapoints (`PK_Datapoints`, `Datapoint`, `FK_Unit`, `EK_Device`, `timestamp`) values (0, 1.000000, 9, 54, "2013-01-09 16:57:52")] MySQL server has gone away reconnect: 0 result2: -1 <0x69bb9b70>
01   01/09/13 16:58:23.206      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x69bb9b70>
01   01/09/13 16:58:23.206      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x69bb9b70>
01   01/09/13 17:00:11.454      AirPlay_PlugIn::Starting up... <0xb77598e0>
01   01/09/13 17:00:16.410      Starting Hulu_Plugin::Register() <0xb77598e0>
01   01/09/13 17:00:16.410      Registered device 2102 <0xb77598e0>
01   01/09/13 17:00:16.411      AirPlay_PlugIn::Register() <0xb77598e0>
01   01/09/13 17:00:16.412      AirPlay_PlugIn::Registered device media player <0xb77598e0>
01   01/09/13 17:00:36.413      Bad room <0x8d7f5b70>
01   01/09/13 17:00:36.414      Bad room <0x8d7f5b70>
01   01/09/13 17:02:54.344      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:02:58.146      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:02:59.025      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:04.856      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:05.380      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:06.604      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:08.612      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:14.769      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:15.389      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:16.610      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:16.807      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:18.372      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:19.220      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:30.553      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:30.679      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:32.981      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:35.018      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:36.271      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:41.541      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:42.293      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:43.521      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:45.281      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:51.016      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:55.830      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:03:58.516      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:00.128      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:04.494      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:05.173      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:08.555      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:10.332      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:13.802      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:14.964      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:15.965      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:16.025      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:17.023      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:18.291      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:19.815      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:21.654      MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 7 PK_AttributeType 30 string sName * PK_Attribute_Related 0 size 1 <0x823e3b70>
01   01/09/13 17:04:38.015      Extension =  OR CONCAT(AreaCode, PhoneNumber) =  OR PhoneNumber =  <0x691e6b70>
01   01/09/13 17:04:38.016      Extension = 0625600041 OR CONCAT(AreaCode, PhoneNumber) = 0625600041 OR PhoneNumber = 0625600041 <0x691e6b70>
01   01/09/13 17:04:38.016      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.056      Extension =  OR CONCAT(AreaCode, PhoneNumber) =  OR PhoneNumber =  <0x691e6b70>
01   01/09/13 17:04:38.056      Extension = 0625600041 OR CONCAT(AreaCode, PhoneNumber) = 0625600041 OR PhoneNumber = 0625600041 <0x691e6b70>
01   01/09/13 17:04:38.056      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.096      Extension =  OR CONCAT(AreaCode, PhoneNumber) =  OR PhoneNumber =  <0x691e6b70>
01   01/09/13 17:04:38.096      Extension = 0625600041 OR CONCAT(AreaCode, PhoneNumber) = 0625600041 OR PhoneNumber = 0625600041 <0x691e6b70>
01   01/09/13 17:04:38.106      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.136      Extension =  OR CONCAT(AreaCode, PhoneNumber) =  OR PhoneNumber =  <0x691e6b70>
01   01/09/13 17:04:38.137      Extension = 0625600041 OR CONCAT(AreaCode, PhoneNumber) = 0625600041 OR PhoneNumber = 0625600041 <0x691e6b70>
01   01/09/13 17:04:38.137      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.422      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.432      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.462      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.472      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.482      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.492      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.513      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>
01   01/09/13 17:04:38.533      Received message type: 1 id: 741 from: 11 going to an empty device list md: 0 cat: 0 <0xa3bf8b70>

[cfernandes]

mysql server is not running  try to start  then  and view messages  for corrupted databases

[hanafi]

after restart mysql here is log


Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x4f7fcb70>
01   01/09/13 17:18:37.747      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x4f7fcb70>
01   01/09/13 17:18:41.322      Query failed (MySQL server has gone away): UPDATE Device SET Status='TRIPPED',psc_mod=psc_mod WHERE PK_Device=53 (1) <0x4f7fcb70>
01   01/09/13 17:18:41.348      Query failed (): UPDATE Device SET Status='TRIPPED',psc_mod=psc_mod WHERE PK_Device=53 retry: 1 <0x4f7fcb70>

how ican view error database or table
i am not an expert of linux sorry

[cfernandes]

try this

/etc/init.d/mysql start   (enter)


mysql  (enter)

this show  mysql prompt like this

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[hanafi]

ok
but how i can see what wrong in database ?

[cfernandes]

the mysql server is started, show prompt ?

[cfernandes]

to repair database use this command

mysqlcheck --all-databases --auto-repair --check --optimize

[hanafi]

i am in mysql
what command i do ?

[hanafi]

here what response mysql

mysql> mysqlcheck --all-databases --auto-repair --check --optimize
    -> mysqlcheck --all-databases --auto-repair --check --optimize;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thacorresponds to your MySQL server version for the right syntax to use near 'myscheck --all-databases --auto-repair --check --optimize
mysqlcheck --all-dat' at line 1
mysql>

[hanafi]

ok
I typed the command and no thing happened here is my log

Router::PingFailed 0x9d4620d8 Incoming_Conn Socket 109 ::ffff:127.0.0.1 dev 40 40 <0x86bdbb70>
01   01/09/13 18:19:52.487      Connect failed Unknown database 'pluto_media' <0xb77218e0>
01   01/09/13 18:19:52.487      Cannot connect to database! <0xb77218e0>
01   01/09/13 18:19:52.488      Cannot initialize plug-in for device: 4 <0xb77218e0>
01   01/09/13 18:19:52.711      Connect failed Unknown database 'pluto_media' <0xb77218e0>
01   01/09/13 18:19:52.711      Cannot connect to database! <0xb77218e0>
01   01/09/13 18:19:52.712      Cannot initialize plug-in for device: 9 <0xb77218e0>
01   01/09/13 18:19:52.758      Connect failed Unknown database 'pluto_media' <0xb77218e0>
01   01/09/13 18:19:52.758      Cannot connect to database! <0xb77218e0>
01   01/09/13 18:19:52.759      Cannot initialize plug-in for device: 10 <0xb77218e0>
01   01/09/13 18:19:53.143      AirPlay_PlugIn::Starting up... <0xb77218e0>
01   01/09/13 18:19:53.231      Cannot find sister plugins to file grids <0xb77218e0>
01   01/09/13 18:19:53.231      Cannot find sister plugins to climate plugin <0xb77218e0>
01   01/09/13 18:19:53.231      Cannot find sister plugins to ir plugin <0xb77218e0>
01   01/09/13 18:19:53.231      Cannot find sister plugins to lighting plugin <0xb77218e0>
01   01/09/13 18:19:53.231      Cannot find sister plugins to telecom plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to security plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to pnp plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to xine plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to picture plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to myth plugin <0xb77218e0>
01   01/09/13 18:19:53.232      Starting Hulu_Plugin::Register() <0xb77218e0>
01   01/09/13 18:19:53.232      Cannot find sister plugins to Hulu plugin <0xb77218e0>
01   01/09/13 18:19:53.232      AirPlay_PlugIn::Register() <0xb77218e0>
01   01/09/13 18:19:53.232      AirPlay_PlugIn::Cannot find sister plugins <0xb77218e0>

[hanafi]

I think that my server died?

[cfernandes]

you need to run this command on linux prompt  not in mysql console

after reboot your core

[hanafi]

yes it is what I have make

[hanafi]

and here my dcerouter.log after reboot

Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x8bbebb70>
01   01/09/13 19:06:22.403      Query failed (MySQL server has gone away): UPDATE Device SET Registered=0,psc_mod=psc_mod WHERE PK_Device=-1003 (1) <0x8bbebb70>
01   01/09/13 19:06:22.403      Connect failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) <0x8bbebb70>
01   01/09/13 19:08:30.879      Connect failed Unknown database 'pluto_media' <0xb77298e0>
01   01/09/13 19:08:30.879      Cannot connect to database! <0xb77298e0>
01   01/09/13 19:08:30.881      Cannot initialize plug-in for device: 4 <0xb77298e0>
01   01/09/13 19:08:31.165      Connect failed Unknown database 'pluto_media' <0xb77298e0>
01   01/09/13 19:08:31.166      Cannot connect to database! <0xb77298e0>
01   01/09/13 19:08:31.167      Cannot initialize plug-in for device: 9 <0xb77298e0>
01   01/09/13 19:08:31.239      Connect failed Unknown database 'pluto_media' <0xb77298e0>
01   01/09/13 19:08:31.239      Cannot connect to database! <0xb77298e0>
01   01/09/13 19:08:31.240      Cannot initialize plug-in for device: 10 <0xb77298e0>
01   01/09/13 19:08:31.831      AirPlay_PlugIn::Starting up... <0xb77298e0>
01   01/09/13 19:08:32.050      Cannot find sister plugins to file grids <0xb77298e0>
01   01/09/13 19:08:32.050      Cannot find sister plugins to climate plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to ir plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to lighting plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to telecom plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to security plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to pnp plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to xine plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to picture plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to myth plugin <0xb77298e0>
01   01/09/13 19:08:32.051      Starting Hulu_Plugin::Register() <0xb77298e0>
01   01/09/13 19:08:32.051      Cannot find sister plugins to Hulu plugin <0xb77298e0>
01   01/09/13 19:08:32.051      AirPlay_PlugIn::Register() <0xb77298e0>
01   01/09/13 19:08:32.051      AirPlay_PlugIn::Cannot find sister plugins <0xb77298e0>

[hanafi]

I think that my database died