Dominique
9 years ago
Hi,
I have a running SOGo under Ubuntu 12.04 that I want to move to another
server running Ubuntu 14.04.
I installed SOGo into the new server and copied the entire MySQL
database from one server to another - export sql from one side, import
sql on the other server.
The SOGo user is created and allows connection from the cli and can see
all the tables in the SOGo DB
However, from the SOGo interface... nothing. Not able to connect. In the
log, it shows as follow:
2016-03-01 13:33:50.176 sogod[9628] ERROR: could not open MySQL4
connection to database 'sogo': Access denied for user 'sogo'@'localhost'
(using password: YES)
Mar 01 13:33:50 sogod [9628]: [ERROR]
<0x0x7f352f514b58[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7f352f2cbcc8] connection=0x(null)> for
mysql://localhost/sogo/sogo_user_profile
Mar 01 13:33:50 sogod [9628]: [WARN]
<0x0x7f352f514b58[GCSChannelManager]> will prevent opening of this
channel 5 seconds after 2016-03-01 13:33:50 +0100
My config file is as follow - The same config file is working properly
in Ubuntu 12.04:
{
SOGoProfileURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_sessions_folder";
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoIMAPServer = "imap://mail.domain.tld";
SOGoSieveServer = "sieve://mail.domain.tld:4190";
SOGoMailDomain = "domain.tld";
SOGoMailingMechanism = smtp;
SOGoForceIMAPLoginWithEmail = YES;
SOGoUserSources = (
{
canAuthenticate = YES;
displayName = "Shared Addresses";
id = accounts;
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = none;
viewURL = "http://sogo:***@localhost:3306/sogo/sogo_view";
}
);
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoTimeZone = "Europe/Madrid";
SOGoLanguage = SpanishSpain;
SOGoCalendarDefaultRoles = (
PublicViewer,
ConfidentialDAndTViewer
);
WOLogFile = /var/log/sogo/sogo.log;
WOWorkersCount = 10;
SOGoSpecialFoldersInRoot = YES; /* Deprecated ?*/
SOGoAuthenticationMethod = sql; /* Deprecated ?*/
NGImap4DisableIMAP4Pooling = YES; /* Deprecated ?*/
NGUseUTF8AsURLEncoding = YES; /* Deprecated ?*/
/* Email Reminders */
SOGoEnableEMailAlarms = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES; /* Deprecated ?*/
SOGoAppointmentSendEMailNotifications = YES;
OCSEMailAlarmsFolderURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_alarms_folder";
}
Any ideas ?
Thanks,
Dominique
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
I have a running SOGo under Ubuntu 12.04 that I want to move to another
server running Ubuntu 14.04.
I installed SOGo into the new server and copied the entire MySQL
database from one server to another - export sql from one side, import
sql on the other server.
The SOGo user is created and allows connection from the cli and can see
all the tables in the SOGo DB
However, from the SOGo interface... nothing. Not able to connect. In the
log, it shows as follow:
2016-03-01 13:33:50.176 sogod[9628] ERROR: could not open MySQL4
connection to database 'sogo': Access denied for user 'sogo'@'localhost'
(using password: YES)
Mar 01 13:33:50 sogod [9628]: [ERROR]
<0x0x7f352f514b58[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7f352f2cbcc8] connection=0x(null)> for
mysql://localhost/sogo/sogo_user_profile
Mar 01 13:33:50 sogod [9628]: [WARN]
<0x0x7f352f514b58[GCSChannelManager]> will prevent opening of this
channel 5 seconds after 2016-03-01 13:33:50 +0100
My config file is as follow - The same config file is working properly
in Ubuntu 12.04:
{
SOGoProfileURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_sessions_folder";
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoIMAPServer = "imap://mail.domain.tld";
SOGoSieveServer = "sieve://mail.domain.tld:4190";
SOGoMailDomain = "domain.tld";
SOGoMailingMechanism = smtp;
SOGoForceIMAPLoginWithEmail = YES;
SOGoUserSources = (
{
canAuthenticate = YES;
displayName = "Shared Addresses";
id = accounts;
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = none;
viewURL = "http://sogo:***@localhost:3306/sogo/sogo_view";
}
);
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoTimeZone = "Europe/Madrid";
SOGoLanguage = SpanishSpain;
SOGoCalendarDefaultRoles = (
PublicViewer,
ConfidentialDAndTViewer
);
WOLogFile = /var/log/sogo/sogo.log;
WOWorkersCount = 10;
SOGoSpecialFoldersInRoot = YES; /* Deprecated ?*/
SOGoAuthenticationMethod = sql; /* Deprecated ?*/
NGImap4DisableIMAP4Pooling = YES; /* Deprecated ?*/
NGUseUTF8AsURLEncoding = YES; /* Deprecated ?*/
/* Email Reminders */
SOGoEnableEMailAlarms = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES; /* Deprecated ?*/
SOGoAppointmentSendEMailNotifications = YES;
OCSEMailAlarmsFolderURL =
"mysql://sogo:***@localhost:3306/sogo/sogo_alarms_folder";
}
Any ideas ?
Thanks,
Dominique
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
***@sogo.nu
https://inverse.ca/sogo/lists
***@sogo.nu
https://inverse.ca/sogo/lists