SeAT - β-support - Page 14
Alex
23 Oct 2025 21:57
Manage to make it work. But somehow the .env wont copy the setting after restarting
Asrik
23 Oct 2025 21:58
did you use ``sudo nano .env``?
and what to you mean copy setting aftter restarting?
Astral
24 Oct 2025 05:45
down and up.
Alex
24 Oct 2025 06:41
Tnx all!
Hello! Is this normal for the Corp Mining Tax addon?
I don't see anything on Corp Moon Minings
Matt Falahe
26 Oct 2025 21:08
U are using css that is not working with this plugin. Add section to it and change it or revert to default one I guess.
I had the same issue π
Alex
26 Oct 2025 21:15
π€ I have try reset and still same issue
Matt Falahe
26 Oct 2025 21:36
Check console if u got any errors.
And logs
ider palot
27 Oct 2025 14:23
please can someone walk me through the data restore - on the old server Ive run the back up docker compose then transferred the backup to the new server changed the .env and run the restore command but it doesnt do anything
Asrik
28 Oct 2025 14:43
I assumed your followed this document (at the bottom of the page).
https://eveseat.github.io/docs/admin_guides/docker_admin/#database-backups-and-restore
ps sorry for the late reply
ider palot
28 Oct 2025 22:49
yes
is there a specific place the .gz file needs to be in to restore, i had it in the /opt/docker-seat folder
Asrik
28 Oct 2025 23:02
There is no specific path as long you point it in the right place..
zcat /opt/docker-seat/seatbackup.sql.gz | docker compose exec -T mariadb sh -c 'exec mysql "$MYSQLDATABASE" -u"$MYSQLUSER" -p"$MYSQLPASSWORD"'
Raikia
30 Oct 2025 00:47
i have some people on my Seat install with scopes that are basically just "publicData" because they are blues. However, it looks like they are still getting queued for jobs that are out of the scope of their ESI token. my failed job log is FULL of these errors. is it necessary to have this as a failed() log instead of a debug log?
iulixxi
30 Oct 2025 20:06
Got aquestion... I get tons of errors like this lately. Any thoughts?
Asrik
30 Oct 2025 20:41
I think we all are
iulixxi
30 Oct 2025 20:58
Oh, lol. Roger
Vladimir_Vladykin
31 Oct 2025 05:01
Itβs like this actually helped me.
https://discord.com/channels/821361165791133716/1345031288226054245/1345378583333568634
Raikia
2 Nov 2025 02:53
@user_614098468218339348 have you seen this before?
recursive_tree
2 Nov 2025 05:18
Yes, there are a few checks missing in some parts of the scheduling logic
Raikia
2 Nov 2025 05:29
yeah it looks like its "Seat\Eveapi\Jobs\Killmails\Character\Recent", "Seat\Eveapi\Jobs\Character\Notifications", and "Seat\Eveapi\Jobs\Contracts\Character\Contracts" that are missed. ill see if i can take a look at the code to fix
i'm getting 30,000+ failed jobs per day in my logs because of it lol
pull request submitted ready for review: https://github.com/eveseat/eveapi/pull/443
Bradock
3 Nov 2025 01:51
hey guys, I need some help please, Jobs Process Successfully But Save 0 Data (Render.com + PostgreSQL)
Environment:- SeAT 5.x (latest Docker)
- Render.com Free Tier
- PostgreSQL 16 (managed, external host)
- Queue:
database
Seat\Eveapi\Jobs\Skills\Character\Skills ... DONE
DB::table("character_skills")->count() β 0
Verified working:- ESI returns data (tested: 330 skills, 99M SP via direct API)
- Token valid (57 scopes)
- Manual INSERT works
- Jobs process without errors
- Queue config:
--queue=high,public,default,characters,low
- characterskills, characterwalletjournals, characterassets = always 0
- 200+ jobs processed, 0 data saved
- Cleared ESI cache (
rm -rf storage/eseye/*) multiple times
- Changed
QUEUE_CONNECTIONfromsynctodatabase
- VACUUM database
- Verified scopes (all correct)
- Attempted applying PR
443
- Tables show allocated space (72KB) but 0 records
- No errors in
failed_jobs
- No exceptions in logs
- Jobs complete too fast (20-150ms) - possibly returning early?
443 (scope grants)? Does it affect Skills/Wallet/Assets jobs too?
3. PostgreSQL-specific issue with managed databases? Should I try Railway.app or is there a fix? Thanks!
Goem
3 Nov 2025 03:06
afaik SeAT doesn't support PostgreSQL, so you'd probably need to make quite a modifications to use it
recursive_tree
3 Nov 2025 05:56
Yes. Please try using MariaDB and see if the issues persist
Asrik
3 Nov 2025 18:05
Did a Ubuntu upgrade from v22 to v24.. now seat is not loading...
iv turned of all of the plugin.................. not sure what is going on...
2025-11-03 16:00:10+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.14+maria~ubu2204 started.
2025-11-03 16:00:11+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
2025-11-03 16:00:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-11-03 16:00:11+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.14+maria~ubu2204 started.
2025-11-03 16:00:11+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2025-11-03 16:00:11 0 [Note] Starting MariaDB 10.11.14-MariaDB-ubu2204 source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid 9VMJaPbse0MtQCT8llbcEfo5r6E= as process 1
2025-11-03 16:00:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-11-03 16:00:11 0 [Note] InnoDB: Using transactional memory
2025-11-03 16:00:11 0 [Note] InnoDB: Number of transaction pools: 1
2025-11-03 16:00:11 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-11-03 16:00:11 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2025-11-03 16:00:11 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
create_uring failed: falling back to libaio
2025-11-03 16:00:11 0 [Note] InnoDB: Using Linux native AIO
2025-11-03 16:00:11 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m
2025-11-03 16:00:11 0 [Note] InnoDB: Completed initialization of buffer pool
2025-11-03 16:00:11 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-11-03 16:00:11 0 [Note] InnoDB: End of log at LSN=909954565551
2025-11-03 16:00:11 0 [Note] InnoDB: 128 rollback segments are active.
2025-11-03 16:00:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-11-03 16:00:11 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-11-03 16:00:11 0 [Note] InnoDB: log sequence number 909954565551; transaction id 5628183608
2025-11-03 16:00:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-11-03 16:00:11 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-11-03 16:00:11 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2025-11-03 16:00:11 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'.
2025-11-03 16:00:11 0 [Note] Server socket created on IP: '::', port: '3306'.
2025-11-03 16:00:11 0 [Note] mariadbd: ready for connections.
Version: '10.11.14-MariaDB-ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2025-11-03 16:00:11 0 [Note] InnoDB: Buffer pool(s) load completed at 251103 16:00:11
is this correct?
recursive_tree
3 Nov 2025 18:45
I don't see anything that is obviously wrong in that log
However, how does "now seat is not loading..." manifest? Do you get an error? A timeout?
Asrik
3 Nov 2025 18:52
At first i got this error before removing the plugins
A connection timeout was encountered. If you intend to run Composer without connecting to the internet, run the command again prefixed with COMPOSER_DISABLE_NETWORK=1 to make Composer run in offline mode.
The following exception probably indicates you have misconfigured DNS resolver(s)
In CurlDownloader.php line 394:
curl error 28 while downloading https://repo.packagist.org/packages.json: R
esolving timed out after 10000 milliseconds
I havnt had much time to troubleshoot yet
i think i found it...
[2025-11-03 18:54:43] local.ERROR: cURL error 6: Could not resolve host: raw.githubusercontent.com (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://raw.githubusercontent.com/eveseat/resources/master/sde.json {"exception":"[object] (GuzzleHttp\\Exception\\ConnectException(code: 0): cURL error 6: Could not resolve host: raw.githubusercontent.com (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://raw.githubusercontent.com/eveseat/resources/master/sde.json at /var/www/seat/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php:277)
[stacktrace]
Kiba
3 Nov 2025 18:58
Looks like a DNS resolution issue, if bare metal could be with the host. Could try something like
dig raw.githubusercontent.com (and/or a few other sites) from your terminal and see if anything returns, if not should probably troubleshoot DNS resolution on the host as it's likely not SeAT specific.
Vladimir_Vladykin
3 Nov 2025 20:46
Are you by any chance from Russia?
Sometimes GitHub is inaccessible from there. A VPN usually helps.
recursive_tree
3 Nov 2025 21:01
docker or bare?
Asrik
3 Nov 2025 21:08
Net. Lol
I remember after I used a hardening script, it broke Ubuntu dns... there is a fix for it, but I have to find it again .......
I didn't apply it after the upgrade to v24.. but I wonder if it did something to it again... luckily I made a snapshot before this...
I got it to work.. Incase in the near future that someone else get the same issue... after the upgrade, it might mess up the DNS resolution. To fix it:
``sudo rm -f /etc/resolv.conf``
and then
``sudo ln -s /run/systemd/resolve/resolv.conf /etc/resolv.conf``
Wibla
3 Nov 2025 23:09
Uhm
ksk
7 Nov 2025 13:44
Hola!
running an older Seat (5) instance for me corp; Wondering: Could I get rid of some "data", without loosing insights??- What about table
api_token_logsfor example? (about 1.4G)
- Do I need all that is named
seat-storagein Docker?
- there are multiple, dated files in
sde/subdirectory -- needed?
- assuming we want to keep
eseyefolder as is?
recursive_tree
7 Nov 2025 15:12
- deleting the contents of
api_token_logsshould be fine
- deleting old sdes should be fine too, although I haven't tested it
- yes, keep eseye unless you are running a redis esi cache
ksk
7 Nov 2025 15:12
thanks!
Sharpie
7 Nov 2025 18:24
is there a limit of how many plugins a server could have? I have added some new ones and they dont seem to be loading or even reading the updated .env file. Not sure what I am doing worng.
Wibla
7 Nov 2025 19:00
have you tried turning it off and on again?
Sharpie
7 Nov 2025 20:05
lol Yes
recursive_tree
7 Nov 2025 21:10
no, there is no limit. What plugins are you talking about and how does not loading manifest itself?
Sharpie
7 Nov 2025 21:19
I just re-pulled the containers, for updates. I nano'ed the .env file to add some new plugins and it appears that the .env is not being read at /opt/seat-docker/.env . The only way I could get it to pull the new plugins was to recreate the container in portainer and manualy edit the env varaibles in portainer. Does this have to do with the .packages: development only it looks like you guys are testing?
recursive_tree
7 Nov 2025 21:21
Just to make sure, you did restart the stack after changing the .env? I don't know about portainer, but on docker you have to restart the containers with the new .env
Sharpie
7 Nov 2025 21:22
yes, I even tried recreating the containers to force the read
and restarted the host system in between
recursive_tree
7 Nov 2025 21:23
does seat start up fine or does it crash?
Sharpie
7 Nov 2025 21:23
after the manual .env edits in portainer, its working
I had to edit Line 26
ksk
8 Nov 2025 08:00
@user_118681249576386562 erm, if you are running Portainer, you need to be careful with the envrionment foobar;
If you defined env via Portainer UI, you need to deploy it via portainer ( in contrast do issuing docker compose something via ssh!)
Very easy to forget to update either via the UI, or the env file, main reason I migrated to komodo, really..
Sharpie
8 Nov 2025 08:06
so if I understand correctly, if I build via compose, then edit via the UI, I cant go back to editing via the .env?
Astral
8 Nov 2025 09:07
Portainer really shouldn't be used for deploying honestly too much abstraction and quite a few issues with how it decides to deploy stuff if you want it to read logs sure go for it..
Also teaches you bad habits too to a point.
ksk
8 Nov 2025 15:54
(IMHO) I would assume Portainer does use docker composesoo thinking along the lines: IF everything is 100% identical (env, mostly??), you should be able to deploy the stack with both CLI docker-compose and the Portainer GUI, and see no difference.
Would suggest only using one for deployment, maybe (and, https://github.com/moghtech/komodo, cough - its kind of the same as Portainer, but more free (doh!), and what was key selling point for me: It does write the ENV you configure in GUI to a file on disk if you desire: No problems with also using docker-compose-cli..)
Raikia
9 Nov 2025 23:13
@user_301981661761896449 friendly reminder when you get a chance: https://github.com/eveseat/eveapi/pull/443
Asrik
10 Nov 2025 00:09
Think you should post it in here https://discord.com/channels/821361165791133716/821361505735278592
For next time
m0d
11 Nov 2025 12:24
I am getting this when trying to boot my docker SeAT up
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP FOREIGN
front-1 | KEY `calendar_operations_user_id_foreign`; check that it exists (Connection
front-1 | : mysql, SQL: alter table `calendar_operations` drop foreign key `calendar_
front-1 | operations_user_id_foreign`)
front-1 |
front-1 |
front-1 | In Connection.php line 587:
front-1 |
front-1 | SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP FOREIGN
front-1 | KEY `calendar_operations_user_id_foreign`; check that it exists
It never boots just goes round in circles spitting this each time
Is it possible to completely remake the database?
Seiten
11 Nov 2025 15:58
hi
i could use some help with my SeaT getting ssl for it
recursive_tree
11 Nov 2025 15:59
This is related to the calendar plugin. Remove it and it should start fine. Perhaps also contact its developer
docker compose <-f your files> exec front php artisan migrate:fresh
What is the problem? The docs should cover it. If you get an error, please post it
Seiten
11 Nov 2025 16:03
i just get a webroot error.
ok to dm so i dont spam my shit here ?
recursive_tree
11 Nov 2025 16:04
No. Because then nobody else can answer the question.
Seiten
11 Nov 2025 16:04
ok
i have a Seat and i used cerbot for it
when i did the steps on their site i seem to make a cert.
but when i do a sudo certbot -v renew --dry-run i get this message
and usnsure how to go from here
Anubis
11 Nov 2025 20:39
Hello all you fantastic smart people! Is this a valid squad filter or can I not have different skills at different levels within a single group?
file: image.png [not recorded]
recursive_tree
11 Nov 2025 20:46
I can't help you much with certbot as I run docker+traefik. If you don't get an answer here, perhaps try asking somewhere more certbot-specific, as this is more about certbot than seat
Seiten
11 Nov 2025 20:50
thanks hope can get a answer, got the same answer from certbot forum that i should try here π
maybe someone can help π
Matt Falahe
11 Nov 2025 21:08
its not. Skill and skill level should be in a group. You should create as many groups as skill + skill levels you have.
Note. IF you do group for black ops and do skill level is 1 it will only put people with skill level 1 to the squad. If they will train level 2 they will lose the squad because criteria is not meet.
Anubis
11 Nov 2025 21:19
So my leadership is asking for a black ops squad that includes BLOPs pilots with JDC 5 as well as T3C pilots. Is that possible? If so, how would I set it up?
Matt Falahe
11 Nov 2025 21:28
2 seperate squads will be the best solution...
but you can try with this... the only issue is that in this case for black ops and t3c you cant request level... and people even with injected skill but not trained yet will be able to join it.
But I might be wrong.
obviously add more t3c to it I just chose 1
Anubis
11 Nov 2025 21:30
Wouldn't that require the T3C pilots to also have JDC 5?
Since the top level match is All?
Matt Falahe
11 Nov 2025 21:30
yes it would.
Logic is people have to have 1 group + any of second group
Anubis
11 Nov 2025 21:31
Hmm, I think splitting this out into two squads might be better
Matt Falahe
11 Nov 2025 21:32
if you will pick any as top level then you will get people from any of those 3 outcomes.
having only jdc 5, having only blackops, having only t3c, + variants of those like jdc 5 + t3c, jdc + blops, etc
its messy with some skills combination this is why seperate squads is cleaner approach
but I might be wrong in here
I am not that experienced with squads so maybe wait for someone else to respond as well.
Fxsx24
12 Nov 2025 18:49
I have a fresh install of seat , i cannot see more than a month back on my wallet, my character has been authd for a week or more so everything should by synced up . we also verified the same on a couple other accounts. Is this a setup issue or an esi issue?
Asrik
12 Nov 2025 22:32
it can take some time to pull the rest of the data.. Give it about 24 hours or more
Fxsx24
12 Nov 2025 22:34
The character in question has been in for at least 2 weeks. I looked at the same character on AA and I can see back to April.
Ariel Rin
13 Nov 2025 01:33
This is correct, https://developers.eveonline.com/api-explorer#/operations/GetCharactersCharacterIdWalletJournal Retrieve the given character's wallet journal going 30 days back
Your previous auth pulled this data and stored it in the database back in april.
Fxsx24
13 Nov 2025 01:37
ok so by that logic it is the same for pulling 50 mails
Ariel Rin
13 Nov 2025 03:51
I'm less sure about that, or if the endpoint just returns 50 at a time and you paginate backwards. I havent pulled an evemail in 10+ years
Xaivada Skywalker
13 Nov 2025 08:04
Any idea on this? https://discord.com/channels/821361165791133716/821361566184112181/1438279060059984075
Seion
13 Nov 2025 12:22
@user_131158012831203328 did you figure this out
Iβm having the same issue
Wibla
13 Nov 2025 13:42
nope
Michael Crilly
14 Nov 2025 07:04
When using artisan eve:update:sde are the MySQL database connection details in ./.env being used? I'm having an issue where the artisan migrate worked fine, connecting to the database and migrating the entire database schema, etc., but the eve:update:sde simply fails.
"Check the version of SDE dumps available on www.fuzzwork.co.uk. At the time of this writing, frostline-1.0-116241 was the latest. Once you have the version string ready, open the .env configuration file and add a key as follows:" -- this seems to imply it does, from the SDE Overload page.
Actually, never mind. Figured it out. Problem was in the chair, not the computer.
Tom C
14 Nov 2025 09:53
moNK-
16 Nov 2025 21:24
Hello hello.
I'm in the process of installing SeAT on my Ubuntu server.
I'm having issues with the Artisan migrate command.
Oh I see.
One moment and I'll see if I fixed it.
Yeah I fixed it. I figured the .env file had Password for DB set to 'secret' as a security feature. Turns out, I needed to add my DB password in.
All good now.
Alrighty guys, so one final question. I managed to successfully get all the way through the SeAT installation, however I'm unsure of how to connect to it via my localhost.
Currently I have another service running on :8080. Is there a way to update the SeAT configuration to use a different connection port?
So yeah, receiving a 404 error with nginx on Ubuntu.
Currently my localhost is running AMP game server off :8080.
Config files in nginx are all listening on 80, and I removed old Alliance-Auth config files that may have been conflicting, but unfortunately still unable to connect to the webpage at this time.
Unsure where to go from here, so I'll wait to hear back β€οΈ
Goem
16 Nov 2025 22:40
I guess you using docker for seat?
moNK-
16 Nov 2025 22:40
No, Ubuntu
Goem
16 Nov 2025 22:41
Docker is container layer inside ubuntu. What install method you used for seat?
moNK-
16 Nov 2025 22:42
Manual
Goem
16 Nov 2025 22:45
Is nginx config correct? There are nginx config in manual
moNK-
16 Nov 2025 22:46
I believe so. I've commented out the ipv6 config just because I've had issues with that in the past and it was throwing out an nginx error on this install as well. It worked fine with Alliance Auth and my AMP config when I did so as well. I will copy and paste.
server {
listen 80;
listen [::]:80;
If you are hosting this instance on a domain, set that
name here.
server_name seat.yourdomain.com;
SeAT public directory. This is the only directory that
should be exposed by the webserver. If one has to expose
the parent directory then things like the .env file will
be available for anyone to download.
root /var/www/seat/public; index index.php; location / { tryfiles \$uri \$uri/ /index.php?\$querystring; }PHP-FPM configuration.
location ~ \.php\$ { tryfiles \$uri /index.php =404; fastcgipass unix:/run/php/php8.2-fpm.sock; fastcgiparam SCRIPTFILENAME \$documentroot\$fastcgiscriptname; include fastcgiparams; }Even though .htaccess rules mean nothing in the nginx
world, prevent those from being downloaded anyways.
location ~ /\.ht { deny all; }In case someone messes up, prevent .env files from
being downloaded as well.
location ~ /\.env { deny all; } }
Goem
16 Nov 2025 22:50
hmm. I Think it shoud be work. maybe set server_name localhost; ?
moNK-
16 Nov 2025 22:50
Oh yeah. That might do it.
Still getting a 404 after resetting the supervisor
If you are hosting this instance on a domain, set that
name here.
server_name localhost;
Ugh
server {
listen 80;
listen [::]:80;
If you are hosting this instance on a domain, set that
name here.
servername localhost;SeAT public directory. This is the only directory that
should be exposed by the webserver. If one has to expose
the parent directory then things like the .env file will
be available for anyone to download.
root /var/www/seat/public; index index.php; location / { tryfiles \$uri \$uri/ /index.php?\$querystring; }PHP-FPM configuration.
location ~ \.php\$ { tryfiles \$uri /index.php =404; fastcgipass unix:/run/php/php8.2-fpm.sock; fastcgiparam SCRIPTFILENAME \$documentroot\$fastcgiscriptname; include fastcgi_params; }Even though .htaccess rules mean nothing in the nginx
world, prevent those from being downloaded anyways.
location ~ /\.ht { deny all; }In case someone messes up, prevent .env files from
being downloaded as well.
location ~ /\.env { deny all; } }
I'm just wondering if it's conflicting with the AMP installation I have, as amp defaults to localhost:8080, which when I looked up on Google, listening on Port 80 with nginx would default externally to :8080
Goem
16 Nov 2025 22:58
I think you are getting 404 when connecting to :80 so if it redirects to 8080 you must see AMP page. so not i guess
moNK-
16 Nov 2025 22:59
Yeah I was trying to connect to :80
and then when I do use :8080 it goes to amp
Goem
16 Nov 2025 22:59
did you run vendor:publish command?
moNK-
16 Nov 2025 23:00
I didnt, I can try that
Where would I run that, sorry?
Goem
16 Nov 2025 23:01
sudo -H -u www-data bash -c 'php /var/www/seat/artisan vendor:publish --force --all'
moNK-
16 Nov 2025 23:01
Done. So now I should just try to connect to 192.168.1.74, no port?
(The server is another PC on the network)
Yeah still getting a 404 π
I might just wipe this server and set up Docker π
Ok! I got it running now in Docker. Now I just need to figure out how to connect to it from my external IP so I can connect to to a DNS.
So if anyone knows what port SeAT uses externally, lemme know so I can port forward to my server and setup the DNS. I did it with Docker.
I think I'm a bit out of my depth here unfortunately lol. So I've got it running locally, but when I try to connect to my IP (with port forwarding) from a device not on my own local network, I still get a 404. At least it's displaying with Docker though. With the Ubuntu installation I couldn't even make it to the localhost webpage.
Asrik
17 Nov 2025 02:49
I have Cloudflare DNS using their tunnel. You will need to add the tunnel to front-end docker network.
moNK-
17 Nov 2025 02:49
Ahhh
Like in here I suppose:
seat_domain = <dns> pointed to IP?
Asrik
17 Nov 2025 02:50
its just DNS..
moNK-
17 Nov 2025 02:50
Ah kk. I just wasn't sure. Alliance-Auth required a lot more config on the network side
So I was getting confused here with Traefik and such
Ibn Khatab
17 Nov 2025 02:56
I just finished installing SEAT, and when I attempted the first log in I'm getting a 500 in the browser, the laravel log shows
> {"error":"invalidgrant","errordescription":"Invalid authorization code"}
I saw some other people have had this issue and the only resolution they had was to recreate the esi app, I've done that but am still getting the same results.
Full stack trace
Asrik
17 Nov 2025 03:40
did you complete this step?
https://eveseat.github.io/docs/configuration/esi_configuration/
Crypta Electrica
17 Nov 2025 03:43
When using traefik, you do not access seat over an IP as it's using SNI to know how to route your request. If you want to run docker, and access it over an IP then you must use the proxy config. And then there is an env variable for the proxy port you want to use
moNK-
17 Nov 2025 03:43
Yeah no worries I think I'm SLOWLY figuring this out π
The only issue I'm seeing now is when trying to start the Docker I get this error:
2025-11-17 3:06:40 15 [Warning] Access denied for user 'seat'@'172.20.0.4' (using password: YES)
front
In Connection.php line 829:
SQLSTATE[HY000] [1045] Access denied for user 'seat'@'172.20.0.4' (using pa
ssword: YES) (Connection: mysql, SQL: select tablename as
name, (datale
ngth + indexlength) as size, tablecomment as comment, engine as engi
ne, tablecollation as collation from informationschema.tables where ta
bleschema = 'seat' and tabletype in ('BASE TABLE', 'SYSTEM VERSIONED') or
der by table_name)
In Connector.php line 65:
SQLSTATE[HY000] [1045] Access denied for user 'seat'@'172.20.0.4' (using pa
ssword: YES)
I did setup the password in the .env
So I just need to figure out if I need to edit that config file
I'm assuming if I point it to the dns though, it'll probably work
So im gunna try that now
Ibn Khatab
17 Nov 2025 03:46
https://i.imgur.com/zJ8ZkYK.png
Crypta Electrica
17 Nov 2025 03:48
Did you setup the env password for the db after having started it for the first time? If this is the case then it was created with one password and you are now using another.
If you have no data in the db you care about you can just drop the db volume then restart the stack to restore it.
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml down -v
moNK-
17 Nov 2025 03:50
So I did that, can't restart the Docker now though
There we go. I re-ran
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up
after completely redoing the .env file to ensure configs are correct and it's starting up again now.
Ok, so the Docker is up and running. I think my tunnel isn't working properly from cloudflare though.
So I set up the tunnel as https://seat.imperiumcartel.org
and downloaded Cloudflared. Set up the services:
However, I maybe got the internal forward wrong? I'll take a screenshot
And this is the output from the tunnel
Asrik
17 Nov 2025 04:20
Ok.. i understand why... you have to make sure the line for EVEcallbackurl is like this... But to me it looks like an issue that seat is not able to connect to EVE ESI...
``EVECALLBACKURL=${APP_URL}/auth/eve/callback``
you will need to add the tunnel to the "seatbackendend" docket network..
also need to add port 8080
192.168.1.66:8080
docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker_seat-frontend cloudflare/cloudflared:latest tunnel run --token
moNK-
17 Nov 2025 04:30
docker: Error response from daemon: failed to set up container networking: network seat-docker_seat-frontend not found
Asrik
17 Nov 2025 04:30
you will need to check the docker network name
I think this is the command ``docker network ls``
moNK-
17 Nov 2025 04:31
Asrik
17 Nov 2025 04:32
moNK-
17 Nov 2025 04:32
Asrik
17 Nov 2025 04:32
ok.. you need to add ``master`` in the command
moNK-
17 Nov 2025 04:32
Ahh kk
Asrik
17 Nov 2025 04:33
``docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker-master_seat-frontend cloudflare/cloudflared:latest tunnel run --token``
moNK-
17 Nov 2025 04:34
docker: Error response from daemon: Conflict. The container name "/cloudflare-seat" is already in use by container "e5a3bb71d664edd8ffafc20cc91c611bb1b4aa20c349b075f2cf504ed0bda651". You have to remove (or rename) that container to be able to reuse that name.
so docker rm e5a3bb71d664edd8ffafc20cc91c611bb1b4aa20c349b075f2cf504ed0bda651?
Then re-run?
Sorry, never used Docker before and I'm kinda amateur lol
Asrik
17 Nov 2025 04:34
yes
moNK-
17 Nov 2025 04:34
I've set up Alliance Auth a bunch of times, but this is a pain haha
Asrik
17 Nov 2025 04:34
you might have to bring it down first before you can remove it
moNK-
17 Nov 2025 04:35
Alrighty
It gave me a token back
Asrik
17 Nov 2025 04:35
you have to use your token given to you by Claudflare
lol. mee too
moNK-
17 Nov 2025 04:36
Ohhh where --token is
put in my own token
Ok, lemme remove this container lol
Asrik
17 Nov 2025 04:36
no.. not your own.. it when you created a tunnel from cloudflare site
moNK-
17 Nov 2025 04:36
thats what I mean
sorry
Ok so just to confirm
Before I run this command again
docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker-master_seat-frontend cloudflare/cloudflared:latest tunnel run --<insert cloudflare token here>
Asrik
17 Nov 2025 04:39
almost
docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker-master_seat-frontend cloudflare/cloudflared:latest tunnel run --token <insert cloudflare token here>
moNK-
17 Nov 2025 04:40
Thank you!
Ran this
docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker-master_seat-frontend cloudflare/cloudflared:latest tunnel run --token eyJhIjoi* <- is just the whole string
The Docker window gave a token back, no errors.
Ibn Khatab
17 Nov 2025 04:43
no change
Asrik
17 Nov 2025 04:44
did you put your id??
do you have a cloudflare account?
moNK-
17 Nov 2025 04:45
Yes
Asrik
17 Nov 2025 04:48
where it says "4. Run the following command". you can copy the command and past it into a notepad so you can see the full token.
moNK-
17 Nov 2025 04:49
Yeah I did that
Like, I copied the whole token
docker run -d --name cloudflare-seat --restart unless-stopped --network seat-docker-master_seat-frontend cloudflare/cloudflared:latest tunnel run --token eyJhIjoiOWE0NTQ5NTRjZDQ3MTdkMmViYzU5OTQ2MWJmZTA3ZGEiLCJ0IjoiYTk0M2FlM2QtZmViNy00Mjg4LWJmOTUtYmYwOTEwZDk0MTdhIiwicyI6Ik1EZGtPRE***** <- More asterisks to not give the whole token here
Asrik
17 Nov 2025 04:51
obviously its a authorization issue.. seem like an issue with the key or something.. i would double check the key.. otherwise.. maybe someone else may know why..
That would be the issue... there is no asterisks.. so it is missing the rest of the code... also you should generate a new code.
moNK-
17 Nov 2025 04:53
No
I'm adding them in
to hide the code
Unsure if it's bad or not to show full code
Asrik
17 Nov 2025 04:54
ok
moNK-
17 Nov 2025 04:54
if it's unique or w/e
Asrik
17 Nov 2025 04:54
hmm..
moNK-
17 Nov 2025 04:57
So now I'm just getting this error on Cloudflare
So I think IP or Firewall issues
error": "Unable to reach the origin service. The service may be down or it may not be responding to traffic from cloudflared: dial tcp 192.168.1.66:8080: connectex: No connection could be made because the target machine actively refused it.",
"connIndex": 0,
"originService": "https://192.168.1.66:8080",
"ingressRule": 0
}
I port forwarded 8080, 80 and 443, as well as opened all of them on the system and allowed them
Ibn Khatab
17 Nov 2025 04:57
Asrik
17 Nov 2025 04:57
yea.. that is normal because you dont have the tunnel up atm.
moNK-
17 Nov 2025 04:58
I'm so confused lol!
Asrik
17 Nov 2025 05:00
lol
moNK-
17 Nov 2025 05:00
I'm literally so confused π
Asrik
17 Nov 2025 05:00
there is a link since 46 mins
lol
moNK-
17 Nov 2025 09:40
Well, I finally got it working after messing with chatgpt for a while π
Ibn Khatab
17 Nov 2025 16:42
new day, new tz, going to revive this issue π
Haven't made any progress on it
stack trace is attached above
Astral
17 Nov 2025 16:48
recursive_tree
17 Nov 2025 16:55
Most likely something wrong with your SSO setup. Have you gone throught the setup guide? https://eveseat.github.io/docs/configuration/esi_configuration/