LinuxMCE Forums
General => Users => Topic started by: hanafi on January 08, 2013, 10:33:55 pm
-
is't possible to make IVR in language French
-
Yes is possible !
Foxi was finished scripts that make possible french and german languages.
the script to create is generate_users_voicemenu.pl
cfernandes
-
hi CFernandes
when i execute a script it give me this
Generating speech for invalid IVR entries.
Text 2172: Your selection is not valid, please try again.
and i don't see where i can make french option
thank you
-
the language selection is made on lmce-admin
on instalation
Language settings
Telecom default voice language
-
i change language from web admin ans make script but it give me a same error
in french language this time!
and hen i call home i get no thing
-
this is response from script
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for invalid IVR entries.
Text 2172: Votre sélection n'est pas valable, veuillez réessayer s'il vous plait.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
dcerouter_1033114:/usr/pluto/bin# ./generate_users_voicemenu.pl
Generating speech for IVR Main Menu (language: 2).
Text 2173: Merci pour votre appel.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Text 2168: Si vous connaissez l'extension de la personne à appeler, vous pouvez l'entrer à tout moment.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Text 2167: Pour appeler tout le monde dans la maison, tapez 0.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Text 2169: Pour laisser un message, tapez dièse.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for Hanafi extension: 301
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Hanafi, tapez 1.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for Nadia extension: 302
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Nadia, tapez 2.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for Kami extension: 303
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Kami, tapez 3.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for Mansour extension: 304
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Mansour, tapez 4.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for Taleb extension: 305
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Taleb, tapez 5.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
Generating speech for invalid IVR entries.
Text 2172: Votre sélection n'est pas valable, veuillez réessayer s'il vous plait.
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter: No such file or directory
-
your instalation is updated ?
-
install mbrola and mbrola-fr4
-
hello CFernandes
yes my installation is update and mbrola mbrola-fr4 are installed
but when i apply a script iget an error :
sh: /usr/share/mbrola/lia_phon/script/lia_text2mbrola: /bin/csh: bad interpreter
try later
-
apt-get install csh
-
hi again
i reboot my core and now i have another probleme orbiter can't load
is't a probleme with script generate_user_voicemunu.sh ?
-
I do not believe that this script can interfere with loading orbiter
-
I am blocked :o ???
-
check DCErouter.log
-
i install csh
Generating speech for IVR Main Menu (language: 2).
Text 2173: Merci pour votre appel.
Text 2168: Si vous connaissez l'extension de la personne à appeler, vous pouvez l'entrer à tout moment.
Text 2167: Pour appeler tout le monde dans la maison, tapez 0.
Text 2169: Pour laisser un message, tapez dièse.
Generating speech for Hanafi extension: 301
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Hanafi, tapez 1.
Generating speech for Nadia extension: 302
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Nadia, tapez 2.
Generating speech for Kami extension: 303
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Kami, tapez 3.
Generating speech for Mansour extension: 304
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Mansour, tapez 4.
Generating speech for Taleb extension: 305
Text 2170: Pour appeler
Text 2171: , tapez
Result: Pour appeler Taleb, tapez 5.
Generating speech for invalid IVR entries.
Text 2172:
Generating speech for invalid IVR entries.
Text 2172: try again
what means Text 2172
-
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>
-
mysql server is not running try to start then and view messages for corrupted databases
-
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
-
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>
-
ok
but how i can see what wrong in database ?
-
the mysql server is started, show prompt ?
-
to repair database use this command
mysqlcheck --all-databases --auto-repair --check --optimize
-
i am in mysql
what command i do ?
-
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>
-
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>
-
I think that my server died?
-
you need to run this command on linux prompt not in mysql console
after reboot your core
-
yes it is what I have make
-
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>
-
I think that my database died >:(
-
any idea ?
-
A forum is no chat system. If you want faster responses, go visit the #linuxmce channel at freenode - or click the chat button above.
-
excuse me
and thank you for all your help