[OpenSIPS-Users] DB version error in upgrading to 1.5

[Carlo Dimaggio]

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.