Fetch URL file then execute the file

RouterOS Scripting
1

I have server (CentOS) that gather all the active blacklisted IPs (most of the time that attempt SSH logins/spamhaus/RBL listed/etc.) and I have the blacklist.php that will generate that blacklisted IPs the hosted under Apache+PHP.

What I am going to do is, that blacklist.php will generate all the Mikrotik command like the following:

/ip firewall address-list add list=blacklist address=<blacklisted IPs from DB>

Then, that IPs will be listed under my Mikrotik’s address list named “blacklist”, and my Rules already add DROP the incoming/outgoing traffic into that rules.

However, I am clueless how to run the generated file into Mikrotik. Anyone know how to do this into the script?
Lets say the script’s scenario is like this:

  1. Execute /tool fetch url=“http://blablabla/servercmd.php” http-method=post http-data=“op=mikrotik” output=“runremotescript”
  2. Execute all the generated Mikrotik’s commands in runremotescript

the runremotescript will be like this:

  1. /ip firewall address-list add list=blacklist address=<generated from http://blablabla/servercmd.php>
    Example:
/ip firewall address-list add list=blacklist address=123.25.25.128

TQ

2

The forum is FULL of example, use SEARCH function first:

http://forum.mikrotik.com/t/importing-ip-list-from-file/143071/8
http://forum.mikrotik.com/t/help-with-error-in-script-to-import-the-ipv4-full-bogons-list-from-www-team-cymru-org/113429/4

But I prefer mine because file size limit are little, and I prefer read IP than read replicated commands that use more space than single IP,

3

thanks.. solved