<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16385"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT color=#280b00 face=Cambria>Thank you Flavio.</FONT></DIV>
<DIV><FONT color=#280b00 face=Cambria></FONT> </DIV>
<DIV><FONT color=#280b00 face=Cambria>I solved this problem in a way that I
recreated database and now everything is OK except of "Register"
a new user. </FONT></DIV>
<DIV><FONT color=#280b00 face=Cambria></FONT> </DIV>
<DIV><FONT color=#280b00 face=Cambria>When I click to Register new user I
have this error </FONT></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><EM></EM></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><EM>Authentication failed; nested exception is
javax.mail.AuthenticationFailedException</EM></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><EM></EM></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span>I posted a new list with this problem in
a following link</SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><A
href="http://lists.opensips.org/pipermail/users/2010-July/013835.html"><FONT
title="http://lists.opensips.org/pipermail/users/2010-July/013835.html CTRL + Click to follow link"
size=3>http://lists.opensips.org/pipermail/users/2010-July/013835.html</FONT></A></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"
class=Apple-style-span><FONT color=#280b00 size=3
face=Cambria></FONT> </DIV></SPAN>
<DIV><FONT color=#280b00 face=Cambria></FONT> </DIV>
<DIV><FONT color=#280b00 face=Cambria></FONT> </DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><FONT color=#280b00 size=3 face=Cambria></FONT><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:flavio@asteriskguide.com CTRL + Click to follow link"
href="mailto:flavio@asteriskguide.com">Flavio Goncalves</A> </DIV>
<DIV><B>Sent:</B> Sunday, July 11, 2010 16:43</DIV>
<DIV><B>To:</B> <A
title="mailto:users@lists.opensips.org CTRL + Click to follow link"
href="mailto:users@lists.opensips.org">OpenSIPS users mailling list</A> </DIV>
<DIV><B>Subject:</B> Re: [OpenSIPS-Users] SerMyAdmin - Invalid username or
password ?</DIV></DIV></DIV>
<DIV><BR></DIV>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
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<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></BODY></HTML>