self-host-csmm-support

Your wiki has the following notation when creating the user "csmm":

CREATE USER 'csmm'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your-db-password';

but with this notation i got a syntax error. I wrote it like this:

CREATE USER csmm@localhost IDENTIFIED BY 'your-db-password';

and got no error. Can this be the reason why no connection can be established?

changing the port seems to have been enough.

But it seems that no connection to mariadb or to the database can be established.

If you change those in Apache it should not conflict anymore

It probab borks on 80 and 443

ok, but do i need to uninstall my already installed webserver to use caddy?
Maybe stupid question sorry.

I guess yes. Or is it enough to change the port?

Go with caddy

If not

IF you know how to secure reverse proxy to csmm with apache

If you already have a webserver, you dont need to use the one included in the compose

i'm trying again on the docker image. Now I get the following message:

there is an apache2 already installed. Is that why the error message appears?
Do I have to uninstall the apache2 service first?

The support bot has a command that should do it but it broke :( Haven't gotten around to fixing it

Alright and my apologies I thought that just gave me the description of what the command does

Yeah, say2 is basically an upgraded version of say, and likewise for pm and pm2

Ok

Try doing that in your discord server 😉

🔴 something unexpected went wrong while executing this command :( If this problem persists, please join the support server and report this issue.

Oh i forgot to put the 2. And thank you.

So does the

say2

function message the entire server?

Check out

pm2

for that ^^

Does

say2

work like

pm

?

Trying to have a message sent to players upon them joining the server.

And ngl I am genuinely having fun trying to learn how to use csmm 😂

I dont think that healthcheck is causing high RAM usage, it's going to be something else

If you want to disable the healthcheck though, it's using standard docker healthcheck stuff: https://docs.docker.com/compose/compose-file/compose-file-v3/#healthcheck

csmm-db-1 | 2023-04-13 22:39:53 8 [Warning] Aborted connection 8 to db: 'csmm' user: 'csmm' host: '172.19.0.4' (Got an error reading communication packets)
csmm-csmm-web-1 | verbose: Starting app at /usr/src/app...
csmm-csmm-web-1 | verbose: Running the setup logic in

sails.config.bootstrap(done)

...
csmm-csmm-web-1 | info: Started the system stats gathering interval
csmm-csmm-web-1 | info: Importing files enabled, looking for JSON files at /home/docker/csmm
csmm-csmm-web-1 | warn: Error while trying to import, continuing with CSMM boot
csmm-csmm-web-1 | error: undefined {"code":"ENOENT","errno":-2,"path":"/home/docker/csmm","syscall":"scandir"}

kk want to Thank CSMM group for all the help they have help with on my setup. And I want to put a big thanks to @User 44750902 and reason is if he did not ask the things he did. I would be going at this for a lot more weeks. Yes I scroll up before asking for help. A big Thanks. Now I have few things to fine tuned and need little more help. I have drop caddy and now using my pfsense/HAProxy. I am seeing a lot more ram being use when csmm is running. How to turn health check down some? that is when I am seeing ram go up. With HAproxy I do not need to have it going so much and turn down csmm-db-1 check. and fix this small error

Ah nice, I haven't needed it so didn't really look into that yet

the free one

Not sure u check into but cloudflare tunnel help me with my Reverse proxy

Not an error, just the framework giving some tips on how to type less :)

verbose: Watch out! Nesting helpers more than one sub-folder deep can be a liability. It also means that you'll need to type more every time you want to use your helper. Instead, try keeping your directory structure as flat as possible; i.e. in general, having more explicit filenames is better than having deep, complicated folder hierarchies.

BTW here is little code error i was going but just let u know

woot THANKS . all cause of me not setting ntp to true

and I am in

csmm@csmm:$ timedatectl set-ntp true
==== AUTHENTICATING FOR org.freedesktop.timedate1.set-ntp ===
Authentication is required to control whether network time synchronization shall be enabled.
Authenticating as: csmm
Password:
==== AUTHENTICATION COMPLETE ===
csmm@csmm:$ timedatectl
Local time: Fri 2023-04-07 05:24:55 EDT
Universal time: Fri 2023-04-07 09:24:55 UTC
RTC time: Fri 2023-04-07 09:24:55
Time zone: America/New_York (EDT, -0400)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no

Yeah bad time on your server causes a lot of issues, it's important to always get that correct

was but now its not me fix it see if get again

yes

Is your server time correct? Eg are you syncing it with some NTP server?

I will block out ID things if that make u feel safer

do u want me to send my .env and .yml to u

Oh my bad, I looked wrong. The migrations container should stop yeah. It sets up the database structure for you. You start it, it does a bunch of SQL and then exits. I was confusing with the worker

So I dunno what's wrong still, I can give some more info though

csmm-migrations:
#build: .
image: catalysm/csmm
depends_on:
- db
environment:
NODE_ENV: "production"
env_file: .env
healthcheck:
disable: true
entrypoint: ["sh", "-c", "npm run wait-for:db && npm run db:migrate"]

me put less stop in code cause there is not one

well its keep stoping

Yes it needs to keep running, as you use CSMM there will be more 'work' for it to do

I did some testing and my steam api ID is working and I have it set csmm.altoyda.us

I have all the new logs not sure how u want them in a zip file or just upload here do not want keeping spamming chat with them. csmm log only change the worker not csmm web and csmm web is where i am getting the error. BTW is this need to be running or just stop after it finish its work.

kk that what i was thinking and been working on script to take the owner info and input it. that is why i am looking at caddy the other call for a lot of labels

Does not need to be on the same machine, RAM/CPU usage will depend a lot on how much you use it. Start with a VM with like 8 GB ram, that should be plenty