Git Product home page Git Product logo

Comments (9)

H2CK avatar H2CK commented on July 4, 2024

Bonjour Laurent,
I will try to analyse your problem in the next days.

from webtrees.

loranger avatar loranger commented on July 4, 2024

Merci ! 👍🏻

from webtrees.

H2CK avatar H2CK commented on July 4, 2024

Hi Laurent,
when I try to setup an environment with single docker commands everything works correct and you can login with the credentials set in WT_ADMIN and WT_ADMINPW.

So, when you execute:

docker run --name mariadb -p 3306:3306 -e MARIADB_ROOT_PASSWORD=rootpw -e MARIADB_USER=example-user -e MARIADB_PASSWORD=my_secret -d mariadb:10

and following

docker run -d -p 80:80 --name webtrees  -e DISABLE_SSL=TRUE -e PORT=80 -e DB_USER=root -e DB_PASSWORD=rootpw -e DB_HOST=192.168.1.131 -e DB_PORT=3306 -e DB_NAME=webtrees_db -e WT_ADMIN=admin -e WT_ADMINPW=admin dtjs48jkt/webtrees:latest

Everything works as expected and I would rule out that the implementation in general does not work.

Since you are using docker-compose I also tried to do a test with docker-compose. But I could not use your provided files directly due to a completely different environment (no Traefik, ..). After some modifications I got it running and had the effect that the database was created but no tables at all were contained the database. Currently it is not yet clear why this happens since the data is created with the single command:

mysql -u root --password=rootpw -h webtrees-mariadb < /mod_webtrees.sql

When you connect to the shell of the container you can execute the command and the database is successfully created. Also a successful login is possible.

Currently I would assume here a timing problem that the database is not ready while the webtrees container yet tries to write to the database. You could try to add the following to your docker-compose.yml:

command:
      - '/bin/sh'
      - '-c'
      - '/bin/sleep 30 && ./start.sh'
depends_on:
      - "mariadb"

I will try to analyze it further and check if there could be some enhancement in the webtrees image itself.

from webtrees.

H2CK avatar H2CK commented on July 4, 2024

With 8935913 a delay was added when initially setting up the database. This gives the database the time to startup before the SQL script is executed.

Please try the latest version for setting up webtrees with the database using docker-compose. Previously described modification is no longer necessary.

My local tests proved that the database was created successful. Hope you could confirm that too.

from webtrees.

loranger avatar loranger commented on July 4, 2024

Hi,

Thanks for your hard work.

I just tried, but I'm afraid it still does not work for me. You could find the log
I did prune all the containers and datas.
I started the project and waited 2 minutes (as you can see on the logs) before opening adminer, but the database was empty

logs
~/Developer/projects/webtrees
❯ la
total 16
-rw-r--r--  1 loranger  staff   602B 10 mai 08:51 .env
-rw-r--r--  1 loranger  staff   1,0K 10 mai 08:51 docker-compose.yml

~/Developer/projects/webtrees
❯ docker-compose pull
[+] Running 2/2
 ⠿ webtrees Pulled                                                         1.4s
 ⠿ mariadb Pulled                                                          1.4s

~/Developer/projects/webtrees
❯ docker-compose rm
No stopped containers

~/Developer/projects/webtrees
❯ docker-compose --profile adminer up
[+] Running 3/2
 ⠿ Container webtrees-adminer   Created                                    0.1s
 ⠿ Container webtrees-mariadb   Created                                    0.1s
 ⠿ Container webtrees-webtrees  Created                                    0.0s
Attaching to webtrees-adminer, webtrees-mariadb, webtrees-webtrees
webtrees-adminer   | [Tue May 10 07:05:52 2022] PHP 7.4.28 Development Server (http://[::]:8080) started
webtrees-mariadb   | 2022-05-10 07:05:52+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.3+maria~focal started.
webtrees-mariadb   | 2022-05-10 07:05:52+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
webtrees-mariadb   | 2022-05-10 07:05:52+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.3+maria~focal started.
webtrees-mariadb   | 2022-05-10 07:05:52+00:00 [Note] [Entrypoint]: Initializing database files
webtrees-webtrees  | Site webtrees_insecure already disabled
webtrees-webtrees  | Site webtrees already enabled
webtrees-webtrees  | PRETTYURLS not explicitly activated. Nothing to do.
webtrees-webtrees  | Set base_url in /var/www/html/data/config.ini.php
webtrees-webtrees  | ERROR: Configuration file /var/www/html/data/config.ini.php to set base_url not found.
webtrees-webtrees  | 2022-05-10 07:05:52,586 WARN No file matches via include "/etc/supervisor/conf.d/*.conf"
webtrees-webtrees  | 2022-05-10 07:05:52,586 INFO Set uid to user 0 succeeded
webtrees-webtrees  | 2022-05-10 07:05:52,588 INFO RPC interface 'supervisor' initialized
webtrees-webtrees  | 2022-05-10 07:05:52,588 CRIT Server 'unix_http_server' running without any HTTP authentication checking
webtrees-webtrees  | 2022-05-10 07:05:52,588 INFO supervisord started with pid 31
webtrees-webtrees  | 2022-05-10 07:05:53,594 INFO spawned: 'crond' with pid 33
webtrees-webtrees  | 2022-05-10 07:05:53,595 INFO spawned: 'apache2' with pid 34
webtrees-webtrees  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.20.0.10. Set the 'ServerName' directive globally to suppress this message
webtrees-webtrees  | 2022-05-10 07:05:54,618 INFO success: crond entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
webtrees-webtrees  | 2022-05-10 07:05:54,618 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
webtrees-mariadb   | 2022-05-10  7:05:55 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   |
webtrees-mariadb   |
webtrees-mariadb   | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
webtrees-mariadb   | To do so, start the server, then issue the following command:
webtrees-mariadb   |
webtrees-mariadb   | '/usr/bin/mysql_secure_installation'
webtrees-mariadb   |
webtrees-mariadb   | which will also give you the option of removing the test
webtrees-mariadb   | databases and anonymous user created by default.  This is
webtrees-mariadb   | strongly recommended for production servers.
webtrees-mariadb   |
webtrees-mariadb   | See the MariaDB Knowledgebase at https://mariadb.com/kb
webtrees-mariadb   |
webtrees-mariadb   | Please report any problems at https://mariadb.org/jira
webtrees-mariadb   |
webtrees-mariadb   | The latest information about MariaDB is available at https://mariadb.org/.
webtrees-mariadb   |
webtrees-mariadb   | Consider joining MariaDB's strong and vibrant community:
webtrees-mariadb   | https://mariadb.org/get-involved/
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-10 07:05:56+00:00 [Note] [Entrypoint]: Database files initialized
webtrees-mariadb   | 2022-05-10 07:05:56+00:00 [Note] [Entrypoint]: Starting temporary server
webtrees-mariadb   | 2022-05-10 07:05:56+00:00 [Note] [Entrypoint]: Waiting for server startup
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] mariadbd (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 98 ...
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Number of transaction pools: 1
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Using Linux native AIO
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Completed initialization of buffer pool
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: 128 rollback segments are active.
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
webtrees-mariadb   | 2022-05-10  7:05:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Note] InnoDB: 10.7.3 started; log sequence number 41361; transaction id 14
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Note] Plugin 'FEEDBACK' is disabled.
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Warning] 'user' entry 'root@226fd5d45356' ignored in --skip-name-resolve mode.
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Warning] 'proxies_priv' entry '@% root@226fd5d45356' ignored in --skip-name-resolve mode.
webtrees-mariadb   | 2022-05-10  7:05:57 0 [Note] mariadbd: ready for connections.
webtrees-mariadb   | Version: '10.7.3-MariaDB-1:10.7.3+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
webtrees-mariadb   | 2022-05-10 07:05:57+00:00 [Note] [Entrypoint]: Temporary server started.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
webtrees-mariadb   | 2022-05-10 07:05:59+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
webtrees-mariadb   | 2022-05-10 07:05:59+00:00 [Note] [Entrypoint]: Creating database webtrees
webtrees-mariadb   | 2022-05-10 07:05:59+00:00 [Note] [Entrypoint]: Creating user webtrees
webtrees-mariadb   | 2022-05-10 07:05:59+00:00 [Note] [Entrypoint]: Giving user webtrees access to schema webtrees
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-10 07:05:59+00:00 [Note] [Entrypoint]: Stopping temporary server
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: FTS optimize thread exiting.
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: Starting shutdown...
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: Buffer pool(s) dump completed at 220510  7:05:59
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] InnoDB: Shutdown completed; log sequence number 42335; transaction id 15
webtrees-mariadb   | 2022-05-10  7:05:59 0 [Note] mariadbd: Shutdown complete
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-10 07:06:00+00:00 [Note] [Entrypoint]: Temporary server stopped
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-10 07:06:00+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] mariadbd (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 1 ...
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Number of transaction pools: 1
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Using Linux native AIO
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Completed initialization of buffer pool
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: 128 rollback segments are active.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: 10.7.3 started; log sequence number 42335; transaction id 14
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] Plugin 'FEEDBACK' is disabled.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] InnoDB: Buffer pool(s) load completed at 220510  7:06:00
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] Server socket created on IP: '0.0.0.0'.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] Server socket created on IP: '::'.
webtrees-mariadb   | 2022-05-10  7:06:00 0 [Note] mariadbd: ready for connections.
webtrees-mariadb   | Version: '10.7.3-MariaDB-1:10.7.3+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58582 Accepted
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58582 [403]: GET /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58582 Closing
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58586 Accepted
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58586 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Tue May 10 07:08:33 2022] [::ffff:172.20.0.2]:58586 Closing
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58588 Accepted
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58588 [302]: POST /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58588 Closing
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58590 Accepted
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58590 [200]: GET /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58590 Closing
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58594 Accepted
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58594 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Tue May 10 07:08:38 2022] [::ffff:172.20.0.2]:58594 Closing
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58598 Accepted
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58598 [200]: GET /?server=webtrees-mariadb&username=webtrees&db=webtrees
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58598 Closing
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58602 Accepted
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58602 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Tue May 10 07:08:41 2022] [::ffff:172.20.0.2]:58602 Closing

Capture d’écran 2022-05-10 à 09 08 50

Maybe I forgot a step ?

from webtrees.

H2CK avatar H2CK commented on July 4, 2024

You didn't do anything wrong. From the logs it seems that the added static delay of 30 seconds is not sufficient for your database to fully start up.

I will have to modify the routine to check periodically if the database is already up an running.

I will inform you when the implementation is changed.

from webtrees.

H2CK avatar H2CK commented on July 4, 2024

With commit e822637 now a dynamic delay is added before writing to the database. In a loop the readiness of the database is checked and only if it is available the data is written.
It should be soon available in the latest docker image for version 2.1.x
Please try if this solves the problem on your side.

from webtrees.

loranger avatar loranger commented on July 4, 2024

Hi,

Thanks for your support.
I did prune everything and get the lateste version, but I'm afraid it does not work

logs
❯ docker-compose pull
[+] Running 2/2
(...)
[+] Running 24/24                                                          2.2s
 ⠿ mariadb Pulled                                                          2.2s
 ⠿ webtrees Pulled                                                        13.2s
   ⠿ d4ba87bb7858 Already exists                                           0.0s
   ⠿ 95dcbc4018c6 Pull complete                                            1.0s
   ⠿ f48d8c50b3d0 Pull complete                                            9.0s
   ⠿ 0d0d915d8ce1 Pull complete                                            9.0s
   ⠿ e8813ef483e7 Pull complete                                            9.1s
   ⠿ 22dcfb1bb616 Pull complete                                            9.1s
   ⠿ c8dabb2a5d71 Pull complete                                            9.1s
   ⠿ 1035038ea35c Pull complete                                            9.2s
   ⠿ b14b922a6773 Pull complete                                            9.2s
   ⠿ 247f03f03c35 Pull complete                                            9.3s
   ⠿ 31d8ff8a6211 Pull complete                                            9.3s
   ⠿ ae2fd05f2196 Pull complete                                            9.4s
   ⠿ 323f3fb0f511 Pull complete                                            9.4s
   ⠿ f456908c63ba Pull complete                                            9.4s
   ⠿ defcdaf55c87 Pull complete                                            9.5s
   ⠿ c1b8e18ec37b Pull complete                                            9.5s
   ⠿ ecf8ff44adf8 Pull complete                                            9.6s
   ⠿ a5ac55630cb5 Pull complete                                            9.6s
   ⠿ ff6d2bdd914f Pull complete                                            9.7s
   ⠿ 4b05e241896d Pull complete                                            9.7s
   ⠿ 40e48e28d7ac Pull complete                                            9.7s
   ⠿ 7891fe602bb7 Pull complete                                            9.8s

~/Developer/projects/webtrees 14s
❯ docker-compose --profile adminer up
[+] Running 3/3
 ⠿ Container webtrees-mariadb   Created                                    0.1s
 ⠿ Container webtrees-adminer   Created                                    0.1s
 ⠿ Container webtrees-webtrees  Created                                    0.0s
Attaching to webtrees-adminer, webtrees-mariadb, webtrees-webtrees
webtrees-mariadb   | 2022-05-13 08:07:45+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.3+maria~focal started.
webtrees-adminer   | [Fri May 13 08:07:45 2022] PHP 7.4.28 Development Server (http://[::]:8080) started
webtrees-mariadb   | 2022-05-13 08:07:45+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
webtrees-mariadb   | 2022-05-13 08:07:45+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.3+maria~focal started.
webtrees-webtrees  | Site webtrees_insecure already disabled
webtrees-webtrees  | Site webtrees already enabled
webtrees-webtrees  | PRETTYURLS not explicitly activated. Nothing to do.
webtrees-webtrees  | Set base_url in /var/www/html/data/config.ini.php
webtrees-webtrees  | ERROR: Configuration file /var/www/html/data/config.ini.php to set base_url not found.
webtrees-mariadb   | 2022-05-13 08:07:45+00:00 [Note] [Entrypoint]: Initializing database files
webtrees-webtrees  | 2022-05-13 08:07:46,021 WARN No file matches via include "/etc/supervisor/conf.d/*.conf"
webtrees-webtrees  | 2022-05-13 08:07:46,021 INFO Set uid to user 0 succeeded
webtrees-webtrees  | 2022-05-13 08:07:46,023 INFO RPC interface 'supervisor' initialized
webtrees-webtrees  | 2022-05-13 08:07:46,023 CRIT Server 'unix_http_server' running without any HTTP authentication checking
webtrees-webtrees  | 2022-05-13 08:07:46,023 INFO supervisord started with pid 30
webtrees-webtrees  | 2022-05-13 08:07:47,026 INFO spawned: 'crond' with pid 32
webtrees-webtrees  | 2022-05-13 08:07:47,027 INFO spawned: 'apache2' with pid 33
webtrees-webtrees  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.20.0.6. Set the 'ServerName' directive globally to suppress this message
webtrees-webtrees  | 2022-05-13 08:07:48,053 INFO success: crond entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
webtrees-webtrees  | 2022-05-13 08:07:48,053 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
webtrees-mariadb   | 2022-05-13  8:07:49 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   |
webtrees-mariadb   |
webtrees-mariadb   | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
webtrees-mariadb   | To do so, start the server, then issue the following command:
webtrees-mariadb   |
webtrees-mariadb   | '/usr/bin/mysql_secure_installation'
webtrees-mariadb   |
webtrees-mariadb   | which will also give you the option of removing the test
webtrees-mariadb   | databases and anonymous user created by default.  This is
webtrees-mariadb   | strongly recommended for production servers.
webtrees-mariadb   |
webtrees-mariadb   | See the MariaDB Knowledgebase at https://mariadb.com/kb
webtrees-mariadb   |
webtrees-mariadb   | Please report any problems at https://mariadb.org/jira
webtrees-mariadb   |
webtrees-mariadb   | The latest information about MariaDB is available at https://mariadb.org/.
webtrees-mariadb   |
webtrees-mariadb   | Consider joining MariaDB's strong and vibrant community:
webtrees-mariadb   | https://mariadb.org/get-involved/
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-13 08:07:50+00:00 [Note] [Entrypoint]: Database files initialized
webtrees-mariadb   | 2022-05-13 08:07:50+00:00 [Note] [Entrypoint]: Starting temporary server
webtrees-mariadb   | 2022-05-13 08:07:50+00:00 [Note] [Entrypoint]: Waiting for server startup
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] mariadbd (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 96 ...
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Number of transaction pools: 1
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Using Linux native AIO
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Completed initialization of buffer pool
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: 128 rollback segments are active.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] InnoDB: 10.7.3 started; log sequence number 41361; transaction id 14
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] Plugin 'FEEDBACK' is disabled.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Warning] 'user' entry 'root@0a3510bcb48b' ignored in --skip-name-resolve mode.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Warning] 'proxies_priv' entry '@% root@0a3510bcb48b' ignored in --skip-name-resolve mode.
webtrees-mariadb   | 2022-05-13  8:07:50 0 [Note] mariadbd: ready for connections.
webtrees-mariadb   | Version: '10.7.3-MariaDB-1:10.7.3+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
webtrees-mariadb   | 2022-05-13 08:07:51+00:00 [Note] [Entrypoint]: Temporary server started.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
webtrees-mariadb   | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
webtrees-mariadb   | 2022-05-13 08:07:52+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
webtrees-mariadb   | 2022-05-13 08:07:52+00:00 [Note] [Entrypoint]: Creating database webtrees
webtrees-mariadb   | 2022-05-13 08:07:52+00:00 [Note] [Entrypoint]: Creating user webtrees
webtrees-mariadb   | 2022-05-13 08:07:52+00:00 [Note] [Entrypoint]: Giving user webtrees access to schema webtrees
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-13 08:07:52+00:00 [Note] [Entrypoint]: Stopping temporary server
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: FTS optimize thread exiting.
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: Starting shutdown...
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: Buffer pool(s) dump completed at 220513  8:07:52
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] InnoDB: Shutdown completed; log sequence number 42335; transaction id 15
webtrees-mariadb   | 2022-05-13  8:07:52 0 [Note] mariadbd: Shutdown complete
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-13 08:07:53+00:00 [Note] [Entrypoint]: Temporary server stopped
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-13 08:07:53+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
webtrees-mariadb   |
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] mariadbd (server 10.7.3-MariaDB-1:10.7.3+maria~focal) starting as process 1 ...
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Number of transaction pools: 1
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Using Linux native AIO
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Completed initialization of buffer pool
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: 128 rollback segments are active.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: 10.7.3 started; log sequence number 42335; transaction id 14
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] Plugin 'FEEDBACK' is disabled.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] InnoDB: Buffer pool(s) load completed at 220513  8:07:53
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] Server socket created on IP: '0.0.0.0'.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] Server socket created on IP: '::'.
webtrees-mariadb   | 2022-05-13  8:07:53 0 [Note] mariadbd: ready for connections.
webtrees-mariadb   | Version: '10.7.3-MariaDB-1:10.7.3+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
webtrees-adminer   | [Fri May 13 08:10:58 2022] [::ffff:172.20.0.3]:56368 Accepted
webtrees-adminer   | [Fri May 13 08:10:58 2022] [::ffff:172.20.0.3]:56368 [403]: GET /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Fri May 13 08:10:58 2022] [::ffff:172.20.0.3]:56368 Closing
webtrees-adminer   | [Fri May 13 08:10:58 2022] [::ffff:172.20.0.3]:56372 Accepted
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56372 [200]: GET /?file=default.css&version=4.8.1
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56372 Closing
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56378 Accepted
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56380 Accepted
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56378 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56380 [200]: GET /?file=functions.js&version=4.8.1
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56380 Closing
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56378 Closing
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56382 Accepted
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56382 [200]: POST /?server=webtrees-mariadb&username=webtrees&script=version
webtrees-adminer   | [Fri May 13 08:10:59 2022] [::ffff:172.20.0.3]:56382 Closing
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56390 Accepted
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56390 [302]: POST /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56390 Closing
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56392 Accepted
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56392 [200]: GET /?server=webtrees-mariadb&username=webtrees
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56392 Closing
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56396 Accepted
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56398 Accepted
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56398 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56396 [200]: GET /?file=jush.js&version=4.8.1
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56396 Closing
webtrees-adminer   | [Fri May 13 08:11:10 2022] [::ffff:172.20.0.3]:56398 Closing
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56400 Accepted
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56400 [200]: GET /?server=webtrees-mariadb&username=webtrees&db=webtrees
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56400 Closing
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56404 Accepted
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56404 [200]: GET /adminer.css?v=1882297936
webtrees-adminer   | [Fri May 13 08:11:13 2022] [::ffff:172.20.0.3]:56404 Closing

Capture d’écran 2022-05-13 à 10 12 16

Please don't be offended, but I think I'm going to use this docker image instead which seems to work out of the box…

from webtrees.

H2CK avatar H2CK commented on July 4, 2024

In the log file it is possible to find the entry:
ERROR: Configuration file /var/www/html/data/config.ini.php to set base_url not found.
This is caused by the situation that there is no environment variable DB_PASSWORD set.
If this variable is not set the database initialization is not started and even the config.ini.php is not generated.

But anyhow please feel free to used whatever webtrees docker image you want.

from webtrees.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.