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

Export and Import Client/Domain Templates?

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by vnchristina, Jan 5, 2010.

  1. vnchristina

    vnchristina Guest

    0
     
    Is it possible to export and import client/domain templates?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,546
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    You can do it with mysql dumps, for example. ID of template can be found in 'Templates' table of psa database and all settings for needed template ID can be found in 'TmplData' table.
     
  3. vnchristina

    vnchristina Guest

    0
     
  4. vnchristina

    vnchristina Guest

    0
     
    I have another question regarding templates. Why is it that there is no way to reference the template an account was created with? In the clients table for the column tmpl_id, all of the accounts show NULL. We made chagnes to our templates and wanted to change the clients to the new ones. However, there doesn't appear to be a way to do this, or am I just missing something?
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,546
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Client's template can be used only for clients creating and can't be applied to already existing clients. Really, if you enable mysql logging in my.cnf and analyse logs you see that id of template used only during client creating and then replaced with NULL in clients table.
     
  6. LarsT

    LarsT Guest

    0
     
    doesnt work for me

    hi igor, tried to import client and domain templates from another plesk installation as described above. but in the new plesk installation are only the default client and domain templates visible. is there still another database (psa) table to consider?

    thanks for help

    greetz lars

    sql inserts for new plesk installation (client/domain templates) into psa database :

    INSERT INTO `Templates` VALUES(44, 'BusinessWeb Advanced', NULL);
    INSERT INTO `Templates` VALUES(45, 'BusinessWeb Power', NULL);
    INSERT INTO `Templates` VALUES(46, 'BusinessWeb Standard', NULL);


    #####

    INSERT INTO `TmplData` VALUES(44, 'allow_ftp_backups', 'false');
    INSERT INTO `TmplData` VALUES(44, 'allow_local_backups', 'true');
    INSERT INTO `TmplData` VALUES(44, 'change_limits', 'false');
    INSERT INTO `TmplData` VALUES(44, 'cp_access', 'true');
    INSERT INTO `TmplData` VALUES(44, 'create_domains', 'false');
    INSERT INTO `TmplData` VALUES(44, 'disk_space', '20971520000');
    INSERT INTO `TmplData` VALUES(44, 'disk_space_soft', '-1');
    INSERT INTO `TmplData` VALUES(44, 'excl_ip_num', '0');
    INSERT INTO `TmplData` VALUES(44, 'expiration', '-1');
    INSERT INTO `TmplData` VALUES(44, 'manage_anonftp', 'false');
    INSERT INTO `TmplData` VALUES(44, 'manage_crontab', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_dashboard', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_dns', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_domain_aliases', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_log', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_maillists', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_not_chroot_shell', 'false');
    INSERT INTO `TmplData` VALUES(44, 'manage_performance', 'false');
    INSERT INTO `TmplData` VALUES(44, 'manage_phosting', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_php_safe_mode', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_quota', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_sh_access', 'false');
    INSERT INTO `TmplData` VALUES(44, 'manage_spamfilter', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_subdomains', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_virusfilter', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_webapps', 'true');
    INSERT INTO `TmplData` VALUES(44, 'manage_webstat', 'true');
    INSERT INTO `TmplData` VALUES(44, 'max_box', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_db', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_dom', '54');
    INSERT INTO `TmplData` VALUES(44, 'max_dom_aliases', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_maillists', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_mg', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_redir', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_resp', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_subdom', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_traffic', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_traffic_soft', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_webapps', '-1');
    INSERT INTO `TmplData` VALUES(44, 'max_wu', '-1');
    INSERT INTO `TmplData` VALUES(44, 'mbox_quota', '1024000000');
    INSERT INTO `TmplData` VALUES(44, 'overuse_block', 'false');
    INSERT INTO `TmplData` VALUES(44, 'overuse_notify', 'true');
    INSERT INTO `TmplData` VALUES(44, 'remote_access_interface', 'true');
    INSERT INTO `TmplData` VALUES(44, 'select_db_server', 'false');
    INSERT INTO `TmplData` VALUES(44, 'shared_template', 'true');
    INSERT INTO `TmplData` VALUES(44, 'site_builder', 'false');
    INSERT INTO `TmplData` VALUES(44, 'tmpl_pool_id', '6');
    INSERT INTO `TmplData` VALUES(44, 'use_sbnet', '0');
     
Loading...