access to yellowfin configuration database on ec2 instance from AWS Marketplace

Hi Chris,

Thanks for reaching out to yellowfin.

I don't think we have any documentation on access a db.

If YF is up and running, then

Firstly, I would verify the db we have installed with yellowfin by appending /info.jsp at the end of the URL. For example, I use http:localhost:8080 to run YF, so:

(We can also look at the web.xml JDBC settings to verify this)

Then, I would install a 3rd party tool like DbVisualizer, load the driver and use the connection string from web.xml to connect to it:

If we have postgres running, and if psql failed to connect then we may have to check if there are other permissions required from AWS side which is topping the access. And also can you please confirm if you are able to start the server and login via browser?

Thanks,

Deepak

Hi Chris,

Here are a couple of related articles (but not the exact article for AWS - I believe this should be same as any other db, but should consider the AWS access settings to reach it via 3rd party tools):

https://community.yellowfinbi.com/knowledge-base/article/connecting-to-the-yellowfin-db-on-azure

https://community.yellowfinbi.com/knowledge-base/article/how-to-query-yfs-embedded-hsql-database

Thanks,

Deepak

Hello,

Thanks for your reply.

I think what I'm really asking is: Does yellowfin set a default password for the postgres user ("yellowfin-dba") that it installs from the AWS ec2 marketplace?

Yes, app works in the browser, etc.

Hi Chris,

Generally, YF comes with hssql as default db when we install on any environment (the default password for this is null), please refer to the connection below:

But if we change the db (may be like postgres, mssql etc during installation), it would prompt for the db server/credentials details in the environment and uses those credentials to create the configdb.

I currently do not have access to AWS instance to test the default db that comes with AWS EC2 image of YF(Will try to get one soon). We may try password as null or yellowfin123. Alternatively if we have access to the Postgres db itself directly(via PgAdmin etc), then we can try create a new Postgres admin(who has rights similar to yellowfin-dba) and then replace the details of this new user in web.xml file.

Please let me know if that helps.

Regards,

Deepak

Hi Chris.,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Kind regards,

Deepak Chaganti

Hi Chris,

I hope things are going well with you.

Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.

Kind regards,

Deepak