Mysql + ODBC shared database issue
Hi All, I have some wired thing happen,not sure its an issue OR bug. I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working. But after sometime my database server was crashed and i lost my database. Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname". Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error. After change to proper odbc-dsn parameter not showing any error but not able to create table again. I also tried like restart freeswitch many times no luck. My freeswitch version (Both server same ) : FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit) Please suggest me what i am doing wrong. -- Thanks, Bhavik Patel
I have been searching for a way to get the b-leg disposition of a call to handle messaging for calls such as unallocated_number but I am having no success. I have set continue_on_fail=true and hangup_after_bridge=false so I can look at the originate_disposition after the bridge either is successful or fails. Everything I read points to this not being possible, does anyone know if this is not possible or is there another way. When we call our gateway to an unallocated_number it returns 404, but I cannot seem to get access to this message to play the proper instructions to the end user, but the ip phone does get a 404, however, users are not sip savvy so I need to interrupt this to play a message before disconnect. Darcy Primrose voice2net corp
if you use those vars and put the info app after the bridge line it will dump vars to the log for you to inspect and find what you are looking for On Friday, June 26, 2015, Darcy Primrose <fs@voice2net.ca> wrote:
I have been searching for a way to get the b-leg disposition of a call to handle messaging for calls such as unallocated_number but I am having no success. I have set continue_on_fail=true and hangup_after_bridge=false so I can look at the originate_disposition after the bridge either is successful or fails. Everything I read points to this not being possible, does anyone know if this is not possible or is there another way.
When we call our gateway to an unallocated_number it returns 404, but I cannot seem to get access to this message to play the proper instructions to the end user, but the ip phone does get a 404, however, users are not sip savvy so I need to interrupt this to play a message before disconnect.
Darcy Primrose voice2net corp
sounds like your db is corrupt. if you use a new db does it work? On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
Yes i uploaded new DB but still ODBC not able to generate tables in My database. Can you please tell me how to debug it ? Do i need to recompile freeswitch with enable ODBC flag ? On Fri, Jun 26, 2015 at 10:59 AM, Michael Jerris <mike@jerris.com> wrote:
sounds like your db is corrupt. if you use a new db does it work?
On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
Opps, I forgot to configure <param name="odbc-dsn" value="odbc://dsn:username:password"/> in the sip-profile. But now issue is like my 2 FS server try to accessing same DB table like registration. Now issue with internal calls. Now let's take a example. FS1 : 192.168.1.13 FS2 : 192.168.1.14 I am trying internal call. User1 is register on .13 server and call comes in .14 via (Load balacing), call is not originating. My bridge dial string is like *user/User1@$$domain_name*. What's wrong. I am managing registration using share database but still no luck. Any suggestion or help is appreciate. On Fri, Jun 26, 2015 at 11:08 AM, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Yes i uploaded new DB but still ODBC not able to generate tables in My database.
Can you please tell me how to debug it ?
Do i need to recompile freeswitch with enable ODBC flag ?
On Fri, Jun 26, 2015 at 10:59 AM, Michael Jerris <mike@jerris.com> wrote:
sounds like your db is corrupt. if you use a new db does it work?
On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
-- Thanks, Bhavik Patel
Are you using a frontend or plain xml files On Jun 26, 2015 6:19 AM, "bhavik patel" <bhavikpatel14388@gmail.com> wrote:
Opps, I forgot to configure
<param name="odbc-dsn" value="odbc://dsn:username:password"/> in the sip-profile.
But now issue is like my 2 FS server try to accessing same DB table like registration. Now issue with internal calls.
Now let's take a example.
FS1 : 192.168.1.13 FS2 : 192.168.1.14
I am trying internal call.
User1 is register on .13 server and call comes in .14 via (Load balacing), call is not originating.
My bridge dial string is like *user/User1@$$domain_name*.
What's wrong. I am managing registration using share database but still no luck.
Any suggestion or help is appreciate.
On Fri, Jun 26, 2015 at 11:08 AM, bhavik patel <bhavikpatel14388@gmail.com
wrote:
Yes i uploaded new DB but still ODBC not able to generate tables in My database.
Can you please tell me how to debug it ?
Do i need to recompile freeswitch with enable ODBC flag ?
On Fri, Jun 26, 2015 at 10:59 AM, Michael Jerris <mike@jerris.com> wrote:
sounds like your db is corrupt. if you use a new db does it work?
On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
yes using front end and mod_xml_curl module. On Fri, Jun 26, 2015 at 4:40 PM, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
Are you using a frontend or plain xml files On Jun 26, 2015 6:19 AM, "bhavik patel" <bhavikpatel14388@gmail.com> wrote:
Opps, I forgot to configure
<param name="odbc-dsn" value="odbc://dsn:username:password"/> in the sip-profile.
But now issue is like my 2 FS server try to accessing same DB table like registration. Now issue with internal calls.
Now let's take a example.
FS1 : 192.168.1.13 FS2 : 192.168.1.14
I am trying internal call.
User1 is register on .13 server and call comes in .14 via (Load balacing), call is not originating.
My bridge dial string is like *user/User1@$$domain_name*.
What's wrong. I am managing registration using share database but still no luck.
Any suggestion or help is appreciate.
On Fri, Jun 26, 2015 at 11:08 AM, bhavik patel < bhavikpatel14388@gmail.com> wrote:
Yes i uploaded new DB but still ODBC not able to generate tables in My database.
Can you please tell me how to debug it ?
Do i need to recompile freeswitch with enable ODBC flag ?
On Fri, Jun 26, 2015 at 10:59 AM, Michael Jerris <mike@jerris.com> wrote:
sounds like your db is corrupt. if you use a new db does it work?
On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
Any suggestion ? On Fri, Jun 26, 2015 at 4:43 PM, bhavik patel <bhavikpatel14388@gmail.com> wrote:
yes using front end and mod_xml_curl module.
On Fri, Jun 26, 2015 at 4:40 PM, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
Are you using a frontend or plain xml files On Jun 26, 2015 6:19 AM, "bhavik patel" <bhavikpatel14388@gmail.com> wrote:
Opps, I forgot to configure
<param name="odbc-dsn" value="odbc://dsn:username:password"/> in the sip-profile.
But now issue is like my 2 FS server try to accessing same DB table like registration. Now issue with internal calls.
Now let's take a example.
FS1 : 192.168.1.13 FS2 : 192.168.1.14
I am trying internal call.
User1 is register on .13 server and call comes in .14 via (Load balacing), call is not originating.
My bridge dial string is like *user/User1@$$domain_name*.
What's wrong. I am managing registration using share database but still no luck.
Any suggestion or help is appreciate.
On Fri, Jun 26, 2015 at 11:08 AM, bhavik patel < bhavikpatel14388@gmail.com> wrote:
Yes i uploaded new DB but still ODBC not able to generate tables in My database.
Can you please tell me how to debug it ?
Do i need to recompile freeswitch with enable ODBC flag ?
On Fri, Jun 26, 2015 at 10:59 AM, Michael Jerris <mike@jerris.com> wrote:
sounds like your db is corrupt. if you use a new db does it work?
On Friday, June 26, 2015, bhavik patel <bhavikpatel14388@gmail.com> wrote:
Hi All,
I have some wired thing happen,not sure its an issue OR bug.
I was created MYSQL ODBC connection for 2 freeswitch server which have shared database and configure odbc-dsn in db.conf.xml file and its was working.
But after sometime my database server was crashed and i lost my database.
Once by database server back,Now when ever i run "reload mod_db" OR "reload mod_sofia" its not connecting ODBC database, but still i am accessible using "isql -v dbname".
Also if i change odbc-dsn in configuration file and do wrong configuration then showing error like not connecting "[unixODBC][MySQL][ODBC 5.1 Driver]Access denied" error.
After change to proper odbc-dsn parameter not showing any error but not able to create table again.
I also tried like restart freeswitch many times no luck.
My freeswitch version (Both server same ) :
FreeSWITCH Version 1.4.15+git~20141229T185951Z~507a0f22c5~64bit (git 507a0f2 2014-12-29 18:59:51Z 64bit)
Please suggest me what i am doing wrong.
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
-- Thanks, Bhavik Patel
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
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
-- Thanks, Bhavik Patel
-- Thanks, Bhavik Patel
participants (4)
-
bhavik patel
-
Darcy Primrose
-
Luis Daniel Lucio Quiroz
-
Michael Jerris