<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Rodrigo,<br>
<br>
Of course you can use any combination of SQL backends - when you
define the db_url for a module, just select the db backend you
want for it.<br>
<br>
Now, the timer error you get here is related to the SQLite - I
noticed in one of your more recent posts that you get an error
from sqlite on locking the location table - this blocking of the
table may prevent opensips to write into the table - and the
writing in the location table is timer based. So, the timer complains
on getting blocked.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 13.05.2016 15:53, Rodrigo Pimenta
Carvalho wrote:<br>
</div>
<blockquote
cite="mid:BY2PR02MB16557ED40162B71456FD125EB5740@BY2PR02MB1655.namprd02.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<div> <br>
Dear OpenSIPS-users,<br>
<br>
In my project I'm using SQLite as database for OpenSIPS,
Everything is going well for several tables. That is, OpenSIPS
works very well to handle several tables from my SQLite data
base. Except for table location, as I suspect.<br>
<br>
What is the problem?<br>
------------------------------<br>
After receiving "SIP REGISTER" messages for a time, OpenSIPS
shows a warning in the log:<br>
"<span>WARNING:core:timer_ticker: timer task <ul-timer>
already schedualed f...verlap..</span>"<br>
<br>
<br>
How can I reproduce the problem?<br>
-----------------------------------------------<br>
I just let only one softphone (client) online sending SIP
REGISTER to my OpenSIPS, one message at each minute. Only one
client is enough to cause the problem. And there is no calls
at all.<br>
<br>
<br>
What I'm suspecting?<br>
-----------------------------<br>
I suspect that when OpenSIPS receives the SIP REGISTER it has
to handle the table location. And then the proxy does it
successfully for a number of SIP REGISTER. But, after a time,
probably there is some error while handling the location via
SQLite, and it causes the issue. I suspect that if I stop
using DB_SQLite for keep users locations, the problem will
disappear (finish).
<br>
<br>
<br>
What I intend to do?<br>
------------------------------<br>
I intend to use DB_Text every time OpenSIPS will need to save
user locations. But I still want to continue using DB_SQLite
for other data.<br>
<br>
<br>
Can I use DB_Text and DB_SQLite in the same script or such
thing will cause problems for sure?<br>
P.S.: I'm using OpenSIPS 2.2 from october/november 2015.<br>
<br>
Any hint will be very helpful!<br>
Best regards.<br>
<br>
<br>
<br>
</div>
RODRIGO PIMENTA CARVALHO<br>
<div id="Signature">
<div name="divtagdefaultwrapper"
style="font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>