Skip to Content

Import servers from a CSV file into Ezeelogin

139  admin August 31, 2022  Migration & Maintenance, Productivity & Efficiency Features

How to import servers from a file into the Ezeelogin SSH gateway?

1. To import a list of servers from a CSV file, click on the import tab on the left then choose the CSV file and click upload. 

2. Once you click upload, the CSV file would be parsed and if the format is correct, then the import button would show up so that you can import the list of servers. Using this feature you can import multiple servers quickly.

3. After the successful import of the servers it will display the message "Servers imported" as shown in the screenshot below.

4. If the server already exists, it will display the error message "No valid new servers to import" (The server exists) as shown in the screenshot below.

5. If the server group does not exist, it will display the error message "No valid new servers to import" (No such server group) as shown in the screenshot below.

This is what the importing CSV file would look like. The first line would be the header and the second line would be the server that has to be imported. You can also use the export feature to get a CSV file as shown below which can be later used as a template to import more servers.

"name"|"ip_address"|"group"|"password"|"ssh_port"|"ssh_user"|"keep_password"|"enable_ssh"|"controlpanel"|"datacenter"|"description"|"tunnel_host"|"switch_user"|"switch_pass"|"switch_sudo"|"prompt1"|"prompt2"|"prompt3"|"cp_user"|"cp_pass"|"rc_host"|"rc_user"|"rc_pass"|"onhost"|"ishn"|"rack_id"|"machine_id"|"comments"|"use_dns"|"passphrase"|"ssh_key"|"rdp"|"windows_domain"|"ipmi_host"|"ipmi_protocol"|"ipmi_port"|"ipmi_request_method"|"ipmi_user_field"|"ipmi_username"|"ipmi_passwd_field"|"ipmi_password"|"ipmi_basic_auth"|"ipmi_request_uri"|"ipmi_extra_vars"|"ipmi_enable"

"ez.noc.com"|"118.7.63.62"|"LINUX"|""|"22"|"root"|"S"|"Y"|""|""|"TestMachine"|""|""|""|"N"|""|"Password:"|""|""|""|""|""|""|""|"N"|""|""|""|"N"|""|""|"N"|""|""|"https"|"80"|"POST"|""|""|""|""|"N"|""|""|"N"

What are the mandatory fields required to import the servers from a CSV file?

+------------------------------------------------------------------------------------------------+
| name       | ip_address  | group | password | ssh_port | ssh_user | keep_password | enable_ssh |
+------------------------------------------------------------------------------------------------+
| ez.noc.com | 118.7.63.62 | Linux |          | 22       |          | S             | Y          |
+------------------------------------------------------------------------------------------------+

name FQDN or name of the server
ip_address  Remote server IP
group  Server group that exists in Ezeelogin
password  The password of the remote SSH user (leaving blank will be asked for prompt)
ssh_port  SSH port of the remote server
ssh_user  The username of the remote SSH user (leaving blank will be asked for prompt)
keep_password 

Set password management for the server (leaving blank will set to automatic)

Y (keep given password), N (automatic), S (keep server password)
enable_ssh  Enable SSH access for the remote server (leaving blank will set enable_ssh to no)

 

 

Related Articles
Rating: 5 (1 Votes)