On 4 Feb 2014, at 06:46, Stefan Winter <stefan.winter@restena.lu> wrote:
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@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.
INSERT OR REPLACE I already had the fix in master. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2