Manually deleting records from Plesk Database

[eder]

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

 

[Murugan Ranganathan]

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

 

[eder]

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

 

[Murugan Ranganathan]

If you are running Plesk 8.3

I suggest you to upgrade it to 8.6.0 ( http://pleskwin.download.swsoft.com/Plesk/Plesk8.6/Windows/8.6.0/plesk_8.6.0_build080722.15.exe )

Then run a patch to further upgrade it to 8.6.0.5 ( http://download1.parallels.com/Plesk/Autoupdate/plesk_8.6.0.5_update080924.19.msp )

 

[Murugan Ranganathan]

Hi,

Your plesk db was in .mdb or mysql ?

 

[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

 

[WinHN HN]

see this to find which db provider.. http://kb.odin.com/en/3453
tell me which is using, i'll tell you how to remove the domains manually.

 

[eder]

I checked and it says its jet

Seems like its mdb.

Thanks again for your help. Its greatly appreciated!

Eder