Drupal manualy removing

[Sergio asc]

Hi all,

I have installed drupal twice using admin App installer for some test, then I have removed it not by panel but manually... and now Plesk don't works properly...

During the manual removing I have deleted:

- .htaccess file
- drupal directory
- drupal database

But this is not enough, plesk continues to see the "old" drupal.

Can you help me ? I have the resource-id (something like 9a213a53-f722-41b7-a4c3-1cb50457b18b) maybe this should help...

Thanks for your time!

 

[IgorG]

It should be deleted from Plesk psa database too.

 

[Sergio asc]

It should be deleted from Plesk psa database too.

Yes I know... But how?

I'm searching from APSC the Application UID

SELECT `apsc`.`id`, `apsc`.`uid`, `apsc`.`type`, `apsc`.`creation_time`, `apsc`.`enabled` from `aps_registry_object` `apsc` WHERE (`apsc`.`uid`) = ('49bcaa01-127c-4e17-bc29-7a162c0386ee');

Result:

id 	uid 	type 	creation_time 	enabled
23 	49bcaa01-127c-4e17-bc29-7a162c0386ee 	aps.resource 	2012-02-04 20:14:29 	y

The APP UID is then 23

SELECT `1`.`id`, `1`.`resource_type`, `1`.`parent_resource_id`, `2`.`uid`, `1`.`service_id` from (((`aps_application_resource` `3` RIGHT JOIN `aps_resource` `1` ON (`1`.`id`) = (`3`.`resource_id`)) LEFT JOIN `aps_application` `4` ON (`3`.`app_id`) = (`4`.`id`)) LEFT JOIN `aps_registry_object` `2` ON (`4`.`registry_object_id`) = (`2`.`id`)) WHERE (`1`.`registry_object_id`) = (23);

Result:

id 	resource_type 	parent_resource_id 	uid 	service_id
8 	aps::aps10::Drupal 	NULL	e3cd27db-7784-43ac-aad2-992a3033b1d2

Now I have the Service ID and I can search the REGISTRY_OBJECT_ID and APPLICATION_ID

select reg.id as REGISTRY_OBJECT_ID,reg.uid as APPLICATION_UID,reg.type as TYPE,ap.id as APPLICATION_ID from apsc.aps_registry_object reg left join apsc.aps_application ap on reg.id=ap.registry_object_id where reg.uid='e3cd27db-7784-43ac-aad2-992a3033b1d2';

Result:

REGISTRY_OBJECT_ID 	APPLICATION_UID 	TYPE 	APPLICATION_ID
22 	e3cd27db-7784-43ac-aad2-992a3033b1d2 	aps.application 	8

Finally I can delete it from DB:

delete from apsc.aps_application_resource where app_id=8;
delete from apsc.aps_application where id=8;
delete from apsc.aps_registry_object where id=22;

Then from aps table:

delete from psa.apsContextsApplications WHERE (apsContextId IN ('8'));

Then

select s.object_id as pleskId,s.id as subscriptionId from psa.Subscriptions s left join psa.domains d on s.object_id=d.id where name = '*******domain.xxx*****.tld';

+---------+----------------+
| pleskId | subscriptionId |
+---------+----------------+
|    1    |        1       |
+---------+----------------+

delete from psa.apsContexts where (pleskType = "hosting" AND pleskId IN (1)) OR (pleskType = "subscription" AND subscriptionId IN ('1'));

Then last step is to reconfigure the vhost:

root@vserv:~# /usr/local/psa/admin/sbin/websrvmng --reconfigure-vhost --vhost-name=*****domain.xxx*****.tld

But I got this warning:

WARNING: You are using obsolete option, use corresponding option of httpdmng.


What I have to do now ?

 

[IgorG]

Did you try install Drupal back and remove it from Plesk interface?