ispcp to i-mscp on a new server, database seems to stay behind

  • Evening all,


    I'm upgrading the server hardware for my old ispcp setup. In the process I'd like to move to i-mscp but I'm having a few issues.


    I'm doing a test run on the new hardware (sync'd across /var/www, /var/mail/virtual, /etc/ispcp and databases), after some tidying of orphan'd db entries I passed my first hurdle (imscp-migrate-from-ispcp) but I'm falling flat on my face at the second.


    When running imscp-setup -d I end up with an error relating to my ispcp DB structure (specifically php_ini):

    Code
    1. Servers::httpd::apache_php_fpm::installer::_fixPhpErrorReportingValues: Errorwhile executing query: Table 'ispcp.php_ini' doesn't existiMSCP::EventManager::trigger: A listener registered on the'afterSetupCreateDatabase' event and triggered in main::setupCreateDatabase hasfailed.Listener code was:sub { package Servers::httpd::apache_php_fpm::installer; BEGIN {${^WARNING_BITS} = "TUUUUUUUUUUUU\025UU\005"} use strict; $self->_fixPhpErrorReportingValues(@_);}


    Fixing this table (creating it empty) lands me at another db error relating to fields, it therefore seems the structure has been left behind.


    I spotted updDB.php (woo this may sort it all for me) but I get:

    Code
    1. An error occurred. Please contact your administrator or reseller.


    Something is likely broken, any pointers to where I should be looking?


    Thanks,


    Tristan.

  • Excerpt from the imscp-setup.log


    Points to the same issue with updDB.php failing I believe:


    Code
    1. [Wed Nov 12 21:00:47 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/bin/php5 /var/www/imscp/engine/setup/updDB.php
    2. [Wed Nov 12 21:00:47 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0
    3. [Wed Nov 12 21:00:47 2014] [debug] main::setupUpdateDatabase: An error occurred. Please contact your administrator or reseller.
    4. [Wed Nov 12 21:00:47 2014] [debug] iMSCP::EventManager::trigger: Triggering afterSetupCreateDatabase event


    Now to find the cause...

  • Sorry X/


    Ubuntu 14.04.1 (trusty)
    Upgrading from ispcp 1.0.7 OMEGA to 1.1.16 or 1.1.14 (same error)
    Courier, Apache FPM


    Logs to follow shortly,


    Tristan.

  • Log containing the above error attached.


    Thanks for giving me a chance to report this bug properly, my apologies for not following the rules initially.


    Tristan.

  • For now I'm going to migrate the new server and stay with ispcp.


    After the migration I'll do further testing in a VM regarding an upgrade to i-mscp.


    Thanks for working and continuing to develop a wonderful control panel. I hope to join the world of i-mscp soon!


    Tristan.

  • @Nuxwin should be more able to help you on that case, but it seems it didn't find some entries in the DB.
    I'm not sure, but nuxwin should find it out quickly xD

  • As I know the php_ini table comes from imscp. So may the db update was not successful. If possible, please purge php-fpm & apache and do the steps again.