Jump to content

Natcoso9955

Members
  • Content Count

    37
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Natcoso9955

  • Rank
    Advanced Member
  • Birthday 07/04/1992

Converted

  • Gender
    Male
  • Location
    Adelaide/Australia

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I mean you literally just need to replace one bit of code to be a variable and add the variable to docker template. done. Oh and include a note that if people have issues, check the prod.log and if it says missing table, increase timeout, delete 7dtd.sql file and restart container. I hope you do end up making the change, this is so useful for remote management. (then again it may only be me having this issue but i dont know why, my system is super over spec'd)
  2. I can confirm that unless your timeout 60 nodejs .../app.js command completes in the given time the database doesnt end up with all the tables. If you are missing even 1 entry you cannot sign in, and csmm timesout and that is what was causing my 502 error. (Not the proxy) @ich777 I'd suggest modifying you start-server.sh file to have a longer timeout, or update the container so it can be set as a variable.
  3. So after reloading the docker numerous times and cloning the sql file, i then imported them manually and exported them manually, i have most of the tables. I think manually running the nodejs app.js command with a larger timeout helped, but its not perfect. If im right, im going to suggest that you increase the timeout in your start-server.sh file. Confirming now.
  4. Your not understanding. This issue has nothing to do with proxy. The database is incomplete and as such the command gets dropped by csmm. can you do me a favour, upload you 7dtd.sql file located in data_dir/Database. dont worry it doesnt actually contain you data, just how the database tables are configured. I think the issue may be with CSMM, but thats coming from the call: echo "---Checking if Databse is present---" if [ -f ${DATA_DIR}/Database/7dtd.sql ]; then echo "---Database found, injecting, please wait---" mysql -u "csmm" -p"csmm7dtd" 7dtd < ${DATA_DIR}/Database/7dtd.sql export NODE_ENV=production else echo "--------------------------------------------------------------" echo "---Please wait initializing CSMM this will take ~60 seconds---" echo "-------the CSMM will restart automatically after that it------" echo "--------------------------------------------------------------" sleep 5 cd ${DATA_DIR}/CSMM timeout 60 nodejs ${DATA_DIR}/CSMM/app.js export NODE_ENV=production fi This. This is not exporting correctly to the 7dtd.sql file, everytime i delete and restart the container, it recreates and has different missing tables.
  5. Okay, so after removing mariaDB docker (and appdata) and CSMM (and appdata), absolute brand new grab seems to be working, well working in that i can atleast get to the webpage. I decided to do some digging, in the logs to see whats going on, im still not sure if its an nginx problem or not. I opened the nginx file to see how the code looked backend, and reverse proxy now set to include the location "/" with extra settings. (this may have been what fixed the webpage) Stilling getting error, and nginx log suggests its a timeout somewhere: 2020/05/22 13:27:06 [error] 5821#5821: *200 upstream prematurely closed connection while reading response header from upstream, client: 192.168.1.1, server: csmm.xg-gaming.duckdns.org, request: "GET /auth/steam/return?openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.op_endpoint=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Flogin&openid.claimed_id=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.identity=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.return_to=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn&openid.response_nonce=2020-05-22T03%3A55%3A06ZuqnNtHZGyjwcvL5Kz8P9ietu634%3D&openid.assoc_handle=1234567890&openid.signed=signed%2Cop_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle&openid.sig=WNR0DE%2FhzbHBxNNdcFbOdlwasXw%3D HTTP/1.1", upstream: "http://192.168.1.129:1337/auth/steam/return?openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.op_endpoint=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Flogin&openid.claimed_id=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.identity=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.return_to=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn&openid.response_nonce=2020-05-22T03%3A55%3A06ZuqnNtHZGyjwcvL5Kz8P9ietu634%3D&openid.assoc_handle=1234567890&openid.signed=signed%2Cop_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle&openid.sig=WNR0DE%2FhzbHBxNNdcFbOdlwasXw%3D", host: "csmm.xg-gaming.duckdns.org" Which lines up with the individual proxy log [22/May/2020:13:21:04 +0930] - 304 304 - GET http csmm.xg-gaming.duckdns.org "/" [Client 192.168.1.1] [Length 0] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "-" [22/May/2020:13:21:06 +0930] - 500 500 - GET http csmm.xg-gaming.duckdns.org "/api/stats" [Client 192.168.1.1] [Length 21] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "http://csmm.xg-gaming.duckdns.org/" [22/May/2020:13:21:10 +0930] - 304 304 - GET http csmm.xg-gaming.duckdns.org "/" [Client 192.168.1.1] [Length 0] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "http://csmm.xg-gaming.duckdns.org/" [22/May/2020:13:21:10 +0930] - 101 101 - GET http csmm.xg-gaming.duckdns.org "/socket.io/?__sails_io_sdk_version=1.1.13&__sails_io_sdk_platform=browser&__sails_io_sdk_language=javascript&EIO=3&transport=websocket" [Client 192.168.1.1] [Length 96] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "-" [22/May/2020:13:21:11 +0930] - 500 500 - GET http csmm.xg-gaming.duckdns.org "/api/stats" [Client 192.168.1.1] [Length 21] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "http://csmm.xg-gaming.duckdns.org/" [22/May/2020:13:24:58 +0930] - 302 302 - GET http csmm.xg-gaming.duckdns.org "/auth/steam" [Client 192.168.1.1] [Length 0] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "http://csmm.xg-gaming.duckdns.org/" [22/May/2020:13:24:59 +0930] - 101 101 - GET http csmm.xg-gaming.duckdns.org "/socket.io/?__sails_io_sdk_version=1.1.13&__sails_io_sdk_platform=browser&__sails_io_sdk_language=javascript&EIO=3&transport=websocket" [Client 192.168.1.1] [Length 120] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "-" [22/May/2020:13:27:06 +0930] - 502 502 - GET http csmm.xg-gaming.duckdns.org "/auth/steam/return?openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.op_endpoint=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Flogin&openid.claimed_id=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.identity=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322&openid.return_to=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn&openid.response_nonce=2020-05-22T03%3A55%3A06ZuqnNtHZGyjwcvL5Kz8P9ietu634%3D&openid.assoc_handle=1234567890&openid.signed=signed%2Cop_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle&openid.sig=WNR0DE%2FhzbHBxNNdcFbOdlwasXw%3D" [Client 192.168.1.1] [Length 568] [Gzip -] [Sent-to 192.168.1.129] "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" "-" So looking in CSMM log, im 99% sure issue is with database. @ich777 should i be able to access db outside of the docker? ie using adminer docker? Because i dont seem to be able to. 2020-05-22T04:47:45.130Z - warn: Error during steam auth! 2020-05-22T04:47:45.130Z - error: message=Unexpected error from database adapter: ER_NO_SUCH_TABLE: Table '7dtd.user' doesn't exist, name=AdapterError, name=AdapterError, adapterMethodName=find, modelIdentity=user, code=ER_NO_SUCH_TABLE, errno=1146, sqlMessage=Table '7dtd.user' doesn't exist, sqlState=42S02, index=0, sql=select `createdAt`, `updatedAt`, `id`, `steamId`, `discordId`, `username`, `avatar`, `admin`, `banned` from `user` where `steamId` = '76561198024157322' limit 2, isOperational=true, stack=AdapterError: Unexpected error from database adapter: ER_NO_SUCH_TABLE: Table '7dtd.user' doesn't exist at Deferred._.extend._WLModel [as _handleExec] (/csmm-7dtd/CSMM/node_modules/waterline/lib/waterline/methods/find-or-create.js:220:15) at Deferred.exec (/csmm-7dtd/CSMM/node_modules/parley/lib/private/Deferred.js:286:10) at Deferred.tryCatcher (/csmm-7dtd/CSMM/node_modules/bluebird/js/release/util.js:11:23) at ret (eval at makeNodePromisifiedEval (/csmm-7dtd/CSMM/node_modules/bluebird/js/release/promisify.js:184:12), <anonymous>:14:23) at Deferred.toPromise (/csmm-7dtd/CSMM/node_modules/parley/lib/private/Deferred.js:572:19) at Deferred.then (/csmm-7dtd/CSMM/node_modules/parley/lib/private/Deferred.js:431:22) at process._tickCallback (internal/process/next_tick.js:68:7), adapterMethodName=find, modelIdentity=user, $ref=$["cause"]["raw"] I have connected via the console and can see that the database is missing all the tables that it failed to inject. So the issue is with CSMM and how it tries to put data into the database. MariaDB [7dtd]> use 7dtd; Database changed MariaDB [7dtd]> show tables; +---------------------------+ | Tables_in_7dtd | +---------------------------+ | analytics | | banentry | | commandreply | | countryban | | cronjob | | customcommand | | customcommandargument | | customdiscordnotification | | customhook | | gblcomment | | gimmeitem | | historicalinfo | | hookvariable | | player | | playerclaimitem | | playerteleport | | playerusedcommand | | playerusedgimme | | role | | sdtdconfig | | sdtdserver | +---------------------------+ 21 rows in set (0.000 sec) So I decided to look through the start.sh, which pointed to start-server.sh Looking in here, i found the command to insert data into the database. (modified with full folder path below) mysql -u "csmm" -p"csmm7dtd" 7dtd < csmm-7dtd/Database/7dtd.sql When you run this manually you get an error. ERROR 1064 (42000) at line 389: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CHARS' at line 13 So i decided to rename the 7dtd.sql file and let it recreate. However this time it is missing player and some other tables. I think the timeout needs to be changed in the start-server.sh script, and/or how its set, as per below its using depreciated code. (node:248) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead. (node:248) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead. Im going to assume that if it times out creating all the tables in DB then it doesnt work.
  6. I wasnt trying with an external, i have MariaDB setup for a completely different docker. Also im fairly sure something is not being removed properly as now a fresh install fails to load the webpage completely. Plan for today is to completely strip mariadb from unraid, and clear appdata, and try and manually go through your docker steps. As you said, hopefully Spectral can eventually comment, It would be good to have step by step guides created (happy to help) for this dockers that are not so straight forward.
  7. Okay so i think i found the issue, just testing it now. So in the docker container it asks for a mariadb port, by default this is 3306, however i had a mariadb already running on that port so i changed the container setting to 3307. However looking csmm log its still trying to go to 3306. { host: 'localhost', port: 3306, schema: true, adapter: 'sails-mysql', url: 'mysql2://csmm:csmm7dtd@127.0.0.1:3306/7dtd', identity: 'default' } } } I am now swapping existing instance to 3307, and leaving csmm on 3306 and seeing what happens, however is this possibly a bug in the container config? Okay i dont think it made any difference attached is what im seeing in the log after a fresh install including clearing the appdata. honestly cant understand why this is not working. NOTE: after this first boot, the log never has this info, but always has: ---Checking if UID: 99 matches user--- usermod: no changes ---Checking if GID: 100 matches user--- usermod: no changes ---Setting umask to 000--- ---Checking for optional scripts--- ---No optional script found, continuing--- ---Starting...--- ---Starting MariaDB...--- ---Starting Redis Server--- ---Checking if CSMM is installed--- ---CSMM found--- ---Prepare Server--- ---Configuring Redis--- OK OK Background saving started ---Checking for old logs--- ---Configuring CSMM--- ---Checking if Databse is present--- ---Database found, injecting, please wait--- csmm.log
  8. What settings did you use? And your saying you can sign-in with steam and it redirects back to csmm?
  9. I changed to http, and also removed the cert from proxy ( and obviously removed the force SSL), still getting 502 error. This is the address that is generated after clicking signin on steam. (i have broken each & parameter into a new line for easier reading) obviously as this comes from steam, this would be the default url generated by steam when a website has a signin with steam module, but even this appears to be going to the correct address (unless for some reason the return to is wrong, http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn = http://csmm.xg-gaming.duckdns.org/auth/steam/return) https://steamcommunity.com/openid/login?openid.mode=checkid_setup& openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0& openid.ns.sreg=http%3A%2F%2Fopenid.net%2Fextensions%2Fsreg%2F1.1& openid.sreg.optional=nickname%2Cemail%2Cfullname%2Cdob%2Cgender%2Cpostcode%2Ccountry%2Clanguage%2Ctimezone& openid.ns.ax=http%3A%2F%2Fopenid.net%2Fsrv%2Fax%2F1.0& openid.ax.mode=fetch_request& openid.ax.type.fullname=http%3A%2F%2Faxschema.org%2FnamePerson& openid.ax.type.firstname=http%3A%2F%2Faxschema.org%2FnamePerson%2Ffirst& openid.ax.type.lastname=http%3A%2F%2Faxschema.org%2FnamePerson%2Flast& openid.ax.type.email=http%3A%2F%2Faxschema.org%2Fcontact%2Femail& openid.ax.required=fullname%2Cfirstname%2Clastname%2Cemail& openid.identity=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0%2Fidentifier_select& openid.claimed_id=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0%2Fidentifier_select& openid.return_to=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn& openid.realm=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org This is the url from the CSMM page with 502 error: (again broken on & parameter for easier reading) http://csmm.xg-gaming.duckdns.org/auth/steam/return?openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0& openid.mode=id_res& openid.op_endpoint=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Flogin& openid.claimed_id=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322& openid.identity=https%3A%2F%2Fsteamcommunity.com%2Fopenid%2Fid%2F76561198024157322& openid.return_to=http%3A%2F%2Fcsmm.xg-gaming.duckdns.org%2Fauth%2Fsteam%2Freturn& openid.response_nonce=2020-05-20T10%3A43%3A26Z%2FzpafCztUT7dwGhsbHr2LuGINps%3D& openid.assoc_handle=1234567890& openid.signed=signed%2Cop_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle& openid.sig=LsOyR7DyYTAZ1CyyF8S%2BooV5T4U%3D
  10. I was using that as an example only. everything is set to csmm.xg-gaming.duckdns.org
  11. So i have the steam api key set as csmm.xg-gaming.duckdns.org, this is also the address i have in proxy. I have just tested and can access via phone, but have the same issue. sign in with steam redirects after some time with 502 bad gateway According to CSMM documentation for reverse proxy it had extra settings. i have configured nginx proxy manager to have custom configuration as follows: proxy_http_version 1.1; proxy_set_header Upgrade $http_upgrade; proxy_set_header Connection 'upgrade'; proxy_set_header Host $host; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_cache_bypass $http_upgrade; proxy_read_timeout 300; proxy_connect_timeout 300; When i remove the above, the error changes from 502 to 504 gateway time-out.
  12. Can i ask what you set you nginx proxy with, im using duckdns and created an entry csmm.personalised.duckdns.org and have that pointing to my internal IP 192.168.1.129:1337 I have CSMM hostname as "http://csmm.personalised.duckdns.org" However when i go to the weblink (internal or via proxy) i can get the first page, but then click sign-in with steam and it fails (502 nginx error). Im not sure if this is an issue with steamkey api, or something ive configured.
  13. Just wondering if this solved the problem. I have the proxy setup, can access first page of CSMM, but then try and auth steam and it takes ages to load and then gives a 502 error.
  14. So this is what I'm stuck on, won't work from Maria's console, or unraid console or pterodactyl console. Where am I meant to run these commands from?
  15. I dont know if im doming something wrong, or if the lack of instructions is the issue, but i have setup the pterodactly docker, the log has basically nothing in it and i get an error 500 when i click to view the webui. Does anyone actually have a step by step guide of how to use this docker on Unraid? Starting Pterodactyl v0.7.17 in 5 seconds... [Warning] Disabling HTTPS src:"192.168.1.185" time:"16/May/2020:02:28:07 +0000" req:"GET / HTTP/1.1" status:"500" agent:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" for:"-" src:"192.168.1.185" time:"16/May/2020:02:28:08 +0000" req:"GET /svg/500.svg HTTP/1.1" status:"404" agent:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" for:"-" src:"192.168.1.185" time:"16/May/2020:02:30:02 +0000" req:"GET / HTTP/1.1" status:"500" agent:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" for:"-" src:"192.168.1.185" time:"16/May/2020:02:30:03 +0000" req:"GET /svg/500.svg HTTP/1.1" status:"404" agent:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36" for:"-" I very much could have not setup the mariadb properly as that docker also has a massive lack of guide. Basically looking for someone who has successfully set this up on unraid to provide steps. Thanks.