ISPmail Admin

Documentation

Installation

  1. Requirements
    • Webserver: Any will do as long as PHP is supported. It must not even be on the same server as the mailserver database as long as it can access it.
    • PHP: Any version above 5.0 (the mysqli extension is built in). I recommend the latest.
    • MySql: Version 4.1.13 or newer, or 5.0.7 or newer.
    • Write access to the database: The ISPmail guide rightfully limited the database user mailuser to readonly. ISPmail Admin naturally needs write access to the mailserver database.
    • Javascript and cookies:: The browser you intend to use ISPmail Admin with needs Javascript and cookies enabled.
  2. Prepare database user
    The ISPmail guide rightfully limited the database user mailuser to readonly. ISPmail Admin naturally needs write access to the mailserver database. So there are two possibilites: Grant write access to the mailuser (not recommended) or create a new user (e.g. mailadmin) with read/write access.
    • Method 1, recommended: Create user mailadmin with read/write access:
      Run the following SQL–commands on the database server:
      GRANT SELECT, UPDATE, INSERT, DELETE on `mailserver`.* TO 'mailadmin'@'127.0.0.1' IDENTIFIED BY 'password';
      FLUSH PRIVILEGES;
      SHOW GRANTS FOR 'mailadmin'@'127.0.0.1';
      The last should show that it has worked and is in effect.
    • Method 2: Grant write access to the mailuser:
      Run the following SQL–commands on the database server:
      GRANT SELECT, UPDATE, INSERT, DELETE on `mailserver`.* TO 'mailuser'@'127.0.0.1';
      FLUSH PRIVILEGES;
      SHOW GRANTS FOR 'mailadmin'@'127.0.0.1';
      The last should show that it has worked and is in effect.
  3. Download ISPmail Admin
  4. Extract the archive into an appropriate directory
  5. Modify cfg/config.inc.php:
    /**
    **
    **
    ** @package    ISPmail_Admin
    ** @author     Ole Jungclaussen
    ** @version    0.9.0
    /**
    ** Database access
    **
    **/
    define('IMA_CFG_DB_HOST',     '127.0.0.1');
    define('IMA_CFG_DB_PORT',     '3306');
    define('IMA_CFG_DB_USER',     'mysqluser');
    define('IMA_CFG_DB_PASSWORD', 'password');
    define('IMA_CFG_DB_DATABASE', 'mailserver');
    /**
    ** access control: uncomment the type you want to use.
    **
    **/
    // define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ACCOUNT);
    // define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ADM);    
    // define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ADMAUTO);
    /**
    ** Define the administrator's name and password.
    **
    **/
    define('IMA_CFG_ADM_USER',  'user');     // admin username
    define('IMA_CFG_ADM_PASS',  'pass');     // admin password
    
    • Set the database access information (IMA_CFG_DB_ ...)
    • Set the ISPmail Admin access (login) type by uncommenting (remove the leading "//") the line with the method you want to use:
      • "define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ACCOUNT)":
        Only one user will administrate ISPmail Admin but all users with an email–account may login (using their password) and manage aliases for their accounts.
      • "define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ADM)":
        Only one user will use ISPmail Admin and that is the administrator.
      • "define('IMA_CFG_LOGIN', IMA_LOGINTYPE_ADMAUTO)":
        Same as above, but when you've protected ISPmail Admin behind a .htaccess username and password, another login is not really needed.
    • Set the ISPmail Admin administrative user and his password (IMA_CFG_ADM_ ...). Use a strong password, yes? Please?
  6. Open index.php in your browser