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<[email protected]>:
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<[email protected]>:
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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to