Re: [SOGo] Sogo installation on Ubuntu Lucid Lynx: MySQL/LDAP/Postifx/Bind9/Apache Draft
Hi, The draft looks neat, nice stuff ! I wonder though, who'd be the target audience for this ? From what I have gathered browsing the mailing lists is mostly about SOGo's behavior itself, people looking for performance tweaks here and there, functionality enhancements, bugs et al. Having said that though, I think more such contributions could be really of help to the community. Thanks for taking the initiative ! Regards, Mohit Chawla On Tue, Oct 19, 2010 at 5:22 PM, ketzal devims ketzaldev...@gmail.comwrote: Hi all, I made a documentation for the installation/deployement of Sogo for Ubuntu 10.04 Lucid Lynx. This document is in fact the notes I took during the Installation I made on my Server. This is still a draft I need to complete, that's why there are a lot of missing information, but I think this is a good start for a tutorial. Regards Louis -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo installation on Ubuntu Lucid Lynx: MySQL/LDAP/Postifx/Bind9/Apache Draft
louis, thanks for your effort! i do appreciate the document a lot as i am evaulating groupware solutions at the moment for a small office (8 people). currently our favourite server is sogo as we're working with thundebird and lightning. i would like to set up sogo on ubuntu 10.04. as you described. your pdf is a really good start! i would love to see it in the finished version. thanks again. i am looking forward to the pdf update best regards, alex -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo installation on Ubuntu Lucid
On 06/17/2010 01:19 PM, Jason Oster wrote: What's the table schema so I can create it manually? It appears to be defined in: UI/MainUI/SOGoProfile.sql So I created this table manually: sogo= CREATE TABLE sogo_user_profile (c_uid VARCHAR(255) NOT NULL PRIMARY KEY, c_defaults TEXT, c_settings TEXT); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index sogo_user_profile_pkey for table sogo_user_profile CREATE TABLE sogo= \dt List of relations Schema | Name| Type | Owner +---+---+--- public | sogo_user_profile | table | sogo (1 row) And then I restart SOGo. postgres log shows: 2010-06-17 13:18:38 MST STATEMENT: CREATE TABLE sogo_user_profile; 2010-06-17 13:24:10 MST FATAL: database sogo/sogo_user_profile does not exist The CREATE statement was from my manual SQL entry. So there's still no change, here. attachment: jason_oster.vcf-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo installation on Ubuntu Lucid
Jason Oster wrote: It appears to be defined in: UI/MainUI/SOGoProfile.sql So I created this table manually: sogo= CREATE TABLE sogo_user_profile (c_uid VARCHAR(255) NOT NULL PRIMARY KEY, c_defaults TEXT, c_settings TEXT); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index sogo_user_profile_pkey for table sogo_user_profile CREATE TABLE sogo= \dt List of relations Schema | Name| Type | Owner +---+---+--- public | sogo_user_profile | table | sogo (1 row) And then I restart SOGo. postgres log shows: 2010-06-17 13:18:38 MST STATEMENT: CREATE TABLE sogo_user_profile; 2010-06-17 13:24:10 MST FATAL: database sogo/sogo_user_profile does not exist The CREATE statement was from my manual SQL entry. So there's still no change, here. What's the libpq version being used? I guess there might be some changes that break the code in the PostgreSQL adaptor. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo installation on Ubuntu Lucid
Hi, thank you, Roberto for your hints. I experimented with them, but nothing changed. On the psql-commandline there is no problem with the given credentials to log in, create some tables and access them in the database named sogo. I think I'll try to use another daily build, but ... Ralf Roberto schrieb: El 27/05/10 14:16, rpesc...@peschke-it.de escribió: Trying the manual access via psql -h localhost -U sogo -d sogo with passwort sogo everything is okay, except that there are still no tables created in the database. Hi, I never used PostgreSQL, but having access doesn't mean you have table creation rights... [snip] 2010-05-27 17:44:42.649 sogod[3920] could not open channel to sogo/sogo_user_prof...@localhost May 27 17:44:42 sogod: SOGo watchdog [3920]: [ERROR] 0x0x3032670[GCSChannelManager] could not open channel 0x0x2c65670[PostgreSQL72Channel]: not-connected for URL: postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile [snip] Here is SOGo's first complaint... I searched through Google and found a lot of webpages discussing this problem, I think you should give this post [1] a try. After that I would check creation table rights too. [1] http://mail.opengroupware.org/pipermail/sogo/2009-June/002695.html HTH, -- Roberto -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo installation on Ubuntu Lucid
rpesc...@peschke-it.de wrote: Hi, thank you, Roberto for your hints. I experimented with them, but nothing changed. On the psql-commandline there is no problem with the given credentials to log in, create some tables and access them in the database named sogo. I think I'll try to use another daily build, but ... Ralf Hi Ralf, You probably also need to enable identification via tcp in your postgres, which is disabled by default on new installations... Here is what I have in my own pg_hba.conf: hostall all 127.0.0.1/32 md5 -- Wolfgang Sourdeau :: +1 (514) 447-4918 ext. 125 :: wsourd...@inverse.ca Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo installation on Ubuntu Lucid
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Please, could somebody give me a hint, whats going wrong with my SOGo installation? Thank you Ralf rpesc...@peschke-it.de schrieb: I tried to install SOGo 1.2.2 on Ubuntu Lucid, but can't get it running. Accessing SOGo via browser results in the message the called object returned no result in the browser. Th ereason seems to be the missing dispatcher-object, see log. Apache, postgre and sogod are running. First error in sogo-log tells me that the connection to postgre failed, see log below. Trying the manual access via psql -h localhost -U sogo -d sogo with passwort sogo everything is okay, except that there are still no tables created in the database. Any idea, what causes the response? Log: May 27 17:44:42 sogod: SOGo watchdog [3918]: [WARN] 0x0x26f0390[WOWatchDog] 'WOHttpAllowHost' is ignored in watchdog mode, use a real firewall instead May 27 17:44:42 sogod: SOGo watchdog [3918]: 0x0x26f0390[WOWatchDog] listening on *:2 May 27 17:44:42 sogod: SOGo watchdog [3918]: 0x0x26f0390[WOWatchDog] watchdog process pid: 3918 May 27 17:44:42 sogod: SOGo watchdog [3918]: 0x0x26f0390[WOWatchDog] preparing 1 children May 27 17:44:42 sogod: SOGo watchdog [3918]: 0x0x26f0390[WOWatchDog] child spawned with pid 3920 May 27 17:44:42 sogod: SOGo watchdog [3920]: SNS support disabled. May 27 17:44:42 sogod: SOGo watchdog [3920]: 0x0x2a80980[SOGoProductLoader] SOGo products loaded from '/usr/lib/GNUstep/SOGo': May 27 17:44:42 sogod: SOGo watchdog [3920]: 0x0x2a80980[SOGoProductLoader] CommonUI.SOGo, Appointments.SOGo, MailerUI.SOGo, MainUI.SOGo, SchedulerUI.SOGo, ContactsUI.SOGo, Mailer.SOGo, MailPartViewers.SOGo, AdministrationUI.SOGo, Contacts.SOGo, PreferencesUI.SOGo May 27 17:44:42 sogod: SOGo watchdog [3920]: |SOGo| version 1.2.2 (build @vizzini.inverse.ca 201005221106) -- starting May 27 17:44:42 sogod: SOGo watchdog [3920]: |SOGo| vmem size check enabled: shutting down app when vmem 384 MB 2010-05-27 17:44:42.649 sogod[3920] could not open channel to sogo/sogo_user_prof...@localhost May 27 17:44:42 sogod: SOGo watchdog [3920]: [ERROR] 0x0x3032670[GCSChannelManager] could not open channel 0x0x2c65670[PostgreSQL72Channel]: not-connected for URL: postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile May 27 17:44:42 sogod: SOGo watchdog [3920]: [WARN] 0x0x3032670[GCSChannelManager] will prevent opening of this channel 5 seconds after 2010-05-27 17:44:42 +0200 May 27 17:59:21 sogod: SOGo watchdog [3920]: 0x0x3541fd0[SOGoCache] Cache cleanup interval set every 300.00 seconds May 27 17:59:21 sogod: SOGo watchdog [3920]: 0x0x3541fd0[SOGoCache] Using host(s) 'localhost' as server(s) 2010-05-27 17:59:21.971 sogod[3920] Note(SoObject): SoDebugKeyLookup is enabled! 2010-05-27 17:59:21.971 sogod[3920] Note(SoObject): SoDebugBaseURL is enabled! 2010-05-27 17:59:21.971 sogod[3920] Note(SoObject): relative base URLs are enabled. May 27 17:59:21 sogod: SOGo watchdog [3920]: [ERROR] [object-handler] did not find dispatcher class ''SoObjectMethodDispatcher'; fallback' 127.0.0.1 - - [27/May/2010:17:59:21 GMT] GET /SOGo HTTP/1.1 500 36/0 0.018 - - 312K May 27 17:59:23 sogod: SOGo watchdog [3920]: [ERROR] [object-handler] did not find dispatcher class ''SoObjectMethodDispatcher'; fallback' 127.0.0.1 - - [27/May/2010:17:59:23 GMT] GET /SOGo HTTP/1.1 500 36/0 0.006 - - 0 and my .GNUstepDefaults: { NSGlobalDomain = { }; gdnc = { }; sogod = { NGUseUTF8AsURLEncoding = YES; OCSFolderInfoURL = postgresql://sogo:s...@localhost:5432/sogo/sogo_folder_info; SOGoACLsSendEMailNotifications = YES; SOGoAppointmentSendEMailNotifications = YES; SOGoAuthenticationMethod = LDAP; SOGoDraftsFolderName = Entw\U00FCrfe; SOGoFoldersSendEMailNotifications = YES; SOGoIMAPServer = 10.0.1.6; SOGoLanguage = German; SOGoMailDomain = osics.de; SOGoMailingMechanism = smtp; SOGoProfileURL = postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile; SOGoSMTPServer = 10.0.1.6; SOGoSentFolderName = Versendet; SOGoTimeZone = Europe/Berlin; SOGoTrashFolderName = Papierkorb; SOGoUserSources = ( { CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; MailFieldNames = (mail); baseDN = ou=Benutzer,dc=osics,dc=de; bindDN = cn=osicsadmin,dc=osics,dc=de; bindFields = uid; bindPassword = secretPW; canAuthenticate = YES; displayName = LDAP Benutzer; filter = (objectClass=inetOrgPerson); hostname = ldap; id = shared; isAddressBook = YES; port = 389; } ); WOMessageUseUTF8 = YES; WOParsersUseUTF8 = YES; WOPort = 2; WOUseRelativeURLs = NO; WOLogFile = /var/log/sogo/sogo.log; }; } -BEGIN PGP SIGNATURE- Version: GnuPG
Re: [SOGo] SOGo installation on Ubuntu Lucid
El 27/05/10 14:16, rpesc...@peschke-it.de escribió: Trying the manual access via psql -h localhost -U sogo -d sogo with passwort sogo everything is okay, except that there are still no tables created in the database. Hi, I never used PostgreSQL, but having access doesn't mean you have table creation rights... [snip] 2010-05-27 17:44:42.649 sogod[3920] could not open channel to sogo/sogo_user_prof...@localhost May 27 17:44:42 sogod: SOGo watchdog [3920]: [ERROR] 0x0x3032670[GCSChannelManager] could not open channel 0x0x2c65670[PostgreSQL72Channel]: not-connected for URL: postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile [snip] Here is SOGo's first complaint... I searched through Google and found a lot of webpages discussing this problem, I think you should give this post [1] a try. After that I would check creation table rights too. [1] http://mail.opengroupware.org/pipermail/sogo/2009-June/002695.html HTH, -- Roberto -- users@sogo.nu https://inverse.ca/sogo/lists