[Freeswitch-users] Storing voicemail in DB
Anthony Minessale
anthony.minessale at gmail.com
Thu Aug 28 09:55:20 EDT 2008
Here is the one I have setup:
-- /etc/odbc.ini
[freeswitch]
Description = MySQL ODBC Driver Testing
Driver = MySQL
Socket =
Server = localhost
User = myuser
Password = mypass
Database = test
Option =
Port = 3306
Stmt =
and the param in my FS config.
<param name="odbc-dsn" value="freeswitch:myuser:mypass"/>
On Wed, Aug 27, 2008 at 9:52 PM, Woody Dickson <woodydickson at gmail.com>wrote:
> 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
>>
>>
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080828/407d97b2/attachment-0001.html
More information about the Freeswitch-users
mailing list