Sopaste

Rust port of Soder's Pastebin.

Introduction

Soder's Pastebin was originally created by Fredrik Soderlund in 2007. The original code runs on a now unsupported version of PHP, and its dependencies have not been upgraded for quite some time. The pastebin is still under active use despite this, so a gentle sunsetting is in order.

The goal of this project is to create a read-only version of Soder's Pastebin, mimicking its original style and functionality. The plan is to go live as soon as the minimal read-only features have been implemented. The creation of new pastes will not be supported, at least not initially.

Database

MySQL is used for storing paste data. The schema matches the original pastebin, allowing both to use the same database. New databases can be initialized using the script below.

CREATE TABLE `list` (
  `id` varchar(9) NOT NULL,
  `name` tinytext DEFAULT NULL,
  `description` text DEFAULT NULL,
  `language` tinytext DEFAULT NULL,
  `start` int(11) DEFAULT NULL COMMENT 'line number start',
  `password` tinytext DEFAULT NULL,
  `ip` tinytext DEFAULT NULL,
  `proxy` tinytext DEFAULT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `checked` date DEFAULT NULL,
  `size` double DEFAULT NULL,
  `removed` tinyint(1) NOT NULL DEFAULT 0,
  `parent` varchar(9) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `text` (
  `id` varchar(9) NOT NULL,
  `text` longtext DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE INDEX parent ON list (parent);

Running

This project requires a recent version of Rust. First, set the environment variables SOPASTE_BINDING and SOPASTE_DATABASE. See MySqlConnection for information about database connection strings. Then, Simply invoke cargo to build and start the local development server.

$ export SOPASTE_BINDING='[::1]:8000'
$ export SOPASTE_DATABASE='mysql://user:pass@host/database?charset=latin1'
$ cargo run

When running, the pastebin should be available on localhost. Make sure to use a release build instead for deployment to a public server.

$ cargo build --release

The executable server binary will be placed in the target directory.

License

Licensed under GNU Affero General Public License v3.0.

• Copyright (C) 2008, Fredrik Soderlund.
• Copyright (C) 2021, Joakim Soderlund.

See license.txt for more information.