<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<br>
<div class="moz-cite-prefix">On 07/04/15 16:14, Andres wrote:<br>
</div>
<blockquote cite="mid:5523E640.6060804@telesip.net" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On 4/2/15 8:44 AM, Daniel-Constantin
Mierla wrote:<br>
</div>
<blockquote cite="mid:551D39C3.1040902@gmail.com" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<br>
<br>
<div class="moz-cite-prefix">On 02/04/15 14:29, Andres wrote:<br>
</div>
<blockquote cite="mid:551D363C.3070902@telesip.net" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On 4/1/15 11:10 PM, Alex Balashov
wrote:<br>
</div>
<blockquote
cite="mid:C04EA378-1047-4A5B-A121-C55957CD16BA@evaristesys.com"
type="cite">How complex is the SER configuration? SER
couldn't do that much, by the standards of the modern
feature set, so there may not be much to port. :-) <br>
</blockquote>
It is very simple. I am more concerned about the procedure to
migrate the thousands of mysql entries from one version to
another. If I have to write a script I will but before I do
that I wanted to check in an see if somebody has already done
it even if for an older version of Kamailio.<br>
</blockquote>
<br>
The database structure from ser 0.9.x is closer to current
kamailio database in many aspects than to ser 2.0. I don't know
what tables are you using, but subscriber, usr_preferences or
grp should be pretty compliant. Maybe you ca list here what
modules are you using.<br>
<br>
The location needs to changed, but that is something which fills
itself. You can first lower the max expires for registrar/usrloc
modules so you force phones to register more often. Then restart
with kamailio, and phones will register quickly after,
populating location table.<br>
<br>
Also, you need to set appropriate version values in 'version'
table.<br>
</blockquote>
We completed the upgrade and it was not that difficult. I was
indeed surprised to see that about 95% of our configuration file
worked unmodified. All we had to to was look at the error
messages and fix the syntaxes were applicable. Most were related
to rtpproxy or xlog statements.<br>
<br>
Regarding the mysql database, we simply started with the new
Kamailio schema. Then we went table by table and
added/deleted/renamed columns on the old schema so that it would
match the new one. We then exported the entries in the old
database with mysqldump and then imported them into the new
database. We were only working with 5 or 6 tables so it did not
take long either.<br>
</blockquote>
<br>
Glad to hear it went smooth -- maybe we should make a wiki page
about it, starting from your remarks, although there might not be
many ser instances running out there, could still be useful from
time to time..<br>
<br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>