SQL statements for CUI with sqlite

Stefan Winter stefan.winter at restena.lu
Mon Feb 3 16:21:19 CET 2014


Hello,

in 3.0.x, the queries.conf for the cuisql module / post-auth / dialect
sqlite state:

INSERT IGNORE INTO ${..cui_table} \

This breaks (gracefully) for me, and I'm told it's a syntax error. This
page here:

https://www.sqlite.org/lang_insert.html

says it should be

INSERT OR IGNORE

Might be worth fixing for 3.0.2.

Greetings,

Stefan Winter

-- 
Stefan WINTER
Ingenieur de Recherche
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et
de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473

PGP key updated to 4096 Bit RSA - I will encrypt all mails if the
recipient's key is known to me

http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xC0DE6A358A39DC66
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x8A39DC66.asc
Type: application/pgp-keys
Size: 3243 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140203/20951bf5/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 901 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140203/20951bf5/attachment.pgp>


More information about the Freeradius-Users mailing list