Error Starting Yellowfin
Good afternoon today I encounter the following problem:
"An error occurred during system startup. Ask your system administrator to check the connection settings for the database. Find more information in the log files"
And check the logs and it seems that it is not receiving the connection packets.
This is what appears in the log file:
JDBC.log
2016-12-27 15:17:13 NOTICE: -----------------------------------------
2016-12-27 15:17:13 NOTICE: 2016-12-27 15:17:13
2016-12-27 15:17:13 NOTICE: Starting DBConnectionPool
2016-12-27 15:17:13 NOTICE: sourceId: 0
2016-12-27 15:17:13 NOTICE: sourceName: Application Configuration Database
2016-12-27 15:17:13 NOTICE: connectionMethod: JDBC
2016-12-27 15:17:13 NOTICE: authAdapter: Standard Authentication(GENERICUSER)
2016-12-27 15:17:13 NOTICE: driver: com.mysql.jdbc.Driver
2016-12-27 15:17:13 NOTICE: url: jdbc:mysql://localhost:3306/yellowfin?characterEncoding=utf8
2016-12-27 15:17:13 NOTICE: username: root
2016-12-27 15:17:13 NOTICE: min connections: 2
2016-12-27 15:17:13 NOTICE: max connections: 25
2016-12-27 15:17:13 NOTICE: maxOpenTime: 4 h
2016-12-27 15:17:13 NOTICE: maxCheckoutTime: 5 min
2016-12-27 15:17:13 NOTICE: psCacheSize: 20
2016-12-27 15:17:13 NOTICE: FetchSize: 0
2016-12-27 15:17:13 NOTICE: Verify connections: false
2016-12-27 15:17:13 NOTICE: Application Version: 7.1
2016-12-27 15:17:13 NOTICE: Build Version: 20160701
2016-12-27 15:17:13 NOTICE: Pooling Enabled: true
2016-12-27 15:17:13 NOTICE: -----------------------------------------
2016-12-27 15:17:15 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. 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.
2016-12-27 15:17:32 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 2). Will try again in 15 seconds. 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.
2016-12-27 15:17:49 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 3). Will try again in 15 seconds. 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.
2016-12-27 15:18:06 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 4). Will try again in 15 seconds. 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.
2016-12-27 15:18:23 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 5). Will try again in 15 seconds. 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.
2016-12-27 15:18:40 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 6). Will try again in 15 seconds. 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.
2016-12-27 15:18:57 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 7). Will try again in 15 seconds. 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.
2016-12-27 15:19:14 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 8). Will try again in 15 seconds. 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.
2016-12-27 15:19:31 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 9). Will try again in 15 seconds. 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.
2016-12-27 15:19:48 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 10). 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.
2016-12-27 15:19:48 ERROR: Failed to create initial connection at DBConnectionPool startup. Giving up.
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.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2479)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:155)
at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:128)
at com.hof.pool.DBConnectionPool.A(DBConnectionPool.java:1113)
at com.hof.pool.DBConnectionPool.createJDBCPool(DBConnectionPool.java:553)
at com.hof.pool.DBConnectionManager.initialiseAppPool(DBConnectionManager.java:389)
at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:222)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5262)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5550)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)
... 34 more
Yellowfin.log
YF:2016-12-27 15:17:12: WARN (PropertyMessageResources:loadLocale) - Resource com/hof/ApplicationResources_es_MX.properties Not Found.
YF:2016-12-27 15:19:48: INFO (DBConnectionManager:shutdown) - DBConnectionManager shutting down
YF:2016-12-27 15:19:48: INFO (DBConnectionManager:shutdown) - DBConnectionManager completed shutdown
YF:2016-12-27 15:19:48: INFO (hofStartup:init) - === hofStartup Starting Up ===
YF:2016-12-27 15:19:48:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.process.BuildDataProcess.A(BuildDataProcess.java:58)
at com.hof.process.BuildDataProcess.getBuildData(BuildDataProcess.java:78)
at com.hof.servlet.hofStartup.init(hofStartup.java:63)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5262)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5550)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
YF:2016-12-27 15:19:48:ERROR (BuildDataProcess:A) - Error: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:19:48:ERROR (BuildDataProcess:A) - Error: java.lang.NullPointerException
YF:2016-12-27 15:19:48:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:411)
at com.hof.util.RefCodeList$_C.<init>(RefCodeList.java:159)
at com.hof.util.RefCodeList$_C.<init>(RefCodeList.java:134)
at com.hof.util.RefCodeList.initialise(RefCodeList.java:667)
at com.hof.servlet.hofStartup.init(hofStartup.java:111)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5262)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5550)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
YF:2016-12-27 15:19:48:ERROR (RefCodeList:<init>) - Error loading configuration records: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:19:48:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.util.LicenceControl.getInstance(LicenceControl.java:451)
at com.hof.servlet.InitLicenceCheck.init(InitLicenceCheck.java:96)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5262)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5550)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
YF:2016-12-27 15:24:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:665)
at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:422)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
YF:2016-12-27 15:24:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:24:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:29:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:665)
at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:422)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
YF:2016-12-27 15:29:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:29:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:34:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:665)
at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:422)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
YF:2016-12-27 15:34:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:34:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:39:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:665)
at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:422)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
YF:2016-12-27 15:39:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:39:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:44:00:ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException
java.lang.NullPointerException
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:414)
at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:285)
at com.hof.util.DBAction.<init>(DBAction.java:343)
at com.hof.util.DBAction.<init>(DBAction.java:456)
at com.hof.util.DBAction.<init>(DBAction.java:398)
at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:665)
at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:422)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
YF:2016-12-27 15:44:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception
YF:2016-12-27 15:44:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception
I hope and can help me with this inconvenience
Greetings and in advance thanks
The same problem 
Hi Delgado,
With the files you provided I was able to successfully startup your Yellowfin installation by pointing it to my database server.
Let's go ahead and try to set the password in the web.xml file following these instructions:
Open <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml in your favorite text editor.
Find the parameter titled JDBCPassword and replace the string with the password you've used to successfully log in with today.
Change the parameter titled JDBCPasswordEncryption to false (it should be the next parameter after Password).
Save the file.
Start Yellowfin.
Let me know the results of this.
Thanks,
Ryan
Hi Delgado,
With the files you provided I was able to successfully startup your Yellowfin installation by pointing it to my database server.
Let's go ahead and try to set the password in the web.xml file following these instructions:
Open <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml in your favorite text editor.
Find the parameter titled JDBCPassword and replace the string with the password you've used to successfully log in with today.
Change the parameter titled JDBCPasswordEncryption to false (it should be the next parameter after Password).
Save the file.
Start Yellowfin.
Let me know the results of this.
Thanks,
Ryan
Hi Delgado,
Thanks for contacting us in regards to the issue you're having. It looks like Yellowfin is unable to the database. If you could check the reference to your database in <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml that would be helpful.
Is this a new or existing installation?
Have you modified your database location or authentication recently?
I look forward to your answers.
Thanks,
Ryan
Hi Delgado,
Thanks for contacting us in regards to the issue you're having. It looks like Yellowfin is unable to the database. If you could check the reference to your database in <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml that would be helpful.
Is this a new or existing installation?
Have you modified your database location or authentication recently?
I look forward to your answers.
Thanks,
Ryan
Hi Ryan
Thanks for Responding my Question
According to what you tell me
It is not a new installation, it has been used before
No authentication credentials changed
And the installation path I have this: "C: \ Yellowfin 7.1 \"
The configuration that is in web.xml is the following:
<! - Initiate JDBC Connection Pooling - Setup / Configuration ->
<Servlet>
<Servlet-name> InitConnectionPool </ servlet-name>
<Servlet-class> com.hof.servlet.InitConnectionPool </ servlet-class>
<Init-param>
<Param-name> Description </ param-name>
<Param-value> Yellowfin Connection Pool </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCDriverClass </ param-name>
<Param-value> com.mysql.jdbc.Driver </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCUrl </ param-name>
<Param-value> jdbc: mysql: // localhost: 3306 / yellowfin? CharacterEncoding = utf8 </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCUser </ param-name>
<Param-value> root </ param-value>
</ Init-param>
And nothing has been changed either from the base or this file
Greetings and in advance thanks
Hi Ryan
Thanks for Responding my Question
According to what you tell me
It is not a new installation, it has been used before
No authentication credentials changed
And the installation path I have this: "C: \ Yellowfin 7.1 \"
The configuration that is in web.xml is the following:
<! - Initiate JDBC Connection Pooling - Setup / Configuration ->
<Servlet>
<Servlet-name> InitConnectionPool </ servlet-name>
<Servlet-class> com.hof.servlet.InitConnectionPool </ servlet-class>
<Init-param>
<Param-name> Description </ param-name>
<Param-value> Yellowfin Connection Pool </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCDriverClass </ param-name>
<Param-value> com.mysql.jdbc.Driver </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCUrl </ param-name>
<Param-value> jdbc: mysql: // localhost: 3306 / yellowfin? CharacterEncoding = utf8 </ param-value>
</ Init-param>
<Init-param>
<Param-name> JDBCUser </ param-name>
<Param-value> root </ param-value>
</ Init-param>
And nothing has been changed either from the base or this file
Greetings and in advance thanks
Hi Delgado,
Thanks for the additional information.
Have you verified that MySQL is running? From the looks of things you're being refused connection to the database on port 3306, which would indicate the strong possibility that the MySQL service is not up and listening on that port.
It would be helpful if you could try connecting to MySQL using MySQL Workbench or DBVisualizer and let me know the results?
Thanks,
Ryan
Hi Delgado,
Thanks for the additional information.
Have you verified that MySQL is running? From the looks of things you're being refused connection to the database on port 3306, which would indicate the strong possibility that the MySQL service is not up and listening on that port.
It would be helpful if you could try connecting to MySQL using MySQL Workbench or DBVisualizer and let me know the results?
Thanks,
Ryan
Hi Ryan
If in effect I can connect to my database in mysql by Navicat on port 3306 and by phpmyadmin however I do not know why yellowfin does not start.
Thanks
Hi Ryan
If in effect I can connect to my database in mysql by Navicat on port 3306 and by phpmyadmin however I do not know why yellowfin does not start.
Thanks
Delgado,
In order to investigate this a little deeper it would be helpful to see any logs from when Yellowfin was last working. It would be helpful if you could provide a zipped copy of your entire log folder at <YourYellowfinInstallation>/appserver/logs. Could you also include any log files from the root of your installation?
Thanks,
Ryan
Delgado,
In order to investigate this a little deeper it would be helpful to see any logs from when Yellowfin was last working. It would be helpful if you could provide a zipped copy of your entire log folder at <YourYellowfinInstallation>/appserver/logs. Could you also include any log files from the root of your installation?
Thanks,
Ryan
Thanks Ryan
Thanks Ryan
I share my installation of Yellowfin as you requested and in advance thanks
Thanks Ryan
Thanks Ryan
I share my installation of Yellowfin as you requested and in advance thanks
Hi Delgado,
With the files you provided I was able to successfully startup your Yellowfin installation by pointing it to my database server.
Let's go ahead and try to set the password in the web.xml file following these instructions:
Open <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml in your favorite text editor.
Find the parameter titled JDBCPassword and replace the string with the password you've used to successfully log in with today.
Change the parameter titled JDBCPasswordEncryption to false (it should be the next parameter after Password).
Save the file.
Start Yellowfin.
Let me know the results of this.
Thanks,
Ryan
Hi Delgado,
With the files you provided I was able to successfully startup your Yellowfin installation by pointing it to my database server.
Let's go ahead and try to set the password in the web.xml file following these instructions:
Open <YourYellowfinInstallation>/appserver/webapps/ROOT/WEB-INF/web.xml in your favorite text editor.
Find the parameter titled JDBCPassword and replace the string with the password you've used to successfully log in with today.
Change the parameter titled JDBCPasswordEncryption to false (it should be the next parameter after Password).
Save the file.
Start Yellowfin.
Let me know the results of this.
Thanks,
Ryan
Hi Ryan
Thank you very much with what you said to me I was able to raise again the service of Yellowfin
Hi Ryan
Thank you very much with what you said to me I was able to raise again the service of Yellowfin
Delgado,
I'm glad to hear you're up and running again. If you want to encrypt your password in the web.xml file again you can download the EncryptPassword.jar utility here.
Open a command window where the file is located and run:
java -jar EncryptPassword.jar
Type in your password and it will output the encrypted password.
Copy this and replace the plain-text password you changed in your web.xml.
Change the JDBCPasswordEncrypted parameter back to true.
Restart Yellowfin.
Let us know if you have any other questions or issues.
Thanks,
Ryan
Delgado,
I'm glad to hear you're up and running again. If you want to encrypt your password in the web.xml file again you can download the EncryptPassword.jar utility here.
Open a command window where the file is located and run:
java -jar EncryptPassword.jar
Type in your password and it will output the encrypted password.
Copy this and replace the plain-text password you changed in your web.xml.
Change the JDBCPasswordEncrypted parameter back to true.
Restart Yellowfin.
Let us know if you have any other questions or issues.
Thanks,
Ryan
Thanks for your help Ryan
Happy Holidays !
Thanks for your help Ryan
Happy Holidays !
Hi Yhair,
I'm glad to have been of help.
Thanks,
Ryan
Hi Yhair,
I'm glad to have been of help.
Thanks,
Ryan
Replies have been locked on this page!