ISPconfig - Usename change password -> username already in use

[klonos]

Using ISPconfig 2.2.27

When I go to Customer -> Site Management -> Select IP -> User & Email ->Select user account -> enter new password -> Save ...

It gives me:

The following error occurred:

The username is already in use.

Next >>

First time I am having issues with ISPconfig, so I don't know where to start troubleshooting from.

[_X_]

Check out if there is something in Recycle Bin (both of them).

[klonos]

... are there two recycle bins? Well, when I check under 'ISP Manager' section I see the following:

Recycle bin: contents 0 - 30

[Empty recycle bin]
 
Note: Items remaining in recycle bin after emptying are currently in update state. Please try to delete them later.

Hitting the 'Empty recycle bin' has no different effect (there are no items in the first place anyway).

All the other sections' recycle bins are empty:

Recycle bin: contents 0 - 30

[Empty recycle bin]

Is there any way I can double check this in the MySQL db directly?

PS: Sorry for the late reply, but I was away.

[_X_]

You can try with database check/repair/optimise.

You can check directly in db_ispconfig database for that username but i dont suggest manual editing of database. If you want to manualy edit that database do a backup first so you can revert to previous state if anything goes wrong.

[klonos]

database check/repair/optimize did not work. Still getting that error

I am not going to touch the db unless someone out there knows to point me to the exact thing I need to change and where I am to locate it in the db tables.

Still waiting for any ideas on this one...

[_X_]

info on users can be found in isp_isp_user table in ispconfig db.

check if that username exists there.

[klonos]

Yep! The user entry is there and the only odd thing is the 'user_cron' field that is set to 0 whereas the rest of the user entries have it set to Null.

The thing though is that the error appears for any other user I try to change the password and not just the one's that I noticed having the issue first. So I guess that this is a general problem with changing user passwords and not user specific.

[_X_]

can you change any other setting for users or you cannot change only passwords?

[klonos]

It turns out that despite this error coming up, the password actually is changed. And you are right, trying to change other settings (I tried real name, mail address and quota) also spits this error, but actually applies the change.

Can I safely ignore this, or should we troubleshoot further? I am using the latest stable 2.x version of ISPconfig and Ubuntu 8.10.

[_X_]

well ... since those changes are done in database it points out to problem with mysql so you should take a look at log files to see if that error can be corrected.

personaly I would try to correct that problem because you cannot delete users and that function can be usefull