Classe: Auth_cyrsql  - X-Ref

The Auth_cyrsql class provides a SQL implementation of the Horde
authentication system for the Cyrus IMAP server. Most of the functionality
is the same as for the SQL class; only what is different overrides the
parent class implementations.

Required parameters:<pre>
'cyradmin'  The username of the cyrus administrator.
'cyrpass'   The password for the cyrus administrator.
'imap_dsn'  The full IMAP DSN
(i.e. {localhost:993/imap/ssl/novalidate-cert}).
'phptype'   The database type (ie. 'pgsql', 'mysql', etc.).</pre>

Optional parameters:<pre>
'domain_field'    If set to anything other than 'none' this is used as
field name where domain is stored.
DEFAULT: 'domain_name'
'encryption'      The encryption to use to store the password in the
table (e.g. plain, crypt, md5-hex, md5-base64, smd5,
sha, ssha).
DEFAULT: 'md5-hex'
'folders'         An array of folders to create under username.
DEFAULT: NONE
'password_field'  The name of the password field in the auth table.
DEFAULT: 'password'
'quota'           The quota (in kilobytes) to grant on the mailbox.
DEFAULT: NONE
'table'           The name of the auth table in 'database'.
DEFAULT: 'accountuser'
'unixhier'        The value of imapd.conf's unixhierarchysep setting.
Set this to true if the value is true in imapd.conf.
'username_field'  The name of the username field in the auth table.
DEFAULT: 'username'</pre>

Required by some database implementations:<pre>
'database'  The name of the database.
'hostspec'  The hostname of the database server.
'protocol'  The communication protocol ('tcp', 'unix', etc.).
'username'  The username with which to connect to the database.
'password'  The password associated with 'username'.
'options'   Additional options to pass to the database.
'port'      The port on which to connect to the database.
'tty'       The TTY on which to connect to the database.</pre>


The table structure for the auth system is as follows:

<pre>
CREATE TABLE accountuser (
username    VARCHAR(255) BINARY NOT NULL DEFAULT '',
password    VARCHAR(32) BINARY NOT NULL DEFAULT '',
prefix      VARCHAR(50) NOT NULL DEFAULT '',
domain_name VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE KEY username (username)
);

CREATE TABLE adminuser (
username    VARCHAR(50) BINARY NOT NULL DEFAULT '',
password    VARCHAR(50) BINARY NOT NULL DEFAULT '',
type        INT(11) NOT NULL DEFAULT '0',
SID         VARCHAR(255) NOT NULL DEFAULT '',
home        VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (username)
);

CREATE TABLE alias (
alias       VARCHAR(255) NOT NULL DEFAULT '',
dest        LONGTEXT,
username    VARCHAR(50) NOT NULL DEFAULT '',
status      INT(11) NOT NULL DEFAULT '1',
PRIMARY KEY (alias)
);

CREATE TABLE domain (
domain_name VARCHAR(255) NOT NULL DEFAULT '',
prefix      VARCHAR(50) NOT NULL DEFAULT '',
maxaccounts INT(11) NOT NULL DEFAULT '20',
quota       INT(10) NOT NULL DEFAULT '20000',
transport   VARCHAR(255) NOT NULL DEFAULT 'cyrus',
freenames   ENUM('YES','NO') NOT NULL DEFAULT 'NO',
freeaddress ENUM('YES','NO') NOT NULL DEFAULT 'NO',
PRIMARY KEY (domain_name),
UNIQUE KEY prefix (prefix)
);

CREATE TABLE domainadmin (
domain_name VARCHAR(255) NOT NULL DEFAULT '',
adminuser   VARCHAR(255) NOT NULL DEFAULT ''
);

CREATE TABLE search (
search_id   VARCHAR(255) NOT NULL DEFAULT '',
search_sql  TEXT NOT NULL,
perpage     INT(11) NOT NULL DEFAULT '0',
timestamp   TIMESTAMP(14) NOT NULL,
PRIMARY KEY (search_id),
KEY search_id (search_id)
);

CREATE TABLE virtual (
alias       VARCHAR(255) NOT NULL DEFAULT '',
dest        LONGTEXT,
username    VARCHAR(50) NOT NULL DEFAULT '',
status      INT(11) NOT NULL DEFAULT '1',
KEY alias (alias)
);

CREATE TABLE log (
id          INT(11) NOT NULL AUTO_INCREMENT,
msg         TEXT NOT NULL,
user        VARCHAR(255) NOT NULL DEFAULT '',
host        VARCHAR(255) NOT NULL DEFAULT '',
time        DATETIME NOT NULL DEFAULT '2000-00-00 00:00:00',
pid         VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
</pre>

$Horde: framework/Auth/Auth/cyrsql.php,v 1.33.10.14 2006/08/14 02:48:48 chuck Exp $

Copyright 2002-2006 Ilya <mail@krel.org>
Copyright 2005-2006 Jan Schneider <jan@horde.org>

See the enclosed file COPYING for license information (LGPL). If you
did not receive this file, see http://www.fsf.org/copyleft/lgpl.html.