[Freeswitch-users] Mysql + ODBC shared database issue

[bhavik patel]

Any suggestion ?

On Fri, Jun 26, 2015 at 4:43 PM, bhavik patel <bhavikpatel14388 at 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 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
>
>


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