cloudxtreme / hostadmin Goto Github PK

== Web Administation on Rails

== Things that need to be done
Write better readme :) 

Aliases - need to figure out a better way to display them so we can see multiple aliases for a single user. May require a new database layout

Deployment Scripts?
	Autogenerate database config file
	Autogenerate postfix config file(s)
	Change sync script to do the right thing


Configs:

Modify name of hosting environment in environment.rb

=======mysql-domains=======
user = postfix
password = Ucibtoc%

# The database name on the servers.
dbname = gladosadmin

# For Postfix 2.2 and later The SQL query template.
# See mysql_table(5) for details.
query = SELECT domains.name FROM domains WHERE domains.name = '%s' AND domains.email = '1'

hosts = 127.0.0.1
=======mysql-virtual-alias-maps=======
user = postfix
password = Ucibtoc%

# The database name on the servers.
dbname = gladosadmin

# For Postfix 2.2 and later The SQL query template.
# See mysql_table(5) for details.
query = SELECT destinations.destination as destination FROM mailalias_destinations as destinations, mailalias_sources as sources, domains WHERE sources.source='%u' AND domains.name='%d' AND sources.domain_id = domains.id AND sources.id = destinations.mailalias_source_id

hosts = 127.0.0.1
=======mysql-virtual-users=======
user = postfix
password = Ucibtoc%

# The database name on the servers.
dbname = gladosadmin

# For Postfix 2.2 and later The SQL query template.
# See mysql_table(5) for details.
query = SELECT CONCAT(U.name, '@',D.name) FROM mailusers AS U LEFT JOIN domains AS D ON U.domain_id=D.id WHERE CONCAT(U.name, '@',D.name)='%s'

hosts = 127.0.0.1