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

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>