Hello Paul Pathiakis
Am 2013-05-07 21:19, schrieb [email protected]: > > I'm assisting some of the people on the port to FreeBSD. I have an incredible > amount of questions but I'm going to limit them to bundled one offs so that I > don't create an unwieldy thread. > Nice. > This one covers sogo.conf location, configuration of the DB/User profiles and > an error generated from a possible misconfiguration. > > I'm on FreeBSD 9.1. > Postgresql 9.2 > I'm attempting to use SOGO 2.0.5 and SOPE. > > 1) I've had to read everything about the sogod process and I, finally, > deduced > from reading that it creates the postgresql tables upon the initial startup. > (Correct?) > Not only on the initial startup. When starting sogod it checks, if the needed/configured tables are there. If not, it will create them. This is handy, when you eg. drop the session table, it will create it anew. I had to do that because of a restore once. > 2) There is a configuration file known as sogo.conf. I believe this to be the > default settings of the sogod process and it's interface to the > protocol/login/pw/host of various services that it will use. (Correct?) > Yes, since 2.0.4 this is the main config file. But you also can use the GNUStep defaults command, which stores its informations in the sogo user directory. > Questions: > > 1) Does the postgresql user sogo need to be created before starting sogod for > the first time? (I would think so.) > Yes, definitely. And you have to create the database sogo and give the sogo db user apropriate privileges on that. > 2) Is there a manual script to create the database tables in postgresql? If > so, where is it locatied? > Never saw such a thing. I think this is not possible at all, because you have 3 tables per user, which will be created when you add a user. So it has to be dynamic at least for those. > 3) Does a system user account with a home directory and login shell required > any longer outside of a UID and GID for the process. (Everything says 'no') > You don't need the login shell, but you need the home directory, because GNUStep uses that. > 4) Where is the sogo.conf file supposed to exist? > In /etc/sogo/ But you can choose if you use it or not, see above. > 5) Is the sogo.conf location hardcoded or does it take the variable from the > GNUstep environment that is sourced upon startup? If so, what is the name of > the variable defining this location? > I don't know, sorry. > 6) I get this error in the /var/log/sogo/sogo.log file: sogod[82779] No value > specified for 'SOGoProfileURL' This makes me believe that it is not > reading > sogo.conf file that I have as in it, I have: > > SOGoProfileURL = "postgresql://sogo:thisisfun@<DB host > IP>:5432/sogo/sogo_user_profile > > OCSFolderInfoURL = "postgresql://sogo:thisisfun@<DB host > IP>:5432/sogo/sogo_folder_info"; > OCSSessionsFolderURL = "postgresql://sogo:thisisfun@<DB host > IP>:5432/sogo/sogo_sessions_folder"; > There is a double quote and a semicolon missing at the end of SOGoProfileURL. Therefore your config is invalid and therfore not used. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- [email protected] https://inverse.ca/sogo/lists
