[Spce-user] WEB GUI password lost

[Daniel Grotti]

just access mysql with:

# mysql



-- 
Daniel Grotti
Head of Customer Support
Sipwise GmbH, Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Office: +43(0)130120332
Email: dgrotti at sipwise.com
Website: https://www.sipwise.com

On 02/15/2018 01:32 PM, Lanvin ADON wrote:
>
> Daniel
>
> Thanks for your support.
>
> The issue is now with mysql; I cannot log in and I’ve never change the 
> password.
>
> root at sipwise:~# mysql -uroot
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
>
> I have an image with the default administrative password. I’ll use it.
>
> Thanks.
>
> Lanvin A.
>
> *De :*Daniel Grotti [mailto:dgrotti at sipwise.com]
> *Envoyé :* jeudi 15 février 2018 10:30
> *À :* Lanvin ADON <lanvin.adon at kaina-com.fr>; spce-user at lists.sipwise.com
> *Objet :* Re: [Spce-user] WEB GUI password lost
>
> Hi,
> you can restore administrator's user password to default one with:
>
>
> mysql> update billing.admins set md5pass=md5("administrator"), 
> saltedpass=NULL where login="administrator";
>
>
>
> Then you can login and change the password again.
> Cheers,
>
>
>
>
> -- 
> Daniel Grotti
> Head of Customer Support
> Sipwise GmbH, Campus 21/Europaring F15
> AT-2345 Brunn am Gebirge
> Office: +43(0)130120332
> Email:dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
> Website:https://www.sipwise.com
>
> On 02/15/2018 11:02 AM, Lanvin ADON wrote:
>
>     Hi Daniel,
>
>     Sipwise NGCP platform version 'mr5.4.1'
>
>     Regards
>
>     Lanvin A.
>
>     *De :*Spce-user [mailto:spce-user-bounces at lists.sipwise.com] *De
>     la part de* Daniel Grotti
>     *Envoyé :* jeudi 15 février 2018 09:52
>     *À :* spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com>
>     *Objet :* Re: [Spce-user] WEB GUI password lost
>
>     Hi Lavin,
>     which SPCE version do you have?
>
>
>
>     -- 
>
>     Daniel Grotti
>
>     Head of Customer Support
>
>     Sipwise GmbH, Campus 21/Europaring F15
>
>     AT-2345 Brunn am Gebirge
>
>       
>
>     Office: +43(0)130120332
>
>     Email:dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
>
>     Website:https://www.sipwise.com
>
>     On 02/14/2018 05:06 PM, Lanvin ADON wrote:
>
>         Hi all ,
>
>         I’ve lost my sip:provider CE WEB GUI administrator’s password.
>
>         Is there any way I can change or retrieve it from the console?
>
>         Thanks for your help.
>
>         Regards
>
>         Lanvin ADON
>
>
>
>
>
>         _______________________________________________
>
>         Spce-user mailing list
>
>         Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
>
>         https://lists.sipwise.com/listinfo/spce-user
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180215/46d0dd07/attachment-0001.html>