[OpenSIPS-Users] SerMyAdmin - Invalid username or password ?

[Flavio Goncalves]

Hi Nezdad,

Your database was not updated by the install utility. Please delete your
database, recreate-it using opensipsdbctl create and reinstall the database
modifications. The message below says that you do not have the areacode
field in your database and this field is created by the installation
program.

Regards,

--------------------------------------------------
Flavio E. Goncalves
CEO - V.Office
Fone: +554830258590/+554884085000
OpenSIPS Bootcamp (Frankfurt Sep 20-24)



2010/7/8 Nedzad <nedzad.sila at hotmail.com>

>  I can't login to SerMyAdmin. I have message "Invalid username or
> password".
> I have tried all  defaults options (username and password) but for nothing.
>
>
> How do I add new user as "admin" in mysql "subscriber" table,  with witch I
> will be able to login on SerMyAdmin ?
>
> Also,
>
> when I try to register new user via SerMyAdmin, get this error>>>
>
> *Grails Runtime Exception
> Error Details*
>
> *Message*: could not execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
> *Caused by*:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
> *Class*: AuthController
> *At Line*: [112]
> *Code Snippet:*
>
> *Stack Trace*
>
> org.codehaus.groovy.runtime.InvokerInvocationException:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
>  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.jsecurity.web.servlet.JSecurityFilter.doFilterInternal(JSecurityFilter.java:384)
>  at
> org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:183)
>  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.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:619)
> Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException:
> could not execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
>  at AuthController$_closure3.doCall(AuthController.groovy:112)
>  at AuthController$_closure3.doCall(AuthController.groovy)
>  ... 28 more
> Caused by: org.hibernate.exception.SQLGrammarException: could not execute
> query
>  ... 30 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'this_.areacode' in 'field list'
>  at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
>  at com.mysql.jdbc.Util.getInstance(Util.java:381)
>  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
>  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
>  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
>  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
>  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
>  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
>  at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
>  at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
>  at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>  ... 30 more
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100711/4977c517/attachment.htm