Gaseous Server Container Fails to Connect to MariaDB with Access Denied Error for Both root and gaseous Users

[byteme4188]

Describe the bug
I'm trying to run the Gaseous Server using the official Docker Compose setup with MariaDB as the database. However, the server container repeatedly logs:

Waiting for database...
Access denied for user 'gaseous'@'%' to database 'gaseous'

To Reproduce
Used the following docker-compose.yml, tested with both root and created new gaseous user for mariadb
version: '2'
services:
gaseous-server:
container_name: gaseous-server
image: gaseousgames/gaseousserver:latest
restart: unless-stopped
networks:
- gaseous
depends_on:
- gsdb
ports:
- 5198:80
volumes:
- gs:/root/.gaseous-server
environment:
- TZ=America/New_York
- dbhost=gsdb
- dbuser=gaseous
- dbpass=gaseous
- igdbclientid=
- igdbclientsecret=
gsdb:
container_name: gsdb
image: mariadb
restart: unless-stopped
networks:
- gaseous
volumes:
- gsdb:/var/lib/mysql
environment:
- MARIADB_ROOT_PASSWORD=gaseous
- MARIADB_USER=gaseous
- MARIADB_PASSWORD=gaseous
networks:
gaseous:
driver: bridge
volumes:
gs:
gsdb:

Run docker compose up -d.

Check the logs of the gaseous-server container using docker logs gaseous-server.

Database connectivity was manually tested via:
docker run -it --rm --network gaseous_gaseous mysql:latest mysql -h gsdb -uroot -pgaseous
docker run -it --rm --network gaseous_gaseous mysql:latest mysql -h gsdb -ugaseous -pgaseous

ran inside of MYSQL Client
CREATE DATABASE IF NOT EXISTS gaseous;
GRANT ALL PRIVILEGES ON gaseous.* TO 'gaseous'@'%' IDENTIFIED BY 'gaseous';
FLUSH PRIVILEGES;

Expected behavior
The server should connect successfully to the database and initialize without error.

Error
Same error for root user as well
Waiting for database...

20250809 035811: Critical: Database: Error while executing 'CREATE DATABASE IF NOT EXISTS gaseous;'
MySqlConnector.MySqlException (0x80004005): Access denied for user 'gaseous'@'%' to database 'gaseous'

Desktop (please complete the following information):
Proxmox V9 LXC Container
Docker version: 28.3.3, build 980b856
Docker Compose version: v2.39.1
OS: Ubuntu 22.04
MariaDB version: Official mariadb image (latest)
Gaseous Server image: gaseousgames/gaseousserver:latest

[michael-j-green]

Hi @byteme4188; just looking at your compose file there; the dbuser variable for gaseous-server should be root, or at least a user with permissions to create and modify a database, as the first thing Gaseous does is connect to the database host without specifying a database in the connection string - it then creates a database and populates that database with tables.

Only once the above process is completed does it connect using a connection string specifying the database.

The error snippet you've included indicates that it can connect to the database server, but doesn't have rights to create the database.

An alternative is to use the gaseousgames/gaseousserver:latest-embeddeddb image which has MariaDB baked in.

[byteme4188]

Hi @michael-j-green Thanks for the reply! I initially spun it up with root user for db but I got the same error message and issue. I then tried to create a gaseous user and tried that as well. Ill go ahead and try the one with MariaDB baked in and see. Im going to run it on a separate container and server anyways

[michael-j-green]

Hi @byteme4188, just wanted to check with you to see if you were able to resolve this?

[byteme4188]

I was able to resolve the issue but had the same issue with the embedded image. For some reason when spinning up the container the mariadb container does not like the root user at all. I had to create a new user for db and give it access and that finally worked.

[michael-j-green]

Thanks for getting back. Glad it’s working.

I might need to spin up a Proxmox host to see whats going on, because what you’ve described sounds very unusual.