Re: [SOGo] Templates
Hi, "Simon Wilson" schrieb: >From a folder's three-dot menu, select to use for Templates: >* > >On Saturday, July 22, 2023 02:57 AEST, "Hanns Mattes" (ha...@hannsmattes.de) > wrote: > > > Hi, > > how do I tell sogo, which IMAP-folder is used for templates? Might be > obvious, but I don't get it. > > Any help appreciated > > Regards Hanns Thanks. I'm getting old and blind. Regards Hanns
[SOGo] Templates
Hi, how do I tell sogo, which IMAP-folder is used for templates? Might be obvious, but I don't get it. Any help appreciated Regards Hanns
Re: [SOGo] Add second E-Mail-Account
Hi, Am 28.01.22 um 10:00 schrieb Yoann Delattre (yoann.delat...@ac-lille.fr): Hi, For multiple identity, you need to set SOGoMailCustomFromEnabled = YES; Regards, Yoann indeed, this fixes the identity-issue - thanks a lot. Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Add second E-Mail-Account
Hi, "Christian Mack" (christian.m...@uni-konstanz.de) schrieb: >Hello > >All settings in the webfrontend are stored together. >This means, you perhaps have a mandatory field not set in another mail >setting. >E.g. I had once enabled forwarding, but not set an email address to >forward to. >Or an user had forgotten to set a name and email in the second identity, >just added another signature. > >As long as that is not fixed, you can not store your changes. AFAICS all mandatory fields are set an it also happens with a new account: I can enter the data, but can't access the ok-button. I'm clueless Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Add second E-Mail-Account
Hi,
"Hanns Mattes" (ha...@hannsmattes.de) schrieb:
>[can't add identity or second imap-account]
Upgrading to 5.5.0 (as expected) didn't help. It's not a main concern,
but I don't like it, if things doesn't work as expected :-) - so any
help appreciated.
I can add an identity, if it's got the same name and E-mail-address as
the main account (obviously not very useful), so it's probably related
to the setup of my user source.
Here's my configuration:
MySQL4Encoding = "utf8mb4";
SOGoProfileURL =
"mysql://sogo:Strenggeheim@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:Strenggeheim@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:Strenggeheim@localhost:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL =
"mysql://sogo:Strenggeheim@localhost:3306/sogo/sogo_sessions_folder";
OCSCacheFolderURL =
"mysql://sogo:Strenggeheim@127.0.0.1:3306/sogo/sogo_cache_folder";
OCSStoreURL = "mysql://sogo:Strenggeheim@127.0.0.1:3306/sogo/sogo_store";
OCSAclURL = "mysql://sogo:Strenggeheim@127.0.0.1:3306/sogo/sogo_acl";
WOWorkersCount = 15;
/* Mail */
SOGoDraftsFolderName = INBOX/Drafts;
SOGoSentFolderName = INBOX/Sent;
SOGoTrashFolderName = INBOX/Trash;
// SOGoJunkFolderName = Junk;
SOGoIMAPServer = "imap://freebsd.example.com:143/?tls=YES";
SOGoSieveServer = "sieve://freebsd.example.com:4190/?tls=YES";
SOGoSMTPServer = "smtp://freebsd.example.com:587/?tls=YES";
SOGoMailDomain = example.com;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = YES;
SOGoSMTPAuthenticationType = PLAIN;
SOGoMailSpoolPath = /var/spool/sogo;
NGImap4ConnectionStringSeparator = "/";
/* Notifications */
//SOGoAppointmentSendEMailNotifications = NO;
//SOGoACLsSendEMailNotifications = NO;
//SOGoFoldersSendEMailNotifications = NO;
/* Authentication */
SOGoPasswordChangeEnabled = YES;
/* LDAP authentication example */
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
IDFieldName = uid; // first field of the DN for direct binds
bindFields = (uid, mail); // array of fields to use for indirect binds
baseDN = "ou=virtualmail,dc=example,dc=com";
bindDN = "cn=Manager,dc=example,dc=com";
bindPassword = Strenggeheim;
canAuthenticate = YES;
//displayName = "Verzeichnisdienst";
hostname = "ldap://127.0.0.1:389;;
id = public;
isAddressBook = NO;
},
{
type = ldap;
CNFieldName = cn;
UIDFieldName = cn;
IDFieldName = uid; // first field of the DN for direct binds
bindFields = (uid); // array of fields to use for indirect binds
baseDN = "ou=Oeffentliche_Adressen,dc=example,dc=com";
bindDN = "cn=Manager,dc=example,dc=com";
bindPassword = Strenggeheim;
canAuthenticate = NO;
displayName = "Verzeichnisdienst";
hostname = "ldap://127.0.0.1:389;;
id = publicAddresses;
isAddressBook = YES;
}
);
/* Web Interface */
SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoTrustProxyAuthentication = NO;
SOGoXSRFValidationEnabled = NO;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
/* General - SOGoTimeZone *MUST* be defined */
SOGoLanguage = German;
SOGoTimeZone = Europe/Berlin;
SOGoCalendarDefaultRoles = (
PublicDAndTViewer,
ConfidentialDAndTViewer
);
SOGoSuperUsernames = (hanns, admin); // This is an array - keep the parens!
SxVMemLimit = 384;
WOPidFile = "/var/run/sogo/sogo.pid";
// SOGoMemcachedHost = "/var/run/memcached.sock";
/* Debug */
//SOGoEASDebugEnabled = YES;
//SOGoDebugRequests = YES;
//SoDebugBaseURL = YES;
//ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
//WOLogFile = /var/log/sogo/sogo.log;
}
Regards Hanns
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] Add second E-Mail-Account
Hi, I'm trying to add a second E-Mail-Account. I can enter the necessary data, but i can't confim them, because the ok-button is deactivated. I also can't create a second identity, same behaviour. Don't know, if this is related. "SOGoMailAuxiliaryUserAccountsEnabled = YES;" is set. I guess, I' missing something obvious. SOGo is 5.4.0, UserSource is LDAP. Please let me know, if more details are required Any help appreciated. Thanx in advance Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Database-error with Activesync
"Thomas Fuehrer" (t...@aon.at) schrieb: >Hi, >I have no explanation why this problem occurs. Since I have no access >to a FreeBSD env I cannot test whether the problem is FreeBSD >specific. It seems so, I'll drop a note to the maintainer of the port. >I tested with Debain and CentOS and EAS works without >OCSCacheFolderURL, OCSAclURL and OCSStoreURL. > >So, I recommend to convert to the 9 table schema. It was introduced >with SOGo 3.0 and has several benefits. > >There is an excellent description of the required steps here: >https://docs.iredmail.org/upgrade.sogo.combined.sql.tables.html > >For a new environment you just have to set OCSCacheFolderURL, >OCSAclURL and OCSStoreURL as described int the installation guide. Added the manually - and everything is working. I owe You a beer, if You're the next time in the Frankfurt area. Thanks Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Database-error with Activesync
Hi, Thomas,
Am 14.01.22 um 07:46 schrieb "Thomas Fuehrer" (t...@aon.at):
Hi Hanns,
can you please set SOGoEASDebugEnabled=true, reproduce the error and
provide sogo.log?
/var/log7sogo/sogo.log:
Jan 14 11:33:00 sogod [43211]: <0x0x80481c2d8[SOGoCache]> Cache cleanup
interval set every 300.00 seconds
Jan 14 11:33:00 sogod [43211]: <0x0x80481c2d8[SOGoCache]> Using host(s)
'localhost' as server(s)
Jan 14 11:33:00 sogod [43211]: 94.79.154.202 "OPTIONS /SOGo HTTP/1.1"
302 0/0 0.025 - - -
Jan 14 11:33:21 sogod [43211]: 94.79.154.202 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.097 - - -
Jan 14 11:33:21 sogod [43211]: <0x0x80477dc48[SOGoActiveSyncDispatcher]>
EAS - request for device NineA3A7E5B16682:
"http://www.microsoft.com/;>
0
Jan 14 11:33:21 sogod [43211]:
<0x805376088[SOGoCacheGCSObject]:NineA3A7E5B16682> an exception occurred
when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:21 sogod [43211]:
<0x805376088[SOGoCacheGCSObject]:NineA3A7E5B16682> exception is
' NAME:ExecutionFailed REASON:Unknown
column 'c_uid' in 'where clause''
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists
in DAV permissions table
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write-properties'
already exists in DAV permissions table
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write-content'
already exists in DAV permissions table
Jan 14 11:33:22 sogod [43211]:
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
an exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folder75a80116e6c192545830654d370e' AND c_uid =
'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
could not insert/update record for record
'/NineA3A7E5B16682+folder75a80116e6c192545830654d370e' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> an
exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folderJunk' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> exception
is ' NAME:ExecutionFailed REASON:Unknown
column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> could not
insert/update record for record '/NineA3A7E5B16682+folderJunk' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic> an
exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folderPublic' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic> could
not insert/update record for record '/NineA3A7E5B16682+folderPublic' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
an exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folder3102040732e392545664654d370e' AND c_uid =
'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
could not insert/update record for record
'/NineA3A7E5B16682+folder3102040732e392545664654d370e' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
Re: [SOGo] Database-error with Activesync
Hi, Am 09.01.22 um 11:14 schrieb Hanns Mattes (hannsmat...@googlemail.com): > Hello, > > I've setup sogo 5.4.0 on a server running FreeBSD 13.0 und PSQL, web access, > caldav and carddav are working fine. But trying to access an account via > activesync is failing: > [...] (I forgot to mention, that I'm using LDAP-Authentication.) similar results with mysql: Jan 10 17:45:24 sogod [66817]: <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> an exception occurred when executing query 'SELECT * FROM sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path = '/4E696E65413341374535423136363832' AND c_uid = 'ha...@hanauix.de'' Jan 10 17:45:24 sogod [66817]: <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> exception is ' NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'where clause'' Jan 10 17:45:24 sogod [66817]: [ERROR] <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> could not insert/update record for record '/4E696E65413341374535423136363832' in sogo_cache_folder_hanns_A_hanauix_D_de: NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list' Any idea? Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Database-error with Activesync
Hello, I've setup sogo 5.4.0 on a server running FreeBSD 13.0 und PSQL, web access, caldav and carddav are working fine. But trying to access an account via activesync is failing: Jan 08 10:01:55 sogod [54350]: [ERROR] <0x805630b88[SOGoCacheGCSObject]:4E696E65414130423332413136354136> could not insert/update record for record '/4E696E65414130423332413136354136' in sogo_cache_folder_hanns_A_hanauix_D_de: NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x8056151e8[PostgreSQL72Channel]: connection=<0x0x804a53908[PGConnection]: connection=0x0x804785400>>): ERROR: column "c_uid" of relation "sogo_cache_folder_hanns_a_hanauix_d_de" does not exist LINE 1: ...ERT INTO sogo_cache_folder_hanns_A_hanauix_D_de (c_uid, c_p... ^ Jan 08 10:01:55 sogod [54350]: <0x8054e9088[SOGoCacheGCSObject]:4E696E65414130423332413136354136> an exception occurred when executing query 'SELECT * FROM sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path = '/4E696E65414130423332413136354136' AND c_uid = 'ha...@hanauix.de'' Jan 08 10:01:55 sogod [54350]: <0x8054e9088[SOGoCacheGCSObject]:4E696E65414130423332413136354136> exception is ' NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x8056151e8[PostgreSQL72Channel]: connection=<0x0x804a53908[PGConnection]: connection=0x0x804785400>>): ERROR: column "c_uid" does not exist LINE 1: ... c_path = '/4E696E65414130423332413136354136' AND c_uid = 'h... Looking at phpPgAdmin, I see the table sogo_cache_folder_hanns_A_hanauix_D_de and indeed, there is no column c_uid. Any help appreciated. Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
