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