flood protection - duplicate entry error
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexProblems AFTER Install/Upgrade
Author Message
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: flood protection - duplicate entry error
Posted: Wed Jul 29, 2009 8:50 pm
Reply with quote

And for what it's worth, different site, same server/account, approx. 11.5 hours later, from same bot at same URL, and same duplicate key:

Code:
On /CPGNuCalendar/view=day/date=20321128.html
While executing query "INSERT INTO wps_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x43da7486, '1248925173', '0', DEFAULT)"

the following error occured: Duplicate entry 'CÚt†' for key 1

In: /home/layin2/public_html/sbcwineries/includes/classes/security.php on line: 308

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 67.218.116.134
Host: crawl-9c.cuil.com

_________________
Pro_News: The complete module for Dragonfly - now available as version 3.3

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: flood protection - duplicate entry error
Posted: Thu Jul 30, 2009 6:15 am
Reply with quote

And 2 more, 1 for each site, at 18:50 for the 1st site, and 16:07 for the 2nd, everything else as before exactly.
_________________
Pro_News: The complete module for Dragonfly - now available as version 3.3

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: flood protection - duplicate entry error
Posted: Thu Jul 30, 2009 8:26 am
Reply with quote

And again to 2nd site at 00:43 ...

This 2nd site is semi-dormant, so if you want Admin access to investigate, Nano, just ask.

_________________
Pro_News: The complete module for Dragonfly - now available as version 3.3

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1
Back to top
View user's profile Visit poster's website
NanoCaiordo
Developer


Joined: Jun 29, 2004
Posts: 3677
Location: Melbourne, AU

PostPost subject: Re: flood protection - duplicate entry error
Posted: Fri Jul 31, 2009 4:55 pm
Reply with quote

... data get removed regularly every ((($times+1)*2)/$delay)+$time

so this error may appear few times every minute, but it doesn't.

If, on your logs, there are 2 or more entries from this bot accessing your site at the same time, then it would confirm my theory.

_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.

NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen()
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: flood protection - duplicate entry error
Posted: Fri Jul 31, 2009 9:40 pm
Reply with quote

Nano,

I've found 3 dup errors, and have attached the email texts, and the matching segment of the daily log.

Easiest way I found to match the emails to the log entries is to search on the CPGNuCalendar date cited in the emails.

On 1 error the 2 accesses in question are same time, but 1 pair are 1 ms apart, and 1 pair are 2 ms apart. However there are a lot more cases I can see when the accesses are at same time, but no dup error was raised. So ... ???

_________________
Pro_News: The complete module for Dragonfly - now available as version 3.3

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1
Back to top
View user's profile Visit poster's website
NanoCaiordo
Developer


Joined: Jun 29, 2004
Posts: 3677
Location: Melbourne, AU

PostPost subject: Re: flood protection - duplicate entry error
Posted: Sun Aug 02, 2009 6:25 am
Reply with quote

A screen shot of your security page settings would be handy.

At this stage I have no clue. But I'll nail it and hang it on my wall Very Happy

_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.

NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen()
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: flood protection - duplicate entry error
Posted: Sun Aug 02, 2009 9:04 am
Reply with quote

Here you go ...

Pls send picture when you've fixed! Wink

_________________
Pro_News: The complete module for Dragonfly - now available as version 3.3

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexProblems AFTER Install/Upgrade All times are GMT
Go to page Previous  1, 2
Page 2 of 2


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.5333 seconds with 16 DB Queries in 0.3408 seconds
Memory Usage: 2.91 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy