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

[Dragomir Haralambiev]

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