How to update yellowfin configuration table for custom login?

Edgardo J Perez Rios shared this question 4 months ago
Answered

Hello,

I'm trying to change the default yellowfin login page but, I don't know where to run the querie found in the wiki since I can't seem to find where the the yellowfin configuration db is.


UPDATE dbo.Configuration

SET ConfigData = 'login_companyName.jsp'

WHERE ConfigCode = 'LOGONPAGE'

Comments (5)

photo
1

Hi Edgardo,

Thanks for reaching out. What RDBMS do you have Yellowfin installed into? You can find this information under Application Details in your info.jsp file, which can be accessed by appending '/info.jsp' to your login URL. For example, localhost:8080/info.jsp.

/8Pz9foTc7+SV8AAAAASUVORK5CYII=

By taking this information, you can alter the syntax of the query you've referenced to update the specified parameter by running the query directly against your RDBMS.

This is what my 'LOGONPAGE' ConfigData value is set to currently in my YF instance on Microsoft SQL Server using SQL Server Management Studio:

/8rPM3Qu5O8sAAAAASUVORK5CYII=

The config db would likely have been chosen at the time of installation so whoever configured this should be aware of where the RDBMS is located.

Regards,

Mike

photo
1

Hi Mike,


The RDBMS installed to yellowfin is HSQL Database Engine 2.3.4 but, I still don't know exactly where to run this. The current database we'are using in our company is Progress OpenEdge so I don't know exactly how is the procedure with this if I need to work with SQL to run that querie.


Regards,


Edgardo

photo
1

Hi Edgardo,


You should be able to refer to Progress OpenEdge's documentation for how to connect to, and subsequently query, the database.


You can use something like DbVisualizer to connect to your database by creating a new Database Connection, selecting the corresponding driver for OpenEdge, and inputting your connection details. Your RDBMS' documentation should be able to point you to where to find your driver and connection details.Regards,

Mike

photo
1

Hi Edgardo,

I just wanted to check in and see make sure you've gotten this sorted.

Regards,

Mike

photo
1

Hi Edgardo,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike