• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Manually deleting records from Plesk Database

E

eder

Guest
Hello,

I'm stuck with four domains at a dedicated server at godaddy.
I was restoring over one hundred domains from another Plesk Panel 8.3 when I came across what I consider to be a glitch in Plesk as it should have warned me and neither godaddy nor parallels want to give me support on the issue.

If you are restoring a domain that has a mssql database and the incoming database is smaller in size then sqlxpress mssql "model" database, Plesk Panel will not restore that specific domain for you, will show you an error, and then you're stuck, as it wont let you delete the domain to reestore it again without the db.

Everytime I try to delete the domain through Plesk Panel I get an error:

Unable to remove domains: Problems occured while removing domains: Unable to remove hosting: Unable to delete logrotate config: logrot_mng failed: Execute websrvmng --update-log-rotation "--vhost-name=bovisul.com.br" failed: Unable to lookup SID for name bovisul: (1332) No mapping between account names and security IDs was done.

The physical folder for the domains in question do not appear under vhosts. So seems like the records are at the Plesk database but do not phisycally exist.

From some searches around the web I was informed that I can open Plesk database and remove the entries manually, howeber I dont know how to proceed, as I gotta be very carefull for the fact that I have over 400 healthy domains running under the same panel.

Can anybody help me with instructions to safely delete those half restored domains?

Thanks

Eder Wainer
 
Hi,

1. Run the below commands from the command prompt of your server

"%plesk_bin%\websrvmng.exe" --remove-sites-cache

"%plesk_bin%\websrvmng.exe" --reconfigure-vhost --vhost-name=<your_domain>

2. Remove email accounts
3. Remove the databases
4. If the httpdocs contains lots of files remove them manually
5. Then remove the account from plesk panel

Good Luck

Murugan
 
Hi Murugan,

Thank you very much for the quick reply.
The domains in question do not have a folder at vhosts, they only appear on Plesk Panel.
I did as you instructed and I get the following message:

Unable to lookup SID for name autonorte: <1332> no mapping between account names and security IDs was done.

Strange thing is that the domain I typed in the command was autonortearapongas.com.br, not autonorte as stated on the error message.

Thanks!

Eder
 
Hello Murugan,

How do I learn whether its DB is Mysql or mdb? Is it somewhere in my control panel?

As for upgrading to a newer version, is that a 100% safe procedure? I have over 400 websites published in that server and making it unnavailable can cause me quite a headache.

Thanks again for your prompt responses!

Eder
 
I checked and it says its jet

Seems like its mdb.

Thanks again for your help. Its greatly appreciated!

Eder
 
Back
Top