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
  #11  
Old 15th September 2009, 10:57
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

I get an access denied message.

Quote:
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?
Reply With Quote
Sponsored Links
  #12  
Old 15th September 2009, 11:14
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

I did this logged in as root on server1:

Quote:
GRANT ALL PRIVILEGES ON *.* TO 'ispconfig'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
and:
Quote:
FLUSH PRIVILEGES;
After that restarted mysql server:
Quote:
/etc/init.d/mysql restart
I can connect now from server2 to server1.

But the jobqueue stays the same.

Last edited by skoena; 15th September 2009 at 11:22.
Reply With Quote
  #13  
Old 15th September 2009, 11:30
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Also I see that these:

Quote:
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:
Quote:
Data from: ????-??-?? ??:??
No data about the memory usage available at the moment. Please check again later.
Reply With Quote
  #14  
Old 15th September 2009, 13:02
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

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

Quote:
//** 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';
Reply With Quote
  #15  
Old 15th September 2009, 13:09
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,787
Thanks: 821
Thanked 5,337 Times in 4,187 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #16  
Old 15th September 2009, 13:15
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

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?
Reply With Quote
  #17  
Old 15th September 2009, 13:19
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,787
Thanks: 821
Thanked 5,337 Times in 4,187 Posts
Default

Quote:
OK it's from the server1 file: /usr/local/ispconfig/server/lib/config.inc.php.
Thats ok as it is the master server.

Quote:
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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #18  
Old 15th September 2009, 13:22
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Quote:
Originally Posted by till View Post
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?

Last edited by skoena; 15th September 2009 at 13:27.
Reply With Quote
  #19  
Old 15th September 2009, 13:27
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,787
Thanks: 821
Thanked 5,337 Times in 4,187 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #20  
Old 15th September 2009, 13:28
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
 
Default

Oops error:

Quote:
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
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


All times are GMT +2. The time now is 13:36.


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