Comments on The Perfect Server - Ubuntu 17.10 (Artful Aardvark) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

Could I upgrade a installation of ispconfig with ubuntu 17.04 with this tut?

I tried to install clean ubuntu 17.10 also update from version 17.04. In both cases, apc did not work. It remains functional only apcu. I do not update this, maybe later  :)

The old APC is not used anymore and not even available for PHP 7.1, it has been replaced by Opcache plus APCu as described in the tutorial.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory"

sudo /etc/init.d/mysql start

(https://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq)

This error occurs due to multiple installations of mysql. Run the command:

ps -A|grep mysql

Kill the process by using:

sudo pkill mysql

and then run command:

ps -A|grep mysqld

Also Kill this process by running:

sudo pkill mysqld

Now you are fully set just run the following commands:

service mysql restart mysql -u root -p

Have very well working mysql again

please, where is the Virtual machine image download of this tutorial for this tutorial?

In the menu on the right side at the top. Right below the big red download icon. If you donÄt see that icon and the download link, then you probably use an ad blocker. There are some faulty ad blockers out there which remove the complete content of the right menu at Howtoforge and not just the ads.

Many thanks for your usefull tutorial

Two notes that I sugget to add in it:

1 if doing 

mysql_secure_installation

you get

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

then just reboot the PC and repeat the command.

2 if accessing yuoursite.com/phpmyadmin

you get a blank page or phpmyadmin access denied for user 'root'@'localhost'

just clear the cache of your browser and retry.

Ciao Aldo

I had to do this to make FTP work properly:

echo "29799 29899" > /etc/pure-ftpd/conf/PassivePortRange

am I the only one?

I also needed to reboot to continue installation for this reason :

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Other than that, so far so good. Awesome tutorial. Respect to all who keep this going :)

following these instructions for 18.04 ... note that php7.1 needs to be changed to php7.2 and mycryp has to be replaced by sodium or openssl

Now Ubuntu 18.04 is out. Is there going to be a new version of the tutorial for the 18.04? If yes, when could we expect to see it? Thanks.

Of course there will be a new tutorial. It will get published when ISPConfig supports Ubuntu 18.04, which will be in ISPConfig version 3.1.12.

Thanks, Till, for your prompt and informative reply! I am looking forward to seeing your new tutorial.

 

***HELP ME ON DigitalOcean*** 

 

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 Mon 2018-05-07 20:09:10 UTC; 10ms ago

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

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

      CPU: 521ms

 

May 07 20:09:10 JAN amavis[7082]: Starting amavisd:   The value of variable $myhostname is "JAN", but should have been

May 07 20:09:10 JAN amavis[7082]:   a fully qualified domain name; perhaps uname(3) did not provide such.

May 07 20:09:10 JAN amavis[7082]:   You must explicitly assign a FQDN of this host to variable $myhostname

May 07 20:09:10 JAN amavis[7082]:   in /etc/amavis/conf.d/05-node_id, or fix what uname(3) provides as a host's

May 07 20:09:10 JAN amavis[7082]:   network name!

May 07 20:09:10 JAN amavis[7082]: (failed).

May 07 20:09:10 JAN systemd[1]: amavis.service: Control process exited, code=exited status=1

May 07 20:09:10 JAN systemd[1]: Failed to start LSB: Starts amavisd-new mailfilter.

May 07 20:09:10 JAN systemd[1]: amavis.service: Unit entered failed state.

May 07 20:09:10 JAN systemd[1]: amavis.service: Failed with result 'exit-code'.

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)

 

The server hostname is wrong. The hostname must be a fully qualified domain name, amavisd will not start othewise. Check /etc/hostname file and /etc/hosts file and correct the hostname there so that the command hostname -f returns a fully qualified domain as hostname.

Internal Server Error

ON HTTPS

After the apparently successful installation, I enter the server's ip (digitalocean) because I have not yet been approved for the change of the DNS of my domain .com.ve, should I wait for the approval of the domain? or it is a bad installation  

This is a very well done tutorial. Every step worked perfectly, as described.

I had just a couple of small problems because in one case I didn't followed exactly one step and in another case because of a small difference in my distribution.

Your effort is very much appreciated.

If you got an error "ERROR 2002 (HY000): Can't connect to local MySQL server throug........."

when try to mysql_secure_installation

activate mysql service

same error with ubuntu 14, 16 and now 17. I can connect trough ftp:

TLS connection established.

Command: USER mihaigrecu

Response: 331 User mihaigrecu OK. Password required

Command: PASS ********

Response: 530 Login authentication failed

Error: Critical error: Could not connect to server

 

same error, i am desperate :(