#149 Subnet and IP addresses in MYSQL

[Anonymous]

I am trying to bulk add subnets via MYSQL but the "subnet" row from the "subnets" table is in a weird format.

For example, the root network 10.222.0.0/16 shows as "182321152".

Ip addresses also have this format. Is this an ID linked to another table?

FYI, bulk adding subnets is a must have in IPAM solutions. Makes it easier for people to migrate.

[Anonymous]

UPDATE: It seems to be a calculation of number of hosts.

182353920 (10.222.128.0) - 182321152 (10.222.0.0) = 32768

32768 is the number of hosts between 10.222.0.0 and 10.222.128.0.

Interesting, anyone know why phpIPAM inserts data into mysql this way???

[Miha Petkovsek]

Ticket moved from /p/phpipam/bugs/327/

[Miha Petkovsek]

User inet_ntoa and inet_aton SQL functions.

https://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-ntoa
https://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton