Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: removed pooling since that is no longer handled by Asterisk


No Format
enabled => yes
dsn => your-configured-dsn-name
username => your-database-username
password => insecurepassword
pooling => no
limit => 1
pre-connect => yes

Then start up Asterisk and assuming res_odbc loads properly on the CLI you can use odbc show to verify connectivitya DSN is configured and shows up:

No Format
rnewton-office-lab*CLI> odbc show
ODBC DSN Settings
  Name:   asterisk
  DSN:    your-configured-dsn-name
    Last connection attempt: 1969-12-31 18:00:00
  Pooled: No
  Connected: Yes

To verify the connection works you should use func_odbc or something similar to query the data source from Asterisk.


If you don't have the odbc command at the CLI, check that