You should be able to define multiple data sources. However I'm having my own issues. I have my dialplan accessing one maria database which is hosted locally on the asterisk server then logging cdr with odbc adaptive which connects to maria on a remote machine. This works fine 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 odbc calls to the local database.
In my case the remote server is 5' away and in the same switch that Asterisk is plugged into, so it hasn't been critical to fix this - but it may provide some clues to your situation. On Thu, Aug 17, 2023 at 11:04 AM Federico <feder...@digitalipvoice.com> wrote: > 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] > > Description = MySQL ODBC Driver Testing > > Driver = maria > > Socket = /var/run/mysqld/mysqld.sock > > User = root > > Password = > > Database = public > > Option = 3 > > > > > > I get, immediately, segmentation fault. > > With only one, it works fine. > > Is this by design? > > > > Philip > > > > > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: > https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users