主题: 怎样维护一个RoundCube的公共通讯录
怎样维护一个RoundCube的公共通讯录
让同一域名下的用户都可以看到？
页次 1
支持 Red Hat Enterprise Linux, CentOS, Scientific Linux, Debian, Ubuntu, FreeBSD, OpenBSD
您尚未登陆。 请选择登陆或是注册一个新账号。
iRedMail 开源邮件服务解决方案 » iRedMail 技术支持 » 怎样维护一个RoundCube的公共通讯录
怎样维护一个RoundCube的公共通讯录
让同一域名下的用户都可以看到？
这个我也在关注
插件有 global address book
但不知怎么使用
目前ldap版本，是有全局通讯录，包括domain里的所有用户。
5.1 还是6.0测试版?
恩
看来下
LDAP版本里面的Global Address Book是系统根据LDAP内容自动生成的，全局的
这个我也在关注
插件有 global address book
但不知怎么使用
那个是专门针对mysql版本的。你可以尝试一下。
基于mysql 的全局我已经自己修改完成，并且投入使用
可否分享一下如何实现的？
步骤还挺复杂我先粗略的写下
基于 rc 0.3.1
用到的plugins 是globaladdressbook
1.表结构调整
-- 表的结构 `contacts`
CREATE TABLE IF NOT EXISTS `contacts` (
`contact_id` int(10) unsigned NOT NULL auto_increment,
`changed` datetime NOT NULL default '1000-01-01 00:00:00',
`del` tinyint(1) NOT NULL default '0',
`name` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`firstname` varchar(128) NOT NULL,
`surname` varchar(128) NOT NULL,
`vcard` text,
`user_id` int(10) unsigned NOT NULL default '0',
`global_contact` int(1) NOT NULL default '0',
`firm` varchar(128) default NULL,
`position` varchar(50) default NULL,
`p_tel` varchar(30) default NULL,
`p_fax` varchar(30) default NULL,
`p_mob` varchar(20) default NULL,
`p_address` text,
`w_tel` varchar(20) default NULL,
`w_fax` varchar(20) default NULL,
`w_mob` varchar(20) default NULL,
`w_address` text,
`notice` text,
`email2` varchar(128) default NULL,
`email3` varchar(128) default NULL,
`email4` varchar(128) default NULL,
`birth` varchar(10) default NULL,
PRIMARY KEY (`contact_id`),
KEY `user_contacts_index` (`user_id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;2.globaladdressbook 插件
-- 语言包增加
zh_CN.inc （UTF8编码）
<?php
/* Author: Philip Weir */
$labels = array();
$labels['globaladdressbook'] = '全局联系人';
$messages = array();
?>-- 修改 globaladdressbook.php
public function get_address_book($args)
{
if ($args['id'] === $this->abook_id) {
$args['instance'] = new rcube_contacts(rcmail::get_instance()->db, $this->user_id);
$args['instance']->readonly = $this->readonly;
$args['instance']->global = true; #增加标示为全局
}3.修改 /var/www/roundcubemail/program/include/rcube_contacts.php
class rcube_contacts extends rcube_addressbook
{
var $db = null;
var $db_name = '';
var $user_id = 0;
var $filter = null;
var $result = null;
var $search_fields;
var $search_string;
var $table_cols = array('name', 'email', 'firstname', 'surname', 'global_contact', 'vcard', 'firm', 'position', 'p_tel', 'p_fax', 'p_mob', 'p_address', 'w_tel', 'w_fax', 'w_mob', 'w_address', 'notice', 'email2', 'email3', 'email4', 'birth');
/** public properties */
var $primary_key = 'contact_id';
var $readonly = false;
var $list_page = 1;
var $page_size = 10;
var $ready = false;
var $global = false;
---------------
function list_records($cols=null, $subset=0)
...
$sql_result = $this->db->limitquery(
"SELECT * FROM ".$this->db_name."
WHERE del<>1".
($this->global ? " AND global_contact = 1": " AND user_id=?").
($this->filter ? " AND (".$this->filter.")" : "") .
" ORDER BY name",
----------------
function count()
{
// count contacts for this user
$sql_result = $this->db->query(
"SELECT COUNT(contact_id) AS rows
FROM ".$this->db_name."
WHERE del<>1".
($this->global ? " AND global_contact = 1": " AND user_id=?").
($this->filter ? " AND (".$this->filter.")" : ""),
$this->user_id);
-----------------
function get_record($id, $assoc=false)
...
$this->db->query(
"SELECT * FROM ".$this->db_name."
WHERE contact_id=?".
($this->global ? " AND global_contact = 1": " AND user_id=?").
" AND del<>1",
-----------------
function update($id, $save_cols)
{
$updated = false;
$write_sql = array();
foreach ($this->table_cols as $col)
if (isset($save_cols[$col]))
$write_sql[] = sprintf("%s=%s", $this->db->quoteIdentifier($col), $this->db->quote($save_cols[$col]));
if (!empty($write_sql))
{
$this->db->query(
"UPDATE ".$this->db_name."
SET changed=".$this->db->now().", ".join(', ', $write_sql)."
WHERE contact_id=?".
($this->global ? " AND global_contact = 1": " AND user_id=?").
" AND del<>1",
$id,
$this->user_id);
$updated = $this->db->affected_rows();
}
return $updated;
}
-----------------
function delete($ids)
{
if (is_array($ids))
$ids = join(',', $ids);
$this->db->query(
"UPDATE ".$this->db_name."
SET del=1".
($this->global ? " WHERE global_contact = 1": " WHERE user_id=?").
" AND contact_id IN (".$ids.")",
$this->user_id);
return $this->db->affected_rows();
}4.修改 /var/www/roundcubemail/program/steps/addressbook/show.inc
function rcmail_contact_details($attrib)
...
$a_show_cols = array('name', 'firstname', 'surname', 'global_contact', 'email', 'firm', 'position', 'p_tel', 'p_fax', 'p_mob', 'p_address', 'w_tel', 'w_fax', 'w_mob', 'w_address', 'notice', 'email2', 'email3', 'email4', 'birth');
$microformats = array('name' => 'fn', 'email' => 'email');
foreach ($a_show_cols as $col) {
if (($col=='email' || $col=='email2' || $col=='email3' || $col=='email4') && !empty($record[$col])) {
$value = html::a(array(
'href' => 'mailto:' . $record[$col],
'onclick' => sprintf("return %s.command('compose','%s',this)", JS_OBJECT_NAME, JQ($record[$col])),
'title' => rcube_label('composeto'),
'class' => $microformats[$col],
), Q($record[$col]));
}
else if ($col=='global_contact'){
$value = html::span($microformats[$col], Q($record[$col]==1?'Yes':'No'));
}
else if (!empty($record[$col])) {
$value = html::span($microformats[$col], Q($record[$col]));
}
else
$value = '';
...5.修改 /var/www/roundcubemail/program/steps/addressbook/edit.inc
function rcmail_contact_editform($attrib)
...
$out = "$form_start<table>\n\n";
$a_show_cols = array('name', 'firstname', 'surname', 'global_contact', 'email', 'firm', 'position', 'p_tel', 'p_fax', 'p_mob', 'p_address', 'w_tel', 'w_fax', 'w_mob', 'w_address', 'notice', 'email2', 'email3', 'email4', 'birth');
foreach ($a_show_cols as $col)
{
$attrib['id'] = 'rcmfd_'.$col;
$value = rcmail_get_edit_field($col, $record[$col], $attrib);
if($col == "global_contact"){
$out .= sprintf("<tr><td class=\"title\"><label for=\"%s\">%s</label></td><td>%s</td></tr>\n",
$attrib['id'],
Q(rcube_label($col)),
rcmail_get_edit_field($col, $record[$col], $attrib, 'checkbox'));
} else if(!$value == "")
$out .= sprintf("<tr><td class=\"title\"><label for=\"%s\">%s</label></td><td>%s</td></tr>\n",
$attrib['id'],
Q(rcube_label($col)),
$value);
}
$out .= "\n</table>$form_end";
...6.修改 /var/www/roundcubemail/program/steps/addressbook/save.inc
// setup some vars we need
$a_save_cols = array('name', 'firstname', 'surname', 'global_contact', 'email', 'p_tel', 'firm', 'position', 'p_tel', 'p_fax', 'p_mob', 'p_address', 'w_tel', 'w_fax', 'w_mob', 'w_address', 'notice', 'email2', 'email3', 'email4', 'birth');
$a_record = array();
// read POST values into hash array
foreach ($a_save_cols as $col)
{
$fname = '_'.$col;
if($col == 'global_contact'){
if(isset($_POST[$fname])){
$a_record[$col] = 1;
}else{
$a_record[$col] = 0;
}
}else
if (isset($_POST[$fname]))
$a_record[$col] = get_input_value($fname, RCUBE_INPUT_POST);
}7. 添加 /var/www/roundcubemail/program/localization/zh_CN/labels.inc (UTF8)
$labels['global_contact'] = '全局联系人';
$labels['firm'] = '公司名称';
$labels['position'] = '职务';
$labels['p_tel'] = '电话';
$labels['p_fax'] = '传真';
$labels['p_mob'] = '手机';
$labels['p_address'] = '地址';
$labels['w_tel'] = '工作电话';
$labels['w_fax'] = '工作传真';
$labels['w_mob'] = '工作手机';
$labels['w_address'] = '工作地址';
$labels['notice'] = '备注';
$labels['email2'] = 'E-Mail2';
$labels['email3'] = 'E-Mail3';
$labels['email4'] = 'E-Mail4';
$labels['birth'] = '生日';8. 修改 /var/www/roundcubemail/plugins/globaladdressbook/config.inc.php
这样全局通讯录的管理权限就可以使用了
$rcmail_config['globaladdressbook_readonly'] = true;
// global address book admin user
// either a single username or an array of usernames
$rcmail_config['globaladdressbook_admin'] = array('user1@youdomain','user2@youdomain');这个不错～～～
谢谢分享啊，
好像漏了设置 config.inc.php
Rename this to plugins/globaladdressbook/config.inc.php
'username'
This is the name of the dummy user which holds the global address book.
The username does not have to belong to a valid email account. The username will be stored in the RoundCube database but will not be able to log into RoundCube unless it belongs to a valid email account on your server.
To create a single global address book for everyone who access RoundCube set this options to something like: '[global_addressbook_user]'
To create a global address book per email domain which RoundCube serves set this options to something like: 'lobal_addressbook@%d'
The username can contain the following macros that will be expanded as follows:
%d is replaced with the domain part of the logged in user's username
%h is replaced with the imap host (from the session info)很好的分享，非常不错
希望能加入到0.6中去
0.6中没有，想要试下该功能 。我现在遇到的问题是mysql不能用全局通迅录，ldap无法使用邮件列表（组）功能。有什么方法可以一并实现这两功能，谢谢！
0.6中没有，想要试下该功能 。我现在遇到的问题是mysql不能用全局通迅录，ldap无法使用邮件列表（组）功能。有什么方法可以一并实现这两功能，谢谢！
MySQL 全局地址簿有插件：http://trac.roundcube.net/wiki/Plugin_Repository
LDAP 有邮件列表功能，你可以自己用 phpLDAPadmin 进行维护，或者购买 iRedAdmin-Pro 进行管理。这里是功能列表： http://iredmail.org/admin_panel.html
真是不错，0.60能直接放进安装包就好了
iRedMail 开源邮件服务解决方案 » iRedMail 技术支持 » 怎样维护一个RoundCube的公共通讯录
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 3 official extensions. Copyright © 2003–2010 PunBB.
页面生成时间 0.017 秒, 共执行查询 70 条