Page 1 of 1
Cant connect to Domoticz after error in script
Posted: Friday 30 December 2016 22:26
by DutchTrickle
I've made a lua script that hangs on my Pi. The log told me it took more than 10 seconds to complete and now i cant connet to domoticz at all. Iver tried rebooting, but this still happens. Is there a way for me to boot domoticz with the scripts disabled? Or can i edit the scripts externally on a windows pc? (the script was made using the webinterface -> events -> lua).
Currently i cant logon to domoticz and json requests result in a timeout

Re: Cant connect to Domoticz after error in script
Posted: Friday 30 December 2016 22:31
by Egregius
Disable the script in the database using a SQL3lite tool like Adminer, SQLite explorer,...
Re: Cant connect to Domoticz after error in script
Posted: Friday 30 December 2016 22:57
by DutchTrickle
So, how do i do this?
I can loging using ssh. Can i copy the database fromt here an place it back? Or do i take the sdcard from my pi and put it in a different machine? What variable do i look for? I need a bit more explanation i'm afraid.
Re: Cant connect to Domoticz after error in script
Posted: Friday 30 December 2016 23:01
by Egregius
Use a sftp client like cyberduck, winscp, ...
stop domoticz
copy the database file
open it in a sqlite explorer
set Status = 0 in Eventmaster table
copy the database back
start domoticz
Re: Cant connect to Domoticz after error in script
Posted: Friday 30 December 2016 23:43
by DutchTrickle
thanks a lot. Worked perfectly.