Comments (34)
NovumGain
commented on September 22, 2024
1
AH, I see it now
from romm.
NovumGain
commented on September 22, 2024
1
I need to lay down for a little bit. In a full-body fibromyalgia attack and am in severe pain. Once my soma kicks in, I should be able to get up and be able to work on this again. Sorry for all the troubles I'm giving you.
from romm.
gantoine
commented on September 22, 2024
romm_db | 2024-02-22 17:46:29 3 [Warning] Access denied for user 'user'@'172.28.0.4' (using password: YES)
your volume mount for mysql is wrong, try this:
romm_db:
image: mariadb:latest
container_name: romm_db
environment:
- MYSQL_ROOT_PASSWORD=hidden
- MYSQL_DATABASE=romm-stack
- MYSQL_USER=user
- MYSQL_PASSWORD=hidden
volumes:
- mysql_data:/var/lib/mysql
ports:
- 3306:3306
restart: "unless-stopped"
also you need to change an env variables:
- REDIS_HOST=redis # default: localhost
from romm.
NovumGain
commented on September 22, 2024
My apologies, but I don't see what's wrong with the mysql; I'll replace it with yours, but I don't see any visible changes besides the redacted password being pasted in... May I ask what you changed?
from romm.
gantoine
commented on September 22, 2024
Those changes may not fix the underlying issue but at least your compose will be right and we can work from there.
from romm.
NovumGain
commented on September 22, 2024
Alright. Many thanks. That said, it's still erroring, it seems, with the same error.
from romm.
gantoine
commented on September 22, 2024
could you post the updated logs?
from romm.
NovumGain
commented on September 22, 2024
Can do;
[sudo] password for user:
[+] Running 4/4
✔ Network romm_default Created 0.5s
✔ Container redis Created 13.6s
✔ Container romm_db Created 12.6s
✔ Container romm Created 7.2s
Attaching to redis, romm, romm_db
romm_db | 2024-02-22 19:33:44+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
redis | 1:C 22 Feb 2024 19:33:48.077 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. 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.
redis | 1:C 22 Feb 2024 19:33:48.078 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis | 1:C 22 Feb 2024 19:33:48.078 * Redis version=7.2.4, bits=64, commit=00000000, modified=0, pid=1, just started
redis | 1:C 22 Feb 2024 19:33:48.078 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis | 1:M 22 Feb 2024 19:33:48.079 * Increased maximum number of open files to 10032 (it was originally set to 1024).
redis | 1:M 22 Feb 2024 19:33:48.079 * monotonic clock: POSIX clock_gettime
redis | 1:M 22 Feb 2024 19:33:48.081 * Running mode=standalone, port=6379.
redis | 1:M 22 Feb 2024 19:33:48.082 * Server initialized
redis | 1:M 22 Feb 2024 19:33:48.082 * Ready to accept connections tcp
romm_db | 2024-02-22 19:33:56+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
romm_db | 2024-02-22 19:33:56+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
romm_db | 2024-02-22 19:33:56+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
romm_db | 2024-02-22 19:33:56+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
romm_db | 2024-02-22 19:33:57 0 [Note] Starting MariaDB 11.2.3-MariaDB-1:11.2.3+maria~ubu2204 source revision 79580f4f96fc2547711f674eb8dd514abd312b4a as process 1
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Number of transaction pools: 1
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Using liburing
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Completed initialization of buffer pool
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: End of log at LSN=47629
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Opened 3 undo tablespaces
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: log sequence number 47629; transaction id 14
romm_db | 2024-02-22 19:33:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
romm_db | 2024-02-22 19:33:57 0 [Note] Plugin 'FEEDBACK' is disabled.
romm_db | 2024-02-22 19:33:57 0 [Note] Plugin 'wsrep-provider' is disabled.
romm_db | 2024-02-22 19:33:58 0 [Note] InnoDB: Buffer pool(s) load completed at 240222 19:33:58
romm_db | 2024-02-22 19:33:58 0 [Note] Server socket created on IP: '0.0.0.0'.
romm_db | 2024-02-22 19:33:58 0 [Note] Server socket created on IP: '::'.
romm_db | 2024-02-22 19:33:59 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
romm_db | 2024-02-22 19:33:59 0 [Note] mariadbd: ready for connections.
romm_db | Version: '11.2.3-MariaDB-1:11.2.3+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
romm_db | 2024-02-22 19:34:43 3 [Warning] Access denied for user 'user'@'192.168.64.4' (using password: YES)
romm | Traceback (most recent call last):
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | mariadb.OperationalError: Access denied for user 'user'@'192.168.64.4' (using password: YES)
romm |
romm | The above exception was the direct cause of the following exception:
romm |
romm | Traceback (most recent call last):
romm | File "/backend/bin/alembic", line 8, in <module>
romm | sys.exit(main())
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 591, in main
romm | CommandLine(prog=prog).main(argv=argv)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 585, in main
romm | self.run_cmd(cfg, options)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 562, in run_cmd
romm | fn(
romm | File "/backend/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
romm | script.run_env()
romm | File "/backend/lib/python3.10/site-packages/alembic/script/base.py", line 576, in run_env
romm | util.load_python_file(self.dir, "env.py")
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
romm | module = load_module_py(module_id, path)
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
romm | spec.loader.exec_module(module) # type: ignore
romm | File "<frozen importlib._bootstrap_external>", line 883, in exec_module
romm | File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
romm | File "/backend/alembic/env.py", line 82, in <module>
romm | run_migrations_online()
romm | File "/backend/alembic/env.py", line 67, in run_migrations_online
romm | with engine.connect() as connection:
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3268, in connect
romm | return self._connection_cls(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
romm | Connection._handle_dbapi_exception_noconnection(
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2430, in _handle_dbapi_exception_noconnection
romm | raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | sqlalchemy.exc.OperationalError: (mariadb.OperationalError) Access denied for user 'user'@'192.168.64.4' (using password: YES)
romm | (Background on this error at: https://sqlalche.me/e/20/e3q8)
romm | ERROR: [init][2024-02-22 19:34:45] Something went horribly wrong with our database
from romm.
NovumGain
commented on September 22, 2024
If it helps, I'm running NixOS 23.11 as my OS. It has a tendency to be annoying with things like this, but the only issues I've run into are "read only" type errors with its store rather than Permission denied errors.. The second thing I should mention, again, is that I have to run docker-compose as sudo due to complications with Nixos
from romm.
gantoine
commented on September 22, 2024
mariadb.OperationalError: Access denied for user 'user'@'192.168.64.4' (using password: YES)
seems romm still can't access mariadb, you might want to rm your mariadb container, rm the mysql_data volume, check to make sure your username and passwords match, and create it again.
from romm.
NovumGain
commented on September 22, 2024
alright, will try that and will report back once done.
from romm.
NovumGain
commented on September 22, 2024
Welp, I think I found the issue. I don't see a DB in the folder of which I specified.. was I supposed to do that myself? Or was it supposed to automatically do that?
from romm.
gantoine
commented on September 22, 2024
The database mount is only if you're using sqlite, which isn't the case.
from romm.
NovumGain
commented on September 22, 2024
I don't see any databases anywhere, though -- no .db files. hell, it's pretty barren -- there's not many things made almost at all from it
from romm.
NovumGain
commented on September 22, 2024
such as /romm/db/
from romm.
gantoine
commented on September 22, 2024
you don't need /romm/db, you database is stored in mysql_data
from romm.
NovumGain
commented on September 22, 2024
I don't know where that is, actually. I see that the docker's location for it is /var/lib/mysql, but on the "real side" it's not set -- could that be the issue? (Sorry for the lack of terminology. Self taught and trying to learn)
from romm.
gantoine
commented on September 22, 2024
mysql_data is a volume, one you defined in the volumes section at the top of your compose file. this might be helpful: https://www.youtube.com/watch?v=Wh4BcFFr6Fc
from romm.
NovumGain
commented on September 22, 2024
I do more or less know how to use Docker -- I'm trying to map it, but can't figure it out -- it goes beyond just the tutorial of mapping. I'll be honest and say I'm in a really bad cptsd attack rn, so I'm not thinking super clear, but I've been wanting to get this set up for quite some time.. Would it be possible to help? Sorry to ask. I just, I don't know what else to do, or who else to go to. I do see at the top
volumes:
mysql_data:
I'd like the database to be within the location of ./data/database.db -- how would I go about this? Sorry to ask, again.
from romm.
gantoine
commented on September 22, 2024
Aaaahhh i see what you want to do! Try this mapping for mariadb:
romm_db:
image: mariadb:latest
container_name: romm_db
environment:
- MYSQL_ROOT_PASSWORD=hidden
- MYSQL_DATABASE=romm-stack
- MYSQL_USER=user
- MYSQL_PASSWORD=hidden
volumes:
- ./data/database:/var/lib/mysql
ports:
- 3306:3306
restart: "unless-stopped"
You can't use a .db file as maria doesn't support that, but you can mount the folder and have it create the DB there instead.
from romm.
NovumGain
commented on September 22, 2024
Ahh, I see. Many thanks -- I really do appreciate it. I'll let you know results in a moment.
from romm.
NovumGain
commented on September 22, 2024
It seems we're getting somewhere, lol -- the code is now erroring in another way after that (sorry, I probably should've noticed that, but it's kind of hard to think rn.), regardless, here's the new error
[user@user-NAS:/aeternae/data_servers/romm]$ sudo docker-compose up
[+] Running 4/4
✔ Network romm_default Created 0.3s
✔ Container romm_db Created 11.2s
✔ Container redis Created 10.7s
✔ Container romm Created 6.7s
Attaching to redis, romm, romm_db
romm_db | 2024-02-22 22:22:54+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
redis | 1:C 22 Feb 2024 22:22:55.380 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. 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.
redis | 1:C 22 Feb 2024 22:22:55.380 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis | 1:C 22 Feb 2024 22:22:55.380 * Redis version=7.2.4, bits=64, commit=00000000, modified=0, pid=1, just started
redis | 1:C 22 Feb 2024 22:22:55.380 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis | 1:M 22 Feb 2024 22:22:55.381 * Increased maximum number of open files to 10032 (it was originally set to 1024).
redis | 1:M 22 Feb 2024 22:22:55.381 * monotonic clock: POSIX clock_gettime
redis | 1:M 22 Feb 2024 22:22:55.382 * Running mode=standalone, port=6379.
redis | 1:M 22 Feb 2024 22:22:55.382 * Server initialized
redis | 1:M 22 Feb 2024 22:22:55.383 * Ready to accept connections tcp
romm_db | 2024-02-22 22:22:59+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
romm_db | 2024-02-22 22:22:59+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
romm_db | 2024-02-22 22:22:59+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
romm_db | 2024-02-22 22:22:59+00:00 [Note] [Entrypoint]: Initializing database files
romm | Traceback (most recent call last):
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | mariadb.OperationalError: Can't connect to server on 'romm_db' (115)
romm |
romm | The above exception was the direct cause of the following exception:
romm |
romm | Traceback (most recent call last):
romm | File "/backend/bin/alembic", line 8, in <module>
romm | sys.exit(main())
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 591, in main
romm | CommandLine(prog=prog).main(argv=argv)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 585, in main
romm | self.run_cmd(cfg, options)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 562, in run_cmd
romm | fn(
romm | File "/backend/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
romm | script.run_env()
romm | File "/backend/lib/python3.10/site-packages/alembic/script/base.py", line 576, in run_env
romm | util.load_python_file(self.dir, "env.py")
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
romm | module = load_module_py(module_id, path)
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
romm | spec.loader.exec_module(module) # type: ignore
romm | File "<frozen importlib._bootstrap_external>", line 883, in exec_module
romm | File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
romm | File "/backend/alembic/env.py", line 82, in <module>
romm | run_migrations_online()
romm | File "/backend/alembic/env.py", line 67, in run_migrations_online
romm | with engine.connect() as connection:
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3268, in connect
romm | return self._connection_cls(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
romm | Connection._handle_dbapi_exception_noconnection(
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2430, in _handle_dbapi_exception_noconnection
romm | raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | sqlalchemy.exc.OperationalError: (mariadb.OperationalError) Can't connect to server on 'romm_db' (115)
romm | (Background on this error at: https://sqlalche.me/e/20/e3q8)
romm | ERROR: [init][2024-02-22 22:23:35] Something went horribly wrong with our database
romm exited with code 0
from romm.
NovumGain
commented on September 22, 2024
Wait, I docker-compose down'd it, got it back up, and now there's a new error, lol.
from romm.
NovumGain
commented on September 22, 2024
[user@user-NAS:/aeternae/data_servers/romm]$ sudo docker-compose up
[+] Running 4/4
✔ Network romm_default Created 0.8s
✔ Container redis Created 10.6s
✔ Container romm_db Created 11.1s
✔ Container romm Created 5.9s
Attaching to redis, romm, romm_db
romm_db | 2024-02-22 22:36:56+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
redis | 1:C 22 Feb 2024 22:36:57.830 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. 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.
redis | 1:C 22 Feb 2024 22:36:57.830 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis | 1:C 22 Feb 2024 22:36:57.830 * Redis version=7.2.4, bits=64, commit=00000000, modified=0, pid=1, just started
redis | 1:C 22 Feb 2024 22:36:57.830 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis | 1:M 22 Feb 2024 22:36:57.831 * Increased maximum number of open files to 10032 (it was originally set to 1024).
redis | 1:M 22 Feb 2024 22:36:57.831 * monotonic clock: POSIX clock_gettime
redis | 1:M 22 Feb 2024 22:36:57.832 * Running mode=standalone, port=6379.
redis | 1:M 22 Feb 2024 22:36:57.832 * Server initialized
redis | 1:M 22 Feb 2024 22:36:57.833 * Ready to accept connections tcp
romm_db | 2024-02-22 22:37:01+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
romm_db | 2024-02-22 22:37:01+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
romm_db | 2024-02-22 22:37:01+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
romm_db | 2024-02-22 22:37:02+00:00 [Note] [Entrypoint]: MariaDB heathcheck configation file missing, assuming desirable
romm_db | 2024-02-22 22:37:02+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
romm_db | 2024-02-22 22:37:02 0 [Note] Starting MariaDB 11.2.3-MariaDB-1:11.2.3+maria~ubu2204 source revision 79580f4f96fc2547711f674eb8dd514abd312b4a as process 1
romm_db | 2024-02-22 22:37:02 0 [Note] mariadbd: Aria engine: starting recovery
romm_db | recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (0.4 seconds); tables to flush: 3 2 1 0 (0.9 seconds);
romm_db | 2024-02-22 22:37:04 0 [Note] mariadbd: Aria engine: recovery done
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Number of transaction pools: 1
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Using liburing
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Completed initialization of buffer pool
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: End of log at LSN=47629
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Opened 3 undo tablespaces
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: log sequence number 47629; transaction id 14
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
romm_db | 2024-02-22 22:37:04 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
romm_db | 2024-02-22 22:37:04 0 [Note] Plugin 'FEEDBACK' is disabled.
romm_db | 2024-02-22 22:37:04 0 [Note] Plugin 'wsrep-provider' is disabled.
romm_db | 2024-02-22 22:37:04 0 [Note] Recovering after a crash using tc.log
romm_db | 2024-02-22 22:37:04 0 [Note] Starting table crash recovery...
romm_db | 2024-02-22 22:37:04 0 [Note] Crash table recovery finished.
romm_db | 2024-02-22 22:37:05 0 [Note] DDL_LOG: Crash recovery executed 1 entries
romm_db | 2024-02-22 22:37:05 0 [Note] Server socket created on IP: '0.0.0.0'.
romm_db | 2024-02-22 22:37:05 0 [Note] Server socket created on IP: '::'.
romm_db | 2024-02-22 22:37:05 0 [Warning] 'user' entry 'root@e14a15ba4528' ignored in --skip-name-resolve mode.
romm_db | 2024-02-22 22:37:05 0 [Warning] 'proxies_priv' entry '@% root@e14a15ba4528' ignored in --skip-name-resolve mode.
romm_db | 2024-02-22 22:37:05 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
romm_db | 2024-02-22 22:37:05 0 [Note] mariadbd: ready for connections.
romm_db | Version: '11.2.3-MariaDB-1:11.2.3+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
romm_db | 2024-02-22 22:37:22 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.96.4' (This connection closed normally without authentication)
romm | Traceback (most recent call last):
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | mariadb.OperationalError: Host '192.168.96.4' is not allowed to connect to this MariaDB server
romm |
romm | The above exception was the direct cause of the following exception:
romm |
romm | Traceback (most recent call last):
romm | File "/backend/bin/alembic", line 8, in <module>
romm | sys.exit(main())
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 591, in main
romm | CommandLine(prog=prog).main(argv=argv)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 585, in main
romm | self.run_cmd(cfg, options)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 562, in run_cmd
romm | fn(
romm | File "/backend/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
romm | script.run_env()
romm | File "/backend/lib/python3.10/site-packages/alembic/script/base.py", line 576, in run_env
romm | util.load_python_file(self.dir, "env.py")
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
romm | module = load_module_py(module_id, path)
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
romm | spec.loader.exec_module(module) # type: ignore
romm | File "<frozen importlib._bootstrap_external>", line 883, in exec_module
romm | File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
romm | File "/backend/alembic/env.py", line 82, in <module>
romm | run_migrations_online()
romm | File "/backend/alembic/env.py", line 67, in run_migrations_online
romm | with engine.connect() as connection:
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3268, in connect
romm | return self._connection_cls(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
romm | Connection._handle_dbapi_exception_noconnection(
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2430, in _handle_dbapi_exception_noconnection
romm | raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | sqlalchemy.exc.OperationalError: (mariadb.OperationalError) Host '192.168.96.4' is not allowed to connect to this MariaDB server
romm | (Background on this error at: https://sqlalche.me/e/20/e3q8)
romm | ERROR: [init][2024-02-22 22:37:22] Something went horribly wrong with our database
romm exited with code 0
from romm.
gantoine
commented on September 22, 2024
ok 1 more change:
romm_db:
image: mariadb:latest
container_name: romm_db
environment:
- MYSQL_ROOT_PASSWORD=hidden
- MYSQL_DATABASE=romm-stack
- MYSQL_USER=user
- MYSQL_PASSWORD=hidden
volumes:
- ./data/database:/var/lib/mysql
restart: "unless-stopped"
from romm.
NovumGain
commented on September 22, 2024
[user@user-NAS:/aeternae/data_servers/romm]$ sudo docker-compose up
[+] Running 3/3
✔ Network romm_default Created 0.7s
✔ Container redis Created 12.8s
✔ Container romm Created 12.0s
Attaching to ddb595fdcd0b_romm_db, redis, romm
ddb595fdcd0b_romm_db | 2024-02-22 22:44:02+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
redis | 1:C 22 Feb 2024 22:44:03.109 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. 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.
redis | 1:C 22 Feb 2024 22:44:03.109 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis | 1:C 22 Feb 2024 22:44:03.109 * Redis version=7.2.4, bits=64, commit=00000000, modified=0, pid=1, just started
redis | 1:C 22 Feb 2024 22:44:03.109 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis | 1:M 22 Feb 2024 22:44:03.110 * Increased maximum number of open files to 10032 (it was originally set to 1024).
redis | 1:M 22 Feb 2024 22:44:03.110 * monotonic clock: POSIX clock_gettime
redis | 1:M 22 Feb 2024 22:44:03.111 * Running mode=standalone, port=6379.
redis | 1:M 22 Feb 2024 22:44:03.111 * Server initialized
redis | 1:M 22 Feb 2024 22:44:03.112 * Ready to accept connections tcp
ddb595fdcd0b_romm_db | 2024-02-22 22:44:08+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
ddb595fdcd0b_romm_db | 2024-02-22 22:44:08+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
ddb595fdcd0b_romm_db | 2024-02-22 22:44:08+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.3+maria~ubu2204 started.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09+00:00 [Note] [Entrypoint]: MariaDB heathcheck configation file missing, assuming desirable
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] Starting MariaDB 11.2.3-MariaDB-1:11.2.3+maria~ubu2204 source revision 79580f4f96fc2547711f674eb8dd514abd312b4a as process 1
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Number of transaction pools: 1
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Using liburing
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Completed initialization of buffer pool
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: End of log at LSN=47629
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Opened 3 undo tablespaces
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: log sequence number 47629; transaction id 14
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] Plugin 'FEEDBACK' is disabled.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] Plugin 'wsrep-provider' is disabled.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:09 0 [Note] InnoDB: Buffer pool(s) load completed at 240222 22:44:09
ddb595fdcd0b_romm_db | 2024-02-22 22:44:10 0 [Note] Server socket created on IP: '0.0.0.0'.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:10 0 [Note] Server socket created on IP: '::'.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:10 0 [Warning] 'user' entry 'root@e14a15ba4528' ignored in --skip-name-resolve mode.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:10 0 [Warning] 'proxies_priv' entry '@% root@e14a15ba4528' ignored in --skip-name-resolve mode.
ddb595fdcd0b_romm_db | 2024-02-22 22:44:11 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
ddb595fdcd0b_romm_db | 2024-02-22 22:44:11 0 [Note] mariadbd: ready for connections.
ddb595fdcd0b_romm_db | Version: '11.2.3-MariaDB-1:11.2.3+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
ddb595fdcd0b_romm_db | 2024-02-22 22:44:40 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192.168.128.4' (This connection closed normally without authentication)
romm | Traceback (most recent call last):
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | mariadb.OperationalError: Host '192.168.128.4' is not allowed to connect to this MariaDB server
romm |
romm | The above exception was the direct cause of the following exception:
romm |
romm | Traceback (most recent call last):
romm | File "/backend/bin/alembic", line 8, in <module>
romm | sys.exit(main())
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 591, in main
romm | CommandLine(prog=prog).main(argv=argv)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 585, in main
romm | self.run_cmd(cfg, options)
romm | File "/backend/lib/python3.10/site-packages/alembic/config.py", line 562, in run_cmd
romm | fn(
romm | File "/backend/lib/python3.10/site-packages/alembic/command.py", line 378, in upgrade
romm | script.run_env()
romm | File "/backend/lib/python3.10/site-packages/alembic/script/base.py", line 576, in run_env
romm | util.load_python_file(self.dir, "env.py")
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
romm | module = load_module_py(module_id, path)
romm | File "/backend/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
romm | spec.loader.exec_module(module) # type: ignore
romm | File "<frozen importlib._bootstrap_external>", line 883, in exec_module
romm | File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
romm | File "/backend/alembic/env.py", line 82, in <module>
romm | run_migrations_online()
romm | File "/backend/alembic/env.py", line 67, in run_migrations_online
romm | with engine.connect() as connection:
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3268, in connect
romm | return self._connection_cls(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
romm | Connection._handle_dbapi_exception_noconnection(
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2430, in _handle_dbapi_exception_noconnection
romm | raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
romm | self._dbapi_connection = engine.raw_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
romm | return self.pool.connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 452, in connect
romm | return _ConnectionFairy._checkout(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
romm | fairy = _ConnectionRecord.checkout(pool)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
romm | rec = pool._do_get()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 169, in _do_get
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 167, in _do_get
romm | return self._create_connection()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
romm | return _ConnectionRecord(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
romm | self.__connect()
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
romm | with util.safe_reraise():
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
romm | raise exc_value.with_traceback(exc_tb)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
romm | self.dbapi_connection = connection = pool._invoke_creator(self)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
romm | return dialect.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
romm | return self.loaded_dbapi.connect(*cargs, **cparams)
romm | File "/backend/lib/python3.10/site-packages/mariadb/__init__.py", line 146, in connect
romm | connection = connectionclass(*args, **kwargs)
romm | File "/backend/lib/python3.10/site-packages/mariadb/connections.py", line 85, in __init__
romm | super().__init__(*args, **kwargs)
romm | sqlalchemy.exc.OperationalError: (mariadb.OperationalError) Host '192.168.128.4' is not allowed to connect to this MariaDB server
romm | (Background on this error at: https://sqlalche.me/e/20/e3q8)
romm | ERROR: [init][2024-02-22 22:44:40] Something went horribly wrong with our database
romm exited with code 0
Looks like same error, but for some reason the amount of spaces on the left have doubled lol
from romm.
NovumGain
commented on September 22, 2024
Ah, it does look a bit different -- looks like we're at least making progress
from romm.
NovumGain
commented on September 22, 2024
Alright, I'm ready again when you are, if you're able to think of anything.
from romm.
gantoine
commented on September 22, 2024
Host '192.168.128.4' is not allowed to connect to this MariaDB server
This is the error you're getting, and sadly it's outside the scope of romm's code. For some reason your mariadb container won't accept connections from romm.
from romm.
NovumGain
commented on September 22, 2024
that's.. odd. what protocal is it trying to connect with, by chance? if 22/23, it's my opensnitch acting up
from romm.
gantoine
commented on September 22, 2024
not sure, but it should be all in the internal docker network 🤷🏼
from romm.
NovumGain
commented on September 22, 2024
Alright, so I switched to SQLite, and.. everything is "working"; except for one thing. The actual service, lol. I've tried so many different ports, and none are working, just, timing out. 3334, 8080, and 6379.. Any ideas?
from romm.
gantoine
commented on September 22, 2024
No clue top of my head, care to join our discord and continue the chat there? I don't think your issues are bugs in RomM but based on your setup, and discord's better place to chat about these. https://discord.gg/sYFQPgvU3j
from romm.
NovumGain
commented on September 22, 2024
Alright, will join.
from romm.
Related Issues (20)
- [Bug] Scanning unidentified still scans identified games HOT 4
- [Bug] "Abort" option doesn't work when scanning HOT 1
- [Bug] Unable to upload ROMS HOT 9
- [Feature] Favorites & Labels for Saves & States
- [Bug] IGDB metadata with unicode characters causes errors HOT 2
- [Bug] Profile image and app icon sometimes produce a 404 HOT 1
- [Bug] Websocket connection failure HOT 2
- [Feature] Allow "viewer" role users access to Firmware/BIOS menu. HOT 1
- [Feature] Preferred/Default Game Language HOT 1
- [Bug] Custom Covers Not Saved HOT 1
- [Bug] Game launch - network error HOT 6
- [Feature] Group games without metadata match as siblings
- [Feature] More fine-grained control over searches HOT 1
- [Feature] Upload Additional Files (Updates, Patches, DLC, Mods, etc) HOT 3
- [Feature] Library Wide Filtering
- [Question] Can files be "reasonably" replaced? HOT 1
- [Bug] joserfc.errors.InvalidKeyTypeError: invalid_key_type: Algorithm "RS256" requires "RSA" key HOT 2
- [Feature] Auto-generated collections for franchises
- [Feature] Shared collections HOT 1
- ROMM detecting platforms (the folders) but not the ROMS (the roms inside the folders) HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from romm.