George, thanks for the help. Ok. I've dropped the original openmeetings mysql database I had made I recreated the openmeetings database with all privileges, and user admin with password:xxxxxx
all paths I have are the same as yours. I removed the original 'install.xml' (renamed it) I modified the mysql-persistence.xml, then renamed it persistence.xml, using the right user/password combo that I set up for the database. I started the Red5.bat typed in http://yes.podzone.net:5080/openmeetings/install and it just hangs there. --------------------------------------------------------- *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 installation works fine if I just leave it to use the built in db. It just will not use mysql I did have 1.8.8 installed - and more or less working. It fell over the rtsmp what ever protocol. another story. I put that mysqlxxxx.jar into the lib directory. No change. On Tue, Jun 12, 2012 at 10:50 AM, George Kirkham <[email protected]>wrote: > 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.**** > > ** ** > > ** ** >
