Hi Nezdad, <div><br></div><div>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. </div>
<div><br></div><div>Regards, </div><div><br clear="all">--------------------------------------------------<br>Flavio E. Goncalves<br>CEO - V.Office <br>Fone: +554830258590/+554884085000<br>OpenSIPS Bootcamp (Frankfurt Sep 20-24)<br>
<br>
<br><br><div class="gmail_quote">2010/7/8 Nedzad <span dir="ltr"><<a href="mailto:nedzad.sila@hotmail.com">nedzad.sila@hotmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="padding-left:10px;padding-right:10px;padding-top:15px" name="Compose message area">
<div><font color="#280b00" face="Cambria">I can't login to SerMyAdmin. I have
message "Invalid username or password".<br>I have tried all defaults
options (username and password) but for nothing. </font></div>
<div> </div>
<div><font color="#280b00" face="Cambria">How do I add new user as "admin" in mysql
"subscriber" table, with witch I<br>will be able to login on SerMyAdmin
?</font></div>
<div> </div>
<div><font color="#280b00" face="Cambria">Also, </font></div>
<div> </div>
<div><font color="#280b00" face="Cambria">when I try to register new user via
SerMyAdmin, get this error>>></font></div>
<div> </div>
<div><font color="#280b00" size="4" face="Cambria"><strong>Grails Runtime
Exception<br>Error Details</strong></font></div>
<div> </div>
<div><font color="#280b00" face="Cambria"><strong>Message</strong>: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<br><strong>Caused by</strong>:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<br><strong>Class</strong>: AuthController<br><strong>At
Line</strong>: [112]<br><strong>Code Snippet:</strong></font></div>
<div> </div>
<div><font color="#280b00" size="4" face="Cambria"><strong>Stack
Trace</strong></font></div>
<div> </div>
<div><font color="#280b00" face="Cambria">org.codehaus.groovy.runtime.InvokerInvocationException:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<br> at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<br> at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<br> at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.jsecurity.web.servlet.JSecurityFilter.doFilterInternal(JSecurityFilter.java:384)<br> at
org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:183)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<br> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<br> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<br> at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<br> at
java.lang.Thread.run(Thread.java:619)<br>Caused by:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<br> at
AuthController$_closure3.doCall(AuthController.groovy:112)<br> at
AuthController$_closure3.doCall(AuthController.groovy)<br> ... 28
more<br>Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query<br> ... 30 more<br>Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'this_.areacode' in 'field list'<br> at
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br> at
com.mysql.jdbc.Util.getInstance(Util.java:381)<br> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)<br> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<br> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<br> at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<br> at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<br> at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<br> at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<br> at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)<br> at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<br> ...
30 more</font></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>