View Issue Details

IDProjectCategoryView StatusLast Update
0004326SOGoBackend Generalpublic2018-01-12 19:07
ReporterWraptor Assigned To 
PriorityhighSeverityfeatureReproducibilityalways
Status newResolutionopen 
PlatformLinuxOSDebian StretchOS VersionDebian 9.2
Product Versionnightly master 
Summary0004326: IPv6 and mysql 'not a valid URL'
Description

I'm using iRedmail (An all in one mailserver solution) which integrates the nightly builds of sogo. I posted this issue and I was advised to report this as a sogo bug.

Error:
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'

user permissions:
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)

Steps To Reproduce

Installing latest iRedmail package (9.2.7) with IPv6 and sogo checked on Debian Stretch 9.2

TagsNo tags attached.

Activities

Wraptor

Wraptor

2017-10-25 15:36

reporter  

feed-rss-topic13512.xml (30,052 bytes)   
<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[iRedMail — Installation errors]]></title>
		<link>http://www.iredmail.org/forum/topic13512-installation-errors.html</link>
		<atom:link href="http://www.iredmail.org/forum/feed-rss-topic13512.xml" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Installation errors.]]></description>
		<lastBuildDate>Wed, 25 Oct 2017 15:03:30 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59500.html#p59500</link>
			<description><![CDATA[<p>Is this issue related to SOGo, SOGo Integrator or the SOGo Connector?</p><br /><p>EDIT: <br />Is sogo responsable for the table creation or is iRedmail supposed to do this on installation?</p>]]></description>
			<author><![CDATA[null@example.com (Wraptor)]]></author>
			<pubDate>Wed, 25 Oct 2017 15:03:30 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59500.html#p59500</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59492.html#p59492</link>
			<description><![CDATA[<div class="quotebox"><cite>Wraptor wrote:</cite><blockquote><p>2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;</p></blockquote></div><p>According to SOGo error message, i think the problem is SOGo doesn&#039;t support IPv6 address while parsing the setting. Please report this bug to SOGo team:<br /><a href="https://sogo.nu/support/index.html">https://sogo.nu/support/index.html</a></p>]]></description>
			<author><![CDATA[zhb@iredmail.org (ZhangHuangbin)]]></author>
			<pubDate>Wed, 25 Oct 2017 14:44:50 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59492.html#p59492</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59472.html#p59472</link>
			<description><![CDATA[<p>Yes I&#039;m using IPv6 as IPv4 is becoming Legacy imo.<br />The remote mysql server has the user sogo created by the iRedmail installer.</p><p>mysql&gt; show grants for sogo@&#039;xxxx:xxxx:xxxx:xxxx:xxxx::1&#039;;<br />+------------------------------------------------------------------------------------------------+<br />| Grants for sogo@xxxx:xxxx:xxxx:xxxx:xxxx::1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />+------------------------------------------------------------------------------------------------+<br />| GRANT USAGE ON *.* TO &#039;sogo&#039;@&#039;xxxx:xxxx:xxxx:xxxx:xxxx::1&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />| GRANT ALL PRIVILEGES ON `sogo`.* TO &#039;sogo&#039;@&#039;xxxx:xxxx:xxxx:xxxx:xxxx::1&#039;&nbsp; &nbsp; |<br />| GRANT SELECT ON `vmail`.`mailbox` TO &#039;sogo&#039;@&#039;xxxx:xxxx:xxxx:xxxx:xxxx::1&#039; |<br />+------------------------------------------------------------------------------------------------+<br />3 rows in set (0.00 sec)</p><br /><p>EDIT:<br />I googled the issue and it said something about not having the right default encoding, which should&#039;ve been UTF8. <br />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.</p>]]></description>
			<author><![CDATA[null@example.com (Wraptor)]]></author>
			<pubDate>Tue, 24 Oct 2017 18:22:42 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59472.html#p59472</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59451.html#p59451</link>
			<description><![CDATA[<div class="quotebox"><cite>Wraptor wrote:</cite><blockquote><p>2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;</p></blockquote></div><p>Are you using a IPv6 address for remote MySQL server?<br />Does sql user &quot;sogo&quot; have required privileges to create sql tables in &quot;sogo&quot; database on remote MySQL server?</p>]]></description>
			<author><![CDATA[zhb@iredmail.org (ZhangHuangbin)]]></author>
			<pubDate>Tue, 24 Oct 2017 00:57:21 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59451.html#p59451</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59446.html#p59446</link>
			<description><![CDATA[<p>Hey there</p><p>Really helpfull but i got another problem adn am wondergin if someone can help</p><div class="codebox"><pre><code>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 &quot;systemctl status nginx.service&quot; and &quot;journalctl -xe&quot; for details.
invoke-rc.d: initscript nginx, action &quot;start&quot; 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)</code></pre></div><br /><div class="codebox"><pre><code>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)
&lt;&lt; ERROR &gt;&gt; Installation failed, please check the terminal output.
&lt;&lt; ERROR &gt;&gt; If you&#039;re not sure what the problem is, try to get help in iRedMail
&lt;&lt; ERROR &gt;&gt; forum: http://www.iredmail.org/forum/</code></pre></div><br /><p>What is going wrong?</p>]]></description>
			<author><![CDATA[null@example.com (desolator)]]></author>
			<pubDate>Mon, 23 Oct 2017 15:15:43 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59446.html#p59446</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59442.html#p59442</link>
			<description><![CDATA[<p>I got it all installed but now sogo just isn&#039;t working, I checked the sogo log and found out that only 1 table (users) was being created.</p><p>I&#039;m using a remote mysql server, created an admin_iredmail user with all permissions (Including grant) and everything but sogo worked.</p><p>Remote mysql sogo table:<br />mysql&gt; use sogo;</p><p>Database changed<br />mysql&gt; show tables;<br />+----------------+<br />| Tables_in_sogo |<br />+----------------+<br />| users&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />+----------------+<br />1 row in set (0.00 sec)</p><p>Remote mysql users:<br />mysql&gt; select user from mysql.user;<br />+---------------------+<br />| user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />+---------------------+<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| xxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| admin_iredmail&nbsp; &nbsp; &nbsp; |<br />| amavisd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| iredadmin&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| iredapd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| sogo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />| vmail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| vmailadmin&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />| mysql.sys&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| root&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<br />+---------------------+<br />14 rows in set (0.00 sec)</p><p>/var/log/sogo/sogo.log:<br />2017-10-22 13:51:43.188 sogod[5810:5810] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />2017-10-22 13:51:43.188 sogod[5811:5811] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5811]: &lt;0x0x563100d387c0[WOHttpAdaptor]&gt; notified the watchdog that we are readyOct 22 13:51:43 sogod [5810]: &lt;0x0x563100d38ab0[WOHttpAdaptor]&gt; notified the watchdog that we are ready</p><p>Oct 22 13:51:43 sogod [5809]: &lt;0x0x563100dca670[WOWatchDog]&gt; child spawned with pid 5817<br />2017-10-22 13:51:43.188 sogod[5812:5812] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5812]: &lt;0x0x563100d38530[WOHttpAdaptor]&gt; notified the watchdog that we are readyOct 22 13:51:43 sogod [5809]: &lt;0x0x563100dca670[WOWatchDog]&gt; child spawned with pid 5818</p><p>Oct 22 13:51:43 sogod [5809]: &lt;0x0x563100dca670[WOWatchDog]&gt; child spawned with pid 5819<br />2017-10-22 13:51:43.192 sogod[5813:5813] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />2017-10-22 13:51:43.192 sogod[5815:5815] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />2017-10-22 13:51:43.192 sogod[5814:5814] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5815]: &lt;0x0x563100d1ee10[WOHttpAdaptor]&gt; notified the watchdog that we are readyOct 22 13:51:43 sogod [5813]: &lt;0x0x563100d37db0[WOHttpAdaptor]&gt; notified the watchdog that we are ready</p><p>Oct 22 13:51:43 sogod [5814]: &lt;0x0x563100d37120[WOHttpAdaptor]&gt; notified the watchdog that we are ready<br />2017-10-22 13:51:43.193 sogod[5817:5817] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5817]: &lt;0x0x563100cdb3a0[WOHttpAdaptor]&gt; notified the watchdog that we are ready<br />2017-10-22 13:51:43.196 sogod[5819:5819] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />2017-10-22 13:51:43.196 sogod[5816:5816] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5819]: &lt;0x0x563100ede830[WOHttpAdaptor]&gt; notified the watchdog that we are readyOct 22 13:51:43 sogod [5816]: &lt;0x0x563100cf9f90[WOHttpAdaptor]&gt; notified the watchdog that we are ready</p><p>2017-10-22 13:51:43.197 sogod[5818:5818] ERROR(+[GCSFolderManager defaultFolderManager]): default &#039;OCSFolderInfoURL&#039; is not a valid URL: &#039;mysql://sogo:SECRET@xxxx:xxxx:xxxx:xxxx:xxxx::1:3306/sogo/sogo_folder_info&#039;<br />Oct 22 13:51:43 sogod [5818]: &lt;0x0x563100f0a870[WOHttpAdaptor]&gt; notified the watchdog that we are ready<br />Oct 22 13:51:54 sogod [5818]: &lt;0x0x563100dc08c0[SOGoCache]&gt; Cache cleanup interval set every 300.000000 seconds<br />Oct 22 13:51:54 sogod [5818]: &lt;0x0x563100dc08c0[SOGoCache]&gt; Using host(s) &#039;127.0.0.1&#039; as server(s)<br />2017-10-22 13:51:54.411 sogod[5818:5818] EXCEPTION: &lt;NSException: 0x5631010ab6e0&gt; NAME:NSInvalidArgumentException REASON:Tried to add nil value for key &#039;users&#039; to dictionary INFO:{}<br />Oct 22 13:51:54 sogod [5818]: xx.xx.xx.xx &quot;GET /SOGo/ HTTP/1.0&quot; 501 0/0 0.012 - - 6M</p>]]></description>
			<author><![CDATA[null@example.com (Wraptor)]]></author>
			<pubDate>Mon, 23 Oct 2017 14:53:38 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59442.html#p59442</guid>
		</item>
		<item>
			<title><![CDATA[Re: Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59434.html#p59434</link>
			<description><![CDATA[<div class="quotebox"><cite>Wraptor wrote:</cite><blockquote><p>W: GPG error: <a href="https://packages.inverse.ca/SOGo/nightly/3/debian">https://packages.inverse.ca/SOGo/nightly/3/debian</a> stretch InRelease: The following signatures couldn&#039;t be verified because the public key is not available: NO_PUBKEY 19CDA6A9810273C4<br />W: The repository &#039;https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease&#039; is not signed.<br />N: Data from such a repository can&#039;t be authenticated and is therefore potentially dangerous to use.</p></blockquote></div><p>SOGo apt repo key was not imported.</p><p>You can try to import it manually, then run iRedMail installer again.<br /></p><div class="codebox"><pre><code>sudo apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4</code></pre></div>]]></description>
			<author><![CDATA[zhb@iredmail.org (ZhangHuangbin)]]></author>
			<pubDate>Mon, 23 Oct 2017 02:46:18 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59434.html#p59434</guid>
		</item>
		<item>
			<title><![CDATA[Installation errors]]></title>
			<link>http://www.iredmail.org/forum/post59422.html#p59422</link>
			<description><![CDATA[<p>==== Required information ====<br />- iRedMail version (check /etc/iredmail-release): v0.9.7<br />- Linux/BSD distribution name and version: Debian Stretch 9.2<br />- Store mail accounts in which backend (LDAP/MySQL/PGSQL):&nbsp; MySQL (Remote via <a href="http://iredmail.org/docs/install.iredmail.with.remote.mysql.server.html)">http://iredmail.org/docs/install.iredma … rver.html)</a><br />- Web server (Apache or Nginx): Nginx<br />- Manage mail accounts with iRedAdmin-Pro? No, modified Postfixadmin<br />- [IMPORTANT] Related original log or error message is required if you&#039;re experiencing an issue.<br />====</p><p>Installation log:</p><p>[ INFO ] Add apt repo for SOGo: <a href="https://packages.inverse.ca">https://packages.inverse.ca</a><br />[ INFO ] Import apt key (0x810273C4) for SOGo repo (<a href="https://packages.inverse.ca">https://packages.inverse.ca</a>).<br />Executing: /tmp/apt-key-gpghome.CTBWQZjs1v/gpg.1.sh --keyserver keys.gnupg.net --recv-key 0x810273C4<br />gpg: keyserver receive failed: Server indicated a failure<br />Executing: /tmp/apt-key-gpghome.hSkHqCyqC5/gpg.1.sh --keyserver pgp.mit.edu --recv-key 0x810273C4<br />gpg: keyserver receive failed: Server indicated a failure<br />[ INFO ] Resynchronizing the package index files (apt-get update) ...<br />Hit:1 <a href="http://security.debian.org/debian-security">http://security.debian.org/debian-security</a> stretch/updates InRelease<br />Ign:2 <a href="http://ftp.be.debian.org/debian">http://ftp.be.debian.org/debian</a> stretch InRelease<br />Hit:3 <a href="http://ftp.be.debian.org/debian">http://ftp.be.debian.org/debian</a> stretch-updates InRelease<br />Get:4 <a href="https://packages.inverse.ca/SOGo/nightly/3/debian">https://packages.inverse.ca/SOGo/nightly/3/debian</a> stretch InRelease [2540 B]<br />Hit:5 <a href="http://ftp.be.debian.org/debian">http://ftp.be.debian.org/debian</a> stretch Release<br />Ign:4 <a href="https://packages.inverse.ca/SOGo/nightly/3/debian">https://packages.inverse.ca/SOGo/nightly/3/debian</a> stretch InRelease<br />Fetched 2540 B in 0s (4545 B/s)<br />Reading package lists... Done<br />W: GPG error: <a href="https://packages.inverse.ca/SOGo/nightly/3/debian">https://packages.inverse.ca/SOGo/nightly/3/debian</a> stretch InRelease: The following signatures couldn&#039;t be verified because the public key is not available: NO_PUBKEY 19CDA6A9810273C4<br />W: The repository &#039;https://packages.inverse.ca/SOGo/nightly/3/debian stretch InRelease&#039; is not signed.<br />N: Data from such a repository can&#039;t be authenticated and is therefore potentially dangerous to use.<br />N: See apt-secure(8) manpage for repository creation and user configuration details.<br />[ 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<br />Reading package lists...<br />Building dependency tree...<br />Reading state information...<br />bzip2 is already the newest version (1.0.6-8.1).<br />cpio is already the newest version (2.11+dfsg-6).<br />cron is already the newest version (3.0pl1-128+b1).<br />bsdutils is already the newest version (1:2.29.2-1).<br />The following additional packages will be installed:<br />&nbsp; binutils clamav clamav-base clamdscan cpp cpp-6 debugedit dovecot-core<br />&nbsp; fontconfig-config fonts-dejavu-core gcc gcc-6 gnustep-base-common<br />&nbsp; gnustep-base-runtime gnustep-common gnustep-make gobjc gobjc-6 libaio1<br />&nbsp; libarchive-zip-perl libarchive13 libasan3 libatomic1 libauthen-sasl-perl<br />&nbsp; libavahi-client3 libavahi-common-data libavahi-common3 libberkeleydb-perl<br />&nbsp; libc-dev-bin libc6-dev libcc1-0 libcgi-fast-perl libcgi-pm-perl libcilkrts5<br />&nbsp; libclamav7 libconvert-binhex-perl libconvert-tnef-perl libconvert-uulib-perl<br />&nbsp; libcrypt-openssl-bignum-perl libcurl3 libdate-manip-perl libdbi-perl<br />&nbsp; libdigest-hmac-perl libencode-locale-perl liberror-perl libevent-2.0-5<br />&nbsp; libexttextcat-2.0-0 libexttextcat-data libfcgi-perl libfile-listing-perl<br />&nbsp; libfont-afm-perl libfontconfig1 libgc1c2 libgcc-6-dev libgd3<br />&nbsp; libgnustep-base1.24 libgomp1 libhtml-form-perl libhtml-format-perl<br />&nbsp; libhtml-parser-perl libhtml-tagset-perl libhtml-tree-perl<br />&nbsp; libhttp-cookies-perl libhttp-daemon-perl libhttp-date-perl<br />&nbsp; libhttp-message-perl libhttp-negotiate-perl libio-html-perl<br />&nbsp; libio-multiplex-perl libio-socket-inet6-perl libio-socket-ssl-perl<br />&nbsp; libio-stringy-perl libisl15 libitm1 libjansson4 libjbig0 libjemalloc1<br />&nbsp; libjpeg62-turbo libjson-c3 liblasso3 libllvm3.8 liblsan0 libltdl7<br />&nbsp; liblua5.2-0 liblwp-mediatypes-perl liblwp-protocol-https-perl liblzo2-2<br />&nbsp; libmailtools-perl libmariadbclient18 libmatheval1 libmemcached11<br />&nbsp; libmime-tools-perl libmpc3 libmpfr4 libmpx2 libnet-cidr-lite-perl<br />&nbsp; libnet-cidr-perl libnet-dns-perl libnet-http-perl libnet-ip-perl<br />&nbsp; libnet-libidn-perl libnet-patricia-perl libnet-server-perl<br />&nbsp; libnet-smtp-ssl-perl libnet-ssleay-perl libnetaddr-ip-perl<br />&nbsp; libnginx-mod-http-auth-pam libnginx-mod-http-dav-ext libnginx-mod-http-echo<br />&nbsp; libnginx-mod-http-geoip libnginx-mod-http-image-filter<br />&nbsp; libnginx-mod-http-subs-filter libnginx-mod-http-upstream-fair<br />&nbsp; libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libnspr4<br />&nbsp; libnss3 libobjc-6-dev libobjc4 libpgm-5.2-0 libpython2.7 libquadmath0<br />&nbsp; librpm3 librpmbuild3 librpmio3 librpmsign3 libsbjson2.3 libsocket6-perl<br />&nbsp; libsodium18 libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9<br />&nbsp; libsope-ldap4.9 libsope-mime4.9 libsope-xml4.9 libstemmer0d libsys-cpu-perl<br />&nbsp; libsys-hostname-long-perl libsys-meminfo-perl libterm-readkey-perl libtfm1<br />&nbsp; libtiff5 libtimedate-perl libtsan0 libubsan0 libunix-syslog-perl liburi-perl<br />&nbsp; libwavpack1 libwbxml2-0 libwebp6 libwww-perl libwww-robotrules-perl<br />&nbsp; libxmlsec1 libxmlsec1-openssl libxpm4 libxslt1.1 libyaml-0-2 libzmq5<br />&nbsp; linux-libc-dev make manpages-dev mariadb-client-10.1<br />&nbsp; mariadb-client-core-10.1 mariadb-common memcached mysql-common nginx-common<br />&nbsp; p7zip perl-openssl-defaults php-common php7.0-cli php7.0-common php7.0-fpm<br />&nbsp; php7.0-json php7.0-opcache php7.0-readline postfix-sqlite psmisc python-bs4<br />&nbsp; python-chardet python-cheetah python-flup python-html5lib python-markupsafe<br />&nbsp; python-pkg-resources python-six python-sqlalchemy-ext python-webencodings<br />&nbsp; python3-pyinotify python3-systemd re2c rpm-common rpm2cpio sa-compile<br />&nbsp; sope4.9-libxmlsaxdriver spamc ssl-cert tmpreaper unar uwsgi-core whois zip<br />Suggested packages:<br />&nbsp; dspam lhasa libnet-ldap-perl libsnmp-perl libzeromq-perl unrar binutils-doc<br />&nbsp; clamav-docs apparmor daemon cpp-doc gcc-6-locales rpm-i18n ntp<br />&nbsp; dovecot-gssapi dovecot-pgsql dovecot-sqlite dovecot-ldap dovecot-solr<br />&nbsp; dovecot-lucene ufw mailx monit gcc-multilib autoconf automake libtool flex<br />&nbsp; bison gdb gcc-doc gcc-6-multilib gcc-6-doc libgcc1-dbg libgomp1-dbg<br />&nbsp; libitm1-dbg libatomic1-dbg libasan3-dbg liblsan0-dbg libtsan0-dbg<br />&nbsp; libubsan0-dbg libcilkrts5-dbg libmpx2-dbg libquadmath0-dbg gnustep-base-doc<br />&nbsp; gnustep-make-doc gobjc-multilib gobjc-6-multilib libobjc4-dbg libgssapi-perl<br />&nbsp; glibc-doc libclamunrar7 libclone-perl libmldbm-perl libnet-daemon-perl<br />&nbsp; libsql-statement-perl libgd-tools libdata-dump-perl libcrypt-ssleay-perl<br />&nbsp; liblog-log4perl-perl libauthen-ntlm-perl fortune-mod make-doc<br />&nbsp; libcache-memcached-perl libmemcached libanyevent-perl libyaml-perl fcgiwrap<br />&nbsp; nginx-doc p7zip-rar ed diffutils-doc php-pear procmail postfix-pgsql<br />&nbsp; postfix-ldap postfix-lmdb sasl2-bin resolvconf postfix-cdb mail-reader<br />&nbsp; postfix-doc python-markdown python-pygments python-memcache python-genshi<br />&nbsp; python-jinja2-doc python-lxml-dbg python-lxml-doc default-mysql-server<br />&nbsp; | virtual-mysql-server python-egenix-mxdatetime python-mysqldb-dbg<br />&nbsp; python-setuptools libcurl4-gnutls-dev python-pycurl-dbg python-pycurl-doc<br />&nbsp; python-sqlalchemy-doc python-psycopg2 python-fdb python-pymssql<br />&nbsp; python-pyinotify-doc alien elfutils rpmlint rpm2html mysql-server razor<br />&nbsp; pyzor libencode-detect-perl libgeo-ip-perl openssl-blacklist pike7.8<br />&nbsp; | pike7.6 | pike uwsgi-plugins-all uwsgi-extra python-uwsgidecorators<br />The following NEW packages will be installed:<br />&nbsp; acl altermime amavisd-new arj binutils cabextract clamav clamav-base<br />&nbsp; clamav-daemon clamav-freshclam clamdscan cpp cpp-6 debugedit dovecot-core<br />&nbsp; dovecot-imapd dovecot-lmtpd dovecot-managesieved dovecot-mysql dovecot-pop3d<br />&nbsp; dovecot-sieve fail2ban fontconfig-config fonts-dejavu-core gcc gcc-6<br />&nbsp; gnustep-base-common gnustep-base-runtime gnustep-common gnustep-make gobjc<br />&nbsp; gobjc-6 libaio1 libarchive-zip-perl libarchive13 libasan3 libatomic1<br />&nbsp; libauthen-sasl-perl libavahi-client3 libavahi-common-data libavahi-common3<br />&nbsp; libberkeleydb-perl libc-dev-bin libc6-dev libcc1-0 libcgi-fast-perl<br />&nbsp; libcgi-pm-perl libcilkrts5 libclamav7 libconvert-binhex-perl<br />&nbsp; libconvert-tnef-perl libconvert-uulib-perl libcrypt-openssl-bignum-perl<br />&nbsp; libcrypt-openssl-rsa-perl libcurl3 libdate-manip-perl libdbd-mysql-perl<br />&nbsp; libdbi-perl libdigest-hmac-perl libencode-locale-perl liberror-perl<br />&nbsp; libevent-2.0-5 libexttextcat-2.0-0 libexttextcat-data libfcgi-perl<br />&nbsp; libfile-listing-perl libfont-afm-perl libfontconfig1 libgc1c2 libgcc-6-dev<br />&nbsp; libgd3 libgnustep-base1.24 libgomp1 libhtml-form-perl libhtml-format-perl<br />&nbsp; libhtml-parser-perl libhtml-tagset-perl libhtml-tree-perl<br />&nbsp; libhttp-cookies-perl libhttp-daemon-perl libhttp-date-perl<br />&nbsp; libhttp-message-perl libhttp-negotiate-perl libio-html-perl<br />&nbsp; libio-multiplex-perl libio-socket-inet6-perl libio-socket-ssl-perl<br />&nbsp; libio-stringy-perl libisl15 libitm1 libjansson4 libjbig0 libjemalloc1<br />&nbsp; libjpeg62-turbo libjson-c3 liblasso3 libllvm3.8 liblsan0 libltdl7<br />&nbsp; liblua5.2-0 liblwp-mediatypes-perl liblwp-protocol-https-perl liblz4-tool<br />&nbsp; liblzo2-2 libmail-dkim-perl libmail-spf-perl libmailtools-perl<br />&nbsp; libmariadbclient18 libmatheval1 libmemcached11 libmime-tools-perl libmpc3<br />&nbsp; libmpfr4 libmpx2 libnet-cidr-lite-perl libnet-cidr-perl libnet-dns-perl<br />&nbsp; libnet-http-perl libnet-ip-perl libnet-libidn-perl libnet-patricia-perl<br />&nbsp; libnet-server-perl libnet-smtp-ssl-perl libnet-ssleay-perl<br />&nbsp; libnetaddr-ip-perl libnginx-mod-http-auth-pam libnginx-mod-http-dav-ext<br />&nbsp; libnginx-mod-http-echo libnginx-mod-http-geoip<br />&nbsp; libnginx-mod-http-image-filter libnginx-mod-http-subs-filter<br />&nbsp; libnginx-mod-http-upstream-fair libnginx-mod-http-xslt-filter<br />&nbsp; libnginx-mod-mail libnginx-mod-stream libnspr4 libnss3 libobjc-6-dev<br />&nbsp; libobjc4 libpgm-5.2-0 libpython2.7 libquadmath0 librpm3 librpmbuild3<br />&nbsp; librpmio3 librpmsign3 libsbjson2.3 libsocket6-perl libsodium18<br />&nbsp; libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9 libsope-ldap4.9<br />&nbsp; libsope-mime4.9 libsope-xml4.9 libstemmer0d libsys-cpu-perl<br />&nbsp; libsys-hostname-long-perl libsys-meminfo-perl libterm-readkey-perl libtfm1<br />&nbsp; libtiff5 libtimedate-perl libtsan0 libubsan0 libunix-syslog-perl liburi-perl<br />&nbsp; libwavpack1 libwbxml2-0 libwebp6 libwww-perl libwww-robotrules-perl<br />&nbsp; libxmlsec1 libxmlsec1-openssl libxpm4 libxslt1.1 libyaml-0-2 libzmq5<br />&nbsp; linux-libc-dev logwatch lrzip lzop make manpages-dev mariadb-client<br />&nbsp; mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common memcached<br />&nbsp; mysql-common nginx-common nginx-full nomarch p7zip p7zip-full patch pax<br />&nbsp; perl-openssl-defaults php-common php-fpm php7.0-cli php7.0-common php7.0-fpm<br />&nbsp; php7.0-json php7.0-opcache php7.0-readline postfix postfix-mysql<br />&nbsp; postfix-pcre postfix-sqlite psmisc python-beautifulsoup python-bs4<br />&nbsp; python-chardet python-cheetah python-dnspython python-flup python-html5lib<br />&nbsp; python-jinja2 python-lxml python-markupsafe python-mysqldb python-netifaces<br />&nbsp; python-pkg-resources python-pycurl python-six python-sqlalchemy<br />&nbsp; python-sqlalchemy-ext python-webencodings python-webpy python3-pyinotify<br />&nbsp; python3-systemd re2c ripole rpm rpm-common rpm2cpio sa-compile sogo<br />&nbsp; sogo-activesync sope4.9-gdl1-mysql sope4.9-libxmlsaxdriver spamassassin<br />&nbsp; spamc ssl-cert tmpreaper tofrodos unar unrar-free unzip uwsgi uwsgi-core<br />&nbsp; uwsgi-plugin-python whois zip zoo<br />0 upgraded, 256 newly installed, 0 to remove and 0 not upgraded.<br />Need to get 134 MB of archives.<br />After this operation, 480 MB of additional disk space will be used.<br />WARNING: The following packages cannot be authenticated!<br />&nbsp; libwbxml2-0 libsbjson2.3 libsope-xml4.9 libsope-core4.9 libsope-mime4.9<br />&nbsp; libsope-appserver4.9 libsope-gdl1-4.9 libsope-ldap4.9<br />&nbsp; sope4.9-libxmlsaxdriver sope4.9-gdl1-mysql sogo sogo-activesync<br />E: There were unauthenticated packages and -y was used without --allow-unauthenticated<br />&lt;&lt; ERROR &gt;&gt; Installation failed, please check the terminal output.<br />&lt;&lt; ERROR &gt;&gt; If you&#039;re not sure what the problem is, try to get help in iRedMail<br />&lt;&lt; ERROR &gt;&gt; forum: <a href="http://www.iredmail.org/forum/">http://www.iredmail.org/forum/</a></p><br /><br /><p>Is it only the sogo repository or am I seeing this wrong?</p><p>Thanks in advance for the support<br />Wraptor</p>]]></description>
			<author><![CDATA[null@example.com (Wraptor)]]></author>
			<pubDate>Sun, 22 Oct 2017 06:25:13 +0000</pubDate>
			<guid>http://www.iredmail.org/forum/post59422.html#p59422</guid>
		</item>
	</channel>
</rss>
feed-rss-topic13512.xml (30,052 bytes)   
Wraptor

Wraptor

2017-10-25 15:43

reporter   ~0012401

Invalid iRedmail version in 'Steps to reproduce', should be v0.9.7.
Als Remote mysql server was used (Hence the ipv6 address and not 127.0.0.1 or ::1)

Issue History

Date Modified Username Field Change
2017-10-25 15:36 Wraptor New Issue
2017-10-25 15:36 Wraptor File Added: feed-rss-topic13512.xml
2017-10-25 15:43 Wraptor Note Added: 0012401
2018-01-12 19:07 ludovic Severity block => feature