SeAT - โ-support - Page 7
Akov
22 Sep 2024 08:37
wonder if they didnt have a price source imported from v4
Crypta Electrica
22 Sep 2024 08:38
Ahh! Sorry yes that would do it. V4 didn't have price sources. Apologies I forgot about that. So after an import from v4 to v5 need to specify price source.
Akov
22 Sep 2024 08:38
sall good
Growing pains
Crypta Electrica
22 Sep 2024 08:39
Hehe. I don't think about v4 a lot anymore
Starting more to think about a potential v6
Akov
22 Sep 2024 08:41
remind me to write out a wish list
Astral
23 Sep 2024 02:40
Throw a curve and just say it's V7
Akov
23 Sep 2024 03:31
ok teamspeak, settle down
Astral
23 Sep 2024 09:06
Fryke
23 Sep 2024 09:56
I'm getting some wild runtime numbers with some character related jobs that report back that the software has hit the error limit for ESI. my task queue has been struggling to keep up over the last couple days because of it. any advice?
recursive_tree
23 Sep 2024 10:34
can you send us your eseye logs to see which requests to esi fail?
Ncc-1709
23 Sep 2024 14:19
Since that last update 3-4 days ago, were getting near 200k errors a day again, before it we were down to 2k a week
recursive_tree
23 Sep 2024 14:35
Are you talking about the eve update or a seat update you installed?
In general, esi has been quite bad in the last few days from what I hear from others
nobody
23 Sep 2024 14:39
killmail esi endpoint looks like boom
recursive_tree
23 Sep 2024 14:40
Well at least that one will get fixed fast by ccp because of zkill
nobody
23 Sep 2024 14:41
lol
Kiba
23 Sep 2024 14:43
A lot of ESI endpoints have been quite disruptive over the last 3-4 days, mostly timeouts. Seems to be majority killmails but also is affecting other jobs like orders, status, history, etc. Feels like it's been roughly since the ESI outage last week but I haven't looked at the timeline close enough.
nobody
23 Sep 2024 14:45
U right, I stop market endpoint, and now needed to stop killmail
Fryke
23 Sep 2024 19:24
are there steps on where to find the eseye logs somewhere?
and regarding turning off endpoints, does that involve just deleting the related scheduled task?
recursive_tree
23 Sep 2024 19:25
.docs.troubleshooting
SeAT-Bot
23 Sep 2024 19:26
@user_614098468218339348, https://eveseat.github.io/docs/troubleshooting/
recursive_tree
23 Sep 2024 19:26
also on the web ui you can access the logs browser in the settings drawer. settings->log viewer
Fryke
23 Sep 2024 19:27
gotcha
yea the eseye logs are pretty much completely 504 gateway timeout errors
I can export one of them for you if you need it
the types of calls failing are all over the place
order history, killmails, skillqueue, contracts, planets
there are a bunch of 404s for a calendar route
https://esi.evetech.net/v3/characters/483957378/calendar/401753/?datasource=tranquility
there's the one for today if it helps
looks like it's been having these errors since the 17th-ish
recursive_tree
23 Sep 2024 20:00
yes, that is basically your only option
if you need to readd them, just restart the docker stack
Fryke
23 Sep 2024 20:01
kk
Deags
24 Sep 2024 03:05
Whats the line for adding workers to the server for SeAT 5?
I copies over the old one from my SeAT 4 deployment, that's not working ๐
Crypta Electrica
24 Sep 2024 03:18
It's the same
QUEUE_WORKERS=20 in the env file
Deags
24 Sep 2024 07:19
QUEUE_WORKERS=40
Just trying to understand the 5.x and optimize ๐
Crypta Electrica
24 Sep 2024 07:33
So.. 40 is a lot of workers..
But keep in mind esi is very broken at the moment so everyone's jobs will be failing and now is not a good time to optimise things.
Deags
24 Sep 2024 13:44
Ah okay, thank you. I was hoping it wasn't a "yeah you done fucked up your config*
I can prolly tune that down to 30 on 5.x, it seems to run jobs A LOT faster than 4.x did lol
ReadYY
24 Sep 2024 16:38
do we have a statement from ccp? or do we know whats up?
Wibla
24 Sep 2024 16:45
I guess they ran out of money to pay for their shitty cloud environment
๐
used to sit around 300k
lol
Akov
24 Sep 2024 16:49
I'll be real honest... I think you are going to hit a resource constraint before you hit a worker constraint and adding more workers just slows all of them down
Deags
24 Sep 2024 16:50
I rarely went over 6-7 GBs of RAM on my 4.x build with that many. Server is reasonably beefy.
Akov
24 Sep 2024 16:52
Hey, unfortunately it's your disk that is in question probably
Wibla
24 Sep 2024 16:54
okay that's nuts. How many cores? how much memory? good storage?
Akov
24 Sep 2024 16:55
Also how many tokens
Wibla
24 Sep 2024 16:59
that too yeah
also what's your bucket update set to?
Deags
24 Sep 2024 17:05
400gb nvme SSD, 8 cores, 16gb of DDR4 RAM. VPS. I think we're at 2200+ characters? 10 minutes bucket updates. 40 workers.
Used about 41gb over the last 3+ years.
Wibla
24 Sep 2024 17:05
so it's a VPS
shared infra
Deags
24 Sep 2024 17:06
That's the resources dedicated to my instance but yes.
Wibla
24 Sep 2024 17:06
"dedicated" ๐
those are always oversubscribed to a certain extent
Deags
24 Sep 2024 17:06
Allocated*
Wibla
24 Sep 2024 17:06
fair
there will be memory pressure, cpu contention, storage contention etc
Deags
24 Sep 2024 17:07
It's not a US or UK provider, German one, Contabo. We got it back when their stuff was super cheap. Prices have gone way up for new customers since sadly.
It's in their US data center though.
I would be onboard with that if I consistently had the same error count with the same settings on 4.x but I didn't ๐ซ
I had my buckets set to 8 mins with 4.x, actually.
I only ever had to clear the eseye cache when ESI itself shit the bed fantastically.
Wibla
24 Sep 2024 17:09
how long have you been on v5 now?
Deags
24 Sep 2024 17:09
....actually now that I think about that I don't know how to do that on 5.x, I'm not sure the same container command works?
Wibla
24 Sep 2024 17:09
lol
โค๏ธ docker โค๏ธ
Deags
24 Sep 2024 17:09
Less than 4 days.
Wibla
24 Sep 2024 17:09
right
that's after CCP ESI shat the bed, iirc
so you don't really know heh
Deags
24 Sep 2024 17:10
Ah okay I didn't know that happened in the last few days, just lined up right with my upgrade. Wonderful
When Crypta said earlier "ESI is being bad" I was like "....right when I updated??" but....this is CCP we're talking about. Sorry for prolly coming across as doubting you, Crypta, if you read this.
I held off on updating for so long because I knew how to work 4.x well enough, but some of the plugins I was using stopped working, figured it was time to update.
I think it's healthy to have a suspicion of updating to a new version, tbf ๐
Wibla
24 Sep 2024 17:13
I'm running keydb instead of redis, eseye cache in redis, 18GB ram, 4 vCPUs on a 5600G, 2x Samsung PM683a enterprise SSD in ZFS mirror on proxmox, 4400ish tokens and 20 minute refresh
lots of errors the last few days, but it runs pretty well
that host basically only does SeAT and a couple of other things though
Deags
24 Sep 2024 17:14
Yeah mine is overkill for just SeAT
But it's only $16.99/mo
Wibla
24 Sep 2024 17:14
๐ค
Deags
24 Sep 2024 17:15
All the US/UK providers were charging double that in 2021
Wibla
24 Sep 2024 17:15
I mean you've backed off the bucket update intervall
Deags
24 Sep 2024 17:16
By two minutes ๐
I hadn't realized there was a long-going (relatively) ESI issue
Wibla
24 Sep 2024 17:17
well the default is 2 minutes
which, considering the sheer write amplification that happens with SeAT, is pure insanity ๐
Deags
24 Sep 2024 17:21
Yeah lol
Worked fine for <500 tokens
Gotta get back to work though
Wibla
24 Sep 2024 17:21
Yep ๐
Elron Hoover
24 Sep 2024 19:22
hey! going through the api documentation, i am trying to figure out how to request a different page from a request. I get the meta data "currentpage" and "lastpage", and am struggling to find a way to move to page x
looking at /api/v2/users currently if that helps
Goem
24 Sep 2024 19:27
you can use query string like this: /api/v2/users?page=12
Elron Hoover
24 Sep 2024 19:27
amazing thank you!
Astral
24 Sep 2024 21:21
Well issue with shared even if you are guaranteed X amount of ram it doesn't mean much on shared hosts. Also you say 16GB of ram.. but saying you're using 41GB just means sooner or later if that's your ram usage you will just be banned or removed as that would be considered excessive on a shared host. Then again some shared hosts could give zero fucks if you over utilize.
Deags
25 Sep 2024 00:28
I meant 41GB of SSD storage, my bad
How do you clear eseye cache on SeAT 5?
Or can I do that through the scheduler now
I used to do it via command line lol
Crypta Electrica
25 Sep 2024 03:13
It hasn't changed
Deags
25 Sep 2024 23:37
dope
Okay, sorry, tried running that old command you told about in DMs over a year ago, just modified for the new docker compose:
docker compose exec seat-web php artisan se:ca:cl
Got this root@vmi618539:/opt/seat-docker# docker compose exec seat-web php artisan se:ca:cl
WARN[0000] /opt/seat-docker/docker-compose.override.yml: the attribute `version` is obsolete, it will be ignored, please remove it to avoid potential confusion
service "seat-web" has neither an image nor a build context specified: invalid compose project
wait seat-web isn't even a container in 5.x
I'm dumb. Justr trying to clear the eseye cache
Crypta Electrica
26 Sep 2024 00:10
The container names have changed. It's now called front
Deags
26 Sep 2024 05:17
Not sure what this means when trying to clear the cache?
root@vmi618539:/opt/seat-docker# docker compose exec seat-docker-front-1 php artisan se:ca:cl
WARN[0000] /opt/seat-docker/docker-compose.override.yml: the attribute `version` is obsolete, it will be ignored, please remove it to avoid potential confusion
service "seat-web" has neither an image nor a build context specified: invalid compose project
okay renamed the override file and not I get this:
root@vmi618539:/opt/seat-docker# docker compose exec seat-docker-front-1 php artisan se:ca:cl
service "seat-docker-front-1" is not running
But....[+] Running 6/0
โ Container seat-docker-mariadb-1 Running 0.0s
โ Container seat-docker-cache-1 Running 0.0s
โ Container seat-docker-front-1 Running 0.0s
โ Container seat-docker-worker-1 Running 0.0s
โ Container seat-docker-scheduler-1 Running 0.0s
โ Container seat-docker-traefik-1 Running 0.0s
recursive_tree
26 Sep 2024 19:40
that looks suspiciously like a mix of seat 4 and 5. seat-web doesn't exist anymore in 5, it is now called front
also you can ignore the warning about the version being obsolete
you exec by service name, not container name, so
docker compose exec front php artisan se:ca:cl
Deags
26 Sep 2024 19:44
AHHHH okay
Awesome, that worked, ty
the old command was seat-web so I imagine the service was called seat-web
Aha
I understand better now
Wibla
26 Sep 2024 19:48
use containers they said...
it'll be so much easier they said...
shit I upgraded and now my commands don't work anymore, halp?
Kiba
26 Sep 2024 19:56
Use bare metal they saidโฆ itโll be so much easier they said. Shit I upgraded and now I have to roll back to a machine image backup, see you tomorrow. ๐คฃ
Wibla
26 Sep 2024 19:59
snapshots exist
:v
or just do a PBS backup before updating v0v
I guess if you're on some shitty VPS that's problematic
kuch3n
28 Sep 2024 10:03
is ESI broken? got a huge amount of timeouts..
Crypta Electrica
28 Sep 2024 11:17
Has been for two weeks on and off now
Astral
28 Sep 2024 11:18
Not just ESI.. clients are also dropping
Wibla
28 Sep 2024 11:26
yeah
had all my clients drop offline before DT
good times
Astral
28 Sep 2024 11:26
Well that's lucky.
I can't stay connected for more then 20 minutes or less.
Wibla
28 Sep 2024 11:26
with multiple titans undocked?
but yeah, haven't logged in much the last week or so, been busy with work
Astral
28 Sep 2024 11:27
Or trying to dock in a keep or npc and disconnecting each time you attempt to dock
Sitting under pos shields right now
Wibla
28 Sep 2024 11:27
damn
that seems pretty fucked up
Astral
28 Sep 2024 11:27
I'm effectively coffined right now
kuch3n
28 Sep 2024 14:10
CCPleeeeeaaasse
Wibla
3 Oct 2024 15:49
it got even worse :v
just looking at this
file: diskstats_iops-week.png [not recorded]
Xalkost
3 Oct 2024 15:53
yep, esi stability is not at it's best that's for sure
Ariel Rin
3 Oct 2024 21:55
2.5 weeks
Wibla
4 Oct 2024 06:06
tbf, EVE stability isn't all that great either
getting all my clients disconnected at the same time at irregular intervals
Xalkost
4 Oct 2024 08:59
We've folks from the UK area that gets dcd at the same time on daily basis. I'm wondering if the global problem is related to network issues or if it is their pure infra instability
Asrik
4 Oct 2024 13:18
Iv heard recently Verizon and Cloudflare had network issues...
Astral
4 Oct 2024 14:34
Mostly likely just Verizon fuckery.
Wibla
5 Oct 2024 08:52
lol
file: image.png [not recorded]
that is some shit
nobody
6 Oct 2024 02:42
WHAT CCP DOING NOW
Astral
6 Oct 2024 03:22
https://tenor.com/view/the-simpsons-homer-simpson-spider-pig-pig-ceiling-gif-4466277
Ncc-1709
6 Oct 2024 18:02
i thought mine was looking bad
Crypta Electrica
6 Oct 2024 18:04
Unfortunately there's not a lot we can do to improve the quality of esi.. The avenue we have been advised by CCP to take is to bring up the issues we are having with the CSM.
Ncc-1709
6 Oct 2024 18:11
any idea why seat slows to a crawl when we have this many errors?
Crypta Electrica
6 Oct 2024 18:14
Most likely ram pressure. Unfortunately laravel decides to store failed jobs initially in redis, before a flush to the db after 24 (iirc). The downside of this is lots of ram pressure which can then itself cause more errors. (positive feedback cycle is bad)
A method to check that is to run
php artisan se:ca:cl to clear the redis cache out and alleviate the ram pressure temporarily
Ncc-1709
6 Oct 2024 19:01
ram seems pretty stable at 80%
you mean
docker compose exec front php artisan se:ca:cl
ok that took its sweet ass time, but ram dropped a lot
Astral
6 Oct 2024 20:46
"You all don't need api right?"
Ncc-1709
7 Oct 2024 20:23
since doing the big update last night, error's have dropped down to 5k in a day
Wibla
7 Oct 2024 20:43
oh yeah?
tha'ts interesting
VeritasLuxMea
8 Oct 2024 23:34
Yeah mine is showing just over 200k failed jobs ๐
Wibla
10 Oct 2024 05:54
800k ...
Astral
10 Oct 2024 06:01
https://tenor.com/view/it-just-works-tod-todd-howard-%D1%82%D0%BE%D0%B4%D0%B4%D0%B3%D0%BE%D0%B2%D0%B0%D1%80%D0%B4-fallout-skyrim-gif-14803660
Crypta Electrica
10 Oct 2024 06:06
esi is slightly better atm. you can try clearing your job queues and cache to see if things inmprove
VeritasLuxMea
10 Oct 2024 13:39
I've noticed my errors have slowly decreased through the week from 200k to almost less than 100k
Ncc-1709
10 Oct 2024 14:37
mine were ok.. till overnight
fml ccp
Wibla
10 Oct 2024 15:29
looks like things have improved a bit at least
file: sda-month.png [not recorded]
Ncc-1709
10 Oct 2024 16:00
i did a update clear an hour ago
Asrik
10 Oct 2024 17:12
Question, what if we can help their load by decreasing the request by 10%, 25% or 50% (im just pull numbers randomly)? or if CCP can come up with a new esi recommended standard/protocol?
just saying if we call contribute, it could help them?
Wibla
10 Oct 2024 18:03
maybe they had to scale back their cloud infra costs ๐
so now it's just overloaded and shit in general?
Nightmare
10 Oct 2024 18:06
i am so annoyed, SeAT is not even posting some killmails twice....no...some KM get not posted at all!
Ncc-1709
10 Oct 2024 18:15
we slowed down our refresh from 2 mins to 30 mins and it still goes
in 3h
1000 in 5 mins
and 2 mins
i guess esi is dead
Asrik
10 Oct 2024 18:35
Sound like you going to chip in to CCP cloud infrastructure ๐๐
Wibla
10 Oct 2024 18:36
I have 14 accounts subbed
I'm doing my part.
Akov
10 Oct 2024 18:38
givenn your esi usage though....dont think you break even >:)
Wibla
10 Oct 2024 18:38
p sure I do
๐
not my fault that CCP chose a literally braindamaged architecture for their API
then claiming it was the only way to decouple it from the monolith
I call BS
recursive_tree
11 Oct 2024 06:09
and as long as your DB is happy, nothing prevents you from adding more workers, even on a second node
FremontDango
11 Oct 2024 06:10
i'm not so happy; it takes 120 hours to update everything once
Akov
11 Oct 2024 06:13
im still trying to find right balance
the new squads update though has helped a toooon
recursive really nocked it out of the park
recursive_tree
11 Oct 2024 06:15
BTW: did the last update resolve the oom issue?
Akov
11 Oct 2024 06:15
yea
no ooms even after I dropped it back to 128meg
if the Esi would stop puking all day every day maybe we could get some normal error numbers again
Wibla
11 Oct 2024 06:16
holy shit
what kind of bucket update schedule do you run?
oh I see it
120 hours
ooof
recursive_tree
11 Oct 2024 06:17
Buckets are seat 4+
FremontDango
11 Oct 2024 06:17
i modified it to a rolling schedule - the next batch of char queues when the previous batch finishes
Wibla
11 Oct 2024 06:17
seat3 ๐ฎ
FremontDango
11 Oct 2024 06:18
so it's not really scheduled in a sense - the scheduler runs per minute
Wibla
11 Oct 2024 06:18
what kind of hardware does it run on?
FremontDango
11 Oct 2024 06:18
epyc 7601p 64 core with 32G ram allocated on web
and 128G ram allocated on database
but the db is not dedicated to this. there are tens more sites on that machine as well
Akov
11 Oct 2024 06:20
~37k 504s in the esey log yesterday....down from 65k the day before
gettin better every day!
Wibla
11 Oct 2024 06:21
dayum
Ncc-1709
11 Oct 2024 22:31
you dont have prune running?
FremontDango
11 Oct 2024 22:32
v3 dont have prune
Ncc-1709
11 Oct 2024 22:32
?
FremontDango
11 Oct 2024 22:33
thats not so useful
it only deletes orphan stuff
Ncc-1709
11 Oct 2024 22:34
supposed to prune dead tokens
fml
FremontDango
11 Oct 2024 22:53
those are valid tokens
there are another 40k dead tokens
ยฏ\(ใ)/ยฏ
DrNightmare
12 Oct 2024 09:49
nope. i use the bootstap script. which leads to the access denied error. if i attache to the mariadb container and change the permissions for the seat user. the frontend container is showing this error.
i am not sure if this a follow up error because of the access denied error or if this is an error on its own.
okay after a little bit of tinkering.
1. clone the seat-docker files manually
2. set all values in .env
3. boot mariadb container
4. change the permissions to seat@'%'
5. boot any other container but front
6. boot front
this is working for me.
i think there is an issue with the mariadb user permission setup procedure. i am running on a debian latest, docker latest, with "docker compose"
recursive_tree
12 Oct 2024 09:54
did you have seat installed before?
DrNightmare
12 Oct 2024 09:55
nope. clean new VM
recursive_tree
12 Oct 2024 09:55
you should not need to do anything like that on docker
DrNightmare
12 Oct 2024 09:55
true. but this was necessary
and it is not working if the front is started once before changing the user permissions. only if i change the permissions before i start anything else.
first installation try was.
1. boot a clean new debian
2. install docker https://docs.docker.com/engine/install/debian/
3. bash <(curl -fsSL https://git.io/get-seat)
-> no success
second installaiton try:
1. boot a new clean debian
2. install docker, git
3. clone repo
4. ./bootstrap.sh (without acme because i do a opnsense sll termination endpoint for ssl)
-> no success
third:
1. boot a new clean debian
2. install docker, git
3. clone repo
4. up -d mariadb
5. change user permission seat@'%'
6. up -d
-> working
Xalkost
12 Oct 2024 10:08
it's very very veryyy strange, looks like you've already a volume attached to the mariadb container.
also you don't need to create a new vm brute force mode between all the install just be sure to down the seat stack via compose and remove the volumes (on a fresh install right) don't do that if you've a previous install or you'll lose all the datas.
so step by step via the bootstrap script you shouldn't have to clone anything. As the script will make eveything you need during the .env setup process
which is takes ESI infos, instance URI, mode (proxy/traefik) and that's it the script will generate all you need to start
DrNightmare
12 Oct 2024 10:21
Access denied for user 'seat'@'172.18.0.4' (using pa
front-1 | ssword: YES) (Connection: mysql, SQL: select table_name as `name`, (data_le
front-1 | ngth + index_length) as `size`, table_comment as `comment`, engine as `engi
front-1 | ne`, table_collation as `collation` from information_schema.tables where ta
front-1 | ble_schema = 'seat' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') or
front-1 | der by table_name)
this is the message i get if i down and up again or do a clean first boot
recursive_tree
12 Oct 2024 10:25
you need to delete the docker volume to get a fresh DB
DrNightmare
12 Oct 2024 10:25
tried that.
even with docker system prune --volumes
and do a complete overhaule of all images and networks...
no change
recursive_tree
12 Oct 2024 10:27
Does docker system prune delete docker compose volumes? I'm not 100% sure. Can you run it and then check if there are any volumes?
DrNightmare
12 Oct 2024 10:38
no volumes
i tried to step down to 5.0.50. booted like it should. changed back to tag 5. now it works. absolutly no idea why.
Crypta Electrica
12 Oct 2024 11:21
The easiest way to remove the volumes will be to run docker compose -f docker-compose.yml -f docker-compose.mariadb.yml down -v
then up the stack again
Valentine King
13 Oct 2024 21:28
Hi. Am a SeAT noob in the sense of setting up and running an instance for our Corp. Installed via the bootstrap script. Everything loaded and worked first time. Now I want to expand the instance with some plugins.
Trying to follow the plugins instructions and failing at the very first hurdle - cd'ing into /opt/seat-docker. I keep being told that there is no such directory. As such, I cannot get to the .env file to add the plugin name.
Not too sure what I am missing after re-reading the installation documentation. Any advice would be appreciated.
Asrik
13 Oct 2024 23:26
Try using
ls /opt/
See if the seat_docker folder is there..
Can't remember if you need to use "sudo" before the "bash".
Astral
14 Oct 2024 03:43
docker container inspect front
find the compose label area, It'll say where the container's compose is in question.
Valentine King
14 Oct 2024 08:08
Thanks for the replies.
ls /opt/ returns - digitalocean
docker container inspect front returns - Error response from daemon: No such container: front
Going through my file system with Filezilla, I have found /var/www/myauth, so attempted to run the Blade Package Installation instructions, being in the supposed install path, with:
sudo -H -u www-data bash -c 'php artisan down'
This returns bash: php: command not found
Installed php-cli............
Now I get Could not open input file: artisan
I am kind of guessing at present it may be simpler to reinstall SeAT from scratch..........
Crypta Electrica
14 Oct 2024 08:13
Having /var/www/myauth present makes me think you have allianceauth installed. Are you sure you installed seat?
recursive_tree
14 Oct 2024 08:39
What gives ls /var/www/myauth?
Valentine King
14 Oct 2024 08:44
> Having /var/www/myauth present makes me think you have allianceauth installed. Are you sure you installed seat?
Yep - been running it for over a month ๐ Ass aid, frontend works fine. I just can't get into the backend to do anything.
Attempted to install Alliance Auth originally, but it failed. The VPS droplet was completely reset and SeAT installed.
> What gives ls /var/www/myauth?
ls /var/www/myauth returns static
recursive_tree
14 Oct 2024 08:48
Output of find / -path docker-compose.yml?
Valentine King
14 Oct 2024 08:55
Does not give me a return. Goes back to prompt.
I am going to do a reinstall of the instance after resetting my droplet as I can not even get back into Admin, which I have been into after initial setup to set access on who can see the ESI data, etc.
Might be a case of something DigitalOcean has done (I remember they did a PHP update not long ago) that might have thrown something out?
Thanks for the assistance and I might be back later ๐
Nightmare
16 Oct 2024 14:18
Hm...i'm getting an error for "Container seat-docker-traefik-1" while they all are spooling up. ๐ค
"Error response from daemon: driver failed programming external connectivity on endpoint seat-docker-traefik-1 (b4135fcaef6a10f238e6a78eb2c2492bc141fe361c145de6e9dcab2c63ba88cc): failed to bind port 0.0.0.0:80/tcp: Error starting userland proxy: listen tcp4 0.0.0.0:80: bind: address already in use"
recursive_tree
16 Oct 2024 14:50
do you have any other web server running on that machine?
Akov
16 Oct 2024 15:59
tbh, its probably two instance of traefik running
I'd do a
docker ps and see if theres a dangling container from a previous run
Astral
16 Oct 2024 16:14
If not,
``sudo ss -tuln | grep ':80'``
``sudo netstat -tuln | grep ':80'``
Nightmare
16 Oct 2024 16:20
as long as the Batch is not installing one of its one...nope
Scheduler-1 / Woker-1 / front-1 / cache-1 / mariadb-1 shows up. Does not look like a dangling container. all have the same start time
Akov
16 Oct 2024 16:26
then its astrals command will tell you whats listening on the same port
Nightmare
16 Oct 2024 16:27
root@ubuntu:~sudo ss -tuln | grep ':80'
tcp LISTEN 0 511 :80 : root@ubuntu:~sudo netstat -tuln | grep ':80'
tcp6 0 0 :::80 ::: LISTEN Well not really getting wise from that. Just that its listening on tcp6 but the container is looking for tcp4?
Akov
16 Oct 2024 16:31
do netstat -tulpen | grep ':80' instead
Nightmare
16 Oct 2024 16:31
tcp6 0 0 :::80 :::* LISTEN 0 13052 741/apache2
The Apache2 comes up.
Akov
16 Oct 2024 16:32
there ya go
Nightmare
16 Oct 2024 16:33
hm...next question would be for a noob like myself...why and how do i stop it ๐ค
Akov
16 Oct 2024 16:34
would have to know why you were running it to start with
is there some other service running on that server?
Nightmare
16 Oct 2024 16:36
Nah...but according to the Documentation, there is a WebServer needed. NginX or Apache or not? And if i got it right, PHP: ^8.3 want Apache2 or not?
Akov
16 Oct 2024 16:37
everything is inside docker
nothing external is needed
Nightmare
16 Oct 2024 16:37
ah so the fun things down is there for the manuall shit
Akov
16 Oct 2024 16:37
yea
if nothing else needs it, I'd just uninstall apache
Nightmare
16 Oct 2024 16:37
well...i had a feeling about that already. but my first try with only the docker was also a miss, maybe i did something stupid there ๐
Akov
16 Oct 2024 16:40
containers are the way
Astral
16 Oct 2024 16:55
Depends on the host os.. some have apache installed and running by default
Nightmare
16 Oct 2024 17:18
Hmhm...its running now. Is it right, that the Admin Link is always a direct link that put me into Seat without the chance to "create" a specific account with specific credentials?
Akov
16 Oct 2024 17:39
Yes
Sign in with your main
then sign in with admin link
give your main admin
Profit
Nightmare
16 Oct 2024 17:42
hmhm...how long does it normally take to fech the prices for stuff like the moon reporter?
Ncc-1709
16 Oct 2024 20:06
o/
seems our seat is bloated, could do with some help 'unbloating' it if possible
file: image.png [not recorded]
Wibla
16 Oct 2024 20:07
woah, how many tokens is that, and how long timeframe?
Ncc-1709
16 Oct 2024 20:07
20 month, 1600 char in corp
not sure on token count
recursive_tree
16 Oct 2024 20:12
it seems like it is mostly the DB. Can you give us a breakdown of how much space each tables uses? Also, 50GB doesn't seem that crazy. I know the requirements in https://eveseat.github.io/docs/installation/requirements/#up-to-1-000-characters are probably very old and maybe no longer accurate, but 1.6*20GB=32GB vs 50GB doesn't look very crazy, given it also grows with time
Ncc-1709
16 Oct 2024 20:14
got a cmd line to do that? i havent had much luck trying to see that
recursive_tree
16 Oct 2024 20:31
curl https://www.google.com/search?q=mariadb+get+size+of+tables
1. connect to your DB (different on docker and bare)
2. run this sql query: https://mariadb.com/kb/en/information-schema-tables-table/#view-tables-in-order-of-size
Ncc-1709
16 Oct 2024 20:47
this is all i ever get back
and the backup is only ever 2-3 mb
i get nothing but syntax errors trying to use the commands from that site
copy and paste it, syntax error, type it in lowercase, kind of works
Bonechilling
17 Oct 2024 17:22
Looks to work
Maatschunat
17 Oct 2024 21:02
Our tokens wont refresh since 1 Day. Complete SEAt of the corp. Are there Problems sometimes on CCP side or died our connection?
Diagnose says all good:
* Checking ESI Access
Server Online Since: 2024-10-17T11:02:06Z
Online Players: 24462
ESI appears to be OK
Checking Local and Latest Versions. Please wait...
+--------------------+---------------+----------------+
| Package Name | Local Version | Latest Version |
+--------------------+---------------+----------------+
| SeAT API | 4.9.0 | 5.0.0 |
| SeAT Console | 4.8.0 | 4.8.0 |
| SeAT Eve API | 4.21.0 | 5.0.16 |
| SeAT Notifications | 4.3.3 | 5.0.9 |
| SeAT Services | 4.3.1 | 5.0.8 |
| SeAT Web | 4.20.0 | 5.0.18 |
+--------------------+---------------+----------------+
Seems susspicios. Or what means inactive.... the Jobs on the second page are running?!
is the only Error i can find. somebody can explain or tell me why seat isnt updating the Tokens?
Crypta Electrica
17 Oct 2024 21:26
Simple. Because horizon is inactive. It is what orchestrates jobs to be processed
I'm assuming this is a manual install, if so check your supervisor config is running
Maatschunat
17 Oct 2024 21:28
ok will check
seems true. will have to check why....
Wibla
17 Oct 2024 21:34
I've sometimes had to kick that thing into gear twice
Maatschunat
17 Oct 2024 21:34
i restarted it 3 times now..... but still failure
maybe sde outdated or so....
i dont get it running with systemctl restart supervisor.service
I didnt changed something in the last 3 months...
sysdate
17 Oct 2024 23:42
My seat server not working when clicking menu "SeAT API"
It redirect to "http://mydomain.xxx/api-admin" but it shows 404 not found
Astral
18 Oct 2024 11:18
You set the email right?
Maatschunat
18 Oct 2024 19:37
It worked for months..... today it seems to recover without any hands on. i dont know what happend.
kosmosstormstrike
24 Oct 2024 23:44
2nd entry
file: image.png [not recorded]
Astral
24 Oct 2024 23:45
Yeah I know, So if your stuff is setup on seat it should now show the seat page.
kosmosstormstrike
24 Oct 2024 23:45
we will see in a bit
that ended up bricking the domain lol
me linking the domain to seat now causes the website to no longer load
I am at a loss like how does me linking seat cause the website to no longer load
Valentine King
25 Oct 2024 00:01
Your instance of SeAT is not served by "your domain". It is served by "seat.yourdomain" as configured by your DNS A Record and the Ngix/Apache config file.
Astral
25 Oct 2024 00:03
I know when I tried https://seat.blackwatertech.space/ it shows that traefik is there but maybe misconfigs somewhere.
kosmosstormstrike
25 Oct 2024 00:03
well I just deleted the entire docker again
the folder
Astral
25 Oct 2024 00:03
Careful.. you can only request TLS certs every so often
kosmosstormstrike
25 Oct 2024 00:03
and the website still has not recovered back to the default hostinger one
Valentine King
25 Oct 2024 00:04
Are you installing through bootstrap script?
kosmosstormstrike
25 Oct 2024 00:04
yes
I am using the bootstrap script on the vps
to install seat to the vps then I am trying to connect to it on my actual machine
okay it reverted back to hostinger
after deleting the docker folder again
but soon as I point seat to this domain using the bootstrap script the website no longer loads
neither does seat.blackwatertech.space
it just does that dnsprobefinished_NXDOMAIN
Wibla
25 Oct 2024 00:06
Dude
Did you set up that subdomain?
kosmosstormstrike
25 Oct 2024 00:07
no the steps I did was buy the vps, buy the domain, then run the bootstrap script
on the vps
and also set up the eve developer application
like I said I have minimum website experience so I am looking for info what to do after running the bootstrap script but I cannot find any info
Wibla
25 Oct 2024 00:09
Then it won't work
"it doesn't work, I have tried nothing and searched for nothing, please fix my problem"
kosmosstormstrike
25 Oct 2024 00:11
hey like I said I was not aware on what to do after which is why I am asking here
Wibla
25 Oct 2024 00:11
You need to create a subdomain
kosmosstormstrike
25 Oct 2024 00:11
right
Wibla
25 Oct 2024 00:11
This is DNS 101, find a howto
kosmosstormstrike
25 Oct 2024 00:11
until you said that I had no idea I needed a subdomain
Wibla
25 Oct 2024 00:12
https://tenor.com/view/alec-baldwin-alcohol-pour-drink-pouring-alcohol-gif-16944581
It didn't cross your mind to search for that error you got?
Valentine King
25 Oct 2024 00:12
Don't forget that a DNS update (i.e. your A record) can take some time to propagate on the network. Took ours 24 hours to work. Sometimes it can be quicker. You can check your propagation status here: https://www.whatsmydns.net/. Looking for lots of green ticks ๐ If red crosses, your SeAT instance will not see the site request yet.
kosmosstormstrike
25 Oct 2024 00:13
all green apart from in japan and mexico and seattle
no as I thought it just meant the domain was not working
Wibla
25 Oct 2024 00:14
Assumptions
kosmosstormstrike
25 Oct 2024 00:14
okay so I need a subdomain
Wibla
25 Oct 2024 00:14
Google it
Good luck.
I'm going to bed
kosmosstormstrike
25 Oct 2024 00:15
wohoo now I need to buy website hosting to go on top of vps hosting and domain
oh I am looking it up now
okay so now I am searching it I assume I need a website as well as a vps and a domain?
Valentine King
25 Oct 2024 00:16
No. Sending you a dm kosmos
kosmosstormstrike
25 Oct 2024 00:16
right
all done
Astral
25 Oct 2024 01:42
Hmm what's going on there..
kosmosstormstrike
25 Oct 2024 01:42
they helped me set it up
turns out it was a simple problem with how hostinger handles ip adresses
Astral
25 Oct 2024 01:42
They guided you through getting the vps and such set up?
kosmosstormstrike
25 Oct 2024 01:43
the domain and the vps that seat was hosted on used two different ip adresses
changed the domain ip a rule to the VPS IP adress and it fixed it
now just got to go through seat and try to figure out how to use a api checker like what eve hr had or look for a community add on
Astral
25 Oct 2024 02:11
Sorry what?
kosmosstormstrike
25 Oct 2024 02:18
hostinger used two different ip adresses instead of one I used a single one and it worked
also got a new problem, to do with installing community packages on dockr 5.0
Crypta Electrica
25 Oct 2024 02:19
docker compose not docker-compose
kosmosstormstrike
25 Oct 2024 02:19
ah
I was just copying and pasting the command
another problem but I will solve it tommorrow is that SeAT does not send any notifications to my gmail account that I listed for the username
works for discord though
Crypta Electrica
25 Oct 2024 02:21
Did you set up the SMTP server info?
kosmosstormstrike
25 Oct 2024 02:22
I did
Astral
25 Oct 2024 02:22
Just make sure if you are using gmail to send the email you use an app password and not an account password.
kosmosstormstrike
25 Oct 2024 02:23
that was it
I was using my gmail account password
did not work, it doesn't matter I can still get discord notifications and that is fine gmail was optional anyway but seat is set up finally
recursive_tree
25 Oct 2024 04:45
From where? The docs should all use docker compose and not docker-compose
Valentine King
25 Oct 2024 08:02
@user_614098468218339348
> From where? The docs should all use docker compose and not docker-compose
On SeAT's main website. Stated under community package instructions:
> Once you have entered the package(s) to be installed run the below command in /opt/seat-docker:
>
> Docker (SeAT 5.x - using Traefik)
>
> docker-compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up -d
recursive_tree
25 Oct 2024 08:11
Ok thanks. Iโll fix it
Xalkost
25 Oct 2024 10:08
for compose it will always depends on docker / compose version depending how hold the server is (up to date)
i guess we'll always find some people having issues with it, while it's just common sens to know which version you have / can use
recursive_tree
25 Oct 2024 10:31
While you can run seat 5 with docker-compose, the installation instructions and docs all use docker compose
Or at least should, as weโve just seen
kosmosstormstrike
25 Oct 2024 12:38
is there a community addon for buyback which is avaIlable for Seat 5.0 ?
the only one on the website is not available for 5.0 yet
Valentine King
25 Oct 2024 13:39
The version posted in SeAT Community Packages (h4zz4rddev/seat-buyback) does install on V5 - we have it running on our instance. Not had any issues yet, not to say we might not run into some as not specifically for V5.
kosmosstormstrike
25 Oct 2024 13:52
okay thanks
found one for 5.0
only caveat is it has no discord notifications
Seb
27 Oct 2024 12:11
https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker/
I installed docker on windows, is there a windows version of the upgrade guide ?
This part of the upgrade guide is broken
404: not found
I suppose we should update it : https://raw.githubusercontent.com/eveseat/seat-docker/master/.env.example
recursive_tree
27 Oct 2024 13:01
SeAT on windows is not officially supported. There are no installations guides, so there are also no upgrade guides. If you managed to install it on windows, we generally expect you to be able to upgrade using the linux instructions
Seb
27 Oct 2024 13:02
I will see how it goes thank you ๐
recursive_tree
27 Oct 2024 13:07
thanks for the report. it will get fixed: https://github.com/eveseat/docs/pull/178
Seb
27 Oct 2024 13:12
it worked well for me it seems, will see if I encounter other problems
only "mv" command, had to be changed to "move", also I think "curl" command is not in standard windows installation but I have it myself.
Astral
27 Oct 2024 14:47
``docker compose down && docker compose pull && docker compose up -d``
Seb
27 Oct 2024 14:52
@user_247176974164819968 I want to connect to my mariadb instance from my host.
I added a port section into docker-composer.mariadb.yml (that is what I did at your advice in seat 4 and worked well) :
ports:- 127.0.0.1:3306:3306
Astral
27 Oct 2024 14:53
remove the 127.0.0.1 part if windows.
I assume this is past advice for awhile back?
Seb
27 Oct 2024 14:53
yes ๐
Astral
27 Oct 2024 14:54
I'd say 127.0.0.1:3306:3306 if you were sshing in and doing an ssh tunnel, But if this a windows host on your network just do 3306:3306
Seb
27 Oct 2024 14:55
docker run on my computer on windows, and I want to connect from my host with a mysql client (heidiSQL for my part) into my mariadb instance
my seat is just for my use to retrieve information about my characters like assets etc
Astral
27 Oct 2024 14:57
just do what I said above, 3306:3306
127.0.0.1:3306:3306 is only really for vps and doing ssh tunnels.. as some vps providers have the os set to just have any port that is open be accessible to the world the 127.0.0.1:3306:3306 prevents external but allows ssh tunnels to operate just fine.
Seb
27 Oct 2024 15:01
does not seems to work after restarting the instances.
Seat working fine but I have no access from host
Astral
27 Oct 2024 16:52
You down'd and up'd?
Seb
27 Oct 2024 16:58
yes still the same thing, but the only thing I did is to add
ports:- 3306:3306
Astral
27 Oct 2024 17:00
What's the connection string you are using?
Seb
27 Oct 2024 17:01
it's a desktop sql client, configuration did not change
Astral
27 Oct 2024 17:03
127.0.0.1 is invalid put the host ip
Seb
27 Oct 2024 17:04
everything is running on my computer
Asrik
27 Oct 2024 18:41
Maybe the firewall is blocking the port?
Wibla
27 Oct 2024 21:19
that wouldn't surprise me
Seb
28 Oct 2024 16:12
firewall de-activated it is the same thing
lsof -i -n
does not return anything when run inside mariabd, this should return something if a tunnel is created right ?
https://superuser.com/questions/248389/list-open-ssh-tunnels
inspired from here ๐
On traefik instance the output is like this
ok I solved it
my docker-composer.mariadb.yml missed the line I highlighted
I guess seat-internal is a private network not accessible from the host system
Raikia
29 Oct 2024 01:10
for some reason, i cant get seat to properly ping a discord channel when a pos is attacked/reinforced. here's my notification group, the discord integration "test" works perfectly fine. had a pos reinforced today but no notification. is the pos reinforced notification an alert type i missed? i didnt see any others that would be relevant in the list
Matt Falahe
29 Oct 2024 01:13
there is no notifications for POS events.
Raikia
29 Oct 2024 01:14
Is there a reason? Just not implemented (if so I can look at doing a pull request) or is there a technical limitation you're aware of? I know there is no pos reinforce alert but there is an attack alert in-game. TowerAlertMsg notification_id
Raiden
29 Oct 2024 02:36
POS's are very old tech. So maybe that's why ?Perhaps they are not impletmented in the ESI anymore
Kiba
29 Oct 2024 03:34
It's come up a few times, I think it was removed/deprecated a while back when CCP stated they were going to remove POS from the game entirely, and either it was removed or just not updated and then later got fully removed since the code wasn't up-to-date and I don't recall it being functional.
There are definitely notifications for them still that get captured, just someone would have to put code together to get it working.
Raiden
29 Oct 2024 03:42
I heard it was one guy that did all the POS code, and he either quit or got fired. and ccp couldnt figure out his code so they made the stations we have now instead
Ariel Rin
29 Oct 2024 04:57
POS are still in the game
they are still in ESI
they are still actively used, shot, pinged and memed
Asrik
29 Oct 2024 05:22
I heard the same thing Kiba. If i remember right, the reason was the CCP was suppose to remove the POS from the EVE long time ago when CCP implement Upwell structures. SeAT "removed" the ESI code in preparation for that. So officially POS are "still planed" to be removed. It may or may not happen any time soon or later... Unless CCP announce they will keep it, and who knows if that will ever happen...
Xalkost
29 Oct 2024 09:49
For affiliation remove corp and use a director or a ceo
Event will be tracked through you ceo director or any other role that can recieve the notifications for a starbase being attacked
Keep in mind if you add (multiple toons for each corp) you'll have N*(toons) the same notif for a given corp
recursive_tree
29 Oct 2024 09:56
Yes, pos notifications got removed from seat, but I think they are still in esi. If someone can capture me a few POS notifications, I can readd them
Wibla
29 Oct 2024 13:10
in other tools, multiple tokens per corp means tokens get rotated to get the delay time down...
Asrik
29 Oct 2024 14:30
What kind of notifications? How would you capture it?
Kiba
29 Oct 2024 15:14
I donโt have many but I could grab some from my DB later tonight if that would be helpful or maybe can trigger some new ones lol
Seb
29 Oct 2024 16:07
look like my clones does not update in seat, is this a know issue ?
I see no error in the jobs
what is the job name for the clones esi update so that I can investigate ?
Crypta Electrica
29 Oct 2024 21:17
Literally called 'Clones'
If you monitor tag
clone you should see them
Bonechilling
30 Oct 2024 01:23
Why would the command to do a database dump not work?
just instantly completes
no output
Akov
30 Oct 2024 03:23
what command are you doing
Andre Skywalker
30 Oct 2024 09:20
There a reason for pos events, i was telling this for months, there are corps with more than 40 in space, mainly whormhome corps, the ESI its still sending those alerts, there is no reason indeed in null sec where there are no tower, they are old but very usufull and still in use, and my 10 cents they can't just remove it from the game untill fast anchoring structures are a thing.
Seat 4.0 does the notifications, sest 5.0 still have the code just disabled/deprecated.
POS's are still a thing mainly in wh space, having the notifications its a most, i have to run one separete app to give me those and that makes no sense.
There are there, they are implemented
Seems true
Exactly, they are a pain to set up but very usufull in multiple situations, even in null people warp caps to it when in combat timers
/corporations/{corporationid}/starbases/
/corporations/{corporationid}/starbases/{starbase_id}/