[Spce-user] Reset Database did not work

[Skyler]

Hi Andrew,

  How would I do a complete reinitialize on the DB including passwords? I
seem to have a few more issues like below even though the password has been
updated in mysql from the constants.yml

DBI connect('database=provisioning;host=localhost;port=0','soap',...)
failed: Access denied for user 'soap'@'localhost' (using password:
YES) at /usr/sbin/reminder line 41

Can't call method "prepare" on an undefined value at /usr/sbin/reminder
line 43.


Skyler

On Fri, Apr 27, 2012 at 3:37 AM, Andrew Pogrebennyk <
apogrebennyk at sipwise.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20120427/a3653080/attachment.html>