The bridges are in bloom

This is a medium caption for this panel.

Find out where

Get ready for spring

Smallest caption here.

We show you how

Healthy ride to work

Caption goes here. This is a longer one, so we can test the varying size of our captions.

Check it out

Not a cloud in the sky

Description goes here in the default WordPress editor.

Learn more

ISPConfig — Add Database

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

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

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.

Continue reading “ISPConfig — Build and Configure”

ISPConfig3 — Add new FTP-User

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

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.

Continue reading “ISPConfig3 — Aamavisd –Can’t open PEM file”

ISPConfig — Setup Email Domain

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.

Continue reading “ISPConfig — Setup Email Domain”