Resolved FTP: User account already exists.

[sdmx80]

Hello,

I had to delete a FTP user in Plesk 12.5.30 on CentOS 7.

Plesk confirmed the deletion, but the user is still able to connect. If I try to add this user under FTP accounts again, it says "User account already exists".

How can I get in control again?

Thank you very much in advance!

Best regards

 

[IgorG]

Looks like that you have the issue from this thread http://talk.plesk.com/threads/deleted-ftp-accounts-still-working.332217/

 

[vlikhtanskiy]

Hi @sdmx80!

Try to run:
# plesk repair ftp

It can clean up orphaned FTP users. The root cause can be that FTP user could be locked by some process while removal.

 

[sdmx80]

Looks like that you have the issue from this thread http://talk.plesk.com/threads/deleted-ftp-accounts-still-working.332217/

Did it! Nothing changed.

Hi @sdmx80!

Try to run:
# plesk repair ftp

It can clean up orphaned FTP users. The root cause can be that FTP user could be locked by some process while removal.

Did it

Checking system users ............................................... [OK]

Error messages: 0; Warnings: 0; Errors resolved: 0

The user is unable to connect via FTP now, but if I want to add a user with the same name Plesk still says "User account already exists".

Any ideas?

 

[vlikhtanskiy]

1. Does this user present in /etc/passwd ?
2. Does this user present in the list of sys users in plesk db?
# plesk db "select login, home from sys_users"

 

[sdmx80]

Hello vlikhtanskiy,

1. No, I deleted it as requested in IgorG's comment
2. Yes, it is present in the sys users table of plesk db

How to delete it from there?

 

[vlikhtanskiy]

@sdmx80 I've sent you a private message.

 

[jbee]

Hi,
same problem in Centos 7 Plesk 12.5.30
how can i delete it
Best regards

 

[Xavier12]

@sdmx80 I've sent you a private message.

Nice to know resolutions are provided via direct message to users instead of directly within the forum to help others with the same issue. Because thats what a forum is about and how Plesk forum solves issue. Good job.

 

[vlikhtanskiy]

In that particular case it was inconsistency of Plesk database that's why it was needed to investigate directly on the server.

What we were discussing:

Make the following queries in Plesk database (you can connect it using "plesk db"):

> select id, login from sys_users where login = 'YOUR USER LOGIN';
+----+-------+
| id | login |
+----+-------+
| 6 | YOUR USER LOGIN |
+----+-------+
1 row in set (0.01 sec)

This will return the id of the user.

Then make the following queries to check if there are object connected to this id:
> select * from ftp_users where sys_user_id = 6;
> select * from hosting where sys_user_id = 6;
> select * from ScheduledTasks where sysUserId = 6;
> select * from subdomains where sys_user_id = 6;
> select * from web_users where sys_user_id = 6;

If all select queries are empty then you can remove the record from sys_users table:
> delete from sys_users where id = 6;

Otherwise you'd better contact Plesk support to investigate a particular case on your server.