The Plesk database is corrupt

Sep 19, 2006, 10:32 PM #1
eleblanc Member Join: Jun 2005 Posts: 44	The Plesk database is corrupt Hi, I tried to install a SSL certificate on a site, (using dedicated IP). But when i go in the server>IP address , to assign the certificate to the IP. I get this error Warning: The Plesk database is corrupt. Please launch the Reconfigurator utility to fix it So i went at use the reconfigurator, with no luck. And in the SSL certificate drop box to select the certificate i will assign to the ip, the one i've installed won'T show up. Mostlikly because of this error. This is kind of urgent because i was renewing a certificate and now the order wizard of the site does not have any certificate.

Sep 19, 2006, 10:32 PM

eleblanc
Member

Join: Jun 2005
Posts: 44

The Plesk database is corrupt

Hi,

I tried to install a SSL certificate on a site, (using dedicated IP). But when i go in the server>IP address , to assign the certificate to the IP. I get this error

Warning: The Plesk database is corrupt. Please launch the Reconfigurator utility to fix it

So i went at use the reconfigurator, with no luck.

And in the SSL certificate drop box to select the certificate i will assign to the ip, the one i've installed won'T show up. Mostlikly because of this error.

This is kind of urgent because i was renewing a certificate and now the order wizard of the site does not have any certificate.

Jan 12, 2007, 12:58 PM #2
pikos Junior Member Join: Feb 2006 Posts: 22	same here ! any solution? __________________ wind.awmn.net Node 2435

Mar 12, 2007, 01:48 PM #3
vlurk Junior Member Join: Sep 2005 Posts: 5	I get the same error using Plesk 8.1. Plesk reconfigurator didn't help. Oh well...

Feb 14, 2008, 02:46 AM #4
cyleung Junior Member Join: Feb 2008 Posts: 3	I got similar issues with Plesk 8.2 while trying to install SSL http://forum.swsoft.com/showthread.p...262#post199262 This is pretty urgent, please give me a hand. Thanks

Jan 8, 2009, 01:49 PM #5
LDaniele Junior Member Join: Oct 2008 Posts: 3	Solution to the "Plesk database is corrupt" problem I was able to solve this problem on my Plesk 8.6.0 for Windows installation. You can read all about it on my blog entry Warning: The Plesk database is corrupt. Please launch the Reconfigurator utility to fix it. However, here's a summary of the steps I used to solve the problem: 1. On the web server, navigate to %plesk_dir%\admin\db. There you should find the Microsoft Access database files psa.mdb and psa.ldb. 2. Make a copy of these files as a backup (Ctrl+C, Ctrl+V). 3. Copy these files to a computer with Visual Studio (or Access) installed. 4. Open the database (in VS, use Server Explorer), open the "repository" and "certificates" tables. 5. Manually implement the SQL statement delete from repository where rep_id=1 and component_id not in (select id from certificates); Note: I found the repository rep_id, component_ids to be: 1, 1 1, 2 1, 3 1, 4 However, the certificate IDs were 1, 2, 3 and 10. So instead of deleting the row, I modified the value from "4" to "10". 6. Copy the two database files back to the server. 7. Try reproducing the problem in Plesk. The problem went away for me!

Jan 8, 2009, 01:49 PM

LDaniele
Junior Member

Join: Oct 2008
Posts: 3

Solution to the "Plesk database is corrupt" problem

I was able to solve this problem on my Plesk 8.6.0 for Windows installation. You can read all about it on my blog entry Warning: The Plesk database is corrupt. Please launch the Reconfigurator utility to fix it. However, here's a summary of the steps I used to solve the problem:

1. On the web server, navigate to %plesk_dir%\admin\db. There you should find the Microsoft Access database files psa.mdb and psa.ldb.

2. Make a copy of these files as a backup (Ctrl+C, Ctrl+V).

3. Copy these files to a computer with Visual Studio (or Access) installed.

4. Open the database (in VS, use Server Explorer), open the "repository" and "certificates" tables.

5. Manually implement the SQL statement

delete from repository where rep_id=1 and component_id not in (select id from certificates);

Note: I found the repository rep_id, component_ids to be:

1, 1
1, 2
1, 3
1, 4

However, the certificate IDs were 1, 2, 3 and 10. So instead of deleting the row, I modified the value from "4" to "10".

6. Copy the two database files back to the server.

7. Try reproducing the problem in Plesk. The problem went away for me!

Post Reply

« Previous Thread | Next Thread »

Search this thread	Forum jump
Advanced Search

Thread tools	Display modes
Printable Version Email this Page	Linear Mode Hybrid Mode Threaded Mode

Parallels Technology Network

The Plesk database is corrupt