Domain setup error

[cyleung]

Hello,

I am trying to setup SSL on my domain and got the SSL cert. in place.
But when I tried to assign the domain to the SSL cert. by going to Domain -> Setup
I got the following error, I got the same error after I ran the plesk repair...

DB query failed: Table 'psa.protected_dirs' doesn't exist
---------------------- Debug Info -------------------------------
0: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:209
db_query(string 'select id, path, realm from protected_dirs where dom_id=1 and dom_type="domain"')
1: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.ProtectedDirsList.php:40
ProtectedDirsList->fetchProtectedDirsList()
2: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.ProtDir.php:324
ProtDir->checkDuplicates()
3: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:239
PHostingManager->getPleskStatPDir()
4: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:213
PHostingManager->isPleskStatProtected()
5: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:2205
PHostingForm->assign(object of type PHostingManager, boolean true, boolean true, boolean true, boolean false)
6: C:\Program Files (x86)\SWsoft\Plesk\admin\htdocs\domains\hosting\phosting_setup.php:265


Thanks

CY

PS: Is there a KB article that talks about SSL setup with plesk and IIS 6.0?

 

[Bender]

Hi,

Plesk database is corrupted.

Here is an protected_dirs table structure.

CREATE TABLE `protected_dirs` (
`id` int(10) unsigned NOT NULL auto_increment,
`non_ssl` enum('false','true') NOT NULL default 'false',
`ssl` enum('false','true') NOT NULL default 'false',
`realm` varchar(255) default NULL,
`path` varchar(245) NOT NULL default '',
`dom_id` int(10) unsigned NOT NULL default '0',
`dom_type` enum('domain','subdomain') NOT NULL default 'domain',
PRIMARY KEY (`id`),
UNIQUE KEY `dom_id` (`dom_id`,`dom_type`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[cyleung]

Thanks for the response. So how do I recover the database? Is there any other utils to do that?

Could I just simply re-create that table? What data do I have to add to the table?

Thanks a lot