[SOGo] problem with calendar
Hello, I have a problem with calendar data. The first time I started SOGo, the calendar data was saved to the mysql table, e.g. to the table: sogokrzyszto0011f8fa63a_quick. I changed something and now the data is saved to the table: sogo_quick_appointment (all calendars in one table) - this is cool but at this point I lost the data that was saved in the sogokrzyszto0011f8fa63a_quick table (I don't see it in calendar). Can I somehow move the calendar from the sogokrzyszto0011f8fa63a_quick table to the sogo_quick_appointment table? The columns are the same except that in the sogo_quick_appointment table there is an additional column c_folder_id. I tried to move all the data from the individual columns but I do not see this item in the calendar - why? I also see that the c_name value currently looks different, when the calendar was saved in the sogokrzyszto0011f8fa63a_quick table, c_name looked like this: 04008200E00074C5B7101A82E00820D754AE870ADB010001 000DBAFEC71EC5F824A8DF70A6D3931EF88.ics and the new calendar entries generated in the sogo_quick_appointment table are shorter and look like this: D623-67002E80-1-5CCB8E00.ics Please help me recover the data. BR
RE: [SOGo] outlook 365 and calendar free/busy
Hello, Please tell me this solution works with mysql ? Pozdrawiam Grzegorz Cimochowski -Original Message- From: users-requ...@sogo.nu On Behalf Of Christian Mack Sent: Friday, October 4, 2024 9:29 AM To: users@sogo.nu Subject: Re: [SOGo] outlook 365 and calendar free/busy Hello Of course, but that only is applied to new accounts at creation in SOGo. Set in /etc/sogo/sogo.conf: [...] SOGoCalendarDefaultRoles = ( PublicDAndTViewer, ConfidentialDAndTViewer, PrivateDAndTViewer ); [...] For existing accounts you have to write a script which checks all calendars and enhances them, if not already set. Kind regards, Christian Mack Am 03.10.24 um 11:44 schrieb admin (ad...@prawda.net.pl): > Wow. > Big thx now working perfect. > Tell me can I set default values for all users? > > Pozdrawiam > Grzegorz Cimochowski > > -Original Message- > From: users-requ...@sogo.nu On Behalf Of qhivert > Sent: Thursday, October 3, 2024 11:30 AM > To: users@sogo.nu > Subject: RE: [SOGo] outlook 365 and calendar free/busy > > Hello, > > By default, public access share nothing, you have to go to your calendar -> > 3 dots on the right -> Sharing... -> Public access And set something else > than None > > Quentin > > -Original Message- > From: users-requ...@sogo.nu On Behalf Of "MeA" > Sent: jeudi 3 octobre 2024 11:17 > To: users@sogo.nu > Subject: [SOGo] outlook 365 and calendar free/busy > > Hi, > I have a problem with free/busy in my Outlook. > File generated by SOGo from: > https://test.xx/SOGo/dav/public/lo...@domain.net/freebusy.ifb > > BEGIN:VCALENDAR > PRODID:-//Inverse inc./SOGo 5.11.0//EN > VERSION:2.0 > BEGIN:VFREEBUSY > ATTENDEE:mailto:lo...@domain.net > DTSTAMP:20241003T084456Z > DTSTART:20240925T22Z > DTEND:20241009T22Z > END:VFREEBUSY > END:VCALENDAR > > Always is thet same. It doesn't matter if I have 1 or more events. > It doesn't matter mail account. > When I use other mail address then in file mail address changed but dates > are te same. > Why? > Please help me fix my problem > BR > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416
RE: [SOGo] outlook 365 and calendar free/busy
Wow. Big thx now working perfect. Tell me can I set default values for all users? Pozdrawiam Grzegorz Cimochowski -Original Message- From: users-requ...@sogo.nu On Behalf Of qhivert Sent: Thursday, October 3, 2024 11:30 AM To: users@sogo.nu Subject: RE: [SOGo] outlook 365 and calendar free/busy Hello, By default, public access share nothing, you have to go to your calendar -> 3 dots on the right -> Sharing... -> Public access And set something else than None Quentin -Original Message- From: users-requ...@sogo.nu On Behalf Of "MeA" Sent: jeudi 3 octobre 2024 11:17 To: users@sogo.nu Subject: [SOGo] outlook 365 and calendar free/busy Hi, I have a problem with free/busy in my Outlook. File generated by SOGo from: https://test.xx/SOGo/dav/public/lo...@domain.net/freebusy.ifb BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 5.11.0//EN VERSION:2.0 BEGIN:VFREEBUSY ATTENDEE:mailto:lo...@domain.net DTSTAMP:20241003T084456Z DTSTART:20240925T22Z DTEND:20241009T22Z END:VFREEBUSY END:VCALENDAR Always is thet same. It doesn't matter if I have 1 or more events. It doesn't matter mail account. When I use other mail address then in file mail address changed but dates are te same. Why? Please help me fix my problem BR
Re: [SOGo] Sogo problem after migrate to the new virtual server
Even if i get 150 workers problems is still there. We have 15 devices running on IMAP and another 70 use ActiveSync.
[SOGo] Sogo problem after migrate to the new virtual server
Hello, we have a problem after we migrate sogo to new virtual server. There is some logs. First error log: <0x0x564cf6fae340[WOWatchDog]> No child available to handle incoming request! Default/sogo log: # The amount of processes that should be spawned (Default: 3) PREFORK=85 # The name of the account under which SOGo will be running (Default: sogo) # USER=sogo Sogo.config: { // // - Official SOGo document: http://sogo.nu/support/index.html#/documentation // - Mailing list: http://sogo.nu/support/index.html#/community // // Daemon address and port WOPort = 127.0.0.1:2; // PID file //WOPidFile = /var/run/sogo/sogo.pid; // Log file //WOLogFile = /var/log/sogo/sogo.log; // Enable verbose logging. Reference: // http://www.sogo.nu/nc/support/faq/article/how-to-enable-more-verbose-logging-in-sogo.html //SOGoDebugRequests = YES; //SOGoEASDebugEnabled = YES; //ImapDebugEnabled = YES; //LDAPDebugEnabled = YES; //MySQL4DebugEnabled = YES; //PGDebugEnabled = YES; // Define the URL to online help for SOGo. When set, an additional icon // will appear near the logout button in SOGo's web interface. The URL // will always be open in a blank target. //SOGoHelpURL = ''; // set the maximum allowed size for content being sent to SOGo, this can // also limit the file attachment size being uploaded to SOGo when // composing a mail. // The value is in kilobyte. Default is 0 or disabled (unlimit). WOMaxUploadSize = 102400; // Parameter used to set the maximum allowed email message size when // composing a mail. // The value is in kilobytes. By default, the value is 0, or disabled so // no limit will be set. SOGoMaximumMessageSizeLimit = 102400; // Performance Tuning // // The amount of instances of SOGo that will be spawned to handle multiple // requests simultaneously. When started from the init script, that amount // is overriden by the `PREFORK=` setting in /etc/sysconfig/sogo or // /etc/default/sogo. A value of 3 is a reasonable default for low usage. // The maximum value depends on the CPU and IO power provided by your // machine: a value set too high will actually decrease performances under // high load. // // You should have at least one child per EAS device configured to use // "push". You must also have more children than you have EAS devices // configured to use "push" - in order to handle normal SOGo requests to // its Web or DAV interfaces. // // Defaults to 1 when unset, increase it if you see below error message in // sogo log file: 'No child available to handle incoming request' // // WARNING: // - on RHEL/CentOS, this setting is controlled by parameter //'PREFORK=' defined in /etc/sysconfig/sogo. // - on Debian/Ubuntu, this setting is controlled by parameter //'PREFORK=' defined in /etc/default/sogo. WOWorkersCount =70; // Parameter used to set the maximum amount of time, in seconds, SOGo will // wait before replying to a Ping command. // If not set, it defaults to 10 seconds. SOGoMaximumPingInterval = 3540; // Parameter used to set the maximum amount of time, in seconds, SOGo will // wait before replying to a Sync command. // If not set, it defaults to 30 seconds. SOGoMaximumSyncInterval = 3540; // Parameter used to set the maximum amount of time, in seconds, SOGo will // wait before doing an internal check for data changes (add, delete, and // update). This parameter must be lower than SOGoMaximumSyncInterval and // SOGoMaximumPingInterval. // If not set, it defaults to 10 seconds. SOGoInternalSyncInterval = 30; // Specifies the number of minutes after which a busy child process will be // killed by the parent process. // Defaults to 10 (minutes). WOWatchDogRequestTimeout = 61; // Overwrite the maximum number of items returned during a Sync operation. // Defaults to 0, which means no overwrite is performed. // Setting this parameter to a value greater than 512 will have unexpected // behaviour with various ActiveSync clients. //SOGoMaximumSyncWindowSize = 100; // Overwrite the maximum response size during a Sync operation. // The value is in kilobytes. Setting this to 512 means the response size // will be of 524288 bytes or less (or a bit greater if needed for syncing // one item). Note that if you set the value too low and a mail message // (or any other object like calendar events, tasks and contacts) surpasses // it, it will still be synced but only this item will be. // Defaults to 0, which means no overwrite is performed. // // Say you have these five mails and you set the limit to 512KB: // 1. 250 KB // 2. 250 KB // 3. 25 KB // 4. 750 KB
[SOGo] exchange calendar shares
hello we would like to share our calendar with another organsisitan using exchange-online. Is there a way from the sogo page outside the public calendar links? Is there a way to get the calendars from exchange-online sharing? something like "exchange federation " -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Admin user
Hello, as far as I know the purpose of the "SOGo Administrator" user is to provide a user account that can be used for an indirect bind to the AD in your SOGoUserSources. The users that actually should be SOGO administrators have to be defined in the sogo setting SOGoSuperUsernames Best regards Florian Am 10.10.2019 um 11:15 schrieb Lars Liedtke (lied...@punkt.de): Hello everyone, I have connected SOGo to our AD and so far everything works fine. But I have one Problem regarding the admin user: I created a user, like all other users with the following Attributes version: 1 dn: CN=SOGo Administrator,OU=Mitarbeiter,DC=intern,DC=punkt,DC=de objectClass: user objectClass: organizationalPerson objectClass: person objectClass: top cn: SOGo Administrator instanceType: 4 objectCategory: CN=Person,CN=Schema,CN=Configuration,DC=intern,DC=punkt,DC=de codePage: 0 countryCode: 0 displayName: SOGo Administrator distinguishedName: CN=SOGo Administrator,OU=Mitarbeiter,DC=intern,DC=punkt,DC=de givenName: SOGo mail:s...@punkt.de name: SOGo Administrator primaryGroupID: 513 sAMAccountName: sogo sAMAccountType: 805306368 sn: Administrator userAccountControl: 66048 userPrincipalName:s...@intern.punkt.de uSNChanged: 11213741 uSNCreated: 11205718 whenChanged: 20191009134430.0Z whenCreated: 20191007125218.0Z I can login into SOGo with this user, but I don't see any hint that this user is admin at all. Except what is written under https://sogo.nu/files/docs/SOGoInstallationGuide.html#_creating_the_sogo_administrative_account I have not been able to find anything about how this administrative role is able to do something. Or is there an Admin page which I can reach over a URL, which I don't know about. Could you help me please? Wouldn't it be an information for the documentation as well? Best regards Lars -- punkt.de GmbH * Kaiserallee 13a * 76133 Karlsruhe Tel. 0721 9109 0 * Fax 0721 9109 100 i...@punkt.dehttps://www.punkt.de Gf: Jürgen Egeling AG Mannheim 108285 -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Activesync login problem
Ok, found a solution to my problem. My problem relied in the fact I used the mail adress as the user uid. It seems that in a multi domain configuration, you must keep the c_uid in the form of a username (bruno), not a complete mail adress (br...@.fr). To be able to use email addresses to login, you specify LoginFieldNames. Here is the modified part of my working conf (some of it might be overkill but it finally works :-) ): SOGoEnableDomainBasedUID = YES; domains = { x.fr = { SOGoMailDomain = x.fr; SOGoUserSources = ( { LoginFieldNames = ( mail ); canAuthenticate = YES; displayName = "SOGo Users"; id = users_x.fr; isAddressBook = NO; type = sql; IMAPLoginFieldName = mail; IMAPHostFieldName = imaphost; userPasswordAlgorithm = md5; viewURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_users"; } ); }; .net = { SOGoMailDomain = .net; SOGoUserSources = ( { LoginFieldNames = ( mail ); IMAPLoginFieldName = mail; canAuthenticate = YES; displayName = "SOGo Users"; id = users_.net; isAddressBook = NO; type = sql; IMAPHostFieldName = imaphost; userPasswordAlgorithm = md5; viewURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_users2"; } ); }; }; Here is the mysql sogo_users database : +---++--+-+---+--+ | c_uid | c_name | c_password| c_cn | mail | imaphost | +---++--+-+-------+--+ | admin | admin | e.8 | Bruno Steinbach | ad...@x.fr | hosting.x.com | | bruno | bruno | e.8 | Bruno Steinbach | br...@x.fr | hosting.x.com | +---++--+-+---+--+ On 19/06/2014 14:24, Admin wrote: Hello, I have a fresh install of sogo on debian wheezy with authentication on a mysql database. I configured activesync on both android mobile and ipad, but I have to login first on the web interface. Without previous login on the web interface, mobile devices cannot login and my logs show the following : localhost.localdomain - - [19/Jun/2014:13:32:09 GMT] "POST /SOGo/Microsoft-Server-ActiveSync?User=br...@x.fr&DeviceId=ApplDN6GLHA8DKNV&DeviceType=iPad&Cmd=Ping HTTP/1.0" 200 13/0 5.002 - - 8K 2014-06-19 13:32:12.037 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2014-06-19 13:32:12.037 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2014-06-19 13:32:12.037 sogod[5650] didn't set return value for type 'v' 2014-06-19 13:32:12.037 sogod[5650] -[WEClientCapabilities initWithRequest:]: Unknown WebClient: user-agent='Apple-iPad2C2/1104.201' 2014-06-19 13:32:12.038 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2014-06-19 13:32:12.038 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2014-06-19 13:32:12.038 sogod[5650] didn't set return value for type 'v' Jun 19 13:32:12 sogod [5650]: [WARN] <0x0x7f2283fba620[WOContext]> Got no user from authenticator: Here is my conf : { SOGoCacheCleanupInterval = 600; WOWorkersCount = 20; OCSFolderInfoURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_folder_info"; OCSSessionsFolderURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_sessions_folder"; SOGoMemcachedHost = 127.0.0.1; SOGoAppointmentSendEMailNotifications = YES; SOGoFirstDayOfWeek = 1; SOGoLanguage = French; SOGoTimeZone = "Europe/Paris"; SOGoForwardEnabled = YES; SOGoEnablePublicAccess = NO; SOGoLoginModule = Calendar; SOGoMailDomain = "x.fr"; SOGoMailMessageCheck = every_minute; SOGoProfileURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_user_profile"; SOGoSieveScriptsEnabled = YES; SOGoSieveServer = "sieve
[SOGo] Activesync login problem
Hello, I have a fresh install of sogo on debian wheezy with authentication on a mysql database. I configured activesync on both android mobile and ipad, but I have to login first on the web interface. Without previous login on the web interface, mobile devices cannot login and my logs show the following : localhost.localdomain - - [19/Jun/2014:13:32:09 GMT] "POST /SOGo/Microsoft-Server-ActiveSync?User=br...@x.fr&DeviceId=ApplDN6GLHA8DKNV&DeviceType=iPad&Cmd=Ping HTTP/1.0" 200 13/0 5.002 - - 8K 2014-06-19 13:32:12.037 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2014-06-19 13:32:12.037 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2014-06-19 13:32:12.037 sogod[5650] didn't set return value for type 'v' 2014-06-19 13:32:12.037 sogod[5650] -[WEClientCapabilities initWithRequest:]: Unknown WebClient: user-agent='Apple-iPad2C2/1104.201' 2014-06-19 13:32:12.038 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2014-06-19 13:32:12.038 sogod[5650] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull ! 2014-06-19 13:32:12.038 sogod[5650] didn't set return value for type 'v' Jun 19 13:32:12 sogod [5650]: [WARN] <0x0x7f2283fba620[WOContext]> Got no user from authenticator: Here is my conf : { SOGoCacheCleanupInterval = 600; WOWorkersCount = 20; OCSFolderInfoURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_folder_info"; OCSSessionsFolderURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_sessions_folder"; SOGoMemcachedHost = 127.0.0.1; SOGoAppointmentSendEMailNotifications = YES; SOGoFirstDayOfWeek = 1; SOGoLanguage = French; SOGoTimeZone = "Europe/Paris"; SOGoForwardEnabled = YES; SOGoEnablePublicAccess = NO; SOGoLoginModule = Calendar; SOGoMailDomain = "x.fr"; SOGoMailMessageCheck = every_minute; SOGoProfileURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_user_profile"; SOGoSieveScriptsEnabled = YES; SOGoSieveServer = "sieve://localhost:4190"; SOGoEnableDomainBasedUID = YES; SOGoEnableEMailAlarms = YES; OCSEMailAlarmsFolderURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_alarms_folder"; SOGoSuperUsernames = ( "ad...@x.fr" ); SOGoTimeZone = "Europe/Amsterdam"; domains = { x.fr = { SOGoMailDomain = x.fr; SOGoUserSources = ( { canAuthenticate = YES; displayName = "SOGo Users"; id = users_x.fr; isAddressBook = NO; type = sql; IMAPHostFieldName = imaphost; userPasswordAlgorithm = md5; viewURL = "mysql://sogo:sogopasswd@127.0.0.1:3306/sogo/sogo_users"; } ); }; }; SOGoVacationEnabled = YES; } Any idea ? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] How to Sync AdressCategories with Thunderbird adressbook?
Hello, i am using Owncloud for long time yet. On my Android-Smartphone i use the groups / catagories which are synced with the owncloud contacts. There is no problem to sync both. When i sync the adressbook with thunderbird, so i can see the groups / catagories in the contacts, but i cannot use this for sending emails to the groups like on Android. Who can tell me how i can use the owncloudgroups in thunderbird. thx -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] EMail reminders
Hi, We have set-up Sogo on a server, everything is working fine. Some users asked me if it was possible to received events reminders via mail, instead of a pop-up via web sogo interface (in case they are connected through thunderbird). I saw on the installation guide the "EMail reminders" section and I had apply the following option on the configuration file: SOGoEnableEMailAlarms = YES; OCSEMailAlarmsFolderURL = "mysql://user:password@host:port/sogo/sogo_alarms_folder"; I add "* * * * * /usr/sbin/sogo-ealarms-notify" to the sogo's user crontab. and restarted sogo daemon. The problem is that nothing has changed, reminders still appears as pop-ups and not as email alerts. What could be wrong with my setup ? Thank for you help. -- users@sogo.nu https://inverse.ca/sogo/lists