Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] Storing voicemail in DB


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
woodydickson at gmail.com
Guest





PostPosted: Mon Aug 25, 2008 8:02 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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
Back to top
brian at freeswitch.org
Guest





PostPosted: Mon Aug 25, 2008 9:32 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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

/b

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

Quote:
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@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@freeswitch.org




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
anthony.minessale at g...
Guest





PostPosted: Mon Aug 25, 2008 10:22 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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:
Quote:
Did you configure with odbc? ./configure --enable-core-odbc-support

/b


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

Quote:
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




Quote:
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@freeswitch.org ([email]sip%3Abrian@freeswitch.org[/email])




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
woodydickson at gmail.com
Guest





PostPosted: Wed Aug 27, 2008 3:58 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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:
Quote:
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:
Quote:
Did you configure with odbc? ./configure --enable-core-odbc-support

/b


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

Quote:
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




Quote:
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@freeswitch.org ([email]sip%3Abrian@freeswitch.org[/email])




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Back to top
anthony.minessale at g...
Guest





PostPosted: Wed Aug 27, 2008 9:25 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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:
Quote:
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:
Quote:
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:
Quote:
Did you configure with odbc? ./configure --enable-core-odbc-support

/b


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

Quote:
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




Quote:
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@freeswitch.org ([email]sip%3Abrian@freeswitch.org[/email])




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
woodydickson at gmail.com
Guest





PostPosted: Wed Aug 27, 2008 9:55 pm    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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:
Quote:
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:
Quote:
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:
Quote:
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:
Quote:
Did you configure with odbc? ./configure --enable-core-odbc-support

/b


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

Quote:
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




Quote:
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@freeswitch.org ([email]sip%3Abrian@freeswitch.org[/email])




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Back to top
anthony.minessale at g...
Guest





PostPosted: Thu Aug 28, 2008 8:57 am    Post subject: [Freeswitch-users] Storing voicemail in DB Reply with quote

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:
Quote:
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:
Quote:
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:
Quote:
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:
Quote:
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:
Quote:
Did you configure with odbc? ./configure --enable-core-odbc-support

/b


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

Quote:
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




Quote:
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@freeswitch.org ([email]sip%3Abrian@freeswitch.org[/email])




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services