How to change main IP address for a virtual machine in SolusIO?

Question

How to change main IP address for a virtual machine in SolusIO?

Answer

This functionality is yet to be implemented in SolusIO.
There is a corresponding feature request #SIO-2797.

As a workaround, the main IP address can be changed in SolusIO database directly:

1. Login to SolusIO admin panel
2. Find the corresponding VPS ID at SolusIO > Virtual Servers(ID Column):
   
3. Connect to SolusIO management node via SSH
4. Create SolusIO backup using this article:
   How to create a backup of SolusIO on the management node
5. Access SolusIO database with the command:

   # docker exec -it $(docker ps -q -f name=solus_postgres | head -n1) psql -U$(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_USER | awk -F "=" {'print $2'}) $(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_DB | awk -F "=" {'print $2'})

6. List all the IPs of the VPS using VPS ID from step 2:

   MYSQL_LIN: select id,ip,is_primary from ips where compute_resource_vm_id =ID and type='IPv4';

   the output should be like this:

   CONFIG_TEXT:  id  |    ip      | is_primary
   -----+-------------+------------
    457 | 10.40.1.223 | f
    470 | 10.40.1.228 | t

   Here the column is_primary defines if the IP is primary or additional one.
   t(true) - stands for primary
   f(false) - stands for non-primary.

7. Changes the primary IP using the following query using IDs of the IP addresses:

   MYSQL_LIN: update ips set is_primary=false where id=470;
   update ips set is_primary=true where id=457;

   The first query sets the IP with ID 470 as non-primary IP address.
   The second query sets the IP with ID 457 as primary IP address.

8. Restart the VPS at SolusIO > Virtual Servers > VPS