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.jal...@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.jal...@coscendcommunications.com > <susheel.jal...@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
