Change database user used to update YF backend db.

Dave Murphy shared this question 2 years ago
Answered

After installation, where can I go to update the user that the yellowfin application is using to update the Yellowfin db?

Best Answer
photo

Hi Dave,


Thanks for the question. The connection details that Yellowfin uses to connect to its own database reside in a file called web.xml. This file resides at <YourYellowfinInstall>/appserver/webapps.ROOT/WEB-INF. Here are the steps that you will want to follow in order to change this user:


  1. Shut down Yellowfin.
  2. Navigate to the path above.
  3. Make a quick backup copy of the web.xml file.
  4. Open the web.xml file using your favorite text editor.
  5. Scroll to the InitConnectionPoolServlet section (about line 100 in my personal web.xml).
  6. Modify the JDBCUser parameter to the new user. This new user MUST maintain the necessary permissions for Yellowfin to read and write to its configuration database.
  7. Download the EncryptPassword.jar file that is attached to this post and run it in the command line with the command 'java -jar EncryptPassword.jar'. It will ask you for a plaintext password, and will print out the encrypted version.
  8. Update the JDBCPassword parameter with the encrypted password generated by the above program.
  9. Save the web.xml file.
  10. Start up Yellowfin as normal and test to ensure that everything is working properly.


If you could give this procedure a go and let us know if things go smoothly, that would be great. Thanks in advance!


Best,

-Conner


2b3854ba92c503570a66a94d333069a5

Comments (2)

photo
1

Hi Dave,


Thanks for the question. The connection details that Yellowfin uses to connect to its own database reside in a file called web.xml. This file resides at <YourYellowfinInstall>/appserver/webapps.ROOT/WEB-INF. Here are the steps that you will want to follow in order to change this user:


  1. Shut down Yellowfin.
  2. Navigate to the path above.
  3. Make a quick backup copy of the web.xml file.
  4. Open the web.xml file using your favorite text editor.
  5. Scroll to the InitConnectionPoolServlet section (about line 100 in my personal web.xml).
  6. Modify the JDBCUser parameter to the new user. This new user MUST maintain the necessary permissions for Yellowfin to read and write to its configuration database.
  7. Download the EncryptPassword.jar file that is attached to this post and run it in the command line with the command 'java -jar EncryptPassword.jar'. It will ask you for a plaintext password, and will print out the encrypted version.
  8. Update the JDBCPassword parameter with the encrypted password generated by the above program.
  9. Save the web.xml file.
  10. Start up Yellowfin as normal and test to ensure that everything is working properly.


If you could give this procedure a go and let us know if things go smoothly, that would be great. Thanks in advance!


Best,

-Conner


2b3854ba92c503570a66a94d333069a5

photo
1

Hi Dave,


Just checking in on this one to see if you were able to get the database user switched around successfully. Please let me know if you have any additional questions here.


Thanks!

-Conner