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

removing plesk server form expand

Discussion in 'Plesk Expand 2.2 Troubleshooting Issues' started by silent_scream, Nov 21, 2008.

  1. silent_scream

    silent_scream Guest

    0
     
    Hi,

    i have a question. i have 2 plesk server ( win/lin), database server and mail server registered plesk expand.

    if i remove plesk server from expand, all databases and mail account will be removed???
     
  2. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Before removing the Plesk server from the Expand you need to deassign it from database and mail servers. The deassigning from database server is safe operation. The deassigning from mail server is not safe, you can remove mail accounts only.
     
  3. silent_scream

    silent_scream Guest

    0
     
    let me explain,

    my linux server works fine but have a disk problem. i must change it a new one.

    first way i think, register new server expand and migrate it but my license for only 2 servers.

    second way, migrate from plesk panel for domain contents, remove old server and register new server to expand. but afraid of mail accounts and databases so migrated client account does not see account in their panels.
     
  4. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    To replace the linux server you need:
    1. Backup the old Plesk server`s data using Plesk`s backup tools
    2. Install the new Plesk server to new disk and restore data using Plesk`s backup tools
    3. Deassign the old Plesk server from Centralized Mail server with unchecked 'Remove all mail accounts from mail server' option
    4. Deassign the old Plesk server from Centralized DB
    5. Deassign the old Plesk server from Expand
    6. Assign the new Plesk server to Expand
    7. Assign the new Plesk server to Centralized mail with unchecked 'Migrate mail' option
    8. Assign the new Plesk server to Centralized DB

    The another way - you can copy all old disk data to new disk using the appropriate tools (for example - http://mandrivausers.org/index.php?showtopic=27341).
     
  5. silent_scream

    silent_scream Guest

    0
     
    thank you for reply,

    successfuly deassing the old plesk server from centralized mail server.
    but i cant deassing the old plesk server from centralized db.
    i cant select it
     
  6. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    You can omit the step #4.
     
  7. silent_scream

    silent_scream Guest

    0
     
    when i try to remove plesk linux server from expand,

    <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <packet version="2.2.2.20">
    <del>
    <system>
    <status>error</status>
    <errcode>4000</errcode>
    <errtext>Cannot delete or update a parent row: a foreign key constraint fails. Error query: DELETE FROM plesk_server WHERE id = 1</errtext>
    </system>
    </del>
    </packet>

    <?xml version="1.0"?>
    <packet version="2.2.2.20">
    <del>
    <filter>
    <id>1</id>
    </filter>
    <remove_mail_content>false</remove_mail_content>
    </del>
    </packet>

    i got this error.
     
  8. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Please post the full problem report.
     
  9. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    What do you use MySQL server version?
     
  10. silent_scream

    silent_scream Guest

    0
     
    Action Output
    <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <packet version="2.2.2.20">
    <del>
    <system>
    <status>error</status>
    <errcode>4000</errcode>
    <errtext>Cannot delete or update a parent row: a foreign key constraint fails. Error query: DELETE FROM plesk_server WHERE id = 1</errtext>
    </system>
    </del>
    </packet>
    Action Input
    <?xml version="1.0"?>
    <packet version="2.2.2.20">
    <del>
    <filter>
    <id>1</id>
    </filter>
    <remove_mail_content>false</remove_mail_content>
    </del>
    </packet>
    Advanced: Taskman Output
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <packet version="0.1.1.0">
    <result>
    <status>error</status>
    <errtxt>Action executed with errors</errtxt>
    </result>
    </packet>
     
  11. silent_scream

    silent_scream Guest

    0
     
    expand server mysql version : 4.1.20
     
  12. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Please run command
    Code:
    /usr/local/expand/sbin/expandmysql -e 'SHOW INNODB STATUS \G'
    
    after error 'a foreign key constraint fails' and post its result.
     
  13. silent_scream

    silent_scream Guest

    0
     
    ELETE FROM plesk_server WHERE id = 1
    Foreign key constraint fails for table `expand/backup_files`:
    ,
    CONSTRAINT `backup_files_ibfk_2` FOREIGN KEY (`server_id`) REFERENCES `plesk_server` (`id`)
    Trying to delete or update in parent table, in index `PRIMARY` tuple:
    DATA TUPLE: 24 fields;
    0: len 4; hex 00000001; asc ;; 1: len 6; hex 00008f8f556e; asc Un;; 2: len 7; hex 0000003fd72c6a; asc ? ,j;; 3: len 19; hex 6c696e75782e72616d74656b646e732e6e6574; asc linux.ramtekdns.net;; 4: len 14; hex 3139352e3134392e38352e313430; asc 195.149.85.140;; 5: len 4; hex 000020fb; asc ;; 6: len 9; hex 4c6e78323831313037; asc Lnx281107;; 7: len 4; hex 00000000; asc ;; 8: len 4; hex 00000000; asc ;; 9: len 1; hex 01; asc ;; 10: len 1; hex 01; asc ;; 11: len 1; hex 01; asc ;; 12: len 1; hex 01; asc ;; 13: len 4; hex 00000001; asc ;; 14: len 0; hex ; asc ;; 15: len 0; hex ; asc ;; 16: len 4; hex 00000000; asc ;; 17: len 4; hex 00000000; asc ;; 18: SQL NULL; 19: len 4; hex 00000000; asc ;; 20: len 1; hex 01; asc ;; 21: len 4; hex 00001a63; asc c;; 22: len 1; hex 03; asc ;; 23: len 4; hex 002bf766; asc + f;;

    But in child table `expand/backup_files`, in index `server_id_object_type_object_id_filename_key`, there is a record:
    PHYSICAL RECORD: n_fields 5; 1-byte offs TRUE; info bits 0
    0: len 4; hex 00000001; asc ;; 1: len 1; hex 01; asc ;; 2: len 4; hex 00000002; asc ;; 3: len 25; hex 626172636f6d78795f323030382e30312e32325f31382e3130; asc barcomxy_2008.01.22_18.10;; 4: len 4; hex 00000012; asc ;;
     
  14. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Ok, please run command to clear 'backup_files' table
    and try to delete the linux server from Expand.
     
  15. silent_scream

    silent_scream Guest

    0
     
    thank you gold :)
    it works!
    now i try to register new linux server :)
     
Loading...