search

linuxserver / docker-piwigo

GNU General Public License v3.0
132 stars 27 forks source link

Cannot connect to server #31

Closed mzzntn closed 4 years ago

mzzntn commented 4 years ago

linuxserver.io

If you are new to Docker or this application our issue tracker is ONLY used for reporting bugs or requesting features. Please use our discord server for general support.

Expected Behavior

Continue the installation process

Current Behavior

Error message: Cannot connect to server

Environment

OS: Elementay OS
CPU architecture: x86_64
How docker service was installed: Snap

Command used to create docker container (run/create/compose/screenshot)

version: "2" services: MySQL:
image: mysql:latest restart: always container_name: piwi_MySQL environment: MYSQL_ROOT_PASSWORD: test MYSQL_DATABASE: test MYSQL_USER: test MYSQL_PASSWORD: test volumes:

Docker logs

mazza@MacBookPro:~/Documents/Docker$ sudo docker-compose up
WARNING: Found orphan containers (piwi_db) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
piwigo is up-to-date
Creating piwi_MySQL ... done
Attaching to piwigo, piwi_MySQL
piwi_MySQL | 2020-02-26 09:33:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.19-1debian9 started.
piwigo    | [s6-init] making user provided files available at /var/run/s6/etc...exited 0.
piwigo    | [s6-init] ensuring user provided files have correct perms...exited 0.
piwigo    | [fix-attrs.d] applying ownership & permissions fixes...
piwigo    | [fix-attrs.d] done.
piwigo    | [cont-init.d] executing container initialization scripts...
piwigo    | [cont-init.d] 01-envfile: executing... 
piwigo    | [cont-init.d] 01-envfile: exited 0.
piwigo    | [cont-init.d] 10-adduser: executing... 
piwigo    | 
piwigo    | -------------------------------------
piwigo    |           _         ()
piwigo    |          | |  ___   _    __
piwigo    |          | | / __| | |  /  \ 
piwigo    |          | | \__ \ | | | () |
piwigo    |          |_| |___/ |_|  \__/
piwigo    | 
piwigo    | 
piwigo    | Brought to you by linuxserver.io
piwigo    | We gratefully accept donations at:
piwigo    | https://www.linuxserver.io/donate/
piwigo    | -------------------------------------
piwigo    | GID/UID
piwigo    | -------------------------------------
piwigo    | 
piwigo    | User uid:    1000
piwigo    | User gid:    1000
piwigo    | -------------------------------------
piwigo    | 
piwigo    | [cont-init.d] 10-adduser: exited 0.
piwigo    | [cont-init.d] 20-config: executing... 
piwigo    | [cont-init.d] 20-config: exited 0.
piwigo    | [cont-init.d] 30-keygen: executing... 
piwigo    | using keys found in /config/keys
piwigo    | [cont-init.d] 30-keygen: exited 0.
piwigo    | [cont-init.d] 40-install: executing... 
piwigo    | [cont-init.d] 40-install: exited 0.
piwigo    | [cont-init.d] 99-custom-files: executing... 
piwigo    | [custom-init] no custom files found exiting...
piwigo    | [cont-init.d] 99-custom-files: exited 0.
piwigo    | [cont-init.d] done.
piwigo    | [services.d] starting services
piwigo    | [services.d] done.
piwi_MySQL | 2020-02-26 09:33:25+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
piwi_MySQL | 2020-02-26 09:33:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.19-1debian9 started.
piwi_MySQL | 2020-02-26 09:33:25+00:00 [Note] [Entrypoint]: Initializing database files
piwi_MySQL | 2020-02-26T09:33:25.826498Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
piwi_MySQL | 2020-02-26T09:33:25.826505Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
piwi_MySQL | 2020-02-26T09:33:25.826808Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
piwi_MySQL | 2020-02-26T09:33:25.826905Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.19) initializing of server in progress as process 46
piwi_MySQL | 2020-02-26T09:33:28.191767Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
piwi_MySQL | 2020-02-26 09:33:31+00:00 [Note] [Entrypoint]: Database files initialized
piwi_MySQL | 2020-02-26 09:33:31+00:00 [Note] [Entrypoint]: Starting temporary server
piwi_MySQL | 2020-02-26T09:33:31.643138Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
piwi_MySQL | 2020-02-26T09:33:31.643144Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
piwi_MySQL | 2020-02-26T09:33:31.864660Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
piwi_MySQL | 2020-02-26T09:33:31.864761Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 96
piwi_MySQL | 2020-02-26T09:33:32.353207Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
piwi_MySQL | 2020-02-26T09:33:32.356940Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
piwi_MySQL | 2020-02-26T09:33:32.378935Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.19'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
piwi_MySQL | 2020-02-26 09:33:32+00:00 [Note] [Entrypoint]: Temporary server started.
piwi_MySQL | 2020-02-26T09:33:32.472006Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
piwi_MySQL | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
piwi_MySQL | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
piwi_MySQL | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
piwi_MySQL | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
piwi_MySQL | 2020-02-26 09:33:35+00:00 [Note] [Entrypoint]: Creating database test
piwi_MySQL | 2020-02-26 09:33:35+00:00 [Note] [Entrypoint]: Creating user test
piwi_MySQL | 2020-02-26 09:33:35+00:00 [Note] [Entrypoint]: Giving user test access to schema test
piwi_MySQL | 
piwi_MySQL | 2020-02-26 09:33:35+00:00 [Note] [Entrypoint]: Stopping temporary server
piwi_MySQL | 2020-02-26T09:33:35.438958Z 14 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.19).
piwi_MySQL | 2020-02-26T09:33:36.549353Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.
piwi_MySQL | 2020-02-26 09:33:37+00:00 [Note] [Entrypoint]: Temporary server stopped
piwi_MySQL | 
piwi_MySQL | 2020-02-26 09:33:37+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
piwi_MySQL | 
piwi_MySQL | 2020-02-26T09:33:37.460242Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
piwi_MySQL | 2020-02-26T09:33:37.460254Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
piwi_MySQL | 2020-02-26T09:33:37.682410Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
piwi_MySQL | 2020-02-26T09:33:37.682510Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 1
piwi_MySQL | 2020-02-26T09:33:38.107549Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
piwi_MySQL | 2020-02-26T09:33:38.111037Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
piwi_MySQL | 2020-02-26T09:33:38.131422Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.19'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
piwi_MySQL | 2020-02-26T09:33:38.267637Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
j0nnymoe commented 4 years ago

Reinstall docker using the official apt repo rather than using snap and try again.

mzzntn commented 4 years ago

Same issue, i'm new to docker and i think i've made some errors in the docker-compose.yml the idea was to start the database and piwigo in the same time and be able to connect them toghether

j0nnymoe commented 4 years ago

To configure piwigo, once the container has started, you need to browse to http://host.ip.address.here:80 then you configure the database information there.

mzzntn commented 4 years ago

Solved thanks