Cannot create superuser on Mac

Hi,

I try to run seatable locally, but I can’t.
The first visible issue is I can’t create a superuser, but I suspect it’s wider than this…

Anyway, here is what I exactly did, step-by-step.

I’m running Docker version 20.10.13, build a224086 using MacOS 12.3.1 (M1).

/opt is not writable under macos.

mkdir /opt/seatable
mkdir: /opt/seatable: Permission denied

As I don’t want to run any docker container using root access, I tried this :

mkdir /private/tmp/seatable
cd /private/tmp/seatable
wget -O "docker-compose.yml" "https://manual.seatable.io/docker/Developer-Edition/docker-compose.yml"

I edited the docker-compose file, changed the MYSQL_ROOT_PASSWORD and the DB_ROOT_PASSWD, changed the SEATABLE_SERVER_HOSTNAME to seatable.docker (binded to 127.0.0.1 from /etc/hosts), replaced every /opt/seatable to /private/tmp/seatable, commented the 443 port bind and then ran docker-compose up

logs
[+] Running 5/4
 ⠿ Network seatable_seatable-net  Creat...                                 0.0s
 ⠿ Container seatable-redis       Created                                  0.2s
 ⠿ Container seatable-mysql       Created                                  0.2s
 ⠿ Container seatable-memcached   Create...                                0.2s
 ⠿ Container seatable             Created                                  0.0s
Attaching to seatable, seatable-memcached, seatable-mysql, seatable-redis
seatable-redis      | 1:C 07 Apr 2022 06:28:38.784 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
seatable-redis      | 1:C 07 Apr 2022 06:28:38.784 # Redis version=5.0.7, bits=64, commit=00000000, modified=0, pid=1, just started
seatable-redis      | 1:C 07 Apr 2022 06:28:38.784 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
seatable-redis      | 1:M 07 Apr 2022 06:28:38.785 * Running mode=standalone, port=6379.
seatable-redis      | 1:M 07 Apr 2022 06:28:38.785 # Server initialized
seatable-redis      | 1:M 07 Apr 2022 06:28:38.785 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
seatable-redis      | 1:M 07 Apr 2022 06:28:38.785 * Ready to accept connections
seatable-mysql      | 2022-04-07 06:28:38+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.15+maria~focal started.
seatable-mysql      | 2022-04-07 06:28:38+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
seatable-mysql      | 2022-04-07 06:28:38+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.15+maria~focal started.
seatable-mysql      | 2022-04-07 06:28:39+00:00 [Note] [Entrypoint]: Initializing database files
seatable            | *** Running /etc/my_init.d/01_init.sh...
seatable            | *** Booting runit daemon...
seatable            | *** Runit started as PID 65
seatable            | *** Running /templates/enterpoint.sh...
seatable            | 2022-04-07 06:28:39 Start init
seatable-mysql      |
seatable-mysql      |
seatable-mysql      | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
seatable-mysql      | To do so, start the server, then issue the following command:
seatable-mysql      |
seatable-mysql      | '/usr/bin/mysql_secure_installation'
seatable-mysql      |
seatable-mysql      | which will also give you the option of removing the test
seatable-mysql      | databases and anonymous user created by default.  This is
seatable-mysql      | strongly recommended for production servers.
seatable-mysql      |
seatable-mysql      | See the MariaDB Knowledgebase at https://mariadb.com/kb
seatable-mysql      |
seatable-mysql      | Please report any problems at https://mariadb.org/jira
seatable-mysql      |
seatable-mysql      | The latest information about MariaDB is available at https://mariadb.org/.
seatable-mysql      |
seatable-mysql      | Consider joining MariaDB's strong and vibrant community:
seatable-mysql      | https://mariadb.org/get-involved/
seatable-mysql      |
seatable-mysql      | 2022-04-07 06:28:42+00:00 [Note] [Entrypoint]: Database files initialized
seatable-mysql      | 2022-04-07 06:28:42+00:00 [Note] [Entrypoint]: Starting temporary server
seatable-mysql      | 2022-04-07 06:28:42+00:00 [Note] [Entrypoint]: Waiting for server startup
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] mysqld (mysqld 10.5.15-MariaDB-1:10.5.15+maria~focal) starting as process 100 ...
seatable-mysql      | 2022-04-07  6:28:42 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Uses event mutexes
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Number of pools: 1
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Using Linux native AIO
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Completed initialization of buffer pool
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: 128 rollback segments are active.
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
seatable-mysql      | 2022-04-07  6:28:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] InnoDB: 10.5.15 started; log sequence number 45106; transaction id 20
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] Plugin 'FEEDBACK' is disabled.
seatable-mysql      | 2022-04-07  6:28:43 0 [Warning] 'user' entry 'root@2c86c857505a' ignored in --skip-name-resolve mode.
seatable-mysql      | 2022-04-07  6:28:43 0 [Warning] 'proxies_priv' entry '@% root@2c86c857505a' ignored in --skip-name-resolve mode.
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] Reading of all Master_info entries succeeded
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] Added new Master_info '' to hash table
seatable-mysql      | 2022-04-07  6:28:43 0 [Note] mysqld: ready for connections.
seatable-mysql      | Version: '10.5.15-MariaDB-1:10.5.15+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
seatable-mysql      | 2022-04-07 06:28:43+00:00 [Note] [Entrypoint]: Temporary server started.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
seatable-mysql      | 2022-04-07 06:28:45+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
seatable-mysql      |
seatable-mysql      | 2022-04-07 06:28:45+00:00 [Note] [Entrypoint]: Stopping temporary server
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] Event Scheduler: Purging the queue. 0 events
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: FTS optimize thread exiting.
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: Starting shutdown...
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: Buffer pool(s) dump completed at 220407  6:28:45
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] InnoDB: Shutdown completed; log sequence number 45118; transaction id 21
seatable-mysql      | 2022-04-07  6:28:45 0 [Note] mysqld: Shutdown complete
seatable-mysql      |
seatable-mysql      | 2022-04-07 06:28:46+00:00 [Note] [Entrypoint]: Temporary server stopped
seatable-mysql      |
seatable-mysql      | 2022-04-07 06:28:46+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
seatable-mysql      |
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] mysqld (mysqld 10.5.15-MariaDB-1:10.5.15+maria~focal) starting as process 1 ...
seatable-mysql      | 2022-04-07  6:28:46 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Uses event mutexes
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Number of pools: 1
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Using Linux native AIO
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Completed initialization of buffer pool
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: 128 rollback segments are active.
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: 10.5.15 started; log sequence number 45118; transaction id 20
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] Plugin 'FEEDBACK' is disabled.
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] InnoDB: Buffer pool(s) load completed at 220407  6:28:46
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] Server socket created on IP: '::'.
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] Reading of all Master_info entries succeeded
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] Added new Master_info '' to hash table
seatable-mysql      | 2022-04-07  6:28:46 0 [Note] mysqld: ready for connections.
seatable-mysql      | Version: '10.5.15-MariaDB-1:10.5.15+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
seatable-mysql      | 2022-04-07  6:28:46 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'root' host: '172.23.0.5' (Got an error reading communication packets)
seatable            | 2022-04-07 06:28:50 Nginx ready
seatable            | 2022-04-07 06:28:50 This is a idle script (infinite loop) to keep container running.

As specified in the docs, I stopped the container and ran it again, in background

docker-compose up -d

Then I did start the server

docker exec -d seatable /shared/seatable/scripts/seatable.sh start

And tried to create the superuser

docker exec -it seatable /shared/seatable/scripts/seatable.sh superuser

But it failed :

Traceback (most recent call last):
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 85, in _get_transport
    transport = self._pool.get(False)
  File "/usr/lib/python3.7/queue.py", line 167, in get
    raise Empty
_queue.Empty

During handling of the above exception, another exception occurred:

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/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/__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/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/opt/seatable/seatable-server-2.8.0/dtable-web/seahub/base/management/commands/createsuperuser.py", line 88, in handle
    User.objects.get(email=default_username)
  File "/opt/seatable/seatable-server-2.8.0/dtable-web/seahub/base/accounts.py", line 185, in get
    emailuser = ccnet_threaded_rpc.get_emailuser(email)
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/client.py", line 125, in newfunc
    ret_str = self.call_remote_func_sync(fcall_str)
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 97, in call_remote_func_sync
    transport = self._get_transport()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 87, in _get_transport
    transport = self._create_transport()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 80, in _create_transport
    transport.connect()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 44, in connect
    self.pipe.connect(self.socket_path)
FileNotFoundError: [Errno 2] No such file or directory

What did I miss ?
Is there a workaround for this error ?
Thanks

Generally, there’s no official support for SeaTable on Docker on Mac. We have never tested it (and do not have any plans to do it.)

Specifically for your problem:

There’s your error.

Have you tried executing the bash shell interactively in the running container and entering the /shared/seatable/scripts/seatable.sh superuser command in that interactive shell?

It may not have that missing socket issue (which I don’t fully understand).

I just tried it from a Linux terminal and as that is within Docker, it may work on MacOS as well:

$ docker exec -it seatable /bin/bash
root@e0ac04acec71:/opt/seatable# /shared/seatable/scripts/seatable.sh superuser
E-mail address: ...

HTH

Thanks for your reply.

As you can see, I ran the docker-compose from scratch, and the file not found should be found, obviously

Thanks for you support,

I tried, but the error is the same

docker exec -it seatable bash
root@0c6af903bda4:/opt/seatable# /shared/seatable/scripts/seatable.sh superuser
Traceback (most recent call last):
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 85, in _get_transport
    transport = self._pool.get(False)
  File "/usr/lib/python3.7/queue.py", line 167, in get
    raise Empty
_queue.Empty

During handling of the above exception, another exception occurred:

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/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/__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/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/opt/seatable/seatable-server-2.8.0/dtable-web/seahub/base/management/commands/createsuperuser.py", line 88, in handle
    User.objects.get(email=default_username)
  File "/opt/seatable/seatable-server-2.8.0/dtable-web/seahub/base/accounts.py", line 185, in get
    emailuser = ccnet_threaded_rpc.get_emailuser(email)
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/client.py", line 125, in newfunc
    ret_str = self.call_remote_func_sync(fcall_str)
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 97, in call_remote_func_sync
    transport = self._get_transport()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 87, in _get_transport
    transport = self._create_transport()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 80, in _create_transport
    transport.connect()
  File "/opt/seatable/seatable-server-latest/seafile/lib/python3/site-packages/pysearpc/named_pipe.py", line 44, in connect
    self.pipe.connect(self.socket_path)
FileNotFoundError: [Errno 2] No such file or directory
root@0c6af903bda4:/opt/seatable#

I also tried to flush it all, remove images and folders, re-up everything, but it still fails

I also tried using an amd64, running debian 11

mkdir seatable
cd seatable
wget -O "docker-compose.yml" "https://manual.seatable.io/docker/Developer-Edition/docker-compose.yml"

I edited the docker-compose file, changed the DB_ROOT_PASSWD and the MYSQL_ROOT_PASSWORD, commented the 443 port, remap the host port 80 to 8089 (as I have other services running), changed the SEATABLE_SERVER_HOSTNAME to seatable.rock (the machine hostname on lan), replaced every /opt/seatable to ., and ran docker-compose up

here is the log
[+] Running 49/49 Pull complete                                           18.7s
 ⠿ memcached Pulled                                                       28.1s
   ⠿ 2a72cbf407d6 Pull complete                                           25.6s
   ⠿ 23d7f86ee24a Pull complete                                           25.7s
   ⠿ 5d49db5d7c1b Pull complete                                           25.8s
   ⠿ b4f3e3e98914 Pull complete                                           25.9s
   ⠿ fa2c0dff6f9f Pull complete                                           26.0s
 ⠿ seatable Pulled                                                        34.6s
   ⠿ c64513b74145 Pull complete                                            2.7s
   ⠿ 01b8b12bad90 Pull complete                                            2.8s
   ⠿ c5d85cf7a05f Pull complete                                            2.8s
   ⠿ b6b268720157 Pull complete                                            6.0s
   ⠿ e12192999ff1 Pull complete                                            6.1s
   ⠿ d39ece66b667 Pull complete                                            6.2s
   ⠿ 65599be66378 Pull complete                                            7.8s
   ⠿ f676efdfe2d4 Pull complete                                            7.9s
   ⠿ ab03823ab97e Pull complete                                            7.9s
   ⠿ e1dd04e08a9a Pull complete                                            8.0s
   ⠿ fded16cb5acd Pull complete                                            8.0s
   ⠿ c65fa173029c Pull complete                                           12.6s
   ⠿ a4ba481651a5 Pull complete                                           13.9s
   ⠿ bb78c599c3cf Pull complete                                           17.5s
   ⠿ a52811a519c8 Pull complete                                           17.6s
   ⠿ d60742b4e25f Pull complete                                           17.7s
   ⠿ 06445ef3f2c5 Pull complete                                           17.9s
   ⠿ 2833913ddc0b Pull complete                                           18.4s
   ⠿ a3d5a0c6d0bb Pull complete                                           18.7s
   ⠿ 4bf86f863064 Pull complete                                           20.1s
   ⠿ 3f0833c91449 Pull complete                                           23.5s
   ⠿ ddd2cfd8c13a Pull complete                                           23.7s
   ⠿ 4fef3a0d7c61 Pull complete                                           23.9s
   ⠿ 6c036627b01a Pull complete                                           24.0s
   ⠿ e23af4d2f46a Pull complete                                           24.9s
   ⠿ 1018d8263c68 Pull complete                                           26.7s
   ⠿ 5684bf87202a Pull complete                                           27.0s
   ⠿ f757c0c7d0e7 Pull complete                                           27.0s
   ⠿ 007fbed36d96 Pull complete                                           27.1s
   ⠿ f2d3c6a3f887 Pull complete                                           32.5s
   ⠿ c4c1f4950886 Pull complete                                           32.6s
   ⠿ 5122e29a3a39 Pull complete                                           32.7s
   ⠿ ac5ad731fce5 Pull complete                                           32.8s
   ⠿ 3f4a46e267fa Pull complete                                           32.8s
   ⠿ 0bc9c1bd7c52 Pull complete                                           32.9s
 ⠿ redis Pulled                                                           30.0s
   ⠿ 68ced04f60ab Pull complete                                           27.2s
   ⠿ 7ecc253967df Pull complete                                           27.3s
   ⠿ 765957bf98d4 Pull complete                                           27.4s
   ⠿ 52f16772e1ca Pull complete                                           27.7s
   ⠿ 2e43ba99c3f3 Pull complete                                           27.8s
   ⠿ d95576c71392 Pull complete                                           27.9s
[+] Running 5/4
 ⠿ Network seatable_seatable-net  Creat...                                 0.0s
 ⠿ Container seatable-mysql       Created                                  0.2s
 ⠿ Container seatable-redis       Created                                  0.2s
 ⠿ Container seatable-memcached   Create...                                0.2s
 ⠿ Container seatable             Created                                  0.1s
Attaching to seatable, seatable-memcached, seatable-mysql, seatable-redis
seatable-mysql      | 2022-04-07 19:23:11+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.15+maria~focal started.
seatable-redis      | 1:C 07 Apr 2022 19:23:11.024 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
seatable-redis      | 1:C 07 Apr 2022 19:23:11.024 # Redis version=5.0.7, bits=64, commit=00000000, modified=0, pid=1, just started
seatable-redis      | 1:C 07 Apr 2022 19:23:11.024 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
seatable-redis      | 1:M 07 Apr 2022 19:23:11.025 * Running mode=standalone, port=6379.
seatable-redis      | 1:M 07 Apr 2022 19:23:11.025 # Server initialized
seatable-redis      | 1:M 07 Apr 2022 19:23:11.025 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
seatable-redis      | 1:M 07 Apr 2022 19:23:11.025 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
seatable-redis      | 1:M 07 Apr 2022 19:23:11.025 * Ready to accept connections
seatable-mysql      | 2022-04-07 19:23:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
seatable-mysql      | 2022-04-07 19:23:11+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.15+maria~focal started.
seatable-mysql      | 2022-04-07 19:23:11+00:00 [Note] [Entrypoint]: Initializing database files
seatable            | *** Running /etc/my_init.d/01_init.sh...
seatable            | *** Booting runit daemon...
seatable            | *** Runit started as PID 27
seatable            | *** Running /templates/enterpoint.sh...
seatable            | 2022-04-07 19:23:11 Start init
seatable-mysql      |
seatable-mysql      |
seatable-mysql      | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
seatable-mysql      | To do so, start the server, then issue the following command:
seatable-mysql      |
seatable-mysql      | '/usr/bin/mysql_secure_installation'
seatable-mysql      |
seatable-mysql      | which will also give you the option of removing the test
seatable-mysql      | databases and anonymous user created by default.  This is
seatable-mysql      | strongly recommended for production servers.
seatable-mysql      |
seatable-mysql      | See the MariaDB Knowledgebase at https://mariadb.com/kb
seatable-mysql      |
seatable-mysql      | Please report any problems at https://mariadb.org/jira
seatable-mysql      |
seatable-mysql      | The latest information about MariaDB is available at https://mariadb.org/.
seatable-mysql      |
seatable-mysql      | Consider joining MariaDB's strong and vibrant community:
seatable-mysql      | https://mariadb.org/get-involved/
seatable-mysql      |
seatable-mysql      | 2022-04-07 19:23:12+00:00 [Note] [Entrypoint]: Database files initialized
seatable-mysql      | 2022-04-07 19:23:12+00:00 [Note] [Entrypoint]: Starting temporary server
seatable-mysql      | 2022-04-07 19:23:12+00:00 [Note] [Entrypoint]: Waiting for server startup
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] mysqld (mysqld 10.5.15-MariaDB-1:10.5.15+maria~focal) starting as process 101 ...
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Uses event mutexes
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Number of pools: 1
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Using Linux native AIO
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Completed initialization of buffer pool
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: 128 rollback segments are active.
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] InnoDB: 10.5.15 started; log sequence number 45106; transaction id 20
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] Plugin 'FEEDBACK' is disabled.
seatable-mysql      | 2022-04-07 19:23:12 0 [Warning] 'user' entry 'root@68b6047931b7' ignored in --skip-name-resolve mode.
seatable-mysql      | 2022-04-07 19:23:12 0 [Warning] 'proxies_priv' entry '@% root@68b6047931b7' ignored in --skip-name-resolve mode.
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] Reading of all Master_info entries succeeded
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] Added new Master_info '' to hash table
seatable-mysql      | 2022-04-07 19:23:12 0 [Note] mysqld: ready for connections.
seatable-mysql      | Version: '10.5.15-MariaDB-1:10.5.15+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
seatable-mysql      | 2022-04-07 19:23:13+00:00 [Note] [Entrypoint]: Temporary server started.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
seatable-mysql      | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
seatable-mysql      | 2022-04-07 19:23:14+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
seatable-mysql      |
seatable-mysql      | 2022-04-07 19:23:14+00:00 [Note] [Entrypoint]: Stopping temporary server
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] Event Scheduler: Purging the queue. 0 events
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] InnoDB: FTS optimize thread exiting.
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] InnoDB: Starting shutdown...
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
seatable-mysql      | 2022-04-07 19:23:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 220407 19:23:14
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Shutdown completed; log sequence number 45118; transaction id 21
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] mysqld: Shutdown complete
seatable-mysql      |
seatable-mysql      | 2022-04-07 19:23:15+00:00 [Note] [Entrypoint]: Temporary server stopped
seatable-mysql      |
seatable-mysql      | 2022-04-07 19:23:15+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
seatable-mysql      |
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] mysqld (mysqld 10.5.15-MariaDB-1:10.5.15+maria~focal) starting as process 1 ...
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Uses event mutexes
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Number of pools: 1
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Using Linux native AIO
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Completed initialization of buffer pool
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: 128 rollback segments are active.
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: 10.5.15 started; log sequence number 45118; transaction id 20
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] Plugin 'FEEDBACK' is disabled.
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] InnoDB: Buffer pool(s) load completed at 220407 19:23:15
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] Server socket created on IP: '::'.
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] Reading of all Master_info entries succeeded
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] Added new Master_info '' to hash table
seatable-mysql      | 2022-04-07 19:23:15 0 [Note] mysqld: ready for connections.
seatable-mysql      | Version: '10.5.15-MariaDB-1:10.5.15+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
seatable-mysql      | 2022-04-07 19:23:16 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'root' host: '192.168.48.5' (Got an error reading communication packets)
seatable            | 2022-04-07 19:23:19 Nginx ready
seatable            | 2022-04-07 19:23:19 This is a idle script (infinite loop) to keep container running.

Then I ran the extra commands

docker exec -d seatable /shared/seatable/scripts/seatable.sh start
docker exec -it seatable /shared/seatable/scripts/seatable.sh superuser

and everything worked fine, so I’ll stick to linux for now.

Next step, host seatable behind my traefik reverse-proxy…

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.