Re: Mysql connection issue on install

[Alexei Fedotov]

Hello Mark,

IMHO, it'setter to check a particular error message in the log file.
18.09.2012 21:00 пользователь "kmn" <k...@adginc.net> написал:

> Using the headless ubuntu install guide, I get to this page in the setup:
>
> OpenMeetings - Loading ...
> The server is not yet completely initialized. Please try again in a couple
> of seconds.
> If this message persists for several minutes contact your
> Sys-Administration.
> If that message stays forever you should check the logs located in
> openmeetings_install_dir/log
> folder, probably your database user/pwd/host is wrong!
>
> My connection string in persistence.xml looks like this
>
>  Url=jdbc:mysql://localhost:**3306/openmeetings?**autoReconnect=true&amp;*
> *useUnicode=true&amp;**createDatabaseIfNotExist=true&**
> amp;characterEncoding=utf-8&**amp;connectionCollation=utf8_**
> general_ci&amp;cachePrepStmts=**true&amp;**cacheCallableStatements=true&**
> amp;cacheServerConfiguration=**true&amp;useLocalSessionState=**
> true&amp;elideSetAutoCommits=**true&amp;**alwaysSendSetIsolation=false&**
> amp;enableQueryTimeouts=false&**amp;prepStmtCacheSize=3000&**
> amp;prepStmtCacheSqlLimit=1000
>                                         , MaxActive=100
>                                         , MaxWait=10000
>                                         , TestOnBorrow=true
>                                         , poolPreparedStatements=true
>                                         , Username=openmeetings
>                                         , Password=password"/>
>
>
> The openmeetings.log file looks like this
>
> ry(BasicDataSource.java:1545) ~[commons-dbcp-jar-1.4.jar:1.**4]
>         ... 41 common frames omitted
> Caused by: java.sql.SQLException: Access denied for user 
> 'openmeetings'@'localhost'
> (using password: YES)
>         at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**java:1055)
> ~[mysql-connector-java-jar-5.**1.9.jar:na]
>
> I have checked the username and password for mysql , they are ok, I've
> even changed the grant on openmeetings to 'openmeetings'@'%', with no
> effect.
>
> Although I know what I am doing with MySQL, I've no clue with JDBC.
>
> Any suggestions to where I might be going wrong?
>
>
> --
> Mark Newnham
>
> American Data Group
> (303)741-5711
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>