Hi, this is only one half of the necessary steps: have you changed the bind-address in your mysqld.cnf from
bind-address=127.0.0.1 to bind-address=0.0.0.0 to allow external connections? You can try to connect locally via the ip of the server instead of localhost to test this. Ah, and if you are using iptables on the database server (which you really should) check this too. Bye, Peter Von: [email protected] <[email protected]> Im Auftrag von HYVERNAT Philippe Gesendet: Montag, 18. Juli 2022 13:23 An: [email protected] Betreff: Re: [SOGo] - Error memcached Hi, The user sogo have access from his serveur root@localhost [(none)]> select User, host from mysql.user; +------------------+--------------+ | User | host | +------------------+--------------+ | sogo | 172.17.2.223 | Le 15/07/2022 à 13:51, "Peter Nagel" ([email protected] <mailto:[email protected]> ) a écrit : Hi, OCSCacheFolderURL = <mailto:mysql://sogo:[email protected]:3306/sogo/sogo_cache_folder> "mysql://sogo:[email protected]:3306/sogo/sogo_cache_folder"; you are not using localhost for your SQL Connection: is the database really on a different machine? If not: is it set to accept connections from any other IP than localhost? Bye, Peter -----Ursprüngliche Nachricht----- Von: [email protected] <mailto:[email protected]> <mailto:[email protected]> <[email protected]> Im Auftrag von HYVERNAT Philippe Gesendet: Freitag, 15. Juli 2022 09:18 An: [email protected] <mailto:[email protected]> Betreff: Re: [SOGo] - Error memcached Hello, It is exactly what i have done : SOGoMemcachedHost = "/var/run/memcached/memcached.pid"; Always the error on caching values... Le 14/07/2022 à 13:14, Christian Mack ([email protected] <mailto:[email protected]> ) a écrit : Hello Am 06.07.22 um 10:30 schrieb HYVERNAT Philippe ([email protected] <mailto:[email protected]> ): Hello, we have many errors concerning caching value : sogod [60246]: <0x0x8046cbc18[SOGoCache]> an error occurred when caching value for key '/Users/[email protected]/Calendar/personal': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY" What is it ? Here's the configuration : OCSCacheFolderURL = <mailto:mysql://sogo:[email protected]:3306/sogo/sogo_cache_folder> "mysql://sogo:[email protected]:3306/sogo/sogo_cache_folder"; SOGoMemcachedHost = "/var/run/memcached/memcahed.pid"; (i tried to put Ip Address but white page) [cut] There is a typo in SOGoMemcachedHost Should be SOGoMemcachedHost = "/var/run/memcached/memcached.pid"; Kind regards, Christian Mack -- [email protected] <mailto:[email protected]> https://inverse.ca/sogo/lists -- [email protected] <mailto:[email protected]> https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
