[Freeswitch-users] Mysql + ODBC shared database issue

[bhavik patel]

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 at gmail.com> wrote:

> Are you using a frontend or plain xml files
> On Jun 26, 2015 6:19 AM, "bhavik patel" <bhavikpatel14388 at 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 at 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 at 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 at 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 at 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 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
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Bhavik Patel
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Bhavik Patel
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at 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 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
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at 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 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
>



-- 
Thanks,
Bhavik Patel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150626/c6d8f991/attachment.html