راه‌اندازی دو یا چند پنل مرزبان روی یک سرور

[Artin70]

وقت بخیر
امکان راه‌اندازی دو یا چند پنل مرزبان روی یک سرور وجود داره؟ سعی کردم با ساختن دیرکتوری متفاوت و فایل داکر کامپوز و env متفاوت و /var/lib/marzban2/ و تغییر تمام موارد تو این فایل‌ها (از جمله نام دیتابیس از marzban به marzban2) این کار رو با docker-compose up --build
انجام بدم اما خطای تداخل پورت mysql می‌گیرم. زمانی هم که پنل اول رو غیرفعال می‌کنم این خطای mysql رو می‌گیرم:

/opt/marzban2# docker-compose up --build Recreating marzban2_mysql_1 ... done Recreating marzban2_marzban_1 ... done Recreating marzban2_phpmyadmin_1 ... done Attaching to marzban2_mysql_1, marzban2_marzban_1, marzban2_phpmyadmin_1 mysql_1 | 2024-05-28 21:41:30+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. phpmyadmin_1 | Setting apache port to 8011. phpmyadmin_1 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message phpmyadmin_1 | Syntax OK phpmyadmin_1 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message phpmyadmin_1 | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message phpmyadmin_1 | [Tue May 28 21:41:31.413371 2024] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.57 (Debian) PHP/8.2.8 configured -- resuming normal operations phpmyadmin_1 | [Tue May 28 21:41:31.415251 2024] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND' mysql_1 | 2024-05-28 21:41:31+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mysql_1 | 2024-05-28 21:41:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. mysql_1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' mysql_1 | 2024-05-28T21:41:31.678588Z 0 [System] [MY-015015] [Server] MySQL Server - start. mysql_1 | 2024-05-28T21:41:31.870200Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1 mysql_1 | 2024-05-28T21:41:31.875592Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. marzban_1 | Traceback (most recent call last): marzban_1 | File "/usr/local/bin/alembic", line 8, in <module> marzban_1 | sys.exit(main()) marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 590, in main marzban_1 | CommandLine(prog=prog).main(argv=argv) marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 584, in main marzban_1 | self.run_cmd(cfg, options) marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 561, in run_cmd marzban_1 | fn( marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 322, in upgrade marzban_1 | script.run_env() marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env marzban_1 | util.load_python_file(self.dir, "env.py") marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file marzban_1 | module = load_module_py(module_id, path) marzban_1 | File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py marzban_1 | spec.loader.exec_module(module) # type: ignore marzban_1 | File "<frozen importlib._bootstrap_external>", line 883, in exec_module marzban_1 | File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed marzban_1 | File "/code/app/db/migrations/env.py", line 8, in <module> marzban_1 | from app.db.base import Base marzban_1 | File "/code/./app/__init__.py", line 36, in <module> marzban_1 | from app import dashboard, telegram, views, jobs # noqa marzban_1 | File "/code/./app/telegram/__init__.py", line 31, in <module> marzban_1 | from .handlers.report import ( # noqa marzban_1 | File "/code/./app/telegram/handlers/report.py", line 7, in <module> marzban_1 | from app.telegram.utils.keyboard import BotKeyboard marzban_1 | File "/code/./app/telegram/utils/keyboard.py", line 7, in <module> marzban_1 | from app import xray marzban_1 | File "/code/./app/xray/__init__.py", line 7, in <module> marzban_1 | from app.xray import operations marzban_1 | File "/code/./app/xray/operations.py", line 7, in <module> marzban_1 | from app.db import GetDB, crud marzban_1 | File "/code/./app/db/__init__.py", line 4, in <module> marzban_1 | from .base import Base, SessionLocal, engine # noqa marzban_1 | File "/code/./app/db/base.py", line 14, in <module> marzban_1 | engine = create_engine( marzban_1 | File "<string>", line 2, in create_engine marzban_1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned marzban_1 | return fn(*args, **kwargs) marzban_1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 518, in create_engine marzban_1 | u = _url.make_url(url) marzban_1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 732, in make_url marzban_1 | return _parse_url(name_or_url) marzban_1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 793, in _parse_url marzban_1 | raise exc.ArgumentError( marzban_1 | sqlalchemy.exc.ArgumentError: Could not parse SQLAlchemy URL from string '"mysql+pymysql://root:DB_PASSWORD@127.0.0.1/marzban2"' mysql_1 | 2024-05-28T21:41:32.279264Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended."'

ممنون می‌شم راهنمایی کنید.

[Artin70]

فعلا با غیرفعال کردن پنل اول و انجام یه سری تغییرات مشکل mysql حل شد. الان زمان اجرا با docker-compose این خطا رو می‌گیرم (مسیر /var/lib/marzban2/xray-core/xray پنل دوم رو نمیشناسه.):

WARN[0000] /opt/marzban2/docker-compose.yml: `version` is obsolete
[+] Running 4/1
 ✔ Container marzban2-mysql-1                                       Created                                                            0.1s
 ! mysql Published ports are discarded when using host network mode                                                                    0.0s
 ✔ Container marzban2-phpmyadmin-1                                  Created                                                            0.0s
 ✔ Container marzban2-marzban-1                                     Created                                                            0.0s
Attaching to marzban-1, mysql-1, phpmyadmin-1
mysql-1       | 2024-05-29 13:36:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
phpmyadmin-1  | Setting apache port to 8011.
phpmyadmin-1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
phpmyadmin-1  | Syntax OK
phpmyadmin-1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
phpmyadmin-1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
phpmyadmin-1  | [Wed May 29 13:36:12.616243 2024] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.57 (Debian) PHP/8.2.8 configured -- resuming normal operations
phpmyadmin-1  | [Wed May 29 13:36:12.616768 2024] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
mysql-1       | 2024-05-29 13:36:12+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-1       | 2024-05-29 13:36:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql-1       | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
mysql-1       | 2024-05-29T13:36:12.901514Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql-1       | 2024-05-29T13:36:13.093788Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
mysql-1       | 2024-05-29T13:36:13.102934Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql-1       | 2024-05-29T13:36:13.479288Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
marzban-1     | Traceback (most recent call last):
marzban-1     |   File "/usr/local/bin/alembic", line 8, in <module>
marzban-1     |     sys.exit(main())
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 590, in main
marzban-1     |     CommandLine(prog=prog).main(argv=argv)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 584, in main
marzban-1     |     self.run_cmd(cfg, options)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 561, in run_cmd
marzban-1     |     fn(
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 322, in upgrade
marzban-1     |     script.run_env()
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env
marzban-1     |     util.load_python_file(self.dir, "env.py")
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
marzban-1     |     module = load_module_py(module_id, path)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
marzban-1     |     spec.loader.exec_module(module)  # type: ignore
marzban-1     |   File "<frozen importlib._bootstrap_external>", line 883, in exec_module
marzban-1     |   File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
marzban-1     |   File "/code/app/db/migrations/env.py", line 8, in <module>
marzban-1     |     from app.db.base import Base
marzban-1     |   File "/code/./app/__init__.py", line 36, in <module>
marzban-1     |     from app import dashboard, telegram, views, jobs  # noqa
marzban-1     |   File "/code/./app/telegram/__init__.py", line 31, in <module>
marzban-1     |     from .handlers.report import (  # noqa
marzban-1     |   File "/code/./app/telegram/handlers/report.py", line 7, in <module>
marzban-1     |     from app.telegram.utils.keyboard import BotKeyboard
marzban-1     |   File "/code/./app/telegram/utils/keyboard.py", line 7, in <module>
marzban-1     |     from app import xray
marzban-1     |   File "/code/./app/xray/__init__.py", line 18, in <module>
marzban-1     |     core = XRayCore(XRAY_EXECUTABLE_PATH, XRAY_ASSETS_PATH)
marzban-1     |   File "/code/./app/xray/core.py", line 20, in __init__
marzban-1     |     self.version = self.get_version()
marzban-1     |   File "/code/./app/xray/core.py", line 36, in get_version
marzban-1     |     output = subprocess.check_output(cmd, stderr=subprocess.STDOUT).decode('utf-8')
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 421, in check_output
marzban-1     |     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 503, in run
marzban-1     |     with Popen(*popenargs, **kwargs) as process:
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 971, in __init__
marzban-1     |     self._execute_child(args, executable, preexec_fn, close_fds,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 1863, in _execute_child
marzban-1     |     raise child_exception_type(errno_num, err_msg, err_filename)
marzban-1     | FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/marzban2/xray-core/xray'
mysql-1       | 2024-05-29T13:36:13.687797Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql-1       | 2024-05-29T13:36:13.688041Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql-1       | 2024-05-29T13:36:13.691791Z 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.
mysql-1       | 2024-05-29T13:36:13.717093Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.4.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
mysql-1       | 2024-05-29T13:36:13.971758Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
marzban-1     | Traceback (most recent call last):
marzban-1     |   File "/code/main.py", line 2, in <module>
marzban-1     |     from app import app
marzban-1     |   File "/code/app/__init__.py", line 36, in <module>
marzban-1     |     from app import dashboard, telegram, views, jobs  # noqa
marzban-1     |   File "/code/app/telegram/__init__.py", line 31, in <module>
marzban-1     |     from .handlers.report import (  # noqa
marzban-1     |   File "/code/app/telegram/handlers/report.py", line 7, in <module>
marzban-1     |     from app.telegram.utils.keyboard import BotKeyboard
marzban-1     |   File "/code/app/telegram/utils/keyboard.py", line 7, in <module>
marzban-1     |     from app import xray
marzban-1     |   File "/code/app/xray/__init__.py", line 18, in <module>
marzban-1     |     core = XRayCore(XRAY_EXECUTABLE_PATH, XRAY_ASSETS_PATH)
marzban-1     |   File "/code/app/xray/core.py", line 20, in __init__
marzban-1     |     self.version = self.get_version()
marzban-1     |   File "/code/app/xray/core.py", line 36, in get_version
marzban-1     |     output = subprocess.check_output(cmd, stderr=subprocess.STDOUT).decode('utf-8')
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 421, in check_output
marzban-1     |     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 503, in run
marzban-1     |     with Popen(*popenargs, **kwargs) as process:
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 971, in __init__
marzban-1     |     self._execute_child(args, executable, preexec_fn, close_fds,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 1863, in _execute_child
marzban-1     |     raise child_exception_type(errno_num, err_msg, err_filename)
marzban-1     | FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/marzban2/xray-core/xray'
marzban-1 exited with code 1
marzban-1     | Traceback (most recent call last):
marzban-1     |   File "/usr/local/bin/alembic", line 8, in <module>
marzban-1     |     sys.exit(main())
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 590, in main
marzban-1     |     CommandLine(prog=prog).main(argv=argv)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 584, in main
marzban-1     |     self.run_cmd(cfg, options)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 561, in run_cmd
marzban-1     |     fn(
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 322, in upgrade
marzban-1     |     script.run_env()
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env
marzban-1     |     util.load_python_file(self.dir, "env.py")
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
marzban-1     |     module = load_module_py(module_id, path)
marzban-1     |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
marzban-1     |     spec.loader.exec_module(module)  # type: ignore
marzban-1     |   File "<frozen importlib._bootstrap_external>", line 883, in exec_module
marzban-1     |   File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
marzban-1     |   File "/code/app/db/migrations/env.py", line 8, in <module>
marzban-1     |     from app.db.base import Base
marzban-1     |   File "/code/./app/__init__.py", line 36, in <module>
marzban-1     |     from app import dashboard, telegram, views, jobs  # noqa
marzban-1     |   File "/code/./app/telegram/__init__.py", line 31, in <module>
marzban-1     |     from .handlers.report import (  # noqa
marzban-1     |   File "/code/./app/telegram/handlers/report.py", line 7, in <module>
marzban-1     |     from app.telegram.utils.keyboard import BotKeyboard
marzban-1     |   File "/code/./app/telegram/utils/keyboard.py", line 7, in <module>
marzban-1     |     from app import xray
marzban-1     |   File "/code/./app/xray/__init__.py", line 18, in <module>
marzban-1     |     core = XRayCore(XRAY_EXECUTABLE_PATH, XRAY_ASSETS_PATH)
marzban-1     |   File "/code/./app/xray/core.py", line 20, in __init__
marzban-1     |     self.version = self.get_version()
marzban-1     |   File "/code/./app/xray/core.py", line 36, in get_version
marzban-1     |     output = subprocess.check_output(cmd, stderr=subprocess.STDOUT).decode('utf-8')
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 421, in check_output
marzban-1     |     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 503, in run
marzban-1     |     with Popen(*popenargs, **kwargs) as process:
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 971, in __init__
marzban-1     |     self._execute_child(args, executable, preexec_fn, close_fds,
marzban-1     |   File "/usr/local/lib/python3.10/subprocess.py", line 1863, in _execute_child
marzban-1     |     raise child_exception_type(errno_num, err_msg, err_filename)
marzban-1     | FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/marzban2/xray-core/xray
```'