|Summary:||ASTERISK-00559: [patch] for app_directory to support PostgreSQL voicemail|
|Date Opened:||2003-11-21 17:06:22.000-0600||Date Closed:||2011-06-07 14:05:19|
|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.|
****** ADDITIONAL INFORMATION ******
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.