You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Susheel Jalali <Su...@CoscendCommunications.com> on 2015/02/16 09:47:57 UTC
OpenMeetings-3.0.4RC Installation Issues
Dear OpenMeetings Users,
After these steps given below, when we perform the OpenMeetings install
configuration, we are facing database connection error reproduced
further below. Such error was not encounered in previous version of OM/
MySQL/Centos.
1. We have installed the OpenMEetings-3.0.4RC software in a Centos-7
server, along with MariaDB-10.0.16 which is stated as drop-in
replacement for MySQL in Centos-7.
2. We have copied MySQL Java Connector in the right place. As far as
possible, we have retained the usage and configuration similar to our
previous successful install /usage of OM-3.0.3 with MySQL-5.1.73 9
(Centos-6.5 on a different VM), except now we have newer versions of the
libraries where available.
3. Checked that MariaDB server is running and the sock file
(/run/mysqld/mysqld.sock) exists.
4. The same user is able to login and USE DATABASE for the right
database used in OM. Grant Privileges followed by FLUSH PRIVILEGES and
COMMIT was also performed.
5. One difference we notice from our previous setup (OM-3.0.3,
MySQL-5.1.73 on Centos-6.5 on a different VM) is that when the concerned
USER logs into DBMS command line client, the DATABASE used showing in
the prompt appears as "none", instead of the one USE'd last.
6. Perform the OpenMeetings install configuration via instructed
localhost URL, and enter all the configuration parameters including
library paths, SMTP details and so on.
*Question*: Should we add any line or parameter/value to "my.cnf" or is
there any other configuration required e.g. in how MariaDB-10.x should
be used with OpenMeetings-3.0.4. Or anything else we might be missing.
Should the port number used for MariaDB be different?
Here are important lines from the red5.log (same also appear in
openmeetings.log):
org.apache.openjpa.persistence.PersistenceException: Cannot create
PoolableConnectionFactory (Could not create connection to database
server. Attempted reconnect 3 times. Giving up.)
at
org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431)
~[spring-orm-jar-4.0.8.RELEASE.jar:4.0.8.RELEASE]
...
Caused by: org.apache.openjpa.persistence.PersistenceException:
Cannot create PoolableConnectionFactory (Could not create connection
to database server. Attempted reconnect 3 times. Giving up.)
at
org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:107)
~[openjpa-bundle-2.3.0.jar:2.3.0]
...
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Could not create connection to database
server. Attempted reconnect 3 times. Giving up.)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
~[commons-dbcp-jar-1.4.jar:1.4]
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure
The last packet sent successfully to the server was 0 milliseconds
ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor22.newInstance(Unknown
Source) ~[na:na]
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_31]
Here are last few lines from the access log, with IP Addresses anonymized:
w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "POST
/openmeetings/install?2-3.IFormSubmitListener-wizard-form HTTP/1.1"
302 -
w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "GET
/openmeetings/install?3 HTTP/1.1" 200 12447
w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "GET
/openmeetings/install?3-4.IBehaviorListener.1-&_=1424067198062&3=
HTTP/1.1" 200 80
w.x.y.z - - [16/Feb/2015:00:14:13 -0600] "POST
/openmeetings/install?3-4.IFormSubmitListener-wizard-form HTTP/1.1"
302 -
w.x.y.z - - [16/Feb/2015:00:14:14 -0600] "GET
/openmeetings/install?4 HTTP/1.1" 200 10057
w.x.y.z - - [16/Feb/2015:00:14:14 -0600] "GET
/openmeetings/install?4-5.IBehaviorListener.1-&_=1424067251581&4=
HTTP/1.1" 200 80
w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "POST
/openmeetings/install?4-5.IFormSubmitListener-wizard-form HTTP/1.1"
302 -
w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET
/openmeetings/install?5 HTTP/1.1" 200 9483
w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET
/openmeetings/wicket/resource/com.googlecode.wicket.jquery.ui.resource.JQueryUIResourceReference/jquery-ui.min-ver-870B75C273A97501E7D1FB27776BAFD0.js
HTTP/1.1" 200 239564
w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.1-&_=1424067255898&5=
HTTP/1.1" 200 80
w.x.y.z - - [16/Feb/2015:00:14:19 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255899
HTTP/1.1" 200 157
w.x.y.z - - [16/Feb/2015:00:14:20 -0600] "POST
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-buttons-finish
HTTP/1.1" 200 2310
w.x.y.z - - [16/Feb/2015:00:14:21 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255900
HTTP/1.1" 200 613
w.x.y.z - - [16/Feb/2015:00:14:21 -0600] "POST
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container-progress
HTTP/1.1" 200 80
w.x.y.z - - [16/Feb/2015:00:14:22 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255901
HTTP/1.1" 200 613
w.x.y.z - - [16/Feb/2015:00:14:23 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255902
HTTP/1.1" 200 613
w.x.y.z - - [16/Feb/2015:00:14:24 -0600] "GET
/openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255903
HTTP/1.1" 200 9244
--
Regards,
Susheel Jalali
Customer Operations Leader,
Coscend Communications Solutions
Elite Premio Complex Suite 200 Survey No 7 & 8 Balewadi Pune 411045
Maharashtra India
Cell +91-9011000233
_Susheel.Jalali@CoscendCommunications.com_
Web site:www.CoscendCommunications.com
<http://www.coscendcommunications.com/>
------------------------------------------------------------------
*Coscend’s**Software Service Factory*
"*Coscend Communications* is ... *pioneering a new approach*to ...
software applications development, and systems integration."
*Light Reading Network, *December, 2007
"*Coscend*is at the*vanguard of a new evolution*in telco OSS/BSS systems
integration."
*Caroline Chappell*
A leading authority in the communications services software industry
"There are *innovative*…*tools*from ... *Coscend *bubbling up, which
will help accelerate the data consolidation process and reduce its cost."
*Dennis Mendyk, */Editor,/Building a *Telco Service Factory*
------------------------------------------------------------------
CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
Messages from Coscend Communications Solutions' posted at:
http://www.CoscendCommunications.com/Terms_and_Conditions.html
<http://www.coscendcommunications.com/Terms_and_Conditions.html>
Re: OpenMeetings-3.0.4RC Installation Issues
Posted by Maxim Solodovnik <so...@gmail.com>.
can you connect using command line client?
please NOTE connection is most probably made using TCP/IP not sock file, so
you need to test this method
On Mon, Feb 16, 2015 at 2:47 PM, Susheel Jalali <
Susheel.Jalali@coscendcommunications.com> wrote:
> Dear OpenMeetings Users,
>
> After these steps given below, when we perform the OpenMeetings install
> configuration, we are facing database connection error reproduced further
> below. Such error was not encounered in previous version of OM/
> MySQL/Centos.
>
> 1. We have installed the OpenMEetings-3.0.4RC software in a Centos-7
> server, along with MariaDB-10.0.16 which is stated as drop-in replacement
> for MySQL in Centos-7.
>
> 2. We have copied MySQL Java Connector in the right place. As far as
> possible, we have retained the usage and configuration similar to our
> previous successful install /usage of OM-3.0.3 with MySQL-5.1.73 9
> (Centos-6.5 on a different VM), except now we have newer versions of the
> libraries where available.
>
> 3. Checked that MariaDB server is running and the sock file
> (/run/mysqld/mysqld.sock) exists.
>
> 4. The same user is able to login and USE DATABASE for the right database
> used in OM. Grant Privileges followed by FLUSH PRIVILEGES and COMMIT was
> also performed.
>
> 5. One difference we notice from our previous setup (OM-3.0.3,
> MySQL-5.1.73 on Centos-6.5 on a different VM) is that when the concerned
> USER logs into DBMS command line client, the DATABASE used showing in the
> prompt appears as "none", instead of the one USE'd last.
>
> 6. Perform the OpenMeetings install configuration via instructed
> localhost URL, and enter all the configuration parameters including library
> paths, SMTP details and so on.
>
> *Question*: Should we add any line or parameter/value to "my.cnf" or is
> there any other configuration required e.g. in how MariaDB-10.x should be
> used with OpenMeetings-3.0.4. Or anything else we might be missing. Should
> the port number used for MariaDB be different?
>
>
> Here are important lines from the red5.log (same also appear in
> openmeetings.log):
>
> org.apache.openjpa.persistence.PersistenceException: Cannot create
> PoolableConnectionFactory (Could not create connection to database server.
> Attempted reconnect 3 times. Giving up.)
> at
> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431)
> ~[spring-orm-jar-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> ...
> Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot
> create PoolableConnectionFactory (Could not create connection to database
> server. Attempted reconnect 3 times. Giving up.)
> at
> org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:107)
> ~[openjpa-bundle-2.3.0.jar:2.3.0]
>
> ...
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Could not create connection to database server.
> Attempted reconnect 3 times. Giving up.)
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
> ~[commons-dbcp-jar-1.4.jar:1.4]
>
> ...
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> The last packet sent successfully to the server was 0 milliseconds ago.
> The driver has not received any packets from the server.
> at sun.reflect.GeneratedConstructorAccessor22.newInstance(Unknown
> Source) ~[na:na]
>
> Caused by: java.net.ConnectException: Connection refused
> at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_31]
>
>
> Here are last few lines from the access log, with IP Addresses anonymized:
>
> w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "POST
> /openmeetings/install?2-3.IFormSubmitListener-wizard-form HTTP/1.1" 302 -
> w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "GET /openmeetings/install?3
> HTTP/1.1" 200 12447
> w.x.y.z - - [16/Feb/2015:00:13:20 -0600] "GET
> /openmeetings/install?3-4.IBehaviorListener.1-&_=1424067198062&3= HTTP/1.1"
> 200 80
> w.x.y.z - - [16/Feb/2015:00:14:13 -0600] "POST
> /openmeetings/install?3-4.IFormSubmitListener-wizard-form HTTP/1.1" 302 -
> w.x.y.z - - [16/Feb/2015:00:14:14 -0600] "GET /openmeetings/install?4
> HTTP/1.1" 200 10057
> w.x.y.z - - [16/Feb/2015:00:14:14 -0600] "GET
> /openmeetings/install?4-5.IBehaviorListener.1-&_=1424067251581&4= HTTP/1.1"
> 200 80
> w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "POST
> /openmeetings/install?4-5.IFormSubmitListener-wizard-form HTTP/1.1" 302 -
> w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET /openmeetings/install?5
> HTTP/1.1" 200 9483
> w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET
> /openmeetings/wicket/resource/com.googlecode.wicket.jquery.ui.resource.JQueryUIResourceReference/jquery-ui.min-ver-870B75C273A97501E7D1FB27776BAFD0.js
> HTTP/1.1" 200 239564
> w.x.y.z - - [16/Feb/2015:00:14:18 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.1-&_=1424067255898&5= HTTP/1.1"
> 200 80
> w.x.y.z - - [16/Feb/2015:00:14:19 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255899
> HTTP/1.1" 200 157
> w.x.y.z - - [16/Feb/2015:00:14:20 -0600] "POST
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-buttons-finish
> HTTP/1.1" 200 2310
> w.x.y.z - - [16/Feb/2015:00:14:21 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255900
> HTTP/1.1" 200 613
> w.x.y.z - - [16/Feb/2015:00:14:21 -0600] "POST
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container-progress
> HTTP/1.1" 200 80
> w.x.y.z - - [16/Feb/2015:00:14:22 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255901
> HTTP/1.1" 200 613
> w.x.y.z - - [16/Feb/2015:00:14:23 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255902
> HTTP/1.1" 200 613
> w.x.y.z - - [16/Feb/2015:00:14:24 -0600] "GET
> /openmeetings/install?5-6.IBehaviorListener.0-wizard-form-view-container&_=1424067255903
> HTTP/1.1" 200 9244
>
>
>
>
>
>
> --
>
> Regards,
>
> Susheel Jalali
>
> Customer Operations Leader,
>
> Coscend Communications Solutions
>
> Elite Premio Complex Suite 200 Survey No 7 & 8 Balewadi Pune 411045
> Maharashtra India
>
> Cell +91-9011000233
>
> *Susheel.Jalali@CoscendCommunications.com
> <Su...@CoscendCommunications.com>*
>
> Web site: www.CoscendCommunications.com
> <http://www.coscendcommunications.com/>
>
> ------------------------------------------------------------------
>
> *Coscend’s* *Software Service Factory*
>
> "*Coscend Communications* is ... *pioneering a new approach* to ...
> software applications development, and systems integration."
>
> *Light Reading Network, *December, 2007
>
> "*Coscend* is at the *vanguard of a new evolution* in telco OSS/BSS
> systems integration."
>
> *Caroline Chappell*
> A leading authority in the communications services software industry
>
> "There are *innovative* … *tools* from ... *Coscend *bubbling up, which
> will help accelerate the data consolidation process and reduce its cost."
>
> *Dennis Mendyk, **Editor,* Building a *Telco Service Factory*
>
> ------------------------------------------------------------------
>
> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
> Messages from Coscend Communications Solutions' posted at:
> http://www.CoscendCommunications.com/Terms_and_Conditions.html
> <http://www.coscendcommunications.com/Terms_and_Conditions.html>
>
>
>
--
WBR
Maxim aka solomax