Summary:	ASTERISK-00559: [patch] for app_directory to support PostgreSQL voicemail
Reporter:	dhollis (dhollis)	Labels:
Date Opened:	2003-11-21 17:06:22.000-0600	Date Closed:	2011-06-07 14:05:19
Priority:	Major	Regression?	No
Status:	Closed/Complete	Components:	Applications/app_directory
Versions:		Frequency of Occurrence
Related Issues:
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.