Issue with initial user creation & mariaDB #143
Comments
|
What Linux distribution are you using? It might be an issue with the shell that is being used. I mainly use RHEL based distros however my setup has been confirmed to work with newer ubuntu releases. Id also like to see logs generated by laravel, those should be within data/panel/storage/logs/. That would give better insight as to what might be happening. |
|
I am using Ubuntu 22.04 as for the logs, have access.log & access.error.log in that folder but the later error log file is completely empty. Attached the access.log file but replaced my public ip with ###.##.##.### just so you are aware. As mentioned the other log file was completely empty so not included. |
|
access.log and error.log are nginx logs, I need the logs prefixed as laravel to identify why mariadb was not configured.Also a side note, have you configured mariadb.env's user password? |
|
That is odd, in the folder you asked me to check data/panel/storage/logs/ the only files present are access.error.log & access.log. Any ideas where the log files might be if not here? or is their something needed to enable the logs your looking for? As for mariadb.env's user password I have left everything as the default passwords, I did try to configure it previously to my own details but since that had the same issue I decided to keep everything with its default values until it worked. To be specific at the moment its setup as so in mariadb.env: Randomly generate root password and set to localhost only. And panel.env is setup like so: Redis Settings MySQL Settings |
|
I'm having the same issue, although I'm using Nginx Proxy Manager instead of Traefik (but I'm fairly sure that this problem has nothing to do with my reverse proxy setup). And here are the logs of the mariadb container: |
|
Regarding this error:
I needed to change |
|
I can confirm that changing from #!/bin/sh to #!/bin/bash did allow me to create a user for the panel and does allow me to log in to the panel. The issues with mariadb do remain however and when creating a user using the above whilst as mentioned it does allow me to log into the panel I now get the following in the worker: Which I am assuming is due to not being able to connect to the mariadb instance. |
|
To add to the above after creating a user and logging into the panel laravel logs were created in the location data/panel/storage/logs/. |
|
the error generated is in regards to SMTP. this is normal. You need to configure your email options or you can ignore it. |
|
Thought that was the case looking at them, its not something I need so thats fine just need to narrow down the cause of the mariadb issue any ideas? (will try setting up and connecting to the daemon see if I can get anything else that might help find the cause) |
|
Okay to provide further update to this if its any help after trying to setup the daemon side of things and create a node I get the config but after placing it in the right place I then start to get the following error on the daemon: following this setup I can no longer access the panel at all I get gateway timeout My assumption would be the above is due to my traefik setup which if thats the case I can address that later but thought i should include in case related to this issue or in case any recommendations to fix if it is my traefik setup. I also had some additional logs in portainer the following shows up in the panel (disapeared after a restart): In the worker I now get this: Finally the laravel logs have a bit more info now although the errors shown appear to be in relation to redis rather than mariadb but I am still seeing the same connection refused issue on mariadb as before: |
Hi,
I am setting this up again trying to proxy through traefik this time on a fresh install but having issues with mariaDB and making a user.
The panel is up and I can reach it but when running ./bin/artisan p:user:make I get the following error:
-e Warning! This command is intended for interactive sessions only. Please use docker-compose directly for use in scripts.
./bin/artisan: 13: [[: not found
Docker Compose service "panel" does not exist! Exiting...
Secondly it looks like none of the containers can reach mariadb, this shows in the logs for mariadb:
2022-09-02 10:54:12 0 [Note] mariadbd: ready for connections.
Version: '10.8.4-MariaDB-1:10.8.4+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2022-09-02 10:54:12 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.2' (This connection closed normally without authentication)
2022-09-02 10:54:12 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.6' (This connection closed normally without authentication)
2022-09-02 10:54:12 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.7' (This connection closed normally without authentication)
2022-09-02 10:54:13 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.6' (This connection closed normally without authentication)
2022-09-02 10:56:54 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.7' (This connection closed normally without authentication)
2022-09-02 10:58:32 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.2' (This connection closed normally without authentication)
2022-09-02 10:58:33 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.6' (This connection closed normally without authentication)
2022-09-02 10:58:33 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.7' (This connection closed normally without authentication)
2022-09-02 11:11:40 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.2' (This connection closed normally without authentication)
2022-09-02 11:11:40 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.7' (This connection closed normally without authentication)
2022-09-02 11:11:41 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.6' (This connection closed normally without authentication)
Apart from changing panel.env to timezone Europe/London & enabling the trusted proxies section no other changes have been made to panel.env. (also tried both mariadb (default out of the box option) and mysql as DB_HOST under mysql settings but neither works)
Any help would be really appreciated, thanks in advance.
The text was updated successfully, but these errors were encountered: