Hello there!
I am using Debian Sarge,
with the Squirrelmail package provided by Debian (v. 1.4.4) and mysql
4.0.24 provided by the Debian repository, too.
We are trying to migrate from the file based global_abook to the
database driven one.
the table was created using the following command:
CREATE TABLE sm_abook_global (
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(128) DEFAULT '' NOT NULL,
label varchar(255),
PRIMARY KEY (owner,nickname),
KEY firstname (firstname,lastname)
);
The preferences and personal abook were also created, they work
perfectly.
Just the global addressbook doesn't show up in squirrelmail. I have
made some dummy entries to test this, with no luck.
The (important) Squirrelmail configuration:
$default_use_javascript_addr_book = true;
$abook_global_file = '';
$abook_global_file_writeable = false;
$addrbook_dsn = 'mysql://user:[EMAIL PROTECTED]/mail';
$addrbook_table = 'sm_abook';
$prefs_dsn = 'mysql://user:[EMAIL PROTECTED]/mail';
$prefs_table = 'sm_userprefs';
$prefs_user_field = 'user';
$prefs_key_field = 'prefkey';
$prefs_val_field = 'prefval';
$addrbook_global_dsn = 'mysql://user:[EMAIL PROTECTED]/mail';
$addrbook_global_table = 'sm_abook_global';
$addrbook_global_writeable = false;
$addrbook_global_listing = true;
I have searched the archives and the internet, and didn't come up
with a solution.
Best Regards,
Martin Weil
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
--
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
