Multi-server not working after upgrade to 3.0.3.1

I upgraded our main server to 3.0.3.1 (from 3.0.1) and everything works on the main server. The second server still works, but nothing is displayed in ISPconfig (see attachment).

I ran the update on both servers, and it all seemed to go smoothly.

How do I reconnect the second server?

Kind regards,


René

 

Thanks for the fast reply!

When I rerun the update I get:

There are no updates available for ISPConfig 3.0.3.1

When I use the downloaded version I get:

ERROR: Unable to set rights of user in master database: dbispconfig Error: Table 'dbispconfig.server' doesn't exist

The table ispconfig.server does exist (but not dbispconfig.server).

 

Thanks again for the fast reply!

I don't get the option to enter a database name, the very first option is to Reconfigure Permissions. Upon entering yes, I get:

ERROR: Unable to set rights of user in master database: dbispconfig Error: Table 'dbispconfig.server' doesn't exist

 

same error

"http://www.howtoforge.com/installing-a-web-email-and-mysql-database-cluster-on-debian-5.0-with-ispconfig-3"

after upgrade i got the following:

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 72

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 72

i first try ispconfig_autoupdate.sh
and the the manual update

and then check the /usr/local/ispconfig/server/lib/config.inc.php

output:


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

define('DB_TYPE',$conf['db_type']);
define('DB_HOST',$conf['db_host']);
define('DB_DATABASE',$conf['db_database']);
define('DB_USER',$conf['db_user']);
define('DB_PASSWORD',$conf['db_password']);
define('DB_CHARSET',$conf['db_charset']);


//** Database settings for the master DB. This setting is only used in multiserver setups
$conf['dbmaster_type'] = 'mysql';
$conf['dbmaster_host'] = '';
$conf['dbmaster_database'] = 'dbispconfig1';
$conf['dbmaster_user'] = '';
$conf['dbmaster_password'] = '7b1325cac54f4d34546815bcc91599b3744b6';


This is the master server, the other "slave" was installed today whit the new release, and then i tru to update whit no luck =)

Whats the recomendation to upgrade this installation?

//Marcus

 

Yes all servers was working, then i notise that the master got the version before and i upgrade to the new one then i crash.

if i try again whit ispconfig:upgrade.sh i get this:


s09:~# ispconfig_update.sh

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

>> Update

Please choose the update method. For production systems select 'stable'.
The update from svn is only for development systems and may break your current setup.

Select update method (stable,svn) [stable]:

There are no updates available for ISPConfig 3.0.3.1
s09:~#


So i need to use the manual update, then i use reconfigure permissions.

//Marcus

 

Changing the config.inc.php on the master resulted in the master also no longer correctly displaying. The masterdb settings should not be set on the master server.

In the end the problem turned out to be the firewall. Somehow port 3306/tcp was blocked on the master server. Unblocking the port resulted in everything working again. I not sure know if or how the firewall-ports were changed during the upgrade.

Thanks again for the help!

Kind regards,


René

 

There is no firewall between the 2 servers, just on different ESX hosts.

Is there any possibility to do a reinstall ore do i have to reinstall everything?

-------------------------------------------------------------------------

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

Should db_user be ispconfig? ore root?
--------------------------------------------------------------------------------------------------------------





//Marcus

 

dosent matter wat i do, cant get this to work.

i uninstall both servers and delete priv from mysql, en reinstalled this but no luck.
so i going to reinstall it compleatly from beginning.

/M

 

My replication does not work

I have a multiserver with GlusterFS installed as indicated by the ispconfig3_manual
I clarify that replication never worked!
Today I update to ISPConfig Version: 3.0.4.5 and in the process see the following message: Starting incremental database update.
But when I access the database dbispconfig2, I see it is empty and only has the structure.
The server1 works correctly with dbispconfig1 where there correct data, but server2 has no data on dbispconfig2. How can check the synchronization process dbispconfig1 to dbispconfig2?
Another query, the file /usr/local/ispconfig/server/lib/config.inc.php should have the same data in Section:
//** Database settings for the master DB. This setting is only used in multiserver setups??? I ask because I have different data on Server1 and Server2 for this section.

Tks guys

 

Thanks Till, I will have to migrate unison then all!