News | Forum | People | FAQ | Links | Search | Register | Log in
Site Help
This is the forum to ask questions about this website, report things that are broken, request features, etc.

Be sure to check out the FAQ as well.
First | Previous | Next | Last
Posting From Work 
 
W00t, Weird IP 
 
Just Got This 
Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/johnfitz/sites/www.celephais.net/board/_database.php on line 9

Im guessing the site was just busy? 
Daz: 
hmm, yeah i guess so. I'm not sure if the connection limit is per-database or for the entire domain, so we might be competing with the cube forums or something. 
Metl 
Could we get a spoiler tag that makes the text inside color #333333? 
Good Idea 
 
Weird IP Closure 
Post #18 on the Slave thread, I was using my friends laptop through a USB wire-less modem.
Gave one of those weird IPs people were talking about; 127.255.255.255

How exciting! 
IP Thing... 
thanks for the extra info. I wonder if it's a PHP bug or maybe this is a "feature" of some routers. 
It Can't Be Router Thing, Can It? 
I mean, if you think the other end of the socket is connected to the IP address 127.255.255.255, you'll have a hard time sending a web page to them... 
Oh Ah Uh 
Posting Through TOR 
hello 
Hm 
Posting from Windows XP now. Firefox 3.0b4.
And got the 127.255.255.255.
No proxy for sure. But a router (like always).

http://celephais.net/board/view_thread.php?id=60183&start=97 
Test 
now from ie7 
Weird 
firefox again 
Ok 
metl, you are to blame. 
Hmm... 
good leads, i'll check this stuff out when i get a chance. 
127.255.255.255 Possible Fix 
I changed the IP fields from ints to unsigned ints... which is weird because i'm fairly certain they WERE unsigned, but all the server migrations and upgrades in the past few years might have done something to it.

Anyway, someone who was able to generate the 127.255.255.255 address before, please try again and see if it still happens. 
Dunno.. 
 
Argh... 
i just noticed, some people in the thread above are now 0.0.0.0

but at least CZG is legit now. 
No... 
so that wasn't the right fix, ip2long and long2ip are supposed to use signed ints. I have reverted the changes, fixing the 0.0.0.0 problem.

I still can't tell what's wrong, but at least old data from the database is coming out and displaying correctly, but new data going in is getting IPs >= 128.0.0.0 turned into 127.255.255.255. The change coincides with the latest server move. So maybe it's a PHP or mySQL version issue. 
Or... 
perhaps it's a 64-bit issue, though i can barely believe they would do something so dumb:
http://blog.milkfarmsoft.com/?p=73

But apparently it's "not a bug":
http://bugs.php.net/bug.php?id=18816 
New Fix 
implemented a new fix assuming that the problem is 64 bit ints. Hope it works. This can't help all the 127.255.255.255 addresses from the past two months, though. 
The Old Response 
It's not a bug, it's a feature! 
Cool, 
seems like it worked. 
Once Again ! 
Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/johnfitz/sites/www.celephais.net/board/_database.php on line 9 
First | Previous | Next | Last
You must be logged in to post in this thread.
Website copyright © 2002-2024 John Fitzgibbons. All posts are copyright their respective authors.