General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] database error in sogo.log with remote mysql server config


Chronological Thread 
  • From: "Christian Mack" ( ) < >
  • To:
  • Subject: Re: [SOGo] database error in sogo.log with remote mysql server config
  • Date: Fri, 7 Jul 2017 15:10:18 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca DF74310004FD

Am 16.06.2017 um 16:23 schrieb mj
( ):
> Hi,
>
> We're using a sogo3 test machine, connected to the database on our sogo2
> production server.
>
> This config shows in the following ERROR in sogo.log:
>> 2017-06-16 16:11:53.134 sogod[900] ERROR: could not open MySQL4
>> connection to database 'sogo': Can't connect to local MySQL server
>> through socket '/var/run/mysqld/mysqld.sock' (2)
>> Jun 16 16:11:53 sogod [900]: [ERROR]
>> <0x0x56330c265840[GCSChannelManager]> could not open channel
>> <MySQL4Channel[0x0x56330c5fdce0] connection=0x(null)> for
>> mysql://localhost/sogo/sogotest0013e591e17
>> Jun 16 16:11:53 sogod [900]: [WARN]
>> <0x0x56330c265840[GCSChannelManager]> will prevent opening of this
>> channel 5 seconds after 2017-06-16 16:11:53 +0200
>> Jun 16 16:11:53 sogod [900]: [ERROR] <0x0x56330c609a70[GCSFolder]>
>> could not open storage channel!
>
> The mysql config in sogo.conf looks like this:
>> root@sogo3:/etc/sogo# cat sogo.conf
>> {
>> OCSFolderInfoURL =
>> "mysql://username: :3306/sogo/sogo_folder_info";
>> SOGoProfileURL =
>> "mysql://username: :3306/sogo/sogo_user_profile";
>>
>> OCSSessionsFolderURL =
>> "mysql://username: :3306/sogo/sogo_sessions_folder";
>>
>> OCSEMailAlarmsFolderURL =
>> "mysql://username: :3306/sogo/sogo_alarms_folder";
>>
>
> Things DO work, so I guess it also connects to the correct database
> location, but the error message seems strange..?
>
> MJ

You just experience the downside of sogo storing database informations
in the database itself.

See Tip at
https://sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration


Kind regards,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page