George, It doesn't matter that it's running on windows. It's platform independent.
The difference is in those two persistence files I attached to the last email. the 1.8.8 one works, creates the db, and the install.xml the 2.0 one doesn't work. Just hanging there. a mystery On Tue, Jun 12, 2012 at 1:11 PM, George Kirkham <[email protected]>wrote: > Robert,**** > > ** ** > > Apologies but I have no experience with running OpenMeetings on Windows. > (and therefore my netstat will be of little use to you, as will my file > permissions suggestions)**** > > ** ** > > I agree with you that if you can connect to MySQL OpenMeetings database > via the command line, then OpenMeetings should be able to connect using the > same host and user account.**** > > ** ** > > I will have to see if anyone else has any useful suggestions for you.**** > > ** ** > > One last thought, have you rebooted the computer, ensure that red5 was not > running and then started it again. I really don’t think that would work, > but a reboot cures many problems.**** > > ** ** > > ** ** > > Thanks,**** > > ** ** > > George Kirkham**** > > ** ** > > ** ** > > ** ** > > *From:* Robert Chalmers [mailto:[email protected]] > *Sent:* Tuesday, 12 June 2012 1:00 PM > > *To:* [email protected] > *Subject:* Re: folder, probably your database user/pwd/host is wrong!**** > > ** ** > > George,**** > > ** ** > > 1. As I'm on Windows XP, it doesn't worry about accounts really. But I > know it's not that problem anyway.**** > > ** ** > > 2. There is almost nothing at this stage in openmeetings.log 1 line, > stating it's "Starting up context openmeetings"**** > > ** ** > > 3. mysql -h localhost -u admin -pXXXX openmeetings This works fine. > putting me at the mysql> prompt**** > > ** ** > > 4. netstat -anp Returns nothing at all. On windows it only displays one > of four settable protocols. (TCP etc)**** > > ** ** > > ** ** > > In any case - there is obviously something missing. I'm not the only > person who has had problems with this very error message being returned.** > ** > > If I can connect to the db with the command line - then the software > should do it as well....**** > > ** ** > > Robert**** > > ** ** > > ** ** > > ** ** > > On Tue, Jun 12, 2012 at 12:24 PM, George Kirkham <[email protected]> > wrote:**** > > Robert,**** > > **** > > What user account are you running OpenMeetings under, is it the “nobody” > account ? And have you checked all the files to ensure that their owner is > still nobody. Sometimes when I am altering these files, I set the owner to > be root and then things don’t always work correctly. I am guessing that > this is not your issue, though it can be good to check.**** > > **** > > As it says;**** > > If that message stays forever you should check the logs located in**** > > **** > > openmeetings_install_dir/log**** > > **** > > So what would be in your /usr/lib/red5/log/openmeetings.log ? (often > there is nothing useful, and if this is the case, then check the red5.log > file)**** > > **** > > Were you able to test out this step, and can you log into your mysql > database this way ? “Is your mysql account name password correct? E.g. > does this work for you: mysql -h localhost -u openmeetings -pXXXX > openmeetings”**** > > **** > > Or how I would explain it;**** > > mysql -h [localhost or dns name or ip address that mysql is listenting on] > -u [OpenMeetings MySQL account] -p [OpenMeetings database]**** > > You can use either “-pPASSWORD” where PASSWORD is the OpenMeetings MySQL > account password, or just “-p ” where MySQL will prompt you for the > password. And apologies but I guess you already know this stuff, but it is > good to check when thinks do not work.**** > > **** > > If you do the following what do you see?**** > > netstat -anp | grep java**** > > netstat -anp | grep 3306**** > > **** > > I guess the first is just fine as you get the OpenMeetings message about > not being about to connect to MySQL.**** > > **** > > **** > > Thanks,**** > > **** > > George Kirkham**** > > **** > > **** > > **** > > *From:* Robert Chalmers [mailto:[email protected]] > *Sent:* Tuesday, 12 June 2012 11:39 AM**** > > > *To:* [email protected] > *Subject:* Re: folder, probably your database user/pwd/host is wrong!**** > > **** > > 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.**** > > **** > > **** > > **** > > ** ** >
