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
