Hi All,
I am working on a new VCL 2.5 installation using Shibboleth.
The test script in the documentation seems to work correctly.
But when I try to log into the new VCL using Shibboleth, I get a MySQL error:
You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ') AS s LEFT JOIN
cryptsecret cs ON (ck.id = cs.cryptkeyid AND cs.secretid = s.id' at line 1
SELECT ck.id as cryptkeyid, ck.pubkey as cryptkey, s.id as secretid,
s.cryptsecret AS mycryptsecret FROM cryptkey ck JOIN (SELECT secretid as id,
cryptsecret FROM cryptsecret WHERE cryptkeyid = ) AS s LEFT JOIN cryptsecret cs
ON (ck.id = cs.cryptkeyid AND cs.secretid = s.id) WHERE ck.hosttype = 'web' AND
cs.secretid IS NULL AND ck.id !=
ERROR(101): General MySQL error
Mode was
Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:addLoginLog() (line#:187)
Call#:2 => authentication.php:checkMissingWebSecretKeys() (line#:580)
Call#:3 => utils.php:doQuery() (line#:3075)
Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 => index.php:addLoginLog() (line#:187)
Arguments(4)
Argument#: 1 => evquir@FIU
Argument#: 2 => shibboleth
Argument#: 3 => 3
Argument#: 4 => 1
-----------------------
Call#:2 => authentication.php:checkMissingWebSecretKeys() (line#:580)
Arguments(none):
-----------------------
Call#:3 => utils.php:doQuery() (line#:3075)
Arguments(1)
Argument#: 1 => SELECT ck.id as cryptkeyid, ck.pubkey as cryptkey, s.id as
secretid, s.cryptsecret AS mycryptsecret FROM cryptkey ck JOIN (SELECT secretid
as id, cryptsecret FROM cryptsecret WHERE cryptkeyid = ) AS s LEFT JOIN
cryptsecret cs ON (ck.id = cs.cryptkeyid AND cs.secretid = s.id) WHERE
ck.hosttype = 'web' AND cs.secretid IS NULL AND ck.id !=
-----------------------
Any ideas on what could be causing this issue ?
Thanks,
-- Al Quiros
Enterprise Systems
