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:


    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


    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.


  • 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...


  • ops next 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


    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.