Postgresql config

Comment on Asterisk voicemail database
tyaramis
Joined: Thu 23 of Apr, 2009

Re: Postgresql config

Posted:Thu 23 of Apr, 2009 (15:11 UTC)
Hi All
is there also a schema for MS-Sql server?
And also.. does anybody have an idea how can I configure asterisk voicemail to use ms sql database?
Thanks
Anonymous

Re: Postgresql config

Posted:Wed 21 of Jul, 2004 (20:26 UTC)
There is an error in the schema above. Please remove the NOT NULL clause from the pager column. Also, I recommend renaming the primary key index to voicemail_pk, though you may choose any name you like.
Anonymous

Postgresql config

Posted:Thu 24 of Jun, 2004 (17:22 UTC)
Here is the schema for the table in postgresql:

CREATE TABLE public.voicemail
(
context varchar(79) NOT NULL,
mailbox varchar(79) NOT NULL,
password varchar(79) NOT NULL,
fullname varchar(79) NOT NULL,
email varchar(79) NOT NULL,
pager varchar(79) NOT NULL,
options varchar(159),
stamp timestamp,
CONSTRAINT users_pk PRIMARY KEY (context, mailbox)
) WITHOUT OIDS;

Make sure the user asterisk uses to login with has rights to read the table.

To connect to the db, use the dboption keyword in the general section:
dboption=dbname=asteriskdb user=asteriskuser password=asteriskpw host=localhost port=5432

David
dfilion@dotality.com