Comments (12)
k3nd0x
commented on June 10, 2024
Please show me the logfiles of the docker-compose.
Note: you have to login with admin@domain. If you are using default just use admin@localhost.
from piglet.
mr-shorten
commented on June 10, 2024
/
Creating volume "piglet_database-data" with default driver
Creating piglet-db ... done
Creating piglet ... done
Attaching to piglet-db, piglet
piglet-db | 2023-08-03 06:09:09+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.2+maria~ubu2204 started.
piglet-db | 2023-08-03 06:09:10+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
piglet-db | 2023-08-03 06:09:10+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.2+maria~ubu2204 started.
piglet-db | 2023-08-03 06:09:10+00:00 [Note] [Entrypoint]: Initializing database files
piglet | 2023-08-02 22:09:10,988 INFO Set uid to user 0 succeeded
piglet | 2023-08-02 22:09:10,991 INFO supervisord started with pid 1
piglet-db |
piglet-db |
piglet-db | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
piglet-db | To do so, start the server, then issue the following command:
piglet-db |
piglet-db | '/usr/bin/mariadb-secure-installation'
piglet-db |
piglet-db | which will also give you the option of removing the test
piglet-db | databases and anonymous user created by default. This is
piglet-db | strongly recommended for production servers.
piglet-db |
piglet-db | See the MariaDB Knowledgebase at https://mariadb.com/kb
piglet-db |
piglet-db | Please report any problems at https://mariadb.org/jira
piglet-db |
piglet-db | The latest information about MariaDB is available at https://mariadb.org/.
piglet-db |
piglet-db | Consider joining MariaDB's strong and vibrant community:
piglet-db | https://mariadb.org/get-involved/
piglet-db |
piglet-db | 2023-08-03 06:09:11+00:00 [Note] [Entrypoint]: Database files initialized
piglet-db | 2023-08-03 06:09:11+00:00 [Note] [Entrypoint]: Starting temporary server
piglet-db | 2023-08-03 06:09:11+00:00 [Note] [Entrypoint]: Waiting for server startup
piglet-db | 2023-08-03 6:09:11 0 [Note] Starting MariaDB 10.11.2-MariaDB-1:10.11.2+maria~ubu2204 source revision cafba8761af55ae16cc69c9b53a341340a845b36 as process 92
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Number of transaction pools: 1
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
piglet-db | 2023-08-03 6:09:11 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Completed initialization of buffer pool
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: 128 rollback segments are active.
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
piglet-db | 2023-08-03 6:09:11 0 [Note] InnoDB: log sequence number 45452; transaction id 14
piglet-db | 2023-08-03 6:09:11 0 [Note] Plugin 'FEEDBACK' is disabled.
piglet-db | 2023-08-03 6:09:11 0 [Warning] 'user' entry 'root@c9a8f310fe9a' ignored in --skip-name-resolve mode.
piglet-db | 2023-08-03 6:09:11 0 [Warning] 'proxies_priv' entry '@% root@c9a8f310fe9a' ignored in --skip-name-resolve mode.
piglet-db | 2023-08-03 6:09:11 0 [Note] mariadbd: ready for connections.
piglet-db | Version: '10.11.2-MariaDB-1:10.11.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
piglet | 2023-08-02 22:09:11,994 INFO spawned: 'import_db' with pid 7
piglet | 2023-08-02 22:09:11,996 INFO spawned: 'piglet-redis' with pid 8
piglet | 2023-08-02 22:09:11,999 INFO spawned: 'piglet-api' with pid 9
piglet | 2023-08-02 22:09:12,002 INFO spawned: 'piglet-app' with pid 12
piglet | 2023-08-02 22:08:12 waiting for database host
piglet | 2023-08-02 22:09:12,003 INFO success: import_db entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
piglet | [2023-08-02 22:09:12 -0800] [12] [INFO] Starting gunicorn 21.2.0
piglet | [2023-08-02 22:09:12 -0800] [12] [INFO] Listening at: http://0.0.0.0:80 (12)
piglet | [2023-08-02 22:09:12 -0800] [12] [INFO] Using worker: sync
piglet | [2023-08-02 22:09:12 -0800] [17] [INFO] Booting worker with pid: 17
piglet | [2023-08-02 22:09:12] - DEBUG - registered 'sha256_crypt' handler: <class 'passlib.handlers.sha2_crypt.sha256_crypt'>
piglet-db | 2023-08-03 06:09:12+00:00 [Note] [Entrypoint]: Temporary server started.
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: GENERATED ROOT PASSWORD: tulO!3$L`3^Hq!RfE0rEPsVqK0#{6Y{:
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: Creating database piglet
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: Creating user piglet
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: Giving user piglet access to schema piglet
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
piglet-db |
piglet-db | 2023-08-03 06:09:14+00:00 [Note] [Entrypoint]: Stopping temporary server
piglet-db | 2023-08-03 6:09:14 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
piglet-db | 2023-08-03 6:09:14 0 [Note] InnoDB: FTS optimize thread exiting.
piglet-db | 2023-08-03 6:09:14 0 [Note] InnoDB: Starting shutdown...
piglet-db | 2023-08-03 6:09:14 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
piglet-db | 2023-08-03 6:09:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 230803 6:09:14
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Shutdown completed; log sequence number 46702; transaction id 15
piglet-db | 2023-08-03 6:09:15 0 [Note] mariadbd: Shutdown complete
piglet-db |
piglet-db | 2023-08-03 06:09:15+00:00 [Note] [Entrypoint]: Temporary server stopped
piglet-db |
piglet-db | 2023-08-03 06:09:15+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
piglet-db |
piglet-db | 2023-08-03 6:09:15 0 [Note] Starting MariaDB 10.11.2-MariaDB-1:10.11.2+maria~ubu2204 source revision cafba8761af55ae16cc69c9b53a341340a845b36 as process 1
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Number of transaction pools: 1
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
piglet-db | 2023-08-03 6:09:15 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Completed initialization of buffer pool
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: 128 rollback segments are active.
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: log sequence number 46702; transaction id 14
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
piglet-db | 2023-08-03 6:09:15 0 [Note] Plugin 'FEEDBACK' is disabled.
piglet-db | 2023-08-03 6:09:15 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
piglet-db | 2023-08-03 6:09:15 0 [Note] Server socket created on IP: '0.0.0.0'.
piglet-db | 2023-08-03 6:09:15 0 [Note] Server socket created on IP: '::'.
piglet-db | 2023-08-03 6:09:15 0 [Note] InnoDB: Buffer pool(s) load completed at 230803 6:09:15
piglet-db | 2023-08-03 6:09:15 0 [Note] mariadbd: ready for connections.
piglet-db | Version: '10.11.2-MariaDB-1:10.11.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
piglet-db | 2023-08-03 6:09:17 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.64.3' (This connection closed normally without authentication)
piglet | create database piglet if not exist
piglet | ERROR 1044 (42000) at line 1: Access denied for user 'piglet'@'%' to database '$DATABASE'
piglet | 2023-08-02 22:08:12 Import schema
piglet | 2023-08-02 22:09:17,102 INFO exited: import_db (exit status 0; expected)
piglet-db | 2023-08-03 6:09:27 7 [Warning] Aborted connection 7 to db: 'piglet' user: 'piglet' host: '192.168.64.3' (Got an error reading communication packets)
piglet | 2023-08-02 22:09:32,120 INFO success: piglet-redis entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
piglet | 2023-08-02 22:09:32,120 INFO success: piglet-api entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
piglet | 2023-08-02 22:09:32,120 INFO success: piglet-app entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
from piglet.
k3nd0x
commented on June 10, 2024
Ok the error is confusing. "The processes 'entered RUNNING state'"
Can you try it with admin@localhost and show me the logs again?
from piglet.
CrowMash
commented on June 10, 2024
Hi!
I've got the same problem when I try to log in with admin@localhost.
I get that error
Internal Server Error
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
And this log: [Warning] Access denied for user 'piglet'@'172.31.0.3' (using password: YES)
Details:
- Docker for Windows version 4.21.1
- Docker version 24.0.2, build cb74dfc
- Docker Compose version v2.19.1
- docker-compose.yml
version: '3.3'
services:
piglet:
restart: unless-stopped
container_name: piglet
depends_on:
- database
ports:
- '0.0.0.0:3006:80' # Piglet
- '0.0.0.0:3107:8080' # API
image: k3nd0x/piglet:latest
environment:
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
TZ: ${TZ}
database:
image: mariadb:latest
container_name: piglet-db
volumes:
- database-data:/var/lib/mysql
environment:
MYSQL_RANDOM_ROOT_PASSWORD: 1
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
TZ: ${TZ}
volumes:
database-data:- .env (redacted password)
MYSQL_PASSWORD=***
TZ=Europe/Paris
from piglet.
mr-shorten
commented on June 10, 2024
2023-08-03 09:06:22+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.0.2+maria~ubu2204 started.
2023-08-03 09:06:22+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-08-03 09:06:22+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.0.2+maria~ubu2204 started.
2023-08-03 09:06:23+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2023-08-03 09:06:23+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2023-08-03 9:06:23 0 [Note] Starting MariaDB 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 source revision 0005f2f06c8e1aea4915887decad67885108a929 as process 1
2023-08-03 9:06:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-08-03 9:06:23 0 [Note] InnoDB: Number of transaction pools: 1
2023-08-03 9:06:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-08-03 9:06:23 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-08-03 9:06:23 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-08-03 9:06:23 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-03 9:06:23 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-08-03 9:06:23 0 [Note] InnoDB: Reinitializing innodb_undo_tablespaces= 3 from 0
2023-08-03 9:06:23 0 [Note] InnoDB: Data file .//undo001 did not exist: new to be created
2023-08-03 9:06:23 0 [Note] InnoDB: Setting file .//undo001 size to 10.000MiB
2023-08-03 9:06:23 0 [Note] InnoDB: Database physically writes the file full: wait...
2023-08-03 9:06:23 0 [Note] InnoDB: Data file .//undo002 did not exist: new to be created
2023-08-03 9:06:23 0 [Note] InnoDB: Setting file .//undo002 size to 10.000MiB
2023-08-03 9:06:23 0 [Note] InnoDB: Database physically writes the file full: wait...
2023-08-03 9:06:23 0 [Note] InnoDB: Data file .//undo003 did not exist: new to be created
2023-08-03 9:06:23 0 [Note] InnoDB: Setting file .//undo003 size to 10.000MiB
2023-08-03 9:06:23 0 [Note] InnoDB: Database physically writes the file full: wait...
2023-08-03 9:06:23 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-08-03 9:06:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-08-03 9:06:23 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-08-03 9:06:23 0 [Note] InnoDB: log sequence number 100275; transaction id 104
2023-08-03 9:06:23 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-08-03 9:06:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-03 9:06:23 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-08-03 9:06:23 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-08-03 9:06:23 0 [Note] Server socket created on IP: '::'.
2023-08-03 9:06:24 0 [Note] mariadbd: ready for connections.
Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-08-03 9:06:24 0 [Note] InnoDB: Buffer pool(s) load completed at 230803 9:06:24
2023-08-03 9:06:24 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.80.3' (This connection closed normally without authentication)
2023-08-03 9:06:25 5 [Warning] Aborted connection 5 to db: 'piglet' user: 'piglet' host: '192.168.80.3' (Got an error reading communication packets)
Database logs
2023-08-03 01:06:23,604 INFO Set uid to user 0 succeeded
2023-08-03 01:06:23,606 INFO supervisord started with pid 1
2023-08-03 01:06:24,609 INFO spawned: 'import_db' with pid 8
2023-08-03 01:06:24,611 INFO spawned: 'piglet-redis' with pid 9
2023-08-03 01:06:24,615 INFO spawned: 'piglet-api' with pid 10
2023-08-03 01:06:24,617 INFO spawned: 'piglet-app' with pid 12
2023-08-03 01:06:24,627 INFO success: import_db entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
2023-08-03 01:08:24 Database schema is already set - not overwriting
2023-08-03 01:06:24,640 INFO exited: import_db (exit status 0; expected)
[2023-08-03 01:06:24 -0800] [12] [INFO] Starting gunicorn 21.2.0
[2023-08-03 01:06:24 -0800] [12] [INFO] Listening at: http://0.0.0.0:80 (12)
[2023-08-03 01:06:24 -0800] [12] [INFO] Using worker: sync
[2023-08-03 01:06:24 -0800] [18] [INFO] Booting worker with pid: 18
[2023-08-03 01:06:25] - DEBUG - registered 'sha256_crypt' handler: <class 'passlib.handlers.sha2_crypt.sha256_crypt'>
2023-08-03 01:06:45,329 INFO success: piglet-redis entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
2023-08-03 01:06:45,329 INFO success: piglet-api entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
2023-08-03 01:06:45,329 INFO success: piglet-app entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
[2023-08-03 01:06:25] - Starting Piglet API...
[2023-08-03 01:07:33] - DEBUG - Calling on_field_start with no data
[2023-08-03 01:07:33] - DEBUG - Calling on_field_name with data[0:8]
[2023-08-03 01:07:33] - DEBUG - Calling on_field_data with data[9:26]
[2023-08-03 01:07:33] - DEBUG - Calling on_field_end with no data
[2023-08-03 01:07:33] - DEBUG - Calling on_field_start with no data
[2023-08-03 01:07:33] - DEBUG - Calling on_field_name with data[27:35]
[2023-08-03 01:07:33] - DEBUG - Calling on_field_data with data[36:41]
[2023-08-03 01:07:33] - DEBUG - Calling on_field_end with no data
[2023-08-03 01:07:33] - DEBUG - Calling on_end with no data
[2023-08-03 01:07:33] - INFO - 127.0.0.1:51998 - "POST /admin/token HTTP/1.1" 200
[2023-08-03 01:07:33] - INFO - 127.0.0.1:52014 - "GET /user/login-user HTTP/1.1" 200
[2023-08-03 01:07:33] - INFO - 127.0.0.1:52026 - "GET /budget/ HTTP/1.1" 200
from piglet.
k3nd0x
commented on June 10, 2024
Ok thanks I know what the problem is. If you are not setting the env variables in the Database Container it is not possible to connect to the database because mariadb is not creating a user for piglet. So the variables are necessary not optional. Sorry for that.
I will find a solution for this problem soon. Just add the following the mysql Container:
MYSQL_RANDOM_ROOT_PASSWORD: 1
MYSQL_DATABASE: ${MYSQL_DATABASE}
MYSQL_USER: ${MYSQL_USER}
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
And in the piglet container:
MYSQL_USER: ${MYSQL_USER}
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
MYSQL_HOST: ${MYSQL_HOST}
MYSQL_DATABASE: ${MYSQL_DATABASE}
.env
MYSQL_PASSWORD=***
MYSQL_USER=piglet
MYSQL_DATABASE=piglet
MYSQL_HOST=database
Everything should be created and the login should work with admin@localhost
If you try again be secure you delete all database data from the volume or you delete the complete volume you created earlier with:
docker volume rm piglet_database-data (or whatever your volume is called)
from piglet.
CrowMash
commented on June 10, 2024
Login page doesn't show error anymore but I cannot login:
docker-compose.yml
version: '3.3'
services:
piglet:
restart: unless-stopped
container_name: piglet
depends_on:
- database
ports:
- '0.0.0.0:3006:80' # Piglet
- '0.0.0.0:3107:8080' # API
image: k3nd0x/piglet:latest
environment:
MYSQL_USER: ${MYSQL_USER}
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
MYSQL_HOST: ${MYSQL_HOST}
MYSQL_DATABASE: ${MYSQL_DATABASE}
TZ: ${TZ}
database:
image: mariadb:latest
container_name: piglet-db
volumes:
- database-data:/var/lib/mysql
environment:
MYSQL_RANDOM_ROOT_PASSWORD: 1
MYSQL_DATABASE: ${MYSQL_DATABASE}
MYSQL_USER: ${MYSQL_USER}
MYSQL_PASSWORD: ${MYSQL_PASSWORD}
TZ: ${TZ}
volumes:
database-data:.env
MYSQL_PASSWORD=***
MYSQL_USER=piglet
MYSQL_DATABASE=piglet
MYSQL_HOST=database
TZ=Europe/Paris
log
piglet-db | 2023-08-03 11:47:05+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.0.2+maria~ubu2204 started.
piglet-db | 2023-08-03 11:47:05+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
piglet-db | 2023-08-03 11:47:05+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.0.2+maria~ubu2204 started.
piglet-db | 2023-08-03 11:47:06+02:00 [Note] [Entrypoint]: Initializing database files
piglet-db |
piglet-db |
piglet-db |
piglet-db |
piglet-db | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
piglet-db | To do so, start the server, then issue the following command:
piglet-db |
piglet-db |
piglet-db | '/usr/bin/mariadb-secure-installation'
piglet-db |
piglet-db |
piglet | 2023-08-03 09:47:06,728 INFO Set uid to user 0 succeeded
piglet | 2023-08-03 09:47:06,731 INFO supervisord started with pid 1
piglet | 2023-08-03 09:47:07,735 INFO spawned: 'import_db' with pid 7
piglet | 2023-08-03 09:47:07,739 INFO spawned: 'piglet-redis' with pid 8
piglet | 2023-08-03 09:47:07,742 INFO spawned: 'piglet-api' with pid 9
piglet | 2023-08-03 09:47:07,745 INFO spawned: 'piglet-app' with pid 11
piglet | 2023-08-03 09:47:07,756 INFO success: import_db entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)
piglet | 2023-08-03 09:08:07 waiting for database host
piglet | [2023-08-03 09:47:08 +0000] [11] [INFO] Starting gunicorn 21.2.0
piglet | [2023-08-03 09:47:08 +0000] [11] [INFO] Listening at: http://0.0.0.0:80 (11)
piglet | [2023-08-03 09:47:08 +0000] [11] [INFO] Using worker: sync
piglet | [2023-08-03 09:47:08 +0000] [17] [INFO] Booting worker with pid: 17
piglet | [2023-08-03 09:47:11] - DEBUG - registered 'sha256_crypt' handler: <class 'passlib.handlers.sha2_crypt.sha256_crypt'>
piglet | 2023-08-03 09:08:07 waiting for database host
piglet | create database piglet if not exist
piglet | ERROR 1044 (42000) at line 1: Access denied for user 'piglet'@'%' to database '$DATABASE'
piglet | 2023-08-03 09:08:07 Import schema
piglet | 2023-08-03 09:47:18,338 INFO exited: import_db (exit status 0; expected)
piglet | 2023-08-03 09:47:28,354 INFO success: piglet-redis entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
piglet | 2023-08-03 09:47:28,356 INFO success: piglet-api entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
piglet | 2023-08-03 09:47:28,356 INFO success: piglet-app entered RUNNING state, process has stayed up for > than 20 seconds (startsecs)
piglet | [2023-08-03 09:47:12] - Starting Piglet API...
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_start with no data
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_name with data[0:8]
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_data with data[9:26]
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_end with no data
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_start with no data
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_name with data[27:35]
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_data with data[36:41]
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_field_end with no data
piglet | [2023-08-03 09:47:32] - DEBUG - Calling on_end with no data
piglet | [2023-08-03 09:47:32] - INFO - 127.0.0.1:54210 - "POST /admin/token HTTP/1.1" 200
piglet | [2023-08-03 09:47:32] - INFO - 127.0.0.1:54214 - "GET /user/login-user HTTP/1.1" 200
piglet | [2023-08-03 09:47:32] - INFO - 127.0.0.1:54220 - "GET /budget/ HTTP/1.1" 200
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_start with no data
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_name with data[0:8]
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_data with data[9:26]
piglet-db | which will also give you the option of removing the test
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_end with no data
piglet-db | databases and anonymous user created by default. This is
piglet-db | strongly recommended for production servers.
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_start with no data
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_name with data[27:35]
piglet-db |
piglet-db |
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_data with data[36:41]
piglet-db | See the MariaDB Knowledgebase at https://mariadb.com/kb
piglet-db |
piglet-db |
piglet-db | Please report any problems at https://mariadb.org/jira
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_field_end with no data
piglet | [2023-08-03 09:47:38] - DEBUG - Calling on_end with no data
piglet-db |
piglet-db |
piglet | [2023-08-03 09:47:38] - INFO - 127.0.0.1:54246 - "POST /admin/token HTTP/1.1" 200
piglet-db | The latest information about MariaDB is available at https://mariadb.org/.
piglet | [2023-08-03 09:47:38] - INFO - 127.0.0.1:54250 - "GET /user/login-user HTTP/1.1" 200
piglet | [2023-08-03 09:47:38] - INFO - 127.0.0.1:54256 - "GET /budget/ HTTP/1.1" 200
piglet-db |
piglet-db |
piglet-db | Consider joining MariaDB's strong and vibrant community:
piglet-db | https://mariadb.org/get-involved/
piglet-db |
piglet-db |
piglet-db | 2023-08-03 11:47:13+02:00 [Note] [Entrypoint]: Database files initialized
piglet-db | 2023-08-03 11:47:13+02:00 [Note] [Entrypoint]: Starting temporary server
piglet-db | 2023-08-03 11:47:13+02:00 [Note] [Entrypoint]: Waiting for server startup
piglet-db | 2023-08-03 11:47:13 0 [Note] Starting MariaDB 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 source revision 0005f2f06c8e1aea4915887decad67885108a929 as process 101
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Number of transaction pools: 1
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
piglet-db | 2023-08-03 11:47:13 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Using liburing
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: Completed initialization of buffer pool
piglet-db | 2023-08-03 11:47:13 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
piglet-db | 2023-08-03 11:47:14 0 [Note] InnoDB: Opened 3 undo tablespaces
piglet-db | 2023-08-03 11:47:14 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
piglet-db | 2023-08-03 11:47:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
piglet-db | 2023-08-03 11:47:14 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
piglet-db | 2023-08-03 11:47:14 0 [Note] InnoDB: log sequence number 47257; transaction id 14
piglet-db | 2023-08-03 11:47:14 0 [Note] Plugin 'FEEDBACK' is disabled.
piglet-db | 2023-08-03 11:47:14 0 [Note] Plugin 'wsrep-provider' is disabled.
piglet-db | 2023-08-03 11:47:14 0 [Warning] 'user' entry 'root@16687a3c28e6' ignored in --skip-name-resolve mode.
piglet-db | 2023-08-03 11:47:14 0 [Warning] 'proxies_priv' entry '@% root@16687a3c28e6' ignored in --skip-name-resolve mode.
piglet-db | 2023-08-03 11:47:14 0 [Note] mariadbd: ready for connections.
piglet-db | Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
piglet-db | 2023-08-03 11:47:14+02:00 [Note] [Entrypoint]: Temporary server started.
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: GENERATED ROOT PASSWORD: **redacted**
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Creating database piglet
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Creating user piglet
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Giving user piglet access to schema piglet
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
piglet-db |
piglet-db |
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Stopping temporary server
piglet-db | 2023-08-03 11:47:17 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: FTS optimize thread exiting.
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Starting shutdown...
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Buffer pool(s) dump completed at 230803 11:47:17
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Shutdown completed; log sequence number 47257; transaction id 15
piglet-db | 2023-08-03 11:47:17 0 [Note] mariadbd: Shutdown complete
piglet-db |
piglet-db |
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: Temporary server stopped
piglet-db |
piglet-db |
piglet-db | 2023-08-03 11:47:17+02:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
piglet-db |
piglet-db |
piglet-db | 2023-08-03 11:47:17 0 [Note] Starting MariaDB 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 source revision 0005f2f06c8e1aea4915887decad67885108a929 as process 1
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Number of transaction pools: 1
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
piglet-db | 2023-08-03 11:47:17 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Using liburing
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Completed initialization of buffer pool
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Opened 3 undo tablespaces
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: log sequence number 47257; transaction id 14
piglet-db | 2023-08-03 11:47:17 0 [Note] Plugin 'FEEDBACK' is disabled.
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
piglet-db | 2023-08-03 11:47:17 0 [Note] Plugin 'wsrep-provider' is disabled.
piglet-db | 2023-08-03 11:47:17 0 [Note] InnoDB: Buffer pool(s) load completed at 230803 11:47:17
piglet-db | 2023-08-03 11:47:17 0 [Note] Server socket created on IP: '0.0.0.0'.
piglet-db | 2023-08-03 11:47:17 0 [Note] Server socket created on IP: '::'.
piglet-db | 2023-08-03 11:47:17 0 [Note] mariadbd: ready for connections.
piglet-db | Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
piglet-db | 2023-08-03 11:47:17 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.0.3' (This connection closed normally without authentication)
piglet-db | 2023-08-03 11:47:27 7 [Warning] Aborted connection 7 to db: 'piglet' user: 'piglet' host: '192.168.0.3' (Got an error reading communication packets)
from piglet.
k3nd0x
commented on June 10, 2024
Did you remove the database volume?
from piglet.
CrowMash
commented on June 10, 2024
Yes, I deleted the container, the image and the volume before pulling it and running it again.
from piglet.
k3nd0x
commented on June 10, 2024
I just tested your compose and env file. It works on my server. The original mariadb server need some time to start up.
If you are starting the compose file you have to wait a few seconds till the database container is up and the schema import ran. Just start and wait abount 30-45 seconds. Than it should work to login with admin@localhost and 'admin' as password
from piglet.
CrowMash
commented on June 10, 2024
If I wait long enough I don't get the error but this pop up:
Then I am redirected to the login page again.
And again the same log: piglet-db | 2023-08-03 21:49:31 9 [Warning] Aborted connection 9 to db: 'piglet' user: 'piglet' host: '192.168.16.3' (Got an error reading communication packets)
from piglet.
mr-shorten
commented on June 10, 2024
This is not resolved. Why was this closed?
from piglet.
Related Issues (13)
- Site is flashing at reload, when darkmode is enabled
- Navbar pops up for a second when mini menue is active
- separate port for api and dashboard? HOT 2
- Quicken Import / PDF import / Online banking import
- Piglet is "waiting for database host" HOT 5
- API Class in Flask HOT 1
- If mail host not configured, dont try to send mails HOT 1
- Login with admin user not working HOT 4
- Implement SQLite3 as database
- Budget sharing over registered user not only per mail
- CSV Import
- Scheduled Transactions
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from piglet.