Rotary Payphone Hacking Project (work in progress)

This is a project to turn a rotary payphone into a device to play prerecorded messages when a number is dialed. To accomplish this, we are using python on a single board computer to interface with the phone, which accesses recordings and number information stored in a SQLite database. These entries can be modified and accessed from a control panel written in PHP.

currently only the PHP frontend is functional

Build/Development Environment

This project targets Debian Stable for ease of deployment. Because we target specific tool versions, we use the asdf version manager to help with building and installing tools for development. Once you have the required language extensions and build dependencies for asdf, simply run asdf install within the project folder to install the currently targeted versions.

PHP

This project uses PHP 7.4.33. To install, use the asdf php extension. On macOS, this also involved installing the following build dependencies (in addition to the xcode command line tools): brew install libsodium bison re2c gd libiconv libzip

Python

This project uses Python 3.9.2. To install, use the asdf python extension. This potentially has required build dependencies.

Initialize database

All tools work under the assumption that a database already exists. To create one, use initialize.py and either pre-seed entries with the -e argument or create an empty database using python initialize.py.

Running Control Panel (development)

Once all tools are installed, the development server can be run with php --php-ini=php.ini --docroot=res/ --server=localhost:8000

todo

• [] control bitrate and size of sound files
• [] allow sorting of database entries on dashboard
• [] allow editing dashboard entries

Database Table Schema

Phone number entries

Name: numbers

keys	type	related to
id	INTEGER PRIMARY KEY
number	UNIQUE TEXT
sound	BLOB
filename	TEXT
description	TEXT