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 <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > 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") > > - -- > Jeff Chapin, > Assistant Systems/Applications Administrator > ITS-IS, University of Northern Iowa > Phone: 319-273-3162 Email: [email protected] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkt5xL8ACgkQQiaEUfQoY7RFcACfWw/pV+xzz7C/1o0agYWBCWZZ > ZUoAnAto+Eb7yNlAZdOyci66dZqCTbhf > =yfee > -----END PGP SIGNATURE----- > > -- > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
