Re: Alter Shared Guest Network?
There is something wrong there, and you should not, to my knowledge, have issues with IDs (but I don't recall I have checked this ever) Before "cloning" the row from user_ip_address table - please make sure you are cloning an empty record, not the one which is "used" and alter clean up things - makes you life easier. Sequence "problem" : I have no idea where is this mac_address used later - but the logical place would be the cloud.nics table - all NICs that exist (for all of your VMs, including system VMs) are located in that table - check the network ID in the "networks" table (shared network ID), then do select * from nics where network_id= to show all NICs from that network - in your case there should be 3 NICs (of VR, VM1, VM2) - check if the mac addresses of VM1 and VM2 are different - it NOT then you have the problem, otherwise, I don't think you do have a problem - check inside your VM1 and VM2 if they go their respective MAC and IP addresses - they should be different from VM1 to VM2) (I'm pretty sure that MAC sequence is not used anywhere, or anymore - as the actual sequence numbers (for different resources) are kept in the "sequence" table - and in my env MAC sequence for both private and public MACs are set to "1" -which is nonsense - probably not used any more. Best, On Tue, 15 Jun 2021 at 13:22, Yordan Kostov wrote: > FYI tested this on 4.15 with specifics: > - Shared network with 2 ip range for example 10.10.10.10 - 10.10.10.11 > - created as much VMs as ACS allows me which is 1 (first ip gets assigned > to the VR) > - expanded the the range of the shared network in table "VLAN" from > 10.10.10.10-10.10.10.11 to 10.10.10.10-10.10.10.12 > - Dublicated existing entry in table "user_ip_address" for ip in that > specific shared network. Changed the following columns with new entries: > --- ID to the next unreserved > --- UUID to unique one for the table > --- public_ip_address to 10.10.10.12 > --- allocated - make it NULL > --- state - make it Free > --- mac_address - look at the whole table and set it to the next one that > is not used > > Back to ACS gui I can create a new VM in that network and Ip is assigned. > But there are some underwater stones that are created this way. > As IDs are created manually ACS DB is not updating its sequence so I was > wondering if new network is created would it take the same MAC ID. > After creating a new network and looking again in the table - the answer > to this question is yes - https://imgur.com/YnGMGRE. > > So besides the 2 tables another one should be edited but so far I cannot > find where is the sequence kept. > > Best regards, > Jordan > > -Original Message- > From: Andrija Panic > Sent: Monday, June 14, 2021 10:24 PM > To: users > Subject: Re: Alter Shared Guest Network? > > > [X] This message came from outside your organization > > > ANother is is the, if not mistaken, the VLAN table. which will contain the > range as x.x.x.1-x.x.x.10 - etc - this is needed to be updated as well (if > you manually add records in the user_ip_address table) > > best, > > On Thu, 10 Jun 2021 at 18:23, Jeremy Hansen wrote: > > > Thanks. I’ll take a look table. > > > > -jeremy > > > > > On Jun 10, 2021, at 6:57 AM, Yordan Kostov > wrote: > > > > > > Hello Jeremy, > > > > > >Once a shared network with DHCP offering is created the IPs > > > fitting > > into the defined range are created in table called "user_ip_address". > > >They are created one by one so if range between x.x.x.x.11 and > > x.x.x.210 is created this will add 200 entries. So if you want to > > expand that you need to add more entries manually, which is a bit > unfortunate. > > > > > > Best regards, > > > Jordan > > > > > > -Original Message- > > > From: Jeremy Hansen > > > Sent: Thursday, June 10, 2021 12:12 AM > > > To: users@cloudstack.apache.org > > > Subject: Re: Alter Shared Guest Network? > > > > > > > > > [X] This message came from outside your organization > > > > > > > > >> On Jun 9, 2021, at 1:39 PM, Wido den Hollander > wrote: > > >> > > >> > > >> > > >>>> On 6/9/21 3:55 PM, Jeremy Hansen wrote: > > >>> When I created my shared network config, I specified too narrow of > > >>> an > > IP range. > > >>> > > >>> I can’t seem to figure out how to alter this config via the web > > interface. Is this possible? > > >>> > > >> > > >> Not via de UI nor API. You will need to hack this in the database. > > >> Or remove the network and create it again. But this is only > > >> possible if there are no VMs in the network. > > >> > > >> Wido > > > > > > Thanks, recreating it seems like the easiest option since I’m only > > > in > > testing phase right now, but I’m curious what it would take to alter > > tables to fix this. Any clues as to what tables/fields would need to be > updated? > > > > > >> > > >>> -jeremy > > >>> > > > > > > > > > -- > > Andrija Panić > -- Andrija Panić
RE: Alter Shared Guest Network?
FYI tested this on 4.15 with specifics: - Shared network with 2 ip range for example 10.10.10.10 - 10.10.10.11 - created as much VMs as ACS allows me which is 1 (first ip gets assigned to the VR) - expanded the the range of the shared network in table "VLAN" from 10.10.10.10-10.10.10.11 to 10.10.10.10-10.10.10.12 - Dublicated existing entry in table "user_ip_address" for ip in that specific shared network. Changed the following columns with new entries: --- ID to the next unreserved --- UUID to unique one for the table --- public_ip_address to 10.10.10.12 --- allocated - make it NULL --- state - make it Free --- mac_address - look at the whole table and set it to the next one that is not used Back to ACS gui I can create a new VM in that network and Ip is assigned. But there are some underwater stones that are created this way. As IDs are created manually ACS DB is not updating its sequence so I was wondering if new network is created would it take the same MAC ID. After creating a new network and looking again in the table - the answer to this question is yes - https://imgur.com/YnGMGRE. So besides the 2 tables another one should be edited but so far I cannot find where is the sequence kept. Best regards, Jordan -Original Message- From: Andrija Panic Sent: Monday, June 14, 2021 10:24 PM To: users Subject: Re: Alter Shared Guest Network? [X] This message came from outside your organization ANother is is the, if not mistaken, the VLAN table. which will contain the range as x.x.x.1-x.x.x.10 - etc - this is needed to be updated as well (if you manually add records in the user_ip_address table) best, On Thu, 10 Jun 2021 at 18:23, Jeremy Hansen wrote: > Thanks. I’ll take a look table. > > -jeremy > > > On Jun 10, 2021, at 6:57 AM, Yordan Kostov wrote: > > > > Hello Jeremy, > > > >Once a shared network with DHCP offering is created the IPs > > fitting > into the defined range are created in table called "user_ip_address". > >They are created one by one so if range between x.x.x.x.11 and > x.x.x.210 is created this will add 200 entries. So if you want to > expand that you need to add more entries manually, which is a bit unfortunate. > > > > Best regards, > > Jordan > > > > -Original Message- > > From: Jeremy Hansen > > Sent: Thursday, June 10, 2021 12:12 AM > > To: users@cloudstack.apache.org > > Subject: Re: Alter Shared Guest Network? > > > > > > [X] This message came from outside your organization > > > > > >> On Jun 9, 2021, at 1:39 PM, Wido den Hollander wrote: > >> > >> > >> > >>>> On 6/9/21 3:55 PM, Jeremy Hansen wrote: > >>> When I created my shared network config, I specified too narrow of > >>> an > IP range. > >>> > >>> I can’t seem to figure out how to alter this config via the web > interface. Is this possible? > >>> > >> > >> Not via de UI nor API. You will need to hack this in the database. > >> Or remove the network and create it again. But this is only > >> possible if there are no VMs in the network. > >> > >> Wido > > > > Thanks, recreating it seems like the easiest option since I’m only > > in > testing phase right now, but I’m curious what it would take to alter > tables to fix this. Any clues as to what tables/fields would need to be > updated? > > > >> > >>> -jeremy > >>> > > > > -- Andrija Panić
Re: Alter Shared Guest Network?
ANother is is the, if not mistaken, the VLAN table. which will contain the range as x.x.x.1-x.x.x.10 - etc - this is needed to be updated as well (if you manually add records in the user_ip_address table) best, On Thu, 10 Jun 2021 at 18:23, Jeremy Hansen wrote: > Thanks. I’ll take a look table. > > -jeremy > > > On Jun 10, 2021, at 6:57 AM, Yordan Kostov wrote: > > > > Hello Jeremy, > > > >Once a shared network with DHCP offering is created the IPs fitting > into the defined range are created in table called "user_ip_address". > >They are created one by one so if range between x.x.x.x.11 and > x.x.x.210 is created this will add 200 entries. So if you want to expand > that you need to add more entries manually, which is a bit unfortunate. > > > > Best regards, > > Jordan > > > > -Original Message- > > From: Jeremy Hansen > > Sent: Thursday, June 10, 2021 12:12 AM > > To: users@cloudstack.apache.org > > Subject: Re: Alter Shared Guest Network? > > > > > > [X] This message came from outside your organization > > > > > >> On Jun 9, 2021, at 1:39 PM, Wido den Hollander wrote: > >> > >> > >> > >>>> On 6/9/21 3:55 PM, Jeremy Hansen wrote: > >>> When I created my shared network config, I specified too narrow of an > IP range. > >>> > >>> I can’t seem to figure out how to alter this config via the web > interface. Is this possible? > >>> > >> > >> Not via de UI nor API. You will need to hack this in the database. Or > >> remove the network and create it again. But this is only possible if > >> there are no VMs in the network. > >> > >> Wido > > > > Thanks, recreating it seems like the easiest option since I’m only in > testing phase right now, but I’m curious what it would take to alter tables > to fix this. Any clues as to what tables/fields would need to be updated? > > > >> > >>> -jeremy > >>> > > > > -- Andrija Panić
Re: Alter Shared Guest Network?
Thanks. I’ll take a look table. -jeremy > On Jun 10, 2021, at 6:57 AM, Yordan Kostov wrote: > > Hello Jeremy, > >Once a shared network with DHCP offering is created the IPs fitting into > the defined range are created in table called "user_ip_address". >They are created one by one so if range between x.x.x.x.11 and x.x.x.210 > is created this will add 200 entries. So if you want to expand that you need > to add more entries manually, which is a bit unfortunate. > > Best regards, > Jordan > > -Original Message- > From: Jeremy Hansen > Sent: Thursday, June 10, 2021 12:12 AM > To: users@cloudstack.apache.org > Subject: Re: Alter Shared Guest Network? > > > [X] This message came from outside your organization > > >> On Jun 9, 2021, at 1:39 PM, Wido den Hollander wrote: >> >> >> >>>> On 6/9/21 3:55 PM, Jeremy Hansen wrote: >>> When I created my shared network config, I specified too narrow of an IP >>> range. >>> >>> I can’t seem to figure out how to alter this config via the web interface. >>> Is this possible? >>> >> >> Not via de UI nor API. You will need to hack this in the database. Or >> remove the network and create it again. But this is only possible if >> there are no VMs in the network. >> >> Wido > > Thanks, recreating it seems like the easiest option since I’m only in testing > phase right now, but I’m curious what it would take to alter tables to fix > this. Any clues as to what tables/fields would need to be updated? > >> >>> -jeremy >>> >
RE: Alter Shared Guest Network?
Hello Jeremy, Once a shared network with DHCP offering is created the IPs fitting into the defined range are created in table called "user_ip_address". They are created one by one so if range between x.x.x.x.11 and x.x.x.210 is created this will add 200 entries. So if you want to expand that you need to add more entries manually, which is a bit unfortunate. Best regards, Jordan -Original Message- From: Jeremy Hansen Sent: Thursday, June 10, 2021 12:12 AM To: users@cloudstack.apache.org Subject: Re: Alter Shared Guest Network? [X] This message came from outside your organization > On Jun 9, 2021, at 1:39 PM, Wido den Hollander wrote: > > > >> On 6/9/21 3:55 PM, Jeremy Hansen wrote: >> When I created my shared network config, I specified too narrow of an IP >> range. >> >> I can’t seem to figure out how to alter this config via the web interface. >> Is this possible? >> > > Not via de UI nor API. You will need to hack this in the database. Or > remove the network and create it again. But this is only possible if > there are no VMs in the network. > > Wido Thanks, recreating it seems like the easiest option since I’m only in testing phase right now, but I’m curious what it would take to alter tables to fix this. Any clues as to what tables/fields would need to be updated? > >> -jeremy >>
Re: Alter Shared Guest Network?
> On Jun 9, 2021, at 1:39 PM, Wido den Hollander wrote: > > > >> On 6/9/21 3:55 PM, Jeremy Hansen wrote: >> When I created my shared network config, I specified too narrow of an IP >> range. >> >> I can’t seem to figure out how to alter this config via the web interface. >> Is this possible? >> > > Not via de UI nor API. You will need to hack this in the database. Or > remove the network and create it again. But this is only possible if > there are no VMs in the network. > > Wido Thanks, recreating it seems like the easiest option since I’m only in testing phase right now, but I’m curious what it would take to alter tables to fix this. Any clues as to what tables/fields would need to be updated? > >> -jeremy >>
Re: Alter Shared Guest Network?
On 6/9/21 3:55 PM, Jeremy Hansen wrote: > When I created my shared network config, I specified too narrow of an IP > range. > > I can’t seem to figure out how to alter this config via the web interface. Is > this possible? > Not via de UI nor API. You will need to hack this in the database. Or remove the network and create it again. But this is only possible if there are no VMs in the network. Wido > -jeremy >
Alter Shared Guest Network?
When I created my shared network config, I specified too narrow of an IP range. I can’t seem to figure out how to alter this config via the web interface. Is this possible? -jeremy