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 <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > > >> 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-tp16965040p19377037.html >> 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 > >
_______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
