Am 01.03.2016 um 21:40 schrieb Dominique:
> 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
> Did you also migrate the "mysql" database and restarted mysql afterwards? Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
