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
[email protected]_
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>
