Checking associations between domains and IP addresses and Reference between some IP collections and

[Eugene1]

I get the next problem when looking at the Web server Configuration Checker.

[2015-10-30 02:00:12][INFO] ==> STEP 3: Checking associations between domains and IP addresses...
[2015-10-30 02:00:12][WARNING] There is a number of domains which are not associated with any IP address. This may be caused by an error in the IP address database.
Please check http://kb.parallels.com/en/113475 for details.
[2015-10-30 02:00:12][INFO] Result: Warning

[2015-10-30 02:00:12][INFO] ==> STEP 4: Checking for corrupted reference between IP collections and IP addresses...
[2015-10-30 02:00:12][WARNING] Reference between some IP collections and IP addresses has been broken.
Please check http://kb.parallels.com/en/113826 for details.
[2015-10-30 02:00:12][INFO] Result: Warning

Provided solutions does not help solve the problem. Working in Virtuozzo with version 12.0.18 Update #70, last updated at Oct 30, 2015 04:11 AM

Can any one help? I want to solve this problem before moving to version 12.5.30 of Plesk.

 

[UFHH01]

Hi Eugene1,

if you followed KB http://kb.parallels.com/en/113475 , have you got still existing ipCollectionIds with "ipAddressId" = "0" ?

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e 'select * from IpAddressesCollections where ipAddressId = 0'

if you followed KB http://kb.parallels.com/en/113826 , have you got still broken hosting settings?

plesk db

mysql> select IP_Addresses.id, ip_address, pool_id, IpAddressesCollections.ipCollectionId, ipAddressId, domains.name, clients.login from ip_pool, clients, IpAddressesCollections, domains, DomainServices, IP_Addresses where DomainServices.ipCollectionId = IpAddressesCollections.ipCollectionId and domains.id=DomainServices.dom_id and clients.id=domains.cl_id and ipAddressId not in (select id from IP_Addresses) and IP_Addresses.id = ip_pool.ip_address_id and pool_id = ip_pool.id group by pool_id\G

 

[Eugene1]

Hi UFHH01,

Thank you for contacting me.

Artikel http://kb.parallels.com/en/113826 I get this on Odin Forum: Sorry, but this article is outdated.
When searching for this artikel I get to Article ID: 115587. This is not very helpful for with Plesk 12.0.8 the suggested module is present in the Plesk panel.

I followed KB http://kb.parallels.com/en/113475 and it give me when determining which “ipAddressId” should correspond to which “ipCollectionId" the next output:
+--------------------+--------------+---------------------------------------+------------------------------+------------+
| Domains | Service Type | IpAddressesCollections.ipCollectionId | Current value of ipAddressId | Have to be |
+--------------------+--------------+---------------------------------------+------------------------------+------------+
| koopgemak.eu | mail | 7 | 0 | 1 |
| test5.koopgemak.eu | mail | 13 | 0 | 1 |
+--------------------+--------------+---------------------------------------+------------------------------+------------+

Trying to change it with: mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e 'Update IpAddressesCollections SET ipAddressId = 1 WHERE ipCollectionId = 7'

Gives me this answer: ERROR 1062 (23000) at line 1: Duplicate entry '7-1' for key 'PRIMARY'

And with that the problem did not solved, now I have a duplicate.
What am I doing wrong?

A bootstrapper repair does not help!

When Bootstrapper is used, it gaves this result:
===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

Trying to start service mariadb... done
Trying to establish test connection... connected
done
Trying to start service mariadb... done
Trying to establish test connection... connected
done
Trying to find psa database... version is 012000018
Version is OK, no need to create psa database.
Trying to backup MySQL database... Warning: Not dumping MySQL database 'horde' as it doesn't exist
Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.12.0.18-12.0.18.20151102-140425.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.
Upgrade or repair for 'apsc' (stage 'prep') is not required
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.12.0.18-12.0.18.20151102-140434.dump.gz
===> Cumulative upgrade and repair of APS controller database has been completed.
Connection to APSC DB is possible
===> Cumulative APS controller upgrade and repair (final stage) has been started.
Upgrade or repair for 'apsc' (stage 'post') is not required
===> Cumulative upgrade and repair of APS controller (final stage) has been completed.
ERROR 1045 (28000): Access denied for user 'pp_sb_db'@'localhost' (using password: NO)
Trying to reset database user password for 'pp_sb_db@'... ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

WARNING!
Some problems are found during reset database user password for 'pp_sb_db@' - database user does not exist.(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log)

Continue...

===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
===> Preparing Plesk upgrade (final stage).
===> Cumulative upgrade and repair of Plesk (final stage) has been completed.
Reconfiguring mail subsystem...
Reconfiguring Apache web server...
Reconfiguring ProFTPD FTP server...
Reconfiguring AWStats web statistics...
Reconfiguring WatchDog...
Restoring SELinux contexts...
Regenerating web servers' configuration files...
Cleaning active Panel sessions...

Bootstrapper repair finished.

Looking at the probable solutions I feel like going on in circles. Would appriciate it if you have a solution.

Regards,

Eugene

 

[UFHH01]

Hi Eugene1,

first, please be reminded, that database inconsistency should be handled carefully and with thoroughness. Incorrect repair procedures may result in a complete messup of the psa database.
If you correct psa tables, please always double check your corrections and undo manual changes, which result in errors.

Please check now with:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e 'select * from IpAddressesCollections where ipAddressId = 1'​

... double entries and delete possible duplicates.


Afterwards, please check again your current entries, as suggested at http://kb.odin.com/113475 and if you are unsure which entry should be corrected and how, then you have to post all necessary informations and MySQL - queries, in order to get help.

 

[Eugene1]

Hi,

Could not get back to the forum because of a personal problem.

After trying again to upgrade I noticed the link given to as a warning told me the problem was outdated, so I went along implemented the upgrade.
No I get this error when logging in. Strange because I can see that Panel has changed.

Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
)

Details: Doing restart of Parallels Installer...
Datei wird heruntergeladen products.inf3: Error: Couldn't resolve host 'autoinstall.plesk.com', retry...
Error: Couldn't resolve host 'autoinstall.plesk.com', retry...
Error: Couldn't resolve host 'autoinstall.plesk.com', retry...
Datei wird heruntergeladen versions.inf3: Error: Couldn't resolve host 'autoinstall.plesk.com', retry...
Error: Couldn't resolve host 'autoinstall.plesk.com', retry...
Error: Couldn't resolve host 'autoinstall.plesk.com', retry...

ERROR: Fehler! Lesen der Produktinformation aus der Datei fehlgeschlagen : Can't process products.inf3: Herunterladen des Pakets http://autoinstall.plesk.com/products.inf3 fehlgeschlagen:
Couldn't resolve host 'autoinstall.plesk.com'

Can't process versions.inf3: Herunterladen des Pakets http://autoinstall.plesk.com/versions.inf3 fehlgeschlagen:
Couldn't resolve host 'autoinstall.plesk.com'


Es wurden nicht alle Pakete installiert.
Bitte beheben Sie dieses Problem und versuchen Sie, die Pakete erneut zu installieren.
Wenn Sie das Problem nicht selbst beheben können, wenden Sie sich bitte an den technischen Support.

Any Idea what is happening here and how to solve this?

 

[UFHH01]

Hi Eugene1,

please check:

Plesk upgrade is not starting: Couldn't resolve host autoinstall.plesk.com ( KB - article 121 240 )

​

Please consider as well to open a NEW thread, if the thread title doesn't meet your issue, because it will confuse other forum-users, who are searching for solutions and work-arounds.