|
Hi, I am
trying you use MySQL to set up a global address book. I have set it up using
the how to on the SquirrelMail site. Here is my table set up: Database:
squirrelmail Table: global Rows: 1 +-----------+--------------+------+-----+---------+-------+---------------------------------+ |
Field |
Type | Null | Key | Default |
Extra |
Privileges
| +-----------+--------------+------+-----+---------+-------+---------------------------------+ |
owner | varchar(128) | |
PRI |
| | select,insert,update,references | |
nickname | varchar(16) | | PRI
|
| | select,insert,update,references | |
firstname | varchar(128) | | MUL
|
| | select,insert,update,references | |
lastname | varchar(128) |
| |
| | select,insert,update,references | |
email | varchar(128) |
| | |
| select,insert,update,references | |
label | varchar(255) | YES
| |
| | select,insert,update,references | +-----------+--------------+------+-----+---------+-------+---------------------------------+ I have configured SquirrelMail using conf.pl as below: Database 1. DSN for Address Book :
mysql://squirreluser:sqpassword@localhost/squirrelmail 2. Table for Address Book : address 3. DSN for Preferences :
mysql://squirreluser:sqpassword@localhost/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://squirreluser:sqpassword@localhost/squirrelmail 9. Table for Global Address
Book : global 10. Allow writing into Global Address Book : true 11. Allow listing of Global Address Book : true The
address and userprefs tables work correctly. However the global one will
not allow a user to add contacts or list existing contacts. Whenever you choose
to add someone to the global address book it put the new contact in users
personal address book. Any help would be much appreciated. Thanks Erin
Holman |
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
