1 Topic by cre8r

  • cre8r
  • Member
  • Offline
  • Registered: 2014-03-25
  • Posts: 47

Topic: iredapd db information

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

Hi,
We have upgraded a build , there was an issue with iredapd database and it has been replaced with an empty db.
Do have have the full structure required for all iredapd db settings/data (iredapd.greylisting etc)? as we need to repopulate this db.

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

Re: iredapd db information

*) What kind of upgrade will remove all SQL tables in iredapd database?
*) To re-create the sql tables, found sql templates below, import "iredapd.mysql" first, then "greylisting_whitelist_domains.sql".
https://bitbucket.org/zhb/iredapd/src/default/SQL/

3 Reply by cre8r

  • cre8r
  • Member
  • Offline
  • Registered: 2014-03-25
  • Posts: 47

Re: iredapd db information

Thanks, This works good.
It was my mistake , not the upgrade procedure.

Thanks.