[SR-Users] Upgrade from Sip Express Router 0.9.6

[Andres]

On 4/2/15 8:44 AM, Daniel-Constantin Mierla wrote:
>
>
> On 02/04/15 14:29, Andres wrote:
>> On 4/1/15 11:10 PM, Alex Balashov wrote:
>>> 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. :-)
>> 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.
>
> 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.
>
> 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.
>
> Also, you need to set appropriate version values in 'version' table.
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.

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.

Thanks.
>
> Cheers,
> Daniel
>>
>> Thanks.
>>>
>>> On 1 April 2015 22:58:14 GMT-04:00, Andres <andres at telesip.net> wrote:
>>>
>>>     How would one even approach the daunting task of upgrading a fully
>>>     operational Sip Express Router 0.9.6 installation with thousands of
>>>     users that has been running unmodified for over 10 years.
>>>
>>>     I would like some pointers on how to approach the mysql database
>>>     migration from the old schema to the Kamailio 4.2 schema.  I sure hope I
>>>     don't have to start from scratch.  Maybe somebody has already done an
>>>     upgrade script?
>>>
>>>     Regarding the config file, I will certainly have to rewrite it but I was
>>>     wondering if there was a list of deprecated commands or syntaxes that
>>>     would no longer be valid and their equivalent replacement.
>>>
>>>     Thanks,
>>>
>>>
>>> --
>>> Alex Balashov | Principal | Evariste Systems LLC
>>> 303 Perimeter Center North, Suite 300
>>> Atlanta, GA 30346
>>> United States
>>>
>>> Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
>>> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>>>
>>> Sent from my Nexus 10. 
>>
>>
>> -- 
>> Technical Support
>> http://www.cellroute.net
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> -- 
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda  -http://www.linkedin.com/in/miconda
> Kamailio World Conference, May 27-29, 2015
> Berlin, Germany -http://www.kamailioworld.com


-- 
Technical Support
http://www.cellroute.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150407/7c9c3d20/attachment.html>