[Spce-user] WEB GUI password lost

Lanvin ADON lanvin.adon at kaina-com.fr
Thu Feb 15 07:32:32 EST 2018


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/fc991ee3/attachment-0001.html>


More information about the Spce-user mailing list