1 Topic by ddiazjda

  • ddiazjda
  • Member
  • Offline
  • Registered: 2014-10-07
  • Posts: 1

Topic: Bulk import of email accounts and password reset on first login

Hello,

I apologize if im asking a repeated topic, but most of my searches haven't yielded much in he way of answers. I am using iRedMail version 0.8.7 with the MySQL backend, and have a need to create many email accounts (over 10K).

1. IS there a way to import from a CSV file? I am aware of the script in the tools directory but would that work for the MySQL DB?
2. Would I be able to import all of these accounts with the same password and then run a script to force a password reset upon first login through RoundCube?
3. Are any of these features available through the Pro version?

Thanks,




==== Required information ====
- iRedMail version: 0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS
- Related log if you're reporting an issue:
====

----

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: Bulk import of email accounts and password reset on first login

ddiazjda wrote:

1. IS there a way to import from a CSV file? I am aware of the script in the tools directory but would that work for the MySQL DB?

Yes, that script works for MySQL.

ddiazjda wrote:

2. Would I be able to import all of these accounts with the same password and then run a script to force a password reset upon first login through RoundCube?

*) To import with same password: YES.
*) To force password reset, you need a iRedAPD plugin: sql_force_change_password_in_days. Below is quote from plugin source file:

How iRedAPD plugin 'sql_force_change_password_in_days' works wrote:

# How it works:
#
#   - iRedMail configures plugin 'password' of Roundcube webmail to store
#     password change date in SQL database `vmail`, column
#     `mailbox.passwordlastchange`.
#
#   - This plugin checks date stored in `mailbox.passwordlastchange` and
#     compare it with current date. if password last change date is longer
#     than specified days, this plugin rejects smtp session with specified
#     message.

ddiazjda wrote:

3. Are any of these features available through the Pro version?

Unfortunately, neither of them are available in the latest iRedAdmin-Pro release.

3 Reply by tostapiej

  • tostapiej
  • Member
  • Offline
  • Registered: 2014-11-29
  • Posts: 1

Re: Bulk import of email accounts and password reset on first login

Is there a possibility that this would be available in the pro version?

4 Reply by ZhangHuangbin

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

Re: Bulk import of email accounts and password reset on first login

tostapiej wrote:

Is there a possibility that this would be available in the pro version?

We do have plan to provide this feature in iRedAdmin-Pro. Please be patient. smile