cassandra backends for freeradius v3.1.x

Arran Cudbard-Bell a.cudbardb at freeradius.org
Mon Jun 15 15:53:00 CEST 2015


> On Jun 15, 2015, at 9:00 AM, Alan DeKok <aland at deployingradius.com> wrote:
> 
> On Jun 15, 2015, at 8:53 AM, ICHIBA Sara <ichi.sara at gmail.com> wrote:
>> I'm trying to use cassandra backends for Freeradius. I opted for the V3.1.x
>> as it already contains the cassandra module. After building the
>> Freeradius-server in my machine I added the sql.conf which you can find here
>> <https://gist.github.com/linnaea/ef2457ae6fc6db7c2e04#file-sql-conf>

Nope.

>  Just call the file "sql".
> 
>  And call the module "sql", too:
> 
> 	sql {
> 		...
> 	}
> 
>  Instead of
> 
> 	sql cassauth {
> 		...
> 	}

Yeah, the problem is there's no query.conf or schema.sql in there yet, because I wasn't convinced the ones included in the gist were correct. The gist author used non-standard table column for everything as well, which makes this harder... and seems to be doing some crazy time based expiry, which is pretty cool, but not how the rest of the dialects operate.

Because of Cassandra's architecture, it's impossible to get the affected row count, so you can't do the alt query failover thing you can with the other dialects.

The queries should likely all be UPDATEs with a condition comparing Last-Updated to Event-Timestamp. I'll look at it more today.

-Arran


More information about the Freeradius-Devel mailing list