Upgrade from 1.0.3.0 to 1.2.9 - DB update r177 fail

  • Hi,


    i test an upgrade from 1.0.3.0 TO 1.2.9 (the 1.0.3.0 is an upgrade from ISPCP 1.0.7).


    i have this error :


    [ERROR] main::setupUpdateDatabase: [ERROR] Database update 177 failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'localhost-teamspeak3' for key 'PRIMARY'
    autoinstaller::Functions::install: An error occurred while performing installation steps


    Thanks for your help.

    Debian 6 with proxmox 2 - OpenVZ - KVM
    I-mscp 1.0.3.0 migrate from ispcp 1.0.7
    dovecot + zarafa + z-push + maia mail guard + apacheITK

  • Hello ;


    You must check the mysql.user table for possible duplicate entries, based on the PRIMARY key which is a compound field (Host and User fields). If you cannot figure alone, give me an access to your server my adding my ssh key and sending me the IP.


    You should have only a max of two teamspeak3 users in that table (one with % for the Host field value and another with whatever value for the Host field value), else the update will fail because attempt will be made to update any other Host field value for those users to localhost, resulting to duplicate entries.


    Note: If you remove an entry, don't forget to remove the associated entry in the mysql.db table.

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

  • @krok


    Please, provide us the output of the following SQL queries:


    SQL
    1. # mysql -u root -p<your_sql_root_password>
    2. > use mysql;
    3. > SELECT host, user FROM user WHERE user = 'teamspeak3';
    4. > SELECT host, db, user FROM db WHERE user = 'teamspeak3';
    5. > quit;

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

  • Thanks it's work, for information :



    mysql> SELECT host, user FROM user WHERE user = 'teamspeak3';
    +-----------+------------+
    | host | user |
    +-----------+------------+
    | | teamspeak3 |
    | % | teamspeak3 |
    | localhost | teamspeak3 |
    +-----------+------------+
    3 rows in set (0.00 sec)


    mysql> SELECT host, db, user FROM db WHERE user = 'teamspeak3';
    +-----------+------------+------------+
    | host | db | user |
    +-----------+------------+------------+
    | localhost | teamspeak3 | teamspeak3 |
    +-----------+------------+------------+
    1 row in set (0.00 sec)

    Debian 6 with proxmox 2 - OpenVZ - KVM
    I-mscp 1.0.3.0 migrate from ispcp 1.0.7
    dovecot + zarafa + z-push + maia mail guard + apacheITK

  • @krok


    Delete the first entry in the mysql.user table (the teamspeak3 user with no Host). Then rerun installer.

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

  • After that, my root password doesn't work anymore and the install failed :


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


    :D

    Debian 6 with proxmox 2 - OpenVZ - KVM
    I-mscp 1.0.3.0 migrate from ispcp 1.0.7
    dovecot + zarafa + z-push + maia mail guard + apacheITK

  • Which query did you run in order to delete the first teamspeak3 entry ?


    I can see in your signature that you are using Debian 6. Version 1.2.9 needs at least Debian 7 (Wheezy) in order to run...

  • i have recreate the root account and imscp_autoinstall delete this.

    Debian 6 with proxmox 2 - OpenVZ - KVM
    I-mscp 1.0.3.0 migrate from ispcp 1.0.7
    dovecot + zarafa + z-push + maia mail guard + apacheITK

  • i have delete teamspeak3 entry with WEBMIN
    the system has upgrade to debian 7

    Debian 6 with proxmox 2 - OpenVZ - KVM
    I-mscp 1.0.3.0 migrate from ispcp 1.0.7
    dovecot + zarafa + z-push + maia mail guard + apacheITK