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 <[email protected]> > 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
