[Kamailio-Users] Problems with SerMyAdmin Installation

[Brian Chamberlain]

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 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
>
>

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 at 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.






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080908/918703c3/attachment.htm>