You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by sysdebian <sy...@cdbarra.com> on 2012/06/11 15:31:00 UTC
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.
Re: folder, probably your database user/pwd/host is wrong!
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
You should have a closer look at the log files.
The access-log does not interested at all (as it will only contain just who
tried to access the application)
The red5/openmeetings/error log are the files to look at. But not only the
last lines. You have to read the whole log, maybe the last 1000 lines.
Sebastian
2012/6/11 sysdebian <sy...@cdbarra.com>
> 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.
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
Robert,
Below is the text from my persistence.xml file, should this help you.
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<!-- persistence.xml schema -->
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" version="2.0">
<persistence-unit name="openmeetings" transaction-type="RESOURCE_LOCAL">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>org.openmeetings.app.persistence.beans.adresses.Adresses</class>
<class>org.openmeetings.app.persistence.beans.adresses.States</class>
<class>org.openmeetings.app.persistence.beans.basic.Configuration</class>
<class>org.openmeetings.app.persistence.beans.basic.ErrorType</class>
<class>org.openmeetings.app.persistence.beans.basic.ErrorValues</class>
<class>org.openmeetings.app.persistence.beans.basic.LdapConfig</class>
<class>org.openmeetings.app.persistence.beans.basic.Naviglobal</class>
<class>org.openmeetings.app.persistence.beans.basic.Navimain</class>
<class>org.openmeetings.app.persistence.beans.basic.OmTimeZone</class>
<class>org.openmeetings.app.persistence.beans.basic.Sessiondata</class>
<class>org.openmeetings.app.persistence.beans.basic.SOAPLogin</class>
<class>org.openmeetings.app.persistence.beans.calendar.Appointment</class>
<class>org.openmeetings.app.persistence.beans.calendar.AppointmentCategory</class>
<class>org.openmeetings.app.persistence.beans.calendar.AppointmentReminderTyps</class>
<class>org.openmeetings.app.persistence.beans.calendar.MeetingMember</class>
<class>org.openmeetings.app.persistence.beans.domain.Organisation</class>
<class>org.openmeetings.app.persistence.beans.domain.Organisation_Users</class>
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecording</class>
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingLog</class>
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaData</class>
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaDelta</class>
<class>org.openmeetings.app.persistence.beans.invitation.Invitations</class>
<class>org.openmeetings.app.persistence.beans.lang.FieldLanguage</class>
<class>org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues</class>
<class>org.openmeetings.app.persistence.beans.lang.Fieldvalues</class>
<class>org.openmeetings.app.persistence.beans.logs.ConferenceLog</class>
<class>org.openmeetings.app.persistence.beans.logs.ConferenceLogType</class>
<class>org.openmeetings.app.persistence.beans.poll.PollType</class>
<class>org.openmeetings.app.persistence.beans.poll.RoomPoll</class>
<class>org.openmeetings.app.persistence.beans.poll.RoomPollAnswers</class>
<class>org.openmeetings.app.persistence.beans.rooms.RoomModerators</class>
<class>org.openmeetings.app.persistence.beans.rooms.Rooms</class>
<class>org.openmeetings.app.persistence.beans.rooms.RoomTypes</class>
<class>org.openmeetings.app.persistence.beans.rooms.Rooms_Organisation</class>
<class>org.openmeetings.app.persistence.beans.sip.OpenXGReturnObject</class>
<class>org.openmeetings.app.persistence.beans.user.PrivateMessages</class>
<class>org.openmeetings.app.persistence.beans.user.PrivateMessageFolder</class>
<class>org.openmeetings.app.persistence.beans.user.Salutations</class>
<class>org.openmeetings.app.persistence.beans.user.UserContacts</class>
<class>org.openmeetings.app.persistence.beans.user.Userdata</class>
<class>org.openmeetings.app.persistence.beans.user.Userlevel</class>
<class>org.openmeetings.app.persistence.beans.user.UserSipData</class>
<class>org.openmeetings.app.persistence.beans.user.Users</class>
<class>org.openmeetings.app.persistence.beans.files.FileExplorerItem</class>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.AsteriskSipUsers</class>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.Extensions</class>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.MeetMe</class>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="openjpa.RuntimeUnenhancedClasses" value="unsupported"/>
<property name="openjpa.ConnectionDriverName" value="org.apache.commons.dbcp.BasicDataSource" />
<property name="openjpa.ConnectionProperties"
value="DriverClassName=com.mysql.jdbc.Driver
, Url=jdbc:mysql://dns-of-msql-listening-server:3306/om-database?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=account-name
, Password=account-password"/>
<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/>
<property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO" />
<property name="openjpa.DataCache" value="true"/>
<!-- QueryCache disabled due to changes outside of JPA doesn't take effect with caching -->
<property name="openjpa.QueryCache" value="false"/>
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100,tableType=myisam"/>
<property name="openjpa.jdbc.QuerySQLCache" value="false"/>
</properties>
</persistence-unit>
</persistence>
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:11 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
George,
attached are two persistence.xml files
I loaded the first one in, the one that I got working from 1.8.8 - and it works.
The second one, mysql-persistence, from version 2.0.0, doesn't work. It also looks to be "scrambled" when opened in xml editor.
I remember I had this problem with 1.8.8 but can't remember how I fixed it.
Naturally I've changed the user/password settings
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
George,
attached are two persistence.xml files
I loaded the first one in, the one that I got working from 1.8.8 - and it
works.
The second one, mysql-persistence, from version 2.0.0, doesn't work. It
also looks to be "scrambled" when opened in xml editor.
I remember I had this problem with 1.8.8 but can't remember how I fixed it.
Naturally I've changed the user/password settings
RE: folder, probably your database user/pwd/host is wrong!
Posted by Stephen Cottham <St...@robertbird.com.au>.
Hi Robert,
OpenMeetings is already using a version control system via SVN, the nightly builds can be checked out here:
http://svn.apache.org/repos/asf/incubator/openmeetings
Install svn and issue:
svn checkout https://svn.apache.org/repos/asf/incubator/openmeetings/trunk/singlewebapp/
(Build instructions are here: http://incubator.apache.org/openmeetings/BuildInstructions.html )
OM 2.X does indeed work with mysql on linux and im currently installing a Windows XP VM to try and reproduce the issue you are having and then try and solve the problem.
Incidentally when you was trying to set this up with mysql what output did you get from the red5-debug.bat debug script?
This script is in the root of the red5 folder and will give you a debug output as the system starts-up, this should pinpoint where you may be having issues.
I’m just getting the Windows XP machine to the latest patch level then I will begin the OM install.
BTW – is there a reason you was installing OM on windows XP? Would this be the OS choice for a production environment?
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 11:35
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi,
I have the latest build of openmeetings installed and working.
apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz <https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz>
it's running here. very slowly.
http://yes.podzone.net:5080/openmeetings/
Well, it starts up anyway.
However - this is as I say, on XP Pro, and uses the default built in database. It simply will not run if I try to use it with mysql.
I would really love to be able to install the Moodle plugin, that also uses what is supposedly openmeetings v2.0.0
But I can't find that anywhere. and it won't run with mysql either probably.
If openmeetings is being rebuilt at the very least on a daily basis - isn't there a good case for using GIT, or at least breaking it into STABLE and DEVELOPMENT releases?
and putting it all in one place !
cheers
On Tue, Jun 12, 2012 at 5:42 PM, Stephen Cottham <St...@robertbird.com.au> wrote:
Hi Robert,
Is it worth you trying the Debian or Ubuntu installs over running this on Windows?
The guides from start to finish can be found here:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Installing OM2.x On Debian64 - Headless.pdf (Debian Squeeze) - Updated 28/5/2012
Installing OM2.x On Ubuntu64 - Headless.pdf (Unbuntu 12.04) - Updated 23/5/2012
There is also a Live CD created by Greenes here: (This can then be installed to HD)
http://nightly.openmeetings.de/openmeetings/builds/vmware/
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso.md5
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04_Information_Informacion.zip
... in this last file are the names of users and passwords for each party, including Moodle.
Moodle has the OpenMeetings plugin installed and working, with a room created in the course called:
Test Course
...which name is:
OpenMeetings Video-Conference Room
To log into Moodle:
Name = admin
Key = 1a2B3c4*
... this info is in the zip above at first.
If you find any problems, please expose it in this list.
This includes the latest OM build and the integration into Moodle pre-built
If you’re not keen on the above I will have a go at the windows install today and then add the guide to the rest of the guides on the Wiki, not many people have built OM on Windows so unfortunately you may not have received the same level of help as the Nix users have to date, that being said I don’t think you should give up on OM it’s a great system and im sure we can make this work in all environments.
I’ll udate here later:
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 05:34
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi George,
I'm giving it away. Anything I have to spend a day on to try and make work just isn't worth it. And I've spent somewhat longer than that on this.
I did have the Moodle plugin for openmeetings version 1.8.8 working kind of. At least it worked with the mysql database - see old posting on the google apps site. It took ages to find the culprit there. a similar deal.
So, now I try to upgrade to openmeetings Version 2.0.0, and have it use the mysql database. Nope - no way.
It installs from scratch fine and uses its internal database. But asking it to use mysql. .... forget it. It just won't do it.
and yes, I know about mysql etc. I've been using this stuff for about 30 years now. Unix in it's many variants, as well as Microsoft.
So, anyway. Thanks for your kind help George. I do appreciate it. I may fiddle with the thing from time to time now, but I doubt I'll ever use it in a commercial environment.
cheers
Robert
On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au> wrote:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Thanks,
George Kirkham
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 <tel:%2B6173%20319%202777> (AUS)
Phone: +44207 592 8000 <tel:%2B44207%20592%208000> (UK)
Fax: +6173 319 2799 <tel:%2B6173%20319%202799>
Mobile: +61400 756 963 <tel:%2B61400%20756%20963> (AUS)
Mobile: +447900 918 616 <tel:%2B447900%20918%20616> (UK)
Web: www.robertbird.com <http://www.robertbird.com/>
<http://www.robertbird.com.au/>
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
www.codetwo.com
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Tuesday, 12 June 2012 2:16 PM
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 (AUS)
Phone: +44207 592 8000 (UK)
Fax: +6173 319 2799
Mobile: +61400 756 963 (AUS)
Mobile: +447900 918 616 (UK)
Web: www.robertbird.com
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
http://www.codetwo.com
RE: folder, probably your database user/pwd/host is wrong!
Posted by Stephen Cottham <St...@robertbird.com.au>.
Robert,
At this stage I am unable to reproduce the problem you are having, this is working fine on my test XP machine that I built this morning from scratch.
Can you post the output of your red5-debug windows as you start your service and we will try and troubleshoot your setup. (you may need to start it using red5-debug.bat > output.log to capture the output in the output.log file as the command prompt is not so great for copying out of.)
Best Regards
From: Stephen Cottham [mailto:Stephen.Cottham@robertbird.com.au]
Sent: 12 June 2012 14:42
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Hi All,
I have just completed the Install of OM 2.X on Windows XP Pro SP3 using mysql as the DB backend.
These are the steps I took.
· Install Windows XP in VM
· Update to SP3
· Update all Security and MS Patches
· Install 7-zip
· Install mysql Server
· Install jdk-6u25-windows-i586.exe
· Install SWFTools 0.9.2
· Install SOX 14.4.0
· Install ffmpeg 08062012
· Install ImageMagick 6.7.7-7-Q8
· Install Apache Ant 1.8.4
· Install SubVersion Edge
· Set ANT_HOME and JAVA_HOME Variables
· Update PATH with dependencies locations
· Reboot
· Test all installs (example java –version, pdf2swf –version etc..)
· Create DB and set permissions :
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
quit
· cd C:\
· mkdir Builds
· cd Builds
· svn checkout https://svn.apache.org/repos/asf/incubator/openmeetings/trunk/singlewebapp/
· cd singlewebapp
· ant -Ddb=mysql – Wait a while for it to compile
· Copy red5 folder from the dist folder to C:\
· Rename persistence.xml to persistence.xml.old
· Rename mysql_persistence.xml to persistence.xml
· Edit persistence.xml and change Username and Password to match Db creation from earlier (openmeetings and password)
· Start program with c:\red5\red5-debug.bat
· Go to http://<windows IP>:5080/openmeetings/install <http://%3cwindows%20IP%3e:5080/openmeetings/install>
Set it up and we are good to go.
I’ll knock this up with screen shots later when I get time but this works with no issues on Windows using mysql.
Best Regards
From: Stephen Cottham
Sent: 12 June 2012 11:47
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Hi Robert,
OpenMeetings is already using a version control system via SVN, the nightly builds can be checked out here:
http://svn.apache.org/repos/asf/incubator/openmeetings
Install svn and issue:
svn checkout https://svn.apache.org/repos/asf/incubator/openmeetings/trunk/singlewebapp/
(Build instructions are here: http://incubator.apache.org/openmeetings/BuildInstructions.html )
OM 2.X does indeed work with mysql on linux and im currently installing a Windows XP VM to try and reproduce the issue you are having and then try and solve the problem.
Incidentally when you was trying to set this up with mysql what output did you get from the red5-debug.bat debug script?
This script is in the root of the red5 folder and will give you a debug output as the system starts-up, this should pinpoint where you may be having issues.
I’m just getting the Windows XP machine to the latest patch level then I will begin the OM install.
BTW – is there a reason you was installing OM on windows XP? Would this be the OS choice for a production environment?
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 11:35
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi,
I have the latest build of openmeetings installed and working.
apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz <https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz>
it's running here. very slowly.
http://yes.podzone.net:5080/openmeetings/
Well, it starts up anyway.
However - this is as I say, on XP Pro, and uses the default built in database. It simply will not run if I try to use it with mysql.
I would really love to be able to install the Moodle plugin, that also uses what is supposedly openmeetings v2.0.0
But I can't find that anywhere. and it won't run with mysql either probably.
If openmeetings is being rebuilt at the very least on a daily basis - isn't there a good case for using GIT, or at least breaking it into STABLE and DEVELOPMENT releases?
and putting it all in one place !
cheers
On Tue, Jun 12, 2012 at 5:42 PM, Stephen Cottham <St...@robertbird.com.au> wrote:
Hi Robert,
Is it worth you trying the Debian or Ubuntu installs over running this on Windows?
The guides from start to finish can be found here:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Installing OM2.x On Debian64 - Headless.pdf (Debian Squeeze) - Updated 28/5/2012
Installing OM2.x On Ubuntu64 - Headless.pdf (Unbuntu 12.04) - Updated 23/5/2012
There is also a Live CD created by Greenes here: (This can then be installed to HD)
http://nightly.openmeetings.de/openmeetings/builds/vmware/
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso.md5
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04_Information_Informacion.zip
... in this last file are the names of users and passwords for each party, including Moodle.
Moodle has the OpenMeetings plugin installed and working, with a room created in the course called:
Test Course
...which name is:
OpenMeetings Video-Conference Room
To log into Moodle:
Name = admin
Key = 1a2B3c4*
... this info is in the zip above at first.
If you find any problems, please expose it in this list.
This includes the latest OM build and the integration into Moodle pre-built
If you’re not keen on the above I will have a go at the windows install today and then add the guide to the rest of the guides on the Wiki, not many people have built OM on Windows so unfortunately you may not have received the same level of help as the Nix users have to date, that being said I don’t think you should give up on OM it’s a great system and im sure we can make this work in all environments.
I’ll udate here later:
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 05:34
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi George,
I'm giving it away. Anything I have to spend a day on to try and make work just isn't worth it. And I've spent somewhat longer than that on this.
I did have the Moodle plugin for openmeetings version 1.8.8 working kind of. At least it worked with the mysql database - see old posting on the google apps site. It took ages to find the culprit there. a similar deal.
So, now I try to upgrade to openmeetings Version 2.0.0, and have it use the mysql database. Nope - no way.
It installs from scratch fine and uses its internal database. But asking it to use mysql. .... forget it. It just won't do it.
and yes, I know about mysql etc. I've been using this stuff for about 30 years now. Unix in it's many variants, as well as Microsoft.
So, anyway. Thanks for your kind help George. I do appreciate it. I may fiddle with the thing from time to time now, but I doubt I'll ever use it in a commercial environment.
cheers
Robert
On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au> wrote:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Thanks,
George Kirkham
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 <tel:%2B6173%20319%202777> (AUS)
Phone: +44207 592 8000 <tel:%2B44207%20592%208000> (UK)
Fax: +6173 319 2799 <tel:%2B6173%20319%202799>
Mobile: +61400 756 963 <tel:%2B61400%20756%20963> (AUS)
Mobile: +447900 918 616 <tel:%2B447900%20918%20616> (UK)
Web: www.robertbird.com <http://www.robertbird.com/>
<http://www.robertbird.com.au/>
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
www.codetwo.com
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Tuesday, 12 June 2012 2:16 PM
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 (AUS)
Phone: +44207 592 8000 (UK)
Fax: +6173 319 2799
Mobile: +61400 756 963 (AUS)
Mobile: +447900 918 616 (UK)
Web: www.robertbird.com
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
http://www.codetwo.com
RE: folder, probably your database user/pwd/host is wrong!
Posted by Stephen Cottham <St...@robertbird.com.au>.
Hi All,
I have just completed the Install of OM 2.X on Windows XP Pro SP3 using mysql as the DB backend.
These are the steps I took.
· Install Windows XP in VM
· Update to SP3
· Update all Security and MS Patches
· Install 7-zip
· Install mysql Server
· Install jdk-6u25-windows-i586.exe
· Install SWFTools 0.9.2
· Install SOX 14.4.0
· Install ffmpeg 08062012
· Install ImageMagick 6.7.7-7-Q8
· Install Apache Ant 1.8.4
· Install SubVersion Edge
· Set ANT_HOME and JAVA_HOME Variables
· Update PATH with dependencies locations
· Reboot
· Test all installs (example java –version, pdf2swf –version etc..)
· Create DB and set permissions :
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
quit
· cd C:\
· mkdir Builds
· cd Builds
· svn checkout https://svn.apache.org/repos/asf/incubator/openmeetings/trunk/singlewebapp/
· cd singlewebapp
· ant -Ddb=mysql – Wait a while for it to compile
· Copy red5 folder from the dist folder to C:\
· Rename persistence.xml to persistence.xml.old
· Rename mysql_persistence.xml to persistence.xml
· Edit persistence.xml and change Username and Password to match Db creation from earlier (openmeetings and password)
· Start program with c:\red5\red5-debug.bat
· Go to http://<windows IP>:5080/openmeetings/install <http://%3cwindows%20IP%3e:5080/openmeetings/install>
Set it up and we are good to go.
I’ll knock this up with screen shots later when I get time but this works with no issues on Windows using mysql.
Best Regards
From: Stephen Cottham
Sent: 12 June 2012 11:47
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Hi Robert,
OpenMeetings is already using a version control system via SVN, the nightly builds can be checked out here:
http://svn.apache.org/repos/asf/incubator/openmeetings
Install svn and issue:
svn checkout https://svn.apache.org/repos/asf/incubator/openmeetings/trunk/singlewebapp/
(Build instructions are here: http://incubator.apache.org/openmeetings/BuildInstructions.html )
OM 2.X does indeed work with mysql on linux and im currently installing a Windows XP VM to try and reproduce the issue you are having and then try and solve the problem.
Incidentally when you was trying to set this up with mysql what output did you get from the red5-debug.bat debug script?
This script is in the root of the red5 folder and will give you a debug output as the system starts-up, this should pinpoint where you may be having issues.
I’m just getting the Windows XP machine to the latest patch level then I will begin the OM install.
BTW – is there a reason you was installing OM on windows XP? Would this be the OS choice for a production environment?
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 11:35
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi,
I have the latest build of openmeetings installed and working.
apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz <https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz>
it's running here. very slowly.
http://yes.podzone.net:5080/openmeetings/
Well, it starts up anyway.
However - this is as I say, on XP Pro, and uses the default built in database. It simply will not run if I try to use it with mysql.
I would really love to be able to install the Moodle plugin, that also uses what is supposedly openmeetings v2.0.0
But I can't find that anywhere. and it won't run with mysql either probably.
If openmeetings is being rebuilt at the very least on a daily basis - isn't there a good case for using GIT, or at least breaking it into STABLE and DEVELOPMENT releases?
and putting it all in one place !
cheers
On Tue, Jun 12, 2012 at 5:42 PM, Stephen Cottham <St...@robertbird.com.au> wrote:
Hi Robert,
Is it worth you trying the Debian or Ubuntu installs over running this on Windows?
The guides from start to finish can be found here:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Installing OM2.x On Debian64 - Headless.pdf (Debian Squeeze) - Updated 28/5/2012
Installing OM2.x On Ubuntu64 - Headless.pdf (Unbuntu 12.04) - Updated 23/5/2012
There is also a Live CD created by Greenes here: (This can then be installed to HD)
http://nightly.openmeetings.de/openmeetings/builds/vmware/
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso.md5
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04_Information_Informacion.zip
... in this last file are the names of users and passwords for each party, including Moodle.
Moodle has the OpenMeetings plugin installed and working, with a room created in the course called:
Test Course
...which name is:
OpenMeetings Video-Conference Room
To log into Moodle:
Name = admin
Key = 1a2B3c4*
... this info is in the zip above at first.
If you find any problems, please expose it in this list.
This includes the latest OM build and the integration into Moodle pre-built
If you’re not keen on the above I will have a go at the windows install today and then add the guide to the rest of the guides on the Wiki, not many people have built OM on Windows so unfortunately you may not have received the same level of help as the Nix users have to date, that being said I don’t think you should give up on OM it’s a great system and im sure we can make this work in all environments.
I’ll udate here later:
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 05:34
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi George,
I'm giving it away. Anything I have to spend a day on to try and make work just isn't worth it. And I've spent somewhat longer than that on this.
I did have the Moodle plugin for openmeetings version 1.8.8 working kind of. At least it worked with the mysql database - see old posting on the google apps site. It took ages to find the culprit there. a similar deal.
So, now I try to upgrade to openmeetings Version 2.0.0, and have it use the mysql database. Nope - no way.
It installs from scratch fine and uses its internal database. But asking it to use mysql. .... forget it. It just won't do it.
and yes, I know about mysql etc. I've been using this stuff for about 30 years now. Unix in it's many variants, as well as Microsoft.
So, anyway. Thanks for your kind help George. I do appreciate it. I may fiddle with the thing from time to time now, but I doubt I'll ever use it in a commercial environment.
cheers
Robert
On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au> wrote:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Thanks,
George Kirkham
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 <tel:%2B6173%20319%202777> (AUS)
Phone: +44207 592 8000 <tel:%2B44207%20592%208000> (UK)
Fax: +6173 319 2799 <tel:%2B6173%20319%202799>
Mobile: +61400 756 963 <tel:%2B61400%20756%20963> (AUS)
Mobile: +447900 918 616 <tel:%2B447900%20918%20616> (UK)
Web: www.robertbird.com <http://www.robertbird.com/>
<http://www.robertbird.com.au/>
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
www.codetwo.com
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Tuesday, 12 June 2012 2:16 PM
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 (AUS)
Phone: +44207 592 8000 (UK)
Fax: +6173 319 2799
Mobile: +61400 756 963 (AUS)
Mobile: +447900 918 616 (UK)
Web: www.robertbird.com
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
http://www.codetwo.com
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
Hi,
I have the latest build of openmeetings installed and working.
apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz<https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1349062-11-06-2012_2313.tar.gz>
it's running here. very slowly.
http://yes.podzone.net:5080/openmeetings/
Well, it starts up anyway.
However - this is as I say, on XP Pro, and uses the default built in
database. It simply will not run if I try to use it with mysql.
I would really love to be able to install the Moodle plugin, that also uses
what is supposedly openmeetings v2.0.0
But I can't find that anywhere. and it won't run with mysql either probably.
If openmeetings is being rebuilt at the very least on a daily basis - isn't
there a good case for using GIT, or at least breaking it into STABLE and
DEVELOPMENT releases?
and putting it all in one place !
cheers
On Tue, Jun 12, 2012 at 5:42 PM, Stephen Cottham <
Stephen.Cottham@robertbird.com.au> wrote:
> Hi Robert,****
>
> ** **
>
> Is it worth you trying the Debian or Ubuntu installs over running this on
> Windows?****
>
> ** **
>
> The guides from start to finish can be found here:****
>
> ** **
>
>
> https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
> ****
>
> ** **
>
> Installing OM2.x On Debian64 - Headless.pdf (Debian Squeeze) - Updated
> 28/5/2012****
>
> ** **
>
> Installing OM2.x On Ubuntu64 - Headless.pdf (Unbuntu 12.04) - Updated
> 23/5/2012****
>
> ** **
>
> ** **
>
> There is also a Live CD created by Greenes here: (This can then be
> installed to HD)****
>
> ** **
>
> http://nightly.openmeetings.de/openmeetings/builds/vmware/****
>
> ** **
>
> OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso****
>
> ** **
>
> OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso.md5****
>
> ** **
>
> OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04_Information_Informacion.zip****
>
> ** **
>
> ... in this last file are the names of users and passwords for each party,
> including Moodle.****
>
> ** **
>
> Moodle has the OpenMeetings plugin installed and working, with a room
> created in the course called:****
>
> ** **
>
> Test Course****
>
> ...which name is:****
>
> OpenMeetings Video-Conference Room****
>
> ** **
>
> To log into Moodle:****
>
> ** **
>
> Name = admin****
>
> Key = 1a2B3c4*****
>
> ** **
>
> ... this info is in the zip above at first.****
>
> ** **
>
> If you find any problems, please expose it in this list.****
>
> ** **
>
> This includes the latest OM build and the integration into Moodle pre-built
> ****
>
> ** **
>
> If you’re not keen on the above I will have a go at the windows install
> today and then add the guide to the rest of the guides on the Wiki, not
> many people have built OM on Windows so unfortunately you may not have
> received the same level of help as the Nix users have to date, that being
> said I don’t think you should give up on OM it’s a great system and im sure
> we can make this work in all environments.****
>
> ** **
>
> I’ll udate here later:****
>
> ** **
>
> Best Regards****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
> *Sent:* 12 June 2012 05:34
>
> *To:* openmeetings-user@incubator.apache.org
> *Subject:* Re: folder, probably your database user/pwd/host is wrong!****
>
> ** **
>
> Hi George,****
>
> I'm giving it away. Anything I have to spend a day on to try and make work
> just isn't worth it. And I've spent somewhat longer than that on this.****
>
> ** **
>
> I did have the Moodle plugin for openmeetings version 1.8.8 working kind
> of. At least it worked with the mysql database - see old posting on the
> google apps site. It took ages to find the culprit there. a similar deal.*
> ***
>
> ** **
>
> So, now I try to upgrade to openmeetings Version 2.0.0, and have it use
> the mysql database. Nope - no way.****
>
> It installs from scratch fine and uses its internal database. But asking
> it to use mysql. .... forget it. It just won't do it.****
>
> ** **
>
> and yes, I know about mysql etc. I've been using this stuff for about 30
> years now. Unix in it's many variants, as well as Microsoft.****
>
> ** **
>
> ** **
>
> So, anyway. Thanks for your kind help George. I do appreciate it. I may
> fiddle with the thing from time to time now, but I doubt I'll ever use it
> in a commercial environment.****
>
> cheers****
>
> Robert****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au>
> wrote:****
>
>
> https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
> ****
>
> ****
>
> ****
>
> Thanks,****
>
> ****
>
> George Kirkham****
>
> ****
>
> *Stephen Cottham**
> *Group IT Manager (Associate)
>
> Robert Bird Group
> Level 5, 333 Ann St
> Brisbane, Queensland, 4000, Australia****
>
> *Phone: +6173 319 2777 (AUS)*
>
> *Phone: +44207 592 8000 (UK)*****
>
> *Fax: +6173 319 2799*
>
> ******
>
> *Mobile: +61400 756 963 (AUS)*
>
> *Mobile: +447900 918 616 (UK)*
>
> *Web: **www.robertbird.com* <http://www.robertbird.com/>****
>
> ********************************************************************<http://www.robertbird.com.au/><http://www.robertbird.com.au/>
>
> This email and any attachments are confidential and may contain legally
> privileged information or copyright material. Unless expressly stated,
> confidentiality and/or legal privilege is not intended to be waived by the
> sending of this email. The contents of this email, including any
> attachments, are intended solely for the use of the individual or entity to
> whom they are addressed. If you are not an intended recipient, please
> contact us immediately by return email and then delete both messages. You
> may not otherwise read, forward, copy, use or disclose this email or any
> attachments. Any views expressed in this email are those of the individual
> sender except where the sender expressly, and with authority, states
> otherwise. It is your responsibility to check any attachments for viruses
> or defects before opening or sending them on. None of the sender or its
> related entities accepts any liability for any consequential damage
> resulting from this email containing computer viruses.
>
>
> Disclaimer added by *CodeTwo Exchange Rules*
> www.codetwo.com
>
> *From:* George Kirkham [mailto:gkirkham@co2crc.com.au] ****
>
> *Sent:* Tuesday, 12 June 2012 2:16 PM
> *To:* openmeetings-user@incubator.apache.org****
>
> *Subject:* RE: folder, probably your database user/pwd/host is wrong!****
>
> ****
>
> Robert,****
>
> ****
>
> When we write we often abbreviate, and when we read we often read meaning
> into what others have written. What I am trying to say is I am not sure
> what you meant in your email below.****
>
> ****
>
> When you said “1.8.8” do you have an older copy of a version 1.8 of
> OpenMeetings? (I don’t have this version).****
>
> ****
>
> When you said “2.0” do you mean the downloaded source or build from
> https://builds.apache.org/job/openmeetings/ ?****
>
> ****
>
> You also said “1.8.8 one works, creates the db, and the install.xml” but
> what do you mean by;****
>
> ****
>
> 1) “creates the db” ? In OpenMeetings 2.0 it is we who create the
> database, manually as per the instructions (I was using Stephen’s updated
> instructions) ****
>
> *CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';*****
>
> *GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost'
> IDENTIFIED BY 'password' WITH GRANT OPTION;*****
>
>
> https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
> ****
>
> 2) “and the install.xml” ? Does version 1.8 create such a file? The
> only file I can locate in version 2.0 is
> red5/webapps/installer/installer.swf. I am not sure how the install process
> works in OpenMeetings so I cannot comment about this.****
>
> ****
>
> I am curious, what instructions are you following for installing
> OpenMeetings in Windows ? Maybe I could give it a go myself.****
>
> ****
>
> Thanks,****
>
> ****
>
> George Kirkham****
>
> ****
>
> ****
>
> ****
>
> *From:* Robert Chalmers [mailto:robert.a.chalmers@gmail.com<ro...@gmail.com>]
>
> *Sent:* Tuesday, 12 June 2012 1:35 PM
> *To:* openmeetings-user@incubator.apache.org
> *Subject:* Re: folder, probably your database user/pwd/host is wrong!****
>
> ****
>
> 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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 1:00 PM****
>
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 11:39 AM****
>
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 9:59 AM
> *To:* openmeetings-user@incubator.apache.org
> *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 <
> robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>
> 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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ** **
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by Stephen Cottham <St...@robertbird.com.au>.
Hi Robert,
Is it worth you trying the Debian or Ubuntu installs over running this on Windows?
The guides from start to finish can be found here:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Installing OM2.x On Debian64 - Headless.pdf (Debian Squeeze) - Updated 28/5/2012
Installing OM2.x On Ubuntu64 - Headless.pdf (Unbuntu 12.04) - Updated 23/5/2012
There is also a Live CD created by Greenes here: (This can then be installed to HD)
http://nightly.openmeetings.de/openmeetings/builds/vmware/
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04.iso.md5
OpenMeetings_2.0_Moodle_2.2.3_Ubuntu_12.04_Information_Informacion.zip
... in this last file are the names of users and passwords for each party, including Moodle.
Moodle has the OpenMeetings plugin installed and working, with a room created in the course called:
Test Course
...which name is:
OpenMeetings Video-Conference Room
To log into Moodle:
Name = admin
Key = 1a2B3c4*
... this info is in the zip above at first.
If you find any problems, please expose it in this list.
This includes the latest OM build and the integration into Moodle pre-built
If you’re not keen on the above I will have a go at the windows install today and then add the guide to the rest of the guides on the Wiki, not many people have built OM on Windows so unfortunately you may not have received the same level of help as the Nix users have to date, that being said I don’t think you should give up on OM it’s a great system and im sure we can make this work in all environments.
I’ll udate here later:
Best Regards
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: 12 June 2012 05:34
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
Hi George,
I'm giving it away. Anything I have to spend a day on to try and make work just isn't worth it. And I've spent somewhat longer than that on this.
I did have the Moodle plugin for openmeetings version 1.8.8 working kind of. At least it worked with the mysql database - see old posting on the google apps site. It took ages to find the culprit there. a similar deal.
So, now I try to upgrade to openmeetings Version 2.0.0, and have it use the mysql database. Nope - no way.
It installs from scratch fine and uses its internal database. But asking it to use mysql. .... forget it. It just won't do it.
and yes, I know about mysql etc. I've been using this stuff for about 30 years now. Unix in it's many variants, as well as Microsoft.
So, anyway. Thanks for your kind help George. I do appreciate it. I may fiddle with the thing from time to time now, but I doubt I'll ever use it in a commercial environment.
cheers
Robert
On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au> wrote:
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Thanks,
George Kirkham
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Tuesday, 12 June 2012 2:16 PM
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Stephen Cottham
Group IT Manager (Associate)
Robert Bird Group
Level 5, 333 Ann St
Brisbane, Queensland, 4000, Australia
Phone: +6173 319 2777 (AUS)
Phone: +44207 592 8000 (UK)
Fax: +6173 319 2799
Mobile: +61400 756 963 (AUS)
Mobile: +447900 918 616 (UK)
Web: www.robertbird.com
This email and any attachments are confidential and may contain legally privileged information or copyright material. Unless expressly stated, confidentiality and/or legal privilege is not intended to be waived by the sending of this email. The contents of this email, including any attachments, are intended solely for the use of the individual or entity to whom they are addressed. If you are not an intended recipient, please contact us immediately by return email and then delete both messages. You may not otherwise read, forward, copy, use or disclose this email or any attachments. Any views expressed in this email are those of the individual sender except where the sender expressly, and with authority, states otherwise. It is your responsibility to check any attachments for viruses or defects before opening or sending them on. None of the sender or its related entities accepts any liability for any consequential damage resulting from this email containing computer viruses.
Disclaimer added by CodeTwo Exchange Rules
http://www.codetwo.com
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
Hi George,
I'm giving it away. Anything I have to spend a day on to try and make work
just isn't worth it. And I've spent somewhat longer than that on this.
I did have the Moodle plugin for openmeetings version 1.8.8 working kind
of. At least it worked with the mysql database - see old posting on the
google apps site. It took ages to find the culprit there. a similar deal.
So, now I try to upgrade to openmeetings Version 2.0.0, and have it use the
mysql database. Nope - no way.
It installs from scratch fine and uses its internal database. But asking it
to use mysql. .... forget it. It just won't do it.
and yes, I know about mysql etc. I've been using this stuff for about 30
years now. Unix in it's many variants, as well as Microsoft.
So, anyway. Thanks for your kind help George. I do appreciate it. I may
fiddle with the thing from time to time now, but I doubt I'll ever use it
in a commercial environment.
cheers
Robert
On Tue, Jun 12, 2012 at 2:19 PM, George Kirkham <gk...@co2crc.com.au>wrote:
>
> https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
> ****
>
> ** **
>
> ** **
>
> Thanks,****
>
> ** **
>
> George Kirkham****
>
> ** **
>
> *From:* George Kirkham [mailto:gkirkham@co2crc.com.au]
> *Sent:* Tuesday, 12 June 2012 2:16 PM
> *To:* openmeetings-user@incubator.apache.org
> *Subject:* RE: folder, probably your database user/pwd/host is wrong!****
>
> ** **
>
> Robert,****
>
> ** **
>
> When we write we often abbreviate, and when we read we often read meaning
> into what others have written. What I am trying to say is I am not sure
> what you meant in your email below.****
>
> ** **
>
> When you said “1.8.8” do you have an older copy of a version 1.8 of
> OpenMeetings? (I don’t have this version).****
>
> ** **
>
> When you said “2.0” do you mean the downloaded source or build from
> https://builds.apache.org/job/openmeetings/ ?****
>
> ** **
>
> You also said “1.8.8 one works, creates the db, and the install.xml” but
> what do you mean by;****
>
> ** **
>
> **1) **“creates the db” ? In OpenMeetings 2.0 it is we who create
> the database, manually as per the instructions (I was using Stephen’s
> updated instructions) ****
>
> *CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';*
>
> *GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost'
> IDENTIFIED BY 'password' WITH GRANT OPTION;*
>
>
> https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
> ****
>
> **2) **“and the install.xml” ? Does version 1.8 create such a file?
> The only file I can locate in version 2.0 is
> red5/webapps/installer/installer.swf. I am not sure how the install process
> works in OpenMeetings so I cannot comment about this.****
>
> ** **
>
> I am curious, what instructions are you following for installing
> OpenMeetings in Windows ? Maybe I could give it a go myself.****
>
> ** **
>
> Thanks,****
>
> ** **
>
> George Kirkham****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Robert Chalmers [mailto:robert.a.chalmers@gmail.com<ro...@gmail.com>]
>
> *Sent:* Tuesday, 12 June 2012 1:35 PM
> *To:* openmeetings-user@incubator.apache.org
> *Subject:* Re: folder, probably your database user/pwd/host is wrong!****
>
> ** **
>
> 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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 1:00 PM****
>
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 11:39 AM****
>
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 9:59 AM
> *To:* openmeetings-user@incubator.apache.org
> *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 <
> robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>
> 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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ** **
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+related+to+OpenMeetings
Thanks,
George Kirkham
From: George Kirkham [mailto:gkirkham@co2crc.com.au]
Sent: Tuesday, 12 June 2012 2:16 PM
To: openmeetings-user@incubator.apache.org
Subject: RE: folder, probably your database user/pwd/host is wrong!
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
Robert,
When we write we often abbreviate, and when we read we often read meaning into what others have written. What I am trying to say is I am not sure what you meant in your email below.
When you said “1.8.8” do you have an older copy of a version 1.8 of OpenMeetings? (I don’t have this version).
When you said “2.0” do you mean the downloaded source or build from https://builds.apache.org/job/openmeetings/ ?
You also said “1.8.8 one works, creates the db, and the install.xml” but what do you mean by;
1) “creates the db” ? In OpenMeetings 2.0 it is we who create the database, manually as per the instructions (I was using Stephen’s updated instructions)
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Debian64+-+Headless.pdf
2) “and the install.xml” ? Does version 1.8 create such a file? The only file I can locate in version 2.0 is red5/webapps/installer/installer.swf. I am not sure how the install process works in OpenMeetings so I cannot comment about this.
I am curious, what instructions are you following for installing OpenMeetings in Windows ? Maybe I could give it a go myself.
Thanks,
George Kirkham
From: Robert Chalmers [mailto:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:35 PM
To: openmeetings-user@incubator.apache.org
Subject: Re: folder, probably your database user/pwd/host is wrong!
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
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 <gk...@co2crc.com.au>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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 1:00 PM
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 11:39 AM****
>
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 9:59 AM
> *To:* openmeetings-user@incubator.apache.org
> *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 <
> robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>
> 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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
> ****
>
> ****
>
> ****
>
> ** **
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 1:00 PM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
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 <gk...@co2crc.com.au>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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 11:39 AM
>
> *To:* openmeetings-user@incubator.apache.org
> *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 <gk...@co2crc.com.au>
> 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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 9:59 AM
> *To:* openmeetings-user@incubator.apache.org
> *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 <
> robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>
> 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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
> ****
>
> ****
>
> ** **
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 11:39 AM
To: openmeetings-user@incubator.apache.org
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 <gk...@co2crc.com.au> 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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
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 <gk...@co2crc.com.au>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:robert.a.chalmers@gmail.com]
> *Sent:* Tuesday, 12 June 2012 9:59 AM
> *To:* openmeetings-user@incubator.apache.org
> *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 <
> robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>
> 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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
> ** **
>
> ** **
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
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:robert.a.chalmers@gmail.com]
Sent: Tuesday, 12 June 2012 9:59 AM
To: openmeetings-user@incubator.apache.org
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 <ro...@gmail.com> 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 <gk...@co2crc.com.au> 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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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.
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
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 <
robert.a.chalmers@gmail.com> 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 <gk...@co2crc.com.au>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:sysdebian@cdbarra.com]
>> *Sent:* Monday, 11 June 2012 11:31 PM
>> *To:* openmeetings-user@incubator.apache.org
>> *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.****
>>
>
>
Re: folder, probably your database user/pwd/host is wrong!
Posted by Robert Chalmers <ro...@gmail.com>.
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 <gk...@co2crc.com.au>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:sysdebian@cdbarra.com]
> *Sent:* Monday, 11 June 2012 11:31 PM
> *To:* openmeetings-user@incubator.apache.org
> *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.****
>
RE: folder, probably your database user/pwd/host is wrong!
Posted by George Kirkham <gk...@co2crc.com.au>.
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:sysdebian@cdbarra.com]
Sent: Monday, 11 June 2012 11:31 PM
To: openmeetings-user@incubator.apache.org
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&useU
nicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-
8&connectionCollation=utf8_general_ci&cachePrepStmts=true&ca
cheCallableStatements=true&cacheServerConfiguration=true&useLoca
lSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolati
on=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&pr
epStmtCacheSqlLimit=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-20
12_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.