migration from ispcp

  • in table config, set database revision to 51 and try again.
    if not

    Code
    1. ALTER IGNORE TABLE
    2. `ftp_users`
    3. ADD
    4. `rawpasswd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
    5. AFTER
    6. `passwd`

  • in table config, set database revision to 51 and try again.
    if not

    Code
    1. ALTER IGNORE TABLE
    2. `ftp_users`
    3. ADD
    4. `rawpasswd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
    5. AFTER
    6. `passwd`


    I don't have pma, apache can't accessible. If you could send me the revision change sql that would be a great help ;)[hr]
    i found, thanks :)

    OS: Debian Buster

    i-MSCP: GIT 1.5.3-maintenance branch

    Edited once, last by Kika ().

  • UPDATE `imscp`.`config` SET `value` = '51' WHERE `config`.`name` = 'DATABASE_REVISION';
    change imscp with your db name (probably ispcp);

  • change the database revision isn't a solution. I create the field in a moment.[hr]
    i created the rawpasswd and set be the revision to 51. The next error is the update 53 with sql error near "change" WHERE `mail_id`="220""


    but in the query section i see this only:
    update `mail_users' SET 'mail_pass' =


    and a very long scrollable place without any visible character

    OS: Debian Buster

    i-MSCP: GIT 1.5.3-maintenance branch

    Edited once, last by Kika ().


  • Do you have a backup? (you should have one in /var/www/backups)
    Best wait is to restore ispcp database, replace that file i sent to you and run again setup. restore just database not other files. Need help with sql to be performed?

    Edited once, last by oldev01 ().

  • i could restore the database but only with the wrong database passwords, so i must restore everything to change passwords again.


    maybe i found the problem: in the imscp-setup.log i found the wrong line:
    `mail_pass` = ".......\",


    maybe the last backslash is the problem before the quot.

    OS: Debian Buster

    i-MSCP: GIT 1.5.3-maintenance branch

    Edited once, last by Kika ().

  • No. problem is that your pass where already decoded. Ok lets skip this step:

    SQL
    1. UPDATE `imscp`.`config` SET `value` = '53' WHERE `config`.`name` = 'DATABASE_REVISION';
  • i had some deprecated problem magic_quotes_.. because php 5.3, but the process was continue. Rebuilding all config files now.


    thanks a lot :)

    OS: Debian Buster

    i-MSCP: GIT 1.5.3-maintenance branch

  • Sorry for trouble. Will be fixed in beta 2 (tonight)


  • Sorry for trouble. Will be fixed in beta 2 (tonight)


    Somebody must be the first :) Thanks for the great help.


    Next problem: Error while performing step: Rebulding all coustomers conf. See the log.


    Exit code was 1...
    [hr]
    the status of a domain is: sys_command() | [ERROR] External command '/usr/sbin/postmap /etc/postfix/imscp/domains' exited with value -1 !, the other domains are ok

    OS: Debian Buster

    i-MSCP: GIT 1.5.3-maintenance branch

    Edited once, last by Kika ().