[OpenSIPS-Users] migrate DB from 1.8.2 DB to the 1.9.0

Dragomir Haralambiev goup2010 at gmail.com
Fri Feb 8 10:18:24 CET 2013 

Hi,

I copy rtpproxy-create.sql into usr/local/share/opensips. Now Opensips
start without problem.

Now 1.9.0 crash when execute rtpproxy_offer();

Here part of core dump:
Program terminated with signal 11, Segmentation fault.
#0  rtpp_get_var_svalue (msg=0xb7dd5128, param1=0x0, param2=0x0) at
rtpproxy.c:2350
2350		if (gp->type==GPARAM_TYPE_STR) {
(gdb) quit

The same Opensips cript work with 1.8.2 but when use 1.9.0 is crashed.

Any idea?




2013/2/8 Răzvan Crainea <razvan at opensips.org>:
> Hi, Dragomir!
>
> The problem is that in your opensips_1_9 configuration you have not included
> the 'db_mysql' module. That's why, when installing OpenSIPS 1.9, it doesn't
> even try to copy the mysql associated scripts. Therefore, the 1.9 schema is
> not installed on the system.
> Execute "make menuconfig" and enable the "db_mysql" module before the
> installation in order to fix this.
>
> Best regards,
>
> Razvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com
>
>
> On 02/07/2013 06:35 PM, Răzvan Crainea wrote:
>>
>> Hi!
>>
>> Can you please send me the output of the make install command? Perhaps it
>> would be better if you could send it directly to my email, as it is a quite
>> big output.
>>
>> Best regards,
>>
>> Razvan Crainea
>> OpenSIPS Core Developer
>> http://www.opensips-solutions.com
>>
>>
>> On 02/07/2013 06:32 PM, Dragomir Haralambiev wrote:
>>>
>>> I start from /opensips_1_9/scripts
>>>
>>>   ./opensipsdbctl migrate opensips_1_8 opensips_1_9
>>>
>>> database engine 'mysql' loaded
>>> INFO: Creating new Database opensips_1_9....
>>> INFO: test server charset
>>> INFO: creating database opensips_1_9 ...
>>> Creating core table: standard
>>> Creating core table: acc
>>> Creating core table: domain
>>> Creating core table: group
>>> Creating core table: permissions
>>> Creating core table: registrar
>>> Creating core table: usrloc
>>> Creating core table: msilo
>>> Creating core table: alias_db
>>> Creating core table: uri_db
>>> Creating core table: rtpproxy
>>> /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql: line 165:
>>> /usr/local/share/opensips//mysql/rtpproxy-create.sql: No such file or
>>> directory
>>> ERROR: Creating core tables failed!
>>>
>>>
>>> 2013/2/7 Răzvan Crainea<razvan at opensips.org>:
>>>>
>>>> Hi, Dragomir!
>>>>
>>>> You should use the opensipsdbctl tool of the new installation, not the
>>>> 1.8
>>>> one. That one should know how to locate the rtpproxy-create.sql file.
>>>>
>>>>
>>>> Best regards,
>>>>
>>>> Razvan Crainea
>>>> OpenSIPS Core Developer
>>>> http://www.opensips-solutions.com
>>>>
>>>>
>>>> On 02/07/2013 12:07 PM, Dragomir Haralambiev wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> Thanks for your quick replay.
>>>>>
>>>>>
>>>>> 2013/2/7 Răzvan Crainea<razvan at opensips.org>:
>>>>>>
>>>>>> Hi, Dragomir!
>>>>>>
>>>>>> Your 1.9.0 installation has overwritten the 1.8 one?
>>>>>
>>>>> No.
>>>>> I install 1.9.0 in new dir.
>>>>>
>>>>> Or you've installed it
>>>>>>
>>>>>> with a different prefix or something?
>>>>>> Do you have the nathelper-create.sql
>>>>>> instead?
>>>>>
>>>>> Yes I have nathelper-create.sql in to
>>>>> /usr/local/share/opensips//mysql/.
>>>>> Whe I start
>>>>> opensipsdbctl migrate opensips_1_8 opensips_1_9
>>>>> I se to missing rtpproxy-create.sql.
>>>>>
>>>>>
>>>>>> Can you execute "ls -la /usr/local/share/opensips//mysql/" and check
>>>>>> the
>>>>>> create time of the files?
>>>>>
>>>>> -rw-r--r-- 1 root root 1139 Feb  6 01:28 acc-create.sql
>>>>> -rw-r--r-- 1 root root  479 Feb  6 01:28 alias_db-create.sql
>>>>> -rw-r--r-- 1 root root  570 Feb  6 01:28 auth_db-create.sql
>>>>> -rw-r--r-- 1 root root  682 Feb  6 01:28 avpops-create.sql
>>>>> -rw-r--r-- 1 root root 1866 Feb  6 01:28 b2b-create.sql
>>>>> -rw-r--r-- 1 root root 1495 Feb  6 01:28 carrierroute-create.sql
>>>>> -rw-r--r-- 1 root root  668 Feb  6 01:28 closeddial-create.sql
>>>>> -rw-r--r-- 1 root root  328 Feb  6 01:28 cpl-create.sql
>>>>> -rw-r--r-- 1 root root 1218 Feb  6 01:28 dialog-create.sql
>>>>> -rw-r--r-- 1 root root  458 Feb  6 01:28 dialplan-create.sql
>>>>> -rw-r--r-- 1 root root  451 Feb  6 01:28 dispatcher-create.sql
>>>>> -rw-r--r-- 1 root root  322 Feb  6 01:28 domain-create.sql
>>>>> -rw-r--r-- 1 root root  410 Feb  6 01:28 domainpolicy-create.sql
>>>>> -rw-r--r-- 1 root root 1775 Feb  6 01:28 drouting-create.sql
>>>>> -rw-r--r-- 1 root root  720 Feb  6 01:28 group-create.sql
>>>>> -rw-r--r-- 1 root root  679 Feb  6 01:28 imc-create.sql
>>>>> -rw-r--r-- 1 root root  453 Feb  6 01:28 load_balancer-create.sql
>>>>> -rw-r--r-- 1 root root  589 Feb  6 01:28 msilo-create.sql
>>>>> -rw-r--r-- 1 root root  250 Feb  6 01:28 nathelper-create.sql
>>>>> -rw-r--r-- 1 root root  329 Feb  6 01:28 pdt-create.sql
>>>>> -rw-r--r-- 1 root root  453 Feb  6 01:28 permissions-create.sql
>>>>> -rw-r--r-- 1 root root 3176 Feb  6 01:28 presence-create.sql
>>>>> -rw-r--r-- 1 root root  628 Feb  6 01:28 registrant-create.sql
>>>>> -rw-r--r-- 1 root root  930 Feb  6 01:28 registrar-create.sql
>>>>> -rw-r--r-- 1 root root 1519 Feb  6 01:28 rls-create.sql
>>>>> -rw-r--r-- 1 root root  788 Feb  6 01:28 siptrace-create.sql
>>>>> -rw-r--r-- 1 root root  603 Feb  6 01:28 speeddial-create.sql
>>>>> -rw-r--r-- 1 root root  172 Feb  6 01:28 standard-create.sql
>>>>> drwxr-xr-x 6 root root 4096 Aug 15  2011 .svn
>>>>> -rw-r--r-- 1 root root  423 Feb  6 01:28 uri_db-create.sql
>>>>> -rw-r--r-- 1 root root  810 Feb  6 01:28 userblacklist-create.sql
>>>>> -rw-r--r-- 1 root root  949 Feb  6 01:28 usrloc-create.sql
>>>>>
>>>>>
>>>>>
>>>>>> Best regards,
>>>>>>
>>>>>> Razvan Crainea
>>>>>> OpenSIPS Core Developer
>>>>>> http://www.opensips-solutions.com
>>>>>>
>>>>>>
>>>>>> On 02/07/2013 11:43 AM, Dragomir Haralambiev wrote:
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> The OpenSips 1.8.2 is running.
>>>>>>> I isnatll 1.9.0 successfully (make clean, make all, make install)
>>>>>>> I not see rtpproxy-create.sql.
>>>>>>>
>>>>>>> Best regards,
>>>>>>> PlayMen
>>>>>>>
>>>>>>> 2013/2/7 Răzvan Crainea<razvan at opensips.org>:
>>>>>>>>
>>>>>>>> Hi, Dragomir!
>>>>>>>>
>>>>>>>> Have you installed opensips 1.9.0 before executing the command? Or
>>>>>>>> you
>>>>>>>> are
>>>>>>>> still running it on the old opensips 1.8 installation?
>>>>>>>>
>>>>>>>> Best regards,
>>>>>>>>
>>>>>>>> Razvan Crainea
>>>>>>>> OpenSIPS Core Developer
>>>>>>>> http://www.opensips-solutions.com
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 02/07/2013 08:37 AM, Dragomir Haralambiev wrote:
>>>>>>>>>
>>>>>>>>> Hello,
>>>>>>>>> I tru to migrate DB from 1.8.2 DB to the 1.9.0.
>>>>>>>>> I receive follow error:
>>>>>>>>>
>>>>>>>>> opensipsdbctl migrate opensips_1_8 opensips_1_9
>>>>>>>>> .........
>>>>>>>>> Creating core table: standard
>>>>>>>>> Creating core table: acc
>>>>>>>>> Creating core table: domain
>>>>>>>>> Creating core table: group
>>>>>>>>> Creating core table: permissions
>>>>>>>>> Creating core table: registrar
>>>>>>>>> Creating core table: usrloc
>>>>>>>>> Creating core table: msilo
>>>>>>>>> Creating core table: alias_db
>>>>>>>>> Creating core table: uri_db
>>>>>>>>> Creating core table: rtpproxy
>>>>>>>>> /usr/local/lib/opensips/opensipsctl/opensipsdbctl.mysql: line 165:
>>>>>>>>> /usr/local/share/opensips//mysql/rtpproxy-create.sql: No such file
>>>>>>>>> or
>>>>>>>>> directory
>>>>>>>>> ERROR: Creating core tables failed!
>>>>>>>>>
>>>>>>>>> Where is problem?
>>>>>>>>>
>>>>>>>>> BEst regards,
>>>>>>>>> PlayMen
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Users mailing list
>>>>>>>>> Users at lists.opensips.org
>>>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Users mailing list
>>>>>>>> Users at lists.opensips.org
>>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Users mailing list
>>>>>>> Users at lists.opensips.org
>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at lists.opensips.org
>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

More information about the Users mailing list