SquirrelMail and MySQL<\/p>\n
SquirrelMail can use a database backend like MySQL to store address books and preferences. This article describes how to configure SquirrelMail to use a MySQL address book.
\nyum install1. Install the requirements using the command below.<\/p>\n
yum install mysql-server php-pear-DB<\/p>\n
Service Configuration2. Start the mysqld service. Learn how to start and stop services here.
\nCreate Postfix Admin db3. Launch the MySQL command line tool using the command below.<\/p>\n
mysql -u root -p<\/p>\n
The default root password of MySQL is a blank password. Next, create a new MySQL database for SquirrelMail using the commands below.<\/p>\n
mysql> CREATE DATABASE squirrelmail;
\nmysql> CREATE USER squirrelmail@localhost IDENTIFIED BY ‘your_password’;
\nmysql> GRANT ALL PRIVILEGES ON squirrelmail.* TO squirrelmail;
\nmysql> USE squirrelmail;
\nmysql> CREATE TABLE address (
\nowner varchar(128) DEFAULT » NOT NULL,
\nnickname varchar(16) DEFAULT » NOT NULL,
\nfirstname varchar(128) DEFAULT » NOT NULL,
\nlastname varchar(128) DEFAULT » NOT NULL,
\nemail varchar(128) DEFAULT » NOT NULL,
\nlabel varchar(255),
\nPRIMARY KEY (owner,nickname),
\nKEY firstname (firstname,lastname)
\n);
\nmysql> CREATE TABLE global_abook (
\nowner varchar(128) DEFAULT » NOT NULL,
\nnickname varchar(16) DEFAULT » NOT NULL,
\nfirstname varchar(128) DEFAULT » NOT NULL,
\nlastname varchar(128) DEFAULT » NOT NULL,
\nemail varchar(128) DEFAULT » NOT NULL,
\nlabel varchar(255),
\nPRIMARY KEY (owner,nickname),
\nKEY firstname (firstname,lastname)
\n);<\/p>\n
yum install4. Configure SquirrelMail the command below.<\/p>\n
\/usr\/share\/squirrelmail\/config\/conf.pl<\/p>\n
Select menu 9, Database and update the values of the following.<\/p>\n
DSN for Address Book : mysql:\/\/squirrelmail:password@localhost\/squirrelmail
\nDSN for Global Address Book : mysql:\/\/squirrelmail:password@localhost\/squirrelmail
\nAllow writing into Global Address Book : true
\nAllow listing of Global Address Book : true<\/p>\n","protected":false},"excerpt":{"rendered":"
SquirrelMail and MySQL SquirrelMail can use a database backend like MySQL to store address books and preferences. This article describes how to configure SquirrelMail to use a MySQL address book. yum install1. Install the requirements using the command below. yum … \u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435