[OpenSER-Users] Problems with SerMyAdmin Installation

[Mark Koopmann]

Hi Guilherme,
 
i have Openser 1.3.1, SerMyadmin 0.5 and CDRTool 6.4.1 installed.

I think it is a problem with the mysql structure. Mailinglist user flavio
sent me a new sql structure (thanks) but this killed the CDRTool and did not
fixed the problem with the SerMyAdmin. Can you give me a structure which
will work with this tools installed? Now the structure is the original one
(see attached txt file) and the SerMyadmin returns me the following error:

Grails Runtime Exception
Error Details
Message: could not execute query; nested exception is
org.hibernate.exception.JDBCConnectionException: could not execute query 
Caused by: org.springframework.dao.DataAccessResourceFailureException: could
not execute query; nested exception is
org.hibernate.exception.JDBCConnectionException: could not execute query 
Class: NewUserController 
At Line: [33] 
Code Snippet:

Stack Trace
org.codehaus.groovy.runtime.InvokerInvocationException:
org.springframework.dao.DataAccessResourceFailureException: could not
execute query; nested exception is
org.hibernate.exception.JDBCConnectionException: could not execute query
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:630)	at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDis
patcher.java:436)	at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:374)	at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
.java:302)	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebIntercept
orFilter.java:106)	at
org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityCon
textFilter.java:93)	at
org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter
.java:106)	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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(Http
11Protocol.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.DataAccessResourceFailureException: could not
execute query; nested exception is
org.hibernate.exception.JDBCConnectionException: could not execute query
at NewUserController$_closure2.doCall(NewUserController.groovy:33)	at
NewUserController$_closure2.doCall(NewUserController.groovy)	... 29
moreCaused by: org.hibernate.exception.JDBCConnectionException: could not
execute query	... 31 moreCaused by:
com.mysql.jdbc.CommunicationsException: The last packet successfully
received from the server was143932 seconds ago.The last packet sent
successfully to the server was 143932 seconds ago, which  is longer than the
server configured value of 'wait_timeout'. You should consider either
expiring and/or testing connection validity before use in your application,
increasing the server configured values for client timeouts, or using the
Connector/J connection property 'autoReconnect=true' to avoid this problem.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)	at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)	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.executeQuery(PreparedStatement.java:1885)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:93)	... 31 moreCaused by:
java.net.SocketException: Broken pipe	at
java.net.SocketOutputStream.socketWrite0(Native Method)	at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)	at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)	at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)	at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)	at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3227)	... 37 more

Thanks in advance
Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: openser.sql
Type: application/octet-stream
Size: 26978 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080502/748bb418/attachment.obj>