|
From: <rap...@ps...> - 2007-09-25 16:41:22
|
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 |