VoIP Mailing List Archives

[woodydickson at gmail.com]

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

[brian at freeswitch.org]

Did you configure with odbc? ./configure --enable-core-odbc-support

/b

On Aug 25, 2008, at 3:36 AM, Woody Dickson wrote:

[anthony.minessale at g...]

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@freeswitch.org (brian@freeswitch.org)> wrote:

[woodydickson at gmail.com]

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@gmail.com (anthony.minessale@gmail.com)> wrote:

[anthony.minessale at g...]

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@gmail.com (woodydickson@gmail.com)> wrote:

[woodydickson at gmail.com]

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@gmail.com (anthony.minessale@gmail.com)> wrote:

[anthony.minessale at g...]

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@gmail.com (woodydickson@gmail.com)> wrote: