Howto enable/create the first remote user using script

Discussion in 'Installation/Configuration' started by Jeee, Nov 16, 2020.

  1. Jeee

    Jeee New Member

    The default admin user does not seem to be able to use the remote API. What is the best option to create an initial remote user using script? Is there a command line available for that or does someone have a script for that?
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    You have to create the remote user manually from the UI, under System -> Remote Users.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Or use a SQL query, as this user exists in the ispconfig database only.
     
  4. Jeee

    Jeee New Member

    Thank you. This the way or can it be done shorter?

    Code:
    mysql -u root -p dbispconfig
    INSERT INTO remote_user VALUES (0,1,1,'riud','riud','','remote_mysql_user',md5("remote_mysql_password99"),'y','','server_get,server_config_set,get_function_list,client_templates_get_all,server_get_serverid_by_ip,server_ip_get,server_ip_add,server_ip_update,server_ip_delete,system_config_set,system_config_get,config_value_get,config_value_add,config_value_update,config_value_replace,config_value_delete;admin_record_permissions;client_get_all,client_get,client_add,client_update,client_delete,client_get_sites_by_user,client_get_by_username,client_get_by_customer_no,client_change_password,client_get_id,client_delete_everything,client_get_emailcontact;domains_domain_get,domains_domain_add,domains_domain_update,domains_domain_delete,domains_get_all_by_user;quota_get_by_user,trafficquota_get_by_user,mailquota_get_by_user,databasequota_get_by_user;mail_domain_get,mail_domain_add,mail_domain_update,mail_domain_delete,mail_domain_set_status,mail_domain_get_by_domain;mail_aliasdomain_get,mail_aliasdomain_add,mail_aliasdomain_update,mail_aliasdomain_delete;mail_mailinglist_get,mail_mailinglist_add,mail_mailinglist_update,mail_mailinglist_delete;mail_user_get,mail_user_add,mail_user_update,mail_user_delete;mail_alias_get,mail_alias_add,mail_alias_update,mail_alias_delete;mail_forward_get,mail_forward_add,mail_forward_update,mail_forward_delete;mail_catchall_get,mail_catchall_add,mail_catchall_update,mail_catchall_delete;mail_transport_get,mail_transport_add,mail_transport_update,mail_transport_delete;mail_relay_get,mail_relay_add,mail_relay_update,mail_relay_delete;mail_whitelist_get,mail_whitelist_add,mail_whitelist_update,mail_whitelist_delete;mail_blacklist_get,mail_blacklist_add,mail_blacklist_update,mail_blacklist_delete;mail_spamfilter_user_get,mail_spamfilter_user_add,mail_spamfilter_user_update,mail_spamfilter_user_delete;mail_policy_get,mail_policy_add,mail_policy_update,mail_policy_delete;mail_fetchmail_get,mail_fetchmail_add,mail_fetchmail_update,mail_fetchmail_delete;mail_spamfilter_whitelist_get,mail_spamfilter_whitelist_add,mail_spamfilter_whitelist_update,mail_spamfilter_whitelist_delete;mail_spamfilter_blacklist_get,mail_spamfilter_blacklist_add,mail_spamfilter_blacklist_update,mail_spamfilter_blacklist_delete;mail_user_filter_get,mail_user_filter_add,mail_user_filter_update,mail_user_filter_delete;mail_user_backup;mail_filter_get,mail_filter_add,mail_filter_update,mail_filter_delete;monitor_jobqueue_count;sites_cron_get,sites_cron_add,sites_cron_update,sites_cron_delete;sites_database_get,sites_database_add,sites_database_update,sites_database_delete, sites_database_get_all_by_user,sites_database_user_get,sites_database_user_add,sites_database_user_update,sites_database_user_delete, sites_database_user_get_all_by_user;sites_web_folder_get,sites_web_folder_add,sites_web_folder_update,sites_web_folder_delete,sites_web_folder_user_get,sites_web_folder_user_add,sites_web_folder_user_update,sites_web_folder_user_delete;sites_ftp_user_get,sites_ftp_user_server_get,sites_ftp_user_add,sites_ftp_user_update,sites_ftp_user_delete;sites_shell_user_get,sites_shell_user_add,sites_shell_user_update,sites_shell_user_delete;sites_web_domain_get,sites_web_domain_add,sites_web_domain_update,sites_web_domain_delete,sites_web_domain_set_status;sites_web_domain_backup;sites_web_aliasdomain_get,sites_web_aliasdomain_add,sites_web_aliasdomain_update,sites_web_aliasdomain_delete;sites_web_subdomain_get,sites_web_subdomain_add,sites_web_subdomain_update,sites_web_subdomain_delete;sites_aps_update_package_list,sites_aps_available_packages_list,sites_aps_change_package_status,sites_aps_install_package,sites_aps_get_package_details,sites_aps_get_package_file,sites_aps_get_package_settings,sites_aps_instance_get,sites_aps_instance_delete;sites_webdav_user_get,sites_webdav_user_add,sites_webdav_user_update,sites_webdav_user_delete;dns_zone_get,dns_zone_get_id,dns_zone_add,dns_zone_update,dns_zone_delete,dns_zone_set_status,dns_templatezone_add;dns_a_get,dns_a_add,dns_a_update,dns_a_delete;dns_aaaa_get,dns_aaaa_add,dns_aaaa_update,dns_aaaa_delete;dns_alias_get,dns_alias_add,dns_alias_update,dns_alias_delete;dns_caa_get,dns_caa_add,dns_caa_update,dns_caa_delete;dns_cname_get,dns_cname_add,dns_cname_update,dns_cname_delete;dns_dname_get,dns_dname_add,dns_dname_update,dns_dname_delete;dns_ds_get,dns_ds_add,dns_ds_update,dns_ds_delete;dns_hinfo_get,dns_hinfo_add,dns_hinfo_update,dns_hinfo_delete;dns_loc_get,dns_loc_add,dns_loc_update,dns_loc_delete;dns_mx_get,dns_mx_add,dns_mx_update,dns_mx_delete;dns_naptr_get,dns_naptr_add,dns_naptr_update,dns_naptr_delete;dns_ns_get,dns_ns_add,dns_ns_update,dns_ns_delete;dns_ptr_get,dns_ptr_add,dns_ptr_update,dns_ptr_delete;dns_rp_get,dns_rp_add,dns_rp_update,dns_rp_delete;dns_srv_get,dns_srv_add,dns_srv_update,dns_srv_delete;dns_sshfp_get,dns_sshfp_add,dns_sshfp_update,dns_sshfp_delete;dns_tlsa_get,dns_tlsa_add,dns_tlsa_update,dns_tlsa_delete;dns_txt_get,dns_txt_add,dns_txt_update,dns_txt_delete;vm_openvz');
    
     

Share This Page