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ć
