Am 02.03.2016 um 12:26 schrieb Dominique:
> On 02/03/2016 09:21, Christian Mack wrote:
>> 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
>>
> No. I did not move the 'mysql' database. The receiving server already
> has other programs installed with mysql back-end. I cannot just dump the
> existing one and replace it with the old ones. Any specific table
> entries that needs to be moved ?
> Then you need to add the user "sogo"@"localhost" with the password from your sogo.conf and all privileges on the database "sogo". 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
