Summary:ASTERISK-00559: [patch] for app_directory to support PostgreSQL voicemail
Reporter:dhollis (dhollis)Labels:
Date Opened:2003-11-21 17:06:22.000-0600Date Closed:2011-06-07 14:05:19
Versions:Frequency of
Environment:Attachments:( 0) app_directory-pgsql.patch
Description:If the voicemail application is configured to use postgres (or mysql for that matter), the mailbox configuration is not in the voicemail.conf, which is where app_directory gets it's information.  The attached patch allows the directory to query the 'voicemail' table in postgres to do directory matches.


No additional configuration is required, if the Makefile is configured to use postgres voicemail, app_directory will adjust accordingly.
Comments:By: Brian West (bkw918) 2003-11-21 21:44:35.000-0600

Please include setup docs and such.

By: dhollis (dhollis) 2003-11-22 08:50:19.000-0600

All that is required for this functionality to operate is to set USE_POSTGRES_VM_INTERFACE=1  in the apps/Makefile.  This will build app_voicemail and app_directory with Postgres support.  The voicemail entries will be read from the voicemail table in the asterisk database.  The connection string in /etc/asterisk/voicemail.conf is in the [general] section in this format:
dboption=dbname=mydatabase user=myuser password=mypass

By: Brian West (bkw918) 2003-11-28 21:59:18.000-0600

care if I take this and write app_directory thats unixODBC aware?

By: dhollis (dhollis) 2003-11-29 10:01:44.000-0600

Go for it.  Not a bad way to approach it so that almost boilerplate code doesn't have to duped for each DB type out there.

By: Olle Johansson (oej) 2004-04-13 13:47:58

Closing bug, we can't continue adding various SQL api:s into source tree. New database architecture being designed elsewhere. Patch and bug stays in archive, but now closed.