HOW CAN I CREATE SQUIRRELMAIL AND MAILER? JAMES. 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@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@xxxxxxxx | 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 ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ----- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
