Hi.
Im a newby to linux, SM, Mysql, so, i need some help.
I installed Debian, apache, php, pear, mysql, SM 1.4.4, and im trying to configure SM to use MySql to store user addresses, and preferences.
What i did, was:
mysql> CREATE DATABASE squirrelmail;
mysql> use squirrelmail;
mysql> CREATE TABLE address (
-> owner varchar(128) DEFAULT '' NOT NULL,
-> nickname varchar(16) DEFAULT '' NOT NULL,
-> firstname varchar(128) DEFAULT '' NOT NULL,
-> lastname varchar(128) DEFAULT '' NOT NULL,
-> email varchar(200) DEFAULT '' NOT NULL,
-> label varchar(255),
-> PRIMARY KEY (owner,nickname),
-> KEY firstname (firstname,lastname)
-> );
mysql> CREATE TABLE global_abook(
-> owner varchar(128) DEFAULT '' NOT NULL,
-> nickname varchar(16) DEFAULT '' NOT NULL,
-> firstname varchar(128) DEFAULT '' NOT NULL,
-> lastname varchar(128) DEFAULT '' NOT NULL,
-> email varchar(200) DEFAULT '' NOT NULL,
-> label varchar(255),
-> PRIMARY KEY (owner,nickname),
-> KEY firstname (firstname,lastname)
-> );
mysql> CREATE TABLE userprefs(
-> user varchar(128) DEFAULT '' NOT NULL,
-> prefkey varchar(64) DEFAULT '' NOT NULL,
-> prefval BLOB DEFAULT '' NOT NULL,
-> PRIMARY KEY (user,prefkey)
-> );
mysql> CREATE TABLE addressgroups(
-> owner varchar(128),
-> nickname varchar(50),
-> addressgroup varchar(50),
-> type varchar(50)
-> );
mysql> GRANT ALL PRIVILEGES ON squirrelmail.* to 'UserHere'@'localhost'
-> IDENTIFIED BY 'PwHere' WITH GRANT OPTION;
then, on SM config, i configured the server, so, it looks like this:
SquirrelMail Configuration : Read: config.php (1.4.0)
---------------------------------------------------------
Database
1. DSN for Address Book : mysql://UserHere:[EMAIL PROTECTED]/squirrelmail
2. Table for Address Book : address
3. DSN for Preferences : mysql://UserHere:[EMAIL PROTECTED]/squirrelmail
4. Table for Preferences : userprefs
5. Field for username : user
6. Field for prefs key : prefkey
7. Field for prefs value : prefval
8. DSN for Global Address Book : mysql://UserHere:[EMAIL PROTECTED]/squirrelmail
9. Table for Global Address Book : global_abook
10. Allow writing into Global Address Book : false
11. Allow listing of Global Address Book : false
I tested the permitions on MySql for the user, and seems OK.
However, after i inserted the user&password on the logon, i get this:
Preference database error (extension not found). Exiting abnormally
I searched for errors, and i could not find any errors on apache logs.
Thankx
