[Spce-user] Reset Database did not work

[Andrew Pogrebennyk]

On 04/26/2012 11:04 PM, Skyler wrote:
>  I tried ngcp-reset-db on 2.5 with the intent to wipe/erase all data and
> revert to fresh install. It reset all passwords but did not delete any
> data from DB and now all passwords need to be manually updated in mysql
> for each user listed within constants.yml.

Good point, this script no longer works since we moved to the rolling
releases schema. There is a semi-automatic way to reinitialize DB in 2.5:

mysql ngcp
truncate table db_schema
drop database sipstats;
drop database carrier;

ngcp-update-db-schema
It will prompts for your confirmation. The passwords will remain intact.

And I guess we already have a script to update mysql passwords from
constants.yml, maybe Daniel can comment on it.

Thanks for the bugreport, we will fix the script and the documentation.
 :-)
Andrew