1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Drupal manualy removing

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by Sergio asc, Feb 13, 2012.

  1. Sergio asc

    Sergio asc Guest

    0
     
    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!
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,539
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    It should be deleted from Plesk psa database too.
     
  3. Sergio asc

    Sergio asc Guest

    0
     
    Yes I know... But how?

    I'm searching from APSC the Application UID


    Code:
    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

    Code:
    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

    Code:
    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:


    Code:
    
    
    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:

    Code:
    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 ?
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,539
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    Did you try install Drupal back and remove it from Plesk interface?
     
Loading...