[Freeswitch-users] Mysql + ODBC shared database issue

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