<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV>Hi Brian, </DIV>
<DIV> </DIV>
<DIV>I have seen some people complianing about this, but I have not being able to reproduce the problem. Could you send me a copy of your database schema, it is probably the source of the problem. Have you applied the openser.sql in the latest version?</DIV>
<DIV> </DIV>
<DIV>Best regards, </DIV>
<DIV> </DIV>
<DIV>Flavio E. Goncalves<BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif">----- Mensagem original ----<BR>De: Brian Chamberlain <brian@asterisk.ie><BR>Para: users@lists.kamailio.org<BR>Enviadas: Quarta-feira, 10 de Setembro de 2008 13:45:04<BR>Assunto: Re: [Kamailio-Users] Problems with SerMyAdmin Installation<BR><BR><BR>Hi,<BR><BR>Can you add your users to groups? I just went back to openser 1.2 because of<BR>the problems I was facing with sermyadmin adding users to groups and bombing<BR>out. I was using 1.33 - but it seems that that is not the problem.<BR><BR>I can add groups ok but get the following when adding users to those groups!<BR>(GRRRR)<BR><BR>Grails Runtime Exception<BR><BR>Error Details<BR><BR>Message: could not insert: [UserGroup]; nested exception is<BR>org.hibernate.exception.ConstraintViolationException: could not insert:<BR>[UserGroup] <BR>Caused by: org.springframework.dao.DataIntegrityViolationException: could<BR>not insert:
[UserGroup]; nested exception is<BR>org.hibernate.exception.ConstraintViolationException: could not insert:<BR>[UserGroup] <BR>Class: UserController <BR>At Line: [115] <BR>Code Snippet:<BR>Stack Trace<BR><BR>org.codehaus.groovy.runtime.InvokerInvocationException:<BR>org.springframework.dao.DataIntegrityViolationException: could not insert:<BR>[UserGroup]; nested exception is<BR>org.hibernate.exception.ConstraintViolationException: could not insert:<BR>[UserGroup]<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at<BR>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<BR>
at<BR>org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<BR> at<BR>org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<BR> at<BR>org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR>
at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at<BR>org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106)<BR> at<BR>org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93)<BR> at<BR>org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at<BR>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR>
at<BR>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR> at<BR>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<BR> at<BR>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<BR> at<BR>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR> at<BR>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR> at<BR>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<BR> at<BR>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<BR> at<BR>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<BR>not insert: [UserGroup]; nested exception is<BR>org.hibernate.exception.ConstraintViolationException: could not insert:<BR>[UserGroup]<BR> at UserController$_closure6_closure13.doCall(UserController.groovy:115)<BR> at UserController$_closure6.doCall(UserController.groovy:105)<BR> at UserController$_closure6.doCall(UserController.groovy)<BR> ... 29 more<BR>Caused by: org.hibernate.exception.ConstraintViolationException: could not<BR>insert: [UserGroup]<BR> at $Proxy3.saveOrUpdate(Unknown Source)<BR> ... 32 more<BR>Caused by:<BR>com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:<BR>Duplicate entry
'brian-sip.asterisk.ie-' 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<BR>com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR> at<BR>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<BR> at<BR>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<BR>
at<BR>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<BR> at<BR>org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<BR> ... 33 more<BR><BR><BR><BR><BR><BR><BR>Hello,<BR><BR>I solved my problem with Nuno's help. My problem was with the permissions in<BR>mysql. The command GRANT ALL PRIVILEGES ON openser.* TO user@'%' IDENTIFIED<BR>BY 'Password'; did't add the user properly.. I had to also use GRANT ALL<BR>PRIVILEGES ON openser.* TO user@'localhost' IDENTIFIED BY 'password';<BR>because sermyadmin and mysql were running in the same machine. After that I<BR>could run sermyadmin and it changed all the tables properly.<BR><BR><BR>-- <BR>View this message in context: <A href="http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19415041.html"
target=_blank>http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19415041.html</A><BR>Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.<BR><BR><BR>_______________________________________________<BR>Users mailing list<BR><A href="mailto:Users@lists.kamailio.org" ymailto="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</A><BR><A href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target=_blank>http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</A><BR></DIV></DIV></div></body></html>