skip to Main Content

I’m trying to program a simple python app (following this tutorial) and I want to use a MySQL database created with docker but I’m getting some problems.

There is my docker-compose.yml:

version: '3.7'
services:
  backend:
    build:
      context: .
      dockerfile: Dockerfile
    command: 'python manage.py runserver 0.0.0.0:8000'
    ports:
      - '8000:8000'
    volumes:
      - .:/app
    depends_on:
      - db
  db:
    image: mysql:5.7.22
    restart: always
    environment:
      MYSQL_DATABASE: admin
      MYSQL_USER: root
      MYSQL_PASSWORD: root
      MYSQL_ROOT_PASSWORD: root
    volumes:
      - .dbdata:/var/lib/mysql
    ports:
      - '33077:3306'

I can run the docker-compose up and it looks good. docker-compose ps output:

     Name                    Command               State                     Ports                   
-----------------------------------------------------------------------------------------------------
admin_backend_1   python manage.py runserver ...   Up      0.0.0.0:8000->8000/tcp,:::8000->8000/tcp  
admin_db_1        docker-entrypoint.sh mysqld      Up      0.0.0.0:33077->3306/tcp,:::33077->3306/tcp

Then, I’m trying to connect with user:root and password:root at localhost:33077 and I receive this error. Could you give me some help?

When I execute docker-compose up I get this:

Starting admin_db_1 ... done
Starting admin_backend_1 ... done
Attaching to admin_db_1, admin_backend_1
db_1       | 2022-03-02T12:26:20.204261Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1       | 2022-03-02T12:26:20.205273Z 0 [Note] mysqld (mysqld 5.7.22) starting as process 1 ...
db_1       | 2022-03-02T12:26:20.207089Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1       | 2022-03-02T12:26:20.207104Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1       | 2022-03-02T12:26:20.207105Z 0 [Note] InnoDB: Uses event mutexes
db_1       | 2022-03-02T12:26:20.207107Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1       | 2022-03-02T12:26:20.207108Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
db_1       | 2022-03-02T12:26:20.207109Z 0 [Note] InnoDB: Using Linux native AIO
db_1       | 2022-03-02T12:26:20.207250Z 0 [Note] InnoDB: Number of pools: 1
db_1       | 2022-03-02T12:26:20.207316Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1       | 2022-03-02T12:26:20.208157Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1       | 2022-03-02T12:26:20.212058Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1       | 2022-03-02T12:26:20.213177Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1       | 2022-03-02T12:26:20.224331Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1       | 2022-03-02T12:26:20.232279Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1       | 2022-03-02T12:26:20.232321Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1       | 2022-03-02T12:26:20.264177Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1       | 2022-03-02T12:26:20.264599Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1       | 2022-03-02T12:26:20.264604Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1       | 2022-03-02T12:26:20.264790Z 0 [Note] InnoDB: Waiting for purge to start
db_1       | 2022-03-02T12:26:20.315127Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 12359913
db_1       | 2022-03-02T12:26:20.315447Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1       | 2022-03-02T12:26:20.315686Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1       | 2022-03-02T12:26:20.317675Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220302 12:26:20
db_1       | 2022-03-02T12:26:20.322304Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
db_1       | 2022-03-02T12:26:20.322594Z 0 [Warning] CA certificate ca.pem is self signed.
db_1       | 2022-03-02T12:26:20.326271Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
db_1       | 2022-03-02T12:26:20.326318Z 0 [Note] IPv6 is available.
db_1       | 2022-03-02T12:26:20.326330Z 0 [Note]   - '::' resolves to '::';
db_1       | 2022-03-02T12:26:20.326346Z 0 [Note] Server socket created on IP: '::'.
db_1       | 2022-03-02T12:26:20.331099Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
db_1       | 2022-03-02T12:26:20.332360Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332405Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332422Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332457Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332466Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332482Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.335750Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.335772Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.342036Z 0 [Note] Event Scheduler: Loaded 0 events
db_1       | 2022-03-02T12:26:20.342204Z 0 [Note] mysqld: ready for connections.
db_1       | Version: '5.7.22'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
backend_1  | Watching for file changes with StatReloader
backend_1  | Performing system checks...
backend_1  | 
backend_1  | System check identified no issues (0 silenced).
backend_1  | 
backend_1  | You have 18 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): admin, auth, contenttypes, sessions.
backend_1  | Run 'python manage.py migrate' to apply them.
backend_1  | March 02, 2022 - 12:26:20
backend_1  | Django version 4.0.2, using settings 'admin.settings'
backend_1  | Starting development server at http://0.0.0.0:8000/
backend_1  | Quit the server with CONTROL-C.

2

Answers


  1. For me it’s much better to add the creation of a virtual network to your Docker-compose.
    Maybe that can solve your problem.
    like this
    enter image description here

    Bye

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search