Thanks for the input guys... I have set the odbc-dsn in the internal.xml file under the sip_profiles directory. The dsn works fine with isql. Also there are no errors while FS starts up. I got the schema for the tables like sip_registrations, sip_subscriptions etc from the file sofia_glue.c. Now I have created a view for the sip_registrations in the OpenSER database and also created the other tables. Let us see how things work... :) Thanks & Regards, Aadil John Skopis (Lists) wrote:
Brian West wrote:
On Jun 18, 2008, at 1:11 AM, Aadilkhan Maniyar wrote:
Thanks for the reply Brian.
So what you mean to say is that I need not configure mod_spidermonkey_odbc at all in order to store registration data in the MySQL database?.
Correct this is just a way to access odbc from Spidermonkey.
If I configure FS with --enable-core-odbc and set the /odbc-dsn/ parameter in one of the sip profile xml, i should be able to store the registrations in the MySQL database.
Do you see any errors during startup? Does isql work with your dsn?
Brian West wrote:
Considering that mod_spidermonkey_odbc isn't for this that would explain why that wasn't working.
You need to configure freeswitch with --enable-core-odbc-support
In addition to what Brian said you need to configure FS to use the odbc dsn. grep in the conf dir: grep -RHin dsn *
to see how.
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org