[SOGo] Troubles with Installation on FreeBSD
Hello everyone, Please pardon my intrusion. I am a new member and so green and only heard about SOGo recently. Besides, I am on an _mostly_ unsupported platform - FreeBSD. After successfully installing SOPE, I am trying to compile SOGo on FreeBSD 91. (amd64) and it fails at the stage shown below and I am wondering if someone can guess the cause and the solution. More questions after the error txt. === Building for sogo-2.0.5a This is gnustep-make 2.6.2. Type 'gmake print-gnustep-make-help' for help. Making all in SOPE/NGCards ... Making all for library libNGCards... gmake[4]: Nothing to be done for `internal-library-compile'. Making all in versitCardsSaxDriver ... Making all for bundle versitCardsSaxDriver... gmake[5]: Nothing to be done for `internal-bundle-compile'. Copying resources into the bundle wrapper... Making all in SOPE/GDLContentStore ... Making all for library libGDLContentStore... gmake[4]: Nothing to be done for `internal-library-compile'. gmake[2]: Nothing to be done for `internal-master-tool-all'. Making all in OGoContentStore ... Making all for library libOGoContentStore... gmake[4]: Nothing to be done for `internal-library-compile'. gmake[2]: Nothing to be done for `internal-master-tool-all'. Making all in SoObjects ... Making all in SOGo ... Making build-headers for framework SOGo... Making all for framework SOGo... Compiling file SOGoBuild.m ... Creating derived_src/NSFramework_SOGo.m... Compiling file derived_src/NSFramework_SOGo.m ... Linking framework SOGo ... Copying resources into the framework wrapper... Creating SOGo.framework/Versions/2/Resources/Info-gnustep.plist... gmake[3]: Nothing to be done for `internal-master-library-all'. gmake[3]: Nothing to be done for `internal-master-tool-all'. Making all in Appointments ... Making all for wobundle Appointments... Linking resources into the bundle wrapper... Linking localized resources into the bundle wrapper... Making all in Contacts ... Making all for bundle Contacts... gmake[5]: Nothing to be done for `internal-bundle-compile'. Copying resources into the bundle wrapper... Copying localized resources into the bundle wrapper... Making all in Mailer ... Making all for wobundle Mailer... Linking resources into the bundle wrapper... Making all in Main ... Making all for tool sogod... Linking tool sogod ... /usr/bin/ld: /usr/lib/crt1.o: relocation R_X86_64_32 against `_DYNAMIC' can not be used when making a shared object; recompile with -fPIC /usr/lib/crt1.o: could not read symbols: Bad value collect2: ld returned 1 exit status gmake[4]: *** [obj/sogod] Error 1 gmake[3]: *** [internal-tool-all_] Error 2 gmake[2]: *** [sogod.all.tool.variables] Error 2 gmake[1]: *** [internal-all] Error 2 gmake: *** [internal-all] Error 2 *** [do-build] Error code 2 Stop in /usr/local/www/apache22/data/domainpanel/groupoffice/SOGo/sogo. PS: Are there people running SOGo in production on FreeBSD?? On FreeBSD 8.4 (i386), I managed to successfully compile SOPE and SOGo - both 2.0.5 versions. I found the link below where someone documented their FreeBSD installation for an older version. http://permalink.gmane.org/gmane.comp.groupware.sogo.user/3507 However, I am not sure I understand what is being done at Step No.6. I am going to read the documentation yes, but just following the HOWTO, I could not proceed beyond step 6(ii) [sogo@gw ~]$ mtn db init --db=~/db.mtn mtn: misuse: database '/var/db/sogo/db.mtn' already exists [sogo@gw ~]$ mtn --db=~/db.mtn pull kictanet.or.ke ke.or.kictanet.sope mtn: warning: separate server and pattern arguments are deprecated, please consider using the URI calling syntax instead mtn: doing anonymous pull; use -kKEYNAME if you need authentication mtn: connecting to 'mtn://kictanet.or.ke' mtn: include pattern 'ke.or.kictanet.sope' mtn: exclude pattern '' mtn: network error: failed to connect: Operation timed out Can someone explain to me what should be done at this stage? What is being pulled? From where?? What should I do in the face of the messages shown? Can I run SOGo with MySQL only without LDAP? Thanks in advance -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Compile failed...
I am trying to install SOGo-2.0.6 on FreeBSD (64-bit) and it fails at this stage: Linking resources into the bundle wrapper... Making all in Main ... Making all for tool sogod... Compiling file sogod.m ... Compiling file SOGo.m ... SOGo.m:73:2: warning: #warning might be useful to have a SOGoObject-derived proxy class for handling requests and avoid duplicating methods SOGo.m:166:2: warning: #warning the following methods should be replaced with helpers in GCSSpecialQueries Compiling file SOGo+DAV.m ... SOGo+DAV.m:134:2: warning: #warning all REPORT method should be standardized... SOGo+DAV.m:340:2: warning: #warning this is a bit ugly, as usual SOGo+DAV.m:480:5: warning: #warning evil eVIL EVIl! Linking tool sogod ... /usr/bin/ld: /usr/lib/crt1.o: relocation R_X86_64_32 against `_DYNAMIC' can not be used when making a shared object; recompile with -fPIC /usr/lib/crt1.o: could not read symbols: Bad value collect2: ld returned 1 exit status gmake[4]: *** [obj/sogod] Error 1 gmake[3]: *** [internal-tool-all_] Error 2 gmake[2]: *** [sogod.all.tool.variables] Error 2 gmake[1]: *** [internal-all] Error 2 gmake: *** [internal-all] Error 2 *** [do-build] Error code 2 Stop in /usr/local/www/apache22/data/domainpanel/groupoffice/SOGo/sogo. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo MySQL Authentication
Helloz, I am almost bald trying to get authentication using mysql working. The difficult part is how to tell what SOGo is exactly doing (debugging) so that I can fix it. I have in my sogo.conf: /* MySQL Authentication */ SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = md5; viewURL =mysql:// exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view; } ); And I created a view on my DB as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which gives me: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn | mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | secret1| w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ I am trying to login using username=w...@kictanet.or.ke and password=whateveritis but I always get failure... wrong username or password. On sogo.log, I see no clue whatsoever: root@gw:/usr/local/etc/sogo # tail -f /var/log/sogo/sogo.log Jun 26 14:51:24 sogod [94532]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 94533 Jun 26 15:40:53 sogod [5681]: version 2.0.6a (build r...@gw.kictanet.or.ke201306252307) -- starting Jun 26 15:40:53 sogod [5681]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] listening on *:2 Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] watchdog process pid: 5681 Jun 26 15:40:53 sogod [5681]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] preparing 1 children Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 5682 2013-06-26 15:41:06.186 sogod[5682] Note: Using UTF-8 as URL encoding in NGExtensions. Jun 26 15:41:06 sogod [5682]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Using host(s) 'localhost' as server(s) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: SOGo 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 15:41:10.190 sogod[5682] Note(SoObject): relative base URLs are enabled. Jun 26 15:41:10 sogod [5682]: |SOGo| did not find key 'SOGo' in SoClass: 0x0x23c07504[SoObjCClass]: super=0x0x23c07184 objc=SOGo slots=connect ,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup in root object: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| matched appname: SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| = rewrote value: SOGo[0x0x23a6aba4]: name=SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: connect 2013-06-26 15:41:10.194 sogod[5682] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/local/GNUstep/System/Libra ry/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle' 2013-06-26 15:41:10.202 sogod[5682] WOCompoundElement: pool embedding is on. 2013-06-26 15:41:10.203 sogod[5682] WOCompoundElement: id logging is on. Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated pro duct=0x0x23c67dc4[SoProduct]: loaded code-loaded bundle=/usr/local/GNUstep/Local/Library/SOGo/MainUI.SOGo #classes=8 #categories=4 rm=0x0x23c770 a4 Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated product=0x0x23 c67dc4[SoProduct]: loaded code-loaded bundle=/usr
[SOGo] Re: SOGo MySQL Authentication - SOLVED
Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! On 26 June 2013 15:46, Odhiambo Washington odhia...@gmail.com wrote: Helloz, I am almost bald trying to get authentication using mysql working. The difficult part is how to tell what SOGo is exactly doing (debugging) so that I can fix it. I have in my sogo.conf: /* MySQL Authentication */ SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = md5; viewURL =mysql:// exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view; } ); And I created a view on my DB as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which gives me: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn | mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | secret1| w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ I am trying to login using username=w...@kictanet.or.ke and password=whateveritis but I always get failure... wrong username or password. On sogo.log, I see no clue whatsoever: root@gw:/usr/local/etc/sogo # tail -f /var/log/sogo/sogo.log Jun 26 14:51:24 sogod [94532]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 94533 Jun 26 15:40:53 sogod [5681]: version 2.0.6a (build r...@gw.kictanet.or.ke201306252307) -- starting Jun 26 15:40:53 sogod [5681]: vmem size check enabled: shutting down app when vmem 384 MB Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 26 15:40:53 sogod [5681]: 0x0x23c01ee4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] listening on *:2 Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] watchdog process pid: 5681 Jun 26 15:40:53 sogod [5681]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] preparing 1 children Jun 26 15:40:53 sogod [5681]: 0x0x23bdedc4[WOWatchDog] child spawned with pid 5682 2013-06-26 15:41:06.186 sogod[5682] Note: Using UTF-8 as URL encoding in NGExtensions. Jun 26 15:41:06 sogod [5682]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Cache cleanup interval set every 300.00 seconds Jun 26 15:41:06 sogod [5682]: 0x0x23c58e54[SOGoCache] Using host(s) 'localhost' as server(s) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: SOGo 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugKeyLookup is enabled! 2013-06-26 15:41:10.189 sogod[5682] Note(SoObject): SoDebugBaseURL is enabled! 2013-06-26 15:41:10.190 sogod[5682] Note(SoObject): relative base URLs are enabled. Jun 26 15:41:10 sogod [5682]: |SOGo| did not find key 'SOGo' in SoClass: 0x0x23c07504[SoObjCClass]: super=0x0x23c07184 objc=SOGo slots=connect ,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| lookup in root object: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| GOT: (null) Jun 26 15:41:10 sogod [5682]: |SOGo| matched appname: SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| = rewrote value: SOGo[0x0x23a6aba4]: name=SOGo Jun 26 15:41:10 sogod [5682]: |SOGo| lookup name: connect 2013-06-26 15:41:10.194 sogod[5682] ERROR(-[NGBundleManager bundleWithPath:]): could not create bundle for path: '/usr/local/GNUstep/System/Libra ry/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle' 2013-06-26 15:41:10.202 sogod[5682] WOCompoundElement: pool embedding is on. 2013-06-26 15:41:10.203 sogod[5682] WOCompoundElement: id logging is on. Jun 26 15:41:10 sogod [5682]: |SOGo| looked up value: 0x0x23c968c4[SoPageInvocation]: class=SOGoRootPage action=connect bound instantiated pro duct=0x0x23c67dc4[SoProduct]: loaded code-loaded bundle=/usr
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
Well when I change that to md5-crypt, with matching password, it doesn't work. Why so? Either of these two don't work! userPasswordAlgorithm = md5; userPasswordAlgorithm = md5-crypt; My VIEW looks like this: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+- + | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayN ame | +-+-+-++-+-+- + | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | $1$OFb7e/vf$/FL/Q4T0LXFwaklRUzN7v. | w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+- + On 26 June 2013 17:44, Giovanni Bechis giova...@bigio.snb.it wrote: On 06/26/13 15:32, Odhiambo Washington wrote: Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! This is because you have cleartext passwords in your database, you should crypt your passwords before saving into MySQL. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
I have just tried that now and it works!! Thanks However, I find this confusing, since I use dovecot and dovecot treats my password as md5-crypt. Allow me to also ask: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... On 26 June 2013 20:16, Giovanni Bechis giova...@bigio.snb.it wrote: Have you tried with userPasswordAlgorithm = crypt; ? -- msg. originale -- Oggetto: Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED Da: Odhiambo Washington odhia...@gmail.com Data: 26/06/2013 18:17 Well when I change that to md5-crypt, with matching password, it doesn't work. Why so? Either of these two don't work! userPasswordAlgorithm = md5; userPasswordAlgorithm = md5-crypt; My VIEW looks like this: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+- + | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayN ame | +-+-+-++-+-+- + | 3 | w...@kictanet.or.ke | Odhiambo WASHINGTON | $1$OFb7e/vf$/FL/Q4T0LXFwaklRUzN7v. | w...@kictanet.or.ke | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+- + On 26 June 2013 17:44, Giovanni Bechis giova...@bigio.snb.it wrote: On 06/26/13 15:32, Odhiambo Washington wrote: Hello, I have changed userPasswordAlgorithm = md5; to userPasswordAlgorithm = none; and I was able to login! This is because you have cleartext passwords in your database, you should crypt your passwords before saving into MySQL. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED
Hi Ludovic, In that case, I now modify my VIEW: mysql CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which then gives the output below mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke | w...@kictanet.or.ke | $1$XXX | Odhiambo WASHINGTON | w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ So c_uid == c_name as you've suggested. My config has the below and still I cannot find anything inside the Staff Members addressbook folder. Anything unusual?? Also tell me, why is it that SOGo treats such password as crypt and not md5-crypt?? SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = crypt; //userPasswordAlgorithm = none; viewURL =mysql://exim4u:XXXWWW@127.0.0.1:3306/exim4u/sogo_auth_view ; } ); On 26 June 2013 22:47, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-06-26 3:43 PM, Odhiambo Washington wrote: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... Search in it. Also, c_name should be equal in most situation to c_uid. Right now you've set it to the user's real name, which is far from ideal. c_cn should be the user's realname. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Caching errors - what's the problem/solution?
I am getting these in the sogo.log: Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'session:ODRXP1/M23Xz99zKVHGoWg==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: |SOGo| lookup name: w...@kictanet.or.ke Jun 26 23:34:41 sogod [82542]: |SOGo| did not find key ' w...@kictanet.or.ke' in SoClass: 0x0x23c07544[SoObjCClass]: super=0x0x23c071c4 ob jc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jun 26 23:34:41 sogod [82542]: |SOGo| looked up value: (null) Jun 26 23:34:41 sogod [82542]: |SOGo| lookup in root object: (null) Jun 26 23:34:41 sogod [82542]: |SOGo| GOT: (null) Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+attributes': SER VER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'session:ODRXP1/M23Xz99zKVHGoWg==': SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY Jun 26 23:34:41 sogod [82542]: 0x0x23c58d64[SOGoCache] an error occurred when caching value for key 'w...@kictanet.or.ke+defaults': SERVE R HAS FAILED AND IS DISABLED UNTIL TIMED RETRY What do I need to do to solve? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] This page cant be displayed
=(null) base-class=(null)) = 0x0x7f3785cc5948[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785c41cb8[NGInternetSocketAddress]: host=hma016.domain.comport=143 Jun 26 07:12:46 sogod [15593]: 0x85C31BA8[SOGoMailFolder]:folderINBOX renewing imap4 password Jun 26 07:12:46 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login failed: host=hma016.domain.com, user=terry.welch, pwd=yes url=imap://terry.we...@hma016.domain.com/INBOX/ base=(null) base-class=(null)) = 0x0x7f3785bd9d88[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785b57818[NGInternetSocketAddress]: host=hma016.domain.comport=143 Jun 26 07:12:46 sogod [15593]: [ERROR] 0x85C31BA8[SOGoMailFolder]:folderINBOX Could not connect IMAP4 192.1.1.237 - - [26/Jun/2013:07:12:46 GMT] GET /SOGo/so/terry.welch/Mail/view HTTP/1.1 200 7885/0 0.034 31421 74% 0 192.1.1.237 - - [26/Jun/2013:07:12:47 GMT] POST /SOGo/so/terry.welch/Calendar/alarmslist?browserTime=1372281195 HTTP/1.1 200 2/0 0.006 - - 0 Jun 26 07:12:47 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login faile d: host=hma016.domain.com, user=terry.welch, pwd=yes url=imap://terry.we...@hma016.domain.com/ base=(null) base-class=(null)) = 0x0x7f3785c592d8[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785bb8a58[NGInternetSocketAddress]: host=hma016.domain.comport=143 Jun 26 07:12:47 sogod [15593]: 0x85BDE038[SOGoMailAccount]:0 renewing imap4 password Jun 26 07:12:47 sogod [15593]: [ERROR] 0x0x7f3785b25ef8[NGImap4ConnectionManager] IMAP4 login failed: host=hma016.domain.com, user=terry.welch, pwd=yes url=imap://terry.we...@hma016.domain.com/ base=(null) base-class=(null)) = 0x0x7f3785d8[NGImap4Client]: login=terry.welch(pwd) address=0x0x7f3785b89968[NGInternetSocketAddress]: host=hma016.domain.comport=143 Jun 26 07:12:47 sogod [15593]: [ERROR] 0x85BDE038[SOGoMailAccount]:0 Could not c onnect IMAP4 192.1.1.237 - - [26/Jun/2013:07:12:47 GMT] POST /SOGo/so/terry.welch/Mail/0/mailboxes HTTP/1.1 200 17/0 0.005 - - 0 192.1.1.237 - - [26/Jun/2013:07:12:47 GMT] POST /SOGo/so/terry.welch/Mail/foldersState HTTP/1.1 200 6/0 0.003 - - 0 Any advise or clues on the would be greatly appreciated! -- *Terry Welch* Original Message Subject: Re: [SOGo] This page cant be displayed Date: Wednesday, June 26, 2013 09:53 AM MST From: Odhiambo Washington odhia...@gmail.com To: terry.we...@hmatpa.com References: 51ca4b9a.7040...@inverse.ca 9e9-51cb1500-24f-2db56200@119463519 Hi Terry, It means your Apache configuration is missing certain aliases - please add these, and ensure the paths are correct. I use FreeBSD so the paths shown below are different than in Linux! Alias /SOGo.woa/WebServerResources/ /usr/local/GNUstep/Local/Library/SOGo/WebServerResources/ Alias /SOGo/WebServerResources/ /usr/local/GNUstep/Local/Library/SOGo/WebServerResources/ AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/local/GNUstep/Local/Library/SOGo/$1.SOGo/Resources/$2 Directory /usr/local/GNUstep/Local/Library/SOGo/ AllowOverride None Order deny,allow Allow from all IfModule expires_module ExpiresActive On ExpiresDefault access plus 1 year /IfModule /Directory** LocationMatch ^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*\.(jpg|png|gif|css|js) SetHandler default-handler /LocationMatch On 26 June 2013 19:21, Terry Welch terry.we...@hmatpa.com wrote: If I type the url in like this user authenticates into SOGo other then IMAP dovecot is having an issue but I will fix that later. http://mail1.domain.com/SOGo/so/user/Mail/view If I simply type the url in like this: http://mail1.domain.com/SOGo the I get the message This page cant be displayed Any ideas of where to fix this so that the bottom option url works? -- *Terry L. Welch* OF CONFIDENTIALITY: This message and any attachments contain confidential information belonging to the sender intended on ly for the use of the individual or entity named above. If you are not the intended recipient, be advised that copying, disclosure or reliance upon the contents is strictly prohibited. If you have received this message in error please notify the sender immediately and destroy this message. Original Message Subject: Re: [SOGo] This page cant be displayed Date: Tuesday, June 25, 2013 07:02 PM MST From: Ludovic Marcotte lmarco...@inverse.ca Repl y-To: users@sogo.nu Organization: Inverse inc. To: users@sogo.nu References: 50ea-51ca1300-27d-76ba6f00@7167953 On 2013-06-25 6:01 PM, Terry Welch wrote: My maillo g says the same. I believe this to be a postgresql issue but do not know enough postgres to figure this out on my own I've done alot of googleing but have had no luck. It's a LDAP issue - Jun 25 08:00:33 sogod [14879]: 0x0x7fc1044d0b98[LDAPSource] NAME:LDAPException
Re: [SOGo] How to set up CardDav, CalDav etc for IMAP with eMClient
Ian, There is nothing that stops you from running SOGo interface on port 80. Just use NameVirtualHost in your httpd.conf. Apache will happily proxy your requests to the SOGo daemon. On 27 June 2013 23:32, Ian James Vale ianjamesv...@icefire.eu wrote: Hi Bruce, This is a first time configuration for CalDAV/CardDAV for my SOGo install. The web interface works fine, by the way. Unfortunately I can never use the 'normal' ports 80 and 443, because as I said the web server (that's already operational) is using them, so I have SOGo configured to use 1234 and it's working OK from the web interface point of view. ZEG isn't possible as I don't have hardware that can do virtualization. As far as I know Apache on the mail server is as correct as it can be, but I'm not an Apache expert so really can't be sure. (By the way, I am not knowledgeable regarding virtual hosts on Apache, and from what I've read on help pages I'd need an extensive tutorial to get to grips with it as there are way too many settings that I could screw up due to my lack of awareness of what they are). Ian -Original Message- From: Bruce Marriner [mailto:bruce+s...@bmts.us] Sent: 27 June 2013 21:24 To: users@sogo.nu Subject: Re: [SOGo] How to set up CardDav, CalDav etc for IMAP with eMClient Ian, has CalDAV/CardDAV ever worked with anything with your current setup or are you trying to configure it for the first time now? Have you tried to test it using normal ports instead of non-standard ports? Just to get it working in a normal setup first before moving on to something custom? Have you configured Apache with the correct settings per the documentation (or using a ZEG install for an example)? -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogo segfault (2.0.6b)
I have installed both SOGo/SOPE 2.0.6b and now I am unable to start SOGo: root@gw:# /usr/local/etc/rc.d/sogo start Starting sogo. Segmentation fault Is there a way I can track this to find out the cause of the segfault? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo segfault (2.0.6b)
I have kinda made a step fwd. I can run sogo from the debug mode[0], but when I try to start it normally, I get the following in /var/log.messages: Jun 30 18:26:41 gw sogod: 2013-06-30 18:26:41.693 sogod[58347] unable to get status of descriptor 2 - Bad file descriptor Jun 30 18:28:05 gw sogod: 2013-06-30 18:28:05.152 sogod[58733] unable to get status of descriptor 2 - Bad file descriptor Jun 30 18:29:42 gw sogod: 2013-06-30 18:29:42.984 sogod[70515] unable to get status of descriptor 2 - Bad file descriptor Is this something easy to overcome? [0] [sogo@gw ~]$ gdb --args /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type show copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386-marcel-freebsd... (gdb) r Starting program: /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPi dFile /tmp/sogo.pid Jun 30 18:40:11 sogod [72874]: version 2.0.6b (build r...@gw.kictanet.or.ke201306301829) -- starting Jun 30 18:40:11 sogod [72874]: vmem size check enabled: shutting down app when vmem 1024 MB Jun 30 18:40:11 sogod [72874]: 0x0x23be7df4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 30 18:40:11 sogod [72874]: 0x0x23be7df4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 30 18:40:11 sogod [72874]: |SOGo| WOHttpAdaptor listening on address *:2 On 29 June 2013 23:46, Odhiambo Washington odhia...@gmail.com wrote: # su - sogo -s /usr/local/bin/bash [sogo@gw ~]$ gdb --args /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type show copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386-marcel-freebsd... (gdb) r Starting program: /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid /libexec/ld-elf.so.1: Shared object libSOGo.so.2 not found, required by sogod Program exited with code 01. (gdb) quit [sogo@gw ~]$ exit logout root@gw:/ # ls -al /usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/Versions/2/ total 1784 drwxr-xr-x 4 root wheel 512 Jun 29 23:31 . drwxr-xr-x 3 root wheel 512 Jun 29 23:30 .. drwxr-xr-x 2 root wheel 1536 Jun 29 23:30 Headers drwxr-xr-x 2 root wheel 512 Jun 29 23:31 Resources lrwxr-xr-x 1 root wheel 10 Jun 29 23:31 SOGo - libSOGo.so lrwxr-xr-x 1 root wheel 12 Jun 29 23:31 libSOGo.so - libSOGo.so.2 lrwxr-xr-x 1 root wheel 17 Jun 29 23:31 libSOGo.so.2 - libSOGo.so.2.0.6b -rwxr-xr-x 1 root wheel 1786194 Jun 29 23:31 libSOGo.so.2.0.6b Odd! It is complaining about a file that is actually there! I've even added the path to the hints file, but no luck still. ldconfig -r | grep GNU search directories: /lib:/usr/lib:/usr/lib/compat:/usr/local/lib:/usr/local/lib/compat/pkg:/usr/local/GNUstep/Local/Library/:/usr/local/GNUstep/System/Library/Libraries:/usr/local/lib/compat:/usr/local/lib/dovecot:/usr/local/lib/gcc42:/usr/local/lib/mysql:/usr/local/lib/nss:/usr/local/lib/pth:/usr/local/libexec/openldap What next? On 29 June 2013 15:58, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-06-29 6:30 AM, Odhiambo Washington wrote: Is there a way I can track this to find out the cause of the segfault? http://www.sogo.nu/nc/support/**faq/article/how-do-i-debug-**sogo.htmlhttp://www.sogo.nu/nc/support/faq/article/how-do-i-debug-sogo.html -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Misunderstanding SOGo
I have installed SOGo on one of the many FreeBSD boxes that I manage and I am kinda failing to understand something when it comes to Multi-domains setup. Here are my clueless moments: First, my config is availavle here - http://goo.gl/lpKZk This is a virtual domains setup, with MySQL. Users authenticate with username@domain as userid, with their password. The following parameters confuse the hell out of me: SOGoEnableDomainBasedUID = YES; SOGoDomainsVisibility = ((domain1,domain2)); SOGoLoginDomains = (domain1,domain1); (a) Since my users already login with full e-mail address as c_uid, I suppose SOGoEnableDomainBasedUID is not applicable in my case, right?? (b) SOGoLoginDomains - this gives me a dropdownlist from the login page, but then I cannot just enter username (without the @domain), as authentication fails. Is this parameter expected to concat username and @domain selected from the dropdownlist, or where am I going wrong? (c) SOGoDomainsVisibility Parameter used to set domains visible among themselves. For what purpose is this visibility? When defining specific domains, can I use a shortname to introduce the domain, much like a placeholder, then define the full domain name in SOGoMailDomain, like below, or must I use FQDN everywhere? domains = { crownkenya = { SOGoMailDomain = crownkenya.com; . -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGoSuperUsernames - is this a typo in the documentation?
The doco gives this format: SOGoSuperUsernames = (username1[,username2, ...]); I am just wondering what those misplaced braces are for. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGoSuperUsernames - is this a typo in the documentation?
I see the point. I thought it would be better just defined as an array. On 1 July 2013 14:02, MJ Ray m...@phonecoop.coop wrote: On 01/07/13 11:50, Odhiambo Washington wrote: The doco gives this format: SOGoSuperUsernames = (username1[,username2, ...]); I am just wondering what those misplaced braces are for. It means username2 and later is optional, surely? I can't remember if that syntax has a proper name. Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo - ResourceConfiguration
I hope I am not pissing off guys on this forum with my myriad questions about SOGo - having discovered it just the other week after someone mentioned it on another mailing list. I realize SOGo is not for FreeBSD, but I have several servers that could do with such a Groupware and I am learning the curves while playing and getting stuck. I just learnt about Resource Configuration from an old thread: http://wiki.sogo.nu/ResourceConfiguration I still don't understand it. Why do I require this? Can someone please give me a case scenario? I am using MySQL auth, using a VIEW instead of a standalone database. Before knowing a use case of Resources, I configured it on my test platform and promptly got stuck! I created a user(resource): +--+---+--+--+--+---+ | c_uid| c_name| c_cn | mail | kind | multiple_bookings | +--+---+--+--+--+---+ | ro...@crownkenya.com | Meeting Room1 | ro...@crownkenya.com | ro...@crownkenya.com | location | 1 | +--+---+--+--+--+---+ I then added the following to sogo.conf: SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); I understand that is the ACL required to enable a resource to work. Under my SOGoUserResourced, I added two parameters: MultipleBookingsFieldName = multiple_bookings; KindFieldName = kind; Now, as the Wiki says (remember I still don't quite understand the use case for this) I logged in and created an event in my Calendar and tried to add the resource as a participant. The problem is I could NOT save the event! The following would display in sogo.log: Jul 03 12:28:14 sogod [50769]: |SOGo| starting method 'POST' on uri '/SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715' Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key ' ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key ' ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| request took 0.003298 seconds to execute 196.200.26.114 - - [03/Jul/2013:12:28:14 GMT] POST /SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715HTTP/1.1 404 72/0 0.005 - - - And I got lost:) I beg someone familiar with this to explain to me the use case, and why I am getting stuck. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo User Limitation
Who told you this? Did s/he explain where/at what point the limitation comes in? On 3 July 2013 10:48, Mail Robot themailro...@gmail.com wrote: Hi, Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. In this new release of 2.0.6b, had the limitation being fixed? Thank you -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo User Limitation
It does have a limit of 100 users with OpenChange?? On 3 July 2013 14:00, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL Authentication
Hi Christian, I managed to wade past the authentication stage, actually. I used an MD5 encrypted password in that field and changed the userPasswordAlgorithm = crypt, which worked for me after a suggestion from another member of this list. Thanks for the follow up. Do you by any chance use Resource Configurations. I am at that stage of the SOGo learning curve. I posted a question today. Hopefully you have ideas on that too:) On 3 July 2013 15:20, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Odhiambo Washington Am 2013-06-26 14:46, schrieb Odhiambo Washington: I am almost bald trying to get authentication using mysql working. The difficult part is how to tell what SOGo is exactly doing (debugging) so that I can fix it. I have in my sogo.conf: /* MySQL Authentication */ SOGoUserSources = ( { type = sql; canAuthenticate = YES; displayName = Staff Members; id = users; isAddressBook = YES; userPasswordAlgorithm = md5; viewURL =mysql://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view http://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view; } ); And I created a view on my DB as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use rname AS mail, realname AS displayName FROM users WHERE enabled='1'; Which gives me: mysql select * from exim4u.sogo_auth_view where c_name like '%wash%'; +-+-+-++-+-+-+ | sogo_id | c_uid | c_name | c_password | c_cn| mail| displayName | +-+-+-++-+-+-+ | 3 | w...@kictanet.or.ke mailto:w...@kictanet.or.ke | Odhiambo WASHINGTON | secret1| w...@kictanet.or.ke mailto:w...@kictanet.or.ke | w...@kictanet.or.ke mailto:w...@kictanet.or.ke | Odhiambo WASHINGTON | +-+-+-++-+-+-+ I am trying to login using username=w...@kictanet.or.ke mailto:w...@kictanet.or.ke and password=whateveritis but I always get failure... wrong username or password. .. Is there something I am doing wrong?? Is it wrong password format? In your SOGo configuration you say userPasswordAlgorithm = md5, but it seems you have plain text passwords in your Mysql view. Is that correct? Then just use md5 hashed passwords in your view and it should work. My assumption is that SOGo is supposed to be sending these login details to my IMAP (Dovecot), right? Looking at my dovecot logs, I see no connection attempts... It will do that, but it will check your username and password against the mysql view first. As that isn't working, it will not try to connect to the IMAP server at all. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGO hangs trying to connect to external imap-server
Suppose you just change that parameter to: SOGoIMAPServer = imap.bws-uster.ch; Does it make a difference? I have used the parameter even with an IP address and it worked. On 30 June 2013 19:53, u...@rumlikon.ch wrote: Hi sogo-gods I've set up sogo (2-0-6b) on an ubuntu server 12.04. I'm authenticating against an active directory. Everything works great except imap. We are using a third party imap-server. I'm using the same password for AD and imap. My relvant config file looks like that: /* Mail */ //SOGoDraftsFolderName = Drafts; SOGoSentFolderName = Sent; SOGoTrashFolderName = Trash; SOGoIMAPServer = imap://imap.bws-uster.ch:143; SOGoForceExternalLoginWithEmail = YES; Sogo tries to connect but then just hangs for 10 minutes until the safty-belt recovers the system. I've checked the connectivity to imap with telnet. It works great. sogoadmin@sogo:~$ telnet imap.bws-uster.ch imap Trying 92.43.217.103... Connected to imap.bws-uster.ch. Escape character is '^]'. * OK Webland Mail Server v. 10.4.1 IMAP4rev1 Sun, 30 Jun 2013 18:50:19 +0200 01 login t...@bws-uster.ch *** 01 OK LOGIN Completed 02 List * * LIST (\HasNoChildren \Noinferiors) / Spam * LIST (\HasNoChildren) / INBOX 02 OK LIST Completed 03 examine inbox * FLAGS (\Seen \Answered \Flagged \Deleted \Draft \Recent $Forwarded $Redirected Junk NonJunk) * 0 EXISTS * 0 RECENT * OK [UIDVALIDITY 1121733603] UID validity * OK [UNSEEN 0] * OK [UIDNEXT 1] Predicted next UID * OK [PERMANENTFLAGS ( \*)] 03 OK [READ-ONLY] EXAMINE Completed 04 logout * BYE IMAP4rev1 Server terminating connection 04 OK LOGOUT Completed Log: 178.38.163.213 - - [30/Jun/2013:18:35:50 GMT] GET /SOGo/so/12LeuTil/Mail HTTP/1.1 302 0/0 0.003 - - 0 Jun 30 18:35:50 sogod [1346]: [ERROR] 0x0xb8688dd0[NGLdapAttribute] cound not convert value of objectSid to string Jun 30 18:35:50 sogod [1346]: [ERROR] 0x0xb8774e20[NGLdapAttribute] cound not convert value of objectGUID to string 2013-06-30 18:35:50.416 sogod[1346] WARNING: IMAP4 connection pooling is disabled! 2013-06-30 18:35:50.692 sogod[1346] Note(NGImap4Connection): using '/' as the IMAP4 folder separator. Jun 30 18:36:50 sogod [1275]: [WARN] 0x0xb846ae10[WOWatchDogChild] pid 1346 has been hanging in the same request for 1 minutes Has anybody an idea what I'm doing wrong? Thanks in advance ueli -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo - ResourceConfiguration
Hello Igor, Thanks for the link on SOGo Resources. I will read that tonight and see how much I get to understand. I had already checked the SOGo Installation Guide. Here is what I think caused my problem: I had logged in as the resource and created an event. Sorry, I did not remember to keep the event details before I deleted it. However, after I deleted the event, I was able to login as myself and create an event and invite the resource as a participant - successfully. Viewing the Raw source of the event: BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 2.0.6b//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Africa/Nairobi X-LIC-LOCATION:Africa/Nairobi BEGIN:STANDARD TZOFFSETFROM:+0300 TZOFFSETTO:+0300 TZNAME:EAT DTSTART:19700101T00 END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:C651-51D42400-1F-6B8B4580 SUMMARY:Test Event DESCRIPTION:Test CLASS:PUBLIC ATTENDEE;PARTSTAT=ACCEPTED;RSVP=TRUE;ROLE=REQ-PARTICIPANT;CN=room1@crownken ya.com:mailto:ro...@crownkenya.com ORGANIZER;CN=w...@crownkenya.com:mailto:w...@crownkenya.com CREATED:20130703T131725Z DTSTAMP:20130703T131725Z LAST-MODIFIED:20130703T131725Z DTSTART;TZID=Africa/Nairobi:20130708T08 DTEND;TZID=Africa/Nairobi:20130708T15 TRANSP:OPAQUE END:VEVENT END:VCALENDAR So, perhaps what I need to understand is that when multiple_bookings = 1 and someone else already has booked an event, then the resource become unavailable, right??? That would explain why I wasn't able to add the resource as participant in my event because resource already had a booking. If the room1 is a resource, should it not be able to accessible it at different times, as long as there is no clash/overlap in the schedules? I think this Resources thing is beginning to sink in now -- if a resource is booked for an event, it should be unavailable to others. However, I think it should be available when there is no clash/overlap in the event schedules, right? On 3 July 2013 15:51, Igor Vitorac igor.vito...@eurodyn.be wrote: Try to search for SOGo Resources This might be useful: https://inverse.ca/sogo/lists/arc/users/2011-04/msg00303.html Check SOGo user guide for options for the resources. You have some explanations there. Regarding wiki page: http://wiki.sogo.nu/ResourceConfiguration I have added Configure resources with SQL databases part, so I might be able to help you. Regarding SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); It is recommended settings, but you need minimum DAndTViewer in order to be able to see free/busy. If you have changed sogo.conf, do not forget to reload sogod as well as memched and apache. Just to be on the safe side. :-) Regards, Igor Odhiambo Washington wrote, On 03/07/2013 11:28: I hope I am not pissing off guys on this forum with my myriad questions about SOGo - having discovered it just the other week after someone mentioned it on another mailing list. I realize SOGo is not for FreeBSD, but I have several servers that could do with such a Groupware and I am learning the curves while playing and getting stuck. I just learnt about Resource Configuration from an old thread: http://wiki.sogo.nu/ResourceConfiguration I still don't understand it. Why do I require this? Can someone please give me a case scenario? I am using MySQL auth, using a VIEW instead of a standalone database. Before knowing a use case of Resources, I configured it on my test platform and promptly got stuck! I created a user(resource): +--+---+--+--+--+---+ | c_uid| c_name| c_cn | mail | kind | multiple_bookings | +--+---+--+--+--+---+ | ro...@crownkenya.com | Meeting Room1 | ro...@crownkenya.com | ro...@crownkenya.com | location | 1 | +--+---+--+--+--+---+ I then added the following to sogo.conf: SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); I understand that is the ACL required to enable a resource to work. Under my SOGoUserResourced, I added two parameters: MultipleBookingsFieldName = multiple_bookings; KindFieldName = kind; Now, as the Wiki says (remember I still don't quite understand the use case for this) I logged in and created an event in my Calendar and tried to add the resource as a participant. The problem is I could NOT save the event! The following would display in sogo.log: Jul 03 12:28:14 sogod [50769]: |SOGo| starting method 'POST' on uri '/SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715' Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find
Re: [SOGo] sogo segfault (2.0.6b) - SOLVED
I managed to solve this problem. It was all to do with permissions on /var/log/sogo/ For some reason, the permissions were wrong, because of uid changing during installs. On 30 June 2013 18:43, Odhiambo Washington odhia...@gmail.com wrote: I have kinda made a step fwd. I can run sogo from the debug mode[0], but when I try to start it normally, I get the following in /var/log.messages: Jun 30 18:26:41 gw sogod: 2013-06-30 18:26:41.693 sogod[58347] unable to get status of descriptor 2 - Bad file descriptor Jun 30 18:28:05 gw sogod: 2013-06-30 18:28:05.152 sogod[58733] unable to get status of descriptor 2 - Bad file descriptor Jun 30 18:29:42 gw sogod: 2013-06-30 18:29:42.984 sogod[70515] unable to get status of descriptor 2 - Bad file descriptor Is this something easy to overcome? [0] [sogo@gw ~]$ gdb --args /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type show copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386-marcel-freebsd... (gdb) r Starting program: /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPi dFile /tmp/sogo.pid Jun 30 18:40:11 sogod [72874]: version 2.0.6b (build r...@gw.kictanet.or.ke 201306301829) -- starting Jun 30 18:40:11 sogod [72874]: vmem size check enabled: shutting down app when vmem 1024 MB Jun 30 18:40:11 sogod [72874]: 0x0x23be7df4[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jun 30 18:40:11 sogod [72874]: 0x0x23be7df4[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jun 30 18:40:11 sogod [72874]: |SOGo| WOHttpAdaptor listening on address *:2 On 29 June 2013 23:46, Odhiambo Washington odhia...@gmail.com wrote: # su - sogo -s /usr/local/bin/bash [sogo@gw ~]$ gdb --args /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type show copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386-marcel-freebsd... (gdb) r Starting program: /usr/local/GNUstep/Local/Tools/Admin/sogod -WOUseWatchDog NO -WONoDetach YES -WOPort 2 -WOWorkersCount 1 -WOLogFile - -WOPidFile /tmp/sogo.pid /libexec/ld-elf.so.1: Shared object libSOGo.so.2 not found, required by sogod Program exited with code 01. (gdb) quit [sogo@gw ~]$ exit logout root@gw:/ # ls -al /usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/Versions/2/ total 1784 drwxr-xr-x 4 root wheel 512 Jun 29 23:31 . drwxr-xr-x 3 root wheel 512 Jun 29 23:30 .. drwxr-xr-x 2 root wheel 1536 Jun 29 23:30 Headers drwxr-xr-x 2 root wheel 512 Jun 29 23:31 Resources lrwxr-xr-x 1 root wheel 10 Jun 29 23:31 SOGo - libSOGo.so lrwxr-xr-x 1 root wheel 12 Jun 29 23:31 libSOGo.so - libSOGo.so.2 lrwxr-xr-x 1 root wheel 17 Jun 29 23:31 libSOGo.so.2 - libSOGo.so.2.0.6b -rwxr-xr-x 1 root wheel 1786194 Jun 29 23:31 libSOGo.so.2.0.6b Odd! It is complaining about a file that is actually there! I've even added the path to the hints file, but no luck still. ldconfig -r | grep GNU search directories: /lib:/usr/lib:/usr/lib/compat:/usr/local/lib:/usr/local/lib/compat/pkg:/usr/local/GNUstep/Local/Library/:/usr/local/GNUstep/System/Library/Libraries:/usr/local/lib/compat:/usr/local/lib/dovecot:/usr/local/lib/gcc42:/usr/local/lib/mysql:/usr/local/lib/nss:/usr/local/lib/pth:/usr/local/libexec/openldap What next? On 29 June 2013 15:58, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-06-29 6:30 AM, Odhiambo Washington wrote: Is there a way I can track this to find out the cause of the segfault? http://www.sogo.nu/nc/support/**faq/article/how-do-i-debug-**sogo.htmlhttp://www.sogo.nu/nc/support/faq/article/how-do-i-debug-sogo.html -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE
[SOGo] Feature Request
The documentation says SOGoLoginDomains parameter used to define which domains should be selectable from the login page. This parameter is an array of keys from the domains dictionary. In a situation of single or even multiple domains, I'd love to have a user only input their username and then select the domain. Sogo should then concat username and domain in the form username@domain and present this to the IMAP server as the uid for login. I run a system of virtual domains where users are required to login with username@domain. At the moment, even if I enable SOGoLoginDomains, I still have to enter the whole username@domain on the webUI in order to login. This makes the domain selection useless. Unless I am missing a config for SOGo to achieve the above, I'd love to get the feature. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Out of office
Here is a guide - not a school. http://www.catb.org/~esr/faqs/smart-questions.html I meant every word that I said. You must specify at least the environment under which you are facing the problem. And it's always good to accompany your question with some data - like logs or even screenshots showing the errors. Just be assured - I am not afraid of abuses. I am actually immune to them, especially when pointing out what someone needs to do. I believe you are so lucky to still be in the SOGo Users list. Marcotte must be a very magnanimous fellow to have retracted your suspension. On 10 July 2013 18:53, raymondpotgie...@telkomsa.net wrote: ** Sorry Odhiambo, can you please inform me where you studied so I can apply for the smart course... Read bud read... Don't just jump in at the middle and give crappy comments like this... And Oh I know a shop down the road that has crystal balls if you are interested.. Sent via my BlackBerry from Vodacom - let your email find you! -- *From: * Odhiambo Washington odhia...@gmail.com *Date: *Wed, 10 Jul 2013 17:40:30 +0300 *To: *raymondpotgie...@telkomsa.net *Subject: *Re: [SOGo] Out of office Raymond, You really need to learn how to ask smart questions. Without ever giving the background against which you are working, everybody will need a crystal ball to figure out what you are talking about. On 10 July 2013 17:19, raymondpotgie...@telkomsa.net wrote: The one time I got outlook to connect with the zeg (before everything) stopped working I checked the Out of Office message option on the outlook menu and it was grayed out. I could see the out of office option using the sogo web gui. This is why I am thinking that it does not yet work with outlook? Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: Martin Rabl martin.r...@rablnet.de Date: Wed, 10 Jul 2013 15:46:51 To: users@sogo.nu Reply-To: users@sogo.nu Subject: Re: [SOGo] Out of office What do you mean? It runs quite good. But it sets up on top of sieve. Am 10.07.2013 14:16, schrieb raymondpotgie...@telkomsa.net: Hi guys, is there a plan to have the 'out of office' function working in future? Ray Sent via my BlackBerry from Vodacom - let your email find you! -- Greetings, Martin Rabl -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Out of office
If you can go back and reread the original question - the one liner you posted from your Blackberry, it was quite casual, and that is what I meant, and still against, hence my advise. People are not in the forum to guess what you are running. If you are testing ZEG, you must say so. If you are running a production system, you MUST say so. YOU MUST always define the environment. You can close the matter. No point writing to me offlist. On 10 July 2013 19:06, raymondpotgie...@telkomsa.net wrote: ** If you just take a second, calm yourself down and read what I said I was asking about the 'out of office' function and that I saw the it was grayed out in outlook, why can Martin give me a civilized answer but you go and insult me? There is no need for log post if you just read my question. Why do people like you attack the person who asks a question? Sent via my BlackBerry from Vodacom - let your email find you! -- *From: * Odhiambo Washington odhia...@gmail.com *Date: *Wed, 10 Jul 2013 18:59:51 +0300 *To: *raymondpotgie...@telkomsa.net; users@sogo.nu *Subject: *Re: [SOGo] Out of office Here is a guide - not a school. http://www.catb.org/~esr/faqs/smart-questions.html I meant every word that I said. You must specify at least the environment under which you are facing the problem. And it's always good to accompany your question with some data - like logs or even screenshots showing the errors. Just be assured - I am not afraid of abuses. I am actually immune to them, especially when pointing out what someone needs to do. I believe you are so lucky to still be in the SOGo Users list. Marcotte must be a very magnanimous fellow to have retracted your suspension. On 10 July 2013 18:53, raymondpotgie...@telkomsa.net wrote: ** Sorry Odhiambo, can you please inform me where you studied so I can apply for the smart course... Read bud read... Don't just jump in at the middle and give crappy comments like this... And Oh I know a shop down the road that has crystal balls if you are interested.. Sent via my BlackBerry from Vodacom - let your email find you! -- *From: * Odhiambo Washington odhia...@gmail.com *Date: *Wed, 10 Jul 2013 17:40:30 +0300 *To: *raymondpotgie...@telkomsa.net *Subject: *Re: [SOGo] Out of office Raymond, You really need to learn how to ask smart questions. Without ever giving the background against which you are working, everybody will need a crystal ball to figure out what you are talking about. On 10 July 2013 17:19, raymondpotgie...@telkomsa.net wrote: The one time I got outlook to connect with the zeg (before everything) stopped working I checked the Out of Office message option on the outlook menu and it was grayed out. I could see the out of office option using the sogo web gui. This is why I am thinking that it does not yet work with outlook? Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: Martin Rabl martin.r...@rablnet.de Date: Wed, 10 Jul 2013 15:46:51 To: users@sogo.nu Reply-To: users@sogo.nu Subject: Re: [SOGo] Out of office What do you mean? It runs quite good. But it sets up on top of sieve. Am 10.07.2013 14:16, schrieb raymondpotgie...@telkomsa.net: Hi guys, is there a plan to have the 'out of office' function working in future? Ray Sent via my BlackBerry from Vodacom - let your email find you! -- Greetings, Martin Rabl -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] opening winmail.dat files
I believe it's doable. I am running SOGo and groupoffice in the same environment and a user can use whichever they want. Database is shared. SOGo is using a VIEW of the database that I use for groupoffice. On 12 July 2013 16:02, raymondpotgie...@telkomsa.net wrote: Hi MJ hope you are well. By what you are saying are you running both Roundcube and Sogo in your environment? Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: mourik jan heupink heup...@gmail.com Date: Fri, 12 Jul 2013 14:44:08 To: users@sogo.nu Reply-To: users@sogo.nu Subject: Re: [SOGo] opening winmail.dat files Hi Silver, It's not possible as far as I know: It's one of the most annoying shortcomings of SOGo at the moment. As I said in the bugreport: roundcube works, so at least we can tell our staff to use roundcube to open these mails. MJ On 07/11/2013 10:24 AM, Silver Salonen wrote: Hi. Is it somehow possible to see contents of winmail.dat files from the webmail? There is bug report http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=2242 for that, but it's pending? -- Silver -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Regarding installation of SOgo
Here you go: 1. (a) http://www.onlinedemo.hu/71-zeg-install-script OR (b) http://goo.gl/lBdJE OR (c) http://www.sogo.nu/english/downloads/backend_nightly.html - See the links to the FAQs 2. Installation on Windows - Use the VMWARE or VirtualBox appliace from http://www.sogo.nu/english/downloads/zeg.html - whichever pleases you. 3. RTFM 4. RTFM 5. RTFM 6. Google search still works the last time I checked:) On 15 July 2013 17:47, akkikuma...@gmail.com wrote: Well I am complete beginner to sogo.I need to try Sogo in my own Pc.I m using Windows 7 and Ubuntu . 1.Please describe full installation process. 2.if possible installation in windows 7. 3.Deployment procedure in Microsoft outlook. 4.Deployment in Mozilla Thunderbird. 5.Any further suggestion is welcome will be waiting for ur replies. Thanks in advance.. -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Modifying template
On 15 July 2013 16:31, Szládovics Péter p...@szladovics.hu wrote: 2013-07-15 15:35 keltezéssel, ABBAS Alain írta: yes i restarted sogo, memcached and apache Where did you modify the files? In the original place (after backup) or copy them into ~/GNUsteps and there? SOGo not use GNUsteps after 2.0.5... SOGo doesn't use GNUstep after 2.0.5 ??? Hmm, my installations always sucked in GNUstep in FreeBSD!! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Modifying template
LOL... I excuse your English:) On 15 July 2013 18:17, Sven Schwedas sven.schwe...@tao.at wrote: As far as I know, only the location of the config file was changed from ~/GNUstep… to /etc/, don't get your hopes up. :-) On 15.07.2013 17:04, Odhiambo Washington wrote: On 15 July 2013 16:31, Szládovics Péter p...@szladovics.hu wrote: 2013-07-15 15:35 keltezéssel, ABBAS Alain írta: yes i restarted sogo, memcached and apache Where did you modify the files? In the original place (after backup) or copy them into ~/GNUsteps and there? SOGo not use GNUsteps after 2.0.5... SOGo doesn't use GNUstep after 2.0.5 ??? Hmm, my installations always sucked in GNUstep in FreeBSD!! -- Mit freundlichen Grüßen, / Best Regards, Sven SCHWEDAS Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167 http://software.tao.at -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Regarding installation of SOgo
You must RTFM! I gave you all the details! So start from Zero. SOGo is NOT a WIndows Application. Please run MS Exchange if you must run Windows! On 15 July 2013 18:24, Akki Kumar akkikuma...@gmail.com wrote: Can u please suggest me .Weather these components are required in Sogo installation.As some of these are supportive in LINUX not in Windows. 1.Database server -PostgreSQL 7.4 2. LDAP server- OpenLDAP 2.3.x. 3. SMTP server-Postfix 2.x. 4.IMAP server- Cyrus IMAP Server 2.3.x On 7/15/13, Odhiambo Washington odhia...@gmail.com wrote: Here you go: 1. (a) http://www.onlinedemo.hu/71-zeg-install-script OR (b) http://goo.gl/lBdJE OR (c) http://www.sogo.nu/english/downloads/backend_nightly.html - See the links to the FAQs 2. Installation on Windows - Use the VMWARE or VirtualBox appliace from http://www.sogo.nu/english/downloads/zeg.html - whichever pleases you. 3. RTFM 4. RTFM 5. RTFM 6. Google search still works the last time I checked:) On 15 July 2013 17:47, akkikuma...@gmail.com wrote: Well I am complete beginner to sogo.I need to try Sogo in my own Pc.I m using Windows 7 and Ubuntu . 1.Please describe full installation process. 2.if possible installation in windows 7. 3.Deployment procedure in Microsoft outlook. 4.Deployment in Mozilla Thunderbird. 5.Any further suggestion is welcome will be waiting for ur replies. Thanks in advance.. -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Change Password
I can confirm the change password works with MySQL with encrypted passwords! On 16 July 2013 15:29, Bo Lynch bly...@ameliaschools.com wrote: On Mon, July 15, 2013 4:47 pm, Szládovics Péter wrote: 2013-07-15 22:17 keltezéssel, bly...@ameliaschools.com írta: Hello everyone, We are in the process of migrating over to SOGo. I have all of my users there and everything up and running except for one thing that is giving me some issues...we are authenticating via ldap and my users are not able to change there password. In the sogo log I get a message stating Jul 15 20:15:45 sogod [29715]: 0x0x8db06cc[LDAPSource] NSException: 0x9235784 NAME:LDAPException REASON:operation modify failed: Insufficient access (0x32) INFO:{dn = uid=blynch,ou=users,dc=mydomain,dc=com; } I have SOGoPasswordChangeEnabled = YES; Im thinking this is something really simple that Im missing. Any help would be greatly appreciated. Hi, Which LDAP do you talk about? AFAIK the SOGo password change feature works only with OpenLDAP+clear text passwords. If you have other type of ldap or auth, you need to find other method to change passwords. -- users@sogo.nu https://inverse.ca/sogo/lists We are using openldap-2.3.43-25.el5_8.1. So no crypt passwords for ldap? Bummer. Does the change password work with mysql with encrypted passwords? -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Log to syslog
From what I see in the documentation, there are only two options: WOLogFile = /path/t/file; # Log to file WOLogFile = -; # Log to console I cannot see how it can be made to log to syslog. On 22 July 2013 15:10, Corrado Fiore mail...@corradofiore.it wrote: Dear All, we would like to use Rsyslogd to redirect all logs to a centralized server. Is there a way to have SOGo write logs to 'syslog' instead of a file? I have searched through the documentation and the mailing list's archives but have found nothing so far. Thanks for your help. Best, Corrado Fiore -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] TimeZone setting
Can someone please tell me why my: SOGoTimeZone = Africa/Kenya or SOGoTimeZone = UTC+3 is always ignored by sogod. 2013-07-22 13:44:45.689 sogod[14194] No local time zone specified. 2013-07-22 13:44:45.689 sogod[14194] Using time zone with absolute offset 0. Jul 22 13:44:45 sogod [14194]: version 2.0.6b (build r...@gw.kictanet.or.ke 201307071644) -- starting Jul 22 13:44:45 sogod [14194]: vmem size check enabled: shutting down app when vmem 1024 MB Jul 22 13:44:45 sogod [14194]: 0x0x23c16234[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jul 22 13:44:45 sogod [14194]: 0x0x23c16234[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] listening on *:2 Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] watchdog process pid: 14194 Jul 22 13:44:45 sogod [14194]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] preparing 1 children Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] child spawned with pid 14195 -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TimeZone setting
On 22 July 2013 16:55, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-07-22 9:51 AM, Odhiambo Washington wrote: is always ignored by sogod. You have to use a timezone from this list: https://github.com/inverse-inc/sogo/tree/master/SOPE/NGCards/TimeZones ..and that solves it! Thanks. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] TimeZone setting
What I found confusing is this: root@gw:/usr/home/wash # grep TimeZone /usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/Versions/2/Resources/SOGoDefaults.plist SOGoTimeZone = UTC; So I thought sogo.conf would take UTC+3 as the TZ. Now I am wondering if that value in SOGoDefaults.plist conflicts with Ludovics answer, but since my problem was solved, I had no reason to query the relevance of what is in this SOGoDefaults.plist - until someone else bites:) On 22 July 2013 18:09, Szládovics Péter p...@szladovics.hu wrote: 2013-07-22 15:51 keltezéssel, Odhiambo Washington írta: Can someone please tell me why my: SOGoTimeZone = Africa/Kenya or SOGoTimeZone = UTC+3 is always ignored by sogod. 2013-07-22 13:44:45.689 sogod[14194] No local time zone specified. 2013-07-22 13:44:45.689 sogod[14194] Using time zone with absolute offset 0. Jul 22 13:44:45 sogod [14194]: version 2.0.6b (build r...@gw.kictanet.or.ke 201307071644) -- starting Jul 22 13:44:45 sogod [14194]: vmem size check enabled: shutting down app when vmem 1024 MB Jul 22 13:44:45 sogod [14194]: 0x0x23c16234[SOGoProductLoader] SOGo products loaded from '/usr/local/GNUstep/Local/Library/SOGo': Jul 22 13:44:45 sogod [14194]: 0x0x23c16234[SOGoProductLoader] Appointments.SOGo, Contacts.SOGo, Mailer.SOGo, CommonUI.SOGo, ContactsUI.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, MainUI.SOGo, PreferencesUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] listening on *:2 Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] watchdog process pid: 14194 Jul 22 13:44:45 sogod [14194]: 0x0x21464020[WOWatchDogChild] watchdog request timeout set to 10 minutes Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] preparing 1 children Jul 22 13:44:45 sogod [14194]: 0x0x23bfe304[WOWatchDog] child spawned with pid 14195 I think you need Afrika/Nairobi instead of Afrika/Kenya -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Misunderstanding SOGo
Thanks Christian, for the clarification. I use SOGo SxS with Groupoffice and I find that Groupoffice allows me to have a dropdown of the domains available on the system so that a user only enters their first part of the e-mail address and then chooses the domain from the dropdown.However, where as Groupoffice uses IMAP authentication, I don't know how SOGo achieves the authentication. For SOGo I have to enter the full e-mail address even despite having a dropdown of the domains. In this respect I still find groupoffice easier to use than SOGo - so far. I am sticking to SOGo in order to see if one day I am able to get funambol working on FreeBSD. Right now it doesn't compile. On 23 July 2013 11:50, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Am 2013-07-06 01:52, schrieb Mark Madere: if your users login with their full email address (i.e.: u...@host.com), you do not need to set these parameters: SOGoEnableDomainBasedUID SOGoDomainsVisibility SOGoLoginDomains These parameters effect the login page only. You may exclude them from your config. That is not correct for SOGoDomainsVisibility. This option defines, whether the users of one domain can see the global address book of another domain. This affects sharing and autocompletion when writing emails or inviting people to an event. So e.g. if you have a domain per department and you want to have all addresses visible for each user in your company, then you have to set this option. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Misunderstanding SOGo
Hi Giovanni, Sorry, I meant openchange, not funambol. It was a slip of the brain, transmitted to the fingures:) Do you also have OpenChange installed? On FreeBSD, we have a port (mail/libmapi) which is our openchange equiv. It is stuck on COCHRANE, but doesn't even compile on my FreeBSD It's actually the show stopper I encountered. On 23 July 2013 12:30, Giovanni Bechis giova...@bigio.snb.it wrote: On 07/23/13 11:23, Odhiambo Washington wrote: Thanks Christian, for the clarification. I use SOGo SxS with Groupoffice and I find that Groupoffice allows me to have a dropdown of the domains available on the system so that a user only enters their first part of the e-mail address and then chooses the domain from the dropdown.However, where as Groupoffice uses IMAP authentication, I don't know how SOGo achieves the authentication. For SOGo I have to enter the full e-mail address even despite having a dropdown of the domains. In this respect I still find groupoffice easier to use than SOGo - so far. I am sticking to SOGo in order to see if one day I am able to get funambol working on FreeBSD. Right now it doesn't compile. I am using the precompiled version on OpenBSD and it works very well, I think it should run on FreeBSD too: http://sourceforge.net/projects/funambol/files/bundle/v10/funambol-10.0.3.tgz/download Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Misunderstanding SOGo
On FreeBSD, there is Samba-4.0.7 at the moment, which is the latest. I think the port maintainer for libmapi is perhaps busy with other things to find time to update:) On 23 July 2013 13:30, Giovanni Bechis giova...@bigio.snb.it wrote: On 07/23/13 12:24, Odhiambo Washington wrote: Hi Giovanni, Sorry, I meant openchange, not funambol. It was a slip of the brain, transmitted to the fingures:) Do you also have OpenChange installed? On FreeBSD, we have a port (mail/libmapi) which is our openchange equiv. It is stuck on COCHRANE, but doesn't even compile on my FreeBSD It's actually the show stopper I encountered. First we have to finish porting samba4, then we will try with OpenChange, ... Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 16:08, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 14:41 keltezéssel, Christian Mack írta: Hello Odhiambo Washington Am 2013-07-02 13:01, schrieb Odhiambo Washington: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf I enabled sogo-ealarms-notify in my cron and it keeps sending these: 2013-07-02 11:03:02.314 sogo-ealarms-notify[21090] No local time zone specified. 2013-07-02 11:03:02.334 sogo-ealarms-notify[21090] Using time zone with absolute offset 0. Do I need to specify the TZ in another file? Is your cronjob executed as user sogo? Is your system Ubuntu? Check the /etc/timezone. If it doesn't exist or doesn't valid, you need to run tzselect with answers 1-23-1 ;) Or run 'dpkg-reconfigure tzdata' - of course all of them with needed righst. These are set the timezone settings system wide. On /etc/cron.d/sogo you need to check the user 'sogo' between the schedule and command settings: * * * * * sogo/usr/sbin/sogo-ealarms-notify ^ Cheers, Peter AFAICS, my configuration looks correct, at least as far as FreeBSD is concerned. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 16:53, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:49 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. What's happen if you start the command from command line as sogo user? In my response to Christian, I have detailed it. I however copy paste again here: root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2013-07-24 13:02:31.663 sogo-ealarms-notify[17614] No local time zone specified. 2013-07-24 13:02:31.664 sogo-ealarms-notify[17614] Using time zone with absolute offset 0. However, if I specify the TZ enviroment variable, it doesn't complain: [sogo@gw ~]$ export TZ=Africa/Nairobi [sogo@gw ~]$ env SHELL=/usr/local/bin/bash TERM=linux USER=sogo FTP_PASSIVE_MODE=YES PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/var/db/sogo/bin MAIL=/var/mail/sogo BLOCKSIZE=K PWD=/var/db/sogo TZ=Africa/Nairobi SHLVL=1 HOME=/var/db/sogo _=/usr/bin/env [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify [sogo@gw ~]$ -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 19:18, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:55 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:53, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:49 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. What's happen if you start the command from command line as sogo user? In my response to Christian, I have detailed it. I however copy paste again here: root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ /usr/local/GNUstep/Local/**Tools/Admin/sogo-ealarms-**notify 2013-07-24 13:02:31.663 sogo-ealarms-notify[17614] No local time zone specified. 2013-07-24 13:02:31.664 sogo-ealarms-notify[17614] Using time zone with absolute offset 0. However, if I specify the TZ enviroment variable, it doesn't complain: [sogo@gw ~]$ export TZ=Africa/Nairobi [sogo@gw ~]$ env SHELL=/usr/local/bin/bash TERM=linux USER=sogo FTP_PASSIVE_MODE=YES PATH=/sbin:/bin:/usr/sbin:/**usr/bin:/usr/games:/usr/local/** sbin:/usr/local/bin:/var/db/**sogo/bin MAIL=/var/mail/sogo BLOCKSIZE=K PWD=/var/db/sogo TZ=Africa/Nairobi SHLVL=1 HOME=/var/db/sogo _=/usr/bin/env [sogo@gw ~]$ /usr/local/GNUstep/Local/**Tools/Admin/sogo-ealarms-**notify [sogo@gw ~]$ TZ variable won't help. I no have it too, but all features are working fine without this error. Could you please give us a strace output? Any guideline on how to run the trace? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 20:09, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 18:50 keltezéssel, Odhiambo Washington írta: On 24 July 2013 19:18, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:55 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:53, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:49 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. What's happen if you start the command from command line as sogo user? In my response to Christian, I have detailed it. I however copy paste again here: root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2013-07-24 13:02:31.663 sogo-ealarms-notify[17614] No local time zone specified. 2013-07-24 13:02:31.664 sogo-ealarms-notify[17614] Using time zone with absolute offset 0. However, if I specify the TZ enviroment variable, it doesn't complain: [sogo@gw ~]$ export TZ=Africa/Nairobi [sogo@gw ~]$ env SHELL=/usr/local/bin/bash TERM=linux USER=sogo FTP_PASSIVE_MODE=YES PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/var/db/sogo/bin MAIL=/var/mail/sogo BLOCKSIZE=K PWD=/var/db/sogo TZ=Africa/Nairobi SHLVL=1 HOME=/var/db/sogo _=/usr/bin/env [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify [sogo@gw ~]$ TZ variable won't help. I no have it too, but all features are working fine without this error. Could you please give us a strace output? Any guideline on how to run the trace? Of course. strace. So, you log in as sogo user, and run the command as: strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/path/to/output.file And then send the output file to us (or share it somewhere). Before check the strace exists on your syístem. If not, this maybe helps: http://www.cyberciti.biz/faq/howto-installl-strace-under-freebsd/ [sogo@gw ~]$ pwd /var/db/sogo [sogo@gw ~]$ strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/var/db/sogo/output.file [sogo@gw ~]$ less output.file strace: open(/proc/..., ...): No such file or directory trouble opening proc file -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 20:42, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 19:31 keltezéssel, Odhiambo Washington írta: On 24 July 2013 20:09, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 18:50 keltezéssel, Odhiambo Washington írta: On 24 July 2013 19:18, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:55 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:53, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:49 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. What's happen if you start the command from command line as sogo user? In my response to Christian, I have detailed it. I however copy paste again here: root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2013-07-24 13:02:31.663 sogo-ealarms-notify[17614] No local time zone specified. 2013-07-24 13:02:31.664 sogo-ealarms-notify[17614] Using time zone with absolute offset 0. However, if I specify the TZ enviroment variable, it doesn't complain: [sogo@gw ~]$ export TZ=Africa/Nairobi [sogo@gw ~]$ env SHELL=/usr/local/bin/bash TERM=linux USER=sogo FTP_PASSIVE_MODE=YES PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/var/db/sogo/bin MAIL=/var/mail/sogo BLOCKSIZE=K PWD=/var/db/sogo TZ=Africa/Nairobi SHLVL=1 HOME=/var/db/sogo _=/usr/bin/env [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify [sogo@gw ~]$ TZ variable won't help. I no have it too, but all features are working fine without this error. Could you please give us a strace output? Any guideline on how to run the trace? Of course. strace. So, you log in as sogo user, and run the command as: strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/path/to/output.file And then send the output file to us (or share it somewhere). Before check the strace exists on your syístem. If not, this maybe helps: http://www.cyberciti.biz/faq/howto-installl-strace-under-freebsd/ [sogo@gw ~]$ pwd /var/db/sogo [sogo@gw ~]$ strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/var/db/sogo/output.file [sogo@gw ~]$ less output.file strace: open(/proc/..., ...): No such file or directory trouble opening proc file Did you see the link what I send above? The main parts are RED *WARNING!* These examples only work for i386 32 bit FreeBSD computer (strace is not ported to amd64 arch [64 bit]). Install strace First update FreeBSD ports collection and install strace from /usr/ports/devel/strace: # portsnap fetch update # cd /usr/ports/devel/strace # make install clean Mount /proc file system You need to mount /proc filesystem to use trace command under FreeBSD, enter: # mount -t procfs proc /proc I did. root@gw:/usr/home/wash # mount | grep proc procfs on /proc (procfs, local) root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/var/db/sogo/output.file outout.file contains: pread: Device busy pread: Device busy pread: Device busy pread: Device busy PIOCRUN: Input/output error trouble opening proc file -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
On 24 July 2013 21:07, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 19:55 keltezéssel, Odhiambo Washington írta: On 24 July 2013 20:42, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 19:31 keltezéssel, Odhiambo Washington írta: On 24 July 2013 20:09, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 18:50 keltezéssel, Odhiambo Washington írta: On 24 July 2013 19:18, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:55 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:53, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:49 keltezéssel, Odhiambo Washington írta: On 24 July 2013 16:44, Szládovics Péter p...@szladovics.hu wrote: 2013-07-24 15:08 keltezéssel, Odhiambo Washington írta: I have SOGoTimeZone = Africa/Nairobi; in sogo.conf, but that seems to be ignored. The platform is FreeBSD, if that matters. I think the tzselect maybe can help to you - some minimal linuxes is contain this command (in the libc-bin package). I think the bsd is contains too. In FreeBSD, we use tzsetup, which writes to /etc/locatime. My TZ setup is fine. This appears to be a SOGo issue, I am afraid. What's happen if you start the command from command line as sogo user? In my response to Christian, I have detailed it. I however copy paste again here: root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2013-07-24 13:02:31.663 sogo-ealarms-notify[17614] No local time zone specified. 2013-07-24 13:02:31.664 sogo-ealarms-notify[17614] Using time zone with absolute offset 0. However, if I specify the TZ enviroment variable, it doesn't complain: [sogo@gw ~]$ export TZ=Africa/Nairobi [sogo@gw ~]$ env SHELL=/usr/local/bin/bash TERM=linux USER=sogo FTP_PASSIVE_MODE=YES PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/var/db/sogo/bin MAIL=/var/mail/sogo BLOCKSIZE=K PWD=/var/db/sogo TZ=Africa/Nairobi SHLVL=1 HOME=/var/db/sogo _=/usr/bin/env [sogo@gw ~]$ /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify [sogo@gw ~]$ TZ variable won't help. I no have it too, but all features are working fine without this error. Could you please give us a strace output? Any guideline on how to run the trace? Of course. strace. So, you log in as sogo user, and run the command as: strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/path/to/output.file And then send the output file to us (or share it somewhere). Before check the strace exists on your syístem. If not, this maybe helps: http://www.cyberciti.biz/faq/howto-installl-strace-under-freebsd/ [sogo@gw ~]$ pwd /var/db/sogo [sogo@gw ~]$ strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/var/db/sogo/output.file [sogo@gw ~]$ less output.file strace: open(/proc/..., ...): No such file or directory trouble opening proc file Did you see the link what I send above? The main parts are RED *WARNING!* These examples only work for i386 32 bit FreeBSD computer (strace is not ported to amd64 arch [64 bit]). Install strace First update FreeBSD ports collection and install strace from /usr/ports/devel/strace: # portsnap fetch update # cd /usr/ports/devel/strace # make install clean Mount /proc file system You need to mount /proc filesystem to use trace command under FreeBSD, enter: # mount -t procfs proc /proc I did. root@gw:/usr/home/wash # mount | grep proc procfs on /proc (procfs, local) root@gw:/usr/home/wash # su - sogo [sogo@gw ~]$ strace /usr/local/GNUstep/Local/Tools/Admin/sogo-ealarms-notify 2/var/db/sogo/output.file outout.file contains: pread: Device busy pread: Device busy pread: Device busy pread: Device busy PIOCRUN: Input/output error trouble opening proc file Hmmm... Should be working... Could you please run it as root? Same result! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-ealarms-notify - where does it read TZ from?
It's not possible to do this. There is no such path as suggested by Ludovic (Marcotte) in FreeBSD when SOGo/SOPE are installed from FreeBSD ports. I'll let Jim Riggs take a decision on this. He created the FreeBSD ports. PS: Installing SOPE using the FreeBSD ports still sucks in GNUstep! On 25 July 2013 21:00, Szládovics Péter p...@szladovics.hu wrote: 2013-07-25 19:40 keltezéssel, Ludovic Marcotte írta: On 2013-07-25 1:37 PM, Szládovics Péter wrote: I think the most safe solution, if the sogo-ealarms-notify get the TZ info from the sogo.conf. It will work under every ports of sogo. It could be a bug related to moving towards /etc/sogo/sogo.conf. Try putting back your config in /home/sogo/GNUstep/Defaults/.**GNUstepDetaults and see if it fixes the issue. Odhiambo, can you try this? During the test you need to rename the /etc/timezone. Ludovic, why should be a bug related that? I thought sogo doesn't use the GNUstep since version 2.0.5... -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Compile sope-2.2.5 failed
Hi, I am trying to install SOPE-2.2.5 on FreeBSD 8.4-i386 but it's failing as you see from the log at: http://62.8.65.102/~wash/sogo-2.2.5-log.txt Will appreciate any assistance. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sog@ on FreeBSD
I have been running SOGo (for fun) on FreeBSD for quite some time now - almost a year I think. The issue is compiling it. Once you get past that, there shouldn't be much problem. SOPE is required definately and they are both in the ports. Maybe the versions are old, but if you ask me, I did a lof of compiling by hand once I decided to play with it. I think I got stuck once we reached 2.2.5 because couldn't compile successfully, posted here and no one bothered:-) Let me try 2.2.9 and see where I end up. On 21 October 2014 01:59, Sebastian Reitenbach sebas...@l00-bugdead-prods.de wrote: Hi, On Monday, October 20, 2014 13:22 CEST, Jay Patel rockworl...@gmail.com wrote: I am also looking for same as FreeBSD has ZFS system to continuesly adding new HDD for more than 100 users. or DragonflyBSD. Jay. For the case you may not care about what letters are before the *BSD, you may want to look at OpenBSD. Just two days ago I updated sogo port to 2.2.9a in OpenBSD -current. Still without activesync, but I hope with 2.2.10, I'll have it as a subpackage for those who need it. Oh well, no ZFS on OpenBSD, so, maybe not an option for you ;) cheers, Sebastian On Mon, Oct 20, 2014 at 1:00 PM, christoph.lar...@synalinq.com wrote: Dear All, sog@ looks like a terrific piece of software, and its heavy orientation towards busy environments calls for deployment on capable server O/S platforms. FreeBSD is a common and superb choice, yet it is completely unsupported. This is a big pity. While we may not need a port yet, a functioning, verified howto may be a good start, yet so far all FreeBSD- related sog@ documentation is very, very much work in progress, and has been unfinished (given up?) for several years. Quo vadis sog@? Thanks a lot for ideas and any input. Chris -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Finishing the FreeBSD port
Congratulations!! Looking forward to v3 pn FreeBSD. Does the port work on FreeBSD 8.x -> 10.x??? On 23 September 2015 at 13:23, Niklaas Baudet von Gersdorff < nikl...@kulturflatrate.net> wrote: > On 19/09/15 14:21, Niklaas Baudet von Gersdorff wrote: > > I'm still struggling with the problem I described in my initial mail > though. > > Just to keep you updated: > > Thanks to the great work of Euan Thoms and Kurt Jaeger [2] there's now a > port of version 2.3.2 for FreeBSD [1]: > > 1: https://www.freshports.org/www/sogo/ > > 2: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=200750#c13 > > -- > > Niklaas > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 "I can't hear you -- I'm using the scrambler." -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo Contacts MySQL
On 6 May 2016 at 17:20, Keith Williams <users@sogo.nu> wrote: > Hi all, > > Was just wandering if someone had a ready onliner to grab all the contacts > for all users out of the sogo mysql database? > > Regards, > > Doesn't that depend on your DB schema? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft." -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Starting SOGo
I just can't manage to start the server, plus it doesn't write to the logfile any debug info. I am pretty much using the sogo.conf from 2.0.7 which seems not to have any differences from the sample one for 3.0.2 root@gw:/usr/local/etc/sogo # /usr/local/etc/rc.d/sogod start Starting sogod. Loading two versions of Object. The class that will be used is undefined Loading two versions of Protocol. The class that will be used is undefined I cannot make heads or tails of the message, even by googling... -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft." -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Configuring Preferences/Administering SOGo
I have installed SOGo on two different systems. One is Ubuntu 18.04, the other is FreeBSD 11.2. The installations are exactly identical. I have used MySQL as the backend. Now, when I login with an administrator account and click on Administration, I see that there is really nothing to administer, which begs the questions: What is the purpose of the Administrator Account?? When I click on Administration, I get "Rights" displayed on the left pane and the rightmost pane shows "No Resource Selected". Why is this so? I am also trying to understand how to correctly use the SOGOLoginDomains parameter within domains config block. I have 4 domains, so I wonder how to use this to give me a dropdown of the domains. Thank you for now. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Configuring Preferences/Administering SOGo
On Tue, 8 Jan 2019 at 16:14, Christian Mack wrote: > Am 04.01.19 um 12:10 schrieb Odhiambo Washington (odhia...@gmail.com): > > On Thu, 3 Jan 2019 at 23:28, Christian Mack wrote: > < ... > > >> > >>> I am also trying to understand how to correctly use the > SOGOLoginDomains > >>> parameter within domains config block. I have 4 domains, so I wonder > how > >> to > >>> use this to give me a dropdown of the domains. > >>> > >> > >> I don't use that, but according to the "SOGo - Installation and > >> Configuration Guide" you have to set SOGoLoginDomains to an array of > >> keys from your domains configuration. > >> With "keys" they really mean the name of domains given (e.g. acme.com > >> from "acme.com = {") > >> > >> For the example configuration that would be: > >> SOGoLoginDomains = ("acme.com", "coyote.com"); > >> > >> > >> > https://sogo.nu/files/docs/SOGoInstallationGuide.html#_multi_domains_configuration > > > > > > I have done exactly that. However, the moment I enable the > > SOGoLoginDomains, I cannot login as authentication fails: > > > > Jan 04 05:05:36 sogod [81552]: SOGoRootPage Login from '41.215.134.216' > for > > user 'ictsupport' might not have worked - password policy: 65535 grace: > > -1 expire: -1 bound: 0 > > > > Without it, I am able to login with username@domain successfully. > > My domain names are quite long for typing, hence my need to select from a > > dropdown list. > > > > You said you use a mysql database as SOGoUserSources. > Yes. > I assume your c_uid field contains the complete email address. > Correct. > SOGo does query for a username without "@domain" part. > Noted. That is why it's failing then... > Do you have an username field used in LoginFieldNames without @domain part? > No. I created a VIEW of the users table for SOGo to use. Now, unless there is a way to create the VIEW in a way that creates that field: I created the VIEW as follows: CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, username AS mail, realname AS displayName FROM users WHERE enabled='1'; I suppose there is a way? (I am a noob with SQL). My authentication system query expects a complete email address as username though. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Missing Administration button
On Tue, 8 Jan 2019 at 21:08, Christian Mack wrote: > Am 04.01.19 um 12:29 schrieb Odhiambo Washington (odhia...@gmail.com): > > Running two identical instances of SOGo, one on Ubuntu 18.04 and the > other > > on FreeBSD 11.2. > > The configuration files are exactly the same. > > On the Ubuntu instance, when I login with an admin account, the > > "Administration" is missing! > > Anyone knows what is the cause? > > > > > > Did you restart sogo and memcached on Ubuntu after setting SOGoSuperUser? > A reload of sogo is not sufficient! > I have rebooted the machine several times, which I hope takes care of that as well, no? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Missing Administration button
On Fri, 11 Jan 2019 at 18:37, Christian Mack wrote: > Am 11.01.19 um 15:58 schrieb Odhiambo Washington (odhia...@gmail.com): > > On Fri, 11 Jan 2019 at 16:15, Christian Mack wrote: > > > >> Am 11.01.19 um 11:24 schrieb Odhiambo Washington (odhia...@gmail.com): > >>> On Tue, 8 Jan 2019 at 21:08, Christian Mack wrote: > >>> > >>>> Am 04.01.19 um 12:29 schrieb Odhiambo Washington (odhia...@gmail.com > ): > >>>>> Running two identical instances of SOGo, one on Ubuntu 18.04 and the > >>>> other > >>>>> on FreeBSD 11.2. > >>>>> The configuration files are exactly the same. > >>>>> On the Ubuntu instance, when I login with an admin account, the > >>>>> "Administration" is missing! > >>>>> Anyone knows what is the cause? > >>>>> > >>>>> > >>>> > >>>> Did you restart sogo and memcached on Ubuntu after setting > >> SOGoSuperUser? > >>>> A reload of sogo is not sufficient! > >>>> > >>> > >>> I have rebooted the machine several times, which I hope takes care of > >> that > >>> as well, no? > >>> > >> > >> Yes, a reboot also refreshes SOGoSuperUser settings. > >> > >> Are you sure, there are not any invisible characters or dashes instead > >> of minus signs in that part of sogo.conf? > >> > > > > I am using the same sogo.conf across the platforms. The only differences > > are the domain names in use. I have kept everything standard. > > > > > >> You can check that with > >> plparse /etc/sogo/sogo.conf > >> > > > > [FreeBSD] > > root@gw:/usr/home/wash # /usr/local/GNUstep/System/Tools/plparse > > /usr/local/etc/sogo/sogo.conf > > Parsing '/usr/local/etc/sogo/sogo.conf' - a dictionary > > > > [Ubuntu} > > wash@lists:~$ sudo plparse /etc/sogo/sogo.conf > > [sudo] password for wash: > > Parsing '/etc/sogo/sogo.conf' - a dictionary > > > > Do you see any error messages in sogo.log when that user logs in? > If not, I have no idea what that could be. > > No error. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Missing Administration button
On Fri, 11 Jan 2019 at 16:15, Christian Mack wrote: > Am 11.01.19 um 11:24 schrieb Odhiambo Washington (odhia...@gmail.com): > > On Tue, 8 Jan 2019 at 21:08, Christian Mack wrote: > > > >> Am 04.01.19 um 12:29 schrieb Odhiambo Washington (odhia...@gmail.com): > >>> Running two identical instances of SOGo, one on Ubuntu 18.04 and the > >> other > >>> on FreeBSD 11.2. > >>> The configuration files are exactly the same. > >>> On the Ubuntu instance, when I login with an admin account, the > >>> "Administration" is missing! > >>> Anyone knows what is the cause? > >>> > >>> > >> > >> Did you restart sogo and memcached on Ubuntu after setting > SOGoSuperUser? > >> A reload of sogo is not sufficient! > >> > > > > I have rebooted the machine several times, which I hope takes care of > that > > as well, no? > > > > Yes, a reboot also refreshes SOGoSuperUser settings. > > Are you sure, there are not any invisible characters or dashes instead > of minus signs in that part of sogo.conf? > I am using the same sogo.conf across the platforms. The only differences are the domain names in use. I have kept everything standard. > You can check that with > plparse /etc/sogo/sogo.conf > [FreeBSD] root@gw:/usr/home/wash # /usr/local/GNUstep/System/Tools/plparse /usr/local/etc/sogo/sogo.conf Parsing '/usr/local/etc/sogo/sogo.conf' - a dictionary [Ubuntu} wash@lists:~$ sudo plparse /etc/sogo/sogo.conf [sudo] password for wash: Parsing '/etc/sogo/sogo.conf' - a dictionary -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Signing into sogo redirects you to login again
Please follow this HOWTO and don't dare skip even a single step even when you feel you know it already :-) Go through it with a tooth-comb.If you get stuck, I will help you diagnose the problem personally, okay? https://wiki.archlinux.org/index.php/SOGo On Mon, 28 Jan 2019 at 20:27, Matthew Valdez wrote: > So I am using apache, and I have seen numerous people have this same > issue. Everything I am reading it says it has something to do with the > SOGo.conf file in the apache folder but that does not seem to be the > case. I tried all the suggestions like this one > https://www.mail-archive.com/users@sogo.nu/msg27894.html . I also tried > copying the SOGo.conf from the ZEG release and still the same issue. > > > -Matthew > > On 1/25/2019 5:36 PM, Pedro Antunes (pantu...@suroot.pt) wrote: > > Hi Matthew, > > > > I had same problem but it was related with virtualhost that I created to > webmail. > > > > My solution was redirect / to /SOGo on nginx. > > > > location / { > > try_files $uri $uri/ @strip-ext; > > return 301 /SOGo$1; > >} > > > > Regards, > > Pedro Antunes > > > > On 25/01/2019, 23:32, "users-requ...@sogo.nu on behalf of Matthew > Valdez" wrote: > > > > Hello all, > > > > Currently have SOGo setup to authenticate and login using ldap for > our > > Active directory and when I go to sign in, it will redirect you to > > sogo/SOGo/username and it will be the login screen again, and you > can > > keep repeating the login. I am assuming it has something to do with > the > > database? I created the database and the user, I tried creating the > > tables and nothing changes. Below is my sogo config file with a few > > modifications to remove any "sensitive" data. > > > > Thanks, > > > > -Matthew > > > > > > { > > > > SOGoProfileURL= > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_user_profile"; > > OCSFolderInfoURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_folder_info"; > > OCSSessionsFolderURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_sessions_info"; > > OCSEMailAlarmsFolderURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_alarms_folder"; > > OCSStoreURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_store"; > > OCSAclURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_acl"; > > OCSCacheFolderURL = > > "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_cache_folder"; > > > > SOGoLanguage = English; > > SOGoAuthenticationType= LDAP; > > SOGoSieveScriptsEnabled = YES; > > SOGoForwardEnabled= YES; > > SOGoVacationEnabled = YES; > > SOGoEnableEMailAlarms = YES; > > SOGoTimeZone = US/Central; > > SOGoSieveServer = sieve:// > 127.0.0.1:4190; > > SOGoCalendarDefaultRoles = > ("PublicDAndTViewer"); > > SOGoAppointmentSendEMailNotifications = YES; > > > > > > SOGoUserSources = ( > > { > > type= ldap; > > CNFieldName = cn; > > IDFieldName = uid; > > UIDFiledName= sAMAccountName; > > baseDN = > "CN=Users,DC=domain,DC=local"; > > bindDN = "CN=Sogo > > User,CN=Users,DC=domain,DC=local"; > > bindFields = (sAMAccountName); > > bindPassword= sogo; > > canAuthenticate = YES; > > displayName = "Active Directory"; > > hostname= "ldap://ipaddress:389;; > > id = directory; > > isAddressBook = YES; > > } > > ); > > } > > > > > > > > -- > > Matthew Valdez > > Ludlum Measurements, Inc. > > 501 Oak Street > > Sweetwater, TX 79556 USA > > (325) 235-5494 Phone, ext:3393 > > maval...@ludlums.com > > > > -- > > users@sogo.nu > > https://inverse.ca/sogo/lists > > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo & Mozilla Firefox
On Fri, 22 Mar 2019 at 13:54, "Frank Schmirler" wrote: > On Thu, 14. Mar 2019 13:56 CET, "Odhiambo Washington" (odhia...@gmail.com) > wrote: > > On Chrome/Edge, when you hover over the person icon, the select box > appears. > > On Mozilla, you have to click on the person icon to make the select box > to > > appear. > > FYI: The hover effect with Mozilla suddenly started working after updating > to Firefox 66.0 > > Regards, > Frank > > Thank you for the update. I confirm the same is true. Now I am just wondering whether Mozilla Firefox are even aware of the same :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGO upgrade
cd /usr/share/doc/sogo/ wash@lists:/usr/share/doc/sogo$ ls -al total 1484 drwxr-xr-x2 root root4096 Apr 3 17:48 . drwxr-xr-x 1402 root root 69632 Apr 3 18:02 .. -rw-r--r--1 root root 141 Apr 3 09:38 changelog.Debian.gz -rw-r--r--1 root root 1289420 Apr 3 09:38 changelog.gz -rw-r--r--1 root root1144 Apr 3 09:38 copyright -rw-r--r--1 root root 41096 Apr 3 09:38 NEWS.gz -rw-r--r--1 root root2378 Apr 3 09:38 SOGo-apple-ab.conf -rwxr-xr-x1 root root1352 Apr 3 09:38 sogo-backup.sh -rwxr-xr-x1 root root1201 Apr 3 09:38 sql-update-101_to_102.sh -rwxr-xr-x1 root root 960 Apr 3 09:38 sql-update-1.2.2_to_1.3.0-mysql.sh -rwxr-xr-x1 root root 958 Apr 3 09:38 sql-update-1.2.2_to_1.3.0.sh -rwxr-xr-x1 root root 880 Apr 3 09:38 sql-update-1.3.11_to_1.3.12-mysql.sh -rwxr-xr-x1 root root1347 Apr 3 09:38 sql-update-1.3.11_to_1.3.12.sh -rwxr-xr-x1 root root1487 Apr 3 09:38 sql-update-1.3.16_to_1.3.17-mysql.sh -rwxr-xr-x1 root root1441 Apr 3 09:38 sql-update-1.3.16_to_1.3.17.sh -rwxr-xr-x1 root root 958 Apr 3 09:38 sql-update-1.3.3_to_1.3.4-mysql.sh -rwxr-xr-x1 root root 956 Apr 3 09:38 sql-update-1.3.3_to_1.3.4.sh -rwxr-xr-x1 root root1746 Apr 3 09:38 sql-update-20070724.sh -rwxr-xr-x1 root root1974 Apr 3 09:38 sql-update-20070822.sh -rwxr-xr-x1 root root1343 Apr 3 09:38 sql-update-20080303.sh -rwxr-xr-x1 root root1101 Apr 3 09:38 sql-update-2.0.4b_to_2.0.5-mysql.sh -rwxr-xr-x1 root root1666 Apr 3 09:38 sql-update-2.2.17_to_2.3.0-mysql.sh -rwxr-xr-x1 root root1620 Apr 3 09:38 sql-update-2.2.17_to_2.3.0.sh -rwxr-xr-x1 root root7303 Apr 3 09:38 sql-update-3.0.0-to-combined-mysql.sh -rwxr-xr-x1 root root7208 Apr 3 09:38 sql-update-3.0.0-to-combined.sh -rwxr-xr-x1 root root2445 Apr 3 09:38 sql-update-3.2.10_to_4.0.0-mysql.sh -rwxr-xr-x1 root root1902 Apr 3 09:38 sql-update-3.2.10_to_4.0.0.sh -rw-r--r--1 root root3047 Apr 3 09:38 updates.php Just login as root and run the update script, or do sudo .. On Sun, 7 Apr 2019 at 17:02, yacin Djibril wrote: > Hi Sebastian > > thanks for your reply but how can i execute the script. *bash > sql-update-3.2.10_to_4.0.0-mysql.sh > <http://update-3.2.10_to_4.0.0-mysql.sh> is telling me "not found file"* > > *best regards* > > Le jeu. 4 avr. 2019 à 17:57, Sebastián Meyer a écrit : > >> It's in chapter 11 of the Installation Guide: >> >> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading >> >> HTH, >> >> -- >> Seb >> >> El 4/4/19 a las 11:16, yacin Djibril (yacind...@gmail.com) escribió: >> >> could you please help me how to upgrade sogo from 3.2.6 to 4.0? >> ican't find documentation related to this. >> >> >> Ps: SoGo is installed in Yunohost >> >> thanks >> >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> >> >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGO upgrade
What do you see? Be exhaustive when explaining yourself so it doesn't end being a chitchat. On Mon, 8 Apr 2019 at 15:54, yacin Djibril wrote: > Thanks Odhiambo > > But i can't see update for 4.0. is there any step i missed? > > best regards > > Le lun. 8 avr. 2019 à 15:31, Odhiambo Washington a écrit : > >> cd /usr/share/doc/sogo/ >> >> wash@lists:/usr/share/doc/sogo$ ls -al >> total 1484 >> drwxr-xr-x2 root root4096 Apr 3 17:48 . >> drwxr-xr-x 1402 root root 69632 Apr 3 18:02 .. >> -rw-r--r--1 root root 141 Apr 3 09:38 changelog.Debian.gz >> -rw-r--r--1 root root 1289420 Apr 3 09:38 changelog.gz >> -rw-r--r--1 root root1144 Apr 3 09:38 copyright >> -rw-r--r--1 root root 41096 Apr 3 09:38 NEWS.gz >> -rw-r--r--1 root root2378 Apr 3 09:38 SOGo-apple-ab.conf >> -rwxr-xr-x1 root root1352 Apr 3 09:38 sogo-backup.sh >> -rwxr-xr-x1 root root1201 Apr 3 09:38 sql-update-101_to_102.sh >> -rwxr-xr-x1 root root 960 Apr 3 09:38 >> sql-update-1.2.2_to_1.3.0-mysql.sh >> -rwxr-xr-x1 root root 958 Apr 3 09:38 >> sql-update-1.2.2_to_1.3.0.sh >> -rwxr-xr-x1 root root 880 Apr 3 09:38 >> sql-update-1.3.11_to_1.3.12-mysql.sh >> -rwxr-xr-x1 root root1347 Apr 3 09:38 >> sql-update-1.3.11_to_1.3.12.sh >> -rwxr-xr-x1 root root1487 Apr 3 09:38 >> sql-update-1.3.16_to_1.3.17-mysql.sh >> -rwxr-xr-x1 root root1441 Apr 3 09:38 >> sql-update-1.3.16_to_1.3.17.sh >> -rwxr-xr-x1 root root 958 Apr 3 09:38 >> sql-update-1.3.3_to_1.3.4-mysql.sh >> -rwxr-xr-x1 root root 956 Apr 3 09:38 >> sql-update-1.3.3_to_1.3.4.sh >> -rwxr-xr-x1 root root1746 Apr 3 09:38 sql-update-20070724.sh >> -rwxr-xr-x1 root root1974 Apr 3 09:38 sql-update-20070822.sh >> -rwxr-xr-x1 root root1343 Apr 3 09:38 sql-update-20080303.sh >> -rwxr-xr-x1 root root1101 Apr 3 09:38 >> sql-update-2.0.4b_to_2.0.5-mysql.sh >> -rwxr-xr-x1 root root1666 Apr 3 09:38 >> sql-update-2.2.17_to_2.3.0-mysql.sh >> -rwxr-xr-x1 root root1620 Apr 3 09:38 >> sql-update-2.2.17_to_2.3.0.sh >> -rwxr-xr-x1 root root7303 Apr 3 09:38 >> sql-update-3.0.0-to-combined-mysql.sh >> -rwxr-xr-x1 root root7208 Apr 3 09:38 >> sql-update-3.0.0-to-combined.sh >> -rwxr-xr-x1 root root2445 Apr 3 09:38 >> sql-update-3.2.10_to_4.0.0-mysql.sh >> -rwxr-xr-x1 root root1902 Apr 3 09:38 >> sql-update-3.2.10_to_4.0.0.sh >> -rw-r--r--1 root root3047 Apr 3 09:38 updates.php >> >> Just login as root and run the update script, or do sudo .. >> >> >> >> On Sun, 7 Apr 2019 at 17:02, yacin Djibril wrote: >> >>> Hi Sebastian >>> >>> thanks for your reply but how can i execute the script. *bash >>> sql-update-3.2.10_to_4.0.0-mysql.sh >>> <http://update-3.2.10_to_4.0.0-mysql.sh> is telling me "not found file"* >>> >>> *best regards* >>> >>> Le jeu. 4 avr. 2019 à 17:57, Sebastián Meyer a écrit : >>> >>>> It's in chapter 11 of the Installation Guide: >>>> >>>> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading >>>> >>>> HTH, >>>> >>>> -- >>>> Seb >>>> >>>> El 4/4/19 a las 11:16, yacin Djibril (yacind...@gmail.com) escribió: >>>> >>>> could you please help me how to upgrade sogo from 3.2.6 to 4.0? >>>> ican't find documentation related to this. >>>> >>>> >>>> Ps: SoGo is installed in Yunohost >>>> >>>> thanks >>>> >>>> -- >>>> users@sogo.nu >>>> https://inverse.ca/sogo/lists >>>> >>>> >>>> -- >>>> users@sogo.nu >>>> https://inverse.ca/sogo/lists >>>> >>> -- >>> users@sogo.nu >>> https://inverse.ca/sogo/lists >>> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254 7 3200 0004/+254 7 2274 3223 >> "Oh, the cruft.", grep ^[^#] :-) >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
On Mon, 18 Feb 2019 at 22:01, Ludovic Marcotte wrote: > On 2019-02-18 2:11 a.m., Odhiambo Washington (odhia...@gmail.com) wrote: > > > 2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION: > 0x80ba0f558> NAME:NSInvalidArgumentException > > REASON:[NSString+stringWithString:]: NULL string INFO:(null) > Upgrade SOPE packages using the nightly builds. > Since this is FreeBSD ports being used that is impossible - if I need a clean system. Both sope and sogo are currently on version 4.0.4 in both FreeBSD ports as well as the packages. I just need to figure out what I broke the last time I upgraded all ports. As Gordon Messmer points out, I think there is something that messed up the libraries. This system was working well - even better than one I have running on Ubuntu. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
On Mon, 18 Feb 2019 at 22:24, Gordon Messmer wrote: > On 2/17/19 11:11 PM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > Feb 18 10:05:00 sogod [33719]: 41.215.134.216 "POST > > /SOGo/so/ictsupp...@mydomain.name/Mail/unseenCount > > <http://ictsupp...@mydomain.name/Mail/unseenCount> HTTP/1.1" 200 21/31 > > 0.763 - - - > > 2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION: > 0x80ba0f558> NAME:NSInvalidArgumentException > > REASON:[NSString+stringWithString:]: NULL string INFO:(null) > > > I saw a similar error last year when an error in my build process caused > SOGo to update, while SOPE did not. I'd venture to guess that either > you have multiple versions of some library installed and the linker is > locating the wrong one, or you've updated your application but not your > supporting libraries. > That is highly likely the reason. > > It might be easier to troubleshoot if you started with a clean system > and installed from scratch there. > I might, but not now. Luckily, I have an alternative webmail suite if any user wanted it, but again, no one on this system uses webmail, so I am safe as I try to figure this out. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Few SOGO question
On Fri, 22 Feb 2019 at 16:07, Christian Mack wrote: > Am 22.02.19 um 13:04 schrieb Odhiambo Washington (odhia...@gmail.com): > > 1. AddressBook: > > > > I have users in MySQL and the resource is configured with IsAddressBook = > > YES. > > How can I export these to Outlook or Apple Mail transparently? > > > > Set the following in sogo.conf in your SOGoUserSources for that address > book. > listRequiresDot = NO; > > This will always list all address cards from that address book. > > Beware: > We do not use that, because there are too many addresses in our global > address book (~20,000). > To synchronize that will take som time and bandwidth, which is a problem > on smartphones. > > > 2. Webmail: > > > > How do I make SOGo to display subscribed mailboxes? > > I am having a situation where on one webmail app (Groupoffice) I can see > > sub-mailboxes while SOGo does not display the same: > > > > [image: 2019-02-22 (1).png] > > [image: 2019-02-22.png] > > > > When a folder is selected, then you can click on its icon to open > subfolders. > In your example, open Inbox, then click on its icon. > > > Kind regards, > Christian Mack > Thank you very much. My questions satisfactorily answered. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Performance tuning
ed it more, but then again, it might not change much, because of the explanation I see in a typical memcached.conf in Linux (which we can borrow our memcached_flags from is below. On Linux, the default is "-m 64". We compare notes after :-) # memcached default config file # 2003 - Jay Bonci # This configuration file is read by the start-memcached script provided as # part of the Debian GNU/Linux distribution. # Run memcached as a daemon. This command is implied, and is not needed for the # daemon to run. See the README.Debian that comes with this package for more # information. -d # Log memcached's output to /var/log/memcached logfile /var/log/memcached.log # Be verbose # -v # Be even more verbose (print client commands as well) # -vv # Start with a cap of 64 megs of memory. It's reasonable, and the daemon default # Note that the daemon will grow to this size, but does not start out holding this much # memory -m 64 # Default connection port is 11211 -p 11211 # Run the daemon as root. The start-memcached will default to running as root if no # -u command is present in this config file -u nobody # Specify which IP address to listen on. The default is to listen on all IP addresses # This parameter is one of the only security measures that memcached has, so make sure # it's listening on a firewalled interface. -l 127.0.0.1 # Limit the number of simultaneous incoming connections. The daemon default is 1024 # -c 1024 # Lock down all paged memory. Consult with the README and homepage before you do this # -k # Return error when memory is exhausted (rather than removing items) # -M # Maximize core file limit # -r -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] userPasswordAlgorithm
I am able to change passwords, right, but I see that the password encryption scheme prepended to the encrypted password in the DB. Is this something that can be avoided? And why is digest-md5 not among the supported encryption algorithms? I don't see it listed in the Docu under "Possible values" while reference is made to https://wiki.dovecot.org/Authentication/PasswordSchemes, which has it listed. Thanks -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] userPasswordAlgorithm
On Sun, 3 Mar 2019 at 01:37, Ludovic Marcotte wrote: > On 2019-03-02 11:31 a.m., Odhiambo Washington (odhia...@gmail.com) wrote: > > > Is this something that can be avoided? > By setting prependPasswordScheme = NO. > > Thank you. I realize now I MUST take time to go through the documentation (testing my doubts as I progress) from top to bottom, while looking at my sogo.conf. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Performance tuning
On Sun, 3 Mar 2019 at 03:59, Lorenz Pressler wrote: > Hi Odhiamb, > > I tried setting it to 128M and I tried moving it to a unix socket. Both > resulted in nothing noticable but I did not really expect anything on > the cache side since everything else but accessing mail is reasonably fast. > > regards, > > -- > Lorenz Pressler > > Hi Lorenz, I am actually comfortable after setting NGImap4DisableIMAP4Pooling = NO; -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo & Mozilla Firefox
As I can see from my Firefox (65.0.2 (64-bit)), there seems to be a problem using SOGo with Mozilla. I am unable to select mails as that selection box does not appear. Do I have to tell users that they can only Google Chrome and Microsoft Edge with SOGo? I haven't tried Opera, but I don't consider it a mainstream browser. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo & Mozilla Firefox
I see. On Chrome/Edge, when you hover over the person icon, the select box appears. On Mozilla, you have to click on the person icon to make the select box to appear. On Thu, 14 Mar 2019 at 14:47, "Andreas Blaha" wrote: > works fine for me, running SOGo 4.0.7 and Firefox 64bit 65.0.2 > > best > > Andy > > > > *From:* users-requ...@sogo.nu *On Behalf Of *Odhiambo > Washington > *Sent:* Thursday, March 14, 2019 9:53 AM > *To:* users@sogo.nu > *Subject:* [SOGo] SOGo & Mozilla Firefox > > > > As I can see from my Firefox (65.0.2 (64-bit)), there seems to be a > problem using SOGo with Mozilla. > > I am unable to select mails as that selection box does not appear. > > > > Do I have to tell users that they can only Google Chrome and Microsoft > Edge with SOGo? > > I haven't tried Opera, but I don't consider it a mainstream browser. > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with a fresh install of SOGO 4.0.7 on ubuntu 16
On Wed, 13 Mar 2019 at 15:48, Carsten Pieper wrote: > Hi all, > > sorry, I think I have quite a stupid question this time. > > I try to install SOGo v4.0.7 on my new server on Ubuntu 16. > > Installation succeeded, I copied the database from the old server, > Which database? checked /etc/sogo/sogo.conf > > and /etc/apache2/conf-enabled/SOGo.conf > > When I try to open https://mydomain.tld/SOGo/ I get an Internal Server > Error on mydomain.tld:443. > > I checked /var/log/sogo.log, var/log/apache2/error.log and > /var/log/nginx/error.log and found nothing helpful to get the login screen > displayed. > Why are you checking /var/log/nginx/error.lo, if I may ask? I checked if SOGo is running: > > root@server:/var/log/nginx# service sogo status > ● sogo.service - LSB: SOGo server >Loaded: loaded (/etc/init.d/sogo; bad; vendor preset: enabled) >Active: active (running) since Wed 2019-03-13 11:48:07 CET; 1h 52min ago > Docs: man:systemd-sysv-generator(8) > Process: 24670 ExecStop=/etc/init.d/sogo stop (code=exited, > status=0/SUCCESS) > Process: 24740 ExecStart=/etc/init.d/sogo start (code=exited, > status=0/SUCCESS) >CGroup: /system.slice/sogo.service >├─24811 /usr/sbin/sogod -WOWorkersCount 3 -WOPidFile > /var/run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log >├─24812 /usr/sbin/sogod -WOWorkersCount 3 -WOPidFile > /var/run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log >├─24813 /usr/sbin/sogod -WOWorkersCount 3 -WOPidFile > /var/run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log >└─24814 /usr/sbin/sogod -WOWorkersCount 3 -WOPidFile > /var/run/sogo/sogo.pid -WOLogFile /var/log/sogo/sogo.log > > Mar 13 11:48:07 mydomain.tld sogo[24740]: * Starting SOGo sogo > Mar 13 11:48:07 mydomain.tld sogo[24740]:...done. > > Does anybody have an idea what I'm doing wrong and I have to do to get the > login screens displayed? > Does "LogLevel Debug" in /etc/apache2/conf-enabled/SOGo.conf help?? How about you check the configs closely again? How about enable the Debug options in sogo.conf? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo won't start after updates
On Sat, 9 Mar 2019 at 07:14, Alonso Cárdenas Márquez wrote: > El jue., 7 feb. 2019 a las 1:37, Odhiambo Washington () > escribió: > >> The output does not really help me figure it out: >> >> root@waridi:/usr/home/wash # ldd >> /usr/local/GNUstep/Local/Tools/Admin/sogod >> /usr/local/GNUstep/Local/Tools/Admin/sogod: >> libSOGo.so.4 => >> /usr/local/GNUstep/Local/Library/Libraries/sogo/libSOGo.so.4 (0x80100) >> libGDLContentStore.so.4.9 => >> /usr/local/lib/compat/pkg/libGDLContentStore.so.4.9 (0x8011e5000) >> libGDLAccess.so.4.9 => >> /usr/local/lib/compat/pkg/libGDLAccess.so.4.9 (0x80143d000) >> libWEExtensions.so.4.9 => >> /usr/local/lib/compat/pkg/libWEExtensions.so.4.9 (0x80180) >> libNGCards.so.4.9 => /usr/local/lib/compat/pkg/libNGCards.so.4.9 >> (0x801d36000) >> libNGObjWeb.so.4.9 => >> /usr/local/lib/compat/pkg/libNGObjWeb.so.4.9 (0x80200) >> libNGMime.so.4.9 => /usr/local/lib/compat/pkg/libNGMime.so.4.9 >> (0x802c0) >> libNGLdap.so.4.9 => /usr/local/lib/compat/pkg/libNGLdap.so.4.9 >> (0x80323b000) >> libNGStreams.so.4.9 => >> /usr/local/lib/compat/pkg/libNGStreams.so.4.9 (0x8034ad000) >> libNGExtensions.so.4.9 => >> /usr/local/lib/compat/pkg/libNGExtensions.so.4.9 (0x80380e000) >> libEOControl.so.4.9 => >> /usr/local/lib/compat/pkg/libEOControl.so.4.9 (0x803bdc000) >> libDOM.so.4.9 => /usr/local/lib/compat/pkg/libDOM.so.4.9 >> (0x803e8f000) >> libSaxObjC.so.4.9 => /usr/local/lib/compat/pkg/libSaxObjC.so.4.9 >> (0x80419d000) >> libSBJson.so.2 => >> /usr/local/GNUstep/Local/Library/Libraries/libSBJson.so.2 (0x80066b000) >> libgnustep-base.so.1.26 => >> /usr/local/GNUstep/System/Library/Libraries/libgnustep-base.so.1.26 >> (0x80440) >> libobjc.so.4.6 => /usr/local/lib/libobjc.so.4.6 (0x804b0d000) >> libm.so.5 => /lib/libm.so.5 (0x804d3c000) >> libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x804f6b000) >> libthr.so.3 => /lib/libthr.so.3 (0x80517a000) >> libc.so.7 => /lib/libc.so.7 (0x800823000) >> libmemcached.so.11 => /usr/local/lib/libmemcached.so.11 >> (0x8053a2000) >> libcrypto.so.9 => /usr/local/lib/libcrypto.so.9 (0x80560) >> libcrypt.so.5 => /lib/libcrypt.so.5 (0x805a7f000) >> libgnustep-base.so.1.25 => >> /usr/local/lib/compat/pkg/libgnustep-base.so.1.25 (0x805e0) >> libldap-2.4.so.2 => /usr/local/lib/libldap-2.4.so.2 (0x806707000) >> liblber-2.4.so.2 => /usr/local/lib/liblber-2.4.so.2 (0x80694e000) >> libz.so.6 => /lib/libz.so.6 (0x806b5d000) >> libssl.so.9 => /usr/local/lib/libssl.so.9 (0x806d75000) >> libiconv.so.2 => /usr/local/lib/libiconv.so.2 (0x806fee000) >> libgmp.so.10 => /usr/local/lib/libgmp.so.10 (0x8072e9000) >> libavahi-common.so.3 => /usr/local/lib/libavahi-common.so.3 >> (0x807569000) >> libavahi-client.so.3 => /usr/local/lib/libavahi-client.so.3 >> (0x807775000) >> libgnutls.so.30 => /usr/local/lib/libgnutls.so.30 (0x807984000) >> libxslt.so.1 => /usr/local/lib/libxslt.so.1 (0x807d37000) >> libxml2.so.2 => /usr/local/lib/libxml2.so.2 (0x807f74000) >> liblzma.so.5 => /usr/lib/liblzma.so.5 (0x808307000) >> libffi.so.6 => /usr/local/lib/libffi.so.6 (0x80853) >> libkvm.so.7 => /lib/libkvm.so.7 (0x808737000) >> librt.so.1 => /usr/lib/librt.so.1 (0x808945000) >> libdl.so.1 => /usr/lib/libdl.so.1 (0x808b4b000) >> libicui18n.so.63 => /usr/local/lib/libicui18n.so.63 (0x808e0) >> libicuuc.so.63 => /usr/local/lib/libicuuc.so.63 (0x809309000) >> libicudata.so.63 => /usr/local/lib/libicudata.so.63 (0x8096eb000) >> libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x8098ec000) >> libsasl2.so.3 => /usr/local/lib/libsasl2.so.3 (0x809b0b000) >> libexecinfo.so.1 => /usr/lib/libexecinfo.so.1 (0x809d28000) >> libc++.so.1 => /usr/lib/libc++.so.1 (0x809f2b000) >> libssl.so.8 => /usr/lib/libssl.so.8 (0x80a1f9000) >> libcrypto.so.8 => /lib/libcrypto.so.8 (0x80a60) >> libintl.so.8 => /usr/local/lib/libintl.so.8 (0x80aa7) >> libdbus-1.so.3 => /usr/local/lib/libdbus-1.so.3 (0x80ac7b000) >> libp11-kit.so.0 => /usr/local/lib/libp11-kit.so.0 (0x80aecb000)
[SOGo] SOGo won't start after updates
versions of GSAttrInfo. The class that will be used is undefined Loading two versions of GSAttributedString. The class that will be used is undefined Loading two versions of GSMutableAttributedString. The class that will be used is undefined Loading two versions of NSGAttributedString. The class that will be used is undefined Loading two versions of NSGMutableAttributedString. The class that will be used is undefined Loading two versions of GSArray. The class that will be used is undefined Loading two versions of GSInlineArray. The class that will be used is undefined Loading two versions of GSMutableArray. The class that will be used is undefined Loading two versions of GSArrayEnumerator. The class that will be used is undefined Loading two versions of GSArrayEnumeratorReverse. The class that will be used is undefined Loading two versions of GSPlaceholderArray. The class that will be used is undefined Loading two versions of NSGArray. The class that will be used is undefined Loading two versions of NSGMutableArray. The class that will be used is undefined Loading two versions of CXXException. The class that will be used is undefined Unable to set up with [NSProcessInfo-debugSet] Unable to set up with [NSProcessInfo-debugSet] Unable to set up with [NSProcessInfo-debugSet] 2019-02-06 08:58:48.101 sogod[18213:100148] No local time zone specified. 2019-02-06 08:58:48.101 sogod[18213:100148] Using time zone with absolute offset 0. 2019-02-06 08:58:48.101 sogod[18213:100148] File NSConcreteMapTable.m: 584. In void *NSMapGet(NSMapTable *, const void *) Null table argument supplied Abort /usr/local/etc/rc.d/sogod: WARNING: failed to start sogod -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo won't start after updates
That mention of having installed "two different versions of libgnustep-base" is the clue I needed! Problem solved! I am a FreeBSD guy so going to the rpm based systems is not taken kindly :-) On Fri, 8 Feb 2019 at 15:22, Gordon Messmer wrote: > On 2/6/19 10:36 PM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > The output does not really help me figure it out: > > > > root@waridi:/usr/home/wash # ldd > > /usr/local/GNUstep/Local/Tools/Admin/sogod > > /usr/local/GNUstep/Local/Tools/Admin/sogod: > > libgnustep-base.so.1.26 => > > /usr/local/GNUstep/System/Library/Libraries/libgnustep-base.so.1.26 > > (0x80440) > ... > > libgnustep-base.so.1.25 => > > /usr/local/lib/compat/pkg/libgnustep-base.so.1.25 (0x805e0) > > > Quite understandable. Shared library conflicts are difficult to > troubleshoot. I really highly recommend rpm-based systems as they > prevent a lot of those issues. > > In your case, you've managed to install two different versions of > libgnustep-base, which will lead to undefined behavior. Crashes in your > case. You need to figure out how that happened, and reverse whatever > change introduced the copy that you don't want. > > Or start over on a clean system. If you've automated your deployment, > that option should be trivial and preferred. > > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo starting, but with a ton of errors
! Reason: NAME:ExecutionFailed REASON:Table 'exim4u.sogo_quick_contact' doesn't exist Feb 09 01:24:07 sogod [43873]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: NAME:ExecutionFailed REASON:Table 'exim4u.sogo_quick_appointment' doesn't exist Feb 09 01:24:07 sogod [43873]: <0x0x80f903858[WOHttpAdaptor]> notified the watchdog that we are ready Feb 09 01:24:31 sogod [43873]: <0x0x80cba1a88[SOGoCache]> Cache cleanup interval set every 360.00 seconds Feb 09 01:24:31 sogod [43873]: <0x0x80cba188[SOGoCache]> Using host(s) '127.0.0.1' as server(s) Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: 41.215.76.82 "GET /SOGo HTTP/1.1" 302 0/0 0.003 - - - Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find MainUIProduct class! Feb 09 01:24:31 sogod [43873]: [ERROR] [we-rm] did not find locale for language: English Feb 09 01:24:31 sogod [43873]: 41.215.76.82 "GET /SOGo/index HTTP/1.1" 403 238/0 0.003 - - - -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
On Sun, 17 Feb 2019 at 15:09, Gordon Messmer wrote: > On 2/11/19 11:37 PM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > That is where I am at the moment. Webmail does NOT load the e-mails > > and I am not sure I can tell what is causing it. > > > If you watch the log ("tail -f /var/log/sogo/sogo.log" here) as you > select the item in the mailbox, what do you see? I see something like: > > Feb 16 19:09:51 sogod [6088]: 10.1.10.163 "GET > /SOGo/so/gordon/Mail/0/folderINBOX/314323/view HTTP/1.1" 200 739/0 0.931 > - - 12K > > The server should log any errors to that file. > > Here is what I see: Feb 18 10:04:06 sogod [33719]: <0x0x80fc39228[WOHttpAdaptor]> notified the watchdog that we are ready Feb 18 10:04:45 sogod [33719]: <0x0x80e6dce68[SOGoCache]> Cache cleanup interval set every 360.00 seconds Feb 18 10:04:45 sogod [33719]: <0x0x80e6dce68[SOGoCache]> Using host(s) '127.0.0.1' as server(s) Feb 18 10:04:46 sogod [33719]: 41.215.134.216 "GET /SOGo HTTP/1.1" 302 0/0 0.226 - - - Feb 18 10:04:46 sogod [33719]: 41.215.134.216 "GET /SOGo/ HTTP/1.1" 200 6709/0 0.017 22296 69% - Feb 18 10:04:55 sogod [33719]: SOGoRootPage successful login from '41.215.134.216' for user 'ictsupp...@mydomain.name' - expire = -1 grace = -1 Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table Feb 18 10:04:55 sogod [33719]: 41.215.134.216 "POST /SOGo/connect HTTP/1.1" 200 60/83 0.084 - - - Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/ ictsupp...@mydomain.name HTTP/1.1" 302 0/0 0.004 - - - Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/ ictsupp...@mydomain.name/view HTTP/1.1" 302 0/0 0.007 - - - Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/so/ ictsupp...@mydomain.name/Mail HTTP/1.1" 302 0/0 0.004 - - - Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/so/ ictsupp...@mydomain.name/Mail/view HTTP/1.1" 200 18389/0 0.147 78650 76% - Feb 18 10:04:57 sogod [33719]: 41.215.134.216 "GET /SOGo/so/ ictsupp...@mydomain.name/Calendar/alarmslist?browserTime=1550473570 HTTP/1.1" 200 63/0 0.007 - - - Feb 18 10:04:57 sogod [33719]: 41.215.134.216 "GET /SOGo/so/ ictsupp...@mydomain.name/Mail/0/view HTTP/1.1" 200 836/0 0.762 - - - Feb 18 10:04:59 sogod [33719]: 41.215.134.216 "POST /SOGo/so/ ictsupp...@mydomain.name/Mail/0/folderINBOX/view HTTP/1.1" 200 6161/48 1.229 - - - Feb 18 10:05:00 sogod [33719]: 41.215.134.216 "POST /SOGo/so/ ictsupp...@mydomain.name/Mail/unseenCount HTTP/1.1" 200 21/31 0.763 - - - 2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION: NAME:NSInvalidArgumentException REASON:[NSString+stringWithString:]: NULL string INFO:(null) Feb 18 10:05:03 sogod [33719]: 41.215.134.216 "GET /SOGo/so/ ictsupp...@mydomain.name/Mail/0/folderINBOX/24/view HTTP/1.1" 501 0/0 0.885 - - - -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
Hello Gordon, True, I was updating a previous install. How things got broken is what surprised me. After some clues, I was able to delete some rogue libraries, reinstalled all the SOGo related bits (sogo4, sope4, gnustep-make, gnustep-base) and now I am able to get sogod running again. The thing is, in FreeBSD we can do `portupgrade -a` to update all installed packages, like they do 'apt update && apt upgrade' in Linux. Somewhere in between, something might break for some reason, no? That is where I am at the moment. Webmail does NOT load the e-mails and I am not sure I can tell what is causing it. On Tue, 12 Feb 2019 at 07:29, Gordon Messmer wrote: > On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > I thought SOGo is supposed to create the tables sogo_* itself. > > > I'm a little unclear on where you're at with your installation. I > thought you were updating a previous install. If this is a new install, > make sure the sogo user has the rights required to make the tables that > it's complaining about. > > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] could not open storage channel
[My responses inline] Since it's been 8hrs since you posted and no one has responded, I will try my guess here: On Tue, 12 Feb 2019 at 01:13, Carsten Pieper wrote: > Hi all, > > actually, I have some strange problems with SOGO. > > A user told me that his calendar is empty. In the logs I find: > > Feb 11 01:04:20 sogod [22810]: [ERROR] > <0x0x56308306d918[GCSChannelManager]> could not open channel > for > mysql://localhost/sogo/sogo[...] > Feb 11 01:04:20 sogod [22810]: [WARN] > <0x0x56308306d918[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2019-02-11 01:04:20 +0100 > Feb 11 01:04:20 sogod [22810]: [ERROR] <0x0x56308826a138[GCSFolder]> > could not open storage channel! > The " could not open channel Then enter the relevant password. Another way to find out is to edit your /etc/sogo/sogo.conf and enable debugging then restart sogod. The below are possible debug options that you can enable: /* Debug */ //SOGoDebugRequests = YES; //SoDebugBaseURL = YES; //ImapDebugEnabled = YES; //LDAPDebugEnabled = YES; //PGDebugEnabled = YES; //MySQL4DebugEnabled = YES; //SOGoUIxDebugEnabled = YES; //WODontZipResponse = YES; > > I tried the dump-default sogo-tool command and got: > > root@www:/var/log/sogo# sogo-tool dump-defaults > { > OCSFolderInfoURL = > "mysql://sogo:[...]@localhost:3306/sogo/sogo_folder_info"; > SOGoACLsSendEMailNotifications = YES; > SOGoAppointmentSendEMailNotifications = YES; > SOGoFoldersSendEMailNotifications = YES; > SOGoLanguage = German; > SOGoMailDomain = "carstenpieper.com"; > SOGoProfileURL = > "mysql://sogo:[...]@localhost:3306/sogo/sogo_user_profile"; > SOGoTimeZone = "Europe/Berlin"; > > SOGoUserSources = ( > { > CNFieldName = cn; > IDFieldName = uid; > IMAPHostFieldName = mailHost; > UIDFieldName = uid; > baseDN = "ou=accounts,dc=[...],dc=com"; > bindDN = "uid=sogadmin,ou=accounts,dc=[...],dc=com"; > bindPassword = okoo9Fi; > canAuthenticate = YES; > displayName = "Shared Addresses"; > hostname = localhost; > id = public; > isAddressBook = YES; > port = 389; > } > ); > } > Now I have to ask you: Are your SOGoUserSources stored in LDAP of MySQL?? > Now, some questions come into my mind: > > 1. Why is there no default for OCSSessionsFolderURL? > >From https://sogo.nu/files/docs/SOGoInstallationGuide.html, I can see that OCSSessionsFolderURL needs to be specified. There is a default for it. > 2. Where do the defaults come from? I had a look in the GNUstepDefaults > but found nothing: > SOGo creates them :-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
| | enabled | tinyint(1) | NO | | 1 || | flags| varchar(16) | YES | | NULL|| | forward | varchar(255) | YES | | NULL|| | unseen | tinyint(1) | YES | | 0 || | maxmsgsize | mediumint(8) unsigned | NO | | 0 || | quota| int(10) unsigned | NO | | 0 || | realname | varchar(255) | YES | | NULL|| | sa_tag | smallint(5) unsigned | NO | | 0 || | sa_refuse| smallint(5) unsigned | NO | | 0 || | tagline | varchar(255) | YES | | NULL|| | vacation | varchar(255) | YES | | NULL|| | on_spambox | tinyint(1) | YES | | NULL|| | on_spamboxreport | tinyint(1) | YES | | NULL|| | ftp_dir | varchar(255) | YES | | NULL|| | ftp_enable | tinyint(1) | NO | | 0 || | ftp_quota| int(11) | YES | | 20 || | ULBandwidth | smallint(5) | NO | | 0 || | DLBandwidth | smallint(5) | NO | | 0 || | ipaccess | varchar(15) | NO | | * || | QuotaFiles | int(11) | NO | | 0 || +--+-+--+-+-++ On Tue, 12 Feb 2019 at 18:52, Christian Mack wrote: > Hello > > There should be no breakage. > But you have to check, if there exists any sql update scripts between > the version you came from to the one you just installed. > > Check /usr/share/doc/sogo/ > > > Kind regards, > Christian Mack > > Am 12.02.19 um 08:37 schrieb Odhiambo Washington (odhia...@gmail.com): > > Hello Gordon, > > > > True, I was updating a previous install. How things got broken is what > > surprised me. > > After some clues, I was able to delete some rogue libraries, reinstalled > > all the SOGo related bits (sogo4, sope4, gnustep-make, gnustep-base) > > and now I am able to get sogod running again. > > The thing is, in FreeBSD we can do `portupgrade -a` to update all > installed > > packages, like they do 'apt update && apt upgrade' in Linux. > > Somewhere in between, something might break for some reason, no? > > That is where I am at the moment. Webmail does NOT load the e-mails and I > > am not sure I can tell what is causing it. > > > > > > > > > > On Tue, 12 Feb 2019 at 07:29, Gordon Messmer wrote: > > > >> On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote: > >>> I thought SOGo is supposed to create the tables sogo_* itself. > >> > >> > >> I'm a little unclear on where you're at with your installation. I > >> thought you were updating a previous install. If this is a new install, > >> make sure the sogo user has the rights required to make the tables that > >> it's complaining about. > >> > >> > >> -- > >> users@sogo.nu > >> https://inverse.ca/sogo/lists > >> > > > > > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung Basisdienste > 78457 Konstanz > +49 7531 88-4416 > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo starting, but with a ton of errors
I thought SOGo is supposed to create the tables sogo_* itself. On Sun, 10 Feb 2019 at 02:12, Gordon Messmer wrote: > On 2/8/19 2:32 PM, Odhiambo Washington" (odhia...@gmail.com) wrote: > > I am wondering what else I have messed up this time round: > > > Rather than looking at the log as a whole, let's look at errors from > just one PID: > > > Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load > product: ContactsUI > Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load > product: SchedulerUI > > Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_user_profile' creation > failed! Reason: NAME:ExecutionFailed > REASON:Table 'exim4u.sogo_user_profile' doesn't exist > Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_folder_info' creation > failed! Reason: NAME:ExecutionFailed > REASON:Table 'exim4u.sogo_folder_info' doesn't exist > Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_store' creation > failed! Reason: NAME:ExecutionFailed > REASON:Table 'exim4u.sogo_store' doesn't exist > Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table > 'sogo_quick_contact' creation failed! Reason: 0x80f960028> NAME:ExecutionFailed REASON:Table > 'exim4u.sogo_quick_contact' doesn't exist > Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table > 'sogo_quick_appointment' creation failed! Reason: 0x80f9733d8> NAME:ExecutionFailed REASON:Table > 'exim4u.sogo_quick_appointment' doesn't exist > > > The first thing I'd check is your SQL configuration. Make sure those > tables exist, and make sure the sogo user can access them. > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Request Failed
Slowly getting to resolve my SOGo issues. I am able to login to webmail, but when I select a message in the Inbox, I see a "Request Failed" message popup. Message fails to load: The following shows in sogo.log: 2019-02-11 16:28:27.085 sogod[20108:100390] EXCEPTION: NAME:NSInvalidArgumentException REASON:[NSString+stringWithString:]: NULL string INFO: (null) Feb 11 16:28:27 sogod [20108]: 41.57.97.247 "GET /SOGo/so/ ictsupp...@mydomain.com/Mail/0/folderINBOX/17/view HTTP/1.1" 501 0/0 0.899 - - - 2019-02-11 16:32:12.803 sogod[20108:100390] EXCEPTION: NAME:NSInvalidArgumentException REASON:[NSString+stringWithString:]: NULL string INFO: (null) Feb 11 16:32:12 sogod [20108]: 41.57.97.247 "GET /SOGo/so/ ictsupp...@mydomain.com/Mail/0/folderINBOX/16/view HTTP/1.1" 501 0/0 0.936 - - - 2019-02-11 16:32:41.116 sogod[20108:100390] EXCEPTION: NAME:NSInvalidArgumentException REASON:[NSString+stringWithString:]: NULL string INFO: (null) Feb 11 16:32:41 sogod [20108]: 41.57.97.247 "GET /SOGo/so/ ictsupp...@mydomain.com/Mail/0/folderINBOX/15/view HTTP/1.1" 501 0/0 0.859 - - - 2019-02-11 16:33:00.300 sogod[20108:100390] EXCEPTION: NAME:NSInvalidArgumentException REASON:[NSString+stringWithString:]: NULL string INFO: (null) Feb 11 16:33:00 sogod [20108]: 41.57.97.247 "GET /SOGo/so/ ictsupp...@mydomain.com/Mail/0/folderINBOX/14/view HTTP/1.1" 501 0/0 0.860 - - - -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Multiple select
Thank you for the hint, but I was hoping for an "select All" option. It's easier to use that, then deSelect the ones you don't want to act on. The SOGoLoginModule works for me on my FreeBSD box and refuses to work on my Ubuntu. I need to find out why this Ubuntu is also not allowing me to access the Administration option. On Tue, 29 Jan 2019 at 18:12, Andrei Goldchleger wrote: > 1) Click on the small "person icon", then you can select multiple/all > emails. > > 2) Have a look at the SOGoLoginModule configuration parameter. > > Thanks, > > Andrei > On 29/01/2019 10:23, Odhiambo Washington (odhia...@gmail.com) wrote: > > Am I missing something or there is no way to: > 1. Select multiple mails and "do something" (like Delete, Mark as read, > etc)? > 2. Make SoGO login to display e-mails by default instead of Calendar? > > Also, how do I make the mails to load faster? > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Multiple select
Thank you for your reply. I have seen the "box within a box" now. Yayi! I used the SOGoLoginModule in my FreeBSD SOGo install and it now opens on the Mail module. I used the same on Ubuntu 18.04.1, SOGo 4.0.5 and this one refuses to open on the Mail module. It's the same setup that also refuses to give me the Administration button! On Tue, 29 Jan 2019 at 20:57, Andrei Goldchleger wrote: > After you select one email, there is a "box within a box" icon, that > selects all emails. > > Regarding SOGoLoginModule, I am on Ubuntu 18.04, Sogo 4.0.5, and the web > interface opens in the email module. I checked my config and noticed that > there is no mention to SOGoLoginModule, so I guess it is using the default, > which is mail. > > > On 29/01/2019 13:37, Odhiambo Washington (odhia...@gmail.com) wrote: > > Thank you for the hint, but I was hoping for an "select All" option. It's > easier to use that, then deSelect the ones you don't want to act on. > The SOGoLoginModule works for me on my FreeBSD box and refuses to work on > my Ubuntu. I need to find out why this Ubuntu is also > not allowing me to access the Administration option. > > > On Tue, 29 Jan 2019 at 18:12, Andrei Goldchleger wrote: > >> 1) Click on the small "person icon", then you can select multiple/all >> emails. >> >> 2) Have a look at the SOGoLoginModule configuration parameter. >> >> Thanks, >> >> Andrei >> On 29/01/2019 10:23, Odhiambo Washington (odhia...@gmail.com) wrote: >> >> Am I missing something or there is no way to: >> 1. Select multiple mails and "do something" (like Delete, Mark as read, >> etc)? >> 2. Make SoGO login to display e-mails by default instead of Calendar? >> >> Also, how do I make the mails to load faster? >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254 7 3200 0004/+254 7 2274 3223 >> "Oh, the cruft.", grep ^[^#] :-) >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Multiple select
On Ubuntu: wash@lists:~$ apt list | grep gnustep | grep installed WARNING: apt does not have a stable CLI interface. Use with caution in scripts. gnustep-base-common/bionic,now 1.25.1-2ubuntu3 all [installed,automatic] gnustep-base-runtime/bionic,now 1.25.1-2ubuntu3 amd64 [installed,automatic] gnustep-common/bionic,now 2.7.0-3 amd64 [installed,automatic] gnustep-make/bionic,now 2.7.0-3 all [installed,automatic] libgnustep-base1.25/bionic,now 1.25.1-2ubuntu3 amd64 [installed,automatic] On FreeBSD: [wash@waridi ~]$ pkg info | grep gnustep gnustep-base-1.25.0_7 GNUstep Foundation library gnustep-make-2.7.0_2 GNUstep makefile package So, everything seems the same - gnustep-1.2.5 On Tue, 5 Feb 2019 at 03:32, Christian Mack wrote: > Hello > > Could you check your GNUstep version on Ubuntu versus FreeBSD? > > > Kind regards, > Christian Mack > > Am 30.01.19 um 17:02 schrieb Odhiambo Washington (odhia...@gmail.com): > > Thank you for your reply. I have seen the "box within a box" now. Yayi! > > > > I used the SOGoLoginModule in my FreeBSD SOGo install and it now opens on > > the Mail module. > > I used the same on Ubuntu 18.04.1, SOGo 4.0.5 and this one refuses to > open > > on the Mail module. It's the same setup that also refuses to give me the > > Administration button! > > > > > > On Tue, 29 Jan 2019 at 20:57, Andrei Goldchleger wrote: > > > >> After you select one email, there is a "box within a box" icon, that > >> selects all emails. > >> > >> Regarding SOGoLoginModule, I am on Ubuntu 18.04, Sogo 4.0.5, and the web > >> interface opens in the email module. I checked my config and noticed > that > >> there is no mention to SOGoLoginModule, so I guess it is using the > default, > >> which is mail. > >> > >> > >> On 29/01/2019 13:37, Odhiambo Washington (odhia...@gmail.com) wrote: > >> > >> Thank you for the hint, but I was hoping for an "select All" option. > It's > >> easier to use that, then deSelect the ones you don't want to act on. > >> The SOGoLoginModule works for me on my FreeBSD box and refuses to work > on > >> my Ubuntu. I need to find out why this Ubuntu is also > >> not allowing me to access the Administration option. > >> > >> > >> On Tue, 29 Jan 2019 at 18:12, Andrei Goldchleger wrote: > >> > >>> 1) Click on the small "person icon", then you can select multiple/all > >>> emails. > >>> > >>> 2) Have a look at the SOGoLoginModule configuration parameter. > >>> > >>> Thanks, > >>> > >>> Andrei > >>> On 29/01/2019 10:23, Odhiambo Washington (odhia...@gmail.com) wrote: > >>> > >>> Am I missing something or there is no way to: > >>> 1. Select multiple mails and "do something" (like Delete, Mark as read, > >>> etc)? > >>> 2. Make SoGO login to display e-mails by default instead of Calendar? > >>> > >>> Also, how do I make the mails to load faster? > >>> > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung Basisdienste > 78457 Konstanz > +49 7531 88-4416 > > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Multiple select
Am I missing something or there is no way to: 1. Select multiple mails and "do something" (like Delete, Mark as read, etc)? 2. Make SoGO login to display e-mails by default instead of Calendar? Also, how do I make the mails to load faster? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Addressbook Sync Errors
I have installed CalDav Syncronizer for Outlook. SOGo is v4.0.7. When I try to sync the following error is logged on sogo.log: 2019-04-12 11:08:31.511 sogod[43707:100181] EXCEPTION: NAME:NSInvalidArgumentException REASON:'_name' must not be an empty string INFO:(null) while the CalDav tool generates so many messages. Sync fails of course. Any clue as to what could be the problem? My config block for Addressbook is: SOGoUserSources = ( { type = sql; id = directory; viewURL = "mysql://sogou:X@127.0.0.1:3306/exim4u/sogo_auth_view "; canAuthenticate = YES; isAddressBook = YES; listRequiresDot = NO; userPasswordAlgorithm = md5-crypt; displayName = "CSL Global Address Book"; } ); -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Anyway to work around Chinese Character in sogo.conf
One question though - does your MTA read these characters in the configuration? On Tue, 4 Jun 2019 at 12:44, Odhiambo Washington wrote: > Maybe you need to go over the documentation again, because sometimes these > are covered. > My guess is that SOGo doesn't support internationalization within > sogo.conf. > > > On Fri, 31 May 2019 at 06:25, luckydog xf wrote: > >> Does anyone have any idea? >> >> Thanks, guys. >> >> On Wed, May 29, 2019 at 11:58 AM luckydog xf >> wrote: >> >>> # sogo.conf >>> >>> { >>> .. >>> baseDN = "OU=IT服务部,OU=董事会,OU=互太高专,OU=互太纺织印染集团,DC=ms,DC=com" >>> >>> . >>> } >>> >>> SOGo cannot startup with an error, >>> >>> Parsing '/etc/sogo/sogo.conf' - bad char '\U670d' at 3993 >>> >>> Any way to work arount this error? >>> >>> Is it a must to use Non-Ascii code in sogo.conf? >>> >>> Thanks, >>> >>> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Anyway to work around Chinese Character in sogo.conf
Maybe you need to go over the documentation again, because sometimes these are covered. My guess is that SOGo doesn't support internationalization within sogo.conf. On Fri, 31 May 2019 at 06:25, luckydog xf wrote: > Does anyone have any idea? > > Thanks, guys. > > On Wed, May 29, 2019 at 11:58 AM luckydog xf wrote: > >> # sogo.conf >> >> { >> .. >> baseDN = "OU=IT服务部,OU=董事会,OU=互太高专,OU=互太纺织印染集团,DC=ms,DC=com" >> >> . >> } >> >> SOGo cannot startup with an error, >> >> Parsing '/etc/sogo/sogo.conf' - bad char '\U670d' at 3993 >> >> Any way to work arount this error? >> >> Is it a must to use Non-Ascii code in sogo.conf? >> >> Thanks, >> >> -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Addressbook Sync Error
Hello, I am using v4.0.7 and getting the following error when I try to sync addressbook from Outlook (2019): Apr 20 12:54:54 sogod [297]: <0x0x80687c4f8[SOGoCache]> Using host(s) '127.0.0.1' as server(s) Apr 20 12:54:55 sogod [297]: 154.76.158.218 "REPORT /SOGo/dav/ w...@thisdomain.com/Calendar/personal/ HTTP/1.1" 401 0/313 0.681 - - - Apr 20 12:54:55 sogod [297]: [WARN] <0x0x807a59b08[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table Apr 20 12:54:55 sogod [297]: [WARN] <0x0x807a59b08[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table Apr 20 12:54:55 sogod [297]: [WARN] <0x0x807a59b08[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table Apr 20 12:54:58 sogod [297]: 154.76.158.218 "REPORT /SOGo/dav/ w...@thisdomain.com/Calendar/personal/ HTTP/1.1" 207 125/313 3.098 - - - Apr 20 12:54:59 sogod [297]: 154.76.158.218 "PROPFIND /SOGo/dav/ w...@thisdomain.com/Contacts/directory/ HTTP/1.1" 401 0/304 0.001 - - - Apr 20 12:55:00 sogod [297]: 154.76.158.218 "PROPFIND /SOGo/dav/ w...@thisdomain.com/Contacts/directory/ HTTP/1.1" 207 138066/304 1.103 - - - Apr 20 12:55:05 sogod [297]: 154.76.158.218 "REPORT /SOGo/dav/ w...@thisdomain.com/Contacts/directory/ HTTP/1.1" 207 49595/9345 0.242 - - - Apr 20 12:55:05 sogod [297]: 154.76.158.218 "REPORT /SOGo/dav/ w...@thisdomain.com/Contacts/directory/ HTTP/1.1" 207 50042/9358 0.242 - - - *2019-04-20 12:55:06.079 sogod[297:100537] EXCEPTION: NAME:NSInvalidArgumentException REASON:'_name' must not be an empty string INFO:(null)* Apr 20 12:55:06 sogod [297]: 154.76.158.218 "REPORT /SOGo/dav/ w...@thisdomain.com/Contacts/directory/ HTTP/1.1" 501 0/9457 0.150 - - - What could the problem be? Thanks -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Trying again - Addressbook Sync Errors
Hello everyone, I have installed OutlookCalDavSynchronizer-3.6.0 on Outlook 2019. SOGo is v4.0.7. My config block for Addressbook is: SOGoUserSources = ( { type = sql; id = directory; viewURL = "mysql://sogou:X@127.0.0.1:3306/exim4u/sogo_auth_view "; canAuthenticate = YES; isAddressBook = YES; listRequiresDot = NO; userPasswordAlgorithm = md5-crypt; displayName = "CSL Global Address Book"; } ); When I try to sync the following error is logged on sogo.log: 2019-04-12 11:08:31.511 sogod[43707:100181] EXCEPTION: NAME:NSInvalidArgumentException REASON:'_name' must not be an empty string INFO:(null) while the CalDav tool generates so many messages. Sync fails of course. Any clue as to what could be the problem? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Error on sogo.log
I am seeing this on sogo.log for v4.0.7 when a user is accessing their mail: Apr 10 17:35:45 sogod [3631]: 41.90.4.204 "POST /SOGo/connect HTTP/1.1" 200 66/86 0.329 - - - Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/lm...@domain.name HTTP/1.1" 302 0/0 0.023 - - - Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/ lm...@domain.name/view HTTP/1.1" 302 0/0 0.040 - - - Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/ lm...@domain.name/Mail HTTP/1.1" 302 0/0 0.003 - - - Apr 10 17:35:47 sogod [3631]: 41.90.4.204 "GET /SOGo/so/ lm...@domain.name/Mail/view HTTP/1.1" 200 19085/0 0.095 82184 76% - Apr 10 17:35:48 sogod [3631]: 41.90.4.204 "GET /SOGo/so/ lm...@domain.name/Calendar/alarmslist?browserTime=1554906941 HTTP/1.1" 200 63/0 0.088 - - - Apr 10 17:35:49 sogod [5211]: 41.90.4.204 "GET /SOGo/so/ lm...@domain.name/Mail/0/view HTTP/1.1" 200 1135/0 0.690 - - - *2019-04-10 17:35:50.534 sogod[5211:101429] parseTimeZone: cannot parse time notation 'GMT'* Where could that be coming from? That time format is not consistent with the ones above it! Then why is it talking about GMT when in my sogo.conf I have SOGoTimeZone = Africa/Nairobi; ??? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGO upgrade
It therefore means that you haven't yet installed SOGo-4.x. What you have is SOGO-3.2.x Go ahead and install the latest SOGo and you'll find the files. If you don't, please ask your OS Distro's package maintainers. On Tue, 9 Apr 2019 at 13:44, yacin Djibril wrote: > Hi > > i added an picture of what i see. there is no sql-update-3.2.6to4.0 > > best regards > > Le lun. 8 avr. 2019 à 16:07, Odhiambo Washington a écrit : > >> What do you see? >> >> Be exhaustive when explaining yourself so it doesn't end being a chitchat. >> >> >> On Mon, 8 Apr 2019 at 15:54, yacin Djibril wrote: >> >>> Thanks Odhiambo >>> >>> But i can't see update for 4.0. is there any step i missed? >>> >>> best regards >>> >>> Le lun. 8 avr. 2019 à 15:31, Odhiambo Washington a >>> écrit : >>> >>>> cd /usr/share/doc/sogo/ >>>> >>>> wash@lists:/usr/share/doc/sogo$ ls -al >>>> total 1484 >>>> drwxr-xr-x2 root root4096 Apr 3 17:48 . >>>> drwxr-xr-x 1402 root root 69632 Apr 3 18:02 .. >>>> -rw-r--r--1 root root 141 Apr 3 09:38 changelog.Debian.gz >>>> -rw-r--r--1 root root 1289420 Apr 3 09:38 changelog.gz >>>> -rw-r--r--1 root root1144 Apr 3 09:38 copyright >>>> -rw-r--r--1 root root 41096 Apr 3 09:38 NEWS.gz >>>> -rw-r--r--1 root root2378 Apr 3 09:38 SOGo-apple-ab.conf >>>> -rwxr-xr-x1 root root1352 Apr 3 09:38 sogo-backup.sh >>>> -rwxr-xr-x1 root root1201 Apr 3 09:38 sql-update-101_to_102.sh >>>> -rwxr-xr-x1 root root 960 Apr 3 09:38 >>>> sql-update-1.2.2_to_1.3.0-mysql.sh >>>> -rwxr-xr-x1 root root 958 Apr 3 09:38 >>>> sql-update-1.2.2_to_1.3.0.sh >>>> -rwxr-xr-x1 root root 880 Apr 3 09:38 >>>> sql-update-1.3.11_to_1.3.12-mysql.sh >>>> -rwxr-xr-x1 root root1347 Apr 3 09:38 >>>> sql-update-1.3.11_to_1.3.12.sh >>>> -rwxr-xr-x1 root root1487 Apr 3 09:38 >>>> sql-update-1.3.16_to_1.3.17-mysql.sh >>>> -rwxr-xr-x1 root root1441 Apr 3 09:38 >>>> sql-update-1.3.16_to_1.3.17.sh >>>> -rwxr-xr-x1 root root 958 Apr 3 09:38 >>>> sql-update-1.3.3_to_1.3.4-mysql.sh >>>> -rwxr-xr-x1 root root 956 Apr 3 09:38 >>>> sql-update-1.3.3_to_1.3.4.sh >>>> -rwxr-xr-x1 root root1746 Apr 3 09:38 sql-update-20070724.sh >>>> -rwxr-xr-x1 root root1974 Apr 3 09:38 sql-update-20070822.sh >>>> -rwxr-xr-x1 root root1343 Apr 3 09:38 sql-update-20080303.sh >>>> -rwxr-xr-x1 root root1101 Apr 3 09:38 >>>> sql-update-2.0.4b_to_2.0.5-mysql.sh >>>> -rwxr-xr-x1 root root1666 Apr 3 09:38 >>>> sql-update-2.2.17_to_2.3.0-mysql.sh >>>> -rwxr-xr-x1 root root1620 Apr 3 09:38 >>>> sql-update-2.2.17_to_2.3.0.sh >>>> -rwxr-xr-x1 root root7303 Apr 3 09:38 >>>> sql-update-3.0.0-to-combined-mysql.sh >>>> -rwxr-xr-x1 root root7208 Apr 3 09:38 >>>> sql-update-3.0.0-to-combined.sh >>>> -rwxr-xr-x1 root root2445 Apr 3 09:38 >>>> sql-update-3.2.10_to_4.0.0-mysql.sh >>>> -rwxr-xr-x1 root root1902 Apr 3 09:38 >>>> sql-update-3.2.10_to_4.0.0.sh >>>> -rw-r--r--1 root root3047 Apr 3 09:38 updates.php >>>> >>>> Just login as root and run the update script, or do sudo .. >>>> >>>> >>>> >>>> On Sun, 7 Apr 2019 at 17:02, yacin Djibril wrote: >>>> >>>>> Hi Sebastian >>>>> >>>>> thanks for your reply but how can i execute the script. *bash >>>>> sql-update-3.2.10_to_4.0.0-mysql.sh >>>>> <http://update-3.2.10_to_4.0.0-mysql.sh> is telling me "not found file"* >>>>> >>>>> *best regards* >>>>> >>>>> Le jeu. 4 avr. 2019 à 17:57, Sebastián Meyer a écrit : >>>>> >>>>>> It's in chapter 11 of the Installation Guide: >>>>>> >>>>>> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading >>>>>> >>>>>> HTH, >>>>>> >>>>>> -- >>>>>> Seb >>>>>> >>>>>> El 4/4/19 a las 11:16, yacin Djibril (yacind...@gmail.com) escribió: >>>>>> >>>>>> could you please help me how to upgrade sogo from 3.2.6 to 4.0? >>>>>> ican't find documentation related to this. >>>>>> >>>>>> >>>>>> Ps: SoGo is installed in Yunohost >>>>>> >>>>>> thanks >>>>>> >>>>>> -- >>>>>> users@sogo.nu >>>>>> https://inverse.ca/sogo/lists >>>>>> >>>>>> >>>>>> -- >>>>>> users@sogo.nu >>>>>> https://inverse.ca/sogo/lists >>>>>> >>>>> -- >>>>> users@sogo.nu >>>>> https://inverse.ca/sogo/lists >>>>> >>>> >>>> >>>> -- >>>> Best regards, >>>> Odhiambo WASHINGTON, >>>> Nairobi,KE >>>> +254 7 3200 0004/+254 7 2274 3223 >>>> "Oh, the cruft.", grep ^[^#] :-) >>>> -- >>>> users@sogo.nu >>>> https://inverse.ca/sogo/lists >>>> >>> -- >>> users@sogo.nu >>> https://inverse.ca/sogo/lists >>> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254 7 3200 0004/+254 7 2274 3223 >> "Oh, the cruft.", grep ^[^#] :-) >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists >> > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Too much resource usage
SOGo-4.0.7 on FreeBSD-12 (amd64) with Apache/2.4.38: With only one user accessing the web UI, I see the following resource usage: last pid: 40485; load averages: 3.13, 3.15, 3.13 up 20+06:16:29 18:58:16 148 processes: 4 running, 144 sleeping CPU: 72.8% user, 0.0% nice, 2.6% system, 0.0% interrupt, 24.5% idle Mem: 634M Active, 1948M Inact, 382M Laundry, 921M Wired, 382M Buf, 107M Free Swap: 3852M Total, 1803M Used, 2049M Free, 46% Inuse PID USERNAMETHR PRI NICE SIZERES STATEC TIMEWCPU COMMAND 5211 sogod 1 1030 142M41M CPU3 3 413:03 103.76% sogod 5876 sogod 1 1030 106M24M CPU2 2 416:28 101.33% sogod 5888 sogod 1 1030 106M24M CPU1 1 416:31 100.39% sogod -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Building from Source
On Fri, 26 Apr 2019 at 00:01, Robert A Wooldridge wrote: > I'm trying to build SOGo v4.7 from the source code. I've successfully > compiled both sope and sogo but I can't seem to find sogo.conf file. > Where is it located when you do a manual build? > > > -- > > Bob Wooldridge > > EDM Incorporated > Did you already do the 'make install"?? If yes, should it not be in one of the --prefix you spec'd? How about you do: find / -type f -name sogo.conf ??? And BTW, why are you doing the manual compile? Doesn't your OS have a repo to install from? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Fwd: Trying again - Addressbook Sync Errors
Might it be that I just have forgotten how to ask smart questions or this is something that has no answer? I have googled and there is not such problem experienced with Addressbook syncing with Outlook before. Might it be that Addressbook syncing is not supported with MySQL backend as storage?? Christian Mack has been missing here for days :-) -- Forwarded message - From: Odhiambo Washington Date: Tue, 23 Apr 2019 at 14:00 Subject: Trying again - Addressbook Sync Errors To: Hello everyone, I have installed OutlookCalDavSynchronizer-3.6.0 on Outlook 2019. SOGo is v4.0.7. My config block for Addressbook is: SOGoUserSources = ( { type = sql; id = directory; viewURL = "mysql://sogou:X@127.0.0.1:3306/exim4u/sogo_auth_view "; canAuthenticate = YES; isAddressBook = YES; listRequiresDot = NO; userPasswordAlgorithm = md5-crypt; displayName = "CSL Global Address Book"; } ); When I try to sync the following error is logged on sogo.log: 2019-04-12 11:08:31.511 sogod[43707:100181] EXCEPTION: NAME:NSInvalidArgumentException REASON:'_name' must not be an empty string INFO:(null) while the CalDav tool generates so many messages. Sync fails of course. Any clue as to what could be the problem? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Enabling Password Complexity in SOGo 4.0.7
On Fri, 19 Jul 2019 at 18:14, Rene Schroth wrote: > Hi SOGo Admins and Users! > > IIRC on a former SOGo version there was a password complexity option in > the sogo.conf file. > > I cannot find it in my installation's config files. > > Does anybody know where to enable and configure the password complexity > so that users cannot define weak passwords? > > Thank you very much! > > Best Regards, > IRMA > -- > > This thread seems to answer your question: https://users.sogo.narkive.com/Jb1LRVmd/how-to-setup-password-policy-in-sogo -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo with several domains
In my apache config for SOGo, I have below: # Redirect / to /SOGo *RedirectMatch ^/$ https://webmail.crownkenya.com/SOGo <https://webmail.crownkenya.com/SOGo>* # Enable to use Microsoft ActiveSync support # Note that you MUST have many sogod workers to use ActiveSync. # See the SOGo Installation and Configuration guide for more details. # ProxyPass /Microsoft-Server-ActiveSync \ http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \ retry=60 connectiontimeout=5 timeout=360 ProxyPass /SOGo http://127.0.0.1:2/SOGo retry=0 http://127.0.0.1:2/SOGo> ## Adjust the following to your configuration ## and make sure to enable the headers module RequestHeader set "x-webobjects-server-port" "443" SetEnvIf Host (.*) HTTP_HOST=$1 RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e" env=HTTP_HOST RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}e; env=HTTP_HOST #RequestHeader set "x-webobjects-server-name" "webmail.crownkenya.com" #RequestHeader set "x-webobjects-server-url" " https://webmail.crownkenya.com; AddDefaultCharset UTF-8 ## When using proxy-side autentication, you need to uncomment and ## adjust the following line: RequestHeader unset "x-webobjects-remote-user" # RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" env=REMOTE_USER RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0" My questions is about this: *RedirectMatch ^/$ https://webmail.crownkenya.com/SOGo <https://webmail.crownkenya.com/SOGo>* How do I make that non-domain specific? Can I do *RedirectMatch ^/$ * "https://%{HTTP_HOST}e; env=HTTP_HOST*/SOGo* *:-)* -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Ubuntu 18.04 installation
On Mon, 7 Oct 2019 at 16:26, Jaap Stolk wrote: > Hi, > > I'm trying to install Sogo on an Ubuntu 18.04 test server. This server > will also run the LDAP server, which I originally planned to use for > sharing Thunderbird address books.I'm only looking for a shared > address book solution, the actual (IMAP) email is served separately. > > I just subscribed and could only find a recent mail about installing > iRedMail which should integrate Sogo. But I already have a > mail-server. > > I'm following the FAQ: > https://sogo.nu/support/faq/how-to-install-sogo-on-ubuntu.html#/faq an > run into some issues: > > - Not mentioned in the FAQ, but there are Sogo packages in the > official Ubuntu repository. For Ubuntu 18.4 (the latest > Long-Term_Support version) this is still 3.2.10-1build1 from July 5, > 2017. And I think it's better to use a v4 version for a new > installation. > https://sogo.nu/support/faq/how-to-install-nightly-sogo-versions-on-ubuntu.html Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Could not create draft folder
On Tue, 1 Sep 2020 at 17:58, Christian Mack wrote: > Hello > > Am 29.08.20 um 12:00 schrieb Odhiambo Washington (odhia...@gmail.com): > > This is new for me with SOGo-5. Was never happening with v4.x > > > > Aug 29 12:53:24 sogod [207342]: [ERROR] > > <0x5633aecb3a30[SOGoDraftObject]:newDraft1598694575-1> could not create > > folder for draft: '/var/spool/virtual/my.dom.ain/john...@my.dom.ain > > /newDraft1598694575-1' > > > > This is a virtual domain setup where I login using john...@my.dom.ain > > > > The folder structure is /path/to/folders/my.dom.ain/johndoe/Maildir/ > > > > Not sure I understand what is causing the error above, but the path > > information it's giving me is a little confusing, especially because the > > IMAP server can write to the > /var/spool/virtual/my.dom.ain/johndoe/Maildir/ > > > > > > This is on the SOGo server. > You defined two local folders for building a MIME email in sogo.conf via > SOGoMailSpoolPath and NGMimeBuildMimeTempDirectory. > Those are used before a newly created email gets saved in the IMAP > Drafts folder. > > Hope that helps a bit. > Hi Christian, That helped me solve the problem. Thanks. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On Mon, 12 Oct 2020 at 13:39, Götz Reinicke wrote: > Hi, > > what are the right steps to migrate the SOGo database to a new database > server (with new server name): > > - dump/backup all user data > - shutdown sogo > - add a new database to the new server > - edit the sogo.conf database serve name/user/password > It's easier to just reuse the creds from sogo.conf so no need to edit sogo.conf (dbname, username, password): MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH mysql_native_password BY 'the_password'; MYSQL>GRANT ALL ON dbname.* TO 'username'@'hostname OR IP'; - restart sogo > - restore the user data from the backup > > Did I miss something? > Yes. move the dump to the new server :-) > > Are there known problems with the DB version upgrade? > I did not encounter any when I migrated from 5.7 to 8.0. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On Tue, 13 Oct 2020 at 00:05, Götz Reinicke wrote: > Hi, > > Am 12.10.2020 um 13:47 schrieb Odhiambo Washington (odhia...@gmail.com) < > users@sogo.nu>: > > > > On Mon, 12 Oct 2020 at 13:39, Götz Reinicke wrote: > >> Hi, >> >> what are the right steps to migrate the SOGo database to a new database >> server (with new server name): >> >> - dump/backup all user data >> - shutdown sogo >> - add a new database to the new server >> - edit the sogo.conf database serve name/user/password >> > > It's easier to just reuse the creds from sogo.conf so no need to edit > sogo.conf (dbname, username, password): > MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH > mysql_native_password BY 'the_password'; > MYSQL>GRANT ALL ON dbname.* TO 'username'@'hostname OR IP‘; > > > > true@credentials. I’m used to set new ones, so I can be 100% sure I’m > connecting to the new db. > Okay. > - restart sogo >> - restore the user data from the backup >> >> Did I miss something? >> > > Yes. move the dump to the new server :-) > > > I guess you talk about the database dump? As the database server name will > change, I can’t use the „old“ dump anymore I think. > Yes. I meant the DB backup. > > By dumping the user data I was referring to the pogo-tool backup. May be I > was a bit confusing, or did misunderstand you. > I never had to do that because on my servers, there is nothing that sogo saves outside the DB. TBH, I have never used sogo-tool even once! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists