Big problem after migration to 05/11/29

[GravuTrad]

I had the similar problem to the start of this post with zend and solved it with the autoinstaller. But all errors mentioned above...

 

[GravuTrad]

http://download1.parallels.com/Ples...inistrator-guide/index.htm?fileName=68806.htm

How to rebuild this please? None of the autoinstaller and the new installer or bootstrapper rebuild this (structure, move and folders), and the upgrader didn't made this so that's why all is breaked...

 

[MisterU]

Try this command

~# plesk bin repair --help

Usage: repair.sh repair.sh command [options]
Available commands:
--run or -r Restores configuration files of web,
mail and DNS servers.
--restore-vhosts-permissions Restores the default permissions for
the virtual host directories on the
specified service node. If no service
node was specified, the management
node will be used.
--update-vhosts-structure Updates the structure of the home
directory on each virtual host on the
specified service node and updates
virtual hosts configuration on all
service nodes. To skip reconfiguration
of virtual hosts, use the
-no-reconfigure option. To reconfigure
virtual hosts on all nodes at once,
run the command without the
-no-reconfigure option.
--help or -h Displays this help page.

Available options:
-no-reconfigure Skips virtual hosts reconfiguration
when executing the
--update-vhosts-structure command.
-service-node <service_node_ip> Service node.

Version: 11.5.29_build115130607.20 os_Debian 6.0

 

[GravuTrad]

Before to make this i must to solve this:

http://kb.parallels.com/en/9276

But the bootstrapper don't repair it...

 

[GravuTrad]

/usr/local/psa/bootstrapper/pp11.5.29-bootstrapper/bootstrapper.sh repair
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).

**** Product repair started.

===> Checking for previous installation ... not found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

Trying to start service mysqld... mysqld (pid 10718) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005029
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.-11.5.29.20130618-003733.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
Trying to resolve hostname 'ks38509.kimsufi.com' and validate its IP address... done

httpsd: no process killed
ERROR 1049 (42000): Unknown database 'horde'
ERROR 1049 (42000): Unknown database 'horde'

ERROR while trying to (to check that DB horde is accessible to user horde), the query was:
Check the error reason(see log file: /tmp/plesk_11.5.29_repair.log), fix and try again

***** problem report *****
ERROR while trying to (to check that DB horde is accessible to user horde), the query was:
Check the error reason(see log file: /tmp/plesk_11.5.29_repair.log), fix and try again

 

[GravuTrad]

ERROR while trying to (to check that DB horde is accessible to user horde), the query was:
Check the error reason(see log file: /tmp/plesk_11.5.29_repair.log), fix and try again


===> Restoring database from backup /var/lib/psa/dumps/mysql.preupgrade.-11.5.29.20130618-003802.dump.gz

ERROR 1044 (42000) at line 22: Access denied for user 'horde'@'localhost' to database 'mysql'
ERROR 1049 (42000): Unknown database 'horde'

[ERROR] Database restoring failed
Try to restore database from /var/lib/psa/dumps/mysql.preupgrade.-11.5.29.20130618-003802.dump.gz manually


**** Product repair failed.

 

[GravuTrad]

And in the autoinstaller log:

[warn] VirtualHost myipv4:80 overlaps with VirtualHost myipv4:80, the first has precedence, perhaps you need a NameVirtualHost directive
[warn] myipv6:80 overlaps with VirtualHost myipv6:80, the first has precedence, perhaps you need a NameVirtualHost directive

 

[GravuTrad]

Try this command

plesk bin repair --update-vhosts-structure
Plesk is not configured. You should go to the Server Administration Panel and configure it.

pfff....great 11.5.29 updater which didn't made the system folder and all the moves grrrrr!!!!!!

 

[GravuTrad]

I had to remove plesk and reinstall it to fix plesk configuration. Then i putted the last good mysql dump to retrieve it.

Then i could use the plesk bin repair tool.

I used:

plesk bin repair --update-vhosts-structure -no-reconfigure

Then the system folder is good now.

But the remove of plesk and mysql putting give me still a problem:

ERROR: Exception: Package with UID 'cf08a487-2242-4e3f-b578-dcd3152f14ec' not found.

Additionally, an exception has occurred while trying to report this error: Exception
Package with UID 'cf08a487-2242-4e3f-b578-dcd3152f14ec' not found. (aps_php.php:12519)

 

[GravuTrad]

This table seems to missing:

http://pleskhacker.vinnward.net/psa-smb_apspackages/

But i haven't phpmyadmin working and should only use mysql console....

 

[GravuTrad]

/usr/local/psa/bin/sw-engine-pleskrun check_db_integrity-beta.php
List of records in [psa.hosting.dom_id] that miss a matching record in [psa.domains.id WHERE htype='vrt_hst']
69, 84
List of records in [psa.dom_param.dom_id] that miss a matching record in [psa.domains.id]
69
List of records in [psa.hosting.sys_user_id] that miss a matching record in [psa.sys_users.id]
28, 42
List of records in [psa.DomainServices.dom_id] that miss a matching record in [psa.domains.id]
84
List of records in [psa.dns_zone.id WHERE id<>1 and id not in (select dns_zone_id from domainaliases)] that miss a matching record in [psa.domains.dns_zone_id WHERE dns_zone_id<>1]
79, 80, 97, 145
List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0]
130, 131, 133
List of records in [psa.Subscriptions.id] that miss a matching record in [psa.PlansSubscriptions.subscription_id]
14, 2, 1, 5, 19, 20, 13, 17, 15, 21, 24, 25, 26, 27, 18, 12, 9, 16, 3, 22, 23
List of records in [psa.smb_servicePermissions.id] that miss a matching record in [psa.smb_servicePermissionAccounts.servicePermissionId]
1, 3
List of records in [psa.smb_apsPackagesCategories.packageId] that exceed N in 1:N (N=1) relation to [psa.smb_apsPackages.id]
36 [count in table psa.smb_apsPackages:1; count in table psa.smb_apsPackagesCategories:3]
65 [count in table psa.smb_apsPackages:1; count in table psa.smb_apsPackagesCategories:2]

 

[GravuTrad]

I tried to solve this with this tool:

/usr/local/psa/admin/bin/php check_db.php --by-problem
Trying to retrieve DB schema from ./11.5.29-psa.sql
Error getting data from ./11.5.29-psa.sql
Trying to retrieve DB schema from /usr/local/psa/etc/db/psa_db.sql
Error getting data from /usr/local/psa/etc/db/psa_db.sql
Trying to retrieve DB schema from /usr/local/etc/psa/db/psa_db.sql
ERROR: Could not get DB schema anywhere


But no 11.5.29-psa.sql available....

 

[GravuTrad]

No idea how to repair my psa database for plesk 11.5.29?

Thanks for advance.

 

[IgorG]

I suggest you contact Support Team for recovering broken database. Not sure that it is possible to fix it by forum discussion.

 

[GravuTrad]

Sorry for this igor, i solved the problems one by one with the forum posts here. Sorry again. (even a sql file for this branch like the others could be cool)