[Freeswitch-users] Storing voicemail in DB

Woody Dickson woodydickson at gmail.com
Wed Aug 27 19:52:21 PDT 2008


Hi

The error that I am getting is :

2008-08-28 19:04:41 [CRIT] switch_odbc.c:248 db_is_up() The sql server is
not responding for DSN fsdb [STATE: 24000 CODE 0 ERROR:
[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.0.32-Debian_7etch6]Invalid
cursor state

I am sure fsdb is correct as I can do the following:

isql fsdb fs password
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

Any idea why the DNS fsdb does not work within Freeswitch?

Thanks,
Woody



On Wed, Aug 27, 2008 at 10:23 PM, Anthony Minessale <
anthony.minessale at gmail.com> wrote:

> are you mixing modules.conf modules.conf.xml
>
> modules.conf in the dir you type make from MUST have mod_voicemail enabled.
>
> /usr/local/freeswitch/conf/autoload_configs/modules.conf.xml is where you
> can comment out mod_voicemail
> so you can load it manually from the CLI once FS is started and see if
> there are any errors.
>
> be sure to press f8 first
>
> if you are upgrading from previous versions and having trouble, you may
> want to
> mv /usr/local/freeswitch /usr/local/freeswitch.bak and then do "make
> current vm-sync" from the build root.
>
>
>
>
>
>
> On Wed, Aug 27, 2008 at 3:56 AM, Woody Dickson <woodydickson at gmail.com>wrote:
>
>> Hi,
>>
>> When typing in "load mod_voicemail ", I am getting the following error:
>>
>> 2008-08-28 01:05:42 [CRIT] switch_loadable_module.c:757
>> switch_loadable_module_load_file() Error Loading module
>> /usr/local/freeswitch/mod/mod_voicemail .so
>> **/usr/local/freeswitch/mod/mod_voicemail .so: cannot open shared object
>> file: No such file or directory**
>>
>> If I start Freeswitch with mod_voicemail loaded, I don't get that error.
>>
>> But the error that I did get when starting Freeswitch is the following:
>>
>> 2008-08-28 01:09:29 [NOTICE] switch_loadable_module.c:353
>> switch_loadable_module_process() Adding Chat interface 'sip'
>> 2008-08-28 01:09:29 [NOTICE] switch_loadable_module.c:393
>> switch_loadable_module_process() Adding Management interface 'mod_sofia'
>> OID[.1.3.6.1.4.1.27880.1]
>> 2008-08-28 01:09:30 [ERR] switch_core_sqldb.c:95
>> switch_core_db_persistant_execute_trans() SQL ERR [database is locked]
>>
>> I don't know where this error comes come.  It seems to happen after I
>> upgrade to the latest build.  I still don't know how to fix it and what kind
>> of impact it brings to the system.
>>
>> Is this the reason why Freeswitch does not store the voicemail detail in
>> DB?
>>
>> Btw, I did configure odbc with  ./configure --enable-core-odbc-support
>>
>> I would appreciate any help in getting my voicemail setting to work.
>>
>> Thanks,
>> Woody
>>
>>
>>
>> On Mon, Aug 25, 2008 at 11:17 PM, Anthony Minessale <
>> anthony.minessale at gmail.com> wrote:
>>
>>> comment the line in your modules.conf.xml that loads mod_voicemail
>>> then start freeswitch
>>> then set the loglevel to debug by pressing f8
>>> then enter load mod_voicemail into the cli
>>>
>>> the resulting text should clarify the problem.
>>>
>>>
>>>
>>> On Mon, Aug 25, 2008 at 9:27 AM, Brian West <brian at freeswitch.org>wrote:
>>>
>>>> Did you configure with odbc?  ./configure --enable-core-odbc-support
>>>>
>>>> /b
>>>>
>>>> On Aug 25, 2008, at 3:36 AM, Woody Dickson wrote:
>>>>
>>>> > Hi,
>>>> >
>>>> > I am new to Freeswitch.  After playing with it for a couple of
>>>> > weeks, I have to say Freeswitch is GREAT!
>>>> >
>>>> > Right now I am kind of stuck on getting voicemail info to be stored
>>>> > in mysql.
>>>> >
>>>> > I have defined the following in voicemail.conf.xml:
>>>> >
>>>> >       <param name="odbc-dsn" value="fsdb:fs:password"/>
>>>> >
>>>> >
>>>> > And I am sure my odbc is ok, as I have validated it with isql:
>>>> >
>>>> > /usr/src/freeswitch-snapshot# isql fsdb fs password
>>>> > +---------------------------------------+
>>>> > | Connected!                            |
>>>> > |                                       |
>>>> > | sql-statement                         |
>>>> > | help [tablename]                      |
>>>> > | quit                                  |
>>>> > |                                       |
>>>> > +---------------------------------------+
>>>> >
>>>> > Is there anything wrong with my setting?
>>>> >
>>>> >
>>>> > Tks,
>>>> > Woody
>>>> >
>>>> >
>>>> > _______________________________________________
>>>> > Freeswitch-users mailing list
>>>> > Freeswitch-users at lists.freeswitch.org
>>>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> > UNSUBSCRIBE:
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> > http://www.freeswitch.org
>>>>
>>>> Brian West
>>>> sip:brian at freeswitch.org <sip%3Abrian at freeswitch.org>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Freeswitch-users mailing list
>>>> Freeswitch-users at lists.freeswitch.org
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> http://www.freeswitch.org
>>>>
>>>
>>>
>>>
>>> --
>>> Anthony Minessale II
>>>
>>> FreeSWITCH http://www.freeswitch.org/
>>> ClueCon http://www.cluecon.com/
>>>
>>> AIM: anthm
>>> MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
>>> IRC: irc.freenode.net #freeswitch
>>>
>>> FreeSWITCH Developer Conference
>>> sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
>>> iax:guest at conference.freeswitch.org/888
>>> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
>>> pstn:213-799-1400
>>>
>>> _______________________________________________
>>> Freeswitch-users mailing list
>>> Freeswitch-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>>
>>
>> _______________________________________________
>> Freeswitch-users mailing list
>> Freeswitch-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
>
> --
> Anthony Minessale II
>
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
> iax:guest at conference.freeswitch.org/888
> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
> pstn:213-799-1400
>
> _______________________________________________
> Freeswitch-users mailing list
> Freeswitch-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080828/9af3444b/attachment-0002.html 


More information about the FreeSWITCH-users mailing list