Hi all,
after two days of unsuccessful attempts to get the SOGo login to work I'd like to ask you for help. My OS is: CentOS 5.6. I installed SOGo successfully so far. In the log file there are no errors left from what I understand. Nevertheless I can't login using a user name and password - stored in the sogo_view table - which are identical to the imap mail account I want to access. My sogo_view table in my mysql database has these columns: c_uid c_name c_password c_cn mail I deactivated the firewall in case this could have any impact on the database port. mysqld and of course sogod and httpd are running. This is the log file consisting of 3 steps I executed: sogod start, sogo website access in browser, one attempt to login Jul 25 02:26:03 sogod [10472]: Terminating with signal 15 Jul 25 02:26:03 sogod [10472]: sending terminate signal to pid 10477 MySQL4 connection dropped 0x0xa65e30 (channel=0x0xb0f2b0) Jul 25 02:26:03 sogod [10472]: child 10477 exited Jul 25 02:26:03 sogod [10472]: all children exited. We now terminate. Jul 25 02:26:04 sogod [10614]: version 1.3.8 (build [email protected] 201107141607) -- starting Jul 25 02:26:04 sogod [10614]: vmem size check enabled: shutting down app when vmem > 384 MB Jul 25 02:26:04 sogod [10614]: SOGo products loaded from '/usr/GNUstep/System/Library/SOGo': Jul 25 02:26:04 sogod [10614]: Mailer.SOGo, Appointments.SOGo, MailPartViewers.SOGo, AdministrationUI.SOGo, MailerUI.SOGo, SchedulerUI.SOGo, CommonUI.SOGo, PreferencesUI.SOGo, Contacts.SOGo, MainUI.SOGo, ContactsUI.SOGo Jul 25 02:26:04 sogod [10614]: listening on *:20000 Jul 25 02:26:04 sogod [10614]: watchdog process pid: 10614 Jul 25 02:26:04 sogod [10614]: watchdog request timeout set to 10 minutes Jul 25 02:26:04 sogod [10614]: preparing 1 children Jul 25 02:26:04 sogod [10614]: child spawned with pid 10619 2011-07-25 02:26:04.612 sogod[10619] MySQL4 connection established 0x0xa65e30 2011-07-25 02:26:04.612 sogod[10619] MySQL4 channel 0x0xb0f2b0 opened (connection=0x0xa65e30,sogo) 2011-07-25 02:26:04.612 sogod[10619] SQL: SELECT count(*) FROM sogo_user_profile; 2011-07-25 02:26:04.613 sogod[10619] query has results, entering fetch-mode. 2011-07-25 02:26:04.613 sogod[10619] SQL: SELECT count(*) FROM sogo_folder_info; 2011-07-25 02:26:04.613 sogod[10619] query has results, entering fetch-mode. 2011-07-25 02:26:04.614 sogod[10619] SQL: SELECT count(*) FROM sogo_sessions_folder; 2011-07-25 02:26:04.615 sogod[10619] query has results, entering fetch-mode. Jul 25 02:26:27 sogod [10619]: |SOGo| starting method 'GET' on uri '/SOGo/' Jul 25 02:26:27 sogod [10619]: Cache cleanup interval set every 300.000000 seconds Jul 25 02:26:27 sogod [10619]: Using host(s) 'localhost' as server(s) Jul 25 02:26:27 sogod [10619]: |SOGo| traverse(acquire): SOGo Jul 25 02:26:27 sogod [10619]: |SOGo| do traverse name: 'SOGo' 2011-07-25 02:26:27.698 sogod[10619] Note(SoObject): SoDebugKeyLookup is enabled! 2011-07-25 02:26:27.698 sogod[10619] Note(SoObject): SoDebugBaseURL is enabled! 2011-07-25 02:26:27.698 sogod[10619] Note(SoObject): relative base URLs are enabled. Jul 25 02:26:27 sogod [10619]: D validate object: Jul 25 02:26:27 sogod [10619]: D object is public. Jul 25 02:26:27 sogod [10619]: D validate key SOGo of object: Jul 25 02:26:27 sogod [10619]: D found no security info for key (class SOGo): SOGo Jul 25 02:26:27 sogod [10619]: D default is allow ... Jul 25 02:26:27 sogod [10619]: |SOGo| set clientObject: 2011-07-25 02:26:27.699 sogod[10619] SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'anonymous'; 2011-07-25 02:26:27.699 sogod[10619] query has results, entering fetch-mode. 2011-07-25 02:26:27.713 sogod[10619] WOCompoundElement: pool embedding is on. 2011-07-25 02:26:27.713 sogod[10619] WOCompoundElement: id logging is on. 2011-07-25 02:26:27.728 sogod[10619] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!! Jul 25 02:26:27 sogod [10619]: |SOGo| request took 0.045303 seconds to execute Jul 25 02:26:27 sogod [10619]: Zipping of response disabled 92.193.5.230 - - [25/Jul/2011:02:26:27 GMT] "GET /SOGo/ HTTP/1.1" 200 10719/0 0.047 - - 3M Jul 25 02:29:48 sogod [10619]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Jul 25 02:29:48 sogod [10619]: |SOGo| traverse(acquire): SOGo => connect Jul 25 02:29:48 sogod [10619]: |SOGo| do traverse name: 'SOGo' Jul 25 02:29:48 sogod [10619]: D validate object: Jul 25 02:29:48 sogod [10619]: D object is public. Jul 25 02:29:48 sogod [10619]: D validate key SOGo of object: Jul 25 02:29:48 sogod [10619]: D found no security info for key (class SOGo): SOGo Jul 25 02:29:48 sogod [10619]: D default is allow ... Jul 25 02:29:48 sogod [10619]: |SOGo| do traverse name: 'connect' Jul 25 02:29:48 sogod [10619]: D validate key connect of object: Jul 25 02:29:48 sogod [10619]: D validate permission '' on object: Jul 25 02:29:48 sogod [10619]: D successfully validated permission ''. Jul 25 02:29:48 sogod [10619]: D successfully validated key (connect). Jul 25 02:29:48 sogod [10619]: D validate object: Jul 25 02:29:48 sogod [10619]: D object is public. Jul 25 02:29:48 sogod [10619]: D validate key connect of object: Jul 25 02:29:48 sogod [10619]: D validate permission '' on object: Jul 25 02:29:48 sogod [10619]: D successfully validated permission ''. Jul 25 02:29:48 sogod [10619]: D successfully validated key (connect). Jul 25 02:29:48 sogod [10619]: |SOGo| set clientObject: Jul 25 02:29:48 sogod [10619]: SOGoRootPage Login for user 'web459p90' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 Jul 25 02:29:48 sogod [10619]: |SOGo| request took 0.001782 seconds to execute Jul 25 02:29:48 sogod [10619]: Zipping of response disabled 92.193.5.230 - - [25/Jul/2011:02:29:48 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/45 0.003 - - 24K My SOGo.conf file is as follows: Alias /SOGo.woa/WebServerResources/ /usr/GNUstep/System/Library/SOGo/WebServerResources/ Alias /SOGo/WebServerResources/ /usr/GNUstep/System/Library/SOGo/WebServerResources/ AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/GNUstep/System/Library/SOGo/$1.SOGo/Resources/$2 SetHandler default-handler ## Uncomment the following to enable proxy-side authentication, you will then ## need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES and ## adjust the "x-webobjects-remote-user" proxy header in the "Proxy" section ## below. # # AuthType XXX # Require valid-user # SetEnv proxy-nokeepalive 1 # Allow from all # ProxyRequests Off SetEnv proxy-nokeepalive 1 ProxyPreserveHost On # When using CAS, you should uncomment this and install cas-proxy-validate.py # in /usr/lib/cgi-bin to reduce server overloading # # ProxyPass /SOGo/casProxy http://localhost/cgi-bin/cas-proxy-validate.py # # Order deny,allow # Allow from your-cas-host-addr # ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0 ## adjust the following to your configuration RequestHeader set "x-webobjects-server-port" "80" RequestHeader set "x-webobjects-server-name" "#IP-ADDRESS-OF-MY-WEBSERVER#" RequestHeader set "x-webobjects-server-url" "#http://IP-ADDRESS-OF-MY-WEBSERVER#"; ## When using proxy-side autentication, you need to uncomment and ## adjust the following line: # RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0" RequestHeader set "x-webobjects-remote-host" %{REMOTE_HOST}e env=REMOTE_HOST AddDefaultCharset UTF-8 Order allow,deny Allow from all ## We use mod_rewrite to pass remote address to the SOGo proxy. # The remote address will appear in SOGo's log files and in the X-Forward # header of emails. RewriteEngine On RewriteRule ^/SOGo/(.*)$ /SOGo/$1 [env=REMOTE_HOST:%{REMOTE_ADDR},PT] My .GNUstepsDefault has these values: NSGlobalDomain sogod SOGoProfileURL mysql://sogo:#PASS#@localhost:3306/sogo/sogo_user_profile OCSFolderInfoURL mysql://sogo:#PASS#@localhost:3306/sogo/sogo_folder_info OCSSessionsFolderURL mysql://sogo:#PASS#@localhost:3306/sogo/sogo_sessions_folder SOGoTimeZone Europe/Berlin SOGoMailDomain #MAIL-DOMAIN# SOGoLanguage German SOGoUserSources type sql id directory viewURL mysql://sogo:#PASS#@localhost:3306/sogo/sogo_view userPasswordAlgorithm none canAuthenciate YES isAddressBook NO SOGoMailingMechanism smtp SOGoSMTPServer #SMTP-SERVER# SOGoDraftsFolderName Drafts SOGoSentFolderName Sent SOGoTrashFolderName Trash SOGoIMAPServer imap://#MAIL-SERVER#:143 SOGoTrashFolderName Trash GCSFolderDebugEnabled YES GCSFolderStoreDebugEnabled YES LDAPDebugEnabled YES MySQL4DebugEnabled YES NGImap4DisableIMAP4Pooling YES OCSFolderManagerSQLDebugEnabled YES PGDebugEnabled YES SOGoDebugRequests YES SOGoMailKeepDraftsAfterSend YES SOGoUIxDebugEnabled YES SoDebugObjectTraversal YES SoSecurityManagerDebugEnabled YES WODontZipResponse YES WODebugZipResponse YES Regarding the mysql database configuration I double checked that the database and the tables are set to utf8. Before the installation of mysql I made sure that sope4.9-gdl1-mysql is installed. When I start mysqld I get this information in the log file. I'm not sure if it's of relevance with respect to my login issue: 110725 03:19:33 mysqld started 110725 3:19:33 [Warning] /usr/libexec/mysqld: ignoring option '--character-set-client-handshake' due to invalid value 'utf8' 110725 3:19:33 InnoDB: Started; log sequence number 0 43665 110725 3:19:33 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Any help is highly appreciated! Many thanks in advance! Regards Helge -- [email protected] https://inverse.ca/sogo/lists
