[asterisk-users] ODBC connection pooling

[L S]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190304/ad988432/attachment.html>