Hello
List,
We
are trying to use MySQL backend for storing user information and Global Address
Book. We have installed Squirrel Mail 1.4.22. The PHP version is 5.3.3 and
mysql version is 5.1.52. The OS is RHEL 6.1 (64 bit). The following is the
details of the database configuration that we have made:
SquirrelMail
Configuration : Read: config.php (1.4.0)
---------------------------------------------------------
Database
1. DSN for Address Book :
2. Table for Address Book : address
3. DSN for Preferences :
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://root:mysql <at> localhost/mail
9. Table for Global Address Book : address
10.
Allow writing into Global Address Book : false
11.
Allow listing of Global Address Book : true
R Return to Main Menu
C Turn color on
S Save data
Q Quit
Command
>>
The
schema of the address table is as follows:
CREATE TABLE `address` (
`owner` VARCHAR(128) NOT NULL DEFAULT '',
`nickname` VARCHAR(16) NOT NULL DEFAULT '',
`firstname` VARCHAR(128) NOT NULL DEFAULT '',
`lastname` VARCHAR(128) NOT NULL DEFAULT '',
`email` VARCHAR(128) NOT NULL DEFAULT '',
`label` VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`owner`,`nickname`),
KEY `firstname` (`firstname`,`lastname`)
) ENGINE=MYISAM DEFAULT CHARSET=latin1
The content of the table is as follows:
+-------+---------------+-----------+----------+------------------------+---------------------+
| owner | nickname | firstname |
lastname | email
| label |
+-------+---------------+-----------+----------+------------------------+---------------------+
| | Jayanta Ghosh | Jayanta | Ghosh | jayanta.ghosh <at> rp-sg.in | Executive |
+-------+---------------+-----------+----------+------------------------+---------------------+
The configtest.php report is enclosed.
We are going to compose page and clicking on
the addresses button above the message area. We are able to give the search
criteria but while clicking on the search or list all button we get the message
“No persons matching your search were found”.
The server log files shows no errors at
all. Would you kindly help to find out the issue?
With regards,
Goutam