Hi Lars, Might you be able to share HOW you manually install it on FreeBSD? I usually rely on installing using the FreeBSD port and since v5 hasn't been ported to FreeBSD, I am stuck on v4.3.2.
On Thu, 1 Oct 2020 at 20:13, Lars Liedtke <users@sogo.nu> wrote: > Hi *, > > So I tried installing SOGo5 on FreeBSD. Got it working so far, and set it > up the same way I did with did with Sogo 4.3.2 (Ansible). But I cannot > log in on my vagrant box neither over LDAP/AD nor over a "normal" Database > connection. > > I can see an error in the logs, but I don't know what it means. > > Oct 01 17:35:39 sogod [14915]: |SOGo| starting method 'GET' on uri > '/SOGo/so/ry86/Mail/view' > Oct 01 17:35:39 sogod [14915]: <0x0x80d24df68[SOGoCache]> Cache cleanup > interval set every 300.000000 seconds > Oct 01 17:35:39 sogod [14915]: <0x0x80d24df68[SOGoCache]> Using host(s) > 'localhost' as server(s) > 2020-10-01 17:35:39.408 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: BEGIN; > 2020-10-01 17:35:39.408 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has no results. > 2020-10-01 17:35:39.409 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: SELECT t1.c_creationdate, t1.c_id, > t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE > t1.c_id='lTB3MdkwTh+gJnR2n7EWSA=='; > 2020-10-01 17:35:39.410 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has results, entering fetch-mode. > 2020-10-01 17:35:39.411 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: ROLLBACK; > 2020-10-01 17:35:39.411 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has no results. > 2020-10-01 17:35:39.414 sogod[14915:101031] MySQL4 connection established > 0x0x80d367300 > 2020-10-01 17:35:39.414 sogod[14915:101031] MySQL4 channel 0x0x80cfbe1e8 > opened (connection=0x0x80d367300,sogo) > 2020-10-01 17:35:39.414 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> SQL: BEGIN; > 2020-10-01 17:35:39.414 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> query has no results. > 2020-10-01 17:35:39.414 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> SQL: SELECT t1.c_creationdate, t1.c_id, > t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE > t1.c_id='lTB3MdkwTh+gJnR2n7EWSA=='; > 2020-10-01 17:35:39.414 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> query has results, entering fetch-mode. > 2020-10-01 17:35:39.414 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> SQL: ROLLBACK; > 2020-10-01 17:35:39.415 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> query has no results. > 2020-10-01 17:35:39.415 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: BEGIN; > 2020-10-01 17:35:39.415 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has no results. > 2020-10-01 17:35:39.415 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: UPDATE sogo_sessions_folder SET c_lastseen = > 1601566539, c_creationdate = 1601565510, c_value = > 'U9DH9V/gAYHaYIayZFpnBicSJLIyP9kBsvyiHmvub5wtw6K7I6eZ/UI7IAZ2ds3gKrP5sIjXn7456T5IjjOt2Y3XTUSG9Aly8jFI2gqVBipPThJDYPUhO5cfmMIIJX+w8Y4OjcYz24YnIurshFOfIL6XeEHcU+pJaUmKgomWS57xxBdnLt6lP2nw0u47eIabFyuro+uJKwH0YI4U7wsgWg==', > c_id = 'lTB3MdkwTh+gJnR2n7EWSA==' WHERE c_id='lTB3MdkwTh+gJnR2n7EWSA=='; > 2020-10-01 17:35:39.416 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has no results. > 2020-10-01 17:35:39.416 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: COMMIT; > 2020-10-01 17:35:39.418 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has no results. > 2020-10-01 17:35:39.422 sogod[14915:101031] MySQL4 connection established > 0x0x80d367800 > 2020-10-01 17:35:39.422 sogod[14915:101031] MySQL4 channel 0x0x80cfbef68 > opened (connection=0x0x80d367800,sogo) > 2020-10-01 17:35:39.422 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> SQL: SELECT c_password FROM resources WHERE c_uid = > 'ry86'; > 2020-10-01 17:35:39.424 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> query has results, entering fetch-mode. > Oct 01 17:35:39 sogod [14915]: <0x0x80d31ada8[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > Oct 01 17:35:39 sogod [14915]: <0x0x80d31ae98[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > 2020-10-01 17:35:39.505 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter > '(objectClass=*)' for attrs 'subschemaSubentry' > 2020-10-01 17:35:39.519 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '<baseDN>' > filter '(objectClass=*)' for attrs 'objectclasses' > 2020-10-01 17:35:39.591 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '<baseDN>' > filter '<filter>' for attrs 'dn' > 2020-10-01 17:35:39.687 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> SQL: SELECT * FROM resources WHERE (c_uid = 'ry86') > OR (mail = 'ry86'); > 2020-10-01 17:35:39.687 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> query has results, entering fetch-mode. > Oct 01 17:35:39 sogod [14915]: <0x0x812342408[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > 2020-10-01 17:35:39.764 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '<baseDN>' > filter '<filter>' for attrs '*' > 2020-10-01 17:35:39.784 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> SQL: SELECT c_defaults FROM sogo_user_profile WHERE > c_uid = 'ry86'; > 2020-10-01 17:35:39.784 sogod[14915:101031] <MySQL4Channel[0x0x80cfbe1e8] > connection=0x0x80d367300> query has results, entering fetch-mode. > 2020-10-01 17:35:39.889 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> SQL: SELECT c_settings FROM sogo_user_profile WHERE > c_uid = 'ry86'; > 2020-10-01 17:35:39.889 sogod[14915:101031] <MySQL4Channel[0x0x80d2bc468] > connection=0x0x80d365a00> query has results, entering fetch-mode. > 2020-10-01 17:35:39.890 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> SQL: SELECT * FROM resources WHERE (c_uid = 'ry86') > OR (mail = 'ry86'); > 2020-10-01 17:35:39.890 sogod[14915:101031] <MySQL4Channel[0x0x80cfbef68] > connection=0x0x80d367800> query has results, entering fetch-mode. > Oct 01 17:35:39 sogod [14915]: <0x0x80c283d78[NGLdapConnection]> Using > ldap_initialize for LDAP URL: ldap://127.0.0.1:389 > 2020-10-01 17:35:39.970 sogod[14915:101031] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base '<filter>' > 2020-10-01 17:35:39.988 sogod[14915:101031] EXCEPTION: <NSException: > 0x80c39b878> NAME:NSInvalidArgumentException REASON:-[NSURL queryComponents]: > unrecognized selector sent to instance 0x80c39b7e8 INFO:(null) > Oct 01 17:35:39 sogod [14915]: |SOGo| request took 0.589178 seconds to execute > Oct 01 17:35:39 sogod [14915]: 172.17.28.1 "GET /SOGo/so/ry86/Mail/view > HTTP/1.1" 501 0/0 0.596 - - - > > ry86 is my user-account and I redacted the baseDN and the filter, but they > seem to work and worked on 4.3.2 > > AD is connected via stunnel. > > I adapted the IMAP and SMTP URLs in the config to allow insecure localhost > > I get the same error when trying to login via database with a different > account. > > Can someone make sense out of that? > > Cheers > > Lars > > -- > ---punkt.de GmbH > Lars Liedtke > .infrastructure > > Kaiserallee 13a > 76133 Karlsruhe > > Tel. +49 721 9109 500https://infrastructure.punkt.dei...@punkt.de > > AG Mannheim 108285 > Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein > > -- > 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
