Re: OpenMeetings-3.0.4RC Installation Issues

[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