On 01/03/2016 15:56, Christian Mack wrote:
Am 01.03.2016 um 14:06 schrieb Dominique:
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:sogo@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo: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: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:sogo@localhost:3306/sogo/sogo_alarms_folder";
}
Any ideas ?
Did you export your mysql database in UTF-8?
The newer mysql versions create their tables with UTF-8 as default
character set.
Kind regards,
Christian Mack
The database was exported to UTF8, but most of the tables where in
latin1. After reloading the original data I converted all tables to
UTF-8. No change. sogo.log still rejects the connection:
2016-03-01 21:08:46.694 sogod[9168] ERROR: could not open MySQL4
connection to database 'sogo': Access denied for user 'sogo'@'localhost'
(using password: YES)
Mar 01 21:08:46 sogod [9168]: [ERROR]
<0x0x7f67af8d9b58[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7f67afc190a8] connection=0x(null)> for
http://localhost/sogo/sogo_view
Dominique
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
[email protected]
https://inverse.ca/sogo/lists
