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=<ID_HERE> 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 <[email protected]> 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 <[email protected]> > Sent: Monday, June 14, 2021 10:24 PM > To: users <[email protected]> > 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 <[email protected]> wrote: > > > Thanks. I’ll take a look table. > > > > -jeremy > > > > > On Jun 10, 2021, at 6:57 AM, Yordan Kostov <[email protected]> > 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 <[email protected]> > > > Sent: Thursday, June 10, 2021 12:12 AM > > > To: [email protected] > > > 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 <[email protected]> > 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ć
