1

Topic: SOGo Login Error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9 MYSQL edition.
- Deployed with iRedMail Easy or the downloadable installer? Downloadable Installer
- Linux/BSD distribution name and version: FreeBSD 11.2 64bit
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi

Today. I migrated old iRedmail Server (no SOGo) to new server (clean install, latest iRedMail). I transported vmail and roundcube tables to new server. But there are strange events on the server. SOGo is not working. Always giving Wrong username and password. error. But evertyhing works fine with Roundcube. Mail send and receive working. When I realize that SOGO doesn't work.I restarted nginx. But after that iredadmin page giving 502 Bad Gateway error. So iredadmin and SOGo not working anymore. I never changed any configuration on new server.

sogo.log
[ERROR] [we-rm] did not find locale for language: Turkish
SOGoRootPage Login from '172.25.1.10' for user 'user@hidingdomain' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

nginx/error.log
2018/12/20 14:08:48 [error] 6297#100490: *116 kevent() reported that connect() failed (61: Connection refused) while connecting to upstream, client: 172.25.1.10, server: _, request: "GET /iredadmin HTTP/1.1", upstream: "uwsgi://127.0.0.1:7791", host: "mail.hidingdomain"

How can i fix erros? Am i missing something?

Best Regards.

Hasan Alp İNAN

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: SOGo Login Error

Hi

I found a tool in iredadmin setup folder. migrate_sql_alias_table.py what is it for?  Also postmaster@ user successfully login to SOGo but migrated users not.

3

Re: SOGo Login Error

hainan wrote:

I transported vmail and roundcube tables to new server.

You need to apply all SQL related changes by following our upgrade tutorials:
https://docs.iredmail.org/iredmail.releases.html

4

Re: SOGo Login Error

ZhangHuangbin wrote:
hainan wrote:

I transported vmail and roundcube tables to new server.

You need to apply all SQL related changes by following our upgrade tutorials:
https://docs.iredmail.org/iredmail.releases.html

Hi ZhangHuangbin

I mean; I installed fresh iRedMail. Then just move some user database tables from old server to new server. Old server database tables also updated. SOGO is not installed on the old server. So, I am guessing, iredadmin using additional SQL inserts for SOGo. How can i add  existing users (migrated from old server) for SOGo usage? Is there any tool for?

Thanks for support.

Hasan Alp İNAN

5

Re: SOGo Login Error

hainan wrote:

So, I am guessing, iredadmin using additional SQL inserts for SOGo. How can i add  existing users (migrated from old server) for SOGo usage? Is there any tool for?

You should create database for sogo manually, then SOGo will create all required SQL tables automatically when restarting it.

Note: SQL table "users" must be created manually too. sample SQL command can be found in iRedMail source code:
https://bitbucket.org/zhb/iredmail/src/ … h#lines-73