I have identified two issues in the current version :
1) in NetDB.pm, you should replace :
$static = "no" if !$static;
by
$static = 0 if !$static;
as :
mysql> describe ip;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| ip | varchar(32) | NO | PRI | NULL | |
| static | tinyint(4) | YES | | NULL | |
| lastmac | varchar(20) | YES | | NULL | |
| owner | varchar(30) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
-> static is a TINYINT.
2) in the table nacreg, the userID column is too short and it raises some errors on my setup. 30 characters would be better.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I cleaned up those non-integrers in the library and will update the nacreg userID in the next version. For now you can just do this in mysql if you haven't figured it out already:
alter table nacreg modify userID varchar(30);
Thanks and let us know if you run across other issues,
Jonathan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have identified two issues in the current version :
1) in NetDB.pm, you should replace :
$static = "no" if !$static;
by
$static = 0 if !$static;
as :
mysql> describe ip;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| ip | varchar(32) | NO | PRI | NULL | |
| static | tinyint(4) | YES | | NULL | |
| lastmac | varchar(20) | YES | | NULL | |
| owner | varchar(30) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
-> static is a TINYINT.
2) in the table nacreg, the userID column is too short and it raises some errors on my setup. 30 characters would be better.
David,
I cleaned up those non-integrers in the library and will update the nacreg userID in the next version. For now you can just do this in mysql if you haven't figured it out already:
alter table nacreg modify userID varchar(30);
Thanks and let us know if you run across other issues,
Jonathan
Thank you.