1 Topic by schnappi

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Topic: iRedMail without iRedAdmin/ web services amavis database cleanup

Running iRedMail without webservices or iRedAdmin. iRedAdmin handles the cleaning of the amavis database. Can the cleanup_amavisd_db.py file be copied from another server and used standalone to clean the amavis database?

This post also seems relevant to this issue for anyone else dealing with this: http://www.iredmail.org/forum/topic4350 … nence.html

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Debian 9.1
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): NA
- Manage mail accounts with iRedAdmin-Pro? No
====

----

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,163

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

You can try this:

- Download the latest iRedAdmin, copy it to any folder you prefer
- Configure its config file 'settings.py'
- Run 'cleanup_amavisd_db.py' manually to make sure it works
- Setup cron job to run cleanup_amavisd_db.py regularly.

This way iRedAdmin is not running (no network port or http access), and you still have the script to clean up db.

3 Reply by schnappi

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

Thanks. Just got around to doing this so no rush on reply. See a "settings.py.mysql.sample" file in the iRedAdmin root. Should this file be configured before renaming this file to "settings.py" or is the "settings.py" file actually located elsewhere? Was not able to locate any such standalone file in the iRedAdmin folder.

4 Reply by ZhangHuangbin

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

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

iRedAdmin config file is "settings.py" under the iRedAdmin directory.

5 Reply by schnappi (edited by schnappi 2017-11-01 00:19:57)

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

Neat to see that the forum now has SSL support.

When editing the settings.py file need to reset the password for the following database: amavisd
(since long deleted the email that receive upon iRedMail install with database passwords, and not even sure if this email comes if do not install iRedAdmin).

When changing these database passwords are there any files in iRedMail that will need the database password updated as a result?

6 Reply by ZhangHuangbin

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

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

Amavisd config file contains sql password too.

7 Reply by schnappi (edited by schnappi 2017-11-09 07:59:56)

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

All of this works great.

To summarize running "cleanup_amavisd_db.py" after editing the setting.py works fine even without iRedAdmin or the web control panel installed.

Any suggestions as to anything else that need to do to keep databases clean that iRedAdmin otherwise does?

Otherwise issue successfully resolved.

8 Reply by ZhangHuangbin

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

Re: iRedMail without iRedAdmin/ web services amavis database cleanup

schnappi wrote:

Any suggestions as to anything else that need to do to keep databases clean that iRedAdmin otherwise does?

"tools/cleanup_db.py" under same directory of cleanup_amavisd_db.py.