Re: [SOGo] SOGo installation in Ubuntu, pubkey problems

[Marco Moock]

Am 13.04.2023 schrieb "Jose David Bravo A"
(jbr...@colombiahosting.com.co) :

> sudo wget -O-
> "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; |
> sudo gpg --dearmor | sudo apt-key add - sudo wget -O-
> "https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9;
> | sudo gpg --dearmor | sudo apt-key add - sudo apt-get update" 

apt-key is deprecated and not supported anymore.

Use
sudo wget -O- "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; 
|sudo gpg --dearmor |sudo tee /etc/apt/trusted.gpg.d/sogo.gpg

Re: [SOGo] SOGo installation in Ubuntu, pubkey problems

[Gary Horchem]

I used SOGo’s guide and it worked for now but Ubuntu will change it in the 
future. My only issue is I can’t get a connection to my MySQL database running 
on the same box. I’ve done the database configuration for Utf8mb4 and the 
database is listening on localhost but it still won’t connect.

Sent from my iPhone

> On Apr 13, 2023, at 17:05, Jose David Bravo A  wrote:
> 
> 
> Hello,
> 
> Im wondering how are you guys importing the public key of SOGo repos in 
> Ubuntu.
> 
> Following this guide 
> (https://www.sogo.nu/support/faq/how-to-install-sogo-on-ubuntu.html), I 
> always find problems:
>  
> "Alinto signs its Ubuntu packages with its GPG key. Integrity verification 
> happens all by itself on package installation, all you need to do is first 
> import the key into your apt keychain then update your local apt 
> configuration:
> 
> sudo wget -O- 
> "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; | sudo gpg 
> --dearmor | sudo apt-key add -
> sudo wget -O- 
> "https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9;
>  | sudo gpg --dearmor | sudo apt-key add -
> sudo apt-get update"
> 
> 
> Requests to http://pgp.mit.edu/ fails very often:
> sudo wget -O- 
> "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; | sudo gpg 
> --dearmor | sudo apt-key add -
> --2023-04-13 20:42:49--  
> http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C
> Resolving pgp.mit.edu (pgp.mit.edu)... 18.9.60.141
> Connecting to pgp.mit.edu (pgp.mit.edu)|18.9.60.141|:80... Warning: apt-key 
> is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
> connected.
> HTTP request sent, awaiting response... 408 Request Timeout
> 2023-04-13 20:44:26 ERROR 408: Request Timeout.
> 
> gpg: no valid OpenPGP data found.
> gpg: no valid OpenPGP data found.
> 
> 
> And using sudo wget -O- 
> "https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9;
>  | sudo gpg --dearmor | sudo apt-key add -
> I receive this warning: W: 
> https://packages.sogo.nu/nightly/5/ubuntu/dists/jammy/InRelease: Key is 
> stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the 
> DEPRECATION section in apt-key(8) for details.
> 
> I'm using Ubuntu Jammy.
> 
> Thank you!
> 
> Jose Bravo

[SOGo] SOGo installation in Ubuntu, pubkey problems

[Jose David Bravo A]

Hello, 

Im wondering how are you guys importing the public key of SOGo repos in Ubuntu. 

Following this guide ( [ 
https://www.sogo.nu/support/faq/how-to-install-sogo-on-ubuntu.html | 
https://www.sogo.nu/support/faq/how-to-install-sogo-on-ubuntu.html ] ), I 
always find problems: 
"Alinto signs its Ubuntu packages with its GPG key. Integrity verification 
happens all by itself on package installation, all you need to do is first 
import the key into your apt keychain then update your local apt configuration: 

sudo wget -O- "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; 
| sudo gpg --dearmor | sudo apt-key add - 
sudo wget -O- 
"https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9;
 | sudo gpg --dearmor | sudo apt-key add - 
sudo apt-get update" 


Requests to [ http://pgp.mit.edu/ | http://pgp.mit.edu/ ] fails very often: 
sudo wget -O- "http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C; 
| sudo gpg --dearmor | sudo apt-key add - 
--2023-04-13 20:42:49-- 
http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C 
Resolving pgp.mit.edu (pgp.mit.edu)... 18.9.60.141 
Connecting to pgp.mit.edu (pgp.mit.edu)|18.9.60.141|:80... Warning: apt-key is 
deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)). 
connected. 
HTTP request sent, awaiting response... 408 Request Timeout 
2023-04-13 20:44:26 ERROR 408: Request Timeout. 

gpg: no valid OpenPGP data found. 
gpg: no valid OpenPGP data found. 


And using sudo wget -O- 
"https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9;
 | sudo gpg --dearmor | sudo apt-key add - 
I receive this warning: W: 
https://packages.sogo.nu/nightly/5/ubuntu/dists/jammy/InRelease: Key is stored 
in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION 
section in apt-key(8) for details. 

I'm using Ubuntu Jammy. 

Thank you! 

Jose Bravo 

Re: [SOGo] SOGO Installation on Plesk

["Christian M. Jensen"]

Hi Luca.

Just tested and your right, SOGo needs the password. hmm

In that case you may need a support contract with SOGo for this to be 
solved, unless you or some else one can develop and contribute support 
for AES-256-CBC auth, or some other workaround.


in any case, i can't think of any other way.

On 15-07-2019 16:44, Luca Müller (lucamueller...@gmail.com) wrote:

Hey Christian,

Thank you for your reply.
This is our current sogo.conf File:


{
  SOGoTimeZone = Europe/Berlin;
  SOGoMailDomain = http://sr65.firestorm.ch/SOgo/;
  SOGoLanguage = English;
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoFoldersSendEMailNotifications = YES;
  SOGoACLsSendEMailNotifications = YES;
  SOGoCalendarDefaultRoles = ("PublicViewer","ConfidentialDAndTViewer");
  SOGoUserSources = ({
    //canAuthenticate = YES;
    displayName = "SOGo Users";
    id = users;
    isAddressBook = YES;
    type = sql;
    userPasswordAlgorithm = md5;
    viewURL = 
"mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_users 
";

  });
  SOGoMailingMechanism = smtp;
  SOGoSMTPServer = localhost;
  SOGoIMAPServer = imaps://localhost:993;
  SOGoMemcachedHost = 127.0.0.1;
  SOGoEnableEMailAlarms = No;
  SOGoProfileURL = 
"mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_user_profile 
";
  OCSFolderInfoURL = 
"mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_folder_info 
";
  OCSSessionsFolderURL = 
"mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_sessions_folder 
";
  OCSEMailAlarmsFolderURL = 
"mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_alarms_folder 
";


  SOGoPageTitle = "SOGo WebMailer";
  SOGoMailAuxiliaryUserAccountsEnabled = NO;
  SOGoFirstDayOfWeek = 1;
  SOGoMailComposeMessageType = html;

  SOGoDraftsFolderName = Drafts;
  SOGoSentFolderName = Sent;
  SOGoTrashFolderName = Trash;

  SxVMemLimit = 4096;
  SOGoDebugRequests = YES;
  SOGoEASDebugEnabled = YES;
  ImapDebugEnabled = YES;
    //LDAPDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
    //PGDebugEnabled = YES;
  WOPort = 2;
  SOGoForceExternalLoginWithEmail = YES;
}


 On our Plesk Server i've created a test user and tried to login. But 
it failed without a Error Message:
Jul 15 16:41:20 sogod [2711]: |SOGo| starting method 'POST' on uri 
'/SOGo/connect'
Jul 15 16:41:20 sogod [2711]: SOGoRootPage Login from '46.140.230.170' 
for user 't...@tst.tld' might not have worked - password policy: 65535 
 grace: -1  expire: -1  bound: 0
Jul 15 16:41:20 sogod [2711]: |SOGo| request took 0.004622 seconds to 
execute
Jul 15 16:41:20 sogod [2711]: 46.140.230.170 "POST /SOGo/connect 
HTTP/1.1" 403 34/67 0.009 - - 0



Next i've inserted the same username and password into the Table 
'sogo_users'.
So IMAP and the Database had the exact same password. Then i was able 
to login using this user Account.
However in Plesk we can't get the hashed or plain password of our 
users. So filling all these Credentials into a database is not possible.

We need a IMAP only auth.

Bests,
Luca

--
users@sogo.nu
https://inverse.ca/sogo/lists


--
Hilsen/Regards
Christian M. Jensen

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGO Installation on Plesk

[lucamueller...@gmail.com]

Hey Christian,

Thank you for your reply.
This is our current sogo.conf File:


{
  SOGoTimeZone = Europe/Berlin;
  SOGoMailDomain = http://sr65.firestorm.ch/SOgo/;
  SOGoLanguage = English;
  SOGoAppointmentSendEMailNotifications = YES;
  SOGoFoldersSendEMailNotifications = YES;
  SOGoACLsSendEMailNotifications = YES;
  SOGoCalendarDefaultRoles = ("PublicViewer","ConfidentialDAndTViewer");
  SOGoUserSources = ({
//canAuthenticate = YES;
displayName = "SOGo Users";
id = users;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL = "mysql://sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_users";
  });
  SOGoMailingMechanism = smtp;
  SOGoSMTPServer = localhost;
  SOGoIMAPServer = imaps://localhost:993;
  SOGoMemcachedHost = 127.0.0.1;
  SOGoEnableEMailAlarms = No;
  SOGoProfileURL = "mysql://
sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_user_profile";
  OCSFolderInfoURL = "mysql://
sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_folder_info";
  OCSSessionsFolderURL = "mysql://
sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_sessions_folder";
  OCSEMailAlarmsFolderURL = "mysql://
sogo:WDUg19g91eg9e@127.0.0.1:3306/sogo/sogo_alarms_folder";

  SOGoPageTitle = "SOGo WebMailer";
  SOGoMailAuxiliaryUserAccountsEnabled = NO;
  SOGoFirstDayOfWeek = 1;
  SOGoMailComposeMessageType = html;

  SOGoDraftsFolderName = Drafts;
  SOGoSentFolderName = Sent;
  SOGoTrashFolderName = Trash;

  SxVMemLimit = 4096;
  SOGoDebugRequests = YES;
  SOGoEASDebugEnabled = YES;
  ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
//PGDebugEnabled = YES;
  WOPort = 2;
  SOGoForceExternalLoginWithEmail = YES;
}


 On our Plesk Server i've created a test user and tried to login. But it
failed without a Error Message:
Jul 15 16:41:20 sogod [2711]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'
Jul 15 16:41:20 sogod [2711]: SOGoRootPage Login from '46.140.230.170' for
user 't...@tst.tld' might not have worked - password policy: 65535  grace:
-1  expire: -1  bound: 0
Jul 15 16:41:20 sogod [2711]: |SOGo| request took 0.004622 seconds to
execute
Jul 15 16:41:20 sogod [2711]: 46.140.230.170 "POST /SOGo/connect HTTP/1.1"
403 34/67 0.009 - - 0


Next i've inserted the same username and password into the Table
'sogo_users'.
So IMAP and the Database had the exact same password. Then i was able to
login using this user Account.
However in Plesk we can't get the hashed or plain password of our users. So
filling all these Credentials into a database is not possible.
We need a IMAP only auth.

Bests,
Luca

Am Fr., 12. Juli 2019 um 15:59 Uhr schrieb "Christian M. Jensen" <
users@sogo.nu>:

> Hi.
>
> When you try to login what is shown in the logs.
>
> If i remember correctly for authentication you just need to have view with
> users that are allowed to use SOGo and a working imap server, SOGo sends
> the authentication to the imap server and that is where the password is
> validated happens.
>
> Also the option 'userPasswordAlgorithm' in SOGo (according to the doc and
> my own findings) only has effect if i want to change the password from
> within SOGo, so that should not be an issue. i use sha512 and changing that
> option to plain has no effect on authentication at least for me.
> On 12-07-2019 13:31, Luca Müller (lucamueller...@gmail.com) wrote:
>
> Hello,
>
> We're trying to install SOGO on our Plesk Onyx 17.8.11 Server.
> The installation of SOGO itsself was successful. We're able to open SOGO
> Webmail using domain.tld/SOgo. However we have some trouble in choosing the
> correct Authentication method. On Plesk we use dovecot & postfix. In the
> Plesk Database there's the Users password. However it's not hashed with any
> of the supported Hashing Algorithms. The Mail-Password is encrypted using 
> "AES-256-CBC".
> Since there's only the option to use a Database or LDAP we can't login to
> the webmail. Has anyone ever tried to setup Sogo with Plesk ? Are there any
> tutorials (i couldn't fine one). Or does anyone know another option how the
> authentification could work ?
> Thanks in advance.
> Best regards,
> Luca
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
> --
> Hilsen/Regards
> Christian M. Jensen
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGO Installation on Plesk

["Christian M. Jensen"]

Hi.

When you try to login what is shown in the logs.

If i remember correctly for authentication you just need to have view 
with users that are allowed to use SOGo and a working imap server, SOGo 
sends the authentication to the imap server and that is where the 
password is validated happens.


Also the option 'userPasswordAlgorithm' in SOGo (according to the doc 
and my own findings) only has effect if i want to change the password 
from within SOGo, so that should not be an issue. i use sha512 and 
changing that option to plain has no effect on authentication at least 
for me.


On 12-07-2019 13:31, Luca Müller (lucamueller...@gmail.com) wrote:

Hello,

We're trying to install SOGO on our Plesk Onyx 17.8.11 Server.
The installation of SOGO itsself was successful. We're able to open 
SOGO Webmail using domain.tld/SOgo. However we have some trouble in 
choosing the correct Authentication method. On Plesk we use dovecot & 
postfix. In the Plesk Database there's the Users password. However 
it's not hashed with any of the supported Hashing Algorithms. The 
Mail-Password is encrypted using "AES-256-CBC". Since there's only the 
option to use a Database or LDAP we can't login to the webmail. Has 
anyone ever tried to setup Sogo with Plesk ? Are there any tutorials 
(i couldn't fine one). Or does anyone know another option how the 
authentification could work ?

Thanks in advance.
Best regards,
Luca
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
Hilsen/Regards
Christian M. Jensen

--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGO Installation on Plesk

[lucamueller...@gmail.com]

Hello,

We're trying to install SOGO on our Plesk Onyx 17.8.11 Server.
The installation of SOGO itsself was successful. We're able to open SOGO
Webmail using domain.tld/SOgo. However we have some trouble in choosing the
correct Authentication method. On Plesk we use dovecot & postfix. In the
Plesk Database there's the Users password. However it's not hashed with any
of the supported Hashing Algorithms. The Mail-Password is encrypted
using "AES-256-CBC".
Since there's only the option to use a Database or LDAP we can't login to
the webmail. Has anyone ever tried to setup Sogo with Plesk ? Are there any
tutorials (i couldn't fine one). Or does anyone know another option how the
authentification could work ?

Thanks in advance.
Best regards,
Luca
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo installation with Apache2

[Martin Simovic]

> On 20 Oct 2015, at 17:25, Michael Angelozzi  wrote:
> 
> Hi All,
> 
> Firstly, what does SOGo stand for? I have googled intensively and only come 
> up with Society Of  Gas Operators, which I am i sure it does not stand for.
> My guess would be: Super Openexchange Groupware O???

Scalable Open Groupware.

> 
> So I am trying to install SOGo on Ubuntu server 14.04.
> 
> I installed Apache2 which used to serve up a very simple page (as you will 
> see below it is now broken).
> I installed mysql-server.
> I installed Postfix with Dovecot using: sudo apt-get -y install 
> mail-stack-delivery
> I did not install OpenLDAP because at the moment there is just myself in my 
> company. I would rather use a the MySQL database to store the users.
> 
> Then I installed SOGo, and I noticed towards the end of the installation 
> Apache2 fell over:
> Setting up sogo:amd64 (2.3.2-1) ...
> apache2_invoke: Enable configuration SOGo
> Action 'configtest' failed.
> The Apache error log may have more information.
> apache2_reload: Your configuration is broken. Not reloading Apache 2
>  * Starting SOGo sogo [ 
> OK ]
> 
> I checked the Apache log and there was nothing helpful.
> 
> This is what is in the SOGo conf file:
> sudo nano /etc/apache2/conf-enabled/SOGo.conf 
> shows:
> Line 47: ProxyRequests Off
> Line 48: SetEnv proxy-nokeepalive 1
> Line 49: ProxyPreserveHost On
> 
> I ran the following command:
> apachectl configtest
> 
> And got:
> AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/SOGo.conf:
> Invalid command 'ProxyRequests', perhaps misspelled or defined by a module 
> not included in the server configuration
> Action 'configtest' failed.
> So Commented out line 47, because Off is the default value in the Apache 
> documentation anyway.

Rather commenting stuff out you should enable required apache modules 

a2enmod proxy
a2enmod proxy_http
a2enmod headers

> 
> Then I tried again and this time the same error but for line 49:
> AH00526: Syntax error on line 49 of /etc/apache2/conf-enabled/SOGo.conf:
> Invalid command 'ProxyPreserveHost', perhaps misspelled or defined by a 
> module not included in the server configuration
> Action 'configtest' failed.
> 
> I figured it would be unwise to just keep commenting out stuff.
> Any suggestions?
> 
> The SOGO Installation Guide.pdf page 45 says:
> "The SOGo configuration for Apache is located in /etc/httpd/conf.d/SOGo.conf"
> But I dont have a file there?
> 

This is a location for CentOS. On Ubuntu your config file will be somewhere in 
/etc/apache2/conf-available or /etc/apache2/conf.d/

Regards
Martin.



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] SOGo installation with Apache2

[Michael Angelozzi]

Hi All,

Firstly, what does SOGo stand for? I have googled intensively and only come
up with Society Of  Gas Operators, which I am i sure it does not stand for.
My guess would be: Super Openexchange Groupware O???

So I am trying to install SOGo on Ubuntu server 14.04.

I installed Apache2 which used to serve up a very simple page (as you will
see below it is now broken).
I installed mysql-server.
I installed Postfix with Dovecot using: sudo apt-get -y install
mail-stack-delivery
I did not install OpenLDAP because at the moment there is just myself in my
company. I would rather use a the MySQL database to store the users.

Then I installed SOGo, and I noticed towards the end of the installation
Apache2 fell over:
Setting up sogo:amd64 (2.3.2-1) ...
apache2_invoke: Enable configuration SOGo
Action 'configtest' failed.
The Apache error log may have more information.
apache2_reload: Your configuration is broken. Not reloading Apache 2
 * Starting SOGo sogo [
OK ]

I checked the Apache log and there was nothing helpful.

This is what is in the SOGo conf file:
sudo nano /etc/apache2/conf-enabled/SOGo.conf
shows:
Line 47: ProxyRequests Off
Line 48: SetEnv proxy-nokeepalive 1
Line 49: ProxyPreserveHost On

I ran the following command:
apachectl configtest

And got:
AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyRequests', perhaps misspelled or defined by a module
not included in the server configuration
Action 'configtest' failed.
So Commented out line 47, because Off is the default value in the Apache
documentation anyway.

Then I tried again and this time the same error but for line 49:
AH00526: Syntax error on line 49 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyPreserveHost', perhaps misspelled or defined by a
module not included in the server configuration
Action 'configtest' failed.

I figured it would be unwise to just keep commenting out stuff.
Any suggestions?

The SOGO Installation Guide.pdf page 45 says:
*"The SOGo configuration for Apache is located in
/etc/httpd/conf.d/SOGo.conf"*
But I dont have a file there?

Not sure how to proceed.

Kind Regards
Michael
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo installation with Apache2

[Per Jessen]

Michael Angelozzi wrote:

> Hi All,
> 
> Firstly, what does SOGo stand for? 

Scalable Open Groupware.org I believe. 

> So I am trying to install SOGo on Ubuntu server 14.04.
> 
> I installed Apache2 which used to serve up a very simple page (as you
> will see below it is now broken).
> I installed mysql-server.
> I installed Postfix with Dovecot using: sudo apt-get -y install
> mail-stack-delivery
> I did not install OpenLDAP because at the moment there is just myself
> in my company. I would rather use a the MySQL database to store the
> users.

Very similar to my setup. 

> And got:
> AH00526: Syntax error on line 47 of
> /etc/apache2/conf-enabled/SOGo.conf: Invalid command 'ProxyRequests',
> perhaps misspelled or defined by a module not included in the server

You need to include the proxy module in your apache installation. 

a2enmod proxy proxy_http

(from memory).


-- 
Per Jessen, Zürich (9.2°C)
http://www.hostsuisse.com/ - virtual servers, made in Switzerland.

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo installation with Apache2

[Chris Coleman]

What does the SOGo acronym stand for?

*OGo = O*pen*G*roupware.*o*rg
http://www.opengroupware.org/en/about/index.html

"MDlink GmbH, the original author of the OpenGroupware.org reference 
server, was founded as an Internet service provider (ISP) in Germany in 
1994. The company started development on the LSOffice application server 
in about 1996 to extend it's Internet offerings with a powerful 
collaboration platform usable over the Internet.


Some years later LSOffice was renamed to SKYRiX 3 and finally in 2000 a 
separate company, SKYRIX Software AG , was 
forked to concentrate on the further development of the product.


The SKYRiX Groupware Server is certainly one of the earliest GNU/Linux 
based groupware solutions (being now, in [2015], about [nineteen] years 
old).


The OpenGroupware.org source code initially includes the technology 
SKYRIX Software AG  has been developing for the 
future versions of the SKYRiX groupware server. *The source is mainly 
written in Objective-C and delivers language-neutral and scriptable 
functionality, including XML interfaces.*


/Differences between OpenGroupware.org and SKYRiX/

Starting with the launch of OpenGroupware.org, SKYRiX becomes an 
enterprise *distribution* of the OpenGroupware.org software. That is, 
SKYRiX is a maintained selection of stable parts of the OGo sources.
The SKYRiX distribution also includes some additional software which is 
not available as part of the OpenGroupware.org project, like:


 * Application Level Load Balancer (snsd)
 * Various other SKYRiX 5 User Interface Themes
 * Support for Oracle and Sybase databases
 * CTI Support for CSTA based telephone switches
 * Outlook Support for ZideStore"


*SOGo = S*calable*O*pen*G*roupware.*o*rg
http://www.scalableogo.org/
http://www.sogo.nu/
Developed today by inverse (Canada).
SOGo uses OpenChange to provide native Outlook/Exchange protocol 
compatibility, which is developed by Zentyal (Spain).





On 10/20/2015 11:25 AM, Michael Angelozzi wrote:

Hi All,

Firstly, what does SOGo stand for? I have googled intensively and only 
come up with Society Of  Gas Operators, which I am i sure it does not 
stand for.

My guess would be: Super Openexchange Groupware O???

So I am trying to install SOGo on Ubuntu server 14.04.

I installed Apache2 which used to serve up a very simple page (as you 
will see below it is now broken).

I installed mysql-server.
I installed Postfix with Dovecot using: sudo apt-get -y install 
mail-stack-delivery
I did not install OpenLDAP because at the moment there is just myself 
in my company. I would rather use a the MySQL database to store the users.


Then I installed SOGo, and I noticed towards the end of the 
installation Apache2 fell over:

Setting up sogo:amd64 (2.3.2-1) ...
apache2_invoke: Enable configuration SOGo
Action 'configtest' failed.
The Apache error log may have more information.
apache2_reload: Your configuration is broken. Not reloading Apache 2
 * Starting SOGo 
sogo [ OK ]*

*
I checked the Apache log and there was nothing helpful.

This is what is in the SOGo conf file:
sudo nano /etc/apache2/conf-enabled/SOGo.conf
shows:
Line 47: ProxyRequests Off
Line 48: SetEnv proxy-nokeepalive 1
Line 49: ProxyPreserveHost On

I ran the following command:
apachectl configtest

And got:
AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyRequests', perhaps misspelled or defined by a 
module not included in the server configuration

Action 'configtest' failed.
So Commented out line 47, because Off is the default value in the 
Apache documentation anyway.


Then I tried again and this time the same error but for line 49:
AH00526: Syntax error on line 49 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyPreserveHost', perhaps misspelled or defined by 
a module not included in the server configuration

Action 'configtest' failed.

I figured it would be unwise to just keep commenting out stuff.
Any suggestions?

The SOGO Installation Guide.pdf page 45 says:
/"The SOGo configuration for Apache is located in 
/etc/httpd/conf.d/SOGo.conf"/

But I dont have a file there?

Not sure how to proceed.

Kind Regards
Michael


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo installation with Apache2

[Michael Angelozzi]

Thanks Martin Simovic for answering all my questions!

Thanks Chris Coleman for the history of SOGo and SKYRiX, it was interesting.
SOGo certainly looks like an awesome piece of software!

And finally thanks to Per Jessen, and yes your memory serves you correctly
(impressive)!


On 20 October 2015 at 18:11, Per Jessen  wrote:

> Michael Angelozzi wrote:
>
> > Hi All,
> >
> > Firstly, what does SOGo stand for?
>
> Scalable Open Groupware.org I believe.
>
> > So I am trying to install SOGo on Ubuntu server 14.04.
> >
> > I installed Apache2 which used to serve up a very simple page (as you
> > will see below it is now broken).
> > I installed mysql-server.
> > I installed Postfix with Dovecot using: sudo apt-get -y install
> > mail-stack-delivery
> > I did not install OpenLDAP because at the moment there is just myself
> > in my company. I would rather use a the MySQL database to store the
> > users.
>
> Very similar to my setup.
>
> > And got:
> > AH00526: Syntax error on line 47 of
> > /etc/apache2/conf-enabled/SOGo.conf: Invalid command 'ProxyRequests',
> > perhaps misspelled or defined by a module not included in the server
>
> You need to include the proxy module in your apache installation.
>
> a2enmod proxy proxy_http
>
> (from memory).
>
>
> --
> Per Jessen, Zürich (9.2°C)
> http://www.hostsuisse.com/ - virtual servers, made in Switzerland.
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo installation manual for version 2.2.9

[Götz Reinicke - IT Koordinator]

Hi,
Am 21.09.15 um 20:11 schrieb Paul van der Vlis:
> Hello,
> 
> I am looking for the Sogo installation manual for version 2.2.9, that's
> the version shipped with Debian.

are you starting from scratch with SOGo? Or what is the reason you like
to go with 2.2.9?

I'd suggest go with a more recent version as a lot of bugs are fixed
over time ... current V2.2 is 2.2.17a

But 2.3.x is what I'd take.

Regards . Götz



-- 
Götz Reinicke
IT-Koordinator

Tel. +49 7141 969 82420
E-Mail goetz.reini...@filmakademie.de

Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de

Eintragung Amtsgericht Stuttgart HRB 205016

Vorsitzender des Aufsichtsrats: Jürgen Walter MdL
Staatssekretär im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg

Geschäftsführer: Prof. Thomas Schadt



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] sogo installation on Ubuntu Trusty

[hellermann]

Dear sogo developers,

I'm trying to implement  a sogo - openchange installation, but often fail on
serveral steps in the published manuals for doing so.

E.g. the SOGo - Installation and Configuration Guide (PDF) from your website
is identical with the SOGo Native Microsoft Outlook Configuration.pdf .

Also certain commands like openchange_provision don't work at all, allthough
openchange has been installed from the Ubuntu repositorys (ok it's
experimental, i know).

When i tried to install openchange from scratch by compiling the latest
version (including Samba 4.1.11) I had to find out, that certain git hubs are
not available, neither on samba,org nor git clone
https://github.com/openchange/openchange.git.

This becomes a little frustrating, and i hope you can work together with the
openchange developers, to get these problems fixed.

In the meanwhile I'd like to know, if there is an installation support
available, so I can finally have a working edition of openchange and sogo in
my testing environment.

With kind regards, Jens H. / Berlin.

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo installation on Ubuntu Trusty

[Ludovic Marcotte]

On 2014-09-12, 9:11 AM, hellerm...@we-do.com wrote:
 E.g. the SOGo - Installation and Configuration Guide (PDF) from your website
 is identical with the SOGo Native Microsoft Outlook Configuration.pdf .

Trusty isn't mentioned in that guide so that is why it doesn't work.

Up-to-date packages for the native Outlook compatibility will be
available for Trusty in the upcoming v2.2.9 release.

-- 
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo installation on Ubuntu Trusty

[Martin Simovic]

On 12 Sep 2014, at 15:15, Ludovic Marcotte lmarco...@inverse.ca wrote:

 On 2014-09-12, 9:11 AM, hellerm...@we-do.com wrote:
 E.g. the SOGo - Installation and Configuration Guide (PDF) from your website
 is identical with the SOGo Native Microsoft Outlook Configuration.pdf .
 
 Trusty isn't mentioned in that guide so that is why it doesn't work.
 
 Up-to-date packages for the native Outlook compatibility will be
 available for Trusty in the upcoming v2.2.9 release.
 

I assume updated samba / openchange packages will be available for 12.04 too?

Thanks and Best Regards

Martin.

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo installation on Ubuntu Trusty

[Steve Ankeny]

Ludovic announced yesterday . . .

SOGo v2.2.9 should be released in the next 2-3 weeks. It'll have the 
following enhancements:


 * Up-to-date Samba/OpenChange versions and packages


On 09/12/2014 09:11 AM, hellerm...@we-do.com wrote:

Dear sogo developers,

I'm trying to implement  a sogo - openchange installation, but often fail on
serveral steps in the published manuals for doing so.

E.g. the SOGo - Installation and Configuration Guide (PDF) from your website
is identical with the SOGo Native Microsoft Outlook Configuration.pdf .

Also certain commands like openchange_provision don't work at all, allthough
openchange has been installed from the Ubuntu repositorys (ok it's
experimental, i know).

When i tried to install openchange from scratch by compiling the latest
version (including Samba 4.1.11) I had to find out, that certain git hubs are
not available, neither on samba,org nor git clone
https://github.com/openchange/openchange.git.

This becomes a little frustrating, and i hope you can work together with the
openchange developers, to get these problems fixed.

In the meanwhile I'd like to know, if there is an installation support
available, so I can finally have a working edition of openchange and sogo in
my testing environment.

With kind regards, Jens H. / Berlin.



--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGo installation Debian

[Karol Pomaski]

Hey,

I have recently installed the SOGo GroupWare on my Debian Squeeze
using apt-get. It got installed correctly and I have changed from the
apache SOGo.conf file fields that I had to change but still it doesn't
work. While entering to mydomain/SOGo it returns me an internal server
error. I have enabled all the modules mod_alias, mod_headers,
mod_proxy and mod_rewrite but still it doesn't work.

Do you know how to fix it? Did I miss something in the configuration?
How about the MySQL deployment it would make it automatically during
the first enter?

Regards,
Karol
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo installation Debian

[Olivier Bitsch]

Hi Karol,

I published a tutorial here, you can check you setup.

http://iabsis.com/EN/article/35/Samba4-and-OpenChange-on-a-Debian-or-Ubuntu-server/

Best regards

Olivier
Le 27 mars 2013 19:53, Karol Pomaski karol.poma...@gmail.com a écrit :

 Hey,

 I have recently installed the SOGo GroupWare on my Debian Squeeze
 using apt-get. It got installed correctly and I have changed from the
 apache SOGo.conf file fields that I had to change but still it doesn't
 work. While entering to mydomain/SOGo it returns me an internal server
 error. I have enabled all the modules mod_alias, mod_headers,
 mod_proxy and mod_rewrite but still it doesn't work.

 Do you know how to fix it? Did I miss something in the configuration?
 How about the MySQL deployment it would make it automatically during
 the first enter?

 Regards,
 Karol
 --
 users@sogo.nu
 https://inverse.ca/sogo/lists

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Sogo installation

[Joms Ariola]

Dear All,

When i try to install sogo i encountered this 

Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
   Requires: libxmlsec1-openssl.so.1
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
   Requires: xmlsec1 = 1.2.6
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
   Requires: xmlsec1-openssl = 1.2.6
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
   Requires: libxmlsec1.so.1
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest


Please help.


Regards,
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo installation

[Donny Brooks]

 
 
 
On Thursday, December 13, 2012 03:41 AM CST, Joms Ariola j...@cladding.com 
wrote: 
 
 Dear All,
 
 When i try to install sogo i encountered this 
 
 Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: libxmlsec1-openssl.so.1
 Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: xmlsec1 = 1.2.6
 Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: xmlsec1-openssl = 1.2.6
 Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: libxmlsec1.so.1
  You could try using --skip-broken to work around the problem
  You could try running: rpm -Va --nofiles --nodigest
 
 
 Please help.
 
 
 Regards,
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists 

I too ran into this problem on our test machine. It is Centos 6.3. I was able 
to upgrade using the --skip-broken option but have not had a chance to test 
functionality yet.

-- 

Donny B. 

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo installation

[Jean Raby]

On 12-12-13 4:41 AM, Joms Ariola wrote:

Dear All,
When i try to install sogo i encountered this
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: libxmlsec1-openssl.so.1
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: xmlsec1 = 1.2.6
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: xmlsec1-openssl = 1.2.6
Error: Package: lasso-2.3.6-1.centos6.i686 (SOGo)
Requires: libxmlsec1.so.1
  You could try using --skip-broken to work around the problem
  You could try running: rpm -Va --nofiles --nodigest
Please help.
Regards,


What version of xmlsec1 do you have on this system? (rpm -q xmlsec1)
Do you use the EPEL repo? xmlsec1-1.2.16 is available there.

--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  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 Lynx: MySQL/LDAP/Postifx/Bind9/Apache Draft

[Mohit Chawla]

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

[alexpfeiffer]

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

[Jason Oster]

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

[Ludovic Marcotte]

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

[rpesc...@peschke-it.de]

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

[Wolfgang Sourdeau]

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

[Ralf Peschke]

-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

[Roberto]

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