SQL statements for CUI with sqlite

Stefan Winter stefan.winter at restena.lu
Tue Feb 4 07:46:08 CET 2014


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

Well... after doing this on my machine, I noticed more errors with 

rlm_sql (cuisql): Executing query: 'INSERT OR IGNORE INTO cui (clientipaddress, callingstationid, username, cui, lastaccounting) VALUES ('', '02-00-00-00-00-01', 'availability-test at education.lu', 'ad40aca101096cde0ce27b387939e4c76d8234ca', NULL) ON DUPLICATE KEY UPDATE lastaccounting='0000-00-00 00:00:00', cui='ad40aca101096cde0ce27b387939e4c76d8234ca''
rlm_sql (cuisql): Database query error: near "ON": syntax error
(16) cuisql : No additional queries configured

Looking at the same page - the entire "ON DUPLICATE KEY UPDATE"
doesn't work in sqlite at all? This would look like an overhaul
of that statement is needed.

I'll be using a proper database instead now; MySQL is near me :-)


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

-------------- 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/20140204/e229d96d/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/20140204/e229d96d/attachment.pgp>

More information about the Freeradius-Users mailing list