<div dir="ltr">Helo,<br><br>I successful install sermyadmin 0.8 for my openser 1.2.<br><br>I successful launch the web, But i can not login.<br><br>Regards,<br>-LN<br><br><div class="gmail_quote">On Wed, Sep 10, 2008 at 1:36 PM, Flavio Goncalves <span dir="ltr"><<a href="mailto:flavio@asteriskguide.com">flavio@asteriskguide.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><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 <<a href="mailto:brian@asterisk.ie" target="_blank">brian@asterisk.ie</a>><br>Para: <a href="mailto:users@lists.kamailio.org" target="_blank">users@lists.kamailio.org</a><br>
Enviadas: Quarta-feira, 10 de Setembro de 2008 13:45:04<br>Assunto: Re: [Kamailio-Users] Problems with SerMyAdmin Installation<div><div></div><div class="Wj3C7c"><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" target="_blank">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></div></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="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>
<br></blockquote></div><br></div>