Article ID: 5826, created on Dec 4, 2008, last review on Aug 12, 2014

  • Applies to:
  • Plesk 9.x for Windows

Symptoms

Backup of a domain which has FTP users with login names more than 15 symbols and created on Parallels Plesk Panel 8.x might not be restored on Plesk 9.0 server properly.

Resolution

There are two possible ways to work the issue around:

1. The first and preferable way is to figure out such domains on Plesk 8.x server by using command below and rename found FTP users in Plesk.

If Plesk database engine works in MySQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where length(login)>15"


If Plesk database engine works in Jet or MS SQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where len(login)>15"

Then reduce FTP user logins which length is more than 15 symbols by renaming them in Plesk.
Backup domains again, move backup to Plesk 9.0 server and restore as it is described in "How can I restore a backup file from older version of Plesk to Plesk 9.0" article.

2. The second way is recommended if an old domain's backup needs to be restored. In this case it is necessary to figure out domains on Plesk 8.x server by using command below:

If Plesk database engine works in MySQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where length(login)>15"


If Plesk database engine works in Jet or MS SQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where len(login)>15"

After that change extension of the old backup file to zip, open it in an archive tool and extract info.xml file.
Then open the file in WordPad, find and rename FTP user logins which length is more than 15 symbols.
Save info.xml file and return the file back to the archive.
Move the backup file to Plesk 9.0 server and restore as it is described in "How can I restore a backup file from older version of Plesk to Plesk 9.0" article.

Additional information

It is strongly recommended to find and rename FTP users logins which length is more than 15 symbols before performing upgrade of Plesk 8.x servers to Plesk 9.0 version.

aac4a8fcd879de03758354e15495d69a a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF