[Spce-user] Lost administrator password

[qabane me]

Hi all

Is there a different procedure for older installations (4.x)? when
following this I get "ERROR 1054 (42S22): Unknown column 'saltedpass' in
'field list'"

On Wed, Jun 6, 2018 at 9:18 AM Daniel Grotti <dgrotti at sipwise.com> wrote:

> Hi Jimmy,
> just set NULL to the saltedpass column:
>
> update billing.admins set saltedpass=NULL where login='administrator';
>
> Then login again with default credentials and the saltedpass will be
> automatically reset again.
>
> Daniel
>
>
>
>
>
> On 06/06/2018 01:05 AM, Jimmy wrote:
>
> Hi,
>
> I have the same problem as outlined in the post quoted below. I have added an md5 hashed password to the md5pass column, though it appears that only the saltedpass column is being queried. Is that the case? If so how could I generate a salted password that would be accepted?
>
> Thanks in advance,
>
> Jimmy
>
> Hi,
> well the only way is to insert into DB billing.admins the right MD5 of
> "administrator" and restore the default password.
>
> Daniel
>
>
>
>
> On 06/28/2014 11:17 PM, Ahmed Murad wrote:
> >>* Hi,
> *>>>* I have been testing and using Sipwise CE but I have unfortunately lost
> *>* the administrator password for the admin login, I changed this from
> *>* the default administrator/administrator
> *>>>* Is there anyway to retrieve this password?
> *>>>* Many thanks in advance.
> *>>>* Ahmed
> *>>>>>>* _______________________________________________
> *>* Spce-user mailing list
> *>* Spce-user at lists.sipwise.com <http://lists.sipwise.com/listinfo/spce-user>
> *>* http://lists.sipwise.com/listinfo/spce-user <http://lists.sipwise.com/listinfo/spce-user>
> *
>
>
>
> _______________________________________________
> Spce-user mailing listSpce-user at lists.sipwise.comhttps://lists.sipwise.com/listinfo/spce-user
>
>
> _______________________________________________
> Spce-user mailing list
> 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/20210520/fe8413c4/attachment.html>