Ebroch at 14:02, 25 April 2024

2024-04-25T14:02:56Z

← Older revision		Revision as of 08:02, 25 April 2024
Line 1:		Line 1:
	User_Tips_%26_Tricks#WebMail\|Back]]<br><br>		[[User_Tips_%26_Tricks#WebMail\|Back]]<br><br>
	From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html		From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html

Ebroch at 14:02, 25 April 2024

2024-04-25T14:02:43Z

← Older revision		Revision as of 08:02, 25 April 2024
Line 1:		Line 1:
	[[User_Tips_%26_Tricks#~~Webmail_Client~~\|Back]]<br>		User_Tips_%26_Tricks#WebMail\|Back]]<br><br>
	From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html		From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html

Ebroch at 14:01, 25 April 2024

2024-04-25T14:01:06Z

← Older revision		Revision as of 08:01, 25 April 2024
Line 1:		Line 1:
			[[User_Tips_%26_Tricks#Webmail_Client\|Back]]<br>
	From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html		From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html

Ebroch: Created page with "From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html Below are my way to provide Squirrelmail Global Address Book for my users. 1. create sqweb_gabook.sh and sqweb_gabook.php in one folder 2. chmod +x sqweb_gabook.sh 3. edit parameters on both files 4. run sqweb_gabook.sh for first time 5. edit squirrelmail config to load your newly created global address book. More info: http://www.squirrelmail.org/docs/admin/admin-7.html#ss7.5 6. to..."

2024-03-16T17:01:36Z

Created page with "From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html Below are my way to provide Squirrelmail Global Address Book for my users. 1. create sqweb_gabook.sh and sqweb_gabook.php in one folder 2. chmod +x sqweb_gabook.sh 3. edit parameters on both files 4. run sqweb_gabook.sh for first time 5. edit squirrelmail config to load your newly created global address book. More info: http://www.squirrelmail.org/docs/admin/admin-7.html#ss7.5 6. to..."

New page

From: http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg14851.html

Below are my way to provide Squirrelmail Global Address Book for my users.

1. create sqweb_gabook.sh and sqweb_gabook.php in one folder

2. chmod +x sqweb_gabook.sh

3. edit parameters on both files

4. run sqweb_gabook.sh for first time

5. edit squirrelmail config to load your newly created global address book. More info: http://www.squirrelmail.org/docs/admin/admin-7.html#ss7.5

6. to provide latest global address book in your Webmail you may want run this script daily or weekly via crontab

This scripts are far more than perfect but atleast it does it job to provide me a global address book for my company domain.

#!/bin/bash
# sqweb_gabook.sh
# squirrelmail global address book updater
#
# PakOgah <pakogah@pala.bo-tak.info>
# ver 0.1 (2 Aug 2007)
# - initial script
# ver 0.3 (3 Aug 2007)
# - add full path and test if php script exist
# - add detail documentation
#
# need more enhancements
# - use 2 script to create one global address book, if it were only 1 script it would be simpler
# - these scripts only can generate one global address book for one domain
# - and thus 1 global address book is configured with your Squirrelmail
# so if your webmail support multidomain, the global address book didn't
# - can't update dynamicly if there are changes in email account and/or milist
# you have run it again via cron (weekly/daily)
# - user which his email address listed can't update his info
# (I am setup my squirrelmail with policy no one can change global address book)

# variables section edited here
# your domain
DOMAIN="pala.bo-tak.info"
# where this bash and php script reside
SCRIPT_LOC="/root/scripts"
MILISDIR="/home/vpopmail/domains/$DOMAIN"
FILENAME=$DOMAIN"_gabook"
GLOBAL_ABOOK="/var/lib/squirrelmail/$FILENAME"

#===========================
# process here
#===========================
echo "#Squirrelmail global address book updater..."
rm -f $GLOBAL_ABOOK
touch $GLOBAL_ABOOK

# export email address
# make sure sqweb_gabook.php is in same folder
# there are some variable inside it please change them to suit your need
if [ -e $SCRIPT_LOC/sqweb_gabook.php ]; then
php $SCRIPT_LOC/sqweb_gabook.php
fi

# export milist
CWD=`pwd`
cd $MILISDIR
for milisname in $(ls -1);
do
if [ -e $milisname/config ]; then
echo "$milisname|$milisname|MailingList|[EMAIL PROTECTED]|" >>
$GLOBAL_ABOOK
fi
done

cd $CWD
echo "Global Address for $DOMAIN is available at "$GLOBAL_ABOOK
echo "Enter the fullpath using Squirrelmail config utility"
echo "select 6. Address Books option and configure address book in 3. Global file address book"
echo "More info: http://www.squirrelmail.org/docs/admin/admin-7.html#ss7.5";

<?php
/*
# sqweb_gabook.php
# squirrelmail global address book updater
# this file is needed by sqweb-gabook.sh
#
# PakOgah <pakogah@pala.bo-tak.info>
# ver 0.1 (2 Aug 2007)
# - initial script
# ver 0.3 (3 Aug 2007)
# - add full path and test if php script exist
# - add detail documentation
#
# need more enhancements
# - use 2 script to create one global address book, if it were only 1 script it would be simpler
# - these scripts only can generate one global address book for one domain
# - and thus 1 global address book is configured with your Squirrelmail
# so if your webmail support multidomain, the global address book didn't
# - can't update dynamicly if there are changes in email account and/or milist
# you have run it again via cron (weekly/daily)
# - user which his email address listed can't update his info
# (I am setup my squirrelmail with policy no one can change global address book)
*/
// configuration
// your domain name
$domainname="pala.bo-tak.info";
// your domain table name inside vpopmail database
$tablename="pala_bo_tak_info";
$username="vpopmail";
$password="SsEeCcRrEeTt";
$database="vpopmail";
$hostname="localhost";
$filename=$domainname."_gabook";
$global_abook="/var/lib/squirrelmail/".$filename;

// process
$handle = fopen($global_abook, 'a');
$conn = mysql_connect($hostname, $username, $password) or die ('Error
connecting to mysql');
mysql_select_db($database);

$query="select pw_name,pw_gecos from $tablename";
$result = mysql_query($query);

while(list($email,$name)= mysql_fetch_row($result))
{
$data=$email."|".$name."||".$email."@".$domainname."|\n";
fwrite($handle, $data);
}
mysql_close($conn);
fclose($handle);
?>

Squirrelmail Global Address Book - Revision history

Ebroch at 14:02, 25 April 2024

Ebroch at 14:02, 25 April 2024

Ebroch at 14:01, 25 April 2024