群晖系统是6.1.7版,docker是20.10.3版,安装了MariaDB10套件。
开始用官网的docker-composecan.yml安装,4个容器可以装好,但mysql启动不了,手动启动一会就关闭。
后面在.yml文件中删除mysql部分,将seatable的数据库DB_HOST设为群晖IP,重新安装。到运行创建管理员命令时看到有提示数据库错误。一顿查找,发现MariaDB的端口居然是3307,然后手动修改conf里各配置文件的数据库端口(默认是3306),手动在MariaDB中建立了’dtable_db’、seafile_db、ccnet_db等几个空表。
重新运行创建管理员命令,好像没有提示数据库问题了,但是还是弹出一堆错误提示,求助大神帮看看是什么问题,然后解决,谢谢。
root@DS:/volume3/NetBackup/seatable# docker-compose up -d
Creating network "seatable_seatable-net" with the default driver
Creating seatable-redis ... done
Creating seatable-memcached ... done
Creating seatable ... done
root@DS:/volume3/NetBackup/seatable# docker exec -d seatable /shared/seatable/sc ripts/seatable.sh start
root@DS:/volume3/NetBackup/seatable# docker exec -it seatable /shared/seatable/s cripts/seatable.sh superuser
E-mail address: x@c.cn
Password:
Password (again):
Traceback (most recent call last):
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 219, in ensure_connection
self.connect()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 200, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/mysql/base.py", line 234, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/__init __.py", line 123, in Connect
return Connection(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connec tions.py", line 185, in __init__
super().__init__(*args, **kwargs2)
MySQLdb.OperationalError: (1045, "Access denied for user 'root'@'172.27.0.4' (us ing password: YES)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/ma nagement/__init__.py", line 419, in execute_from_command_line
utility.execute()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/ma nagement/__init__.py", line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/ma nagement/base.py", line 354, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/ma nagement/base.py", line 398, in execute
output = self.handle(*args, **options)
File "/opt/seatable/seatable-server-4.2.0/dtable-web/seahub/base/management/co mmands/createsuperuser.py", line 150, in handle
User.objects.create_superuser(email, password)
File "/opt/seatable/seatable-server-4.2.0/dtable-web/seahub/base/accounts.py", line 170, in create_superuser
u = self.create_user(email, password, is_staff=True, is_active=True)
File "/opt/seatable/seatable-server-4.2.0/dtable-web/seahub/base/accounts.py", line 101, in create_user
Profile.objects.add_or_update(username=virtual_id, contact_email=email, need _show_video=True)
File "/opt/seatable/seatable-server-4.2.0/dtable-web/seahub/profile/models.py" , line 29, in add_or_update
profile = self.get(user=username)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/query.py", line 431, in get
num = len(clone)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/query.py", line 262, in __len__
self._fetch_all()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/query.py", line 1324, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/query.py", line 51, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size= self.chunk_size)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/mode ls/sql/compiler.py", line 1173, in execute_sql
cursor = self.connection.cursor()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 259, in cursor
return self._cursor()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 235, in _cursor
self.ensure_connection()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 219, in ensure_connection
self.connect()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/util s.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 219, in ensure_connection
self.connect()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/base/base.py", line 200, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/utils/a syncio.py", line 33, in inner
return func(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/back ends/mysql/base.py", line 234, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/__init __.py", line 123, in Connect
return Connection(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connec tions.py", line 185, in __init__
super().__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'172.27. 0.4' (using password: YES)")
root@DS:/volume3/NetBackup/seatable#