↑戻る |
データ・ベースに個人のアドレス帳や個人プリファレンスを格納 |
2003/04/12 |
Postgreサーバ | localhost |
DB名 | squirrelmail |
DBユーザ名 | squirreluser |
DBユーザ・パスワード | sqpassword |
DSN(データソース名) | pgsql://squirreluser:sqpassword@localhost/squirrelmail |
# su - postgres $ createuser -P squirreluser Enter password for user "squirreluser": sqpassword Enter it again: sqpassword Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y CREATE USER |
$ createdb -U squirreluser squirrelmail createdb $ psql -l List of databases Name | Owner | Encoding --------------+--------------+---------- squirrelmail | squirreluser | EUC_JP |
# su - postgres $ vi sq_address.sql CREATE TABLE "address" ( "owner" varchar(128) NOT NULL, "nickname" varchar(16) NOT NULL, "firstname" varchar(128) NOT NULL, "lastname" varchar(128) NOT NULL, "email" varchar(128) NOT NULL, "label" varchar(255) NOT NULL, CONSTRAINT "address_pkey" PRIMARY KEY ("nickname", "owner") ); CREATE INDEX "address_firstname_key" ON "address" ("firstname", "lastname"); $ psql -U squirreluser squirrelmail < sq_address.sql |
# su - postgres $ vi sq_pref.sql CREATE TABLE "userprefs" ( "username" varchar(128) NOT NULL, "prefkey" varchar(64) NOT NULL, "prefval" text, CONSTRAINT "userprefs_pkey" PRIMARY KEY ("prefkey", "username") ); $ psql -U squirreluser squirrelmail < sq_pref.sql |
$ ./configure SquirrelMail Configuration : Read: config.php (1.4.0) --------------------------------------------------------- Main Menu -- 1. Organization Preferences 2. Server Settings 3. Folder Defaults 4. General Options 5. Themes 6. Address Books (LDAP) 7. Message of the Day (MOTD) 8. Plugins 9. Database D. Set pre-defined settings for specific IMAP servers C. Turn color on S Save data Q Quit Command >> 9 SquirrelMail Configuration : Read: config.php (1.4.0) --------------------------------------------------------- Database 1. DSN for Address Book : pgsql://squirreluser:sqpassword@localhost/squirrelmail 2. Table for Address Book : address 3. DSN for Preferences : pgsql://squirreluser:sqpassword@localhost/squirrelmail 4. Table for Preferences : userprefs 5. Field for username : username 6. Field for prefs key : prefkey 7. Field for prefs value : prefval R Return to Main Menu C. Turn color on S Save data Q Quit Command >> s |