Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- You are now connected to database "mail".
- mail=#
- mail=# -- virtual mailboxes
- mail=# CREATE TABLE mailbox (
- mail(# usernameVARCHAR(128) NOT NULL,
- mail(# domain
- mail(# domainVARCHAR(128) NOT NULL,
- mail(# passwordCHAR(32) NOT NULL,
- mail(# quota
- mail(# quotaINTEGER DEFAULT 1024 NOT NULL,
- mail(# active
- mail(# activeBOOLEAN DEFAULT true NOT NULL,
- mail(# PRIMARY KEY (username, domain)
- mail(# );
- ERROR: syntax error at or near "("
- LINE 2: usernameVARCHAR(128) NOT NULL,
- ^
- mail=#
- mail=# -- virtual mailbox aliases
- mail=# CREATE TABLE mailbox_aliases (
- mail(# address
- mail(# addressVARCHAR(256) PRIMARY KEY,
- mail(# dest_usernameVARCHAR(128) NOT NULL,
- mail(# dest_domainVARCHAR(128) NOT NULL,
- mail(# active
- mail(# activeBOOLEAN DEFAULT true NOT NULL,
- mail(# FOREIGN KEY (dest_username, dest_domain) REFERENCES mailbox (username, domain) ON DELETE CASCADE
- mail(# );
- ERROR: syntax error at or near "("
- LINE 2: addressVARCHAR(256) PRIMARY KEY,
- ^
- mail=#
- mail=# -- relay domains
- mail=# CREATE TABLE mailbox_relay_domains (
- mail(# domain
- mail(# domainVARCHAR(256) PRIMARY KEY,
- mail(# active
- mail(# activeBOOLEAN DEFAULT true NOT NULL
- mail(# );
- ERROR: syntax error at or near "("
- LINE 2: domainVARCHAR(256) PRIMARY KEY,
- ^
- mail=#
- mail=#
- mail=#
- mail=# -- grant permissions
- mail=# GRANT SELECT ON mailbox TO dovecot;
- ERROR: relation "mailbox" does not exist
- mail=# GRANT SELECT ON mailbox,mailbox_aliases,mailbox_relay_domains TO postfix;
- ERROR: relation "mailbox" does not exist
- mail=#
- mail=# -- create virtual domain
- mail=# -- currently virtual domains doesn't work for me
- mail=# INSERT INTO domains_relay_domains VALUES ('tingletingle.de');
- ERROR: relation "domains_relay_domains" does not exist
- LINE 1: INSERT INTO domains_relay_domains VALUES ('tingletingle.de')...
- ^
- mail=#
- mail=# -- create user
- mail=# INSERT INTO mailbox VALUES ('test','tingletingle.de','MD5 Hash of password');
- ERROR: relation "mailbox" does not exist
- LINE 1: INSERT INTO mailbox VALUES ('test','tingletingle.de','MD5 Ha...
- ^
- mail=#
- mail=# -- create virtual aliases
- mail=# INSERT INTO mailbox_aliases VALUES ('postmaster@tingletingle.de', 'test', 'tingletingle.de');
- ERROR: relation "mailbox_aliases" does not exist
- LINE 1: INSERT INTO mailbox_aliases VALUES ('postmaster@tingletingle...
- ^
- mail=# INSERT INTO mailbox_aliases VALUES ('root@tingletingle.de', 'test', 'tingletingle.de');
- ERROR: relation "mailbox_aliases" does not exist
- LINE 1: INSERT INTO mailbox_aliases VALUES ('root@tingletingle.de', ...
- ^
- mail=# INSERT INTO mailbox_aliases VALUES ('example@tingletingle.de', 'test', 'tingletingle.de');
- ERROR: relation "mailbox_aliases" does not exist
- LINE 1: INSERT INTO mailbox_aliases VALUES ('example@tingletingle.de...
- ^
- mail=# INSERT INTO mailbox_aliases VALUES ('abuse@tingletingle.de', 'test', 'tingletingle.de');
- ERROR: relation "mailbox_aliases" does not exist
- LINE 1: INSERT INTO mailbox_aliases VALUES ('abuse@tingletingle.de',...
- ^
- mail=#
- mail=# -- create roundcube and database
- mail=# CREATE USER roundcube ENCRYPTED password 'RoundcubePassword';
- ERROR: role "roundcube" already exists
- mail=# CREATE DATABASE webmail WITH OWNER roundcube;
- ERROR: database "webmail" already exists
- mail=# \c - roundcube
- psql (8.4.17)
- You are now connected to database "mail" as user "roundcube".
- mail=>
- mail=> -- create tables etc for roundcube
- mail=> \i /usr/local/www/roundcube/SQL/postgres.initial.sql
- /usr/local/www/roundcube/SQL/postgres.initial.sql: No such file or directory
- mail=>
- mail=> -- exit psql
- mail=> \q
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement