[Freeswitch-users] Mysql + ODBC shared database issue

Luis Daniel Lucio Quiroz luis.daniel.lucio at gmail.com
Fri Jun 26 15:10:44 MSD 2015


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


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list