1 Topic by mmarlowe

  • mmarlowe
  • Member
  • Offline
  • Registered: 2018-10-14
  • Posts: 1

Topic: New install on Ubuntu w/ Sogo 18.04

Ubuntu 18.04 fresh install w/ Sogo.. Receiving an error:


Err:1 https://packages.inverse.ca/SOGo/nightly/4/ubuntu bionic/bionic amd64 sogo amd64 4.0.2.20181009-1
  404  Not Found [IP: 192.95.20.194 443]
Err:2 https://packages.inverse.ca/SOGo/nightly/4/ubuntu bionic/bionic amd64 sogo-activesync amd64 4.0.2.20181009-1
  404  Not Found [IP: 192.95.20.194 443]
E: Failed to fetch https://packages.inverse.ca/SOGo/nightl … _amd64.deb  404  Not Found [IP: 192.95.20.194 443]
E: Failed to fetch https://packages.inverse.ca/SOGo/nightl … _amd64.deb  404  Not Found [IP: 192.95.20.194 443]


Appears those files do not in fact exist, but I am not understanding where / why it's trying to download those versions?

----

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

2 Reply by aon740505 (edited by aon740505 2018-10-15 00:49:27)

  • aon740505
  • Member
  • Offline
  • Registered: 2018-10-14
  • Posts: 1

Re: New install on Ubuntu w/ Sogo 18.04

I got the same error, checked inverse.ca, 20181009-1 has been removed, new one is 20181013, for some reason it is not picking the new one???

This started this morning 0:00 (Oct 13), I installed iredmail with SOGO yesterday(Oct 12) was fine.


Update: issue was resolved, it is good now.

3 Reply by abu.sayeed (edited by abu.sayeed 2018-10-14 17:57:26)

  • abu.sayeed
  • Member
  • Offline
  • Registered: 2017-11-21
  • Posts: 2

Re: New install on Ubuntu w/ Sogo 18.04

I install iRedMail 0.9.7
I want to upgrade 0.9.8

/etc/apt/sources.list.d/sogo-nightly.list
deb https://packages.inverse.ca/SOGo/nightly/4/ubuntu xenial xenial


apt-get update
apt-get install --only-upgrade sogo sogo-activesync

bash /usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh

Username (root): sogo
Hostname (127.0.0.1):
Database (sogo):
This script will ask for the database password twice
Converting c_content from TEXT to LONGTEXT in the sogo_user_profile table
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
Enter password:
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'



dpkg -L sogo | grep 'sql-update'
/usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0.sh
/usr/share/doc/sogo/sql-update-1.2.2_to_1.3.0-mysql.sh
/usr/share/doc/sogo/sql-update-1.3.11_to_1.3.12.sh
/usr/share/doc/sogo/sql-update-20080303.sh
/usr/share/doc/sogo/sql-update-2.2.17_to_2.3.0.sh
/usr/share/doc/sogo/sql-update-1.3.3_to_1.3.4-mysql.sh
/usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh
/usr/share/doc/sogo/sql-update-101_to_102.sh
/usr/share/doc/sogo/sql-update-1.2.2_to_1.3.0.sh
/usr/share/doc/sogo/sql-update-1.3.16_to_1.3.17-mysql.sh
/usr/share/doc/sogo/sql-update-2.0.4b_to_2.0.5-mysql.sh
/usr/share/doc/sogo/sql-update-3.0.0-to-combined-mysql.sh
/usr/share/doc/sogo/sql-update-1.3.11_to_1.3.12-mysql.sh
/usr/share/doc/sogo/sql-update-3.0.0-to-combined.sh
/usr/share/doc/sogo/sql-update-1.3.16_to_1.3.17.sh
/usr/share/doc/sogo/sql-update-2.2.17_to_2.3.0-mysql.sh
/usr/share/doc/sogo/sql-update-1.3.3_to_1.3.4.sh
/usr/share/doc/sogo/sql-update-20070822.sh
/usr/share/doc/sogo/sql-update-20070724.sh


tail -f /var/log/sogo/sogo.log

ct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec4af0[WOWatchDogChild]> sending terminate signal to pid 1373
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec4110[WOWatchDogChild]> sending terminate signal to pid 1372
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3f60[WOWatchDogChild]> sending terminate signal to pid 1371
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3c90[WOWatchDogChild]> sending terminate signal to pid 1370
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3970[WOWatchDogChild]> sending terminate signal to pid 1369
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eba800[WOWatchDogChild]> sending terminate signal to pid 1368
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb94c0[WOWatchDogChild]> sending terminate signal to pid 1367
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb8a30[WOWatchDogChild]> sending terminate signal to pid 1366
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb8880[WOWatchDogChild]> sending terminate signal to pid 1365
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb85b0[WOWatchDogChild]> sending terminate signal to pid 1364
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb8a30[WOWatchDogChild]> child 1366 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3970[WOWatchDogChild]> child 1369 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3f60[WOWatchDogChild]> child 1371 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec3c90[WOWatchDogChild]> child 1370 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb94c0[WOWatchDogChild]> child 1367 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eba800[WOWatchDogChild]> child 1368 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec4110[WOWatchDogChild]> child 1372 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb8880[WOWatchDogChild]> child 1365 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398eb85b0[WOWatchDogChild]> child 1364 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> Terminating with SIGINT or SIGTERM
Oct 14 05:16:44 sogod [1315]: <0x0x55f398ec4af0[WOWatchDogChild]> child 1373 exited
Oct 14 05:16:44 sogod [1315]: <0x0x55f398efe280[WOWatchDog]> all children exited. We now terminate.
Oct 14 05:16:45 sogod [3361]: version 4.0.2 (build @shiva2.inverse 201810140449) -- starting
Oct 14 05:16:45 sogod [3361]: vmem size check enabled: shutting down app when vmem > 500 MB. Currently at 224 MB
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb23fc70[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb23fc70[SOGoProductLoader]>   MailerUI.SOGo, CommonUI.SOGo, Mailer.SOGo, ActiveSync.SOGo, Contacts.SOGo, MainUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo, MailPartViewers.SOGo, PreferencesUI.SOGo, ContactsUI.SOGo, Appointments.SOGo
Oct 14 05:16:45 sogod [3361]: All products loaded - current memory usage at 278 MB
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> listening on 127.0.0.1:20000
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> watchdog process pid: 3361
Oct 14 05:16:45 sogod [3361]: <0x0x7f039edf9240[WOWatchDogChild]> watchdog request timeout set to 61 minutes
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> preparing 10 children
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3364
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3365
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3366
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3367
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3368
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3369
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3370
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3371
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3372
Oct 14 05:16:45 sogod [3361]: <0x0x5591eb0390c0[WOWatchDog]> child spawned with pid 3373
Oct 14 05:16:45 sogod [3366]: <0x0x5591eb4a3160[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 14 05:16:45 sogod [3368]: <0x0x5591eb4a3160[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 14 05:16:45 sogod [3365]: <0x0x5591eb4a3160[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 14 05:16:45 sogod [3367]: <0x0x5591eb4a3160[WOHttpAdaptor]> notified the watchdog that we are ready
Oct 14 05:16:45 sogod [3364]: <0x0x5591eb4a3160[WOHttpAdaptor]> notified the watchdog that we are ready


What is my wrong?

Please help me.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: New install on Ubuntu w/ Sogo 18.04

mmarlowe wrote:

Err:1 https://packages.inverse.ca/SOGo/nightly/4/ubuntu bionic/bionic amd64 sogo amd64 4.0.2.20181009-1
  404  Not Found [IP: 192.95.20.194 443]

This is SOGo nightly apt repo, old files may be removed and new files will be added every day (or few days), seems this was caused during the change, or old local apt cache data.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: New install on Ubuntu w/ Sogo 18.04

abu.sayeed wrote:

ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'

This should be safe to ignore.

6 Reply by romeu

  • romeu
  • Member
  • Offline
  • Registered: 2016-03-01
  • Posts: 3

Re: New install on Ubuntu w/ Sogo 18.04

On the last releases you will need to install apt-transport-https before iRedMail if you want Sogo.

so:

apt-get install -y apt-transport-https