<div dir="ltr">Hi,<br><br> I´m trying to install SerMyAdmin in my Openser 1.2.2 machine. I follow the steps that were on <a href="http://www.sermyadmin.org">www.sermyadmin.org</a>.<br> I accomplished the installation task, but now when i try to do something on the DB (for example: create a new user) it gives me a lot of errors.<br>
My experience with Grails is null so i don't know were to start.<br> Below i'll show the error messages.<br> If anyone could give me an hand i'll appreciate.<br> Thanks in advance,<br><br> Nuno<br>
<br><br><strong>Message:</strong> could not insert: [User]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [User] <br>
<strong>Caused by:</strong>
org.springframework.dao.DataIntegrityViolationException: could not
insert: [User]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not insert:
[User] <br>
<strong>Class:</strong> UserController <br>
<strong>At Line:</strong> [147] <br>
<strong>Code Snippet:</strong><br><br>Stack<br><pre>org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.DataIntegrityViolationException: could not insert: [User]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [User]<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<br>
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<br> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<br> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106)<br>
at org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93)<br> at org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<br>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<br>
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<br> at java.lang.Thread.run(Thread.java:595)<br>Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [User]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [User]<br>
at UserController$_closure8.doCall(UserController.groovy:147)<br> at UserController$_closure8.doCall(UserController.groovy)<br> ... 29 more<br>Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [User]<br>
at $Proxy3.saveOrUpdate(Unknown Source)<br> ... 31 more<br>Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '4000-192.168.137.1' for key 2<br> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1011)<br>
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<br> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<br> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<br>
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<br> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<br> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<br> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<br>
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<br> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<br> at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br>
... 32 more</pre><br></div>