install_tables.8

NAME

install_tables - create All IndiMail MySQL tables using builtin templates

DESCRIPTION

install_tables can be used to create all MySQL tables used by IndiMail. It can be used when creating a fresh IndiMail(7) installation. It creates the following tables on the local MySQL database

indimail

[step]
indibak

[step]
relay

[step]
atrn_map

[step]
bulkmail

[step]
fstab

[step]
ip_alias_map

[step]
lastauth

[step]
userquota

[step]
valias

[step]
vfilter

[step]
vlimits

[step]
vlog

install_tables will use the host.mysql control file to connect to the local MySQL database.

If you are using a clustered domain, install_tables will additionally create the following MySQL tables on the clusterinfo (See IndiMail(7)).

hostcntrl

[step]
aliasdomain

[step]
dbinfo

[step]
fstab

[step]
host_table

[step]
mgmtaccess

[step]
smtp_port

[step]
vpriv

[step]
spam

[step]
badmailfrom

[step]
badrcptto

[step]
spamdb

install_tables will use the host.master control file to connect to the clusterinfo MySQL database.

It may be noted that IndiMail does not require that any of the MySQL tables to be created prior to use. All tables get created on-the-fly when they get accessed. One can say that install_tables was written by the author because he had nothing better to do with his time.

RETURN VALUE

Returns 0 for success, 1 for any failure.

SEE ALSO

IndiMail(7) vtable(1),