This is a little experiment to see if Bantracker can be ported to use MySQL

Branch

https://code.launchpad.net/~ubuntu-bots/ubuntu-bots/bt-mysql

Setup MySQL

MySQL needs AUTO_INCREMENT in INTEGER PRIMARY KEY or it will always fail to get a new id.

• CREATE DATABASE bt; USE bt CREATE TABLE bans (
  • id INTEGER PRIMARY KEY AUTO_INCREMENT, channel VARCHAR(30) NOT NULL, mask VARCHAR(100) NOT NULL, operator VARCHAR(30) NOT NULL, time VARCHAR(300) NOT NULL, removal DATETIME, removal_op VARCHAR(30), log TEXT
  ); CREATE TABLE comments (
  • ban_id INTEGER, who VARCHAR(100) NOT NULL, comment MEDIUMTEXT NOT NULL, time VARCHAR(300) NOT NULL
  ); CREATE TABLE sessions (
  • session_id VARCHAR(50) PRIMARY KEY, user MEDIUMTEXT NOT NULL, time INT NOT NULL
  ); GRANT ALL ON bt.* TO bot@locahost IDENFIED BY password; FLUSH PRIVILEGES;

Configure Plugin

• config plugins.Bantracker.database mysql://bot:password@localhost/bt

Status

* bans seems to be stored correctly * @mark works apparently * <s>@bansearch and @banlog raises an exception</s> FIXED * @bansearch seems to work * @banlog gives a "Error: No log for ID 1 available" thing? * Didn't test anything else.