Robert,
There are many things that can stop MySQL access from working, it is slow work to go through each of them. Where physically are you located and what is your timezone ? I am in Australia and GMT +10. Maybe we could chat and quickly go though a few steps? A few suggestions; 1) I am wondering what might be in your red5/log file, in particularly the red5/log/openmeetings.log file ? e.g. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.20-bin.jar:na] 2) Is your MySQL database local on the OM server, or on a remote server? 3) Is your mysql account name password correct? E.g. does this work for you: mysql -u openmeetings -pXXXX openmeetings 4) Does your MySQL openmeetings database contain tables and data. I usually drop my table, then re-add it, and re-apply the permissions. (which I do not believe is necessary, but I do it anyway). 5) What is the path and file name of your mysql connection file, for example mind is; /usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml Thanks, George Kirkham From: Robert Chalmers [mailto:[email protected]] Sent: Tuesday, 12 June 2012 9:59 AM To: [email protected] Subject: Re: folder, probably your database user/pwd/host is wrong! Back to square 1. Nothing I do will cause this v2.0 to install and use a mysql database. On Tue, Jun 12, 2012 at 9:34 AM, Robert Chalmers <[email protected]> wrote: Well gee - isn't that handy. Thanks George. I've been struggling with this as well for a few days now .... No word anywhere that this file wasn't even in the distrib. Thanks Robert On Tue, Jun 12, 2012 at 9:04 AM, George Kirkham <[email protected]> wrote: Sysdebian, Do you have mysql-connector-java-5.1.20-bin.jar in your red5/webapps/openmeetings/WEB-INF/lib folder ? Of course there may be another reason, but I wanted to check with you as missing this step has been an issue for me in the past. For me this is “/usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1.20-bin.jar”. To my knowledge the mysql jar file is not longer shipped with OpenMeetings and we need to download it and copy it into the lib folder as a manual step. Here is the URL http://www.mysql.com/downloads/connector/j/ Thanks, George Kirkham From: sysdebian [mailto:[email protected]] Sent: Monday, 11 June 2012 11:31 PM To: [email protected] Subject: folder, probably your database user/pwd/host is wrong! Hello, I have install apache-openmeetings-incubating-2.0.0.r1348677-10-06-2012_2307.tar.gz and everything look fine but when I try the browser install I got this message: -------------------------------- 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! -------------------------------- The user/pwd/host is ok, here you are my /usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml related configuration: -------------------------------- <property name="openjpa.ConnectionProperties" value="DriverClassName=com.mysql.jdbc.Driver , Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000 , MaxActive=100 , MaxWait=10000 , TestOnBorrow=true , poolPreparedStatements=true , Username=openmeetings , Password=XXXX"/> <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/> -------------------------------- And you can see the database setup is correct: -------------------------------- # mysql -u openmeetings -pXXXX openmeetings Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 583 Server version: 5.1.61-0+squeeze1 (Debian) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -------------------------------- These are the steps which I did to install openmeetings: -------------------------------- aptitude install sun-java6-jdk aptitude install openoffice.org-writer openoffice.org-calc openoffice.org-impress openoffice.org-draw openoffice.org-math aptitude install imagemagick aptitude install sox wget https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1348677-10-06-2012_2307.tar.gz mkdir openmeetings cd openmeetings tar zxf apache-openmeetings-incubating-2.0.0.r1348677-10-06-2012_2307.tar.gz mv openmeetings /usr/lib/red5 chown -R nobody /usr/lib/red5 chmod +x /usr/lib/red5/red5.sh vim /etc/init.d/red5 chmod +x /etc/init.d/red5 cd /usr/lib/red5/ cp -a webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml vim webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml /etc/init.d/red5 start netstat -tanp|grep -i listen tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 11799/mysqld tcp 0 0 127.0.0.1:8100 0.0.0.0:* LISTEN 18994/soffice.bin tcp6 0 0 :::1935 :::* LISTEN 18687/java tcp6 0 0 :::9999 :::* LISTEN 18687/java tcp6 0 0 :::8088 :::* LISTEN 18687/java tcp6 0 0 :::5080 :::* LISTEN 18687/java tcp6 0 0 :::53062 :::* LISTEN 18687/java -------------------------------- And then I try the install browser: http://hostname:5080/openmeetings/install and got the error. The log output: ------------------------------ cd /usr/lib/red5/log > 0.0.0.0_access.2012-06-11.log ; > error.log ;>openmeetings.log ;>red5.log #only red5.log writes something when I refresh the browser: 2012-06-11 15:30:27,179 [http-0.0.0.0-5080-1] INFO o.a.c.c.C.[.[.0.0.0.[/openmeetings] - Velocity [debug] ResourceManager : found booting_install.vm with loader org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader ------------------------------ Any Idea ? Thanks and best regards.
