[Spce-user] WEB GUI password lost

[Daniel Grotti]

cool.yw

-- 
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 02:43 PM, Lanvin ADON wrote:
>
> Thank you Daniel !!!!
>
> I found the login for mysql and I’m able to log in the web gui.
>
> Thanks a lot for your support. The request can be close.
>
> Regards
>
> *De :*Daniel Grotti [mailto:dgrotti at sipwise.com]
> *Envoyé :* jeudi 15 février 2018 13:23
> *À :* Lanvin ADON <lanvin.adon at kaina-com.fr>; spce-user at lists.sipwise.com
> *Objet :* Re: [Spce-user] WEB GUI password lost
>
> 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 <mailto: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>
>     <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
>
>     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/55d3d11d/attachment-0001.html>