<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1250"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Guys,<br>
<br>
Well my last query was unanswered. I hope this time round some one can
clear my doubts.<br>
<br>
After a lot of debugging and some very miserable days, I was able to
pin point the root cause of the problem. <br>
<br>
It turns out that FreeSwtich regularly queries the database and
deletes the entries in the sip_registrations tables whose expires value
is > 0 and < 1216188443.<br>
<br>
I would like to know the number 1216188443 (looks like a random number
to me), where is it derived from.<br>
Also why is there such a behavior wherein the FS deletes database
entries at regular intervals.<br>
<br>
Thanks & Regards,<br>
Aadil<br>
<br>
Aadilkhan Maniyar wrote:
<blockquote cite="mid:4861D87D.2060409@velankani.com" type="cite">
<meta content="text/html;charset=windows-1250"
http-equiv="Content-Type">
<title></title>
Hi All,<br>
<br>
I gave this a shot. And it works. But I am facing a unique issue.<br>
<br>
What I have done is created a view called sip_registrations for FS from
the schema for location table in OpenSER. (For details please refer my
earlier mails)<br>
Now when I register a user, the registration is successfully done. I am
able to see the entry in the database.<br>
<br>
But when I again execute a SQL query to display the registrations done,
nothing is displayed. Somehow the registrations are being deleted.<br>
<br>
I have set the registration timeout as 3600 in the UA. So there is no
way the UA is sending a de-register. Also in the traces I do not see
any de-register message being sent. <br>
I have observed this peculiar behaviour only when OpenSER and FS are
sharing the database. If I run only OpenSER the database entries are
not being deleted.<br>
<br>
Could it be possible that FS is for some reason deleting the entries in
the database? Can anyone please help me out here.<br>
<br>
Thanks & Regards,<br>
Aadil <br>
<br>
Aadilkhan Maniyar wrote:
<blockquote cite="mid:4859FED2.5070903@velankani.com" type="cite">
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
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 moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
Freeswitch-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title></title>
<b><font color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;">Velankani
Software Pvt. Ltd</span></font></b><font color="blue" face="Tahoma"
size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: blue;">.</span></font><br>
<p class="MsoNormal" style=""><b><font color="navy" face="Tahoma"
size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;"></span></font></b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">43, <st1:place
u1:st="on"><st1:placename u1:st="on"></st1:placename></st1:place></span></font><st1:place><st1:placename><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Electronics</span></font></st1:placename></st1:place><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> <st1:placetype
u1:st="on"></st1:placetype></span></font><st1:placetype><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">City</span></font></st1:placetype><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, Phase –
II, <br>
</span></font><st1:address><st1:street><font color="navy"
face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"><st1:address
u1:st="on"><st1:street u1:st="on">Hosur Road</st1:street></st1:address></span></font></st1:street><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, <st1:city
u1:st="on"></st1:city></span></font><st1:city><font color="navy"
face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Bangalore</span></font></st1:city></st1:address><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> – 560
100. <st1:country-region u1:st="on"><st1:place u1:st="on"></st1:place></st1:country-region></span></font><st1:country-region><st1:place><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">India</span></font></st1:place></st1:country-region><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">.<br>
T: +91 80 4037 5757<br>
M: +91 9886798572<br>
E-mail:</span></font><font color="#0080c0" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: rgb(0, 128, 192);">
</span></font><font color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"><a
moz-do-not-send="true" href="mailto:mkumar@velankani.com"><font
color="#0080c0"><span style="color: rgb(0, 128, 192);">amaniyar@velankani.com</span></font></a><br>
URL: </span></font><font color="blue"><span style="color: blue;"><a
moz-do-not-send="true" href="http://www.velankani.com/"
title="http://www.velankani.com/"><font face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma;"><span
title="http://www.velankani.com/"><span
title="http://www.velankani.com/">www.velankani.com</span></span></span></font></a></span></font><b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;"><o:p></o:p></span></font></b></p>
<font color="blue" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: blue;">"</span></font><b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;">Every
Customer is a Reference Customer"</span></font></b>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>
<br>
<div class="moz-signature">-- <br>
<title></title>
<b><font color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;">Velankani
Software Pvt. Ltd</span></font></b><font color="blue" face="Tahoma"
size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: blue;">.</span></font><br>
<p class="MsoNormal" style=""><b><font color="navy" face="Tahoma"
size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;"></span></font></b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">43, <st1:place
u1:st="on"><st1:placename u1:st="on"></st1:placename></st1:place></span></font><st1:place><st1:placename><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Electronics</span></font></st1:placename></st1:place><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> <st1:placetype
u1:st="on"></st1:placetype></span></font><st1:placetype><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">City</span></font></st1:placetype><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, Phase –
II, <br>
</span></font><st1:address><st1:street><font color="navy" face="Tahoma"
size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"><st1:address
u1:st="on"><st1:street u1:st="on">Hosur Road</st1:street></st1:address></span></font></st1:street><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, <st1:city
u1:st="on"></st1:city></span></font><st1:city><font color="navy"
face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Bangalore</span></font></st1:city></st1:address><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> – 560
100. <st1:country-region u1:st="on"><st1:place u1:st="on"></st1:place></st1:country-region></span></font><st1:country-region><st1:place><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">India</span></font></st1:place></st1:country-region><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;">.<br>
T: +91 80 4037 5757<br>
M: +91 9886798572<br>
E-mail:</span></font><font color="#0080c0" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: rgb(0, 128, 192);">
</span></font><font color="navy" face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma; color: navy;"><a
href="mailto:mkumar@velankani.com"><font color="#0080c0"><span
style="color: rgb(0, 128, 192);">amaniyar@velankani.com</span></font></a><br>
URL: </span></font><font color="blue"><span style="color: blue;"><a
href="http://www.velankani.com/" title="http://www.velankani.com/"><font
face="Tahoma" size="1"><span
style="font-size: 8.5pt; font-family: Tahoma;"><span
title="http://www.velankani.com/"><span
title="http://www.velankani.com/">www.velankani.com</span></span></span></font></a></span></font><b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;"><o:p></o:p></span></font></b></p>
<font color="blue" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: blue;">"</span></font><b><font
color="navy" face="Tahoma" size="1"><span
style="font-size: 9pt; font-family: Tahoma; color: navy; font-weight: bold;">Every
Customer is a Reference Customer"</span></font></b>
</div>
</body>
</html>