Hi Sanjeev, thx, but I don't just want to remove IP from table - I want to define it to belong to "Public" network, instead of "Guest" network (it is basicaly 1 subnet with some IPs dedicated to Guest, and some IPs dedicated to Public) Also, correct me if I understood you incorrectly - you ment to change "State" field value from "Allocated" to "Free" in order to mark IP as free (and also set "allocated" field to NULL, and also nullofy some other fields probably...)
I guess changing table as I proposed would work for moving IP from Guest to Public network...? I could not find any other table with IP addresses, or IP ranges (since we define IP range inside CS GUI), except that... ? Thanks On 22 May 2014 05:50, Sanjeev Neelarapu <sanjeev.neelar...@citrix.com>wrote: > Hi Andrja, > > We can mark the the IP addresses allocated state to some timestamp in > user_ip_address table in cloud db if we want to remove. > > -Sanjeev > > -----Original Message----- > From: Andrija Panic [mailto:andrija.pa...@gmail.com] > Sent: Wednesday, May 21, 2014 7:55 PM > To: users@cloudstack.apache.org; Prodosh Banerjee Anolim > Subject: update/shrink "guest" IP range > > Hi. > > I have an IP range that is i.e. 50 IPs total - "Guest" ip range with > public IPs... > > I would need to shrink it, in order to move uper 10 IPs to the "public" IP > range... > > From cloudmonkey, I can list Guest range, but I can't update it, and no > support in API till 4.3 version... > > cloudmonkey list vlanipranges > ============================================================= > id = f0bec296-3ac8-483c-a23a-b36213fdf846 > account = system > domain = ROOT > domainid = 650b26a5-7271-48f6-a6a1-4e234a465cfd > endip = x.y.z.201 > forvirtualnetwork = False > gateway = z.x.y.1 > netmask = 255.255.255.0 > networkid = c8eaf8d8-758e-4e93-aa64-732728452ae6 > physicalnetworkid = 92cdd79e-3355-4c3f-9f28-4ffe44a60b44 > startip = x.y.z.131 > vlan = 5xx > zoneid = 3d1dcf11-d482-4f28-a2dd-6afcb51545d2 > ================================================================ > > > update vlanipranges > Error: invalid update api arg'vlanipranges' > > I can't really delete the range (some VMs with those IP addreses), but > need to shrink it... > > Since this is not possible, could I update DB records, like: > > UPDATE `cloud`.`user_ip_address` SET `vlan_db_id`='1', > `source_network_id`='200' WHERE `id`='140'; > > this means changing vlan and source netowrk, to match those of IP > addresses in "Public range" > > Thanks. > Andrja > > -- > > Andrija Panić > -- Andrija Panić -------------------------------------- http://admintweets.com --------------------------------------
