flood protection - duplicate entry error
| Author |
Message |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: flood protection - duplicate entry error Posted: Wed Jul 29, 2009 8:50 pm |
|
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 |
|
 |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: flood protection - duplicate entry error Posted: Thu Jul 30, 2009 6:15 am |
|
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 |
|
 |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: flood protection - duplicate entry error Posted: Thu Jul 30, 2009 8:26 am |
|
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 |
|
 |
NanoCaiordo


Joined: Jun 29, 2004 Posts: 3677 Location: Melbourne, AU
|
Post subject: Re: flood protection - duplicate entry error Posted: Fri Jul 31, 2009 4:55 pm |
|
... 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 |
|
 |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: flood protection - duplicate entry error Posted: Fri Jul 31, 2009 9:40 pm |
|
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 |
|
 |
NanoCaiordo


Joined: Jun 29, 2004 Posts: 3677 Location: Melbourne, AU
|
Post subject: Re: flood protection - duplicate entry error Posted: Sun Aug 02, 2009 6:25 am |
|
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
_________________ .:: 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 |
|
 |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: flood protection - duplicate entry error Posted: Sun Aug 02, 2009 9:04 am |
|
Here you go ...
Pls send picture when you've fixed!
_________________ 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 |
|
 |
|
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
|

|
User Info ![Show/hide content [x]](themes/dragonfly/images/minus.png)
 Welcome Anonymous
Last CVS commits ![Show/hide content [x]](themes/dragonfly/images/minus.png)
Languages ![Show/hide content [x]](themes/dragonfly/images/minus.png)
Community ![Show/hide content [x]](themes/dragonfly/images/minus.png)
 Support for DragonflyCMS in a other languages:
• Deutsch
• Español
X-links ![Show/hide content [x]](themes/dragonfly/images/minus.png)
Preview theme ![Show/hide content [x]](themes/dragonfly/images/minus.png)
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.
|