 |
It is not happening in 0.19.13 version. |
|
|
Is there any update ? |
 |
Can you provide the HTTP request dump with form parameters' values? Some kind of browser debugger could be used (e.g. FireBug). Maybe your browser sends 127.0.0.0 to the server. |
|
|
I can confirm that in database it stores the IP range value correctly. It may be the issue with displaying it after the addition. mysql> SELECT ip, INET_NTOA(ip), mask FROM IPv4Network; +-----------+---------------+------+ | ip | INET_NTOA(ip) | mask | +-----------+---------------+------+ | 2886737408| 172.16.30.0 | 24 | +-----------+---------------+------+ Please check. |
|
|
This issue may be associated with inc/database.php |
|
|
live-http-header.PNG (139,025 bytes) |
|
|
Uploaded screen shot from live-http-header firefox extension. |
|
|
|
|
|
Please run the attached PHP script and post its output. Your current directory should contain wwwroot/inc dir. |
|
|
I ran the test.php and the out come is mentioned below. ip = 172.16.30.0 ip_bin = ac101e0 net['ip'] = 127.255.255.0 net['ip_bin'] = 7fffff0 ip4_format() = 127.255.255.0 |
|
|
Hmm, looks very strange. Please grab some more diagnostics by typing these 3 commands: # echo "show create table IPv4Network\G" | mysql racktables # cat <<\END >test2.php <?php $script_mode = TRUE; require 'wwwroot/inc/init.php'; $row = fetchIPv4AddressNetworkRow (ip_parse ('172.16.30.0')); var_dump ($row); echo ip_format (ip4_int2bin ($row['ip'])) . "\n"; END # php test2.php |
|
|
TEST#1 =================== *************************** 1. row *************************** Table: IPv4Network Create Table: CREATE TABLE `IPv4Network` ( `id` int(10) unsigned NOT NULL auto_increment, `ip` int(10) unsigned NOT NULL default '0', `mask` int(10) unsigned NOT NULL default '0', `name` char(255) default NULL, `comment` text, PRIMARY KEY (`id`), UNIQUE KEY `base-len` (`ip`,`mask`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ============================================================================== TEST#2 =============================================================================== array(5) { ["id"]=> string(2) "13" ["ip"]=> string(10) "2886737408" ["mask"]=> string(2) "24" ["name"]=> string(7) "pool-30" ["comment"]=> NULL } 127.255.255.255 ========================================================================== |
|
|
THIS IS FROM 0.20.0 DB OUTPUT FROM echo "show create table IPv4Network\G" | mysql racktables20 [root@localhost wwwroot]# echo "show create table IPv4Network\G" | mysql racktables20 *************************** 1. row *************************** Table: IPv4Network Create Table: CREATE TABLE `IPv4Network` ( `id` int(10) unsigned NOT NULL auto_increment, `ip` int(10) unsigned NOT NULL default '0', `mask` int(10) unsigned NOT NULL default '0', `name` char(255) default NULL, `comment` text, PRIMARY KEY (`id`), UNIQUE KEY `base-len` (`ip`,`mask`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ====================================================== ====================================================== THIS IS FROM 0.19.13 DB OUTPUT FROM echo "show create table IPv4Network\G" | mysql racktables [root@localhost wwwroot]# echo "show create table IPv4Network\G" | mysql racktables *************************** 1. row *************************** Table: IPv4Network Create Table: CREATE TABLE `IPv4Network` ( `id` int(10) unsigned NOT NULL auto_increment, `ip` int(10) unsigned NOT NULL default '0', `mask` int(10) unsigned NOT NULL default '0', `name` char(255) default NULL, `comment` text, PRIMARY KEY (`id`), UNIQUE KEY `base-len` (`ip`,`mask`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 Difference is AUTO_INCREMENT value in both versions of the DB schema. |
|
|
From inc/functions.php function ip4_int2bin ($ip_int) //expects an integer as parameter. { return pack ('N', $ip_int); } But $row['ip'] is an array of string, which is passed to above function. |
|
|
SOLVED by doing below change in wwwroot/inc/function.php function ip4_int2bin ($ip_int) { return pack ('N', (double)$ip_int); } Added a double type casting. int casting is out of range. Please check for IPv6. May be 64 bit OS required. |
|
|
I've made a fix: https://github.com/RackTables/racktables/commit/5a8bd9a372ca6a371f718c5eb369aef487335e70 Hope it will work for you, please check it out (we've moved project from SVN to git) |
|
|
Fixed |
- Anonymous
