These are scripts for automated managing virtual hosts under Apache+MySQL+FTPd. #General Account data is stored in MySQL database.

To synchronize account info in base with actual one should use update.py

To create backup run backup.py.

There is no built-in GUI for managing accounts. One should use PhpMyAdmin or console mysql client to make changes.

Currently, scripts are incapable to update passwords, delete or rename accounts, restore backups (script is broken), add entries to logrotate, update specific users, and update some configuration files.

#Managing account information Make changes in DB using your favourite MySQL client, and then use

python update.py

to apply changes.

Specificially, update.py does (for each account, in that order):

• Generate FTP and SQL passwords, if these fields are empty
• Set `root` field to default one, if field is empty
• Create SQL database, if one doesn't exist
• Add entry to `hosts` file (entry is `127.0.0.1 .mysqlserver), if one doesn't exist
• Create account for ftpd, if one doesn't exist
• Create entry in apache, if one doesn't exist

#Creating backups backup.py is script for backups. Syntax is:

backup.py [-nosql] [-nofiles] [-only users] [-upload]

-nosql no MySQL dump will be made and included in backup.

-nofiles files won't be backupped.

-only users create backups for specified users only. users should be comma-separated list of account names.

-upload upload backups to FTP

#Configuration files ##config.cfg Main configuration file. Structure:

[main]
host=MySQL host
user=MySQL user
passwd=MySQL password
db=<DB with account information table (named vhosts)
ftpdb=<FTPd DB>
root=<default site root>
apachedir=<Apache site configuration files' directory>
backhost=<FTP host>
backuser=<FTP login>
backpass=<FTP password>
directory=<backup directory>

##template.conf Apache site config template. One can use following expressions in config (they will be replaced with actual user info):

%HOSTNAME% - user hostname

%ROOT% - user root

%CUSTOM% - user 'custom' field