1

Topic: Installation errors

==== Required information ====
- iRedMail version (check /etc/iredmail-release): v0.9.7
- Linux/BSD distribution name and version: Debian Stretch 9.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL (Remote via http://iredmail.org/docs/install.iredma … rver.html)
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No, modified Postfixadmin
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Installation log:

[ INFO ] Add apt repo for SOGo: https://packages.inverse.ca
[ INFO ] Import apt key (0x810273C4) for SOGo repo (https://packages.inverse.ca).
Executing: /tmp/apt-key-gpghome.CTBWQZjs1v/gpg.1.sh --keyserver keys.gnupg.net --recv-key 0x810273C4
gpg: keyserver receive failed: Server indicated a failure
Executing: /tmp/apt-key-gpghome.hSkHqCyqC5/gpg.1.sh --keyserver pgp.mit.edu --recv-key 0x810273C4
gpg: keyserver receive failed: Server indicated a failure
[ INFO ] Resynchronizing the package index files (apt-get update) ...
Hit:1 http://security.debian.org/debian-security stretch/updates InRelease
Ign:2 http://ftp.be.debian.org/debian stretch InRelease
Hit:3 http://ftp.be.debian.org/debian stretch-updates InRelease
Get:4 https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease [2540 B]
Hit:5 http://ftp.be.debian.org/debian stretch Release
Ign:4 https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease
Fetched 2540 B in 0s (4545 B/s)
Reading package lists... Done
W: GPG error: https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 19CDA6A9810273C4
W: The repository 'https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease' is not signed.
N: Data from such a repository can't be authenticated and is therefore potentially dangerous to use.
N: See apt-secure(8) manpage for repository creation and user configuration details.
[ INFO ] Installing package(s): postfix postfix-pcre mariadb-client postfix-mysql libdbd-mysql-perl nginx-full php-fpm dovecot-imapd dovecot-pop3d dovecot-lmtpd dovecot-managesieved dovecot-sieve dovecot-mysql amavisd-new libcrypt-openssl-rsa-perl libmail-dkim-perl clamav-freshclam clamav-daemon spamassassin altermime arj zoo nomarch cpio lzop cabextract p7zip-full rpm ripole libmail-spf-perl unrar-free pax lrzip sogo sogo-activesync sope4.9-gdl1-mysql python-sqlalchemy python-dnspython python-mysqldb python-jinja2 python-netifaces python-webpy python-beautifulsoup python-lxml python-pycurl uwsgi uwsgi-plugin-python fail2ban bzip2 acl patch cron tofrodos logwatch unzip bsdutils liblz4-tool
Reading package lists...
Building dependency tree...
Reading state information...
bzip2 is already the newest version (1.0.6-8.1).
cpio is already the newest version (2.11+dfsg-6).
cron is already the newest version (3.0pl1-128+b1).
bsdutils is already the newest version (1:2.29.2-1).
The following additional packages will be installed:
  binutils clamav clamav-base clamdscan cpp cpp-6 debugedit dovecot-core
  fontconfig-config fonts-dejavu-core gcc gcc-6 gnustep-base-common
  gnustep-base-runtime gnustep-common gnustep-make gobjc gobjc-6 libaio1
  libarchive-zip-perl libarchive13 libasan3 libatomic1 libauthen-sasl-perl
  libavahi-client3 libavahi-common-data libavahi-common3 libberkeleydb-perl
  libc-dev-bin libc6-dev libcc1-0 libcgi-fast-perl libcgi-pm-perl libcilkrts5
  libclamav7 libconvert-binhex-perl libconvert-tnef-perl libconvert-uulib-perl
  libcrypt-openssl-bignum-perl libcurl3 libdate-manip-perl libdbi-perl
  libdigest-hmac-perl libencode-locale-perl liberror-perl libevent-2.0-5
  libexttextcat-2.0-0 libexttextcat-data libfcgi-perl libfile-listing-perl
  libfont-afm-perl libfontconfig1 libgc1c2 libgcc-6-dev libgd3
  libgnustep-base1.24 libgomp1 libhtml-form-perl libhtml-format-perl
  libhtml-parser-perl libhtml-tagset-perl libhtml-tree-perl
  libhttp-cookies-perl libhttp-daemon-perl libhttp-date-perl
  libhttp-message-perl libhttp-negotiate-perl libio-html-perl
  libio-multiplex-perl libio-socket-inet6-perl libio-socket-ssl-perl
  libio-stringy-perl libisl15 libitm1 libjansson4 libjbig0 libjemalloc1
  libjpeg62-turbo libjson-c3 liblasso3 libllvm3.8 liblsan0 libltdl7
  liblua5.2-0 liblwp-mediatypes-perl liblwp-protocol-https-perl liblzo2-2
  libmailtools-perl libmariadbclient18 libmatheval1 libmemcached11
  libmime-tools-perl libmpc3 libmpfr4 libmpx2 libnet-cidr-lite-perl
  libnet-cidr-perl libnet-dns-perl libnet-http-perl libnet-ip-perl
  libnet-libidn-perl libnet-patricia-perl libnet-server-perl
  libnet-smtp-ssl-perl libnet-ssleay-perl libnetaddr-ip-perl
  libnginx-mod-http-auth-pam libnginx-mod-http-dav-ext libnginx-mod-http-echo
  libnginx-mod-http-geoip libnginx-mod-http-image-filter
  libnginx-mod-http-subs-filter libnginx-mod-http-upstream-fair
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libnspr4
  libnss3 libobjc-6-dev libobjc4 libpgm-5.2-0 libpython2.7 libquadmath0
  librpm3 librpmbuild3 librpmio3 librpmsign3 libsbjson2.3 libsocket6-perl
  libsodium18 libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9
  libsope-ldap4.9 libsope-mime4.9 libsope-xml4.9 libstemmer0d libsys-cpu-perl
  libsys-hostname-long-perl libsys-meminfo-perl libterm-readkey-perl libtfm1
  libtiff5 libtimedate-perl libtsan0 libubsan0 libunix-syslog-perl liburi-perl
  libwavpack1 libwbxml2-0 libwebp6 libwww-perl libwww-robotrules-perl
  libxmlsec1 libxmlsec1-openssl libxpm4 libxslt1.1 libyaml-0-2 libzmq5
  linux-libc-dev make manpages-dev mariadb-client-10.1
  mariadb-client-core-10.1 mariadb-common memcached mysql-common nginx-common
  p7zip perl-openssl-defaults php-common php7.0-cli php7.0-common php7.0-fpm
  php7.0-json php7.0-opcache php7.0-readline postfix-sqlite psmisc python-bs4
  python-chardet python-cheetah python-flup python-html5lib python-markupsafe
  python-pkg-resources python-six python-sqlalchemy-ext python-webencodings
  python3-pyinotify python3-systemd re2c rpm-common rpm2cpio sa-compile
  sope4.9-libxmlsaxdriver spamc ssl-cert tmpreaper unar uwsgi-core whois zip
Suggested packages:
  dspam lhasa libnet-ldap-perl libsnmp-perl libzeromq-perl unrar binutils-doc
  clamav-docs apparmor daemon cpp-doc gcc-6-locales rpm-i18n ntp
  dovecot-gssapi dovecot-pgsql dovecot-sqlite dovecot-ldap dovecot-solr
  dovecot-lucene ufw mailx monit gcc-multilib autoconf automake libtool flex
  bison gdb gcc-doc gcc-6-multilib gcc-6-doc libgcc1-dbg libgomp1-dbg
  libitm1-dbg libatomic1-dbg libasan3-dbg liblsan0-dbg libtsan0-dbg
  libubsan0-dbg libcilkrts5-dbg libmpx2-dbg libquadmath0-dbg gnustep-base-doc
  gnustep-make-doc gobjc-multilib gobjc-6-multilib libobjc4-dbg libgssapi-perl
  glibc-doc libclamunrar7 libclone-perl libmldbm-perl libnet-daemon-perl
  libsql-statement-perl libgd-tools libdata-dump-perl libcrypt-ssleay-perl
  liblog-log4perl-perl libauthen-ntlm-perl fortune-mod make-doc
  libcache-memcached-perl libmemcached libanyevent-perl libyaml-perl fcgiwrap
  nginx-doc p7zip-rar ed diffutils-doc php-pear procmail postfix-pgsql
  postfix-ldap postfix-lmdb sasl2-bin resolvconf postfix-cdb mail-reader
  postfix-doc python-markdown python-pygments python-memcache python-genshi
  python-jinja2-doc python-lxml-dbg python-lxml-doc default-mysql-server
  | virtual-mysql-server python-egenix-mxdatetime python-mysqldb-dbg
  python-setuptools libcurl4-gnutls-dev python-pycurl-dbg python-pycurl-doc
  python-sqlalchemy-doc python-psycopg2 python-fdb python-pymssql
  python-pyinotify-doc alien elfutils rpmlint rpm2html mysql-server razor
  pyzor libencode-detect-perl libgeo-ip-perl openssl-blacklist pike7.8
  | pike7.6 | pike uwsgi-plugins-all uwsgi-extra python-uwsgidecorators
The following NEW packages will be installed:
  acl altermime amavisd-new arj binutils cabextract clamav clamav-base
  clamav-daemon clamav-freshclam clamdscan cpp cpp-6 debugedit dovecot-core
  dovecot-imapd dovecot-lmtpd dovecot-managesieved dovecot-mysql dovecot-pop3d
  dovecot-sieve fail2ban fontconfig-config fonts-dejavu-core gcc gcc-6
  gnustep-base-common gnustep-base-runtime gnustep-common gnustep-make gobjc
  gobjc-6 libaio1 libarchive-zip-perl libarchive13 libasan3 libatomic1
  libauthen-sasl-perl libavahi-client3 libavahi-common-data libavahi-common3
  libberkeleydb-perl libc-dev-bin libc6-dev libcc1-0 libcgi-fast-perl
  libcgi-pm-perl libcilkrts5 libclamav7 libconvert-binhex-perl
  libconvert-tnef-perl libconvert-uulib-perl libcrypt-openssl-bignum-perl
  libcrypt-openssl-rsa-perl libcurl3 libdate-manip-perl libdbd-mysql-perl
  libdbi-perl libdigest-hmac-perl libencode-locale-perl liberror-perl
  libevent-2.0-5 libexttextcat-2.0-0 libexttextcat-data libfcgi-perl
  libfile-listing-perl libfont-afm-perl libfontconfig1 libgc1c2 libgcc-6-dev
  libgd3 libgnustep-base1.24 libgomp1 libhtml-form-perl libhtml-format-perl
  libhtml-parser-perl libhtml-tagset-perl libhtml-tree-perl
  libhttp-cookies-perl libhttp-daemon-perl libhttp-date-perl
  libhttp-message-perl libhttp-negotiate-perl libio-html-perl
  libio-multiplex-perl libio-socket-inet6-perl libio-socket-ssl-perl
  libio-stringy-perl libisl15 libitm1 libjansson4 libjbig0 libjemalloc1
  libjpeg62-turbo libjson-c3 liblasso3 libllvm3.8 liblsan0 libltdl7
  liblua5.2-0 liblwp-mediatypes-perl liblwp-protocol-https-perl liblz4-tool
  liblzo2-2 libmail-dkim-perl libmail-spf-perl libmailtools-perl
  libmariadbclient18 libmatheval1 libmemcached11 libmime-tools-perl libmpc3
  libmpfr4 libmpx2 libnet-cidr-lite-perl libnet-cidr-perl libnet-dns-perl
  libnet-http-perl libnet-ip-perl libnet-libidn-perl libnet-patricia-perl
  libnet-server-perl libnet-smtp-ssl-perl libnet-ssleay-perl
  libnetaddr-ip-perl libnginx-mod-http-auth-pam libnginx-mod-http-dav-ext
  libnginx-mod-http-echo libnginx-mod-http-geoip
  libnginx-mod-http-image-filter libnginx-mod-http-subs-filter
  libnginx-mod-http-upstream-fair libnginx-mod-http-xslt-filter
  libnginx-mod-mail libnginx-mod-stream libnspr4 libnss3 libobjc-6-dev
  libobjc4 libpgm-5.2-0 libpython2.7 libquadmath0 librpm3 librpmbuild3
  librpmio3 librpmsign3 libsbjson2.3 libsocket6-perl libsodium18
  libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9 libsope-ldap4.9
  libsope-mime4.9 libsope-xml4.9 libstemmer0d libsys-cpu-perl
  libsys-hostname-long-perl libsys-meminfo-perl libterm-readkey-perl libtfm1
  libtiff5 libtimedate-perl libtsan0 libubsan0 libunix-syslog-perl liburi-perl
  libwavpack1 libwbxml2-0 libwebp6 libwww-perl libwww-robotrules-perl
  libxmlsec1 libxmlsec1-openssl libxpm4 libxslt1.1 libyaml-0-2 libzmq5
  linux-libc-dev logwatch lrzip lzop make manpages-dev mariadb-client
  mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common memcached
  mysql-common nginx-common nginx-full nomarch p7zip p7zip-full patch pax
  perl-openssl-defaults php-common php-fpm php7.0-cli php7.0-common php7.0-fpm
  php7.0-json php7.0-opcache php7.0-readline postfix postfix-mysql
  postfix-pcre postfix-sqlite psmisc python-beautifulsoup python-bs4
  python-chardet python-cheetah python-dnspython python-flup python-html5lib
  python-jinja2 python-lxml python-markupsafe python-mysqldb python-netifaces
  python-pkg-resources python-pycurl python-six python-sqlalchemy
  python-sqlalchemy-ext python-webencodings python-webpy python3-pyinotify
  python3-systemd re2c ripole rpm rpm-common rpm2cpio sa-compile sogo
  sogo-activesync sope4.9-gdl1-mysql sope4.9-libxmlsaxdriver spamassassin
  spamc ssl-cert tmpreaper tofrodos unar unrar-free unzip uwsgi uwsgi-core
  uwsgi-plugin-python whois zip zoo
0 upgraded, 256 newly installed, 0 to remove and 0 not upgraded.
Need to get 134 MB of archives.
After this operation, 480 MB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
  libwbxml2-0 libsbjson2.3 libsope-xml4.9 libsope-core4.9 libsope-mime4.9
  libsope-appserver4.9 libsope-gdl1-4.9 libsope-ldap4.9
  sope4.9-libxmlsaxdriver sope4.9-gdl1-mysql sogo sogo-activesync
E: There were unauthenticated packages and -y was used without --allow-unauthenticated
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail
<< ERROR >> forum: http://www.iredmail.org/forum/



Is it only the sogo repository or am I seeing this wrong?

Thanks in advance for the support
Wraptor

----

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

2

Re: Installation errors

Wraptor wrote:

W: GPG error: https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 19CDA6A9810273C4
W: The repository 'https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease' is not signed.
N: Data from such a repository can't be authenticated and is therefore potentially dangerous to use.

SOGo apt repo key was not imported.

You can try to import it manually, then run iRedMail installer again.

sudo apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4

3

Re: Installation errors

I got it all installed but now sogo just isn't working, I checked the sogo log and found out that only 1 table (users) was being created.

I'm using a remote mysql server, created an admin_iredmail user with all permissions (Including grant) and everything but sogo worked.

Remote mysql sogo table:
mysql> use sogo;

Database changed
mysql> show tables;
+----------------+
| Tables_in_sogo |
+----------------+
| users          |
+----------------+
1 row in set (0.00 sec)

Remote mysql users:
mysql> select user from mysql.user;
+---------------------+
| user                |
+---------------------+
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| xxx                 |
| admin_iredmail      |
| amavisd             |
| iredadmin           |
| iredapd             |
| sogo                |
| vmail               |
| vmailadmin          |
| mysql.sys           |
| root                |
+---------------------+
14 rows in set (0.00 sec)

/var/log/sogo/sogo.log:
2017-10-22 13:51:43.188 sogod[5810:5810] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
2017-10-22 13:51:43.188 sogod[5811:5811] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5811]: <0x0x563100d387c0[WOHttpAdaptor]> notified the watchdog that we are readyOct 22 13:51:43 sogod [5810]: <0x0x563100d38ab0[WOHttpAdaptor]> notified the watchdog that we are ready

Oct 22 13:51:43 sogod [5809]: <0x0x563100dca670[WOWatchDog]> child spawned with pid 5817
2017-10-22 13:51:43.188 sogod[5812:5812] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5812]: <0x0x563100d38530[WOHttpAdaptor]> notified the watchdog that we are readyOct 22 13:51:43 sogod [5809]: <0x0x563100dca670[WOWatchDog]> child spawned with pid 5818

Oct 22 13:51:43 sogod [5809]: <0x0x563100dca670[WOWatchDog]> child spawned with pid 5819
2017-10-22 13:51:43.192 sogod[5813:5813] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
2017-10-22 13:51:43.192 sogod[5815:5815] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
2017-10-22 13:51:43.192 sogod[5814:5814] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5815]: <0x0x563100d1ee10[WOHttpAdaptor]> notified the watchdog that we are readyOct 22 13:51:43 sogod [5813]: <0x0x563100d37db0[WOHttpAdaptor]> notified the watchdog that we are ready

Oct 22 13:51:43 sogod [5814]: <0x0x563100d37120[WOHttpAdaptor]> notified the watchdog that we are ready
2017-10-22 13:51:43.193 sogod[5817:5817] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5817]: <0x0x563100cdb3a0[WOHttpAdaptor]> notified the watchdog that we are ready
2017-10-22 13:51:43.196 sogod[5819:5819] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
2017-10-22 13:51:43.196 sogod[5816:5816] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5819]: <0x0x563100ede830[WOHttpAdaptor]> notified the watchdog that we are readyOct 22 13:51:43 sogod [5816]: <0x0x563100cf9f90[WOHttpAdaptor]> notified the watchdog that we are ready

2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'
Oct 22 13:51:43 sogod [5818]: <0x0x563100f0a870[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 22 13:51:54 sogod [5818]: <0x0x563100dc08c0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Oct 22 13:51:54 sogod [5818]: <0x0x563100dc08c0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2017-10-22 13:51:54.411 sogod[5818:5818] EXCEPTION: <NSException: 0x5631010ab6e0> NAME:NSInvalidArgumentException REASON:Tried to add nil value for key 'users' to dictionary INFO:{}
Oct 22 13:51:54 sogod [5818]: xx.xx.xx.xx "GET /SOGo/ HTTP/1.0" 501 0/0 0.012 - - 6M

4

Re: Installation errors

Hey there

Really helpfull but i got another problem adn am wondergin if someone can help

Setting up nginx-full (1.10.3-0ubuntu0.16.04.2) ...
Job for nginx.service failed because the control process exited with error code. See "systemctl status nginx.service" and "journalctl -xe" for details.
invoke-rc.d: initscript nginx, action "start" failed.
* nginx.service - A high performance web server and a reverse proxy server
   Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2017-10-23 10:51:03 EDT; 38ms ago
  Process: 19465 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=1/FAILURE)
  Process: 19462 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)

dpkg: error processing package nginx-full (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 nginx-full
E: Sub-process /usr/bin/dpkg returned an error code (1)
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail
<< ERROR >> forum: http://www.iredmail.org/forum/

What is going wrong?

5

Re: Installation errors

Wraptor wrote:

2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'

Are you using a IPv6 address for remote MySQL server?
Does sql user "sogo" have required privileges to create sql tables in "sogo" database on remote MySQL server?

6 (edited by Wraptor 2017-10-25 02:24:43)

Re: Installation errors

Yes I'm using IPv6 as IPv4 is becoming Legacy imo.
The remote mysql server has the user sogo created by the iRedmail installer.

mysql> show grants for sogo@'xxxx:xxxx:xxxx:xxxx:xxxx::1';
+------------------------------------------------------------------------------------------------+
| Grants for sogo@xxxx:xxxx:xxxx:xxxx:xxxx::1                                                 |
+------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sogo'@'xxxx:xxxx:xxxx:xxxx:xxxx::1'                          |
| GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'xxxx:xxxx:xxxx:xxxx:xxxx::1'    |
| GRANT SELECT ON `vmail`.`mailbox` TO 'sogo'@'xxxx:xxxx:xxxx:xxxx:xxxx::1' |
+------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)


EDIT:
I googled the issue and it said something about not having the right default encoding, which should've been UTF8.
I changed the MySQL default encoding for databases and tables and removed all databases and users regarding iRedmail and reinstalled on a clean mailserver. Same issue.

7

Re: Installation errors

Wraptor wrote:

2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info'

According to SOGo error message, i think the problem is SOGo doesn't support IPv6 address while parsing the setting. Please report this bug to SOGo team:
https://sogo.nu/support/index.html

8 (edited by Wraptor 2017-10-25 23:27:20)

Re: Installation errors

Is this issue related to SOGo, SOGo Integrator or the SOGo Connector?


EDIT:
Is sogo responsable for the table creation or is iRedmail supposed to do this on installation?

9

Re: Installation errors

Ubuntu 17
My installation not finishing good and given me next:
Creating config file /etc/dovecot/conf.d/20-managesieve.conf with new version
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for libc-bin (2.24-9ubuntu2.2) ...
Processing triggers for systemd (232-21ubuntu5) ...
Processing triggers for dovecot-core (1:2.2.27-2ubuntu2) ...
< SKIP > Function: after_package_installation.

********************************************************************
* Start iRedMail Configurations
********************************************************************
< SKIP > Function: generate_ssl_keys.
< SKIP > Function: add_required_users.
< SKIP > Function: web_server_config.
< SKIP > Function: mysql_setup.
< SKIP > Function: postfix_setup.
< SKIP > Function: dovecot_setup.
< SKIP > Function: clamav_config.
< SKIP > Function: amavisd_config.
< SKIP > Function: sa_config.
< SKIP > Function: iredapd_setup.
< SKIP > Function: iredadmin_setup.
< SKIP > Function: rcm_setup.
< SKIP > Function: cleanup.
root@mail:~/iRedMail-0.9.7#

and this all. what the problem?
web-serever  nginx not gonfigure 443 port and config for /iredadmin/ etc...

10

Re: Installation errors

Hi, ZhangHuangbin

I try to install iredmail 0.9.7 with SoGo in Debian 8.9.
The first problem was with key, follow tour indication that problem was solved, but

root@mx:~/iRedMail-0.9.7# bash iRedMail.sh
[ INFO ] Checking configuration file: /root/iRedMail-0.9.7/config ... [FOUND]
< Question > Use it for mail server setting? [y|N]y
[ INFO ] Use config file: /root/iRedMail-0.9.7/config for mail server setting.
[ INFO ] Import installation process status from file: /root/iRedMail-0.9.7/runtime/install.status.
[ INFO ] Add apt repo for SOGo: https://packages.inverse.ca
[ INFO ] Import apt key (0x810273C4) for SOGo repo (https://packages.inverse.ca).
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.l6OquraCwl --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-security-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-stable.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-security-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-stable.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-wheezy-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-wheezy-stable.gpg --keyserver keys.gnupg.net --recv-key 0x810273C4
gpg: requesting key 810273C4 from hkp server keys.gnupg.net
gpg: keyserver timed out
gpg: keyserver receive failed: keyserver error
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --homedir /tmp/tmp.cI9oAjHpor --no-auto-check-trustdb --trust-model always --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-security-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-jessie-stable.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-security-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-stretch-stable.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-wheezy-automatic.gpg --keyring /etc/apt/trusted.gpg.d/debian-archive-wheezy-stable.gpg --keyserver pgp.mit.edu --recv-key 0x810273C4
gpg: requesting key 810273C4 from hkp server pgp.mit.edu
gpg: key 810273C4: "Inverse Support (package signing) <support@inverse.ca>" not changed
gpg: Total number processed: 1
gpg:              unchanged: 1
[ INFO ] Resynchronizing the package index files (apt-get update) ...
Ign http://192.168.1.15 jessie InRelease
Hit http://192.168.1.15 jessie Release.gpg
Hit http://192.168.1.15 jessie Release
Hit http://192.168.1.15 jessie/main amd64 Packages
Hit http://192.168.1.15 jessie/main Translation-en
Hit http://192.168.1.15 jessie/main Translation-es
Hit https://packages.inverse.ca jessie InRelease
Hit https://packages.inverse.ca jessie/jessie amd64 Packages
Get:1 https://packages.inverse.ca jessie/jessie Translation-en [375 B]
Get:2 https://packages.inverse.ca jessie/jessie Translation-es [375 B]
Ign http://ftp.uk.debian.org jessie InRelease
Ign http://ftp.uk.debian.org jessie Release.gpg
Get:3 https://packages.inverse.ca jessie/jessie Translation-en [375 B]
Get:4 https://packages.inverse.ca jessie/jessie Translation-es [375 B]
Get:5 https://packages.inverse.ca jessie/jessie Translation-en [375 B]
Get:6 https://packages.inverse.ca jessie/jessie Translation-es [375 B]
Get:7 https://packages.inverse.ca jessie/jessie Translation-en [375 B]
Get:8 https://packages.inverse.ca jessie/jessie Translation-es [375 B]
Get:9 https://packages.inverse.ca jessie/jessie Translation-en [375 B]
Ign https://packages.inverse.ca jessie/jessie Translation-en
Get:10 https://packages.inverse.ca jessie/jessie Translation-es [375 B]
Ign https://packages.inverse.ca jessie/jessie Translation-es
Hit http://ftp.uk.debian.org jessie Release
Ign http://ftp.uk.debian.org jessie/main amd64 Packages/DiffIndex
Ign http://ftp.uk.debian.org jessie/contrib amd64 Packages/DiffIndex
Ign http://ftp.uk.debian.org jessie/non-free amd64 Packages/DiffIndex
Hit http://ftp.uk.debian.org jessie/contrib Translation-en
Hit http://ftp.uk.debian.org jessie/main Translation-en
Hit http://ftp.uk.debian.org jessie/main Translation-es
Hit http://ftp.uk.debian.org jessie/non-free Translation-en
Hit http://ftp.uk.debian.org jessie/main amd64 Packages
Hit http://ftp.uk.debian.org jessie/contrib amd64 Packages
Hit http://ftp.uk.debian.org jessie/non-free amd64 Packages
Reading package lists... Done
[ INFO ] Installing package(s): postfix postfix-pcre postfix-ldap slapd ldap-utils libnet-ldap-perl libdbd-mysql-perl mysql-server mysql-client php5-cli php5-json php5-gd php5-mcrypt php5-curl mcrypt php5-intl php5-ldap php5-mysql nginx-full php5-fpm dovecot-imapd dovecot-pop3d dovecot-lmtpd dovecot-managesieved dovecot-sieve dovecot-ldap dovecot-mysql amavisd-new libcrypt-openssl-rsa-perl libmail-dkim-perl clamav-freshclam clamav-daemon spamassassin altermime arj zoo nomarch cpio lzop cabextract p7zip-full rpm ripole libmail-spf-perl unrar-free pax lrzip php-net-ldap2 sogo sogo-activesync sope4.9-gdl1-mysql python-sqlalchemy python-dnspython python-ldap python-mysqldb python-jinja2 python-netifaces python-webpy python-beautifulsoup python-lxml python-pycurl uwsgi uwsgi-plugin-python python-bcrypt awstats fail2ban bzip2 acl patch cron tofrodos logwatch unzip bsdutils liblz4-tool
Reading package lists...
Building dependency tree...
Reading state information...
acl is already the newest version.
bzip2 is already the newest version.
cpio is already the newest version.
cron is already the newest version.
patch is already the newest version.
bsdutils is already the newest version.
unzip is already the newest version.
unzip set to manually installed.
The following extra packages will be installed:
  autotools-dev binutils clamav clamav-base clamdscan cpp cpp-4.9 debugedit
  dovecot-core gcc gcc-4.9 gnustep-base-common gnustep-base-runtime
  gnustep-common gnustep-make gobjc gobjc-4.9 libaio1 libapparmor1
  libarchive-zip-perl libasan1 libatomic1 libberkeleydb-perl libc-dev-bin
  libc6-dev libcilkrts5 libclamav7 libcloog-isl4 libconvert-asn1-perl
  libconvert-binhex-perl libconvert-tnef-perl libconvert-uulib-perl
  libcrypt-openssl-bignum-perl libcurl3 libdate-manip-perl libdbi-perl
  libdigest-hmac-perl libelf1 liberror-perl libgcc-4.9-dev libgd3
  libgnustep-base1.24 libgomp1 libgssapi-perl libhtml-template-perl
  libio-multiplex-perl libio-socket-inet6-perl libio-stringy-perl libisl10
  libitm1 libjansson4 liblasso3 libllvm3.5 liblsan0 libltdl7 liblua5.2-0
  liblz4-1 liblzo2-2 libmatheval1 libmcrypt4 libmemcached11 libmhash2
  libmime-tools-perl libmpc3 libmpfr4 libmspack0 libmysqlclient18
  libnet-cidr-perl libnet-dns-perl libnet-ip-perl libnet-libidn-perl
  libnet-server-perl libnet-xwhois-perl libnetaddr-ip-perl libnspr4 libnss3
  libobjc-4.9-dev libobjc4 libodbc1 libonig2 libperl5.20 libpgm-5.1-0
  libpython2.7 libqdbm14 libquadmath0 librpm3 librpmbuild3 librpmio3
  librpmsign1 libsbjson2.3 libslp1 libsocket6-perl libsodium13
  libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9 libsope-ldap4.9
  libsope-mime4.9 libsope-xml4.9 libsys-cpu-perl libsys-hostname-long-perl
  libterm-readkey-perl libtsan0 libubsan0 libunix-syslog-perl libvpx1
  libwavpack1 libwbxml2-0 libxmlsec1 libxmlsec1-openssl libxpm4 libxslt1.1
  libyaml-0-2 libzmq3 linux-libc-dev make manpages-dev memcached
  mysql-client-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
  nginx-common php5-common php5-readline python-cheetah python-flup
  python-markupsafe python-pyinotify python-sqlalchemy-ext re2c rpm-common
  rpm2cpio sa-compile sope4.9-libxmlsaxdriver spamc ssl-cert tmpreaper unar
  uwsgi-core zip
Suggested packages:
  dspam lhasa libsnmp-perl libzeromq-perl p7zip unrar apache2 httpd
  libgeo-ipfree-perl binutils-doc clamav-docs apparmor daemon cpp-doc
  gcc-4.9-locales rpm-i18n ntp dovecot-gssapi dovecot-pgsql dovecot-sqlite
  dovecot-solr dovecot-lucene python-gamin gcc-multilib autoconf automake
  libtool flex bison gdb gcc-doc gcc-4.9-multilib gcc-4.9-doc libgcc1-dbg
  libgomp1-dbg libitm1-dbg libatomic1-dbg libasan1-dbg liblsan0-dbg
  libtsan0-dbg libubsan0-dbg libcilkrts5-dbg libquadmath0-dbg gnustep-base-doc
  gnustep-make-doc gobjc-multilib gobjc-4.9-multilib libobjc4-dbg
  libsasl2-modules-gssapi-mit libsasl2-modules-gssapi-heimdal glibc-doc
  libclamunrar7 libclone-perl libmldbm-perl libnet-daemon-perl
  libsql-statement-perl libgd-tools libipc-sharedcache-perl libmcrypt-dev
  libjson-perl liblog-log4perl-perl libmyodbc odbc-postgresql tdsodbc
  unixodbc-bin slpd openslp-doc fortune-mod libcache-memcached-perl
  libmemcached libanyevent-perl libyaml-perl tinyca fcgiwrap nginx-doc
  p7zip-rar php-pear php5-user-cache postfix-mysql postfix-pgsql sasl2-bin
  dovecot-common resolvconf postfix-cdb ufw postfix-doc python-markdown
  python-memcache python-jinja2-doc python-ldap-doc python-pyasn1
  python-lxml-dbg python-egenix-mxdatetime python-mysqldb-dbg
  libcurl4-gnutls-dev python-pycurl-dbg python-pycurl-doc python-pyinotify-doc
  python-sqlalchemy-doc python-psycopg2 python-kinterbasdb python-pymssql
  alien elfutils rpmlint rpm2html nginx razor pyzor openssl-blacklist pike7.8
  pike7.6 pike uwsgi-plugins-all uwsgi-extra python-uwsgidecorators
Recommended packages:
  libnet-patricial-perl
The following packages will be REMOVED:
  exim4 exim4-base exim4-config exim4-daemon-light
The following NEW packages will be installed:
  altermime amavisd-new arj autotools-dev awstats binutils cabextract clamav
  clamav-base clamav-daemon clamav-freshclam clamdscan cpp cpp-4.9 debugedit
  dovecot-core dovecot-imapd dovecot-ldap dovecot-lmtpd dovecot-managesieved
  dovecot-mysql dovecot-pop3d dovecot-sieve fail2ban gcc gcc-4.9
  gnustep-base-common gnustep-base-runtime gnustep-common gnustep-make gobjc
  gobjc-4.9 ldap-utils libaio1 libapparmor1 libarchive-zip-perl libasan1
  libatomic1 libberkeleydb-perl libc-dev-bin libc6-dev libcilkrts5 libclamav7
  libcloog-isl4 libconvert-asn1-perl libconvert-binhex-perl
  libconvert-tnef-perl libconvert-uulib-perl libcrypt-openssl-bignum-perl
  libcrypt-openssl-rsa-perl libcurl3 libdate-manip-perl libdbd-mysql-perl
  libdbi-perl libdigest-hmac-perl libelf1 liberror-perl libgcc-4.9-dev libgd3
  libgnustep-base1.24 libgomp1 libgssapi-perl libhtml-template-perl
  libio-multiplex-perl libio-socket-inet6-perl libio-stringy-perl libisl10
  libitm1 libjansson4 liblasso3 libllvm3.5 liblsan0 libltdl7 liblua5.2-0
  liblz4-1 liblz4-tool liblzo2-2 libmail-dkim-perl libmail-spf-perl
  libmatheval1 libmcrypt4 libmemcached11 libmhash2 libmime-tools-perl libmpc3
  libmpfr4 libmspack0 libmysqlclient18 libnet-cidr-perl libnet-dns-perl
  libnet-ip-perl libnet-ldap-perl libnet-libidn-perl libnet-server-perl
  libnet-xwhois-perl libnetaddr-ip-perl libnspr4 libnss3 libobjc-4.9-dev
  libobjc4 libodbc1 libonig2 libperl5.20 libpgm-5.1-0 libpython2.7 libqdbm14
  libquadmath0 librpm3 librpmbuild3 librpmio3 librpmsign1 libsbjson2.3 libslp1
  libsocket6-perl libsodium13 libsope-appserver4.9 libsope-core4.9
  libsope-gdl1-4.9 libsope-ldap4.9 libsope-mime4.9 libsope-xml4.9
  libsys-cpu-perl libsys-hostname-long-perl libterm-readkey-perl libtsan0
  libubsan0 libunix-syslog-perl libvpx1 libwavpack1 libwbxml2-0 libxmlsec1
  libxmlsec1-openssl libxpm4 libxslt1.1 libyaml-0-2 libzmq3 linux-libc-dev
  logwatch lrzip lzop make manpages-dev mcrypt memcached mysql-client
  mysql-client-5.5 mysql-common mysql-server mysql-server-5.5
  mysql-server-core-5.5 nginx-common nginx-full nomarch p7zip-full pax
  php-net-ldap2 php5-cli php5-common php5-curl php5-fpm php5-gd php5-intl
  php5-json php5-ldap php5-mcrypt php5-mysql php5-readline postfix
  postfix-ldap postfix-pcre python-bcrypt python-beautifulsoup python-cheetah
  python-dnspython python-flup python-jinja2 python-ldap python-lxml
  python-markupsafe python-mysqldb python-netifaces python-pycurl
  python-pyinotify python-sqlalchemy python-sqlalchemy-ext python-webpy re2c
  ripole rpm rpm-common rpm2cpio sa-compile slapd sogo sogo-activesync
  sope4.9-gdl1-mysql sope4.9-libxmlsaxdriver spamassassin spamc ssl-cert
  tmpreaper tofrodos unar unrar-free uwsgi uwsgi-core uwsgi-plugin-python zip
  zoo
0 upgraded, 209 newly installed, 4 to remove and 0 not upgraded.
Need to get 117 MB of archives.
After this operation, 442 MB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
  postfix libxpm4 libgd3 mysql-common libmysqlclient18 libnss3 libonig2
  libxslt1.1 mysql-client-5.5 mysql-server-core-5.5 mysql-server-5.5
  libperl5.20 slapd binutils dovecot-core dovecot-imapd dovecot-ldap
  dovecot-lmtpd dovecot-sieve dovecot-managesieved dovecot-mysql dovecot-pop3d
  libc-dev-bin linux-libc-dev libc6-dev ldap-utils mysql-client mysql-server
  php5-common php5-ldap php5-cli php5-curl php5-fpm php5-gd php5-intl
  php5-mcrypt php5-mysql php5-readline uwsgi-core uwsgi postfix-ldap
  postfix-pcre uwsgi-plugin-python
E: There are problems and -y was used without --force-yes
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail
<< ERROR >> forum: http://www.iredmail.org/forum/


this is the error line
E: There are problems and -y was used without --force-yes

11

Re: Installation errors

pablorvh wrote:

I try to install iredmail 0.9.7 with SoGo in Debian 8.9.

did you upgrade all packages before running iRedMail installer?

Is this a fresh new Debian OS? Or it's offered by a VPS/cloud vendor?

12

Re: Installation errors

I fixed the issue myself using common sense. In web URL's the ipv6 address'  ":" is distinguished  between de port's ":" using block brackets. so you have to change every mysql url to "mysql://sogo:SECRET@[xxxx:xxxx:xxxx:xxxx:xxxx::1]:3306/sogo/sogo_folder_info" in the sogo.conf file.


This issue should be resolved by the iRedmail installer to prevent problems for futher IPv6 Issues using SOGo.

13

Re: Installation errors

Fixed moment ago:
https://bitbucket.org/zhb/iredmail/comm … 6b311568a6

Thanks very much for the feedback.