Re: [SOGo] Cannot login following new install
Hi, On Fri, Feb 10, 2012 at 4:43 AM, Nigel Pegram ndpeg...@gmail.com wrote: However, nothing new is displayed, the login page still appears. If the wrong password is used, an error message appears, as expected. And what happens if you give the correct password -- nothing? There are no errors in the apache logs, just: 127.0.0.1 - - [10/Feb/2012:10:32:27 +0800] GET /SOGo/chris HTTP/1.1 200 4036 http://localhost/SOGo/; Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:10.0) Gecko/20100101 Firefox/10.0 What about SOGo's own log? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Hi, On Thu, Feb 9, 2012 at 4:50 AM, Nigel Pegram ndpeg...@gmail.com wrote: My problem is that I cannot login. I have tried creating a couple of users in the sogo_view table and have tried passwords in clear text, and md5. All the other tables are empty since ths is my first login attempt. It seems that the communication is happening between sogo and the database, but something fails after the query. I don't know how to debug this any further. Perhaps the problem is with the MySQL views you created for authenticating your users? I have no experience on MySQL+SOGo combo myself, but perhaps this Linux Journal tutorial could help if you followed it step by step: http://www.linuxjournal.com/article/10894 Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Op 09-02-12 03:50, Nigel Pegram schreef: Hello everyone, I have installed a new installation of sogo on Ubuntu 10.10. I have used mysql as the data store. I have the daemons running and am able to display the web page http://localhost/SOGo My problem is that I cannot login. I have tried creating a couple of users in the sogo_view table and have tried passwords in clear text, and md5. All the other tables are empty since ths is my first login attempt. It seems that the communication is happening between sogo and the database, but something fails after the query. I don't know how to debug this any further. Maybe you like this tutorial what I wrote: http://wiki.debian.org/SOGo With regards, Paul. -- Paul van der Vlis Linux systeembeheer Groningen http://www.vandervlis.nl -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Thank you Peter and Paul, I will look at them both. Cheers Nigel -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Ok. I've made a little progress, starting again using the LJ article settings, including reinstalling SOGo. Now the DB log shows: 120210 10:26:0133608 Connectsogo@localhost on sogo 33608 QuerySET CHARACTER SET utf8 33608 QuerySELECT c_password FROM sogo_users WHERE c_uid = 'chris' 33608 QuerySELECT * FROM sogo_users WHERE (c_uid = 'chris') OR (mail = 'chris') 33608 QuerySELECT c_settings FROM sogo_user_profile WHERE c_uid = 'chris' So we have things happening beyond the initial password lookup. Now in the browser the URL changes from localhost/SOGo to localhost/SOGo/username However, nothing new is displayed, the login page still appears. If the wrong password is used, an error message appears, as expected. There are no errors in the apache logs, just: 127.0.0.1 - - [10/Feb/2012:10:32:27 +0800] GET /SOGo/chris HTTP/1.1 200 4036 http://localhost/SOGo/; Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:10.0) Gecko/20100101 Firefox/10.0 TIA Nigel -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Cannot login following new install
Hello everyone, I have installed a new installation of sogo on Ubuntu 10.10. I have used mysql as the data store. I have the daemons running and am able to display the web page http://localhost/SOGo My problem is that I cannot login. I have tried creating a couple of users in the sogo_view table and have tried passwords in clear text, and md5. All the other tables are empty since ths is my first login attempt. It seems that the communication is happening between sogo and the database, but something fails after the query. I don't know how to debug this any further. Every time the logs give the same result: 31415 Query SELECT c_password FROM sogo_view WHERE c_uid = 'nigel' 120209 10:47:01 31417 Connect sogo@localhost on sogo 31417 Query SET CHARACTER SET utf8 31417 Query BEGIN 31417 Query SELECT t1.c_alarm_number, t1.c_name, t1.c_path, t1.c_recurrence_id, t1.c_uid FROM sogo_alarms_folder t1 WHERE t1.c_alarm_date = 1328755320 AND t1.c_alarm_date = 1328755620 31417 Query ROLLBACK 31417 Query BEGIN 31417 Query DELETE FROM sogo_alarms_folder WHERE c_alarm_date = 1328755620 31417 Query COMMIT My configuration is below (with passwords changed). ?xml version=1.0 encoding=UTF-8? !DOCTYPE plist PUBLIC -//GNUstep//DTD plist 0.9//EN http://www.gnustep.org/plist-0_9.xml; plist version=0.9 dict keyNSGlobalDomain/key dict /dict keysogod/key dict keyMySQL4DebugEnabled/key stringyes/string keyOCSEMailAlarmsFolderURL/key stringmysql://sogo:password@localhost:3306/sogo/sogo_alarms_folder/string keyOCSFolderInfoURL/key stringmysql://sogo:password@localhost:3306/sogo/sogo_folder_info/string keyOCSSessionsFolderURL/key stringmysql://sogo:password@localhost:3306/sogo/sogo_sessions_folder/string keySOGoACLsSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailNotifications/key stringYES/string keySOGoAppointmentSendEMailReceipts/key stringYES/string keySOGoDraftsFolderName/key stringDrafts/string keySOGoEnableEMailAlarms/key stringYES/string keySOGoFoldersSendEMailNotifications/key stringYES/string keySOGoIMAPServer/key stringlocalhost:993/string keySOGoLanguage/key stringEnglish/string keySOGoMailComposeMessageType/key stringhtml/string keySOGoMailDomain/key stringpegram.homelinux.net/string keySOGoMailMessageCheck/key stringevery_10_minutes/string keySOGoMailReplyPlacement/key stringabove/string keySOGoMailSignaturePlacement/key stringabove/string keySOGoMailingMechanism/key stringsmtp/string keySOGoProfileURL/key stringmysql://sogo:password@localhost:3306/sogo/sogo_user_profile/string keySOGoSMTPServer/key stringlocalhost/string keySOGoSentFolderName/key stringSent/string keySOGoTimeZone/key stringAustralia/Perth/string keySOGoTrashFolderName/key stringTrash/string keySOGoUserSources/key array dict keycanAuthenticate/key stringYES/string keydisplayName/key stringPegram Address Book/string keyid/key stringdirectory/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyuserPasswordAlgorithm/key stringmd5/string keyviewURL/key stringmysql://sogo:password@localhost:3306/sogo/sogo_view/string /dict /array keySoSecurityManagerDebugEnabled/key stringyes/string /dict /dict /plist TIA Nigel -- users@sogo.nu https://inverse.ca/sogo/lists