This small Go program is designed to be plugged into Pure-FTPd's authd program, providing authentication against a Paperless-NGX MariaDB or PostgreSQL database.

• Go installed on your machine
• Pure-FTPd with authd support
• MariaDB or PostgreSQL database configured for Paperless-NGX

• Authenticate users against a Paperless-NGX database
• Support for both MariaDB and PostgreSQL databases
• Automatic dependency resolution using Go Modules

1. Clone the repository:

   git clone https://github.com/psych0d0g/pure-ftpd-paperless-dbauth.git

2. Change into the project directory:

   cd pure-ftpd-paperless-dbauth

3. Run the build script to compile the binary:

   ./build.sh

1. Set up environment variables:

   export PAPERLESS_DBHOST="your_database_host" export PAPERLESS_DBPORT="your_database_port" export PAPERLESS_DBNAME="your_database_name" export DB_USER="your_database_user" export PAPERLESS_DBPASS="your_database_password" export PAPERLESS_DBENGINE="postgres" # or "mysql" for MariaDB export PAPERLESS_CONSUMPTION_DIR="your_paperless_consumption_dir"

2. Set up authd configuration to use the compiled binary.

Run the compiled binary to authenticate users against the Paperless-NGX database.

AUTHD_ACCOUNT=username AUTHD_PASSWORD=password ./verify_pw

please refer to pure-ftpd documentation on how to integrate it with authd: https://github.com/jedisct1/pure-ftpd/blob/master/README.Authentication-Modules

Ensure your Paperless-NGX database has a table similar to the following:

CREATE TABLE auth_user ( id SERIAL PRIMARY KEY, username VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_login TIMESTAMP, is_superuser BOOLEAN NOT NULL, first_name VARCHAR(30), last_name VARCHAR(30), email VARCHAR(255), is_staff BOOLEAN NOT NULL, is_active BOOLEAN NOT NULL, date_joined TIMESTAMP NOT NULL );

- Go - The Go Programming Language - github.com/go-sql-driver/mysql - MySQL driver for Go - github.com/lib/pq - PostgreSQL driver for Go 

i am open to any improvement suggestions via issues or pull reqests

This project is licensed under the MIT License - see the LICENSE.md file for details.

- ChatGPT