Ok, you use the MS SQL. It's problem of FreeTDS implementation details.
1. Did you install FreeTDS or other ODBC driver to MS SQL(Sybase)
connecting?
2. Did you configure unixODBC to use freeTDS driver (etc\odbc.ini,
etc\odbcinst.ini)?
3. APPLY the patch that I tell you before
( http://bugs.digium.com/view.php?id=7451 )
4. Rebuild and reinstall the Asterisk
Then asterisk will be be able to react on the ODBC configuration
parameters "pooled" and "poolsize".
Regards,
Dmitry V.Furmanov
Hi Dmitry
Thanks for that. Yes, I had done all of that and have a working Asterisk <-> MS SQL setup where I have a view for the voicemail.conf settings in my database + I have a separate table called 'voicemessages' to store my voicemails. What I wanted to know was that if I have got this far with Release 1.2.9.1, do I need any more patches OR bug fixes that I need to apply to 1.2.9.1 to avoid the FreeTDS issue? What about the settings mentioned in Issue: 5756 by 'kryptolus' to have
pooled => yes
poolsize => 10 (or whatever)
to your res_odbc.conf ? Do I need this?
Also, is this stable? The usage of ODBC storage to store voicemails? Are you
running this in production?
Thanks
\R
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dmitry Furmanov
Sent: Monday, July 03, 2006 7:50 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] performance & reliabulity of asterisk voicemail
using odbc storage
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.
_______________________________________________
--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
