On Wed, 20 Dec 2000, Oldarnie wrote:
> Roger Arnold wrote:
>
> Hello Brad,
>
> Thank you for an incredible in-depth reply (all the other help from people was
> great to), you seem to have really hit the mark.
> The only things that I am unsure about is the MySQL part and the Webmail part.
>
> Although I intend to setup MySQL for several other applications that need it,
> I am unsure regarding the database and tables required for Qmail / Vpopmail,
> is there any other documentation regarding setting up MySQL for Qmail /
> Vpopmail / SqWebMail etc., showing how the database and tables should be
> setup, with some good examples and maybe table generation scripts ?
Qmail itself does not use MySQL. But Vpopmail and Qmailadmin can. Vpopmail
will build it's own database and tables if setup correctly. In the
Vpopmail source directory is a file called README.mysql. Follow the
directions in there. You will need to edit the vmysql.h file with the
username and password for mysql. Then you need to do a "make" and a "make
install-strip". I configured and made the programs as the vpopmail user so
that way that user is the owner and not root. You will want to rebuild
the Vpopmail before rebuilding the Qmailadmin. You will just need to do a
configure with the command line I gave you. Then do a "make clean" then a
"make" and a "make install-strip" so that way it compiles in the new
vpopmail header file which is how it knows to use MySQL.
If you do not know much about MySQL I would recommend reading up on it a
little first. It is definately the best way to go. Flat are's are great
for systems with a small amount of virtuals. I am currently moving some
300 virtuals with around 6000 accounts to the MySQL database. If you want
an easy way to manage your MySQL I would recommend phpMyAdmin
(http://phpwizard.net/projects/phpMyAdmin).
> Regarding Webmail, I was looking at FocalMail before I decided to change to
> Qmail as a mail server, do you (or anyone else) know how it would work with
> Vpopmail as it looked to be an incredible webmail package with heaps of
> different themes and features?
>
> All this information has slowed me up somewhat, and I intend to go into
> everything much more thoroughly before I start again, except for Qmail which I
> will setup as just a standard email server to standard pop3 clients, however
> now I have a much better understanding of the whole process thanks to you and
> several other users, who have provided so much more information than I ever
> expected to receive.
>
> Thank you Brad and everyone else that has contributed to my plea for help
>
> Best Regards
> Roger
Well low and behold. Here I was just going to type to wait for FocalMail
2.0 and there it is. It definately looks like a great program. However I
would hold off until they have any bugs worked out. Looks like some nice
new features however.
--
Brad Dameron [EMAIL PROTECTED]
Network Account Executive 877-663-4349
TSCNet Online Services www.tscnet.com
