1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Migration from Ensim 3.5 to Plesk 8.1 fails

Discussion in 'Plesk for Linux - 8.x and Older' started by j0rus, Dec 17, 2006.

  1. j0rus

    j0rus Guest

    0
     
    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.
     
  2. DReffects

    DReffects Basic Pleskian

    26
    40%
    Joined:
    Feb 8, 2005
    Messages:
    76
    Likes Received:
    0
    the following things might help:

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

    j0rus Guest

    0
     
    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?
     
  4. sergk@

    sergk@ Guest

    0
     
    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;
     
  5. j0rus

    j0rus Guest

    0
     
    Patch worked great, thanks much! :)
     
Loading...