You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Evelio Quiros <ev...@fiu.edu> on 2018/10/11 17:21:11 UTC

Re: Shibboleth Auth not working for VCL v2.5

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

Re: Shibboleth Auth not working for VCL v2.5

Posted by Evelio Quiros <ev...@fiu.edu>.
When I try to log in to the new VCL installation, it does take me to my authentication page, where I enter my credentials.
That part works fine. It’s only when I get redirected back that I get an error message on the browser, then an email with the message below:

Is there a piece of the shibboleth configuration that I am missing ?

-- Al Quiros
Enterprise Systems
 
 

On 10/11/18, 1:21 PM, "Evelio Quiros" <ev...@fiu.edu> wrote:

    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