[prev in list] [next in list] [prev in thread] [next in thread] 

List:       squirrelmail-plugins
Subject:    [SM-PLUGINS] Use EGW address book in SquirrelMail (vlogin ans
From:       Raphaël_Pautasso <raphael.pautasso () psi-si ! com>
Date:       2007-09-25 16:35:17
Message-ID: 63281.82.240.162.187.1190738117.squirrel () groupware ! psi-si ! com
[Download RAW message or body]



Hello,
   As i had problems to read emails with the
Felamimail application of Egroupware.
   So i have
installed SquirrelMail in a subfolder (the Nutsmail eye candy version in
facts).
   It works very well :)
   I create
a dummy application to embedded in EGW with an <iframe> tag.
   Now i try to access the  shared address book data from the
EGW database in SquirrelMail.
   At this point, i succeed
!

My HOWTO :

IMAP : Postfix and DoveCot
PHP 5,
Apache 2, Debian 4
Installation from the Nutsmail archive
SquirrelMail version : latest Nutsmail, based on 1.4.10

Install multilogin plug-in (not activate) and apply path  (used the
1.4.9 patch)
Install, activate and configure vlogin ($useSessionBased
= 1;)
In the vlogin config, add for the "tutu" domain :

$addrbook_dsn = 'mysql://toto:AZERTY@localhost/groupware_tutu';
$addrbook_table = 'address';

In the database, create this
VIEW (check of the CONCAT() content):

CREATE OR REPLACE VIEW
address AS
SELECT CONCAT(ea.account_lid, '.tutu') AS owner,
eab.n_fileas AS nickname, eab.n_given AS firstname, eab.n_family AS
lastname,
eab.contact_email AS email, eab.contact_note AS label
FROM egw_addressbook eab, egw_accounts ea
WHERE
length(eab.contact_email) > 1
AND (eab.contact_owner =
ea.account_primary_group OR eab.contact_owner = ea.account_id)

After logout and login, i get the list, both the group and mine 
address book if the email field is not empty.

Now i wish to
make it writable (not from SM, only from EGW).

I have not found
the option or how to overloaded it for the personal address book, as the
addrbook_global_writeable option.

Ideas will be greatly
appreciate.

Regards,
  RRaph



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
--
squirrelmail-plugins mailing list
Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines
List Address: squirrelmail-plugins@lists.sourceforge.net
List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.plugins
List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=3931
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins

[prev in list] [next in list] [prev in thread] [next in thread]