00:33 <+bridge_> <Assa> csv is not a standard, I don't know if we could instead use json as ddnet already uses it, doesn't it?
08:38 <+bridge_> <ChillerDragon> @heinrich5991 i am muted on irc
08:39 <+bridge_> <ChillerDragon> @learath2 can u do something? heinrich is afk there is no irc spam everyone is muted since forever
08:39 <+bridge_> <ChillerDragon> just remove the channel mute already
08:39 <+bridge_> <ChillerDragon> there is more spam coming from discord mute that instead
10:24 <+bridge_> <heinrich5991> I gave everyone voice on IRC
10:24 <+bridge_> <heinrich5991> the suggestion to mute discord is ridiculous
10:24 <+bridge_> <heinrich5991> if you feel bothered by the spam, I could of course remove the bridge, but I don't think the activity in the IRC channel can sustain itself
11:47 <+bridge_> <learath2> I thought I gave people with Q accs autovoice even
12:10 <+bridge_> <heinrich5991> ChillerDragon: I'd also still suggest fixing your bot to not disconnect every 10 min
12:27 <+bridge_> <remakepower> why I can find teewars website in the git history??
12:27 <+bridge_> <remakepower> 🤔
12:32 <+bridge_> <heinrich5991> teeworlds/teewars website isn't in a git repository
12:32 <+bridge_> <heinrich5991> you can use web.archive.org to view older versions of teeworlds.com
13:19 <+bridge_> <reafesz> https://cdn.discordapp.com/attachments/293493549758939136/1470031391906332925/image.png?ex=6989d0eb&is=69887f6b&hm=5c9f0777039e4358a520d3a6b628c0ac6c06072f39d4b2f6ccc84df156d7d441&
13:19 <+bridge_> <reafesz> https://cdn.discordapp.com/attachments/293493549758939136/1470031392309252319/image.png?ex=6989d0eb&is=69887f6b&hm=4556d0c68e003e20119323c669d699935dbb2d4d5e9bb96b535b0d8bf7c73781&
13:19 <+bridge_> <reafesz> https://cdn.discordapp.com/attachments/293493549758939136/1470031392652919010/image.png?ex=6989d0eb&is=69887f6b&hm=d2b35d3ce56e6503d08cef189f5e6d7e1fa18d32aab0ea61e4ad0070a8c77a2b&
13:20 <+bridge_> <reafesz> https://cdn.discordapp.com/attachments/293493549758939136/1470031393072615516/image.png?ex=6989d0eb&is=69887f6b&hm=98c65914fea72af12b5d86a008776adb7902c3edf4adb1ba3544542b8590b1ea&
13:20 <+bridge_> <milkeeycat> @Discord Mod
13:39 <+bridge_> <chillerdragon> @heinrich5991: how do I fix?
13:40 <+bridge_> <chillerdragon> There is daily discord spam I and yet everyone can talk in ddnet \#developer channel
13:40 <+bridge_> <chillerdragon> Imo we should at least unmute the entire irc channel until the next spam
13:41 <+bridge_> <chillerdragon> There is daily discord spam and yet everyone can talk in ddnet \#developer channel
15:11 <+bridge_> <efetee.> when i try to run my server (ddnet insta ) with a mariadb it crashing after the match ( when i write /statsall) and giving this error : E assert: /DDNet/src/engine/server/databases/mysql.cpp(563): Error in GetInt(1): NULL
15:11 <+bridge_> <efetee.> i edited tables manually but nothing works
15:12 <+bridge_> <efetee.> @chillerdragon how did u solve ( or did it happen ) in your save servers
15:21 <+bridge_> <robyt3> I assume this is dependent on the query you are running or its result. Did you check the stacktrace of the assertion that crashes to figure out which query causes it?
15:28 <+bridge_> <chillerdragon> Oh no that is odd! Never had that in ddnet-insta. As robsi said could you provide a stacktrace? @efetee.
15:29 <+bridge_> <chillerdragon> Did it break before or after you edited the tables?
15:29 <+bridge_> <chillerdragon> Which version do you use? Did you edit the code?
15:34 <+bridge_> <efetee.> yes it did breake , when i first started it worked but after reboot it started to crash when i join , it did disappear after i truncated the tables but started to crash after i did /statsall again , and no i didnt edited and using latest ddnet-insta
15:34 <+bridge_> <efetee.> 2026-02-08 14:32:14 E assert: /DDNet/src/engine/server/databases/mysql.cpp(563): Error in GetInt(1): NULL
15:34 <+bridge_> <efetee.> [Thread 0x7fffedde86c0 (LWP 7729) exited]
15:34 <+bridge_> <efetee.> [Thread 0x7ffff61096c0 (LWP 7724) exited]
15:34 <+bridge_> <efetee.> 
15:34 <+bridge_> <efetee.> Thread 3 "DDNet-Server" received signal SIGILL, Illegal instruction.
15:34 <+bridge_> <efetee.> [Switching to Thread 0x7fffeffff6c0 (LWP 7725)]
15:34 <+bridge_> <efetee.> 0x000055555558e2ac in dbg_assert_imp(char const*, int, char const*, ...) [clone .cold] ()
15:34 <+bridge_> <efetee.> (gdb) bt full
15:34 <+bridge_> <efetee.> #0  0x000055555558e2ac in dbg_assert_imp(char const*, int, char const*, ...) [clone .cold] ()
15:34 <+bridge_> <efetee.> No symbol table info available.
15:34 <+bridge_> <efetee.> #1  0x000055555559e09e in CMysqlConnection::GetInt(int) ()
15:34 <+bridge_> <efetee.> No symbol table info available.
15:34 <+bridge_> <efetee.> #2  0x000055555568e11d in CSqlStats::ShowStatsWorker(IDbConnection*, ISqlData const*, char*, int) ()
15:34 <+bridge_> <efetee.> No symbol table info available.
15:34 <+bridge_> <efetee.> #3  0x000055555559baf5 in CDbConnectionPool::ExecSqlFunc(IDbConnection*, CSqlExecData*, Write) ()
15:34 <+bridge_> <efetee.> No symbol table info available.
15:34 <+bridge_> <efetee.> #4  0x00005555555a1964 in CWorker::Start(void*) ()
15:35 <+bridge_> <efetee.> No symbol table info available.
15:35 <+bridge_> <efetee.> #5  0x00005555556c8bfb in thread_run(void*) [clone .lto_priv.0] ()
15:35 <+bridge_> <efetee.> No symbol table info available.
15:35 <+bridge_> <efetee.> #6  0x00007ffff6a9caa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
15:35 <+bridge_> <efetee.>         ret = <optimized out>
15:35 <+bridge_> <efetee.>         pd = <optimized out>
15:35 <+bridge_> <efetee.>         out = <optimized out>
15:35 <+bridge_> <efetee.>         unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140737219917504, -4724509039640816852, 140737219917504, -384, 0, 140737488279056, -4724509039720508628, -4724523798432558292}, 
15:35 <+bridge_> <efetee.>               mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
15:35 <+bridge_> <efetee.>         not_first_call = <optimized out>
15:35 <+bridge_> <efetee.> #7  0x00007ffff6b29c6c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
15:35 <+bridge_> <efetee.> No locals.
15:35 <+bridge_> <chillerdragon> Latest means selfcompiled today?
15:35 <+bridge_> <efetee.> yesterday
15:36 <+bridge_> <chillerdragon> Which gametype?
15:36 <+bridge_> <chillerdragon> Which host system?
15:36 <+bridge_> <efetee.> fng
15:36 <+bridge_> <chillerdragon> Docker?
15:36 <+bridge_> <efetee.> no
15:37 <+bridge_> <chillerdragon> And what does this sql query show?
15:37 <+bridge_> <chillerdragon> select \* from fng;
15:40 <+bridge_> <efetee.> https://cdn.discordapp.com/attachments/293493549758939136/1470066693500833834/sql_query.txt?ex=6989f1cc&is=6988a04c&hm=855b3afc456c6277380d156de34d1b2be409d850ecaea68fd61969acbdab6308&
15:41 <+bridge_> <efetee.> we did a match but it didnt save cuz not enough players i guess
18:03 <+bridge_> <chillerdragon> How do ppl always manage to get this assert triggered in my mods and I see it nowhere else
18:03 <+bridge_> <chillerdragon> @efetee.: why do you even use Mariadb? Why not use SQLite?
18:04 <+bridge_> <chillerdragon> @efetee.: any chance you would give me ssh access to have a look? Cuz idk what you did and I cant reproduce
18:07 <+bridge_> <efetee.> because i wanted to make stats sysem work in all fng servers and sqlite is poor with connecting to multiple servers
18:08 <+ChillerDragon> so you have multiple linux hosts?
18:10 <+bridge_> <efetee.> i have one binary with multiple configs
18:10 <+ChillerDragon> on one host?
18:10 <+bridge_> <efetee.> yes
18:10 <+ChillerDragon> sqlite3 supports that very well
18:10 <+ChillerDragon> with way less effort
18:10 <+ChillerDragon> its 0 configuration and just works
18:10 <+ChillerDragon> but i would still like to investigate your issue
18:10 <+bridge_> <efetee.> did u made save fng servers with sqlite3
18:11 <+ChillerDragon> to make sure there is no bug in ddnet-insta
18:11 <+ChillerDragon> @efetee. no because i have 3 hosts
18:11 <+ChillerDragon> there sqlite3 becomes more annoying because its 3 different file systems
18:11 <+ChillerDragon> so would you be comfortable with me accessing your server or not? @efetee.
18:12 <+bridge_> <efetee.> sure i can give you ssh access can u send me ur public key
18:12 <+ChillerDragon> https://paste.zillyhuhn.com/rsa
18:14 <+ChillerDragon> @efetee. what is the ip?
18:15 <+bridge_> <efetee.> sended email
18:15 <+ChillerDragon> isnt it a public server? xd
18:16 <+ChillerDragon> Permission denied (publickey).
18:17 <+bridge_> <efetee.> hmm i added second key tho
18:17 <+ChillerDragon> thats so troll of you
18:17 <+ChillerDragon> im not on my laptop right now xd
18:17 <+ChillerDragon> im on the airflow device half the time and the other half i am on the debian one
18:18 <+bridge_> <efetee.> ok added both
18:18 <+ChillerDragon> if i read your trace correctly it crashes here https://github.com/ddnet-insta/ddnet-insta/blob/91677cd1b39f3f6878e3a0223e5f9387a7ca7361/src/insta/server/sql_stats.cpp#L380
18:18 <+ChillerDragon> which would be the first call to GetInt
18:19 <+ChillerDragon> and according to your sql query its non null
18:19 <+ChillerDragon> this reminds me of the ddnet++ issue where the dude installed some goofed mixed of sql libs
18:19 <+bridge_> <efetee.> i am probably same cuz i copy paste from gemini
18:19 <+ChillerDragon> but then again if this is the case for you too i still wonder why i never see this issue reported for like ddnet but only for my mods
18:19 <+ChillerDragon> i still cant access btw :/ 
18:20 <+ChillerDragon> `curl https://paste.zillyhuhn.com/rsa >> ~/.ssh/authorized_keys`
18:21 <+ChillerDragon> ok sure that gemini is a known troll makes sense but still why do no ddnet server owners get trolled by that
18:21 <+ChillerDragon> i wonder if ddnet does something in a way where it is immune to it
18:22 <+ChillerDragon> ddnet code also makes use of `GetInt()` 
18:22 <+ChillerDragon> i still cant ssh btw
18:22 <+bridge_> <efetee.> ok i did curl https://paste.zillyhuhn.com/rsa >> ~/.ssh/authorized_keys
18:23 <+ChillerDragon> i am in ez
18:23 <+bridge_> <efetee.> are u able to login
18:23 <+ChillerDragon> how do i get root access?
18:23 <+bridge_> <efetee.> sudo ?
18:23 <+ChillerDragon> asks for password
18:23 <+bridge_> <efetee.> wait lemme change password and send u
18:23 <+ChillerDragon> you could also add the ssh key to the root user instead
18:24 <+ChillerDragon> `sudo -s`
18:24 <+ChillerDragon>  `mkdir -p /root/.ssh && curl https://paste.zillyhuhn.com/rsa >> /root/.ssh/authorized_keys`
18:24 <+ChillerDragon> then u can keep ur pw untouched
18:24 <+bridge_> <efetee.> sended
18:25 <+bridge_> <efetee.> via email
18:26 <+ChillerDragon> im in
18:26 <+bridge_> <efetee.> can u make a proper server example for me to inspect and change my server structure
18:27 <+ChillerDragon> ok first thing i backdoored my self into /root/.ssh/authorized_keys so i can easily reopen the terminal tab
18:27 <+ChillerDragon> now i will search for the ddnet++ issue that this reminds me of and inspect your installed packages
18:27 <+ChillerDragon> before i change anything i ask you here so dont go afk for a sec
18:27 <+ChillerDragon> sorry @ddnetpeeps for abusing this channel
18:28 <+ChillerDragon> this is the one https://github.com/DDNetPP/DDNetPP/issues/508#issuecomment-3701841090
18:29 <+ChillerDragon> mysql-common/noble,now 5.8+1.1.0build1 all [installed,automatic]
18:29 <+ChillerDragon> libmysqlclient21/noble-updates,noble-security,now 8.0.45-0ubuntu0.24.04.1 amd64 [installed,automatic]
18:29 <+ChillerDragon> yea this looks sus
18:30 <+ChillerDragon> i will compile a pure ddnet now to check if i can reproduce there 
18:30 <+bridge_> <efetee.> oke
18:32 <+ChillerDragon> hmm i guess i would need to add a map to properly test it for ddnet maybe this barrier to entry is the reason why users never run into the assert
18:33 <+ChillerDragon> lol cmake doesnt even pass
18:33 <+ChillerDragon> You must install MySQL to compile the DDNet server with MySQL support
18:33 <+bridge_> <efetee.> i already had
18:33 <+ChillerDragon> what?
18:34 <+bridge_> <efetee.> i did install mysql and compiled ddnett-insta with mysql
18:34 <+ChillerDragon> and did you change installed packages after that?
18:34 <+bridge_> <efetee.> with mysql support *
18:34 <+ChillerDragon> because right now ddnet cant pass the cmake step
18:35 <+bridge_> <efetee.> hmm
18:35 <+bridge_> <efetee.> yes i deleted mysql and installed mariadb
18:35 <+ChillerDragon> yea if you managed to compile it once you have to have changed something 
18:35 <+ChillerDragon> and you didnt recompile?
18:35 <+bridge_> <efetee.> hehe yes i guess
18:36 <+ChillerDragon> possibly its looking for runtime dependency libs and finds ones with matching names that are actually different ones than used for compilation
18:36 <+ChillerDragon> yea so 99% it is lib installation mess as i suspected
18:37 <+ChillerDragon> i wonder how i could avoid that in the future
18:37 <+bridge_> <efetee.> i probably should never use ai for this again
18:37 <+ChillerDragon> i guess my learning for today is to ask for recompilation when this assert is triggered
18:37 <+ChillerDragon> ok let me try to install you the libs that work
18:39 <+ChillerDragon> before i do that
18:39 <+ChillerDragon> do you have any data in the database?
18:39 <+ChillerDragon> or can i nuke it all?
18:41 <+bridge_> <efetee.> sure
18:41 <+ChillerDragon> ok i go nuke
18:41 <+bridge_> <efetee.> u can nuke entire vps
18:41 <+ChillerDragon> u need php-mysql?
18:41 <+ChillerDragon> do u have a website running?
18:44 <+bridge_> <efetee.> y
18:44 <+bridge_> <efetee.> dokuwiki
18:44 <+ChillerDragon> oops i probably broke that
18:44 <+bridge_> <efetee.> also a np
18:45 <+bridge_> <efetee.> np
18:45 <+ChillerDragon> could you email me the url so i can verify it works?
18:45 <+bridge_> <efetee.> wiki.cazar.xyz
18:45 <+ChillerDragon> leak
18:45 <+bridge_> <efetee.> leak what
18:45 <+ChillerDragon> idk xd
18:45 <+ChillerDragon> looks good to me
18:45 <+ChillerDragon> i think it didnt broke
18:45 <+bridge_> <efetee.> yea cuz it doesnt have database
18:46 <+bridge_> <efetee.> writes to direct txt files
18:51 <+ChillerDragon> ok i am done
18:51 <+ChillerDragon> i did the following
18:51 <+ChillerDragon> i uninstalled all apt packages with the name mysql
18:51 <+ChillerDragon> i installed `libmariadb-dev` as recommended by the readme.md 
18:51 <+ChillerDragon> well the readme wants `libmariadb-dev-compat` but eh whatever same same xd
18:52 <+ChillerDragon> i also installed mariadb-server and mariadb-client
18:52 <+ChillerDragon> i recreated your old database based on your teeworlds config file same username and password
18:52 <+ChillerDragon> i removed all my build tests
18:53 <+ChillerDragon> deleted my ssh keys
18:53 <+ChillerDragon> i did not test if it worked because idk how you build stuff xd
18:53 <+ChillerDragon> i am sure it will work now tho
18:53 <+ChillerDragon> what you can do is clean your build directory by ideally deleting it and then build again
18:53 <+ChillerDragon> then when you run the server it should just work
18:53 <+ChillerDragon> i am a little bit curious if it works so let me know if you try that
18:54 <+ChillerDragon> but what i actually recommend is to not use mysql at all it just adds useless complexity if you only have one host
18:54 <+ChillerDragon> sqlite3 will just work with 0 config
18:54 <+ChillerDragon> thanks for trusting me with ssh and using ddnet-insta :)
18:55 <+ChillerDragon> but if this happens one more time to someone im gonna have to figure out a way to smh avoid this
18:55 <+ChillerDragon> there probably is a way to detect this dependency issue at runtime and throw a meaningful error
18:57 <+bridge_> <efetee.> so running 6 fng server with one sqlite database is fine u say ?
19:01 <+ChillerDragon> yes :)
19:02 <+ChillerDragon> sqlite3 is really good tech
20:23 <+bridge_> <milkeeycat> chillerdragon: do you want to help me debug 6502 machine code by any chance? there's a bug somewhere but I don't see it xd
20:33 <+bridge_> <efetee.> chiller which cfg you put sv_redirect_and_shutdown_on_round_end to , because it causes server to stop if i put it in my main cfg file
22:13 <+bridge_> <efetee.> and yes @chillerdragon database works now ( even tho i couldnt save scores in sqlite ) with mariadb
22:15 <+bridge_> <efetee.> and yes @chillerdragon database works now with mariadb ( even tho i couldnt save scores in sqlite )