Greetings !
i trying to change the ip of my secondary storage , was following these steps can you please advice , what im doing wrong thanks in advance for your help and reading ! prashant i was following these steps https://github.com/apache/cloudstack-docs/blob/master/en-US/changing-secondary-storage-ip.xml mysql> use cloud; mysql> select id from host where type = 'SecondaryStorage'; mysql> update host_details set value = 'nfs:// 192.168.160.20/export/mike-ss1' where host_id = HOSTID and name = 'orig.url'; mysql> update host set name = 'nfs:// 192.168.160.20/export/mike-ss1' where type = 'SecondaryStorage' and id = #; mysql> update host set url = 'nfs:// 192.168.160.20/export/mike-ss1' where type = 'SecondaryStorage' and id = #; mysql> update host set guid = 'nfs:// 192.168.160.20/export/mike-ss1' where type = 'SecondaryStorage' and id = #; *But i dont see any host in cloud.host with type secondarystorage * *can you please help* mysql> select id,name,status,available from cloud.host where type="SecondaryStorage"; Empty set (0.00 sec) mysql> select type from cloud.host ; +--------------------+ | type | +--------------------+ | Routing | | Routing | | Routing | | Routing | | SecondaryStorageVM | | ConsoleProxy | | Routing | | Routing | | SecondaryStorageVM | | Routing | | Routing | | Routing | | SecondaryStorageVM | | ConsoleProxy | | SecondaryStorageVM | +--------------------+ 15 rows in set (0.00 sec) mysql> select id,name,status,available from cloud.host where type="SecondaryStorageVM"; +----+----------+--------------+-----------+ | id | name | status | available | +----+----------+--------------+-----------+ | 5 | s-1-VM | Disconnected | 1 | | 9 | s-354-VM | Disconnected | 1 | | 13 | s-689-VM | Disconnected | 1 | | 15 | s-768-VM | Up | 1 | +----+----------+--------------+-----------+ 4 rows in set (0.00 sec) mysql> select id,name,status,available from cloud.host where type="SecondaryStorage"; Empty set (0.00 sec) mysql>
