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:[EMAIL PROTECTED]/squirrelmail
2. Table for Address Book : address
3. DSN for Preferences :
mysql://squirreluser:[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://squirreluser:[EMAIL PROTECTED]/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@lists.sourceforge.net
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
