Comments on Installing A Multiserver Setup With Dedicated Web, Email, DNS And MySQL Database Servers On Debian 5.0 With ISPConfig 3

When I use  http://192.168.0.105/phpmyadmin (my server is located at a different address) i get a broken link message. Is there a step missing?

Replace 192.168.0.105 with the IP address of your master server.

when I add a DB for a client, I can't connect to it. and when I try the phpmyadmin link next to the DB in the CP it doesn't load

Nano nano /etc/phpmyadmin/config.inc.php and add this

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['host'] = 'db.yourserver.tld';

$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|phpmyadmin)';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['extension'] = 'mysqli';

$i++; // next server.

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['DisplayServersList'] = true;

Great tutorial, the only part I adapted was adding a handler for RAR files instead of TAR.

Will this work for Ubuntu? If so what needs to be done differently? I can't find any other tutorial out there...

This should work for Ubuntu too.

Can this work on ubuntu?

Hello

Is it possible to integrate RoundCoube/Squrrielmail on these servers ? If yes, can I use this guide: https://www.howtoforge.com/roundcube_webmail_ispconfig ??

I have made this setup, but I can´t find the RoundCube under ISPConfig -> System -> Apps & Addons -> Packages. How can I install it ? I want to use www.domain.tld/webmail with ssl on port 443.

Please help.

Best regards
WolfieDK

I have used this https://www.howtoforge.com/tutorial/roundcube-installation-on-debian-8-jessie/import sql in server of DB! :)

There is a issue with a apache2-mpm-prefork module on application server and sites applications with smarty, sessions and other functions what are need to write data somewhere to the web directory.

ISPConfig create a virtual hosts with 

# add support for apache mpm_itk
<IfModule mpm_itk_module>
 AssignUserId web1 client1
</IfModule>

by default vhost template.

So you need to uninstall apache2-mpm-prefork and install apache2-mpm-itk module to solve this issue.

It is not nescessary to install apache2-mpm-itk to solve that. apache2-mpm-prefork works absolutely fine, you just missed to enable the suexec checkbox in the website settings in ispconfig so that the scripts run under the user of the website.

To install correctly all apache2 module on Ubuntu Xenial (16.04) , I had try :apache2 apache2-doc apache2-utils libapache2-mod-php php7.0 php7.0-common php7.0-gd php7.0-mysql php7.0-imap phpmyadmin php7.0-cli php7.0-cgi libapache2-mod-fcgid apache2-suexec-pristine php-pear php-auth php7.0-mcrypt mcrypt  imagemagick libruby libapache2-mod-python php7.0-curl php7.0-intl php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xmlrpc php7.0-xsl memcached php-memcache php-imagick php-gettext php7.0-zip php7.0-mbstringTaken from the The Perfect Server - Ubuntu 16.04 (Xenial Xerus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1 - step 8 for the Apache server.PHP5 is no longer available in default ubuntu repository.

That's cool!

I do wonder though... If you're not routing the database-server through a proxy or so... how do you use your database for a wordpress installed by the apps-part of ispconfig?