Bye bye Delicious. Hello Evernote!

Well, with Delicious’ death approaching, I was forced to grab all the bookmarks I’ve been collecting in the past 5 years and make a run to another service.

According to some users, Evernote is like a ‘personal assistant’. Since I’ve been needing some assistance with keeping track of all the things going on at the moment, I decided to create an account with the service.

But importing my bookmarks was no easy task, seeing as the people behind Evernote decided to can their Delicious importer citing ‘technical difficulties’. Nevertheless, Father Google was able to point me in the right direction. If you’re on a Mac, check out the excellent Delicious Bookmark Importer for Evernote.

Bear in mind, though, that you’ll probably need a premium account (I did) if you want to import a lot of bookmarks since the script puts the entire link’s page into a note. Otherwise follow the comments on the script’s homepage for instructions on how to optimize it to create notes with only the bookmark’s URL.

The Key to Traffic-based Tickets in RADIUS

I spent ages looking for information on how to limit user access based on traffic used through a captive portal using pfSense, and couldn’t find somewhere with an easy to use SQL command that was generic enough to use with daloRADIUS.

Well, in case you were wandering (like me) around the ‘net, here it is:

SELECT IFNULL(SUM(AcctInputOctets + AcctOutputOctets),0) AS AcctTotalOctets FROM radacct WHERE username = '%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b';

This, in essence, is the SQL you need to use for the traffic-based counter that you need to setup in FreeRADIUS for this to work. Then add a check for an attribute like Max-Total-Octets and add that attribute with the amount you want to limit (in bytes) to the users who should be limited, and voilà!

You can use a reset value of never and just keep re-filling user’s session traffic when they run out. Set a reply-message that tells them they’ve run out of data, though, or it will just look like they got their password wrong.