Hi, I'm a newcomer and have some big problems to get my first new installation working on Ubuntu 10 LTS 64 bit.
I searched the archives of the mailing list, but I couldn't find any answer about the subject. I followed the steps in the Installation guide (1.3.6), but it seems that there are no the table with the data for user authentication. I'd like to know how to get authentication working only with SQL (Postgres), no LDAP, how can I import my user data from a Linux mailserver where authentication was based on password file (I already generated a password file with the effective md5 password included). It is, I'd need the structure of the table where to import and eventually the bindings with other table to fill approprately and to know if there are some script to generate such tables and view. Here you can find the log errors about the view that doesn't exist when I try to authenticate from the web as jdoe with password qwerty as described in the manual and at the end my .GNUstepDefaults. Apr 14 09:15:14 sogod [1201]: SOGoRootPage Login for user 'jdoe' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 mailsogo.comune.cossato.bi.it - - [14/Apr/2011:09:15:14 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/58 0.004 - - 0 localhost - - [14/Apr/2011:09:37:53 GMT] "GET /SOGo HTTP/1.1" 302 0/0 0.006 - - 0 localhost - - [14/Apr/2011:09:37:53 GMT] "GET /SOGo/ HTTP/1.1" 200 2113/0 0.005 - - 0 localhost - - [14/Apr/2011:10:24:51 GMT] "GET /SOGo HTTP/1.1" 302 0/0 0.009 - - 0 2011-04-14 10:24:51.581 sogod[1201] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!! localhost - - [14/Apr/2011:10:24:51 GMT] "GET /SOGo/ HTTP/1.1" 200 3453/0 0.021 10508 67% 0 Apr 14 10:25:14 sogod [1201]: [ERROR] <0x0x25b6ca0[SQLSource]> could not run SQL 'SELECT c_password FROM sogo_view WHERE c_uid = 'jdoe'': <PostgreSQL72Exception: 0x2b90b70> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x2ad0b10[PostgreSQL72Channel]: connection=<0x0x2b6a140[PGConnection]: connection=0x0x2b6e520>>): ERROR: relation "sogo_view" does not exist LINE 1: SELECT c_password FROM sogo_view WHERE c_uid = 'jdoe' My .GNUstepDefaults: <?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> <key>NSGlobalDomain</key> <dict> </dict> <key>sogod</key> <dict> <key>OCSFolderInfoURL</key> <string>postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info</string> <key>OCSSessionsFolderURL</key> <string>postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder</string> <key>SOGoACLsSendEMailNotifications</key> <string>YES</string> <key>SOGoAppointmentSendEMailNotifications</key> <string>YES</string> <key>SOGoDraftsFolderName</key> <string>Drafts</string> <key>SOGoFoldersSendEMailNotifications</key> <string>YES</string> <key>SOGoIMAPServer</key> <string>localhost</string> <key>SOGoLanguage</key> <string>Italian</string> <key>SOGoMailDomain</key> <string>comune.cossato.bi.it</string> <key>SOGoMailingMechanism</key> <string>smtp</string> <key>SOGoProfileURL</key> <string>postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile</string> <key>SOGoSMTPServer</key> <string>localhost</string> <key>SOGoSentFolderName</key> <string>Sent</string> <key>SOGoTimeZone</key> <string>Europe/Rome</string> <key>SOGoTrashFolderName</key> <string>Trash</string> <key>SOGoUserSources</key> <array> <dict> <key>canAuthenticate</key> <string>YES</string> <key>id</key> <key>id</key> <string>directory</string> <key>isAddressBook</key> <string>YES</string> <key>type</key> <string>sql</string> <key>userPasswordAlgorithm</key> <string>md5</string> <key>viewURL</key> <string>postgresql://sogo:[email protected]:5432/sogo/sogo_view</string> </dict> </array> </dict> </dict> </plist> Thanks to replying people, redards to all, Andrea Ferraris A.d.S. CED Comune di Cossato Tel. fisso: 015/9893235 Tel. cell.: 329/2107393 -- [email protected] https://inverse.ca/sogo/lists
