[SOGo] Message view load images
Hello When viewing incoming messages SOGo shows a load images button to show online images in the message. I would like to find a way to show those images without clicking that button. Other webmail systems allow those images to load automatically when the message comes from an address included in address book. That could be the best way to do it for me, if it were possible. Another idea if previous way is not feasible, would be to add a config switch in preferences menu where a user could choose if he wants to block online images, and if if chooses not to block them, to show them by default in all messages. I could even manage with a load all images always default behaviour if there is no other way. I am a IT technician, so if it's not possible to add the feature I would thank any information that could help me to add it myself to my current SOGo system. Thanks in advance. Best regards. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sync users from /etc/shadow
amazing. thanks so much!
cheers, dan
On 21.02.2012 23:23, Phillip Wyman wrote:
Here is a script I wrote for syncing the shadow file to SOGo's SQL database.
I have it run in cron every minute, and redirect its output to a log file
with the correct permissions.
This is using SOGo's crypt password storage option (undocumented last time I
checked).
The variables at the top are fairly self-explanatory.
The MIN_UID constant defines what the minimum uid in /etc/passwd to sync
above is.
The excluded users array allows you to specify certain users in /etc/passwd
not to sync.
Now for my brief disclaimer :
I haven't scrutinized this script much for security, I take no responsibility
for any side effects, and it comes with no warranty.
Maybe it will help.
#!/usr/bin/php
?php
define ('SOGO_DBHOST', 'localhost');
define ('SOGO_DBUSER', 'sogouser');
define ('SOGO_DBPASS', '12345');
define ('SOGO_DBNAME', 'sogo');
define ('DOMAIN', 'yourdomain.com');
define ('SHADOW_FILE', '/etc/shadow');
define ('PASSWD_FILE', '/etc/passwd');
define ('MIN_UID', '1000');
$excluded_users = array ();
$excluded_users[] = 'webadmin';
$excluded_users[] = 'scanner';
$excluded_users[] = 'temp';
$excluded_users[] = 'sogo';
$sogo_rows = array ();
$fc = file(PASSWD_FILE);
if (!($fc)) {
echo \n . 'Could not obtain the contents of : ' . PASSWD_FILE . \n;
exit(1);
}
foreach ($fc as $line)
{
$line = rtrim($line);
$line_slices = explode(':',$line);
$username = $line_slices[0];
if (in_array($username,$excluded_users)) {
continue;
}
$uid = $line_slices[2];
if ($uid MIN_UID) {
continue;
}
$comment = $line_slices[4];
if (empty($comment)) {
$comment = $username;
}
$email = $username . '@' . DOMAIN;
$sogo_rows[$username] = array('uid' = $uid, 'comment' = $comment, 'email'
= $email);
}
$fc = file(SHADOW_FILE);
if (!($fc)) {
echo \n . 'Could not obtain the contents of : ' . SHADOW_FILE . \n;
exit(1);
}
foreach ($fc as $line)
{
$line = rtrim($line);
$line_slices = explode(':',$line);
$username = $line_slices[0];
if (!array_key_exists($username,$sogo_rows)) {
continue;
}
$sogo_rows[$username]['hash'] = $line_slices[1];
}
if (sizeof($sogo_rows) == 0) {
echo \n . 'No valid users to add were found.' . \n;
exit(1);
}
$sogo_dbcon = mysql_connect(SOGO_DBHOST,SOGO_DBUSER,SOGO_DBPASS,TRUE);
if (!($sogo_dbcon)) {
die('Error connecting to mysql: ' . mysql_error());
}
mysql_select_db(SOGO_DBNAME, $sogo_dbcon) or die('Error: Could not select
database ' . $sogo_dbname);
foreach ($sogo_rows as $username = $user_attrs) {
$username = mysql_real_escape_string($username);
$query = SELECT c_password,c_cn FROM sogo_view WHERE c_uid='$username';
$result = mysql_query($query,$sogo_dbcon);
$num_rows = mysql_num_rows($result);
if ($num_rows == 0) {
$user_attrs = array_map('mysql_real_escape_string', $user_attrs);
$query = INSERT into sogo_view (c_uid,c_name,c_password,c_cn,mail)
VALUES
('$username','$username','$user_attrs[hash]','$user_attrs[comment]','$user_attrs[email]');
$result = mysql_query($query,$sogo_dbcon);
if (!($result)) {
mysql_close($sogo_dbcon);
echo \n . 'Failed adding user : ' . $username . ' to sogo_view
table.' . \n;
exit(1);
}
echo \n . 'Added user : ' . $username . ' to sogo_view table.' . \n;
}
else {
$row = mysql_fetch_assoc($result);
$query_str = '';
if ($user_attrs['hash'] != $row['c_password']) {
$user_attrs['hash'] = mysql_real_escape_string($user_attrs['hash']);
$query_str .= c_password='$user_attrs[hash]',;
}
if ($user_attrs['comment'] != $row['c_cn']) {
$user_attrs['comment'] =
mysql_real_escape_string($user_attrs['comment']);
$query_str .= c_cn='$user_attrs[comment]',;
}
if (!empty($query_str)) {
$query_str = rtrim($query_str,',');
$query_str = 'UPDATE sogo_view set ' . $query_str . WHERE
c_uid='$username';
$result = mysql_query($query_str,$sogo_dbcon);
if (!($result)) {
mysql_close($sogo_dbcon);
echo \n . 'Failed updating data for : ' . $username . ' in
sogo_view table.' . \n;
exit(1);
}
echo \n . 'Updated data for : ' . $username . ' in sogo_view table.'
. \n;
//Disabled reloading of memcached for now, instead the
SOGoCacheCleanupInterval setting has been lowered
//from the default of 300 seconds to 30
//$result = system('/etc/init.d/memcached reload');
//echo \n . $result . \n;
}
}
}
?
On 02/18/2012 02:54 AM, Daniel Erlacher wrote:
Hello
I am running a ISPconfig installation and ideally it would
be possible to sync the usernames and passwords from /etc/shadow
with the mysql authentification that i am using for sogo.
is there any chance
Re: Re: [SOGo] Sogo 1.3.12c + OpenChange
Thank you for your response. I will try to migrate 1.3.12c 2.0.0b4, a virtual machine. I will test the native access Outlook. You think the final version is coming soon? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Migrationpath 3.x - 10.x ?
Am 22.02.2012 14:35, schrieb André Schild: Am 22.02.2012 14:01, schrieb Jakob Lenfers: Am 22.02.2012 12:31, schrieb André Schild: http://wiki.sogo.nu/TB-upgrade-3-to-10 You mention on the page that I need to use https, does it work with self signed certificates (CACert)? I don't know if these are enough, but it would be simple to test.. Doesn't seem to work, too bad. This could also be a option for you: http://www.borngeek.com/firefox/automatic-firefox-extension-updates/ Jup, thanks, that worked. A bit more testing, cleaning up and documenting and we are good to go for TB10! Thanks to everyone who helped in any way! :) Best, Jakob signature.asc Description: OpenPGP digital signature
[SOGo] Hi and Quesstion
Hi, This is my first post to the list. My organization wants to introduce SOgo for our customers. I am very impressed of the fantastic work Inverse has been doing with SOgo. Congratulations. And hello everybody. My question is, does anybody found a file sharing complement to SOgo such as of VMWare Briefcase ( http://wiki.zimbra.com/wiki/Briefcase http://wiki.zimbra.com/wiki/Briefcase)?, this is possibly the biggest missing I found in SOgo. Many thanks in advance for your help. = Pablo Barrachina pa...@digitalvalue.es www. http://www.digitalvalue.es/ digitalvalue.es Tel: +34 963 162 089 Fax: +34 963 738 507 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] normalize calendar entries
Hi, At the moment I have a lot of calendar entries with different time zone spellings and without time zone entries. On the other side I found that SOGo can work with not 100% correct entries :-( This feature crashed with a defect entry the Cardav client from dmfs. Is there a way to normalize the calendar entries with one time zone spelling and 100% correct vcals? Stefan -- *CaC, Computer and Communication* Inhaber Stefan Klatt End-2-End Senior Network Consultant Triftstrasse 9 60528 Frankfurt Germany USt-IdNr.: DE260461592 Tel.: +49-(0)172-6807809 Tel.: +49-(0)69-67808-900 Fax: +49-(0)69-67808-837 Email: stefan.kl...@cac-netzwerk.de attachment: stefan_klatt.vcf signature.asc Description: OpenPGP digital signature
[SOGo] Sogo 2.0.0.20120 and Signature problem
Hi, since a couple of weeks i have a problem with our Sogo installation. Works all fine, common calendar, common address book and 2-3 e-mail adresses. But if i write something in the signature from any mail address i lost some settings: Common calendar is gone Common address book is gone additional e-mail accounts are gone I have only my personal calendar, address book and mail. For database i use mysql, Server is a Debian Linux 5. Any suggestions what i can do? Best regards Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Vacation messages expiration problem
Hi, I setup the cronjob for Vacation messages expiration and I get this error message: 0x0x91c7990[SOGoCache] Cache cleanup interval set every 300.00 seconds 0x0x91c7990[SOGoCache] Using host(s) 'localhost' as server(s) 2012-02-22 15:34:57.788 sogo-tool[8962] failure. Attempting with a renewed password (no authname supported) 2012-02-22 15:34:57.789 sogo-tool[8962] Could not login 'usager1' on Sieve server: 0x0x91fb880[NGSieveClient]: socket=NGActiveSocket[0x0x9202740]: mode=rw address=0x0x9203cb8[NGInternetSocketAddress]: host=sogoserver port=56174 connectedTo=0x0x92001c0[NGInternetSocketAddress]: host=ImapServerIP port=4190: (nil) 2012-02-22 15:34:57.792 sogo-tool[8962] An error occured while removing auto-reply of user usager1 The Sieve and IMAP server are not on the SOGo server. On my test server, everything are on localhost and it works fine. Regards, -- Louis-Philippe Gauthier -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problem with libobjc.so.1
Hi I tried to install Sogo according to this manual http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf on the fresh installation of CentOS 6.2 after running yum install sogo , I got the following error: -- Finished Dependency Resolution Error: Package: gnustep-base-1.23.0-1.i386 (SOGo) Requires: libobjc.so.1 Only package related to this which I found was libobjc-4.4.6-3.el6.i686. I installed it but the same error still occurs. Has anyone any idea? Regards Bartek -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Calendar Transition from old to new account
Hi, we made a transition from example.org to example.com domain for all mailboxes (LDAP - iredmail) and now we want to get all information (calendar and AB) to the new domain. is this possible and if yes, how can i manage this? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar Transition from old to new account
Am 23.02.2012 18:24, schrieb Martin Seener: Hi, we made a transition from example.org to example.com domain for all mailboxes (LDAP - iredmail) and now we want to get all information (calendar and AB) to the new domain. is this possible and if yes, how can i manage this? sogo-tools is your friend. With this you can unload the sogo data in text files and then with search+replace change the domain Then you can reload it in the new domain with sogo-tools as well. André -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: Vacation messages expiration problem
Sorry, I forgot to set the user in the sieve_admins on my Imap Server... Thanks, 2012/2/23 Louis-Philippe Gauthier lpgauth...@gmail.com Hi, I setup the cronjob for Vacation messages expiration and I get this error message: 0x0x91c7990[SOGoCache] Cache cleanup interval set every 300.00 seconds 0x0x91c7990[SOGoCache] Using host(s) 'localhost' as server(s) 2012-02-22 15:34:57.788 sogo-tool[8962] failure. Attempting with a renewed password (no authname supported) 2012-02-22 15:34:57.789 sogo-tool[8962] Could not login 'usager1' on Sieve server: 0x0x91fb880[NGSieveClient]: socket=NGActiveSocket[0x0x9202740]: mode=rw address=0x0x9203cb8[NGInternetSocketAddress]: host=sogoserver port=56174 connectedTo=0x0x92001c0[NGInternetSocketAddress]: host=ImapServerIP port=4190: (nil) 2012-02-22 15:34:57.792 sogo-tool[8962] An error occured while removing auto-reply of user usager1 The Sieve and IMAP server are not on the SOGo server. On my test server, everything are on localhost and it works fine. Regards, -- Louis-Philippe Gauthier -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] How to push extensions?
Is there a way to use SOGo integrator to push extensions without having to host the extension? I'd like to have SOGo integrator tell TB to get the latest Lightning and StartupMaster. If I put those extensions in extensions.rdf for the sogo-integrator, then I have to host the extensions on my server and get updates, change my updates.php file to reflect new versions, etc. And if TB updates to a new version of the extension (through tb's update process) sogo will downgrade to my version. I'd like SOGo to push an extension through tb's normal extension / add process. I don't want someone doing a fresh install of TB and installing the sogo integrator but not installing lightning (and then complaining when there is calendar, etc) Thanks, Ben -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Thursday, February 23 2012
Title: BTS activities for Thursday, February 23 2012 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, February 23 2012 idlast updatestatus (resolution)categorysummary 1648 2012-02-23 20:08:16 new (open) Backend Address Book Various common contact fields not supported 1646 2012-02-23 06:39:48 new (open) sogo-tool Store recipients e-mail address history 1647 2012-02-23 19:36:42 new (open) Web General The SOGo web interface should adapt more smoothly to various environments 1633 2012-02-23 09:59:04 updated (open) Web Mail duplicate trash, sent, drafts in view 1645 2012-02-23 12:27:01 feedback (open) with external server Thunderbird 10.0 with Sogo Connector does not synchronize
[SOGo] What version of Funambol server is needed for sogo 1.3.12?
Hi, we are running SOGo version 1.3.12 on Debian 6. Now we want to try syncronization with mobile device (mainly Blackberry). What version of funambol server is needed for sogo 1.3.12? In the documentetion I read 8.7, this is the only supported version or the minimum recommended version? Thanks -- Alessio Cecchi is: @ ILS - http://www.linux.it/~alessice/ on LinkedIn - http://www.linkedin.com/in/alessice Assistenza Sistemi GNU/Linux - http://www.cecchi.biz/ @ PLUG - ex-Presidente, adesso senatore a vita, http://www.prato.linux.it @ LOLUG - Socio http://www.lolug.net -- users@sogo.nu https://inverse.ca/sogo/lists
