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

Dragomir Haralambiev goup2010 at gmail.com
Thu Feb 7 18:32:20 CET 2013 

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

More information about the Users mailing list