1 Topic by dublea

  • dublea
  • Member
  • Offline
  • Registered: 2016-10-21
  • Posts: 4

Topic: Postmaster inbox questions

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version: Ubuntu Server 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:
====

I was receiving thousands of emails regarding outdated formatting in some scripts but have since resolved it.  Now I am finally receiving Logwatch emails.  But, along with it, every day I receive 8 emails regarding SQL backups.  Many of which show all the warnings the system receives when using the password in cmd line.  But, overall show success.  Is it normal to receive that many daily for backups.  Along with those I am receiving another 8 about "/roundcubemail/bin/cleandb.sh >/dev/null"  All 8 show the following content:

PHP Warning:  Declaration of rcmail::get_instance($env = '') should be compatible with rcube::get_instance($mode = 0, $env = '') in /opt/www/roundcubemail-1.1.5/program/include/rcmail.php on line 30

Any assistance that can be provided would be helpful.  Thanks!

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: Postmaster inbox questions

*) For the PHP warning, if you're running PHP 7 on Ubuntu 16.04, upgrading Roundcube to the latest 1.2.2 will fix your issue.

*) You didn't paste output/error related to other cron jobs, cannot help at all. But it's expected to receive only one email related to backup, not 8.

3 Reply by dublea (edited by dublea 2016-11-01 20:44:29)

  • dublea
  • Member
  • Offline
  • Registered: 2016-10-21
  • Posts: 4

Re: Postmaster inbox questions

ZhangHuangbin wrote:

*) For the PHP warning, if you're running PHP 7 on Ubuntu 16.04, upgrading Roundcube to the latest 1.2.2 will fix your issue.

*) You didn't paste output/error related to other cron jobs, cannot help at all. But it's expected to receive only one email related to backup, not 8.

Here is one of them:

mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/mysql-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/amavisd-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/iredapd-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/sogo-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/roundcubemail-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
bzip2: Output file /var/vmail/backup/mysql/2016/11/01/iredadmin-2016-11-01-03:30:01.sql.bz2 already exists.
mysql: [Warning] Using a password on the command line interface can be insecure.
==> Backup completed successfully.
==> Detailed log (/var/vmail/backup/mysql/2016/11/01/2016-11-01-03:30:01.log):
=========================
* Starting backup: 2016-11-01-03:30:01.
* Backup directory: /var/vmail/backup/mysql/2016/11/01.
* Backing up databases: vmail iredadmin mysql amavisd iredapd sogo roundcubemail iredadmin.
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
128K    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
12K    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* Delete old backup: /var/vmail/backup/mysql/2016/08/03.
* Suppose to delete: /var/vmail/backup/mysql/2016/08/03
* File size:
----
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
1.9M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
1.9M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
1.7M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
2.6M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
2.6M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
0    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
2.6M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
4.0K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).
* File size:
----
40K    amavisd-2016-11-01-03:30:01.sql
8.0K    amavisd-2016-11-01-03:30:01.sql.bz2
2.6M    iredadmin-2016-11-01-03:30:01.sql
20K    iredadmin-2016-11-01-03:30:01.sql.bz2
52K    iredapd-2016-11-01-03:30:01.sql
4.0K    iredapd-2016-11-01-03:30:01.sql.bz2
1.2M    mysql-2016-11-01-03:30:01.sql
184K    mysql-2016-11-01-03:30:01.sql.bz2
112K    roundcubemail-2016-11-01-03:30:01.sql
24K    roundcubemail-2016-11-01-03:30:01.sql.bz2
8.0K    sogo-2016-11-01-03:30:01.sql
4.0K    sogo-2016-11-01-03:30:01.sql.bz2
8.0K    vmail-2016-11-01-03:30:01.sql.bz2
----
* Backup completed (Success? YES).

Also, is the install directly for roundcubemail that is included in the latest version of iredmail located in /opt/www/roundcubemail-1.2.2?  Just want to verify before I follow roundcubemail's upgrade instructions.  Thanks!

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: Postmaster inbox questions

You have duplicate database names in /var/vmail/backup/backup_mysql.sh.

dublea wrote:

Also, is the install directly for roundcubemail that is included in the latest version of iredmail located in /opt/www/roundcubemail-1.2.2?  Just want to verify before I follow roundcubemail's upgrade instructions.  Thanks!

Check our tutorial:
http://www.iredmail.org/docs/file.locations.html

5 Reply by dublea (edited by dublea 2016-11-02 01:14:41)

  • dublea
  • Member
  • Offline
  • Registered: 2016-10-21
  • Posts: 4

Re: Postmaster inbox questions

ZhangHuangbin wrote:

You have duplicate database names in /var/vmail/backup/backup_mysql.sh.

dublea wrote:

Also, is the install directly for roundcubemail that is included in the latest version of iredmail located in /opt/www/roundcubemail-1.2.2?  Just want to verify before I follow roundcubemail's upgrade instructions.  Thanks!

Check our tutorial:
http://www.iredmail.org/docs/file.locations.html

THANKS!  I had used the self installer, wondering how 'iredadmin' DB had two entries under 'export DATABASES' but it is now reduced to one entry.  Next is to update roundcubemail to 1.2.2.  I do appreciate all the advice!

UPDATE:  I've upgrade roundcubemail to 1.2.2 and will now wait and see what transpires tonight with both jobs.  I'll add an update once I verify.

6 Reply by dublea

  • dublea
  • Member
  • Offline
  • Registered: 2016-10-21
  • Posts: 4

Re: Postmaster inbox questions

Welp, didn't work the first day.  So I check the version of RoundCubeMail in the about to find it still shows as 1.1.5.  Thinking that running the install.sh in the 1.2.2 bin dir while specifying the install path didn't appear to update anything, I followed their manual upgrade instructions.  Now, when I log into the portal I can see where my mail would be but nothing loads.  Nor can I interact with anything on the page or log out.  Luckily this is all for learning so now I get to figure out what got borked.

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,165

Re: Postmaster inbox questions

Check its log file to figure out why it doesn't work.
FYI: http://www.iredmail.org/docs/file.locat … #roundcube