Hello Am 14.03.2018 um 12:53 schrieb Henk van Oers ([email protected]): > > I use Apache 2.4, Dovecot, postfix, Postgresql > and SOGo 3.2.9, all installed via FreeBSD 11.1 "ports". > > My users are in a PG table, so I use a "sogo_view" as per install guide. > > Pointing my browser to the webserver I get the login page, > but submitting the username/password I get a "red" screen. > > How do I debug this? > > sogo.log: > > Mar 14 12:13:44 sogod [765]: |SOGo| starting method 'POST' on uri > '/SOGo/connect' > Mar 14 12:13:44 sogod [765]: <0x0x80d734b30[SOGoCache]> Cache cleanup > interval set every 300.000000 seconds > Mar 14 12:13:44 sogod [765]: <0x0x80d734b30[SOGoCache]> Using host(s) > '/var/run/memcached/memcached.sock' as server(s) > 2018-03-14 12:13:44.596 sogod[765:100090] PostgreSQL72 connection > established: <0x0x811d7da30[PGConnection]: connection=0x0x80bf12600> > 2018-03-14 12:13:44.596 sogod[765:100090] PostgreSQL72 channel > 0x0x80bca4e30 opened (connection=<0x0x811d7da30[PGConnection]: > connection=0x0x80bf12600>) > 2018-03-14 12:13:44.596 sogod[765:100090] PG0x0x80bca4e30 SQL: SELECT > c_password FROM sogo_view WHERE c_uid = 'henk' > Mar 14 12:13:44 sogod [651]: <0x0x80d67efb0[WOWatchDogChild]> child 765 > exited < cut >
What errors does your postgresql log? Can you do that SELECT from psql as user sogo? What do you get with PGDebugEnabled = YES; in sogo.conf? Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
