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
image: image.png
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
image: image.png
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?
image: image.png
iulixxi 30 Oct 2025 20:06
Got aquestion... I get tons of errors like this lately. Any thoughts?
image: image.png
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
Problem: Jobs execute successfully (DONE in 50-150ms) but save zero data to 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
Not working:
  • characterskills, characterwalletjournals, characterassets = always 0
  • 200+ jobs processed, 0 data saved
Tried:
  • Cleared ESI cache (rm -rf storage/eseye/*) multiple times
  • Changed QUEUE_CONNECTION from sync to database
  • VACUUM database
  • Verified scopes (all correct)
  • Attempted applying PR

    443

Observations:
  • 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?
Questions: 1. Anyone running SeAT 5.x on Render.com with external PostgreSQL successfully? 2. Related to PR

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_logs for example? (about 1.4G)
  • Do I need all that is named seat-storage in Docker?
  • there are multiple, dated files in sde/ subdirectory -- needed?
  • assuming we want to keep eseye folder as is?
Thanks!
recursive_tree 7 Nov 2025 15:12
  • deleting the contents of api_token_logs should 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
as always, create a backup before such operations
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
image: image.png
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
image: image.png
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.
image: image.png
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
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
hey, I am setting up a seat instance for the first time. I have deplpyed fine, docs are great for that but I am having some trouble with roles. Are corp directors always automatically allowed to see all members, and all corp details? If I add a corp director character they have 0 roles but can still see all corp members, but the seat docs state that the default rules deny access. search is strong: https://discord.com/channels/821361165791133716/1339002325154529392/1339202570064756818
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.
image: image.png
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 / { try
files \$uri \$uri/ /index.php?\$querystring; }

PHP-FPM configuration.

location ~ \.php\$ { try
files \$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?
image: image.png
image: image.png
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.
image: image.png
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:
image: image.png
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
file: message.txt
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
image: image.png
image: image.png
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:
image: image.png
However, I maybe got the internal forward wrong? I'll take a screenshot
image: image.png
And this is the output from the tunnel
image: image.png
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
image: image.png
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
image: image.png
Asrik 17 Nov 2025 04:32
image: image.png
moNK- 17 Nov 2025 04:32
image: image.png
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>
image: image.png
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
I know nothing about the CF config I think thats the wrong IP Address. NVM, using tunnel
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!
image: image.png
image: image.png
image: image.png
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 πŸ˜„
image: image.png
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
probably doesn't help using docker desktop
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/