Helo,

I successful install sermyadmin 0.8 for my openser 1.2.

I successful launch the web, But i can not login.

Regards, -LN

On Wed, Sep 10, 2008 at 1:36 PM, Flavio Goncalves flavio@asteriskguide.comwrote:

Hi Brian,

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?

Best regards,

Flavio E. Goncalves

----- Mensagem original ---- De: Brian Chamberlain brian@asterisk.ie Para: users@lists.kamailio.org Enviadas: Quarta-feira, 10 de Setembro de 2008 13:45:04 Assunto: Re: [Kamailio-Users] Problems with SerMyAdmin Installation

Hi,

Can you add your users to groups? I just went back to openser 1.2 because of the problems I was facing with sermyadmin adding users to groups and bombing out. I was using 1.33 - but it seems that that is not the problem.

I can add groups ok but get the following when adding users to those groups! (GRRRR)

Grails Runtime Exception

Error Details

Message: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] Class: UserController At Line: [115] Code Snippet: Stack Trace

org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at

org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at

org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at

org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106) at

org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93) at

org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at UserController$_closure6_closure13.doCall(UserController.groovy:115) at UserController$_closure6.doCall(UserController.groovy:105) at UserController$_closure6.doCall(UserController.groovy) ... 29 more Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup] at $Proxy3.saveOrUpdate(Unknown Source) ... 32 more Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'brian-sip.asterisk.ie-' for key 2 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1011) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at

com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922) at

org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) ... 33 more

Hello,

I solved my problem with Nuno's help. My problem was with the permissions in mysql. The command GRANT ALL PRIVILEGES ON openser.* TO user@'%' IDENTIFIED BY 'Password'; did't add the user properly.. I had to also use GRANT ALL PRIVILEGES ON openser.* TO user@'localhost' IDENTIFIED BY 'password'; because sermyadmin and mysql were running in the same machine. After that I could run sermyadmin and it changed all the tables properly.

-- View this message in context: http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19415... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users