I’ve go Asterisk v11.15 with Realtime Database (ODBC - Postgresql).
If database goes down o restarts, Asterisk reconnects to database and reads info such as Queue configuration, sippeers, agents defined on Queue, etc…
However, Asterisk does not save to the CDR table anymore.
show odbc all shows “Connected: Yes”
If I reload with
module reload res_odbc.so it still doesn’t save CDR info.
I have to restart Asterisk.
Is there any other way to recover from this situation?
` enabled => yes
dsn => asterisk-connector username => xxxxx password => xxxxx pre-connect => yes pooling => no limit => 5
[asterisk-connector] Description = PostgreSQL connection to 'asterisk' database Driver = PostgreSQL Database = xxxxxxx Servername = xxxxxxx UserName = xxxxx Password = xxxxx Port = 5432 Protocol = 8.1 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings =