[Kamailio-Users] Res: Problems with SerMyAdmin Installation

oso che bol ndlgroup1 at gmail.com
Thu Sep 25 18:16:12 CEST 2008


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 at asteriskguide.com>wrote:

> 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 at asterisk.ie>
> Para: users at 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-tp16965040p19415041.html
> Sent from the OpenSER Users Mailing List mailing list archive at
> Nabble.com.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080925/d0ef0012/attachment.htm 


More information about the Users mailing list