Link to home
Start Free TrialLog in
Avatar of Panos
PanosFlag for Germany

asked on

Coldfusion - security and manage bots/spiders

Hello experts.
I m trying to build my admin area.I need there a controlpage for the bots (spiders/robots),with a database table to check the sessions-allow-statistictics.........
Is there any tutorial there?How can i do it?
Any help?
SOLUTION
Avatar of SidFishes
SidFishes
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

ASKER

Hi sidfishes.
I have a big area for none logged in users.I don't think i can do this.I found something useful here:http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm
but this wasnot exactly i had in mind.
I started to think about this while i was testing the admincontrol panel of a php forum (phpbb3).
take a look:
php.gif
Avatar of Panos

ASKER

Here is a little forward step.
Expert dgrafx has a solution on this site https://www.experts-exchange.com/questions/21688180/Trapping-bad-bots.html?sfQueryTermInfo=1+10+30+bot+coldfus

I need for this example a database table with all the bots/spiders and getting the list for my active bots decide what to do next.Either abort or set a low session time or cflocation or whatever........
<cfif Not isDefined("Application.bannedIPS")>
      <cfquery datasource="filter" name="BanInfo">
           select ip
           from banned_ips
      </cfquery>
      <cflock scope="APPLICATION" type="EXCLUSIVE" timeout="15">
            <cfset Application.bannedIPS=ValueList(BanInfo.ip)>
      </cflock>
</cfif>

<cfif ListFind(Application.bannedIPS,CGI.REMOTE_ADDR)>
    <CFABORT>
</cfif>

There is a solution on this page (http://www.anujgakhar.com/2010/01/26/what-is-the-best-way-to-deal-with-spidersbotscrawlers/   #7) that is checking the number of times someone has been to the site in one second.......
That is interesting too but the code is not posted there.

What do you think about using both?
Could you helpme with the second part(count times....)?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

ASKER

Hi agx.
Thank you for this very useful link.Its is like i open a door to a room with many doors inside there.
I know now what must be done.
I will try to start to build my "protection codes" and make questions i will have for each step.
Avatar of Panos

ASKER

Thank you.
regards
panos
Its is like i open a door to a room with many doors inside there

Yeah, good security measures are like that. There's rarely only 1 step required.  It almost always involves multiple steps and multiple levels.