When I installed vpopmail I forgot to comment out the large site DB so
the only table that got created was relay.  I found this out when I
tried entering test.com so I tried reinstalling vpopmail and when I
added test.com I was told it already existed, so after a poke around the
source code I ran this query:

CREATE TABLE vpopmail (pw_name CHAR(32) not null, pw_domain VARCHAR(223)
not null, pw_passwd VARCHAR(255) not null, pw_uid INT, pw_gid INT,
pw_gecos VARCHAR(255), pw_dir VARCHAR(255), pw_shell VARCHAR(255),
primary key (pw_name, pw_domain));

But when I tried to delete test.com  I got this:

could not delete dir control table delete from dir_control where domain
= 'test.com'

I've since looked further and found a table that I think this should
cover:

CREATE TABLE lastauth (user CHAR(32) not null, domain VARCHAR(223) not
null, remote_ip CHAR(18) not null, timestamp DATETIME not null, primary
key (user, domain));

but the only match I can think of between those 2 is pw_dir but I'm not
sure about that either.

Any hints about either databases to create or a way to reinstall and
loose test.com?

TIA
Kevin
-- 
[EMAIL PROTECTED]

Reply via email to