#1  
Old 13th June 2009, 18:50
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
Default Installation problem

Hi All,

I want to install ispconfig on 3 server with this configuration :

- server 1 : apache + php + ispconfig + ftp + dns 1 (91.121.39.87)
- server 2 : mysql (91.121.39.88)
- server 3 : postfix, smtp, dns 2, etc... (91.121.39.89)

but when I want to install ispconfig on server 1, I've this error :

Quote:
MySQL server hostname [localhost]: sql.espace4you.org

MySQL root username [root]:

MySQL root password []: ***************

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

Unable to connect to mysql server Host '91-121-39-87.ovh.net' is not allowed to connect to this MySQL server
but I've commented on my.cnf this option :

Quote:
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
I don't understand why the installation is reject by mysql.

If you have an idea ?

Thank you for your answers

PS : I use virtual machines with openvz and proxmox for information
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's

Last edited by Gimly; 13th June 2009 at 18:56.
Reply With Quote
Sponsored Links
  #2  
Old 13th June 2009, 19:00
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,647
Thanks: 794
Thanked 5,003 Times in 3,912 Posts
Default

First, make sure that mysql is installed on each of the 3 server. This is a prerequisite for ispconfig. Even if you want to use one server later for the website databases only.

Then make sure that the root user is able to connect from the slave servers to the master database, commenting out the bind-address line is one nescessary step, the other one is that you have to add a root user account which is able to connect from everywere to the master database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 13th June 2009, 19:02
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
Default

Ok thanks till I will test it
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's
Reply With Quote
  #4  
Old 14th June 2009, 19:44
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
Default

Hmmm, I don't understand how can I add new server, I launch ispconfig install on third party server in expert mode, I add information and then the script stop with no message (error or great install) :

Quote:
mail:/tmp/ispconfig3_install/install# php -q install.php


--------------------------------------------------------------------------------
_____ ___________ _____ __ _
|_ _/ ___| ___ \ / __ \ / _(_)
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
__/ |
|___/
--------------------------------------------------------------------------------


>> Initial configuration

Operating System: Debian Lenny/Sid or compatible

Following will be a few questions for primary configuration so be careful.
Default values are in [brackets] and can be accepted with <ENTER>.
Tap in "quit" (without the quotes) to stop the installer.


Select language (en,de) [en]:

Installation mode (standard,expert) [standard]: expert

Full qualified hostname (FQDN) of the server, eg server1.domain.tld [mail.espace4you.org]:

MySQL server hostname [localhost]: ns1.espace4you.org

MySQL root username [root]:

MySQL root password []: *****************

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

mail:/tmp/ispconfig3_install/install#
it's ok or not ?

I think a tutorial about multi-server installation will not be luxury to help all ISPConfig users ... ^^

If you have answers ?

Thanks
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's
Reply With Quote
  #5  
Old 15th June 2009, 08:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,647
Thanks: 794
Thanked 5,003 Times in 3,912 Posts
Default

You entered the wrong mysql server name. The name of the local mysql server is localhost, you will be asked for the external server in a later step of the installer.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 15th June 2009, 11:05
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
Default

aaaaah ok, sorry xD. Last question, I must install all service (apache, mail, etc ...) on all server and then on ISPConfig I select what I want or not ? Because, when I just install mail on third server, or just sql on second, I've the same problem :

Quote:
mail:/tmp/ispconfig3_install/install# php -q install.php


--------------------------------------------------------------------------------
_____ ___________ _____ __ _
|_ _/ ___| ___ \ / __ \ / _(_)
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
__/ |
|___/
--------------------------------------------------------------------------------


>> Initial configuration

Operating System: Debian Lenny/Sid or compatible

Following will be a few questions for primary configuration so be careful.
Default values are in [brackets] and can be accepted with <ENTER>.
Tap in "quit" (without the quotes) to stop the installer.


Select language (en,de) [en]:

Installation mode (standard,expert) [standard]: expert

Full qualified hostname (FQDN) of the server, eg server1.domain.tld [mail.espace4you.org]:

MySQL server hostname [localhost]:

MySQL root username [root]:

MySQL root password []: *****************

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

mail:/tmp/ispconfig3_install/install#
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's

Last edited by Gimly; 15th June 2009 at 11:53.
Reply With Quote
  #7  
Old 15th June 2009, 21:32
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
Default

Any idea, please ?

--edit : What is the prerequisite debian package on third party server to use ispconfig slave system ?

For example, I just use this package for my mail server, with no other .deb :

Quote:
apt-get install postfix postfix-mysql postfix-doc mysql-client mysql-server 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
Quote:
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
and for execute install :

Quote:
apt-get install php5-cli
---
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's

Last edited by Gimly; 15th June 2009 at 21:53.
Reply With Quote
  #8  
Old 16th June 2009, 15:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,647
Thanks: 794
Thanked 5,003 Times in 3,912 Posts
Default

Install all packages that you find in the relevant sections of the perfect setup tutorials plus the php-cli packages and the php modules from the tutorial.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Gimly (16th June 2009)
  #9  
Old 16th June 2009, 15:25
Gimly Gimly is offline
HowtoForge Supporter
 
Join Date: Mar 2007
Location: France
Posts: 144
Thanks: 26
Thanked 4 Times in 4 Posts
 
Default

Now it work. Thanks a lot Till . The topic is solved
__________________
4 virtual machines with Debian Lenny updated on proxmox (openvz) with ISPConfig 3.0.1.6

ns1 : http(s), ftp(s), DNS Master, ISPConfig
sql : MySQL database users
mail : All mail system
ns2 : DNS Slave

ISPConfig.be Admin's
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Graphics problem for fedora 10 installation omkar Installation/Configuration 1 4th June 2009 17:12
HAProxy Installation problem Paladinemishakal Installation/Configuration 2 11th November 2008 09:54
Zivios Ubuntu howto - Openldap installation problem vcorreia HOWTO-Related Questions 3 24th September 2008 15:21
Problem with dcc-client installation (Postfix) swap-as Installation/Configuration 9 18th September 2008 20:47


All times are GMT +2. The time now is 03:31.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.