[Spce-user] WEB GUI password lost

[Daniel Grotti]

Hi,
you can restore administrator's userpassword 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
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
> *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/5f74ea75/attachment-0001.html>