temp

http://qmail-sql.digibel.be/install.html
まずpostgresqlは回しておく
http://qmail-sql.digibel.be/downloads/qmail-sql-0....
# tar xzf qmail-1.03.tar.gz
# cd qmail-1.03
# patch -p1 < ../qmail-sql-latest.patch
# patch -s <../qmail-glibc.patch
# vi sql.headers

• I/usr/local/pgsql/include/

/usr/local/pgsql/lib/ を /lib とか /usr/lib とかにコピーししておく

qmailが動いていれば止める

# svc -d /service/pop3/
# svc -d /service/smtpd/
# svc -d /service/qmail/

# make setup check

--

• PostgreSQL database dump

--

SET client_encoding = 'EUC_JP';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--

• Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: dev

--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--

• Name: dotqmails; Type: TABLE; Schema: public; Owner: usermgr; Tablespace:

--

CREATE TABLE dotqmails (

"login" character varying(64) NOT NULL, virtual_host character varying(64) NOT NULL, extension character varying(64) NOT NULL, dotqmail text NOT NULL

);


ALTER TABLE public.dotqmails OWNER TO usermgr;

--

• Name: passwd; Type: TABLE; Schema: public; Owner: usermgr; Tablespace:

--

CREATE TABLE passwd (

"login" character varying(64) NOT NULL, uid integer NOT NULL, gid integer NOT NULL, home character varying(200) NOT NULL, virtual_host character varying(64) NOT NULL, "password" character varying(13), hardquota integer DEFAULT 0, startdate timestamp without time zone DEFAULT now(), stopdate timestamp without time zone, enabled boolean DEFAULT true, use_dotqmail boolean DEFAULT false, lastlogin timestamp without time zone

);


ALTER TABLE public.passwd OWNER TO usermgr;

--

• Data for Name: dotqmails; Type: TABLE DATA; Schema: public; Owner: usermgr

--

COPY dotqmails ("login", virtual_host, extension, dotqmail) FROM stdin;
alias 1test3.tensoutest.com default &xxx+test@gmail.com
\.


--

• Data for Name: passwd; Type: TABLE DATA; Schema: public; Owner: usermgr

--

COPY passwd ("login", uid, gid, home, virtual_host, "password", hardquota, startdate, stopdate, enabled, use_dotqmail, lastlogin) FROM stdin;
alias 1000 100 /home/dev 1test3.tensoutest.com \N 0 2010-04-30 12:55:40.435643 \N t t \N
\.


--

• Name: dotqmails_pkey; Type: CONSTRAINT; Schema: public; Owner: usermgr; Tablespace:

--

ALTER TABLE ONLY dotqmails

ADD CONSTRAINT dotqmails_pkey PRIMARY KEY ("login", virtual_host, extension);

--

• Name: passwd_pkey; Type: CONSTRAINT; Schema: public; Owner: usermgr; Tablespace:

--

ALTER TABLE ONLY passwd

ADD CONSTRAINT passwd_pkey PRIMARY KEY ("login", virtual_host);

--

• Name: dotqmails_login_fkey; Type: FK CONSTRAINT; Schema: public; Owner: usermgr

--

ALTER TABLE ONLY dotqmails

ADD CONSTRAINT dotqmails_login_fkey FOREIGN KEY ("login", virtual_host) REFERENCES passwd("login", virtual_host) ON DELETE CASCADE;

--

• Name: public; Type: ACL; Schema: -; Owner: dev

--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM dev;
GRANT ALL ON SCHEMA public TO dev;
GRANT ALL ON SCHEMA public TO PUBLIC;


--

• Name: dotqmails; Type: ACL; Schema: public; Owner: usermgr

--

REVOKE ALL ON TABLE dotqmails FROM PUBLIC;
REVOKE ALL ON TABLE dotqmails FROM usermgr;
GRANT ALL ON TABLE dotqmails TO usermgr;
GRANT SELECT ON TABLE dotqmails TO userconsult;


--

• Name: passwd; Type: ACL; Schema: public; Owner: usermgr

--

REVOKE ALL ON TABLE passwd FROM PUBLIC;
REVOKE ALL ON TABLE passwd FROM usermgr;
GRANT ALL ON TABLE passwd TO usermgr;
GRANT SELECT ON TABLE passwd TO userconsult;


--

• PostgreSQL database dump complete

--


/var/qmail/control/

• rcpthosts

.tensoutest.com

• locals

(NONE)

• virtualdomains

.tensoutest.com:alias

あとはデフォルト。