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
CPTimeout0

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