[Spce-user] WEB GUI password lost

[Daniel Grotti]

By default there is no password.
So you have probably changed the password.


-- 
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:37 PM, Lanvin ADON wrote:
>
> I’ve tried already !!!
>
> root at sipwise:~# mysql
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
>
> *De :*Daniel Grotti [mailto:dgrotti at sipwise.com]
> *Envoyé :* jeudi 15 février 2018 12:34
> *À :* Lanvin ADON <lanvin.adon at kaina-com.fr>; spce-user at lists.sipwise.com
> *Objet :* Re: [Spce-user] WEB GUI password lost
>
> 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 <mailto: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>
>     <mailto:lanvin.adon at kaina-com.fr>; spce-user at lists.sipwise.com
>     <mailto: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/c6ce1eb3/attachment-0001.html>