Support

Admin Tools

#11911 Suggestions for improvement of firewall in Admin tools Pro

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Friday, 13 April 2012 03:53 CDT

user7157
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? n/a
Have I searched the tickets before posting? N/a
Have I read the documentation before posting (which pages?)? N/a
Joomla! version: 2.5.4
PHP version: n/a
MySQL version: n/a
Host: (optional, but it helps us help you)
Admin Tools version: 2.2.4

Description of my issue:
Hi Nick
Got a few suggestions to make the firewall even better:
1) make it possible to export and import whitelist and blacklist (csv files) so when handling multiple webpages it makes it easier to interchange these between sites. (maybe have a common repository on a server that the site could get the list from?)
2) as 1) but with also do the same with "forbidden words"
3) Automatically block HTTP:BL connections
4) In the log, be able to select a list at the time to add to the blocklist or remove from the blocklist

Thanks for a great product - I am using it on all my sites. Thanks!

nicholas
Akeeba Staff
Manager
These are all very good suggestions and, in fact, have already been considered or even discussed in the public tickets at one point or another. Let me explain why none of them has been implemented.

1 & 2: You can do that by exporting the jos_admintools_adminiplist (IP whitelist), jos_admintools_badwords (bad words list), jos_admintools_ipblock (black list), jos_admintools_redirects (URL redirections) and jos_admintools_storage (WAF and .htaccess Maker settings) tables using phpMyAdmin or any other SQL management tool (tip: they can all export to CSV). If you don't like phpMyAdmin and mucking around database tables, FreakedOut.de has a CSV import component which works with Admin Tools' URL and IP lists. Ask them if you're unsure. They're a very helpful bunch :)

The reason why this is not implemented in Admin Tools is that the CSV is a very loosely defined format. It would take months and several failed attempts to create something which can work with CSVs produced by all versions of Excel, OpenOffice, Numbers, Google Documents, Office 360,... You get the idea. Not to mention that a valid CSV file may have fixed fields, fields separated by commas, semicolons, spaces, tabs, other character, enclosed in double quotes or not, and when there are double quotes inside a string contained in double quotes you can either escape them as backslash-double quote or as double double quote. I have already had the misfortune of attempting to write a CSV importer in Visual Basic about a decade ago. I wouldn't do that again - nowadays I value my sanity much more :)

3: Do you mean the the thoroughly documented "Project Honeypot integration" feature? What you described is exactly how that feature works. Maybe you have to configure the thresholds a little and/or enable the repeat offenders IP auto block further down the Configure WAF page.

4: This is very dangerous! One wrong click and you'll be adding your own IP or the IP of your client to the list. That's why there are only links to automatically add/remove a single IP to/from the IP black list. Furthermore, I consider permanent IP blocking an ineffective and wrong measure. Any decent hacker/spammer will cycle his IP address every few hours. Blocking his IP hours after the event will simply block an IP address which may later belong to a legitimate user trying to access your site. I consider the automatic IP block (which automatically blocks IPs during an attack spree and only for a limited time) the best way to keep these attacks under control. After all, that's how server-level firewalls work, blocking IPs automatically for a limited time, triggered by attack patterns.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user7157
1) ok - a little cumbersome but I got the message ;)
3) yes well I guess that was it. I look more in to that. Thx
4) hmmm I still believe it would be a great functionality - you could filter these out from what you have in yor whitelist? So only allow this for those IP's that is NOT in your whitelist?
It is damn tedious to apply all these IP's manually by clicking each single one - and especially if you have many sites to admin on ... and since 1+2 can not be simpler ;) (without doing phpadmin stuff or get 3rd party players in on the work ;)

nicholas
Akeeba Staff
Manager
#4 is not really possible without inflicting a huge performance hit (10x slower!) on the log page, on top of the problems I mentioned. Besides, as I said, manually adding IPs to the blacklist is not just counter-productive, it's downright useless. Just turn on the automatic IP block.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user7157
Ok but the auto block feauture only allows to block a certain number of days. Could it not be possible to add "for eternaty"?

nicholas
Akeeba Staff
Manager
In case you missed the important part about the reason not to add someone to the blacklist for "eternity":
Any decent hacker/spammer will cycle his IP address every few hours. Blocking his IP hours after the event will simply block an IP address which may later belong to a legitimate user trying to access your site.

Ergo: Black list = very bad idea. Time-limited auto-ban list = very good idea ;)

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user7157
Well I do not want this to be a retorical debate ... but when they can recycle their IP's then there is a slight change that the IP they used once can be used again to spam? (might cycle in the same range?) And yes I know - or be used by a legitimate user ...
But still it would be nice to have that option as an admin to do that.
Thx - you are welcome to close this ticket (Yes - and I know I can do this myself but I just want to make certain that you read my response)

nicholas
Akeeba Staff
Manager
Yes, there is. The exact chance is 2^32 : 1 against it. It's about the same chance as two completely unrelated people having the same fingerprints. If I were a hacker, I would not use my ISPs IP range to attack you. I'd use a proxy, or a botnet. Hence the improbability of seeing the same IP address or an IP from the same range :)

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!