Piler admin and auditor user not able to login

[Ranjith]

Hi,

We are facing a strange issue. Suddenly we are not able to login with our piler admin and auditor users.

When we try to login, it simply returns the same login page.

As checked in mysql Piler db, both the users exists, I suspect that this might due to users dont have rights to show the page.

Please let us know how to assign previleges to the user or else how to create a new user with required admin previleges

[Janos SUTO]

So it was working for quite some time, and then suddenly it stopped working, right? You should check the free disk space (on all partitions!), as well as both the mail and the mysql logs for clue.

[Ranjith]

Hi,

Yes, it stopped working suddenly. no clue in logs, is there any way to create new admin and auditor users?

[Janos SUTO]

Don't create anew one, rather fix the current one. Try the following: login to mysql piler database as user piler, then execute the following statement:

update user set password='$1$PItc7d$zsUgON3JRrbdGS11t9JQW1' where uid=0;

This resets the admin@local password to pilerrocks

If you still can't login, then the problem is somewhere deeper.

[Ranjith]

Hi,

Tried resetting the password, still its not working. It simply returning the same login page without any error

[Ranjith]

Is that possible to create a admin user with new name

[Ranjith]

One more thing, i tried to integrate the piler with zimbra Ldap. does it be a problem?

[Janos SUTO]

I don't know what you have set for zimbra. Try to undo it, then try to login to see if your change is related to the issue.

[Ranjith]

Have reverted the changes. Still same issue

[Janos SUTO]

Let me look around on this host. Find me on skype (janos.suto) to discuss the details.

[Ranjith]

HI,

Issue resolved. it was resolved after service restart