Oh! I'm sorry. :*)
You are right - it's about freeTDS problem. Just for case of the MS SQL
storage usage.
You need to configure the Asterisk and unixODBC. Read, please next
listed articles:
http://www.asteriskguru.com/tutorials/realtime_pgsql.html (it's for
Postgre SQL. You need use driver of your selected DB service appropriate
ODBC driver)
STORAGE SIDE CONFIGURATION
Configuration of the table (my case - MS SQL):
/* Voicemail storage creating*/
CREATE TABLE asterisk.dbo.voicemessages
(
id int IDENTITY NOT NULL,
msgnum bigint DEFAULT NULL,
dir varchar(80) DEFAULT NULL,
context varchar(80) DEFAULT NULL,
macrocontext varchar(80) DEFAULT NULL,
callerid varchar(40) DEFAULT NULL,
origtime varchar(40) DEFAULT NULL,
duration varchar(20) DEFAULT NULL,
mailboxuser varchar(80) DEFAULT NULL,
mailboxcontext varchar(80) DEFAULT NULL,
recording image DEFAULT NULL,
PRIMARY KEY (id, dir)
);
/*And grant all access to this table to your asterisk ODBC user (must be
previously created)
In my case it's "asterisk" */
GRANT ALL ON asterisk.dbo.voicemessages TO asterisk;
Syntax:
GRANT ALL ON <DB name>.dbo.<table name> TO asterisk;
<DB name>, <table name> can be configured on the Asterisk-server side
read "doc\README.odbcstorage" file from Asterisk source for details of
the Voicemail configuration.
And don't forget uncomment the lines:
CFLAGS+=-DUSE_ODBC_STORAGE
CFLAGS+=-DEXTENDED_ODBC_STORAGE
inside apps\Makefile of the Asterisk sources before rebuild and
reinstall the asterisk with voicemail DB storage support.
Regards,
Dmitry V.Furmanov.
Hi Dmitry,
Thanks so much for replying, I had a read of the bug descriptions you pointed to but unfortunately am not a programmer so have a bit of a struggle following the entire discussion. I actually AM using 1.2.9.1. So does that mean that I should be OK and do not need any patches as this release has all of them, or does it mean that I still need to apply some patch that's in issue: 5756? Also, I do not know how to apply patches, can you help?
These bug reports also seem to mention issues that you seem to have with
FreeTDS and those issues are resolved by configuring connection pooling. Is
this what this particular patch fixed?
Thanks,
\R
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dmitry Furmanov
Sent: Monday, July 03, 2006 6:15 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] performance & reliabulity of asterisk voicemail
using odbc storage
Hi, RR:
Asterisk 1.2.1 with listed in
http://bugs.digium.com/bug_view_page.php?bug_id=5756
patch have some problems with voicemail storage, but that problems already
fixed in the more newer version.
I'll advice you to try using 1.2.9.1 version with the same patch that I'd
applied to it (see http://bugs.digium.com/view.php?id=7451 )
I guess that other voicemail DB storage configuration is known for you.
Regards,
Dmitry V.Furmanov
Hello all,
Newbie here, been searching the net to follow the development and
feedback on the 1.2 release feature with using an odbc storage for
storing the voicemail messages etc.? Have many people
implemented/tried this? Any feedback? Is this better than using a
clustered file system such as GFS or PVFS etc? I was going to
implement the storage using GFS but if I can do it reliably with
storing them in a database then maybe it's better? I don't know much
about storage or databases so not sure if storing in a clustered
database which is connected to a SAN via high-performance HBAs is better than using a clustered file system.
Any comments about all of this vis-à-vis reliability of the
implementation of odbc storage feature in asterisk + comments about DB
storage better/worse than a clustered file-system would be greatly appreciated.
Thank you all,
\R
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
