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

Răzvan Crainea razvan at opensips.org
Fri Feb 8 10:08:47 CET 2013 

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

More information about the Users mailing list