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 -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
