You can list service offerings and their associated ID by looking at the service_offering table. You'll see that software-provided services by CloudPlatform use a dedicated special service offerings. Normal instances have "NULL" under "vm_type".
mysql> SELECT * from service_offering WHERE vm_type != 'NULL';
----+-----+-------+----------+---------+---------+------------+----------+---------------+-------------+-----------------------+----------
| id | cpu | speed | ram_size | nw_rate | mc_rate | ha_enabled | host_tag | limit_cpu_use | default_use | vm_type | sort_key |
----+-----+-------+----------+---------+---------+------------+----------+---------------+-------------+-----------------------+----------
| 60 | 1 | 128 | 128 | 0 | 0 | 1 | NULL | 0 | 1 | elasticloadbalancervm | 6 |
| 68 | 1 | 500 | 256 | 200 | 10 | 1 | SYS | 0 | 0 | domainrouter | 0 |
| 69 | 1 | 500 | 256 | 200 | 10 | 1 | SYS | 0 | 0 | secondarystoragevm | 4 |
| 70 | 1 | 500 | 1024 | 200 | 10 | 0 | SYS | 0 | 0 | consoleproxy | 3 |
----+-----+-------+----------+---------+---------+------------+----------+---------------+-------------+-----------------------+----------
4 rows in set (0.00 sec)
Based on the above, here are my suggestions:
- Try at your own risk
- Create a new service offering for a virtual router, then update it's 'vm_type' field in the service_offering table to 'domainrouter'
- in the vm_instance table, locate your virtual router using the "name" column. You'll notice it has a service_offering_id. Update that field to the service offering you recently created
Erik
Erik
