Re: [SOGo] SOGo migration 2.2.17a to 5.0.0

2020-09-21 Thread Janis Hamme
Don't know if what you try is supposed to work, but it might be easier
to migrate the entire database to your new system and then upgrade the
database schema as described in the user manual for upgrading SOGo versions.

If you only need individual users you can use sogo-tool to export the
users after the upgrade to 5.0 and import them into a clean database. Or
just remove any users that you don't want to keep.

Regards
Janis

Am 21.09.20 um 19:04 schrieb Patrick Geschke (patrick.gesc...@openroot.de):
> Exactly this. 
> I have a 2.2.17a system where i dumped a demo account,
> which previously was also created on the 5.0.0. system.
>
> Dumping on 2.2.17a with 2.2.17a sogo-tool and importing on the 5.0.0
> system with 5.0.0 sogo-tool failed with mentioned error. 
>
> Am Montag, den 21.09.2020, 17:23 +0200 schrieb Christian Mack:
>> Hello
>>
>> Am 21.09.20 um 14:24 schrieb Patrick Geschke (
>> patrick.gesc...@openroot.de):
>>> Hey guys,
>>>
>>> im running 2 sogo installations. 
>>>
>>> A) SOGo 2.2.17a
>>> B) SOGo 5.0.0
>>>
>>> And im trying to migrate between those two.
>>> One of the major problems is
>>> migrating the calendar and addressbook content.
>>> When using sogo-tool backup and dumping accounts from the source
>>> machine, sogo-tool restore will just show errors like
>>>
>>> sogo-tool[18746:18746] user backup (/path/to/backup) file could not
>>> be
>>> loaded
>>>
>>> Are those dumps incomptabile? What are my options?
>>> Sidenote: The user accounts are already created on the target
>>> machine.
>>>
>> You can create a new user on 5.0.0 and he/she can use it?
>> You did dump with the sogo-tool from 2.2.17a?
>> And you are restoring with sogo-tool from 5.0.0 into 5.0.0 System?
>> And all users exist on the authentication source?
>> You have setup a new database for SOGo 5.0.0?
>>
>> Then this should work.
>>
>> Kind regards,
>> Christian Mack
>>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] ANN: SOGo Package Repositories

2016-07-29 Thread Janis Hamme
Am 29.07.2016 um 14:36 schrieb Slávek Banko (slavek.ba...@axis.cz):
> Dne pá 29. července 2016 "Alain Abbas" napsal(a):
>> Hello Slavek
>> Tryed that but it still try to compile openchange and does the same error
>> my steps: 
>> #tar -xzvf SOGo-2.3.13.tar.gz
>> #cd SOGo-2.3.13
>> #cp -a packaging/debian debian
>> #cp packaging/debian-multiarch/control-no-openchange  debian/control
>> #./debian/rules
>> #dpkg-buildpackage -b
>>
>> and falled on the same error
>> any ideas ? 
>>
>> Regards and Thanks in advance 
>>
> You have a clean build machine or already installed dependencies needed for 
> build with openchange: libmapi-dev, libmapistore-dev, libmapiproxy-dev?
>
> By the way, already built packages may be sufficient for you? See alternative 
> SOGo packages repository for Debian and Ubuntu.
>
Removing libmapi* from my Jessie system resolved this error for me.
Thanks a lot!
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Mini Admin Panel Survey

2015-12-14 Thread Janis Hamme
I recommend ViMbAdmin [1]. It's has a very modern web interface and is
more flexible and actively maintained compared to postfixadmin. I use it
with a PostgreSQL Database and all Mailserver Components (Postfix,
Dovecot and SOGo) authenticate against that Database.

Regards,
Janis

[1] http://www.vimbadmin.net/

Am 11.12.2015 um 18:15 schrieb Michel Memeteau - EKIMIA:
> Hi,
>
> this might be slightly off-topic 
>
> We are in the process of selecting a panel for the administration of
> the Sogo users, so far we've tested :
>
> - Sogxmail
> - Zentyal
>
>
> I was wondering what people usually use and I'm open for suggestion
> with a preference for simplicity over features.
>
> Best regards
>
> Michel Memeteau
> Directeur, Ekimia SAS
> +33 (0)9 72 30 83 34 | m...@ekimia.fr | Notre WebBoutique :
> http://shop.ekimia.fr | 49 chemin union 13720 La bouilladisse
>  FRANCE
>
>
> Contactez nous directement par Tchat sur http://bit.ly/ekichat

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] SOGoMailCustomEmail

2015-05-20 Thread Janis Hamme
Am 18.05.2015 um 09:25 schrieb Infoomatic:
 Hi,
 Is it possible to have several from-emails defined via SOGoMailCustomEmail?

 sogo-tool user-preferences set defaults myuser SOGoMailCustomEmail 
 '{SOGoMailCustomEmail: [user1@domain,support@domain,office@domain]}'

 the above does not work, however with one email it works.

 regards,
 infoomatic
You can assign multiple Identities/Aliases via 'MailFieldNames' in the
configuration of your authentication source.
However it would be nice to have a list containing mail aliases instead
of having multiple fields containing on address each.

Janis
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] SOGo on Debian Jessie?

2015-04-27 Thread Janis Hamme
Hi,

now that Debian Jessie is considered stable, are there any plans on
releasing Jessie packages with the next release?

Is anyone running the SOGo packages included in Debian (1.3.16 in
Wheezy, 2.2.9 in Jessie)? My major concern is if there are safe upgrade
paths for such version jumps.
If yes, I might consider to downgrade from 2.2.17 to 2.2.9 and keep it
running until the next Debian release. Would that be safe?

Janis
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Recommended setup?

2014-11-23 Thread Janis Hamme
I am using SOGo in a simple setup for personal use without Samba/LDAP on
Debian Wheezy myself.

As SOGo does not include any kind of user management, you need an
existing user source that holds the user credentials (e.g., mail
address, name, password). This could be either a MySQL/PostgreSQL
Database or LDAP.

Since you have a running Postfix + Dovecot setup you're probably having
such a user source for virtual mail users already (Check your Postfix
and Dovecot configuration). SOGo must be configured to use that existing
user source for authentication. I suggest you use an existing
Webinterface as Postfixadmin or the more modern VimbAdmin to manage your
mail users.

Janis Hamme

On 11/22/2014 04:47 PM, Kai-Uwe Rommel wrote:
 users-requ...@sogo.nu wrote on 22.11.2014 14:38:04:
 
   On 22/11/2014 08:26, Kai-Uwe Rommel wrote:
   Can I install SOGo now on my server as described above, without
 Samba/LDAP?
   I would like to avoid Samba and OpenLDAP because I will never
 needmore than
   a handful (or two) of user accounts on this server, even if I add
 a few more
   relatives and friends to it.
 
  If you don't want to use LDAP for authentication, you can use SQL.
  But right now, you have to use one of the two.

 Thanks ... but I don't understand this yet. Sorry for being a complete
 newbie
 and asking so dumb questions:

 What do you mean with using SQL for authentication? A SQL database
 is something
 for storing data and you need to authenticate in order to _access_ a
 SQL database ...

 I understand that SOGo needs a SQL database for storing calendar
 entries and
 address book content ...

 I have read the SOGo manual but it explains almost nothing. No
 description of
 the architecture, how all those moving parts fit together ... nothing.

 Is there hope for someone like me to find a way to understand how SOGo
 works
 and how I can use it? I should say that I am (in my job) a IBM Domino
 expert
 for 20 years and an expert for many other products, too. But I really
 have a
 problem getting a grip on products like SOGo when there is almost no
 documentation
 and only a group of some experts (those who wrote it ...) who only
 speak in
 some chinese dialect :-) about their product. I just don't have the time
 to spend many hours analyzing the source code in order to understand how
 it works ... I hope you understand what I mean. I am eager to learn
 something
 new and look beyond what I do in my job but I must be able to understand
 a product from an admin's point of view within a (very) few hours.

 Kai-Uwe Rommel

 kai-uwe.rom...@ars.de
 Telefon+Mobil +49 89 32468-120

 

 ARS Computer und Consulting GmbH, http://www.ars.de http://www.ars.de/
 Ridlerstrasse 55, 80339 Muenchen, Deutschland

 Application Development Services, Business Transformation Services, IT
 Infrastruktur Services
 Beratung und Vertrieb zu IBM Software, System x, POWER Systems, Storage
 License Management Services, IBM Passport Advantage Lizenzierung

 Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909
 Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock,
 Joachim Gucker


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Production Server Specification

2014-07-03 Thread Janis Hamme
Am 07/03/2014 01:07 PM, schrieb marco ardito:
 Il 03/07/2014 06:03, Sogo Thailand ha scritto:

 btw, if your SME is 32 bit, it can't see 12 GB RAM at all... but only
 4GB for the whole machine RAM needs... ;)

 -- 
 *Marco
 *


PAE should be enabled on Linux by default, hence all memory should be
available ;)

@Somsak
You should do extensive monitoring of your server to find the
bottleneck. Besides memory and CPU limitations the problem might also be
IO related. You should check if a high IO wait time causes freezes  of
your Sogo, IMAP Backend or your Database.

Janis
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Re: Problem with imap and SOGoMailAuxiliaryUserAccountsEnabled = YES

2014-02-25 Thread Janis Hamme
Yes you need to configure a primary email account first.
You can just configure an external mail accounts as primary account. If
required you can make individual settings per users: check
IMAPHostFieldName and IMAPLoginFieldName in the documentation.

 - Janis

On 02/25/2014 10:23 AM, sr wrote:
 Hello,
 I have try the ZEG just to see and the auxiliary email account is
 working...
 Maybe my sogo auxiliary email don't work because there is no primary
 IMAP account that is set and work???
 ( I have set Active directory for user authentification and for now we
 only have an external mail provider )
 Any ideas? :)
 here is my sogo.conf
 Thanks!

 {
 OCSEMailAlarmsFolderURL =
 postgresql://sogo:sogo@localhost:5432/sogo/sogo_alarms_folder;
 OCSFolderInfoURL =
 postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info;
 OCSSessionsFolderURL =
 postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder;
 SOGoACLsSendEMailNotifications = YES;
 SOGoAppointmentSendEMailNotifications = YES;
 SOGoDraftsFolderName = Drafts;
 SOGoEnableEMailAlarms = YES;
 SOGoFoldersSendEMailNotifications = YES;
 //  SOGoIMAPServer = localhost;
 //NGImap4ConnectionStringSeparator = .;
 //SOGoIMAPAclConformsToIMAPExt = YES;
 //SOGoIMAPAclStyle = rfc2086;
 //SOGoIMAPAclStyle = rfc4314;
 //SOGoMailShowSubscribedFoldersOnly = YES;
 //SOGoForceExternalLoginWithEmail = YES;
 //ImapDebugEnabled = YES;
 //NGImap4DisableIMAP4Pooling = YES;
 SOGoLanguage = French;
 SOGoLoginModule = Calendar;
 SOGoMailAuxiliaryUserAccountsEnabled = YES;
 SOGoMailDomain = job.fr;
 SOGoMailingMechanism = smtp;
 SOGoProfileURL =
 postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile;
 SOGoSMTPServer = smtp.job.fr;
 SOGoSearchMinimumWordLength = 0;
 SOGoSentFolderName = Sent;
 SOGoSuperUsernames = (
 s.r@ariane.intra,
 );
 SOGoTimeZone = Europe/Paris;
 SOGoTrashFolderName = Trash;
 SOGoUserSources = (
 {
 CNFieldName = cn;
 IDFieldName = cn;
 UIDFieldName = userPrincipalName;
 baseDN = OU=job,DC=ariane,DC=intra;
 bindDN = CN=ldap,CN=Users,DC=ariane,DC=intra;
 bindPassword = ldappw;
 bindFields = (
 sAMAccountName,
 userPrincipalName
 );
 hostname = ldap://172.20.2.3:389;;
 canAuthenticate = YES;
 isAddressBook = YES;
 displayName = Active Directory;
 // mapping AD du champ Service et Societe
 mapping = {
 ou = (department,ou);
 o = (company,o);
 };

 id = ariane.intra;
 type = ldap;
 }
 );
 WOWorkersCount = 3;
 }

 Le 19/02/2014 15:03, sr a écrit :


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Re: Problem with imap and SOGoMailAuxiliaryUserAccountsEnabled = YES

2014-02-25 Thread Janis Hamme
Yes that field is missing. Your SOGo password is used for IMAP
Authentication. When external imap servers are used (as primary imap
account), a user must change his sogo password manually when the IMAP
password has changed.

For the other parameters (login name, imap server) you can add database
fields or set them globally for a user source.

On 02/25/2014 05:59 PM, sr wrote:
 Thanks for the answer,

 Ok  it's seems to be a little hard to do, specially for the imap
 password ( it's missing the feature IMAPPasswordFieldName ) ...
 Tell me if I'm wrong but I think that it could be resolved by:
 - create new fields in Sogo postgresql database ( IMAPname, IMAPpass )
 - enter with sql commands of each user imap login and password
 - In sogo.conf, use IMAPLoginFieldName = IMAPname;
etc...

 Sam



 Le 25/02/2014 12:55, Janis Hamme a écrit :


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] URLs contain double slashes

2014-02-24 Thread Janis Hamme
Hey all,

I noticed some URLs in the Webinterface contain double slashes. Examples
are:

 GET /SOGo/so/test123/Calendar//personal/properties

Due to this the links in the calendar properties window are wrong. The
relative URLs for Caldav/ICS/XML point to /SOGO/so/dav instead to /SOGO/dav

I tried to add a rewrite rule to the webserver to fix URLs containing
double slashes, but that broke other functionally as some HTTP POST
requests are redirected and the POST data is lost:

POST /SOGo/so/test...@examplemail.tk/Mail//0/folderINBOX/moveMessages
POST /SOGo/so/test...@examplemail.tk/Mail//0/folderINBOX/batchDelete
POST /SOGo/so/test...@examplemail.tk/Mail//0/folderINBOX/uids

The list of examples is probably not complete. Should be an easy fix.

 - Janis


-- 
users@sogo.nu
https://inverse.ca/sogo/lists