Comments on The Perfect Server - Ubuntu 15.04 (Vivid Vervet) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3

you wrote several times "MariaDB" but you mean "MySQL"

This tutorial installs MariaDB and not MySQL. The systemd unit of the MariaDB Software is named mysql for compatibility reasons but its still MariaDB that gest restarted and not MySQL.

The Link to additional PHP-Versions is wrong (has the "file" protocol) - as in the previous Tutorials

Thanks, I fixed that.

MariaDB should be preferred over mysql these days. The title is wrong even if the steps are for mariadb.

No FTP should even be discussed. FTP should have died out (or been killed off) in 1995.  sFTP, which is built-into openssh-server, should be used.  Since 2000, nobody should run plain FTP. That isn't just my opinion - it is the opinion of security experts worldwide.

You are partially right about the title, the problem is that not everyone knows that mariadb is a full mysql replacement and poeple are still seeking for a guide with MySQL and not MariaDB due to that fact. This tutorials installs FTP with TLS (FTPS), so the connection is secured. FTPS has some advantages on hosting servers (shared hosting envirments) over sFTP as the FTP dameon supports virtual users while you need a real system user (SSH user) for sFTP.

Adding a comment that ClamAV updates may take some time may be helpful for new users... It can take upwards of 5min just for the "daily.cvd" file to download.

How to activate Roundcube plugins (auto responder, password change)?

Are you sure the linked Tutorial (Ubuntu 12.10) for installing Multiple PHP-Versions works on Ubuntu 15? Tested it (with PHP 5.3.29) with no luck.

With --with-imap it breaks:

[...]checking whether build with IMAP works... noconfigure: error: build test failed. Please check the config.log for details.[...]

Without --with-imap

[...]/lib/x86_64-linux-gnu/libssl.so.1.0.0: error adding symbols: DSO missing from command linecollect2: error: ld returned 1 exit statusMakefile:274: recipe for target 'sapi/fpm/php-fpm' failedmake: *** [sapi/fpm/php-fpm] Error 1[...]

netstat -tap | grep mysql gives:

tcp6     0    0    [::]:mysql   [::]:*     LISTEN     11629/mysqld

is this correct since the manual shows:

tcp        0      0 *:mysql                 *:*                     LISTEN      24603/mysqld

 

Yes, thats corrcet. Your server uses ipv4 and ipv6 while the one in the tutorial has ipv4 only.

hi,

when adding aliases and running newaliases (Step 9 Install Mailman) I get the following message :

newaliases: fatal: open /etc/postfix/main.cf: No such file or directory

And indeed there is master.cf but no main.cf

Also, doing a service postfix restart (or /etc/init.d/postfix restart), I get no messages (saying ok or otherwise...) is this normal ?

Postfix is installed since I do have /etc/postfix/files_present_in_here 

Is this normal ?

Where am I going wrong ?

Is Mailman essential ?

Thank-you

enzo2424@gmail[dot]com

Following up on the postfix problem. 

I never got the prompt for "internet site'" upon postfix installation. Maybe a bug in the package ? 

Anyhow, I did a "dpkg-reconfigure postfix"

and followed the install instructions on page1 & everything went correctly from there.

hope this helps out someone else who encounters this problem.

Best regards

I had the same issue, I tried dpkg-reconfigure postfix with no luck. I posted what happen in my case, I am waiting for publishing and help...hope soon.

I've problems with dns server, I need help! I create a site from ispconfig but its not reachable.

The ispconfig community support is available in our forum: https://www.howtoforge.com/community/

Hello,

after installation according this tutorial, there is problem with quotas, when system starting there is message"Failed to start Check and Enable File System Quotas. See 'systemctl status quota.service' for details." as on picture http://mixx.org/ispc3/quota-problem.jpg

When you do it , you get message: quota.service - Check And Enable File System Quotas   Loaded: loaded (/lib/systemd/system/quota.service; enabled)   Active: failed (Result: exit-code) since Mon 2015-06-01 10:01:30 CEST; 8min ago     Docs: man:quotaon(8)  Process: 216 ExecStart=/usr/share/quota/quotaon.sh (code=exited, status=1/FAILURE) Main PID: 216 (code=exited, status=1/FAILURE)Jun 01 10:01:30 109-123-216-005 quotaon.sh[216]: Checking quotas...Jun 01 10:01:30 109-123-216-005 systemd[1]: quota.service: main process exited, code=exited, status=1/FAILUREJun 01 10:01:30 109-123-216-005 systemd[1]: Failed to start Check And Enable File System Quotas.Jun 01 10:01:30 109-123-216-005 systemd[1]: Unit quota.service entered failed state.

repquota -a seems like quotas are working, but when you turn qoutas off "quotaoff -a" repquota -a answer is same, so this probably means nothing

repquota -a*** Report for user quotas on device /dev/vda3Block grace time: 7days; Inode grace time: 7days                        Block limits                File limitsUser            used    soft    hard  grace    used  soft  hard  grace----------------------------------------------------------------------root      -- 1886260       0       0          70925     0     0daemon    --      68       0       0              4     0     0man       --    1884       0       0            147     0     0www-data  --      44       0       0             32     0     0list      --      80       0       0             26     0     0statd     --      12       0       0              3     0     0client    --      32       0       0              6     0     0postfix   --     100       0       0             55     0     0ntp       --      12       0       0              3     0     0mysql     --  117524       0       0            679     0     0clamav    --  151520       0       0             12     0     0debian-spamd --    1592       0       0             25     0     0amavis    --     280       0       0             14     0     0bind      --       8       0       0              2     0     0vmail     --      20       0       0              5     0     0getmail   --      12       0       0              3     0     0ispapps   --      12       0       0              3     0     0ispconfig --   27328       0       0           5604     0     0web1      --      84 2097152 2098176             20     0     0

 

 

I seem to be having pretty much the exact same issue.

If your running an ubuntu server 15 setup following this tuto, than you'll probably have the same problem I did

I couldn't get anything over 100k to upload :(

Although I got settings right /etc/php5/cgi/php.ini and my joomla site was saying max upload 2000M (yeah i did overkill) I still couldn't get anything to go over 100k

So, I followed th instuctions that I found in a post and edited the /etc/apache2/mods-enabled/fcgid.conf to make it look like this :

<IfModule mod_fcgid.c> FcgidConnectTimeout 200 FcgidMaxRequestLen 1073741824 ....

Then, as root you do :

services apache2 restart service php5-fpm restart

to get all those configs swallowed up and miracles occur... Apparently, fcgi limits to 100k upload if not stated otherwise... and this seems to impact only on ubuntu 15, because I don't think I have this problem on my ubuntu server 14.10...

Hope this helps out folks... i searched 3 days to find the soluce...

Regards

can somone show me how to enable root login with gui i cant drop my files into the www folder to install my website

Well done.  Another great set of instructions.

Just one remaining problem (after failing to login to phpmyadmin - fixed it).

An existing website that worked fine under 12.04 now fails in 15.04.  I suspect it is an apache config problem.

Bare php works fine.  Embedded php fails to load.  The html code ends at the last character before the %lt;?php opening tag.

Any thoughts?

Hi, When i try to install amavisd-new i get the following error:

Creating/updating amavis user account...

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

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

WARNING: Starting amavisd-new failed. Please check your configuration.

systemctl status amavis.service outputs the following:

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

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

   Active: failed (Result: exit-code) since Fri 2015-07-17 17:06:35 GST; 13s ago

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

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

 

Jul 17 17:06:35 ramadahserver amavis[10448]: Starting amavisd:   The value of variable $myhostname is "ramadahserver", but should have been

Jul 17 17:06:35 ramadahserver amavis[10448]: a fully qualified domain name; perhaps uname(3) did not provide such.

Jul 17 17:06:35 ramadahserver amavis[10448]: You must explicitly assign a FQDN of this host to variable $myhostname

Jul 17 17:06:35 ramadahserver amavis[10448]: in /etc/amavis/conf.d/05-node_id, or fix what uname(3) provides as a host's

Jul 17 17:06:35 ramadahserver amavis[10448]: network name!

Jul 17 17:06:35 ramadahserver amavis[10448]: (failed).

Jul 17 17:06:35 ramadahserver systemd[1]: amavis.service: control process exited, code=exited status=1

Jul 17 17:06:35 ramadahserver systemd[1]: Failed to start LSB: Starts amavisd-new mailfilter.

Jul 17 17:06:35 ramadahserver systemd[1]: Unit amavis.service entered failed state.

Jul 17 17:06:35 ramadahserver systemd[1]: amavis.service failed.

Please advice on how to solve this error.

btw, we need to install python...

I can access the ISPConfig from https://192.168.1.3:8080/index.php#, https://server.luke.com:8080 doesn't do anything. firefox isn't even giving me an error page.

 

Also how do I access the ftp and /var/www/ domain from the network and machines that are not on my network?

 

Thanks, Luke.

Thank you! I just followed the entire tutorial, it worked 100%! You are awesome!

Something isn't quite right, I''ve wiped my vps twice and followed these instructions exactly. The "MariaDB" messes up my sql so bad that I cannot make anything work with postfix.

"Unable to connect to the specified MySQL server Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'"

What is going on here?

I installed a server by doing a copy & paste of the commands from this tutorial this morning and it worked out of the box. Maybe your vps does not has enough RAM. The VPS shall have at least 1GB RAM for this setup.

Please consider to add the following lines (taken from the similar NGIX instructions) just after setting the mysql root password:

[...]

Reload privilege tables now? [Y/n] <-- y

Then run this command to disable the auth plugin:

echo "update user set plugin='' where User='root';flush privileges;" | mysql --defaults-file=/etc/mysql/debian.cnf mysql

To allow password based authentication from PHPMyAdmin.

Then we restart MariaDB:

[...]

Hi i didnt get.

root@server1:/etc/mysql/mariadb.conf.d# quotaon -avug/dev/mapper/server1--vg-root [/]: group quotas turned on/dev/mapper/server1--vg-root [/]: user quotas turned on

what did I miss please.

 I struggled getting mail to work for a while, If anyone is having trouble remove the "#" from in /etc/postfix/master.cf

#smtps inet n - - - - smtpd #submission inet n - - - - smtpd

Amazing guide, thank you for your hard work, keep it up!

For those with phpmyadmin issues that give a 404 error type:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

sudo a2enconf phpmyadmin

sudo /etc/init.d/apache2 reload

Hello, I could not logg to phpmyadmin user root account.

I got the error : ERROR 1698 (28000): Access denied for user 'root'@'localhost'

 

I had to follow these steps :

http://www.versatilewebsolutions.com/blog/2015/05/dealing-with-mariadb-plugin-unixsocket-is-not-loaded.html

It works fine for me now.

 

Just so you know in case you too stumble upon that problem.

apache2-suexec 

libapache2-mod-suphp

No install, that doesn't work

 

Check your /etc/apt/sources.list and compare it with the one of the tutorial. Ensure that the universe and multiverse repositorys are active, then run: "apt-get update" and try to install the package again.

Wonderful tutorial, do you have have any plans on updating it for 15.10?

We publish updated versions of all perfect server tutorials regularly. The Ubuntu 15.10 release will be available in a few days.

This is such a great tutorial, but I have got a problem. I followed exactly the tutorial, but the user that I cretaed at the mailbox don't receive messages... Their emails are at the sent items, but nothing is deliverd and they get Undelivered Mail... What should I do??

Please post the issue in the forum.

Hi to all and thank for all tutorials  "perfect server...".

I used this guide and my actual result is :

I cannot receive mail, from /var/log/mail.log I see

// quote

NOQUEUE: reject: RCPT from mail-wm0-f46.google.com[74.125.82.46]: 454 4.7.1 <[email protected]>: Relay access denied; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mail-wm0-f46.google.com>

// unquote

 

Let me esplain what happen during installation and what I have done

1) mail.cf was missing, I discovered it when I run the "newaliases" command:newaliases: fatal: open /etc/postfix/main.cf: No such file or directory

2) postfix is not running, main.cf is missing

3) I removed postfix and I reinstalled itafter installation a message asked: if you need mail.cfg ...  - cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf  - service postfix restartI am not able to receive message relay access denied

4) dpkg-reconfigure postfixAnother guy, Vincent posted here for same ussue of mine, main.cf missing, fixed using reconfigureI also tried but still getting replay access denied.

I don't know what I can do, I would like not ruine my new installation.

If someone can help me soon I would say thanks in advance

The postfix main.cf gets installed automatically by apt when you install postfix as described in this tutorial. When that's not the case then there is a fundamental issue in your base setup or you got a completely broken base system from your ISP. Please make a support thread in the forum as we can not help you here in the comment section.

Thanks for reply.

The ISP is KIMSUFI - OVH

When you say "support thread" you mean on ISP Config http://www.ispconfig.org/support ?

No, I mean: https://www.howtoforge.com/community/forums/installation-configuration.27/

Dear my beloved,

This website is very good for me. Now I would like to ask you want question. When we install service like postfix, dovecot, dns ...... so no.., we need internet or not and need disk of os or not? Please let me know..

Thank you before hand.

Best regards,

Chetra PO

Hi, I have this problem during the setup of amavis:

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.dpkg: error processing package amavisd-new (--configure): subprocess installed post-installation script returned error exit status 1Errors were encountered while processing: amavisd-new

I don't know to solve this.

Thank you very much

Luigi

Hi, first if all thanks for all good Perfect Server Guides.

I have a server ubuntu 15.04 with last version of ISP Config.

I installed the server 1 year ago using this guide or another.

I would like to know if I can update my ubuntu to 16.04 and if there is a guide to do it.

note: ' Parameter from external Argument

thanks in advance

There is no special update guide available. You can follow the normal Ubuntu update procedure that you can find in the official Ubuntu documentation. Afterwards, update ispconfig and chose to reconfigure services during ISPConfig update.

Hi, I installed 2 years ago this perfect server  ubuntu 15.04.

This guide was perfect and great.

It would be useful a guide like: How to upgrade the perfect ISP config ubuntu 15.04 to 17.04

I would like upgrade my box but I am not so expert and I dont want to risk compromise my server.

A guide would be REALLY useful

thanks