[Bug]: Unable to start web service from docker: Connection to localhost:5432 refused. #588
Comments
|
Had to truncate some of the logs to actually post the issue. If you need the full, holler! |
|
Heyo imide, Cheers, |
|
First glance: First guess: Something's going on with the database. |
thats a negative, i tested running |
|
How'd you specify the database URI of the DB container? containername:port? If you used localhost instead of the container name, use the container name instead and try again. |
|
This is going to take some time to fix. |
|
A fix is about to be released in version 7.1.1. The database has changed the volume-spec to an actual volume, instead of relative data. Example: version: '3'
services:
serverpackcreatordb:
container_name: serverpackcreatordb
image: postgres:16.1
restart: unless-stopped
environment:
- POSTGRES_DB=serverpackcreator
- POSTGRES_USER=<YOUR_USERNAME>
- POSTGRES_PASSWORD=<YOUR_PASSWORD>
volumes:
- database:/var/lib/postgresql/data
serverpackcreator:
container_name: serverpackcreator
image: griefed/serverpackcreator:latest
restart: unless-stopped
depends_on:
- serverpackcreatordb
environment:
- TZ=Europe/Berlin # Your timezone
- PUID=1000 # Your user ID
- PGID=1000 # Your group ID
- SPC_SCHEDULE_DATABASE_CLEANUP=0 0 0 * * * #CRON expression
- SPC_SCHEDULE_FILES_CLEANUP=0 0 0 * * * #CRON expression
- SPC_SCHEDULE_VERSIONS_REFRESH=0 0 0 * * * #CRON expression
- SPC_DATABASE_PASSWORD=<YOUR_PASSWORD>
- SPC_DATABASE_USERNAME=<YOUR_USERNAME>
- SPC_DATABASE_HOST=serverpackcreatordb
- SPC_DATABASE_PORT=5432
- SPC_DATABASE_DB=serverpackcreator
- SPC_MAX_UPLOAD_SIZE=1000 #In MB
- SPC_CONFIGURATION_AIKAR=-Xms4G -Xmx4G -XX\:+UseG1GC -XX\:+ParallelRefProcEnabled -XX\:MaxGCPauseMillis\=200 -XX\:+UnlockExperimentalVMOptions -XX\:+DisableExplicitGC -XX\:+AlwaysPreTouch -XX\:G1NewSizePercent\=30 -XX\:G1MaxNewSizePercent\=40 -XX\:G1HeapRegionSize\=8M -XX\:G1ReservePercent\=20 -XX\:G1HeapWastePercent\=5 -XX\:G1MixedGCCountTarget\=4 -XX\:InitiatingHeapOccupancyPercent\=15 -XX\:G1MixedGCLiveThresholdPercent\=90 -XX\:G1RSetUpdatingPauseTimePercent\=5 -XX\:SurvivorRatio\=32 -XX\:+PerfDisableSharedMem -XX\:MaxTenuringThreshold\=1 -Dusing.aikars.flags\=https\://mcflags.emc.gs -Daikars.new.flags\=true #Keep an eye out for proper escaping!
- SPC_CONFIGURATION_DIRECTORIES_MUSTINCLUDE=addonpacks,blueprints,config,configs,customnpcs,defaultconfigs,global_data_packs,global_packs,kubejs,maps,mods,openloader,scripts,shrines-saves,structures,structurize,worldshape,Zoestria
- SPC_CONFIGURATION_DIRECTORIES_SHOULDEXCLUDE=animation,asm,cache,changelogs,craftpresence,crash-reports,downloads,icons,libraries,local,logs,overrides,packmenu,profileImage,profileImage,resourcepacks,screenshots,server_pack,shaderpacks,simple-rpc,tv-cache
- SPC_CONFIGURATION_FALLBACK_UPDATEURL=https\://raw.githubusercontent.com/Griefed/ServerPackCreator/main/serverpackcreator-api/src/main/resources/serverpackcreator.properties
- SPC_SERVERPACK_AUTODISCOVERY_ENABLED=true
- SPC_SERVERPACK_AUTODISCOVERY_FILTER=START
- SPC_SERVERPACK_ZIP_EXCLUDE=minecraft_server.MINECRAFT_VERSION.jar,server.jar,libraries/net/minecraft/server/MINECRAFT_VERSION/server-MINECRAFT_VERSION.jar
- SPC_SERVERPACK_ZIP_EXCLUDE_ENABLED=true
ports:
- "8080:8080"
volumes:
- ./modpacks:/app/serverpackcreator/modpacks
- ./server-packs:/app/serverpackcreator/server-packs
- ./logs:/app/serverpackcreator/logs
volumes:
database: |
|
Ooooooooookay, that didn't work in the release, but it worked in dev. I'll get back to you when this is actually fixed. :D |
|
Version 7.1.3 works as expected, now. :) |
What happened?
Trying to use the webservice with the docker-compose config you have in the README. Upon changing the required params (the user, password) and starting, the webservice client bugs.
Running in Ubuntu 24.04 under WSL2. Also ran under Arch Linux native, same issue, same exact log output.
What did you expect to happen?
The server to start
Version
7.1.0
Relevant log output
Anything else you would like to add?
The database is reachable as I was able to run this command:
psql -h 127.0.0.1 -p 5432 -U spcuser -d serverpackcreator -W -c "SELECT version();"and it returned correctly with:
If you are using the webservice, in which browers did you encounter this bug?
No response
Code of Conduct
The text was updated successfully, but these errors were encountered: