iPAuthenticator error after assigning an IP address
shopgirl_11 - November 17, 2008 - 07:13
| Project: | ipAuthenticator - authenticates an IP to a role |
| Version: | 6.x-1.3 |
| Component: | User interface |
| Category: | bug report |
| Priority: | normal |
| Assigned: | shopgirl_11 |
| Status: | active |
Jump to:
Description
Hi there,
Hi there,
I was advised to re-post this problem and report as a bug. I am not really sure what had happened but if someone could tell me what caused the error below, please do help me...
I was trying to use this module but when i tried to key in an IP address, this is what i get:
user warning: Out of range value adjusted for column 'ip1' at row 1 query: INSERT INTO ip_authenticator (ip1, ip2, roles) VALUES ('-1062729495','','1') in C:\inetpub\Drupal\sites\all\modules\ipAuthenticator\ipAuthenticator\ip_authenticator.admin.inc on line 117
Not sure what caused this but if you have an idea, please help.
#1
Could you tell me what version of this module that you installed? The post says 6.x-1.3, but I know that I sometimes just ignore that. The issue is because the IP address is being converted into a negative integer. What it needs to be converted to is an unsigned positive integer. I have addressed this issue in the development versions of the module. Some people have gone into the database and altered the ip1 and ip2 fields in the ip_authenticate table to be a signed integer. That approach fixes the error, but I think that it creates some issues with checking for a range of IPs.
If you are not already, I would try to use the development version of the module.
#2
Hello,
Thanks for your response. The version I installed is same thing as I mentioned before -- 6.x-1.3. Could you send me the link to that forum where you discussed the development versions of this module? I'll see what i can understand from there. If it does create issues with checking a range of IPs then this problem is not totally fixed right?
By the way, I tried using IP Login as an alternative and it worked fine but in case this bug in IP authenticator will be fixed soon, i would like to try and test it as well.
Thanks again. :)
#3
If you check out, http://drupal.org/node/272572, there is a suggestion to make the IP1 and IP2 database columns signed integers. The discussion isn't that in depth.
Another place to check out is: http://drupal.org/node/261458 (I wouldn't use the posted code since there have been updates since then).
#4
Thank you for your help! Sorry it took a while before I got back to this issue; I truly appreciate your help. :)
I will try to check and see what i can do..