[Freeswitch-users] Mysql + ODBC shared database issue

[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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150626/5c5e7f19/attachment-0001.html