[Kamailio-Users] Problems with SerMyAdmin Installation

[Tiago Rés]

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 at 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 at 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-tp16965040p19377037.html
>> Sent from the OpenSER Users Mailing List mailing list archive at
>> Nabble.com.
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080908/88bbd1da/attachment.htm