I just checked and creating a new DB will set a 5 version for the trusted table. Are you sure you are not mixing somehow the old and new DB ?
Regards, Bogdan Carlo Dimaggio wrote: > Il giorno 24/mar/09, alle ore 15:22, Bogdan-Andrei Iancu ha scritto: > > >> Hi Carlo, >> >> to update your database to 1.5 (from 1.4 version) you need to do >> "opensipdbctl migrate" - this should solve your problem. >> >> Regards, >> Bogdan >> > > Hi Bogdan, > > I've used the command 'opensipsdbctl migrate' but I have the same > problem (the version of trusted table is 4 instead of 5). Do I change > manually the number to 5 as Mauro suggested? > > Thanks, > Carlo > > > The output of opensipsdbctl migrate is: > > # opensipsdbctl migrate opensips opensips_15 > MySQL password for root: > INFO: Creating new Database opensips_new.... > INFO: test server charset > INFO: creating database opensips_new ... > INFO: Core OpenSIPS tables succesfully created. > Install presence related tables? (y/n): y > INFO: creating presence tables into opensips_new ... > INFO: Presence tables succesfully created. > Install tables for imc cpl siptrace domainpolicy carrierroute > userblacklist? (y/n): y > INFO: creating extra tables into opensips_new ... > INFO: Extra tables succesfully created. > INFO: Migrating data from opensips to opensips_new.... > INFO: -- Migrating opensips.acc to opensips_new.acc.....OK > INFO: -- Migrating opensips.missed_calls to > opensips_new.missed_calls.....OK > INFO: -- Migrating opensips.aliases to opensips_new.aliases.....OK > INFO: -- Migrating opensips.dbaliases to opensips_new.dbaliases.....OK > INFO: -- Migrating opensips.grp to opensips_new.grp.....OK > INFO: -- Migrating opensips.re_grp to opensips_new.re_grp.....OK > INFO: -- Migrating opensips.silo to opensips_new.silo.....OK > INFO: -- Migrating opensips.domain to opensips_new.domain.....OK > INFO: -- Migrating opensips.uri to opensips_new.uri.....OK > INFO: -- Migrating opensips.usr_preferences to > opensips_new.usr_preferences.....OK > INFO: -- Migrating opensips.trusted to opensips_new.trusted.....OK > INFO: -- Migrating opensips.address to opensips_new.address.....OK > INFO: -- Migrating opensips.speed_dial to > opensips_new.speed_dial.....OK > ERROR: failed to migrate opensips.gw to opensips_new.gw!!! > Skip it and continue (y/n)? y > -- Migrating opensips.gw_grp to opensips_new.gw_grp.....SKIPPED (no > source) > INFO: -- Migrating opensips.lcr to opensips_new.lcr.....OK > INFO: -- Migrating opensips.pdt to opensips_new.pdt.....OK > INFO: -- Migrating opensips.subscriber to > opensips_new.subscriber.....OK > INFO: -- Migrating opensips.cpl to opensips_new.cpl.....OK > -- Migrating opensips.siptrace to opensips_new.siptrace.....SKIPPED > (no source) > INFO: -- Migrating opensips.imc_rooms to opensips_new.imc_rooms.....OK > -- Migrating opensips.im_members to > opensips_new.imc_members.....SKIPPED (no source) > INFO: Migration successfully completed. > > _______________________________________________ > 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
