Forum teuk.org

TeuK  Admin

Member since 2025-12-22 09:24:20Z · 6mo ago

Total posts: 149  ·  Total topics: 146


Topics (page 2/15)

← PrevPage 2 / 15Next →

Posts (page 13/15)

In topic Mediabot 3.1 is out · 2mo ago

Mediabot 3.1 is out

After a long time in beta, Mediabot v3 3.1 is finally out as a proper stable release.

This release is not just another snapshot.
The goal was to make Mediabot easier to install, easier to validate on a fresh system, more predictable to operate, and better documente…

From Fresh Debian 13 to Mediabot 3.1

A lot of work has gone into mediabot_v3 recently, and one of the most useful parts of it was not glamorous at all:

a real install test from scratch on a fresh Debian 13 system.

That kind of test is brutally honest. It does not care that the bot “work…

In topic Mediabot 3.1 is getting closer · 2mo ago

A new stabilization pass has just landed in mediabot_v3, and this one was not about shiny features.

It was about removing friction, tightening weak spots, and making the bot feel less like a long-running beta and more like something that can finally be released with confidence.

What was i…

A new cleanup pass has just landed in mediabot_v3, this time focused on URL title handling.

The goal was not to add flashy features. The goal was to make link detection and title extraction more reliable, more consistent, and far less annoying to debug.

What changed

This round of work …

Snape didn’t teach potions by calling a house elf to do the brewing for him. Similarly, asking MariaDB to hash your passwords for you when you can perfectly well do it in Perl — with the same algorithm, without the round-trip — is an unnecessary dependency. Class is in session.


The Pr…

The Incident

Every time a user joined a channel, this appeared in the logs:

[DEBUG1] userOnJoin() SQL Error: Unknown column 'id_user_level' in 'SELECT'
         Query: SELECT id_channel, notice, id_user_level FROM CHANNEL WHERE name = ?

id_user_level has never existed in the…

Mediabot cleanup: command status fixes, schema alignment, and safer command handling

A new cleanup pass has just been completed on mediabot_v3, with a focus on reliability and consistency rather than new features.

What was fixed

This round of work mainly addressed command management …

“CONSTANT VIGILANCE!” — Mad-Eye Moody, probably staring at a DBI statement handle that was never closed.


The Problem Nobody Noticed (Until Now)

The previous audit session fixed the obvious statement handle leaks. This one went deeper — into the nested my $sth shadows, the early `…

1. DBD::MariaDB Migration

The database driver was migrated from the legacy DBD::mysql to DBD::MariaDB throughout the entire codebase.

All DSN strings were updated from DBI:mysql: to DBI:MariaDB:, with host forced to 127.0.0.1 (MariaDB refuses port-based connections when `localho…

A new cleanup and hardening pass just landed in mediabot_v3.

Commit:
⚡ Stupefy fuzzy matches: unified hostmask magic and taught Mediabot stricter SQL spells

This round was focused on reliability rather than flashy features.

What changed

  • unified hostmask matching logic in…
← PrevPage 13 / 15Next →