[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.
That is great to know.  I remember when SER 2.0 came out I was totally 
put off by the massive changes.  I am happy to hear the Kamailio schema 
is not that different from 0.9.6.  I have not taken a look at it yet but 
will do so shortly.

The modules we are running are:

loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/nathelper.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/group.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so"
loadmodule "/usr/local/lib/ser/modules/xlog.so"
loadmodule "/usr/local/lib/ser/modules/domain.so"
loadmodule "/usr/local/lib/ser/modules/lcr.so"
loadmodule "/usr/local/lib/ser/modules/avp.so"
loadmodule "/usr/local/lib/ser/modules/permissions.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"

I must add that to this day I continue to be totally impressed with the 
SIP Express Router.  Our servers have processed hundreds of millions of 
calls since 2003 and SER has practically never missed a beat.

Thanks.
>
> 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.
>
> 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/20150402/03cfcf0e/attachment.html>