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

[Răzvan Crainea]

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