[SOGo] Error Accessing DB in split Setup

[Dominique]

Hi,

I am in the process of splitting services between servers, mysql on one
side, SOGo (web) on the other.

But I hit the following error in the new SOGo server:

2016-02-23 17:21:54.657 sogod[6482] ERROR: could not open MySQL4
connection to database 'sogo': Access denied for user 'sogo'@'localhost'
(using password: YES)
Feb 23 17:21:54 sogod [6482]: [ERROR]
<0x0x7fede2352b58[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7fede2745ad8] connection=0x(null)> for
mysql://localhost/sogo/test0001234_acl

Which is kind of weird since in the sogo.conf file, the access is done
for a remote server:

/* Database configuration (mysql:// or postgresql://) */

SOGoProfileURL =
"mysql://sogo:***@domain.tld:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:***@domain.tld:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:***@domain.tld:3306/sogo/sogo_sessions_folder";

The sogo install in the original server works perfectly.
The new install loads correctly, allows a correct login and the mail
section is ok, but nothing on the calendar, address book part (no data
is shown, but the calendar names are loaded - personal and subscribed)

/* SQL authentication */

SOGoUserSources = (
{
canAuthenticate = YES;
displayName = "Shared Addresses";
id = accounts;
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = none;
viewURL = "http://sogo:***@domain.tld:3306/sogo/sogo_view";
}
);

info system:
running the original server: ubuntu 12.04 server + apache2.2 + sogo 2.x
(the last available)
running the new server: ubuntu 14.04 server + apache2.4 + sogo 2.x (the
last available)

Any ideas ?

Thanks,

Dominique

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[Christian Mack]

Post by Dominique
Hi,
I am in the process of splitting services between servers, mysql on one
side, SOGo (web) on the other.
2016-02-23 17:21:54.657 sogod[6482] ERROR: could not open MySQL4
(using password: YES)
Feb 23 17:21:54 sogod [6482]: [ERROR]
<0x0x7fede2352b58[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7fede2745ad8] connection=0x(null)> for
mysql://localhost/sogo/test0001234_acl
Which is kind of weird since in the sogo.conf file, the access is done

< cut >

This is correct.
SOGo/SOPE is storing the database link per user in its user table.
With that you can use different databases as backends for different user
groups.

In order to be able to change databases, without doing database updates,
we used a fake database server name.
That fake name is added in the /etc/hosts file, which can be changed at
any time.

There where several threads in this mailing list because of that.
Please search there first.


Kind regards,
Christian Mack