<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks for the input guys...<br>
<br>
I have set the odbc-dsn in the internal.xml file under the sip_profiles
directory.<br>
The dsn works fine with isql. Also there are no errors while FS starts
up.<br>
<br>
I got the schema for the tables like sip_registrations,
sip_subscriptions etc from the file sofia_glue.c.<br>
Now I have created a view for the sip_registrations in the OpenSER
database and also created the other tables.<br>
<br>
Let us see how things work... :)<br>
<br>
Thanks & Regards,<br>
Aadil<br>
<br>
John Skopis (Lists) wrote:
<blockquote cite="mid:4859CBD5.5080601@skopis.com" type="cite">
<pre wrap="">Brian West wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Jun 18, 2008, at 1:11 AM, Aadilkhan Maniyar wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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?.
</pre>
</blockquote>
<pre wrap="">Correct this is just a way to access odbc from Spidermonkey.
</pre>
<blockquote type="cite">
<pre wrap="">
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.
</pre>
</blockquote>
<pre wrap="">Do you see any errors during startup? Does isql work with your dsn?
</pre>
<blockquote type="cite">
<pre wrap="">Brian West wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->
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
<a class="moz-txt-link-abbreviated" href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
</body>
</html>