Hi, indeed, the dialog table was expended from 1.5 to 1.6, but the mysql DB migration is ok - during migration, a new DB is created (with proper version table and everything) and relevant data (subscribers, aliases,etc) copied from old DB to the new one.
So, in Gavin's case, I thing he did not do a "opensipsdbctl migrate" at all.... Or the script is pointing to the wrong DB. Regards, Bogdan Andrew Pogrebennyk wrote: > On 10.08.2010 23:21, Gavin Henry wrote: > >> "opensipsdbctl migrate opensips_1_5 opensips_1_6" was used and there >> was one error with the subscriber db which is actually a stored >> procedure calling an Asterisk realtime table. >> >> Is there a guide to migrate the SQL with out using the above tool? >> > > Gavin, > I sometimes checkout two versions with svn and run diff - you are > correct the structure of dialog table has changed in 1.6.3, not sure why > opensipsdbctl migrate .. did not convert it: > > diff -ruN opensips_1_5/scripts/mysql/dialog-create.sql > opensips_1_6/scripts/mysql/dialog-create.sql > --- opensips_1_5/scripts/mysql/dialog-create.sql 2010-08-04 > 17:11:48.000000000 +0300 > +++ opensips_1_6/scripts/mysql/dialog-create.sql 2010-08-04 > 17:11:48.000000000 +0300 > @@ -1,4 +1,4 @@ > -INSERT INTO version (table_name, table_version) values ('dialog','3'); > +INSERT INTO version (table_name, table_version) values ('dialog','4'); > CREATE TABLE dialog ( > id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, > hash_entry INT(10) UNSIGNED NOT NULL, > @@ -18,7 +18,10 @@ > callee_sock CHAR(64) NOT NULL, > state INT(10) UNSIGNED NOT NULL, > start_time INT(10) UNSIGNED NOT NULL, > - timeout INT(10) UNSIGNED NOT NULL > + timeout INT(10) UNSIGNED NOT NULL, > + vars TEXT(512) DEFAULT NULL, > + profiles TEXT(512) DEFAULT NULL, > + script_flags INT(10) UNSIGNED DEFAULT 0 NOT NULL > ) ENGINE=MyISAM; > > > -- Bogdan-Andrei Iancu OpenSIPS Bootcamp 20 - 24 September 2010, Frankfurt, Germany www.voice-system.ro _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users