Supplying user & password in variables does not work #123
Comments
|
Interesting.... I use webtrees myself with a completely separate MariaDB database as well with no issues. Are you sure there are no networking issues at play? The container comes with the
I would also recommend removing the environment variables entirely and try using the builtin setup wizard. Lastly, I'll add that one root access denied message is not unexpected. Output log from MariaDB for me running the |
|
Hi there @NathanVaughn , i have pretty similar issue Trying to set up the wizard, the error response is I´ve tried to run your command in the webtree app terminal, and with the service.consul comand i´m not able to connect (perhaps the name is wrong by my side) so it seems that the issue is not related in this case with the credentials provided in the docker-compose, isn´t? thanks and greetings |
|
something that i found here #115
this can be the issue, that issue is still opened, any solution? Thanks! |
|
First, the I believe I fixed the issue in 9f1361d with the alternate environment variables not being picked up. Try the Additionally, I use mapped folders on my installation for persistent storage with no issues. It could be permissions problems. A temporary thing to try to see if that is it, is giving all permissions of |
|
Hello @NathanVaughn Yep, it seems there is an issue recovering the MARIADB var, at least the passwords
anyway i´ve tried to change to DB vars but i still can not access
|
|
What container image and tag are pulling? |
|
Hi there @NathanVaughn yep, the latest one, this is the docker-compose.yml Thanks in advance! |
I got everything to launch with this compose file: version: "3"
services:
webtrees_app:
depends_on:
- webtrees_db
environment:
PRETTY_URLS: "1"
HTTPS: "0"
HTTPS_REDIRECT: "0"
LANG: "es-ES"
BASE_URL: "http://localhost:8084"
DB_TYPE: "mysql"
DB_HOST: "webtrees_db"
DB_PORT: "3306"
MARIADB_USER: "DBUSERhere"
MARIADB_PASSWORD: "DBPASShere"
MARIADB_DATABASE: "DBNAMEhere"
DB_PREFIX: "wt_"
WT_USER: "WTUSERhere"
WT_NAME: "WTnamehere"
WT_PASS: "WTpasshere"
WT_EMAIL: "emailhere@email.com"
image: ghcr.io/nathanvaughn/webtrees:latest
ports:
- 8084:80
# - 80443:443
restart: unless-stopped
volumes:
# - ~/certs:/certs/
- ./app_data:/var/www/webtrees/data/
- ./app_media:/var/www/webtrees/media/
- ./app_themes:/var/www/webtrees/modules_v4/
webtrees_db:
environment:
MARIADB_DATABASE: "DBNAMEhere"
MARIADB_USER: "DBUSERhere"
MARIADB_PASSWORD: "DBPASShere"
MARIADB_ROOT_PASSWORD: "DBROOTPASShere"
image: docker.io/library/mariadb:latest
restart: unless-stopped
volumes:
- ./db_data:/var/lib/mysql
volumes:
db_data:
driver: local
app_data:
driver: local
app_media:
driver: local
app_themes:
driver: localI still had some issues with the MariaDB container, but I think that is because of WSL. See https://stackoverflow.com/a/70784438/9944427 |
|
Hello! Ok, i had to change the localhost var to the local ip of my server to be able to connect, but everything else in the yml works correctly, thanks! Regarding the var MARIADB_ROOT_PASSWORD I deleted it because it was not found in the logs: Anyway, after entering the username and password for the first time, I see this error:
it seems that the error was caused by the selected language, but after setting it right in the user options, then I was able to create the first family tree table and everything fine. Thank you! |
|
Gotta admit I haven't read the whole thread but I noticed that But for some reason So I have it working locally with the following env (just remove one of the That being said I am still figuring out how to make it work behind my nginx reverse proxy |
I have a separate container with MariaDB. I have linked webtrees containter with it. I have specified DB_HOST parameter and also MARIADB_USER, MARIADB_PASSWORD and MARIADB_DATABASE. I am getting Connection refused. When I've checked MariaDB logs, I'm getting attempts to connect as a root user without any password: Access denied for user 'root'@'xyz' (using password: NO). I have tried using MYSQL_ version of variables, but I am getting the same error. I have specified DB_TYPE as 'mysql'.
The text was updated successfully, but these errors were encountered: