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

[itanium]

Hi,

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


SQl:
apt-get install mysql-client mysql-server


Web/FTP/NS1:
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? :)

Thanks

[itanium]

I found packages for each server.

[skoena]

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 ?

Rudolf.
p.s. Till/Falko, ispconfig3 rocks, really great, love it :-)

[unixix]

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 ?

Rudolf.
p.s. Till/Falko, ispconfig3 rocks, really great, love it :-)

I'm interested too on how setup squirrelmail for each domain name so each site can have is own webmail www.domain.com/webmail and www.domain1.com/webmail and so on.

[skoena]

I'm interested too on how setup squirrelmail for each domain name so each site can have is own webmail www.domain.com/webmail and www.domain1.com/webmail and so on.

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

My question is different.
Rudolf.

[skoena]

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

[skoena]

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?

2009-09-15 10:24 mail01.skoena.nl Update mail_user
2009-09-15 09:45 server2 Insert mail_forwarding
2009-09-15 06:48 server2 Insert mail_forwarding
2009-09-15 06:47 server2 Insert mail_forwarding
2009-09-14 22:34 server2 Insert mail_user
2009-09-14 22:33 server2 Insert mail_forwarding
2009-09-14 22:33 server2 Insert mail_forwarding
2009-09-14 22:33 server2 Insert mail_forwarding
2009-09-14 22:32 server2 Update mail_user
2009-09-14 22:32 server2 Update mail_user
2009-09-14 22:32 server2 Insert mail_user
2009-09-14 22:32 server2 Insert mail_user
2009-09-14 22:31 server2 Insert mail_domain
2009-09-14 22:31 server2 Insert spamfilter_users

Rudolf.

[till]

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/config.inc.php is able to connect from the slave to the master server.

[skoena]

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/config.inc.php is able to connect from the slave to the master server.

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/config.inc.php 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?

Rudolf.

[till]

But I think I'm connected to the dbispconfig db on the slave server right?

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.

[skoena]

I get an access denied message.

ERROR 1045 (28000): Access denied for user 'ispconfig'@'192.168.1.102' (using password: YES)

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

[skoena]

I did this logged in as root on server1:

GRANT ALL PRIVILEGES ON *.* TO 'ispconfig'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; and:
FLUSH PRIVILEGES;

After that restarted mysql server: /etc/init.d/mysql restart
I can connect now from server2 to server1.

But the jobqueue stays the same.

[skoena]

Also I see that these:

Server State
Show CPU data
Show Overview
Show Update State
Show RAID state
Show Server load
Show Disk usage
Show Memory usage
Show Services Logfiles
Show Mail-Queue
Show Mail-Log
Show Mail warn-Log
Show Mail err-Log
Show System-Log
Show ISPC Cron-Log
Show Freshclam-Log
Show Clamav-Log
Show RKHunter-Log
Show fail2ban-Log

Have no data available.

Example:
Data from: ????-??-?? ??:??
No data about the memory usage available at the moment. Please check again later.

[skoena]

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

//** Database settings for the master DB. This setting is only used in multiserver setups
$conf["dbmaster_type"] = 'mysql';
$conf["dbmaster_host"] = 'was not filled in';
$conf["dbmaster_database"] = 'dbispconfig';
$conf["dbmaster_user"] = 'was not filled in';
$conf["dbmaster_password"] = 'differentpw_than_DB_passwd';

[till]

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.

[skoena]

OK it's from the server1 file: /usr/local/ispconfig/server/lib/config.inc.php.

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

[till]

OK it's from the server1 file: /usr/local/ispconfig/server/lib/config.inc.php.


Thats ok as it is the master server.

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

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.

[skoena]

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.


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?

[till]

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.

[skoena]

Oops error:

Warning: require(/usr/local/ispconfig/server/lib/config.inc.php): failed to open stream: No such file or directory in /tmp/ispconfig3_install/install/uninstall.php on line 50

Fatal error: require(): Failed opening required '/usr/local/ispconfig/server/lib/config.inc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /tmp/ispconfig3_install/install/uninstall.php on line 50

[till]

Please see my post above for the instructions in case that the uninstall script fails.

[skoena]

Sometimes I feel I have too little experience with linux :-)
How can I delete the ispconfig user in the mysql.user table?

When I connect to the main server I don't find a mysql.user table.

[till]

The easiest way is to use phpmyadmin. Every mysql database server has a database called mysql and it must contain several tables incl. a user table.

[skoena]

The easiest way is to use phpmyadmin. Every mysql database server has a database called mysql and it must contain several tables incl. a user table.

I deleted the mysql.user table. But now I can't login to mysql anymore all users are denied even root.
Help.... how to restore the mysql.user database without access to mysql??

[skoena]

What I have done to fix it.
Edited the /etc/mysql/my.cnf file. I have added skip-grant-tables after [mysqld]. Restarted the mysql server /etc/init.d/mysql restart I now was able to get into mysql without login and password. I imported the backupped mysql.user table. Deleted the "skip-grant-tables" from the my.cnf file. Rebooted the server and everyting was fine again. Phoeffffff.

Another question now. What should I delete from the mysql.user table. I know now not the whole table. :rolleyes:

[till]

Please delet just the record for the user named "ispconfig" instead of the complete table. Look also trough all other tables in the database "mysql" and delete records were the username is "ispconfig". Then restart mysql.

[skoena]

Sorry for my noob problems :-)

I find this in the DB table:
*localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N
*192.168.1.102 dbispconfig ispcsrv6 Y Y Y Y N N N N N N N N N N N N N
*192.169.1.102 dbispconfig ispcsrv2 Y Y Y Y N N N N N N N N N N N N N
*nameofhost dbispconfig ispcsrv6 Y Y Y Y N N N

And this in the user table:
*localhost ispconfig *password* N N N N N etc.
*% ispconfig *password* Y Y Y Y etc.

Please tell me what should I do?

[skoena]

Sorry for my noob problems :-)

I find this in the DB table:
*localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N
*192.168.1.102 dbispconfig ispcsrv6 Y Y Y Y N N N N N N N N N N N N N
*192.169.1.102 dbispconfig ispcsrv2 Y Y Y Y N N N N N N N N N N N N N
*nameofhost dbispconfig ispcsrv6 Y Y Y Y N N N

And this in the user table:
*localhost ispconfig *password* N N N N N etc.
*% ispconfig *password* Y Y Y Y etc.

Please tell me what should I do?

So if i'm right I should delete:
**localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N from the DB table.
And
**localhost ispconfig *password* N N N N N etc.
**% ispconfig *password* Y Y Y Y etc. from the USER table right?

[till]

Delete all entry for the user with the name "ispconfig" and also all "ispcsrv" users (you did not mentioned that this is the master database of a multiserver setup. After you cleaned this up, yopu will ahve to reinstall all slave servers too.

[skoena]

So I deleted all the entries mentioned.
I reinstalled ispconfig via de 2nd server and selected expert setup.

Everyting was installed succesfully. But when I want to logon to ispconfig now I get these mysql errors:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

What to do?

Also I notice that my sites are very slow. Also to get into ispconfig is very slow and into /phpmyadmin as well. When I restart apache it's speed is normal but decreases within minutes.

[till]

Please see my post above. If this is a multiserver setup, you have to reinstall all nodes incl. the master and the master has to be installed first. On a reinstall you will loose all settings.

[skoena]

OK I'm having to many newbie problems to get a second server installed. So I will cancel this at this moment. I now just want one server. The master server is allready installed, online and running. How will I be able to login again on the main server?

[till]

Ok, then you will have to copy back your backup of the mysql usertable.

[skoena]

Till,
I imported the last mysql table backup dump but still the access denied messages on ispconfig control panel.

[till]

Have you reloaded mysql?

[skoena]

Yes I restarted mysql.

/etc/init.d/mysql restart

[skoena]

Any other ideas?

[till]

Run the ispconfig 3.0.1.4 update again on the master server as described in this thread (the manual update instructions):

http://www.howtoforge.com/forums/showthread.php?t=38795

It will reconfigure the database permissions for the ispconfig user on the master server.

[skoena]

Till,
I did the manual update. Restarted mysql after it. When i connect to the ispconfig control panel I get this error on top of the page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

[till]

Please check if you are able to login to mysql with the login details in the file /usr/local/ispconfig/interface/lib/config.inc.php when you use the "mysql" command on the shell.

[skoena]

I get this:

ERROR 1045 (28000): Access denied for user 'ispconfig'@'localhost' (using password: YES)

[skoena]

Any ideas to get user ispconfig back in?

[damir]

You can always add the user through phpmyadmin, don't forget to reload privileges after user is added.

[skoena]

(I was using the skip grant option)
I added the user ispconfig via phpmyadmin, used the password found in /usr/local/ispconfig/interface/lib/config.inc.php

Flushed privileges. Restarted mysql. But now the password for ispconfig is changed? And my sites are extremely slow. Also for example site/phpmyadmin is not available or takes very long.
I changed back to the skip grant t option. I think I will reinstall my server from scratch.

[till]

But now the password for ispconfig is changed?

Why shall it has been changed? The ispconfig password is in /usr/local/ispconfig/interface/lib/config.inc.php and the password is in cleartext. So if you add it in phpmyadmin, you have to choose "PASSWORD" to encrypt it.

Regarding the slow server, you should test if the login for the ispconfig user works now and if thats the case, then reboot your server.

[skoena]

Why shall it has been changed? The ispconfig password is in /usr/local/ispconfig/interface/lib/config.inc.php and the password is in cleartext. So if you add it in phpmyadmin, you have to choose "PASSWORD" to encrypt it.

Regarding the slow server, you should test if the login for the ispconfig user works now and if thats the case, then reboot your server.

Sorry Till I was unclear.

I added the user ispconfig via phpadmin and used the password like mentioned in the config.inc.php file.

After that when I want to login to ispconfig control panel it sais access denied for admin with the same password I always used before.

Rudolf.

[till]

Have you tested that you are able to login to the mysql database and switch to the ispconfig database with the username "ispconfig" and the password from the file? You can test this with the mysql command or phpmyadmin.

[skoena]

I get access denied.
How can I grant access to dbispconfig for user ispconfig?

I was looking in phpmyadmin (under dbispconfig, permissions) but there I can't add user ispconfig for db dbispconfig.

Cheers,
Rudolf.

Os should I set "ALL PRIVILEGES" for user ispconfig?

[skoena]

Under the user settings of user ispconfig I "GRANT" the user ispconfig to use the db dbispconfig. Is this enough?

I flushed privileges and I restarted mysql. But I still get this error at the login of the ispconfig controlpanel:

ERROR
Error
Username or Password wrong.1

Password lost?

I checked and now I can use DB in mysql with user ispconfig, I don't get access denied message.

[till]

Should be ok but please test it, you will see if you can enter to the ispconfig database with phpmyadmin.

[skoena]

Via phpadmin, logged in as user "ispconfig" I can enter the database "ispconfig".

But at the the ispconfig control panel still

ERROR
Error
Username or Password wrong.1

when I try to login as admin.

[till]

Then look at the dbispconfig database, is there a user with username "admin" in the sys_user table? If yes, try to set a new password. The password has to be encrypted with "md5".

[skoena]

I reset the admin password in md5 in phpmyadmin.
But now I see that none of the users can login into the ispconfig control panel?

[till]

And does the password work afetr you reset it?

[skoena]

No nobody can login.
Also admin after reset can still nog login.

[till]

Ok, then I guess there must be still a permission problem with the ispconfig mysql user.

[skoena]

OK but I can connect with user ispconfig to the db dbispconfig via mysql and in phpmyadmin. Now the ispconfig user is granted "USAGE" of the dbispconfig. Should I change this to "ALL PRIVILEGES"? And how do I do this?

[till]

The ispconfig user is connecting only to the ispconfig database. I'am not sure if the problem can be solved witthout more debugging of the mysql connections

[skoena]

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/config.inc.php is able to connect from the slave to the master server.

Did this file change on new version of ISPconfig3?
/usr/local/ispconfig/server/lib/config.inc.php

[till]

Yes. But not the values within that file as the updater copies the values from the old file to the new file during update.

[skoena]

Didn't find it first time when I tried to locate it, but I got it now.

[skoena]

Ok thank you.

[skoena]

I have 2 servers.
1 is in Datacenter and is Main server.

//** Database
$conf["db_type"] = 'mysql';
$conf["db_host"] = 'localhost';
$conf["db_database"] = 'dbispconfig';
$conf["db_user"] = 'ispconfig';
$conf["db_password"] = 'password aefc';
$conf["db_charset"] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")

//** Database settings for the master DB. This setting is only used in multiserver setups
$conf["dbmaster_type"] = 'mysql';
$conf["dbmaster_host"] = 'localhost';
$conf["dbmaster_database"] = 'dbispconfig';
$conf["dbmaster_user"] = 'ispcsrv1';
$conf["dbmaster_password"] = 'password 3a6e';


This is slave server (setup in multiserver setup):
This one is @home with me.

//** Database
$conf["db_type"] = 'mysql';
$conf["db_host"] = 'localhost';
$conf["db_database"] = 'dbispconfig';
$conf["db_user"] = 'ispconfig';
$conf["db_password"] = 'password 70fd';
$conf["db_charset"] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")

//** Database settings for the master DB. This setting is only used in multiserver setups
$conf["dbmaster_type"] = 'mysql';
$conf["dbmaster_host"] = 'ip adres main server';
$conf["dbmaster_database"] = 'dbispconfig';
$conf["dbmaster_user"] = 'ispcsrv4';
$conf["dbmaster_password"] = 'password badf';

Which passwords should be the same?
Which user should connect from slave to master?

Rudolf.

[skoena]

Anybody that can help me?

So what data should I enter on the main server and on the slave server?

[CSsab]

Hi rudolfpietersma,

I think from reading your posts that you have removed some required tables from your master server while you were uninstalling ISPConfig the first time and that this has led to your problems. You can access your phpmyadmin here:
http://123.123.123.123/phpmyadmin (where 123.123.123.123 is your IP in /etc/network/interfaces)

Here is a screenshot of phpmyadmin after a fresh install of mysql database on a Ubuntu system and also a new install of ispconfig.

The easy way you can add or remove new users is by clicking on the privileges tab - tick the "add new user" box - hit enter. You can also remove users here and request that their database be dropped to keep your system clean.

If you need to uninstall ISPConfig 3 for any reason the uninstall will remove entire dbispconfig, we need to remove only the user in mysql database which has been created on your mysql database by ISPConfig3 during the install. The reason for not removing the ISPConfig3 user is because you are uninstalling ISPConfig3 and therefore it no longer has access to your mysql database. This is why we get the "tables already exist" error.

Hope this helps.

[skoena]

Hi,
Tnx for your message. But my last 2 messages are because of a new problem. The messaged before are already solved.

My question is what settings should I use for the slave server that is at home with to connect and replicate with the master server that is in the datacenter.

Rudolf.

[skoena]

Till or anybody,
Can you point me in the right direction?

Rudolf.

[damir]

Hi,
Tnx for your message. But my last 2 messages are because of a new problem. The messaged before are already solved.

My question is what settings should I use for the slave server that is at home with to connect and replicate with the master server that is in the datacenter.

Rudolf.

You need to add user of slave server to your master server. That should contain both domain and ipadress of slave server. Don't forget to reload privileges on master server.

Than if you can connect from slave to master using mysql -h command, than it's all setup correctly.

[skoena]

Which user should I add to the master server, does it have a specific name?

Rudolf.

[till]

You have to add a root user. This root user has to be used only during install. The user that is used later by ispconfoig is created by the ispconfig installer. Please do not edit anything refßgarding this ispconfig user manually in the mysql settings. Only the root user has to be added before you install ispconfig.

[skoena]

I can't get this to work.

On my main server I added root user to connect from my slave ip in phpmyadmin:

http://skoena.com/tmp/ispconfig_web01.png

web01 is main server.
backup is slave server.

When I change things on main server via ispconfig it does not sync to the slave server.

Jobqueue
2010-05-30 11:49 backup.----- Update server

What to do next?
Rudolf.

[till]

1) stay the jobs for the slave in the jobqueue?
2) Enable verbose logging for the slave in the server settings of the master server and check the ispconfig.og file on the slave.

[skoena]

Hi Till,

1) Yes they stay there.
2) Sorry how to enable the logging?

Rudolf.

[till]

2) Sorry how to enable the logging?

Please see ISPConfig FAQ:

http://www.faqforge.com/linux/controlpanels/ispconfig3/how-to-enable-debugging-in-ispconfig-3/

[skoena]

I enabled the logging on the master but the /var/log/ispconfig/ispconfig.log on the slave stays empty?