On 07/04/15 16:14, Andres wrote: > 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.
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.. Cheers, Daniel -- 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
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
