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'':
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:
http://www.gnustep.org/plist-0_9.xml";>
NSGlobalDomain
sogod
OCSFolderInfoURL
postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info
OCSSessionsFolderURL
postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder
SOGoACLsSendEMailNotifications
YES
SOGoAppointmentSendEMailNotifications
YES
SOGoDraftsFolderName
Drafts
SOGoFoldersSendEMailNotifications
YES
SOGoIMAPServer
localhost
SOGoLanguage
Italian
SOGoMailDomain
comune.cossato.bi.it
SOGoMailingMechanism
smtp
SOGoProfileURL
postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile
SOGoSMTPServer
localhost
SOGoSentFolderName
Sent
SOGoTimeZone
Europe/Rome
SOGoTrashFolderName
Trash
SOGoUserSources
canAuthenticate
YES
id
id
directory
isAddressBook
YES
type
sql
userPasswordAlgorithm
md5
viewURL
postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view
Thanks to replying people, redards to all,
Andrea Ferraris
A.d.S. CED Comune di Cossato
Tel. fisso: 015/9893235
Tel. cell.: 329/2107393
--
users@sogo.nu
https://inverse.ca/sogo/lists