[OpenSER-Users] 2 problems with serMyAdmin

[Ahmed Huraimel]

hello all,

i am facing two problems with serMyAdmin.05-beta. the problems are
1- Error when adding a user in groups
2- wrong table attributes when adding user preferences.


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:

*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: [111]
Code Snippet:

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:619)
Caused by: org.springframework.dao.DataIntegrityViolationException: could
not insert: [UserGroup]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not insert:
[UserGroup]
at UserController$_closure6_closure11.doCall(UserController.groovy:111)
at UserController$_closure6.doCall(UserController.groovy:101)
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.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'agentA-inrialpes.fr-' for key 2
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
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*


=========================================

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

*Username: agentA at inrialpes.fr
Attribute: callfwd
Value: sip:AgentB at inrialpes.fr <sip%3AAgentB at inrialpes.fr>
Type: String:String
Last Modified: 2008-07-07 17:45:02.0

*and in the MySQL database it is:

+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+
| id | uuid | username    | domain       | attribute | type |
value                   | last_modified       | version | user_id |
+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+
|  6 | 12   | 0           | inrialpes.fr | callfwd   |    0 |
sip:AgentB at inrialpes.fr <sip%3AAgentB at inrialpes.fr> | 2008-07-07 17:45:02
|       0 |      12 |
+----+------+-------------+--------------+-----------+------+-------------------------+---------------------+---------+---------+
=========================================

does anyone faces thous problem?

AHMED ALALI
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.openser.org/pipermail/users/attachments/20080707/a04e2435/attachment-0001.htm