<div dir="ltr">turns out the issue is still there, I was testing the prod instances instead of the test env...<div><br></div><div>so, I do see in the log that the employeeIDÂ got a value from the ldap connector, but later, in the log, after the sql connector, it seems to say that there are no attributes to release... but it is supposed to release employeeID.</div><div><br></div><div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.190790-04:00 idp-prod-1.cua 6d8855831853[1243]: 2018-06-01 20:39:16,186 - lv=DEBUG [net.shibboleth.idp.attribute.resolver.AbstractDataConnector:139] js=1pn4zbp6ic4tzixy8n91w9sab c=10.2.0.215 - Data Connector 'adLdapConnector': produced the following 6 attributes during resolution [employeeID, memberOf, sn, cn, mail, entryDN]</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.190790-04:00 idp-prod-1.cua 6d8855831853[1243]: 2018-06-01 20:39:16,186 - lv=DEBUG [net.shibboleth.idp.attribute.resolver.AbstractDataConnector:143] js=1pn4zbp6ic4tzixy8n91w9sab c=10.2.0.215 - Data Connector 'adLdapConnector': Attribute 'employeeID': Values '[StringAttributeValue{value=1600000}]'</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><br class="gmail-Apple-interchange-newline"></div>...</div><div><br></div><div><div class="gmail-SourceLine gmail-SourceLineHL gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;background-color:rgb(245,233,152);color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.206280-04:00 idp-prod-1.cua 6d8855831853[1243]: 2018-06-01 20:39:16,204 - lv=DEBUG [net.shibboleth.idp.attribute.resolver.dc.rdbms.impl.TemplatedExecutableStatementBuilder:169] js=1pn4zbp6ic4tzixy8n91w9sab c=10.2.0.215 - Template text select * from accounts where employeeID='$employeeID.get(0)'; yields select * from accounts where employeeID='1600000';</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.224584-04:00 idp-prod-1.cua 6d8855831853[1243]: Jun 01, 2018 8:39:16 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.224675-04:00 idp-prod-1.cua 6d8855831853[1243]: INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 1, acquireRetryDelay -> 5000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqq1hf9v1goyvf81wkagy7|67bd351e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.sqlite.JDBC, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bqq1hf9v1goyvf81wkagy7|67bd351e, idleConnectionTestPeriod -> 180, initialPoolSize -> 3, jdbcUrl -> jdbc:sqlite:/data/cua-eduPerson.db, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.251131-04:00 idp-prod-1.cua 6d8855831853[1243]: 2018-06-01 20:39:16,249 - lv=ERROR [net.shibboleth.idp.profile.impl.ResolveAttributes:299] js=1pn4zbp6ic4tzixy8n91w9sab c=10.2.0.215 - Profile Action ResolveAttributes: Error resolving attributes</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.251131-04:00 idp-prod-1.cua 6d8855831853[1243]: net.shibboleth.idp.attribute.resolver.ResolutionException: Data Connector 'sqliteConnector': Unable to execute SQL query</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.251131-04:00 idp-prod-1.cua 6d8855831853[1243]: #011at net.shibboleth.idp.attribute.resolver.dc.rdbms.impl.RDBMSDataConnector.retrieveAttributes(RDBMSDataConnector.java:173)</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.251131-04:00 idp-prod-1.cua 6d8855831853[1243]: Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: accounts)</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.251131-04:00 idp-prod-1.cua 6d8855831853[1243]: #011at org.sqlite.core.DB.newSQLException(DB.java:909)</pre></div><div class="gmail-SourceLine gmail-splFont-mono" style="border-color:rgb(204,204,204);font-family:"Droid Sans Mono",Consolas,Monaco,"Courier New",Courier,monospace;color:rgb(51,51,51);font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><pre style="border-color:rgb(204,204,204);margin:0px;padding:2px;font-size:12px;word-wrap:break-word;white-space:pre-wrap">2018-06-01T20:39:16.264150-04:00 idp-prod-1.cua 6d8855831853[1243]: 2018-06-01 20:39:16,262 - lv=DEBUG [net.shibboleth.idp.profile.impl.FilterAttributes:270] js=1pn4zbp6ic4tzixy8n91w9sab c=10.2.0.215 - Profile Action FilterAttributes: No attribute context, no attributes to filter</pre></div>...</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Jun 1, 2018 at 8:20 PM Cantor, Scott <<a href="mailto:cantor.2@osu.edu">cantor.2@osu.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Thanks a lot. I broke a rule of debugging and made multiple changes at once...<br>
> now I cannot reproduce the "No attributes available" issue...<br>
<br>
I would expect if you put the database offline and try it, you should get that result, per my last note.<br>
<br>
-- Scott<br>
<br>
-- <br>
For Consortium Member technical support, see <a href="https://wiki.shibboleth.net/confluence/x/coFAAg" rel="noreferrer" target="_blank">https://wiki.shibboleth.net/confluence/x/coFAAg</a><br>
To unsubscribe from this list send an email to <a href="mailto:users-unsubscribe@shibboleth.net" target="_blank">users-unsubscribe@shibboleth.net</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Thanks,<div>Mohamed.</div></div></div>