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

Hi Brian,

I've allready passed through a similar problem... Look at your subscriber table (using MYSQL or phpmyadmin for example) and verify the field date of user creation. Probably you have an incompatible type of data in that field and Grails don't know how to handle it. Change the values and then try sermyadmin again. Regards,

Nuno

2008/9/8 Brian Chamberlain brian@asterisk.ie

Hi,

Did you ever get this resolved?

I'm getting the same error.. Looks like serMyAdmin.war isn't talking to the database properly. I can't log in as the user I setup when i imported the openser.sql file..

When I click register I fill in all the details and when I click create I get:

Grails Runtime Exception

Error Details

Message: Caused by: java.lang.NullPointerException Class: NewUserController At Line: [39] Code Snippet: Stack Trace

org.codehaus.groovy.runtime.InvokerInvocationException: java.lang.NullPointerException 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: java.lang.NullPointerException at RegisterUser.toString(RegisterUser.groovy) at NewUserController$_closure3.doCall(NewUserController.groovy:39) at NewUserController$_closure3.doCall(NewUserController.groovy) ... 29 more

Any Help would be brilliant!

Regards, Brian -- View this message in context: http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19377... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Hi All,

I dropped the openser table (no users), created them again with openser then imported the file and bam it works!

Thanks for all your help!

Regards, Brian.

On 8 Sep 2008, at 20:38, Tiago Rés wrote:

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.

2008/9/8 Nuno Marques yangsengopenser@gmail.com Hi Brian,

I've allready passed through a similar problem... Look at your subscriber table (using MYSQL or phpmyadmin for example) and verify the field date of user creation. Probably you have an incompatible type of data in that field and Grails don't know how to handle it. Change the values and then try sermyadmin again. Regards,

             Nuno

2008/9/8 Brian Chamberlain brian@asterisk.ie

Hi,

Did you ever get this resolved?

I'm getting the same error.. Looks like serMyAdmin.war isn't talking to the database properly. I can't log in as the user I setup when i imported the openser.sql file..

When I click register I fill in all the details and when I click create I get:

Grails Runtime Exception

Error Details

Message: Caused by: java.lang.NullPointerException Class: NewUserController At Line: [39] Code Snippet: Stack Trace

org.codehaus.groovy.runtime.InvokerInvocationException: java.lang.NullPointerException 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: java.lang.NullPointerException at RegisterUser.toString(RegisterUser.groovy) at NewUserController $_closure3.doCall(NewUserController.groovy:39) at NewUserController$_closure3.doCall(NewUserController.groovy) ... 29 more

Any Help would be brilliant!

Regards, Brian -- View this message in context: http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19377... Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

---

Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Brian Chamberlain Dot Net Solutions Ltd. 68 Parkwest Enterprise Centre, Parkwest, Dublin 12, Ireland. DDI: [+353] 1 6296521

FAX: [+353] 1 6237029

mobile: [+353] 86 3883003

email: brian@asterisk.ie web: www.asterisk.ie

* Looking for the most advanced PBX available that can also save you a fortune in communication costs? asterisk.ie *

e-mail disclaimer

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited.

If you have received this e-mail in error, please advise the sender immediately, then delete this e-mail.