Defining multiple post-auth INSERT queries for the same table

Stefan Paetow Stefan.Paetow at
Thu May 18 14:19:27 CEST 2017

> AFAICT you can't do this. The code doesn't seem to support it, unless I'm mistaken - the postauth handler uses the acct_redundant() function in rlm_sql.c but that function seems to return if a query succeeded and touched >0 rows, unless RLM_SQL_ALT_QUERY (constraint violation) is returned.

Thanks for the clarification, Phil. :-)

> FWIW we use SQL triggers for stuff like this, but I'm moving away from using the SQL stuff entirely for acct/postauth - we've bumped up against the limits of unlang and compiled-in module logic (and I'm abandoning C as a lost cause ;o)

Interesting. This thing is just a small... how do I put it... 'backup' for those who don't want to rely on automatic generation. This is just version 0.1. ;-)

Stefan Paetow
Moonshot Industry & Research Liaison Coordinator

t: +44 (0)1235 822 125
gpg: 0x3FCE5142
xmpp: stefanp at
skype: stefan.paetow.janet

Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP
URL: <>

More information about the Freeradius-Users mailing list