ISPConfig — Add Database

Posted on November 26, 2017 by admin under Uncategorized
Leave a comment

This procedure will illustrate how to add a database using the ISPConfig3 interface. Although this can, and sometimes must, be done using phpMyAdmin, or a console client, I use the ISPConfig3 interface first if possible.

  1. Logon to the ISPConfig3 admin interface.
  2. Select the Sites tab.
  3. Select Databases from the menu on the left.
  4. Select the Add new Database button.
  5. Select the Site from the dropdown.
    • This is the site for which the database is being created.
  6. Enter the Database name.
    • Note that the Database name field is prefixed with c[CLIENTID]d[DOMAINID] making each one uniq and allowing for the remaining portion of the name to be the same.
  7. Select the Database user from the dropdown.
    • If you do not have a database user, once can be assigned later. Until then only admin will be able to access the database. To create one now, follow the ISPConfig — Add Database User procedure.
  8. Select the Save button.

 

ISPConfig — Add Database User

Posted on by admin under Uncategorized
11 Comments

When database access is desired, database users are created. These users are then considered the owner’s of the databases they create.

  1. Logon to the ISPConfig3 admin interface.
  2. Select the Sites tab
  3. Select Database Users from the menu on the left.
  4. Select the Add new User button.
  5. Select the appropriate client from the Client dropdown.
  6. Enter the Database user name in the field.
    • Note the c[CLIENTID] portion ofthe database user field? This ensures each client has a uniq name. As one database user can own multiple databases, for multiple sites, you do not need to create a uniq id for each domain.
  7. Enter the Password for the user, or select the Generate Password button.
  8. Confirm the password by entering it again in the Repeat Password area.
  9. Select the Save button.

 

ISPConfig — Build and Configure

Posted on November 23, 2017 by admin under ISPConfig
Leave a comment

Purpose

I have been “playing around” with ISPConfig3 for a while now, learning some of the in’s and out’s, and now it is time to build my first production, hopefully, system.

This document illustrate the process, mainly to keep track of what is being done.

I am essentially following the documents on HowtoForge for a CentOS 7.3 Minimal Server and The Perfect Server for the ISPConfig3 portion. By default, these documents build everything on one server and we won’t change that either.

Read More

ISPConfig3 — Add new FTP-User

Posted on by admin under ISPConfig
1 Comment

This is the procedure for adding a new site ftp user account.

  1. Log onto your ISPConfig3 admin interface.
  2. Select the Sites tab.
  3. Select FTP-Accounts from the menu on the left.
  4. Select the Add new FTP-User button.
  5. From the Website dropdown, select the appropriate site.
  6. Enter the user id in the Username field.
  7. Enter the password in the Password field, or select the Generate Password button.
  8. Confirm the password by entering it in the Repeat Password field.
  9. Ensure the Active checkbox is selected.
  10. Select the Save button.

ISPConfig3 — Aamavisd –Can’t open PEM file

Posted on by admin under ISPConfig
1 Comment

The full error on my system was;

ispconfig3 amavisd: Error in config file “/etc/amavisd/amavisd.conf”: Error in config file “/etc/amavisd/60-dkim”: Can’t open PEM file /var/lib/amavis/dkim/quantumleaps.com.private: Permission denied at /usr/sbin/amavisd line 637.

 

I ran into this issue a couple of times, so i figured I would write it down.

Read More

Validate Email is Working Properly

Posted on by admin under General
Leave a comment

This post is a procedure for testing the email services at quantumleaps.com.

The same process should work for your system, just change the domain name as needed.

Read More

ISPConfig — Add new Mailbox

Posted on by admin under ISPConfig
Leave a comment

This post illustrates how to create a new mailbox for an existing mail domain. If you haven’t created an email domain, see ISPConfig — Setup Email Domain and then return.

Read More

Validate DNS is Working Properly

Posted on November 22, 2017 by admin under General
Leave a comment

This post is a procedure for testing the DNS services at quantumleaps.com.

The same process should work for your system, just change the domain name as needed.

Read More

ISPConfig3 — Add SPF Record

Posted on by admin under ISPConfig
1 Comment

SPF, Sender Policy Framework are DNS entries that are used to list the mail server which should be considered valid for a given domain. When an email is received, a DNS lookup of the TXT record containing the SPF data is queried and the data is analyzed to determine if the server is allowed. If it is then it passed that spam filter check.

Read More

ISPConfig — Setup Email Domain

Posted on by admin under ISPConfig
1 Comment

Most sites offer email as a service, and with ISPConfig, setting up email for a domain is an easy process.

In this post we will setup email for the quantumleaps.com domain.

  1. Logon to your ISPConfig3 admin interface.
  2. Select the Email tab.
  3. Select the Add new Domain button.
  4. Select the Client from the dropdown.
  5. Enter quantumleaps.com in the Domain field.
  6. Select the Save button.

Read More