Error Starting Yellowfin

Yhair Delgado Cruz shared this problem 2 years ago
Resolved

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

Best Answer
photo

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

Comments (11)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

Thanks Ryan

Thanks Ryan

I share my installation of Yellowfin as you requested and in advance thanks

photo
2

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

photo
1

Hi Ryan


Thank you very much with what you said to me I was able to raise again the service of Yellowfin

photo
1

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

photo
1

Thanks for your help Ryan

Happy Holidays !

photo
1

Hi Yhair,


I'm glad to have been of help.


Thanks,

Ryan