Sogo white page

Sogo said Proxy error

Yes, i have nextcloud, works.

It is not working again
client disconnected during delivery of response for <WORequest[0x0x558094d5a630]: method=POST uri=/SOGo/so

/Mail/unseenCount> (len=21): the socket was shutdown

please post the full sogo log when the blank page appears in a gist (My old eyes are tired)

again if the DB is corrupted, since you did not removed it, your issue is still occuring
we are not window, install/remove is not good
you are on unix :slight_smile:

You have to look inside

/var/log/messages
/var/log/sogo/sogo.log
/var/log/mariadb/mariadb.log

I removed the database sogo and installed again, so as you said.

ok, don’t know, the error message has changed since your first post

I don’t know hot to put there the log

Here is mysql

190519 17:59:39 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended 
190519 19:59:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
190519 19:59:43 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 6176 ... 
190519 19:59:45 InnoDB: The InnoDB memory heap is disabled 
190519 19:59:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
190519 19:59:45 InnoDB: Compressed tables use zlib 1.2.7 
190519 19:59:45 InnoDB: Using Linux native AIO 
190519 19:59:45 InnoDB: Initializing buffer pool, size = 128.0M 
190519 19:59:46 InnoDB: Completed initialization of buffer pool 
190519 19:59:46 InnoDB: highest supported file format is Barracuda. 
190519 19:59:49 InnoDB: Waiting for the background threads to start 
190519 19:59:50 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 3454017 
190519 19:59:51 [Note] Plugin 'FEEDBACK' is disabled. 
190519 19:59:51 [Note] Server socket created on IP: '0.0.0.0'. 
190519 19:59:52 [Note] Event Scheduler: Loaded 0 events 
190519 19:59:52 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.60-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 
190519 18:11:21 [Note] /usr/libexec/mysqld: Normal shutdown 
190519 18:11:21 [Note] Event Scheduler: Purging the queue. 0 events 
190519 18:11:21 InnoDB: Starting shutdown... 
190519 18:12:21 InnoDB: Waiting for worker threads to be suspended 
190519 20:13:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
190519 20:13:22 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 6232 ... 
190519 20:13:24 InnoDB: The InnoDB memory heap is disabled 
190519 20:13:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
190519 20:13:24 InnoDB: Compressed tables use zlib 1.2.7 
190519 20:13:24 InnoDB: Using Linux native AIO 
190519 20:13:24 InnoDB: Initializing buffer pool, size = 128.0M 
190519 20:13:24 InnoDB: Completed initialization of buffer pool 
190519 20:13:25 InnoDB: highest supported file format is Barracuda. 
190519 20:13:25 InnoDB: Starting crash recovery from checkpoint LSN=3454017 InnoDB: Restoring possible half-written data pages from the doublewrite buffer... 
190519 20:13:32 InnoDB: Starting final batch to recover 14 pages from redo log 
190519 20:13:32 InnoDB: Waiting for the background threads to start 
190519 20:13:33 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 3504499 
190519 20:13:33 [Note] Plugin 'FEEDBACK' is disabled. 
190519 20:13:34 [Note] Server socket created on IP: '0.0.0.0'. 
190519 20:13:35 [Note] Event Scheduler: Loaded 0 events 
190519 20:13:35 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.60-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
May 19 18:18:02 sogod [7085]: [ERROR] <0x0x5567375b9f90[SOGoSQLUserProfile]> failed to acquire channel for URL: mysql://sogo:s_Re3N9GQ_9qtVy1@localhost/sogo/sogo_user_profile 
May 19 18:18:02 sogod [7085]: [ERROR] <0x0x5567375b9f90[SOGoSQLUserProfile]> failed to acquire channel for URL: mysql://sogo:s_Re3N9GQ_9qtVy1@localhost/sogo/sogo_user_profile 
May 19 18:18:02 sogod [7085]: 192.168.12.107 "GET /SOGo/so/stojovski/Mail/view HTTP/1.1" 200 19618/0 0.035 77779 74% 0

how did you remove the mysql database ?
please paste the command you did

DROP DATABASE sogo;

1 Like

when we remove a mysql databse does the user (sogo here) is removed, maybe something is not working here, sogo is clear he cannot connect to mysql and mysql seems workable with nextcloud

maybe

remove sogo db
remove sogo user mysql
reinstall nethserver-sogo

OK i will try, what i also tried, restart crony, sssd, dnsmasq, memcached, opendkim, dovecot, than works, after reboot the same, and i don’t see domain accounts LDAP, but i will try now what you wro

te.THX

1 Like

Ok solve the ad problem, without it sogo won’t connect, probably you have found the problem

still trying

Reboot takes veeeery long.I have debian and centos7 on this server, no problems with reboot.

reboot deserves nothing, the AD container is down, fix the problem

I will try, but i did not made some special settings.
Tnx for your support.

I just restarted dovecot and it worked