Hi Martin Thank you very much. The id=database, does the trick.
Yes the passwords are stored in plain text. I don't see any advantage in storing them in md5 format. Access is only allowed from local machine. From my point of view it is much more important to secure the access either via web or directly via any sort of client. But again. Thank you very much for your help. Regards, Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email: [email protected] > Hi, > > are the passwords plain in the database? > => userPasswordAlgorithm = none (??) > > Here is a SOGoUserSources I use: > defaults write sogod SOGoUserSources '({id=database; isAddressBook = > YES; canAuthenticate=NO; displayName = "Globale Adressen"; type=sql; > userPasswordAlgorithm = md5; viewURL = > "mysql://$DB_SOGO_PWD:$db_sogo_u...@localhost:3306/$DATABASE_SOGO_AUTH/sogo_auth\";})' > > Should run - runs last week ... ;-) > > > Greetings, > Martin > > > Am 15.09.2010 11:05, schrieb Carsten Laun-De Lellis: >> Hi all >> >> After typing in the right command i got another error message: >> >> defaults write sogod SOGoUserSources '({type = sql;id = >> directory;viewURL >> = "mysql://mail:m...@localhost:3306/mail/sogo_view";canAuthenticate = >> YES;isAddressBook = YES;userPasswordAlgorithm = none;})' >> 2010-09-15 10:57:09.652 defaults[10740] Creating empty user defaults >> database >> 2010-09-15 10:57:09.687 defaults[10740] File NSData.m: 1576. In -[NSData >> writeToFile:options:error:] Unable to correctly set all attributes for >> '/home/sogo/GNUstep/Defaults/.GNUstepDefaults' >> >> I don't know where i have the mistake. >> >> I have created a database "mail" and a view with all identifiers >> mentioned >> in the documentation (c_uid, c_user, mail,...) and added some >> information >> to the database. >> >> I created a user "mail" with all rights on the database. >> >> There are two questions i don't understand: >> >> - Does sogo write into the database >> - What excactly does id mean >> >> I would appreciate any help. >> >> Regards, >> >> Carsten Laun-De Lellis >> Dipl.-Ing. Elektrotechnik >> Certified Information Systems Auditor (CISA) >> >> Hauptstrasse 13 >> D-67705 Trippstadt >> >> Phone: +49 (6306) 992140 >> Mobile: +49 (151) 27530865 >> email: [email protected] >> >> >> >> >
-- [email protected] https://inverse.ca/sogo/lists
