Radius manager export

How to export customer’s data from Radius manager including the name of services and non-encrypted passwords: select rm_users.*, radcheck.value, rm_services.srvname from rm_users left join radcheck on rm_users.username = radcheck.username left join rm_services on rm_services.srvid = rm_users.srvid  where radcheck.attribute = ‘Cleartext-Password’ or select rm_users.*, radcheck.value, rm_services.srvname from rm_users left join radcheck on rm_users.username = radcheck.username left[…]

Mikrotik hotspot default queue

When you configure a hotspot with Mikrotik, routerOS always creates a default queue called hs-<hotspot1> allowing unlimited speed both directions. You can delete the queue, but it will come up again after restart. The problem is that this queue will override simple queue which are below it and speed limitation of hotspot users will not work[…]

Mikrotik MPLS implementation issues

We are running MPLS on RouterOS for over one year and still I’m getting new errors in MPLS implementation on RouterOS. Below is a list of all issues, I’ve found (versions < 6.33) : 1. The main problem is separation of VRFs. RouterOS is a linux based system and all VRF tables are linux routing[…]

IPv6 transition mechanisms

There are plenty of IPv6 transition technologies and I always forget some of them. Below is the list with description to have a quick reminder always when it’s needed. I’m considering all technologies from ISP’s point of view : 1. Dual-stack The simplest one. All our infrastructure is IPv6 enabled and we give /64 prefix[…]