• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Migration from Ensim 3.5 to Plesk 8.1 fails

J

j0rus

Guest
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.
 
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
 
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?
 
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;
 
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! :)
 
Back
Top