We are still on Asterisk 1.8.18.

Updated to UnixODBC 2.3.7 and MySQL Connector/ODBC 8.0 to use the pooling
in UnixODBC. Asterisk runs smoothly with those, but it seems there is no
pooling; even though 'odbc show' displays 'Pooled: Yes' - Connections in
Use is always 1.

I just would like to know if odbc pooling is/was doable in Asterisk 1.8.18.
Res_odbc has settings like pooling, limit, share-connections, but not sure
if these apply to mysql odbc connections. (I know res_odbc went thru a lot
of changes since version 13 and pooling is pretty straightforward now, but
it will take us a while to upgrade.)

Anyway here is my configuration:

odbcinst.ini
[ODBC]
Pooling=Yes

[MySQL]
Driver=/usr/lib64/libmyodbc8w.so
FileUsage=1
CPTimeout=120


res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => passwd
pre-connect => yes
share-connections => no
limit => 5
pooling => yes

Thanks,
Matt
-- 
_____________________________________________________________________
-- 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

Reply via email to