Migration from Ensim 3.5 to Plesk 8.1 fails

[j0rus]

Seemed to work OK with 8.0, but I just tried to migrate a site after upgrading to 8.1 and get the following:

Error during dump file retrieving.
Remote agent failed with the following stderr messages: 18:13:51 INFO FileFinder: pwd resolved to /bin/pwd
18:13:51 INFO ------------------------------------------------------------
18:13:51 INFO Migration status reporting initialized.
18:13:51 INFO Status file: /migration/supervisor.18829/dumping-status.xml
18:13:51 INFO ------------------------------------------------------------
18:13:51 INFO FileFinder: psql resolved to /usr/bin/psql
18:13:51 INFO FileFinder: pg_dump resolved to /usr/bin/pg_dump
18:13:51 INFO New connection: postgresql shell connection. db appldb, user , local socket
18:13:51 INFO ------------------------------------------------------------
18:13:51 INFO FILE storage initialized.
18:13:51 INFO Base directory: /migration/supervisor.18829/
18:13:51 INFO Gzip bundles: yes
18:13:51 INFO Bundle split size: do not split
18:13:51 INFO ------------------------------------------------------------
18:13:51 INFO Work dir: /migration/supervisor.18829
18:13:51 INFO Dump file: /migration/supervisor.18829/dump.xml
18:13:51 INFO Status file:
18:13:51 TRACE SQL: SELECT DISTINCT reseller_info.reseller_id, username FROM reseller_info LEFT JOIN reseller ON reseller_info.reseller_id = reseller.reseller_id WHERE (reseller_info.reseller_id <> 0) OR (site_id IS NOT NULL)
psql: FATAL 1: no PostgreSQL user name specified in startup packet

18:13:51 WARN Unfinished SQL query: SELECT DISTINCT reseller_info.reseller_id, username FROM reseller_info LEFT JOIN reseller ON reseller_info.reseller_id = reseller.reseller_id WHERE (reseller_info.reseller_id <> 0) OR (site_id IS NOT NULL)
18:13:51 TRACE SQL: SELECT COUNT(site_id) FROM reseller WHERE reseller_id IN ('0')
psql: FATAL 1: no PostgreSQL user name specified in startup packet

Unable to retrieve sites list from reseller table at /migration/supervisor.18829/EnsimX.pl line 287.

 

[DReffects]

no PostgreSQL user name specified in startup packet

the following things might help:

1. deactivate whatever postgresql support you have on your old machine
2. install psql on your new machine

 

[j0rus]

Originally posted by DReffects
the following things might help:

1. deactivate whatever postgresql support you have on your old machine
2. install psql on your new machine

1. Ensim stores its appliance config in postgres and I sort of need that info to begin a migration.

2. Don't think this has anything to do with the new machine. I think EnsimX.pl isn't parsing the user correctly while running on the old box ONLY.


How can I modify the migration scripts to use a hard coded postgres username?

 

[sergk@]

Support of the SWSoft was resolve this problem by patch of the file /usr/local/psa/PMM/agents/shared/Db/PostgresqlShellBackend.pm

--- PostgresqlShellBackend.pm (revision 80467)
+++ PostgresqlShellBackend.pm (working copy)
@@ -16,8 +16,8 @@
sub _getCmd {
my ($self, $cmd, $additionalOptions) = @_;

- $cmd = "PGUSER=$self->{user} $cmd";
- $cmd = "PGPASSWORD=$self->{password} $cmd";
+ $cmd = "PGUSER=$self->{user} $cmd" if $self->{user};
+ $cmd = "PGPASSWORD=$self->{password} $cmd" if $self->{password};
$cmd .= " -h '$self->{host}'" if $self->{host} and $self->{host} ne 'localhost';
$cmd .= " $additionalOptions" if $additionalOptions;

 

[j0rus]

Originally posted by sergk
Support of the SWSoft was resolve this problem by patch of the file /usr/local/psa/PMM/agents/shared/Db/PostgresqlShellBackend.pm

--- PostgresqlShellBackend.pm (revision 80467)
+++ PostgresqlShellBackend.pm (working copy)
@@ -16,8 +16,8 @@
sub _getCmd {
my ($self, $cmd, $additionalOptions) = @_;

- $cmd = "PGUSER=$self->{user} $cmd";
- $cmd = "PGPASSWORD=$self->{password} $cmd";
+ $cmd = "PGUSER=$self->{user} $cmd" if $self->{user};
+ $cmd = "PGPASSWORD=$self->{password} $cmd" if $self->{password};
$cmd .= " -h '$self->{host}'" if $self->{host} and $self->{host} ne 'localhost';
$cmd .= " $additionalOptions" if $additionalOptions;

Patch worked great, thanks much!