hello all,<br><br>i am facing two problems with serMyAdmin.05-beta. the problems are<br>1- Error when adding a user in groups<br>2- wrong table attributes when adding user preferences.<br><br><br>for the first problem, after i installed openser 1.3.2 with mySQL DB, i loaded the group model after connecting my openser to the PSTN. so i want to use the group model to permit the users for local, long distance and international calls. it work fine with me when i added the users using "openserctl acl add". but when i added the groups using serMyAdmin i get the folowing error message:<br>
<br><i>Message: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup]<br>Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup]<br>
Class: UserController<br>At Line: [111]<br>Code Snippet:<br><br>org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup]<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<br>
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<br> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<br> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106)<br>
at org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93)<br> at org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<br>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<br> at 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:619)<br>Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [UserGroup]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup]<br>
at UserController$_closure6_closure11.doCall(UserController.groovy:111)<br> at UserController$_closure6.doCall(UserController.groovy:101)<br> at UserController$_closure6.doCall(UserController.groovy)<br> ... 29 more<br>Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [UserGroup]<br>
at $Proxy3.saveOrUpdate(Unknown Source)<br> ... 32 more<br>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'agentA-inrialpes.fr-' for key 2<br> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br>
at com.mysql.jdbc.Util.getInstance(Util.java:381)<br> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<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 com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<br> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<br> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<br>
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<br> at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br> ... 33 more</i><br><br>
<br>=========================================<br><br>the second problem is when adding a user references, basically i got a wrong attributes. specifically, the username is not stored in the database. see below the result<br>
<br><i>Username: <a href="mailto:agentA@inrialpes.fr">agentA@inrialpes.fr</a><br>Attribute: callfwd<br>Value: <a href="mailto:sip%3AAgentB@inrialpes.fr">sip:AgentB@inrialpes.fr</a><br>Type: String:String<br>Last Modified: 2008-07-07 17:45:02.0<br>
<br></i>and in the MySQL database it is:<br><br>+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+<br>| id | uuid | username | domain | attribute | type | value | last_modified | version | user_id |<br>
+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+<br>| 6 | 12 | 0 | <a href="http://inrialpes.fr">inrialpes.fr</a> | callfwd | 0 | <a href="mailto:sip%3AAgentB@inrialpes.fr">sip:AgentB@inrialpes.fr</a> | 2008-07-07 17:45:02 | 0 | 12 |<br>
+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+<br>=========================================<br><br>does anyone faces thous problem? <br><br>
AHMED ALALI<br>