<div dir="ltr">Hello,<br><br>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.<br>
<br><div class="gmail_quote">2008/9/8 Nuno Marques <span dir="ltr"><<a href="mailto:yangsengopenser@gmail.com">yangsengopenser@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">Hi Brian,<br><br>I've allready passed through a similar problem...<br>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.<br>
Regards,<br><br> Nuno<br><br><br> <br><br><div class="gmail_quote">2008/9/8 Brian Chamberlain <span dir="ltr"><<a href="mailto:brian@asterisk.ie" target="_blank">brian@asterisk.ie</a>></span><div><div>
</div><div class="Wj3C7c"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Hi,<br>
<br>
Did you ever get this resolved?<br>
<br>
I'm getting the same error.. Looks like serMyAdmin.war isn't talking to the<br>
database properly. I can't log in as the user I setup when i imported the<br>
openser.sql file..<br>
<br>
When I click register I fill in all the details and when I click create I<br>
get:<br>
<br>
Grails Runtime Exception<br>
<br>
Error Details<br>
<br>
Message:<br>
Caused by: java.lang.NullPointerException<br>
Class: NewUserController<br>
At Line: [39]<br>
Code Snippet:<br>
Stack Trace<br>
<br>
org.codehaus.groovy.runtime.InvokerInvocationException:<br>
java.lang.NullPointerException<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<br>
at<br>
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<br>
at<br>
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<br>
at<br>
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.jsecurity.web.servlet.WebInterceptorFilter.doFilterInternal(WebInterceptorFilter.java:106)<br>
at<br>
org.jsecurity.web.servlet.SecurityContextFilter.doFilterInternal(SecurityContextFilter.java:93)<br>
at<br>
org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br>
at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br>
at<br>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br>
at<br>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<br>
at<br>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br>
at<br>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br>
at<br>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br>
at<br>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br>
at<br>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<br>
at<br>
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:595)<br>
Caused by: java.lang.NullPointerException<br>
at RegisterUser.toString(RegisterUser.groovy)<br>
at NewUserController$_closure3.doCall(NewUserController.groovy:39)<br>
at NewUserController$_closure3.doCall(NewUserController.groovy)<br>
... 29 more<br>
<br>
<br>
Any Help would be brilliant!<br>
<br>
Regards,<br>
Brian<br>
--<br>
View this message in context: <a href="http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19377037.html" target="_blank">http://www.nabble.com/Problems-with-SerMyAdmin-Installation-tp16965040p19377037.html</a><br>
Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div></div></div><br></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>