SQL statements for CUI with sqlite

[Stefan Winter]

Hi,

>> 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 
sqlite:

rlm_sql (cuisql): Executing query: 'INSERT OR IGNORE INTO cui (clientipaddress, callingstationid, username, cui, lastaccounting) VALUES ('127.0.0.1', '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 :-)

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/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>