JiscMail Logo
Email discussion lists for the UK Education and Research communities

Help for MOONSHOT-COMMUNITY Archives


MOONSHOT-COMMUNITY Archives

MOONSHOT-COMMUNITY Archives


MOONSHOT-COMMUNITY@JISCMAIL.AC.UK


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Proportional Font

LISTSERV Archives

LISTSERV Archives

MOONSHOT-COMMUNITY Home

MOONSHOT-COMMUNITY Home

MOONSHOT-COMMUNITY  November 2014

MOONSHOT-COMMUNITY November 2014

Options

Subscribe or Unsubscribe

Subscribe or Unsubscribe

Log In

Log In

Get Password

Get Password

Subject:

APC's FreeRADIUS instance has query error

From:

Stefan Paetow <[log in to unmask]>

Reply-To:

Stefan Paetow <[log in to unmask]>

Date:

Thu, 27 Nov 2014 17:11:37 +0000

Content-Type:

multipart/signed

Parts/Attachments:

Parts/Attachments

text/plain (108 lines) , apc-radiusd.log (108 lines) , rp_tidc_request.log (108 lines) , trust_router-default.log.201411271659 (108 lines) , Unknown Name (3 lines) , signature.asc (3 lines)

Hi,

I was under the impression that the APC is a standard Moonshot IdP with the only difference being that it holds the credentials for all other Relying Parties in the system. All other bits remain the same (including running a trust router etc).

I followed the instructions as per the Wiki, but for some reason the APC throws an error in the FreeRADIUS debug log (I've pasted the specific request)

-- start of request --

Thread 2 handling request 8, (2 handled so far)
(8) Retrieved psk identity: key-cc2bba
	User-Name = [log in to unmask]
	GSS-Acceptor-Service-Name = 'trustidentity'
	GSS-Acceptor-Host-Name = 'main-idp65x64.localdomain'
	EAP-Message = 0x0200001c0140747261706336357836342e6c6f63616c646f6d61696e
	Message-Authenticator = 0x46ef757cfa1ee44fc3e1aa7786063a6a
	Event-Timestamp = 'Nov 27 2014 16:59:28 GMT'
	NAS-IP-Address = 127.0.0.1
	Proxy-State = 0x30
(8) Received Access-Request packet from host 192.168.213.24 port 41310, id=241, length=150
(8) 	TLS-PSK-Identity := 'key-cc2bba'
(8) 	User-Name = [log in to unmask]
(8) 	GSS-Acceptor-Service-Name = 'trustidentity'
(8) 	GSS-Acceptor-Host-Name = 'main-idp65x64.localdomain'
(8) 	EAP-Message = 0x0200001c0140747261706336357836342e6c6f63616c646f6d61696e
(8) 	Message-Authenticator = 0x46ef757cfa1ee44fc3e1aa7786063a6a
(8) 	Event-Timestamp = 'Nov 27 2014 16:59:28 GMT'
(8) 	NAS-IP-Address = 127.0.0.1
(8) 	Proxy-State = 0x30
(8) # Executing section authorize from file /etc/raddb/sites-enabled/abfab-tr-idp
(8)   authorize {
(8)   psk_authorize psk_authorize {
(8)     if (TLS-PSK-Identity) 
(8)     if (TLS-PSK-Identity)  -> TRUE
(8)    if (TLS-PSK-Identity)  {
(8)      if ("%{psksql:select distinct keyid from authorizations_keys where keyid = '%{tls-psk-identity}' and '%{trust-router-coi}' like coi and '%{gss-acceptor-realm-name}' like acceptor_realm and '%{gss-acceptor-host-name}' like hostname;}") 
rlm_sql (psksql): Reserved connection (4)
rlm_sql (psksql): Executing query: 'select distinct keyid from authorizations_keys where keyid = 'key-cc2bba' and '' like coi and '' like acceptor_realm and 'main-idp65x64.localdomain' like hostname;'
(8) ERROR: SQL query failed
rlm_sql (psksql): Released connection (4)
(8) EXPAND %{psksql:select distinct keyid from authorizations_keys where keyid = '%{tls-psk-identity}' and '%{trust-router-coi}' like coi and '%{gss-acceptor-realm-name}' like acceptor_realm and '%{gss-acceptor-host-name}' like hostname;}
(8)    --> 
(8)      if ("%{psksql:select distinct keyid from authorizations_keys where keyid = '%{tls-psk-identity}' and '%{trust-router-coi}' like coi and '%{gss-acceptor-realm-name}' like acceptor_realm and '%{gss-acceptor-host-name}' like hostname;}")  -> FALSE
(8)     else else {
(8)      [reject] = reject
(8)     } # else else = reject
(8)    } # if (TLS-PSK-Identity)  = reject
(8)   } # psk_authorize psk_authorize = reject
(8)  } #  authorize = reject
(8) Using Post-Auth-Type Reject
(8) # Executing group from file /etc/raddb/sites-enabled/abfab-tr-idp
(8)  Post-Auth-Type REJECT {
(8)  attr_filter.access_reject : EXPAND %{User-Name}
(8)  attr_filter.access_reject :    --> @trapc65x64.localdomain
(8)  attr_filter.access_reject : Matched entry DEFAULT at line 11
(8)   [attr_filter.access_reject] = updated
(8)  eap : Request was previously rejected, inserting EAP-Failure
(8)   [eap] = updated
(8)   remove_reply_message_if_eap remove_reply_message_if_eap {
(8)     if (&reply:EAP-Message && &reply:Reply-Message) 
(8)     if (&reply:EAP-Message && &reply:Reply-Message)  -> FALSE
(8)    else else {
(8)     [noop] = noop
(8)    } # else else = noop
(8)   } # remove_reply_message_if_eap remove_reply_message_if_eap = noop
(8)  } # Post-Auth-Type REJECT = updated
(8) Delaying response for 1 seconds
Thread 2 waiting to be assigned a request
Waking up in 0.1 seconds.
Waking up in 0.6 seconds.
(8) Sending delayed response
(8) Sending Access-Reject packet to host 192.168.213.24 port 41310, id=241, length=0
(8) 	Proxy-State = 0x30
(8) 	EAP-Message = 0x04000004
(8) 	Message-Authenticator = 0x00000000000000000000000000000000
Sending Access-Reject Id 241 from 0.0.0.0:2083 to 192.168.213.24:41310
	Proxy-State = 0x30
	EAP-Message = 0x04000004
	Message-Authenticator = 0x00000000000000000000000000000000
Waking up in 3.0 seconds.

-- end of request --

As you can see, the SQL query fails. When I disable the psk_authorize query in the abfab-tr-idp section for the APC, it all functions ok. 

So, question is... should I be using that? If not, what needs to be changed, so that I can update the documentation accordingly?

I've included the APC Radius log in its entirety, the tidc request that triggered it, and the trust_router log output for it (if it helps). 

Any suggestions? Sam? Mark? Margaret?

With Regards

Stefan Paetow
Moonshot Industry & Research Liaison Coordinator

t: +44 (0)1235 822 125
gpg: 0x3FCE5142
xmpp: [log in to unmask]
skype: stefan.paetow.janet
Lumen House, Library Avenue, Harwell Oxford, Didcot, OX11 0SG

jisc.ac.uk
 
Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.
Jisc Collections and Janet Ltd. is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under Company No. number 2881024, VAT No. GB 197 0632 86. The registered office is: Lumen House, Library Avenue, Harwell, Didcot, Oxfordshire, OX11 0SG. T 01235 822200.




Top of Message | Previous Page | Permalink

JiscMail Tools


RSS Feeds and Sharing


Advanced Options


Archives

April 2024
March 2022
December 2021
October 2021
September 2021
August 2021
June 2021
April 2021
February 2021
January 2021
December 2020
November 2020
October 2020
August 2020
July 2020
June 2020
May 2020
April 2020
March 2020
January 2020
November 2019
October 2019
September 2019
July 2019
June 2019
May 2019
April 2019
March 2019
February 2019
January 2019
December 2018
June 2018
April 2018
November 2017
October 2017
September 2017
August 2017
July 2017
May 2017
April 2017
March 2017
February 2017
November 2016
October 2016
August 2016
July 2016
June 2016
May 2016
March 2016
February 2016
January 2016
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012
November 2012
October 2012
September 2012
August 2012
July 2012
June 2012
May 2012
April 2012
March 2012
February 2012
January 2012
December 2011
November 2011
October 2011
September 2011
August 2011
July 2011
June 2011
May 2011
April 2011
March 2011
February 2011
January 2011
November 2010
October 2010
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010


JiscMail is a Jisc service.

View our service policies at https://www.jiscmail.ac.uk/policyandsecurity/ and Jisc's privacy policy at https://www.jisc.ac.uk/website/privacy-notice

For help and support help@jisc.ac.uk

Secured by F-Secure Anti-Virus CataList Email List Search Powered by the LISTSERV Email List Manager