search for: adaptive_odbc

Hello, I am struggling with what seems a common unresolved problem, changing the password from voicemailman when using a realtime engine (adaptive_odbc in my case, connected to mysql). I have seen messages dating back to 2007 with this problem and the last one was bug 5168, reported as closed, but without explaining the fix https://issues.asterisk.org/jira/browse/ASTERISK-5168?jql=text%20~%20%22voicemail%20password%22 Just to avoid confusion, I...

...ne except when the remote server is out of reach the calls zombie and eventually lead to a fault. The cli imply that the calls hang on SET(CDR_PROP(disable)=1) which is ironic since instructing the system not to connect to the cdr server appears to cause the problem and there may be a defect in the adaptive_odbc implementation where it somehow still communicates with the server during the cdr_func(disable). My experimentation suggests that the maria_odbc driver utilizes a single thread (there are odbc directives to adjust this - but it seems they have been superseded). Once a cdr hangs, new calls hang on o...

I tested this issue with version 13 and version 18. In res_odbc.conf, if I add a second, new data source like [asterisk] enabled=yes dsn=asterisk sanitysql => select 1 isolation => read_committed username=root ;password= pre-connect => yes forcecommit => yes connect_timeout => 10 negative_connection_cache => 0 max_connections =>500 my odbc.ini [cdr]