[Asterisk-Users] performance & reliabulity of asterisk voicemail using odbc storage

[RR]

Hi Dmitry,

just to answer your questions, and telling you what I've done so far,

1) yes, using FreeTDS
2) yes, configured unixODBC with FreeTDS to talk to MSSQL. I have all of
this working where I can load and update tables in MSSQL using the "realtime
load/update" statements from the Asterisk CLI.
3) I have downloaded and patched the files apps/voicemail.c,
res/res_config_odbc.c and include/asterisk/res_odbc.h (FYI: during patching
the last file, it did say that the patch terminated unexpectedly in the
middle of the line even and then followed by saying Hunk #24 succceeded)

4) rebuilt and reinstalled Asterisk 1.2.9.1
5) added pooled and poolsize lines to res_odbc.conf and also added "Pooling
= Yes" and "CPTimeout = 120" in the odbcinst.ini as per instructions on the
FreeTDS site.

Is this all I need to do to fix the problems you've seen in Asterisk talking
to MSSQL? Is there anything else I should know?

Also, do you have any idea why I can't seem to load any content from my
MSSQL database when I use a "view" instead of a "table"? when I use a table
for vmusers for e.g. then it works but it doens't when I sue a view.

Thanks
\R

On 7/3/06, Dmitry Furmanov <D.Furmanov at ua.fm> wrote:
>
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060703/cad7b0a2/attachment.htm