Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st February 2011, 18:30
saco721 saco721 is offline
Member
 
Join Date: Feb 2010
Posts: 63
Thanks: 15
Thanked 1 Time in 1 Post
Default problems getting ispconfig 3 to install on mailserver

Hi,
I am using the multiserver setup for Debian. My webserver is running 64bit version of Debian netinst. Mail, db and nameservers are running i386.All the base systems are in place. I have installed ISPconfig on my webserver, but I am experiencing problems with my mail server. Basically I am at the stage of installing ISPConfig and I get to :
Quote:
MySQL master server hostname : <--web.example.com
MySQL master server root username [root]: <-- root
MySQL master server root password []: <-- Enter the root password of the master server here
MySQL master server database name [dbispconfig]: <-- dbispconfig
But I get back :
Quote:
Unable to connect to mysql server
I can connect to mysql on my web server using :
Code:
mysql -u root -p
And I can see the dbispconfig database.

If I run netstat -tap I get :

Quote:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:54176 *:* LISTEN 1942/rpc.statd
tcp 0 0 *:mysql *:* LISTEN 9418/mysqld
tcp 0 0 *:sunrpc *:* LISTEN 1931/portmap
tcp 0 0 *:ftp *:* LISTEN 15285/pure-ftpd (SE
tcp 0 0 *:ssh *:* LISTEN 2167/sshd
tcp 0 0 localhost:smtp *:* LISTEN 7636/exim4
tcp 0 52 web.example.com:ssh 80.173.227.121:4356 ESTABLISHED 2509/sshd: administ
tcp6 0 0 [::]:http-alt [::]:* LISTEN 15464/apache2
tcp6 0 0 [::]:www [::]:* LISTEN 15464/apache2
tcp6 0 0 [::]:tproxy [::]:* LISTEN 15464/apache2
tcp6 0 0 [::]:ftp [::]:* LISTEN 15285/pure-ftpd (SE
tcp6 0 0 [::]:ssh [::]:* LISTEN 2167/sshd
tcp6 0 0 [::]:https [::]:* LISTEN 15464/apache2
Any help would be greatly appreciated. - Thanks
Reply With Quote
Sponsored Links
  #2  
Old 22nd February 2011, 07:57
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

You have to add a root server login on the web server for the hostname and the IP address of the mailserver. Please see here for details:

http://www.howtoforge.com/installing...th-ispconfig-3
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 22nd February 2011, 13:03
saco721 saco721 is offline
Member
 
Join Date: Feb 2010
Posts: 63
Thanks: 15
Thanked 1 Time in 1 Post
Default

Hi Till,

Is that the part that says :
Quote:
CREATE USER 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
and :
Quote:
CREATE USER 'root'@'mail.example.tld' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'mail.example.tld' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Thanks for your time!
Reply With Quote
  #4  
Old 22nd February 2011, 13:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Yes. You have to replace the IP and the hostname with the hostname and IP of your mail server and restart mysql on the master.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 22nd February 2011, 18:05
saco721 saco721 is offline
Member
 
Join Date: Feb 2010
Posts: 63
Thanks: 15
Thanked 1 Time in 1 Post
 
Default

Hi Till,

Will try re running queries.

Thanks!
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
Maia MailGuard in ISPC3 warlock Tips/Tricks/Mods 7 23rd December 2010 05:51
Rebuilding server after install of ISPConfig 3 DantePasquale Installation/Configuration 3 28th March 2009 19:15
fastcgi and php with ispconfig tosser Installation/Configuration 14 18th January 2009 13:41
Mailserver 554 Permanent Problems Message asyadiqin Server Operation 7 15th November 2007 15:09
ISPconfig new install - questions jasthom69 Installation/Configuration 1 8th October 2007 11:58


All times are GMT +2. The time now is 05:26.


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