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<[email protected]>:
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
_______________________________________________
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
