OnClick environment How to Access Database directly
Hey Team
This is a newbie question but I cannot seem to figure it how. I have the OneClick Docker image working and the site is working great. How do Access the database directly. what is the username and password.?
My goal is to create the schema for the workspace through the website then do a large data import directly via SQL. I need to load about 200K persons and 4Million notes as a stress test from another CRM system.
Thanks for you help with this very basic Question.
Scott
4 Replies
https://discord.com/channels/1130383047699738754/1281354088264634380/1281476293677944844
Username: postgres - no password needed
That unfortunately didn't work for me I am attempting to access from my windows machine HeidiSQL tool and the database in a docker instance using the oneclick Install on the same machine. I am guessing it is not exposed that way, I don't 'know
Then I'm out of ideas
So I was able to get this to work. first I needed to adjust the docker-composer.yml file in the db section to put the port that is open
then manually removed the db-1 container.
then recreated it using command docker compose up -d now it is accessible via SQL Tools like HeidiSQL
then recreated it using command docker compose up -d now it is accessible via SQL Tools like HeidiSQL
