Lightweight blogging with PivotX

Introduction

PivotX is the next generation of the now defunct, self-hosted Pivot. Unlike its predecessor, PivotX can save data into either flat files or MySQL.

Setup

1. On the web server, using MySQL, create a database and an admin user
1. mysql> CREATE DATABASE pivotx;
2. mysql> CREATE USER 'pivotxadmin'@'localhost' IDENTIFIED BY 'test';
3. mysql> GRANT ALL PRIVILEGES ON pivotx.* TO 'pivotxadmin'@'localhost' WITH GRANT OPTION;
4. mysql> SHOW GRANTS FOR 'pivotxadmin'@'localhost';
5. mysql> EXIT
6. # mysql -u pivotxadmin -p
7. mysql> EXIT
2. cd /var
3. wget -c http://pivotx.net/files/pivotx_latest.zip -O pivotx_latest.zip
4. unzip -d ./www pivotx_latest.zip
5. chmod ./www/images/
6. chmod ./www/pivotx/templates/ (templates_internal)
7. chmod ./www/pivotx/db/
8. http://srv/
9. Set a username/password

Post-setup Customizing

Get rid of the right-hand column (Tag Cloud, etc.)

Disable comments

Administration

http://srv/pivotx/

Data backup/restore

Security

Q&A

Keeping URL's clean?

http://192.168.0.8:8787/pivotx/?e=1

Preventing SPAM and trolls?

Entry vs. Page?

Page = static stuff. Entry = dynamically built from DB.

Categories?

Site vs. Weblog?

No French UI for users?

Is Cache ready for production?

If not, another way to generate static HTML to avoid calling PHP/MySQL for every read?

Resources