<div dir="ltr">What method did you use to determine that constant 1216188443 ?<br><br>The code that generates this stmt uses this template:<br><br>switch_snprintf(sql, sizeof(sql), "delete from sip_registrations where expires > 0 and expires <= %ld", (long) now);<br>
<br>'now' is the current time on the box. So when the phone registers we insert an exptime of current time + double the number of seconds specified as the expire time.<br><br>My only guess is the 2 box do not have the clock set right so when you register to one or the other the exp times are not synced.<br>
<br>Considering this is a nonstandard usage of FreeSWITCH by messing with the db underneath and not using it the way we are used to, and considering it's FREE and you are not paying for support. I prefer next time you send an email you do not open with some rhetoric about how miserable a time you had etc. Imagine how hard it was to write all this free code. You don't hear me complaining.......<br>
<br><br> <br><br><br><br><br><div class="gmail_quote">2008/7/17 Aadilkhan Maniyar <<a href="mailto:amaniyar@velankani.com">amaniyar@velankani.com</a>>:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div 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.<div><div></div><div class="Wj3C7c"><br>
<br>
Thanks & Regards,<br>
Aadil<br>
<br>
Aadilkhan Maniyar wrote:
<blockquote type="cite">
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 type="cite">
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 type="cite">
<pre>Brian West wrote:
</pre>
<blockquote type="cite">
<pre>On Jun 18, 2008, at 1:11 AM, Aadilkhan Maniyar wrote:
</pre>
<blockquote type="cite">
<pre>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>Correct this is just a way to access odbc from Spidermonkey.
</pre>
<blockquote type="cite">
<pre>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>Do you see any errors during startup? Does isql work with your dsn?
</pre>
<blockquote type="cite">
<pre>Brian West wrote:
</pre>
<blockquote type="cite">
<pre>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>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 href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</pre>
</blockquote>
<pre><hr size="4" width="90%">
_______________________________________________
Freeswitch-users mailing list
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
<div>-- <br>
<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><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, </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Electronics</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">City</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, Phase –
II, <br>
</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Hosur Road</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Bangalore</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> – 560
100. </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">India</span></font><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" target="_blank"><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/" target="_blank"><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;"></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><hr size="4" width="90%">
_______________________________________________
Freeswitch-users mailing list
<a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank">Freeswitch-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
<div>-- <br>
<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><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, </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Electronics</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">City</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, Phase –
II, <br>
</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Hosur Road</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">, </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">Bangalore</span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;"> – 560
100. </span></font><font color="navy" face="Tahoma" size="1"><span style="font-size: 8.5pt; font-family: Tahoma; color: navy;">India</span></font><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" target="_blank"><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/" target="_blank"><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;"></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>
</div></div></div>
<br>_______________________________________________<br>
Freeswitch-users mailing list<br>
<a href="mailto:Freeswitch-users@lists.freeswitch.org">Freeswitch-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
<br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400
</div>