Multi-server Setup: package for mail,sql and web/ftp

Discussion in 'Installation/Configuration' started by itanium, Sep 5, 2009.

  1. itanium

    itanium Member


    I want to setup ispconfig3 with 3 servers (mail/ns2 , sql, web/ftp/ns1).

    1) Shall i setup the 3 servers following the entire INSTALL_DEBIAN_5.0.txt?

    2) Or shall i setup every server separately with:

    Mail / NS2:
    apt-get install postfix postfix-mysql postfix-doc courier-authdaemon courier-authlib-mysql courier-pop courier-pop-ssl courier-imap courier-imap-ssl libsasl2-2 libsasl2-modules libsasl2-modules-sql sasl2-bin libpam-mysql openssl courier-maildrop getmail4 rkhunter binutils

    apt-get install amavisd-new spamassassin clamav clamav-daemon zoo 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

    Setup mydns

    apt-get install mysql-client mysql-server

    apt-get install apache2 apache2.2-common apache2-doc apache2-mpm-prefork apache2-utils libexpat1 ssl-cert libapache2-mod-php5 php5 php5-common php5-gd php5-mysql php5-imap phpmyadmin php5-cli php5-cgi libapache2-mod-fcgid apache2-suexec php-pear php-auth php5-mcrypt mcrypt php5-imagick imagemagick libapache2-mod-suphp libopenssl-ruby

    apt-get install pure-ftpd-common pure-ftpd-mysql quota quotatool

    apt-get install vlogger webalizer

    Setup mydns


    Option 1 or 2? :)

  2. itanium

    itanium Member

    I found packages for each server.
  3. ikrudolf

    ikrudolf Member

    I also would like to setup one server for web and one server for mail.

    Server 1 is allready up and running all services.
    Server 2 is added as a multiple server setup up and running (but nowt doing anything yet)

    How to get Server 2 up and running to take over email?
    How to setup the link to www.domain/webmail ?

    p.s. Till/Falko, ispconfig3 rocks, really great, love it :)
  4. unixix

    unixix New Member

    I'm interested too on how setup squirrelmail for each domain name so each site can have is own webmail and and so on.
  5. ikrudolf

    ikrudolf Member

    If you follow the "The Perfect Server" setup for your system @ you will get this.

    My question is different.
  6. ikrudolf

    ikrudolf Member

    Can somebody point me in the right direction?
    Or is there some documentation availalbe?
    Or can anybody provide me with some links?
  7. ikrudolf

    ikrudolf Member

    What I have done:

    I have 2 servers. 1 Mainserver with SQL/WEB, 1 Mailserver. Both are visible in the ispconfig control panel.

    *I removed all the email domains from the control panel because it's not possible to change from server1 to server2.
    *I re-entered the email domains and email account with the name of server2.
    *I changed the config of squerrelmail on server1 and changed the localhost names to the IP of server2.
    *I can do the squerrelmail config_test.php, all looks fine.

    But when I check the Jobqueue on server2 in the ispconfig control panel it's full with things he didn't perform since yesterday. What should I do?

  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely the slave server is naot abloe to connect to the master server. Please check that the mysql user "ispconfig" with the password that is stored in the file /usr/local/ispconfig/server/lib/ is able to connect from the slave to the master server.
  9. ikrudolf

    ikrudolf Member

    Hi Till,
    (Sorry I'm kind of a newbie on linux.)

    On the slave I do: mysql -uispconfig -p
    Entered the password that was found in the file /usr/local/ispconfig/server/lib/ on the slaveserver.
    Than I can change to the dbispconfig database.
    But I think I'm connected to the dbispconfig db on the slave server right? How should I connect to the main server instead?

  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes. To connect to the master server use this command on the slave:

    mysql -h masterserver.tld -u ispconfig -p

    where masterserver.tld is the hostname of the master server.
  11. ikrudolf

    ikrudolf Member

    I get an access denied message.

    How can I allow server2 to connect to server1's databases?
  12. ikrudolf

    ikrudolf Member

    I did this logged in as root on server1:

    After that restarted mysql server:
    I can connect now from server2 to server1.

    But the jobqueue stays the same.
    Last edited: Sep 15, 2009
  13. ikrudolf

    ikrudolf Member

    Also I see that these:

    Have no data available.

  14. ikrudolf

    ikrudolf Member

    I also see different dbmaster settings? Why are they different?

  15. till

    till Super Moderator Staff Member ISPConfig Developer

    This settings are from a server that is not a slave server in a multiserver setup or it is the master server itself and they are correct for this scenario. If they would have ben set, the setup will fail.
  16. ikrudolf

    ikrudolf Member

    OK it's from the server1 file: /usr/local/ispconfig/server/lib/

    Should on the slave server2 also exist a /usr/local/ispconfig/server/lib/ file? Because it's not there?
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats ok as it is the master server.

    Yes, and this file is individual for every server, so you can not copy it. If the file is not there, then ispconfig is not installed on the second server. Please install ispconfig 3 on the second server in expert mode and choose to join the master server.
  18. ikrudolf

    ikrudolf Member

    Strange Till,
    I installed it on the server2 slave and it was succesful. When I now reinstall it it sais: "ERROR: Stopped: Database already contains some tables"". Should I delete the tables in this dbispconfig db on the slave server?
    Last edited: Sep 15, 2009
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    Run the uninstall.php script first and then install it again. If the uninstall script fails, please remove the ispconfig database and ispconfig mysql user manually and reload mysql. then delete the folder /usr/local/ispconfig before you install it again.
  20. ikrudolf

    ikrudolf Member

    Oops error:


Share This Page