[Spce-user] error while upgrading

[Matthew Ogden]

It have the same error when using without the -p, but the sipwise user
worked thanks!

So I get this error when I run the down script:
ERROR 1091 (42000) at line 7: Can't DROP 'lcr_id_prefix_from_uri_idx'; check
that column/key exists




> -----Original Message-----
> From: Jon Bonilla (Manwe) [mailto:jbonilla at sipwise.com]
> Sent: 29 August 2012 10:24 PM
> To: spce-user at lists.sipwise.com
> Cc: Matthew Ogden
> Subject: Re: [Spce-user] error while upgrading
>
> El Wed, 29 Aug 2012 21:53:01 +0200
> Matthew Ogden <matthew at tenacit.net> escribió:
>
> > I ran the upgrade to the failed point, and then when I try run the
> > command i get the following
> >
> > root at spce:~# mysql -p <
> > /usr/share/ngcp-db-schema/db_scripts/diff/9868.down
> > Enter password:
> > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> > password: YES)
> >
> >
>
>
> mysql running as root does not have password unless you added it. So
> you can do it without the "-p"
>
> If you created a password for root and don't remember it you can always
> use sipwise user. The password is stored in /etc/mysql/sipwise.cnf
> AFAIR