The Perfect Server - Ubuntu 18.04 (Bionic Beaver) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

This tutorial shows the installation of an Ubuntu 18.04 (Bionic Beaver) web hosting server with Apache 2.4, Postfix, Dovecot, Bind and PureFTPD to prepare it for the installation of ISPConfig 3.1. The resulting system will provide a Web, Mail, Mailinglist, DNS and FTP Server.

ISPConfig is a web hosting control panel that allows you to configure the following services through a web browser: Apache or Nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of Nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

1. Preliminary Note

In this tutorial, I use the hostname server1.example.com with the IP address 192.168.1.100 and the gateway 192.168.1.1  These settings might differ for you, so you have to replace them where appropriate.  Before proceeding further you need to have a basic minimal installation of Ubuntu 18.04 as explained in the tutorial.

The commands in this tutorial have to be run with root permissions. To avoid adding sudo in front of each command, you'll have to become root user by running:

sudo -s

before you proceed.

2. Edit /etc/apt/sources.list And Update Your Linux Installation

Edit /etc/apt/sources.list. Comment out or remove the installation CD from the file and make sure that the universe and multiverse repositories are enabled. It should look like this afterwards:

nano /etc/apt/sources.list
#

# deb cdrom:[Ubuntu-Server 18.04 LTS _Bionic Beaver_ - Release amd64 (20180425.1)]/ bionic main restricted

#deb cdrom:[Ubuntu-Server 18.04 LTS _Bionic Beaver_ - Release amd64 (20180425.1)]/ bionic main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://de.archive.ubuntu.com/ubuntu/ bionic main restricted
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates main restricted
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://de.archive.ubuntu.com/ubuntu/ bionic universe
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic universe
deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates universe
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://de.archive.ubuntu.com/ubuntu/ bionic multiverse
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic multiverse
deb http://de.archive.ubuntu.com/ubuntu/ bionic-updates multiverse
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://de.archive.ubuntu.com/ubuntu/ bionic-backports main restricted universe multiverse
# deb-src http://de.archive.ubuntu.com/ubuntu/ bionic-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu bionic partner
# deb-src http://archive.canonical.com/ubuntu bionic partner

deb http://security.ubuntu.com/ubuntu bionic-security main restricted
# deb-src http://security.ubuntu.com/ubuntu bionic-security main restricted
deb http://security.ubuntu.com/ubuntu bionic-security universe
# deb-src http://security.ubuntu.com/ubuntu bionic-security universe
deb http://security.ubuntu.com/ubuntu bionic-security multiverse
# deb-src http://security.ubuntu.com/ubuntu bionic-security multiverse

Then run

apt-get update

to update the apt package database and

apt-get upgrade

to install the latest updates (if there are any). If you see that a new kernel gets installed as part of the updates, you should reboot the system afterwards:

reboot

 

3. Change the Default Shell

/bin/sh is a symlink to /bin/dash, however we need /bin/bash, not /bin/dash. Therefore, we do this:

dpkg-reconfigure dash

Use dash as the default system shell (/bin/sh)? <-- No

If you don't do this, the ISPConfig installation will fail.

4. Disable AppArmor

AppArmor is a security extension (similar to SELinux) that should provide extended security. In my opinion, you don't need it to configure a secure system, and it usually causes more problems than advantages (think of it after you have done a week of trouble-shooting because some service wasn't working as expected, and then you find out that everything was ok, only AppArmor was causing the problem). Therefore, I disable it (this is a must if you want to install ISPConfig later on).

We can disable it like this:

service apparmor stop
update-rc.d -f apparmor remove
apt-get remove apparmor apparmor-utils

5. Synchronize the System Clock

It is a good idea to synchronize the system clock with an NTP (network time protocol) server over the Internet when you run a physical server. In case you run a virtual server then you should skip this step. Just run

apt-get -y install ntp

and your system time will always be in sync.

6. Install Postfix, Dovecot, MariaDB, rkhunter, and binutils

For installing postfix, we need to ensure that sendmail is not installed and running. To stop and remove sendmail run this command:

service sendmail stop; update-rc.d -f sendmail remove

The error message:

Failed to stop sendmail.service: Unit sendmail.service not loaded.

Is ok, it just means that sendmail was not installed, so there was nothing to be removed.

Now we can install Postfix, Dovecot, MariaDB (as MySQL replacement), rkhunter, and binutils with a single command:

apt-get -y install postfix postfix-mysql postfix-doc mariadb-client mariadb-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d dovecot-mysql dovecot-sieve dovecot-lmtpd sudo

You will be asked the following questions:

General type of mail configuration: <-- Internet Site
System mail name: <-- server1.example.com

It is important that you use a subdomain as "system mail name" like server1.example.com or server1.yourdomain.com and not a domain that you want to use as email domain (e.g. yourdomain.tld) later.

Next, open the TLS/SSL and submission ports in Postfix:

nano /etc/postfix/master.cf

Uncomment the submission and smtps sections as follows - add the line -o smtpd_client_restrictions=permit_sasl_authenticated,reject to both sections and leave everything thereafter commented:

[...]
submission inet n       -       y       -       -       smtpd
  -o syslog_name=postfix/submission
  -o smtpd_tls_security_level=encrypt
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING
smtps     inet  n       -       y       -       -       smtpd
  -o syslog_name=postfix/smtps
  -o smtpd_tls_wrappermode=yes
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING
[...]

NOTE: The whitespaces in front of the "-o .... " lines are important!

Restart Postfix afterward:

service postfix restart

We want MySQL to listen on all interfaces, not just localhost. Therefore, we edit /etc/mysql/mariadb.conf.d/50-server.cnf and comment out the line bind-address = 127.0.0.1:

nano /etc/mysql/mariadb.conf.d/50-server.cnf
[...]
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1

[...]

Now we set a root password in MariaDB. Run:

mysql_secure_installation

You will be asked these questions:

Enter current password for root (enter for none): <-- press enter
Set root password? [Y/n] <-- y
New password: <-- Enter the new MariaDB root password here
Re-enter new password: <-- Repeat the password
Remove anonymous users? [Y/n] <-- y
Disallow root login remotely? [Y/n] <-- y
Reload privilege tables now? [Y/n] <-- y

Set the password authentication method in MariaDB to native so we can use PHPMyAdmin later to connect as root user:

echo "update mysql.user set plugin = 'mysql_native_password' where user='root';" | mysql -u root

Edit the file /etc/mysql/debian.cnf and set the MYSQL / MariaDB root password there twice in the rows that start with password.

nano /etc/mysql/debian.cnf

The MySQL root password that needs to be added is shown in read, in this example the password is "howtoforge".

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = root
password = howtoforge
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = root
password = howtoforge
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

Then we restart MariaDB:

service mysql restart

Now check that networking is enabled. Run

netstat -tap | grep mysql

The output should look like this:

[email protected]:~# netstat -tap | grep mysql
tcp6 0 0 [::]:mysql [::]:* LISTEN 30591/mysqld
[email protected]:~#

7. Install Amavisd-new, SpamAssassin, and Clamav

To install amavisd-new, SpamAssassin, and ClamAV, we run

apt-get -y install amavisd-new spamassassin clamav clamav-daemon unzip bzip2 arj nomarch lzop cabextract apt-listchanges libnet-ldap-perl libauthen-sasl-perl clamav-docs daemon libio-string-perl libio-socket-ssl-perl libnet-ident-perl zip libnet-dns-perl postgrey

The ISPConfig 3 setup uses amavisd which loads the SpamAssassin filter library internally, so we can stop SpamAssassin to free up some RAM:

service spamassassin stop
update-rc.d -f spamassassin remove

To start ClamAV use:

freshclam
service clamav-daemon start

The following error can be ignored on the first run of freshclam.

ERROR: /var/log/clamav/freshclam.log is locked by another process
ERROR: Problem with internal logger (UpdateLogFile = /var/log/clamav/freshclam.log).

The amavisd-new program has currently a bug in Ubuntu 18.04 which prevents that emails get signed with Dkim correctly. Run the following commands to patch amavisd-new.

cd /tmp
wget https://git.ispconfig.org/ispconfig/ispconfig3/raw/stable-3.1/helper_scripts/ubuntu-amavisd-new-2.11.patch
cd /usr/sbin
cp -pf amavisd-new amavisd-new_bak
patch < /tmp/ubuntu-amavisd-new-2.11.patch

In case you get an error for thelast 'patch' command, then Ubuntu has probably fixed the issue in the meantime, so it should be safe to ignore that error then.

7.1 Install Metronome XMPP Server (optional)

The Metronome XMPP Server provides an XMPP chat server. This step is optional, if you do not need a chat server, then you can skip this step. No other ISPConfig functions depend on this software.

Install the following packages with apt.

apt-get -y install git lua5.1 liblua5.1-0-dev lua-filesystem libidn11-dev libssl-dev lua-zlib lua-expat lua-event lua-bitop lua-socket lua-sec luarocks luarocks
luarocks install lpc

Add a shell user for Metronome.

adduser --no-create-home --disabled-login --gecos 'Metronome' metronome

Download Metronome to the /opt directory and compile it.

cd /opt; git clone https://github.com/maranda/metronome.git metronome
cd ./metronome; ./configure --ostype=debian --prefix=/usr
make
make install

Metronome has now be installed to /opt/metronome.

Share this page:

Suggested articles

63 Comment(s)

Add comment

Comments

By: lnxgs at: 2018-05-28 17:26:59

Hi,

I installed fail2ban, but on ispconfig control panel on show fail2ban-log I get this error:

fail2ban is not installed on this server.See more (for debian) here...

O.s: Ubuntu 18.04 and last ispconfig.

Regards,

L.

By: John at: 2018-05-29 10:31:06

Can we additional PHP version in this instalation? Like PHP 5.6 and PHP 7.1 ?

By: Danny at: 2018-06-04 12:55:09

I cant seem to use phpmyadmin.

The username password are correct because if i use a username with wrong password it will tell me its wrong.

cant seem to find a correct answer...

By: Raysv at: 2018-06-08 08:55:17

Hi, 

Followed this to the letter, but when trying to send outgoing mails from the webmail client just results in "Authentication faied", roundcube logs also shows that, but with no more info. 

Any suggestion?

By: till at: 2018-06-08 09:08:33

 Or you configured roundcube to connect to a different host than lokalhost. Compare your postfix master.cf with the one from this tutorial.common mistakes are that you might have not removed the # in front of the submission and smtps lines. If you need further help, then please post here: https://www.howtoforge.com/community/forums/installation-configuration.27/

By: djesys at: 2018-06-11 11:36:06

Thank you !

How do we get mailman to work though ?

journalctl -xe:

 

-- Unit mailman.service has begun starting up.

Jun 11 14:31:22 b0x mailmanctl[1748]: Site list is missing: mailman

Jun 11 14:31:22 b0x systemd[1]: mailman.service: Control process exited, code=exited status=1

Jun 11 14:31:22 b0x systemd[1]: mailman.service: Failed with result 'exit-code'.

Jun 11 14:31:22 b0x systemd[1]: Failed to start Mailman Master Queue Runner.

-- Subject: Unit mailman.service has failed

-- Defined-By: systemd

-- Support: http://www.ubuntu.com/support

--

-- Unit mailman.service has failed.

--

-- The result is RESULT.

By: till at: 2018-06-11 11:45:39

Ensure that you created the 'mailman' mailinglist as described in chapter 10 by using the command 'newlist mailman'.

By: djesys at: 2018-06-12 09:59:13

How can I access phpmyadmin ? I tried http://ip.ip.ip.ip:8081/phpmyadmin as in was in a previous tutorial.

 

By: till at: 2018-06-12 11:56:58

You mix up apache and nginx servers here. On a nginx server, phpmyadmin is on port 8081, on an apache server, phpmyadmin is on port 80.

By: vincent1890 at: 2018-06-27 21:20:44

No link for download ovf/ova

By: till at: 2018-06-28 06:05:55

The download link is in the menu on the right side of the page, directly below the big red download icon. If you don't see a menu on the right side, then turn off your ad blocker in case you have one installed. Some ad blockers are buggy remove whole web page columns and menus here on howtoforge.

By: Julian at: 2018-06-27 21:58:25

Uncommenting the #bind-address line in the MariaDB config has no effect, it's documented in the comment above that the default is already to bind to localhost (127.0.0.1). You would only uncomment that line if you wanted to change the bind address to another interface.

By: till at: 2018-06-28 06:05:08

> You would only uncomment that line if you wanted to change the bind address to another interface.

And that's exactly why you shall uncomment it in this tutorial. Please follow the tutorial closely, otherwise, the setup will not be fully working and you would not be able to configure access to MySQL databases in ISPConfig.

By: Corey at: 2018-06-28 16:08:35

Do you have a tutorial coming for clustering that works with this tutorial? I see the Debian 8.4 one on the site but not sure if that would work well with the Perfect Server tutorial?

By: helios842000 at: 2018-06-30 14:28:23

Hi, I have a vbulletin forum that only runs under php 5.6, it is possible to add this version as it was proposed for version 16.04? thanks

By: Bjoern at: 2018-07-06 23:09:15

Let's encrypt only worked after the instructions in the manual, that means after the manual installation of the script. Since it is not allowed to publish parts of the script, I ask the author of the manual to do so.

By: till at: 2018-07-09 08:24:30

Let's encrypt works fine when installed according to this tutorial, the steps from ISPConfig manual were not required on any of my servers that I run with Ubuntu 18.04. So there must have done something else wrong the first time you installed Let's encrypt.-

By: Kazuto at: 2018-07-08 15:27:41

I can't access phpmyadmin. ip:80 nor ip:8081 works.

By: till at: 2018-07-09 08:28:28

PHPMyAdmin is on port 80 on Apache servers like used in this setup. If you can't reach it, then you missed enabling it for apache during installation as shown in this tutorial. You can fix that by running:

 

dpkg-reconfigure phpmyadmin

By: bill at: 2018-07-11 19:25:06

First, Thanks for the great software and the hours of tech support you have given over many years.

If not too much trouble, please post somewhere how to properly setup composer and git such that the ISPConfig user works. I have found bits a pieces in the forum and thru google but nothing consice. So much is going to a composer only install, it would be a real benefit.

Thanks,

By: heero at: 2018-07-12 05:27:36

Hi,

I followed the guide step by step but I cannot access my domain. The domain that I created was through VirtualBox. I don't know if that could affect anything?

By: ggmanugg at: 2018-07-17 15:08:45

Perfekte Anleitung. Detailliert und funktioniert fehlerfrei :) Weiter so!

By: keith at: 2018-07-18 17:45:57

I followed the tutorial on 18.04 as I have done countless times on older versions of ubuntu. I get a white screen on .php files, but normal .html loads just fine./var/logs shows nothing that help?

By: till at: 2018-07-19 16:27:04

Check the apache error.log of the website to find out why PHP fails in your server. If you need more help, post in the forum.

By: Evelyn at: 2018-07-21 00:36:09

Just a couple of tips for others...

if the server is NATed and you want to specify to specify a passive port range for FTPd.

40110-40210 in this example:

echo "40110 40210" > /etc/pure-ftpd/conf/PassivePortRange

And/Or Force FTPd to announce an external ip address:

echo "[server_ip_here]" > /etc/pure-ftpd/conf/ForcePassiveIP

And do a restart

/etc/init.d/pure-ftpd-mysql restart

 

To adjust the phpmysql upload size, 10 megs in this example:

nano /etc/php/7.2/apache2/php.ini

max_upload_size = 10M

save and do a

service apache2 restart

 

By: Darko at: 2018-07-23 08:02:05

Thank you! Can you do a updated Debian one ? The one here is OLD now.

By: Mario at: 2018-07-30 21:24:27

I made all the tutorial, but i like how to see a website that i add in ispconfig

By: till at: 2018-07-31 06:53:30

Open a web browser and enter the domain name of the site that you added in ISPConfig. The domain name must exist in DNS and point to the IP address of your server.

By: Johan at: 2018-08-19 14:31:43

 I end up with the dev version when installing ispconfig with this link in the manual , had to run a update after installation , and i did use stable during first installation.

wget -O ispconfig.tar.gz https://git.ispconfig.org/ispconfig/ispconfig3/repository/archive.tar.gz?ref=stable-3.1

 

By: till at: 2018-08-20 09:05:25

This is the stable branch, so all is fine. 3.1dev is not the master or unstable branch.

By: Johan at: 2018-08-26 08:45:51

dev means development for the rest of the world , development is not a stable version (it could be stable but doesn't need to be). Please reconsider the naming or the file to download as after an update the version changed to 3.1.13 (except for the database , that stayed on version 3.1dev)

By: Herbert at: 2018-09-02 14:24:32

Thks for wonderful tutorial keep it up

By: Antonino at: 2018-09-08 12:12:12

I got an error during the installation of amavis, sorry but I have only a short error message:

ExecStart=/etc/init.d/amavis start (code=exited, status=1/FAILURE)

BTW fixed so

nano /etc/amavis/conf.d/05-node_id

Uncomment the host the and set the following

$myhostname ="myhost.mydomain.it";

 

Maybe will be useful for other

 

ciao

 

By: Antonino at: 2018-09-08 14:20:12

As usual "Perfect Tutorial"

 

- My personal suggest

https://www.ispconfig.org/documentation

 

- My Main question

I just finish to install a new VPS

I have a vps with ubuntu 16 and the last ispconfig installed. I need to migrate it to the new installation.

I know how to do it manually, but if there are some short ways, they are the welcome.

 

Manual steps :

a) Setup Isp Config (Clients, sites and so on)

  I will use 2 chrome windows to make the same configuration (copy and paste from one to the second) :-(

b) Copy websites folders from remote vps to the new one:

   scp from remote and than chown...

c) Import mysql dump databases

d) Enable the new ISPConfig installation with Let's Encrypt for website (already done in the old current vps)

I don't know how to procede

e) Try to understand is there is a way to enable ispconfig panel to use a valid and public SSL certificate (let's encrypt)

I don't know how to do it

 

ISPConfig guide pdf talks about MASTER and SLAVE but atm I just only need to import from the old current vps or do all import process manually.

I am sure, I am not the 1st one that needs to migrate an old installation to a new one.

Any suggestions?

thanks

 

By: Connor at: 2018-09-11 18:25:10

So I'm getting this error when trying to install amavisd-new on debian 9. I know that this guide is for ubuntu, but literally everything here has functioned perfectly besides amavisd-new. This is a copy of part of the terminal output of apt-get -y install amavisd-new.

 

 

Setting up amavisd-new (1:2.10.1-4) ...

Creating/updating amavis user account...

Job for amavis.service failed because the control process exited with error code.

See "systemctl status amavis.service" and "journalctl -xe" for details.

invoke-rc.d: initscript amavis, action "start" failed.

? amavis.service - LSB: Starts amavisd-new mailfilter

   Loaded: loaded (/etc/init.d/amavis; generated; vendor preset: enabled)

   Active: failed (Result: exit-code) since Tue 2018-09-11 09:49:11 PDT; 7ms ago

     Docs: man:systemd-sysv-generator(8)

  Process: 29673 ExecStart=/etc/init.d/amavis start (code=exited, status=1/FAILURE)

 

Sep 11 09:49:11 gibsonhomeserver amavis[29673]:   The value of variable $myhostname is "gibsonhomeserver",…e been

Sep 11 09:49:11 gibsonhomeserver amavis[29673]:   a fully qualified domain name; perhaps uname(3) did not … such.

Sep 11 09:49:11 gibsonhomeserver amavis[29673]:   You must explicitly assign a FQDN of this host to variab…stname

Sep 11 09:49:11 gibsonhomeserver amavis[29673]:   in /etc/amavis/conf.d/05-node_id, or fix what uname(3) p…host's

Sep 11 09:49:11 gibsonhomeserver amavis[29673]:   network name!

Sep 11 09:49:11 gibsonhomeserver amavis[29673]: (failed).

Sep 11 09:49:11 gibsonhomeserver systemd[1]: amavis.service: Control process exited, code=exited status=1

Sep 11 09:49:11 gibsonhomeserver systemd[1]: Failed to start LSB: Starts amavisd-new mailfilter.

Sep 11 09:49:11 gibsonhomeserver systemd[1]: amavis.service: Unit entered failed state.

Sep 11 09:49:11 gibsonhomeserver systemd[1]: amavis.service: Failed with result 'exit-code'.

Hint: Some lines were ellipsized, use -l to show in full.

dpkg: error processing package amavisd-new (--configure):

 subprocess installed post-installation script returned error exit status 1

Errors were encountered while processing:

 amavisd-new

E: Sub-process /usr/bin/dpkg returned an error code (1)

By: till at: 2018-09-11 18:40:43

Your server uses an invalid hostname and that's what amavis complains about. See Ubuntu base server tutorial, chapter 8, on how to configure the hostname of an Ubuntu server: https://www.howtoforge.com/tutorial/ubuntu-lts-minimal-server/2/ After you fixed the hostname, rerun the failed command to install amavis and then continue with the tutorial.

By: mercury at: 2018-09-16 08:13:47

Followed the instruction above. Everything was fine but cannot open phpmyadmin seems something wrong. Sorry i am new to servers Need help.

Thanks

By: till at: 2018-09-17 08:31:00

Then you did not select 'apache2' during phpmyadmin installation. Options must be activated with the space bar in apt to activate them. Use command:

 

dpkg-reconfigure phpmyadmin

 

to redo the phpmyadmin setup and activate it for apache2 this time.

By: Kamil at: 2018-09-17 20:15:16

Hi Till,

First of all, thank you so much for brilliant work on this tutorial! I followed it step by step in order to try to build our own small webhosting server for our projects and it is finally working! I just sent some money to support the ISPConfig development and to get a e-book with documentation.

Today I moved the first testing web running on WordPress and logged-in to the phpmyadmin to import the database and I'm still getting this error even when I just open some table without doing anything else:

 

Warning in ./libraries/sql.lib.php#613

count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)

./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(

array,

boolean true,

string 'c1zivotnadovolene',

string 'wp_options',

NULL,

NULL,

NULL,

NULL,

NULL,

NULL,

string '',

string './themes/pmahomme/img/',

NULL,

NULL,

NULL,

string 'SELECT * FROM `wp_options`',

NULL,

NULL,

)

./sql.php#221: PMA_executeQueryAndSendQueryResponse(

array,

boolean true,

string 'c1zivotnadovolene',

string 'wp_options',

NULL,

NULL,

NULL,

NULL,

NULL,

NULL,

string '',

string './themes/pmahomme/img/',

NULL,

NULL,

NULL,

string 'SELECT * FROM `wp_options`',

NULL,

NULL,

)

Please, would you be so kind and could you tell me if you have an idea what could be the problem?

Thank you so much for your help,

Kamil

By: till at: 2018-09-18 05:45:03

Thank you very much for supporting ISPConfig! In regard to the issue, that's a bug in the phpMyAdmin package from Ubuntu- It exists for months now, I have no idea why they don't fix it as phpMyAdmin is such a widely used software. Here are the instructions on how to fix it on your server until Ubuntu delivers a fixed package: https://stackoverflow.com/questions/48001569/phpmyadmin-count-parameter-must-be-an-array-or-an-object-that-implements-co

By: Kamil at: 2018-09-18 15:27:21

Hi Till,

Thank you so much for you help! I have tried it and used this solution:

Edit file /usr/share/phpmyadmin/libraries/sql.lib.php:

sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php

Replace: count($analyzed_sql_results['select_expr'] == 1)

With: (count($analyzed_sql_results['select_expr']) == 1)

Restart the server

 

sudo service apache2 restart

But when I added just one "(" it is showing me still some errors. If I put there two "((" it doesnt show the previous error but it shows Error 500, Internal server errror so there is still something wrong... 

Which solution of all of them on the link you gave me should be used for fixing the problem, please?

I am sorry, but I am not a experienced still enough in Linux and still learning a lot of things every day... 

Thank you and have a nice day,

Kamil

 

By: Bernd at: 2018-09-20 12:43:06

Hi At first thanks for the great tutorial (and all the others you provide).In chapter "7.1 Install Metronome XMPP Server" there is a little problem as the command "luarocks install lpc" needs gcc. so you need to install this first.

By: Matt G at: 2018-09-28 05:27:15

installed ISPConfig by download from the ISPConfig.org site

kept getting a 'Not allowed' with the wget string in the instructions

It installs OK but then when i go to 'local-ip-addy:9000' it takes me to the standard "it works" page

when i goto 'local-ipaddy:9000/ipconfig i get

uses('tpl'); $app->tpl->....

Any Help would be great!

Thanks

Matt

By: till at: 2018-09-28 05:56:32

Hi Matt, the wget command works fine here, just tested it. Please make a post in the ispconfig forum here at howtoforge so we can help you debugging your issue.

By: Wim at: 2018-10-05 18:40:08

I was puzzled by the comment near the Postfix installation "It is important that you use a subdomain as "system mail name" like server1.example.com or server1.yourdomain.com and not a domain that you want to use as email domain (e.g. yourdomain.tld) later." My server has no subdomains. So how should I explain this?

I got errors for the Amavis command:

Setting up postgrey (1.36-5) ...

Warning: The home dir /var/lib/postgrey you specified can't be accessed: No such file or directory

And later:

Creating/updating amavis user account...

Job for amavis.service failed because the control process exited with error code              .

See "systemctl status amavis.service" and "journalctl -xe" for details.

invoke-rc.d: initscript amavis, action "start" failed.

? amavis.service - LSB: Starts amavisd-new mailfilter

   Loaded: loaded (/etc/init.d/amavis; generated)

   Active: failed (Result: exit-code) since Fri 2018-10-05 17:42:01 UTC; 14ms ago

     Docs: man:systemd-sysv-generator(8)

  Process: 24268 ExecStart=/etc/init.d/amavis start (code=exited, status=1/FAILURE)

Oct 05 17:42:00 ubuntu-s-1vcpu-2gb-ams3-perenboom systemd[1]: Starting LSB: Starts amavisd-new mailfilter...

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]: Starting amavisd:   The value of variable $myhostname is "bilbil", but should have been

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]:   a fully qualified domain name; perhaps uname(3) did not provide such.

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]:   You must explicitly assign a FQDN of this host to variable $myhostname

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]:   in /etc/amavis/conf.d/05-node_id, or fix what uname(3) provides as a host's

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]:   network name!

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom amavis[24268]: (failed).

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom systemd[1]: amavis.service: Control process exited, code=exited status=1

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom systemd[1]: amavis.service: Failed with result 'exit-code'.

Oct 05 17:42:01 ubuntu-s-1vcpu-2gb-ams3-perenboom systemd[1]: Failed to start LSB: Starts amavisd-new mailfilter.

dpkg: error processing package amavisd-new (--configure):

 installed amavisd-new package post-installation script subprocess returned error exit status 1

By: Rholand at: 2018-10-11 22:29:40

You're missing apt install mysql-server

By: till at: 2018-10-12 06:40:22

No, that's not missing. The setup uses MariaDB instead of MySQL and when you read the guide, then you'll see that the package mariadb-server gets installed.

By: Curtis Maurand at: 2018-10-25 01:10:39

Hello,

A change for Ubuntu 18.04.  All of the commands can still use service and update-rc.d, but given the systemctl bits of ubuntu, they should be used going forward.  just IMHO

systemctl stop apparmor

systemctl disable apparmor

apt-get -y remove apparmor apparmor-utils

 

systemctl stop sendmail; systemctl disable sendmail

the errors will be:

Failed to stop sendmail.service: Unit sendmail.service not loaded.

Failed to disable unit: unit file sendmail.service does not exsit.

systemctl postfix restart

systemctl restart mysql

systemctl stop spamassassin

systemctl disable spamassassin

systemctl start clamav-daemon

 

Regards, Curtis

By: Mateus at: 2018-10-31 16:48:28

my vps is hostinger, and the / etc / fstab file contains the lines: proc / proc proc defaults 0 0 none / dev / pts devpts wr, gid = 5, mode620 0 0 none / run / shm tmpfs default 0 0 Where to insert the ,usrjquota = quota.user, grpjquota = quota.group, jqfmt = vfsv0 ??

By: till at: 2018-10-31 17:20:13

Skip editing the fstab and proceed with the next step. The VPS you use seems to not have a mount point for the root filesystem in fstab.

By: ruliezz at: 2018-11-08 20:53:31

Instead of disabling AppArmor you should better deep dive in learning AppArmor and make your application ready for AppArmor. This quote is an excuse not to learn AppArmor: "it usually causes more problems than advantages". Instead of that lets learn AppArmor and try to dance with it instead of disable it: https://wiki.ubuntu.com/AppArmor

By: NBElite at: 2018-11-14 13:36:19

Thanks :)

By: Ben at: 2018-11-21 20:52:39

I installed a new ubuntu client 18.04. After successful completion I completed all your steps for the perfect server.

I did not do the chat stuff. When I go to https://myserverip:8080 in any browser I set the site is not secure. The only browser I can use is IE when I click run anyway (not recommended). I do not own any certificates. I was assuming the one you set up was a free one. Is there anyway around this with out buying certificates.

 

By: till at: 2018-11-22 08:35:38

You installed a so-called 'self-signed' SSL certificate, so the warning that you get in the browser is ok and not an error. If you want to install an SSL cert from let's encrypt instead, use this guide: https://www.howtoforge.com/tutorial/securing-ispconfig-3-with-a-free-lets-encrypt-ssl-certificate/

By: CarliumYT at: 2018-11-22 15:28:32

 Hello,

When I try to login to the IP adress, my server refuses me to log on, can anyone help me with this? I've tried with different browsers. They say that there is a problem with the internet connection or that the line is too busy. 

- I use a virtual machine (VM box)

- I've tried with different browsers on the VM and desktop.

can anyone help me with this?

Carl

By: Ben Spradling at: 2018-11-23 19:48:43

Hello: I am a novice ubuntu user. I have successfully installed ubuntu 18.04 fresh. Following your turorial I have run into several problems. My confusion comes in where to user server1.example.com. I am assuming this should be my server host name and one of my domain names so I used webserver.spradlings.com. Your also used howtoforge as a password. I used that but when I try to do the phpmyadmin installation it says invalid password. I have also tried a password I used in eariler steps. Should I use my own password instead of howtofoge.

By: till at: 2018-11-26 07:44:41

Yes, use your own password.

By: Lococoyote at: 2018-11-24 19:38:56

Trying to edit the sources.list results in opening a file that has only three lines in it which are all http://archive.ubuntu.com/ubunto did I miss something?

Thanks

By: Vic at: 2018-11-29 15:42:51

Hi,

In the synchronization step (5. Synchronize the System Clock), I execute it in my vps, it is possible, to undo it.

Regards.

By: willriker at: 2018-11-30 18:00:00

hi, i follow your step w/o to find any problem, but sometimes, the most simple things are dificult to solve, in may case , when i use ispconfig (like client) for create my site and my mail, which is the mail server name ( for MX record)???? i only know my name in the instalation process of postfix, but, because this is a multidomain server, i cannot find config file of postfix for each client/domain. tx in advance

By: Tamas Amon at: 2018-12-06 10:20:36

For me does not working the ispconfig. How i see after install there is no documentroot in my apache config file. How I see there must be mod_fcgid support or mpm_itk_module. How can Iinstall it?

By: till at: 2018-12-06 10:28:49

mpm_itk is not required and it is not recommended to install it. mod_fcgid is installed as part of this tutorial, if you don't have it installed, then you did not follow this guide closely. This tutorial has 3 pages, start with page one and follow it to the letter until the end of page 3 and you will have a fully functional ISPConfig server setup.

By: CarliumYT at: 2018-12-07 21:10:24

 Hi!

I'vegone throught he whole guide, but I can't seem to be able to log into ISPconfig. Any Ideas to what I can do? I would like a respnse ASAP, since this is a school project.

I use:

*A virtual machine

*Ubuntu server 18.04

*Firefox as web-browser

The error message in the browser: "The server at 192.168.0.100 is taking too long to respond."

 

Any help will be deebly aprischiated!

 

Sincerely

Carl M.