Bt-mysql

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.

UbuntuBots/Bt-mysql (last edited 2012-01-20 19:54:05 by alanbell)