> 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.
How many SquirrelMail installs you have on your machine? Change something else in SquirrelMail configuration and see if it shows up in your SquirrelMail interface. For example - enable message_details or info plugins. -- Tomas ------------------------------------------------------- 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