连不上mysql数据库

2023-09-04 12:57:48 [db_port ERROR] (2002, “Can’t connect to MySQL server on ‘mysql’ (115)”)
2023-09-04 12:57:48 Collect static files
ALLOWED_HOSTS:

  • localhost
  • core:8080
  • 127.0.0.1
  • 127.0.0.1:8080
  • 127.0.0.1:80
  • localhost:8080
  • localhost:80
  • core:8080
  • core:80
    ALLOWED_HOSTS:
  • localhost
  • core:8080
  • 127.0.0.1
  • 127.0.0.1:8080
  • 127.0.0.1:80
  • localhost:8080
  • localhost:80
  • core:8080
  • core:80
    2023-09-04 12:57:48 Collect static files done
    2023-09-04 12:57:48 Check database structure change …
    2023-09-04 12:57:48 Migrate model change to database …
    2023-09-04 12:59:56 Perform migrate failed, exit
    Traceback (most recent call last):
    File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 282, in ensure_connection
    self.connect()
    File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
    return func(*args, **kwargs)
    ^^^^^^^^^^^^^^^^^^^^^
    File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 263, in connect
    self.connection = self.get_new_connection(conn_params)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
    return func(*args, **kwargs)
    ^^^^^^^^^^^^^^^^^^^^^
    File “/usr/local/lib/python3.11/site-packages/django/db/backends/mysql/base.py”, line 247, in get_new_connection
    connection = Database.connect(**conn_params)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File “/usr/local/lib/python3.11/site-packages/MySQLdb/init.py”, line 121, in Connect
    return Connection(*args, **kwargs)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^
    File “/usr/local/lib/python3.11/site-packages/MySQLdb/connections.py”, line 193, in init
    super().init(*args, **kwargs2)
    MySQLdb.OperationalError: (2002, “Can’t connect to MySQL server on ‘mysql’ (115)”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “/opt/jumpserver/./jms”, line 88, in perform_db_migrate
management.call_command(‘migrate’)
File “/usr/local/lib/python3.11/site-packages/django/core/management/init.py”, line 198, in call_command
return command.execute(*args, **defaults)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/core/management/base.py”, line 448, in execute
output = self.handle(*args, **options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/core/management/base.py”, line 96, in wrapped
res = handle_func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/core/management/commands/migrate.py”, line 114, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/migrations/executor.py”, line 18, in init
self.loader = MigrationLoader(self.connection)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 58, in init
self.build_graph()
File “/usr/local/lib/python3.11/site-packages/django/db/migrations/loader.py”, line 235, in build_graph
self.applied_migrations = recorder.applied_migrations()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 81, in applied_migrations
if self.has_table():
^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/migrations/recorder.py”, line 57, in has_table
with self.connection.cursor() as cursor:
^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 323, in cursor
return self._cursor()
^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 299, in _cursor
self.ensure_connection()
File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 281, in ensure_connection
with self.wrap_database_errors:
File “/usr/local/lib/python3.11/site-packages/django/db/utils.py”, line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 282, in ensure_connection
self.connect()
File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/backends/base/base.py”, line 263, in connect
self.connection = self.get_new_connection(conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/utils/asyncio.py”, line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/django/db/backends/mysql/base.py”, line 247, in get_new_connection
connection = Database.connect(**conn_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/MySQLdb/init.py”, line 121, in Connect
return Connection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/site-packages/MySQLdb/connections.py”, line 193, in init
super().init(*args, **kwargs2)
django.db.utils.OperationalError: (2002, “Can’t connect to MySQL server on ‘mysql’ (115)”)
[ERROR] 表结构变更失败!

发帖前,看看发帖提醒啊,你的堡垒机版本、部署方式都没有给出来

离线安装,jumpserver的版本v3.6.2,容器部署,到初始化那一步报错:Can’t connect to MySQL server on ‘mysql’ :roll_eyes:

内置的mysql容器连不上咯,systemctl restart docker,再试试

如果说有容器已经在跑了,并且端口也是一样,这样的话会不会有影响呢

哪个端口一样了?麻烦截图看看

mysql的容器服务3306端口有在跑,主机映射3306这个容器服务;jms_mysql的端口也是3306,这样的话有两个3306端口在跑,初始化时一直拉取不了jms_mysql的容器连接

我们的jms_mysql是内置的,一般你不去映射出来,是不会影响其他端口的,网络上也是,jms_mysql只存在于jms_net的子网中。反而是你最后一句话,初始化在拉取的话,你安装包是不是有问题,缺少mysql镜像啊?

jumpserver/mariadb 10.6 有这个镜像,就是一直连不上,安装包官方下载看了没什么问题
image