[Kamailio-Users] Problems with SerMyAdmin Installation

[Brian Chamberlain]

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.