-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I commented out my modified handlerMappingB from my cas-servlet.xml and restored the original, and got the same error visiting '/cas/logout' and not on '/cas/login', which caused me to check my original statement. When I enabled my original config, it appears to be happening on *logoutS*.
Jeff Scott Battaglia wrote: > That would imply that your user is NULL. Does this happen if you don't > enable the throttling login attempts? The throttling login attempts, if > you're doing it by user, defaults to the normal field for userName on > the form. > > > On Mon, Feb 15, 2010 at 5:03 PM, Jeff Chapin <jeff.cha...@uni.edu > <mailto:jeff.cha...@uni.edu>> wrote: > > I have recently configured CAS as per > http://www.ja-sig.org/wiki/display/CASUM/Auditing+and+Statistics+Via+Inspektr > and http://www.ja-sig.org/wiki/display/CASUM/Throttling+Login+Attempts > > When my user logs in, I am seeing to following error in the cas.log -- > but the log-in is still behaving normally. Is this an error worth > following up with? > > According to the schema for inspektr found at > http://code.google.com/p/inspektr/wiki/DatabaseTables these tables > should *NOT* be accepting NULL, so I am not sure what the error is. > > Exception in thread "pool-2-thread-1" > org.springframework.dao.DataIntegrityViolationException: > PreparedStatementCallback; SQL [Insert into COM_AUDIT_TRAIL(AUD_USER, > AUD_CLIENT_IP, AUD_SERVER_IP, AUD_RESOURCE, AUD_ACTION, APPLIC_CD, AUD_D > ATE) Values(?, ?, ?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL into > ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") > ; nested exception is java.sql.SQLException: ORA-01400: cannot insert > NULL into ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") > > at > org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858) > at > org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:237) > at > org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask$1.doInTransactionWithoutResult(JdbcAuditTrailManager.java:96) > at > org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) > at > org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) > at > org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask.run(JdbcAuditTrailManager.java:89) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into > ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") > - -- You are currently subscribed to cas-user@lists.jasig.org <mailto:cas-user@lists.jasig.org> as: scott.battag...@gmail.com <mailto:scott.battag...@gmail.com> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user > -- > You are currently subscribed to cas-user@lists.jasig.org as: > jeff.cha...@uni.edu > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user - -- Jeff Chapin, Assistant Systems/Applications Administrator ITS-IS, University of Northern Iowa Phone: 319-273-3162 Email: jeff.cha...@uni.edu -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAkt5ybgACgkQQiaEUfQoY7Sr+QCeJnNPbI1eefUqwKVYI1NuVa5E mJAAn3+bvwSVwm5hjfTUZrLJPScSuEFM =EhO+ -----END PGP SIGNATURE----- -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
