migrate from ispcp 1.0.7 to 1.2.2

  • I am trying to migrate my old ispcp 1.0.7 to 1.2.2.
    I got that error:


    [ERROR]


    main::databaseIntegrityTests:
    DBI connect('database=;host=localhost','Peter',...) failed: Access denied for user 'Peter'@'localhost' (using password: YES) at /var/www/imscp/engine/setup/../PerlLib/iMSCP/Database/mysql.pm line 115


    [FATAL]



    What I am doing wrong ?

  • Hello;


    You're doing nothing wrong specially ;)


    The password for the Peter SQL user is wrong so the migration fail. You must reset that password at mysql side and update it into the imscp sql_users table. Once done, you must restart the migration script.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • I think Peter is an orphaned entry. Check, remove it and then try again..

  • @Ninos


    That migration script gives me some cold sweats ;) We need really finish that importer...

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • ops next error


    [ERROR]


    main::setupServerIps: Unable to connect to the SQL database: DBI connect('database=ispcp;host=localhost;port=3306','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /var/www/imscp/engine/setup/../PerlLib/iMSCP/Database/mysql.pm line 115


    [FATAL]


    Exit code: 1


    Now my root password for mysql does not work any more.
    I tried to change with stuff like mysqld_safe --init-file=/home/me/mysql-init & ....
    but nothing helps.
    Any suggestions ?

  • mysql root user was missing or erased during upgrade.
    I used skip-grant .. option to add mysql root user.
    After that I rerun the setup.
    Actually i upgraded from debian 5 to debian 6, then upgraded iscp 1.0.7 to imscp, then
    moved to debian 7 and rerun imscp setup.
    Everthing is good now.