Posts by robbo007

  • Migrating form ispcp imscp RC3

    Quote from aseques


    Basically you would lose all the accounting data for this period, you can recreate only the missing tables from the dump, it's basically a text file, so you can remove all the proper working parts and load only the broken ones.


    Hi, I've just checked my master SQL dump before I started to migrate and the mentioned tables above are not listed. I'm thinking they are not from ISPCP but maybe from the failed migration attempts IMSCP? Can you guys confirm?


    I'm happy to make a donation for your time if you guys can help me finish this migration. At present I'm stuck with an ISPCP system I can't migrate :(


    Please let me know. thanks
    Rob

  • Migrating form ispcp imscp RC3

    Quote from aseques


    If you rsynked databases without stopping mysql many times they might be broken. Best thing is that after migrating you do a mysqlcheck and if there are errors you restore from a mysqldump.


    I get this error. What information is stored in the ISPCP database? Oviously the domains etc but a week has passed since my last mysqldump. Ive added no new users since the last dump, so what changes will I loose if i restore from the dump?


    Also if I restore from the dump do I need to launch any commands after the restoration? Or will everything just work fine?



    oot@sosaria:/home/rcraig# mysqlcheck -c ispcp -u root -p
    Enter password:
    ispcp.admin OK
    ispcp.auto_num OK
    ispcp.autoreplies_log OK
    ispcp.config OK
    ispcp.custom_menus OK
    ispcp.domain OK
    ispcp.domain_aliasses OK
    ispcp.domain_dns OK
    ispcp.domain_traffic OK
    ispcp.email_tpls OK
    ispcp.error_pages OK
    ispcp.ftp_group OK
    ispcp.ftp_users OK
    ispcp.hosting_plans OK
    ispcp.htaccess OK
    ispcp.htaccess_groups OK
    ispcp.htaccess_users OK
    ispcp.lang_EnglishBritain OK
    ispcp.lang_SpanishSpain OK
    ispcp.log OK
    ispcp.login OK
    ispcp.mail_users OK
    ispcp.orders OK
    ispcp.orders_settings OK
    ispcp.php_ini
    Error : Table 'ispcp.php_ini' doesn't exist
    status : Operation failed
    ispcp.plugin
    Error : Table 'ispcp.plugin' doesn't exist
    status : Operation failed
    ispcp.quota_dovecot
    Error : Table 'ispcp.quota_dovecot' doesn't exist
    status : Operation failed
    ispcp.quotalimits OK
    ispcp.quotatallies OK
    ispcp.reseller_props OK
    ispcp.server_ips OK
    ispcp.server_traffic OK
    ispcp.sql_database OK
    ispcp.sql_user OK
    ispcp.ssl_certs
    Error : Table 'ispcp.ssl_certs' doesn't exist
    status : Operation failed
    ispcp.straff_settings OK
    ispcp.subdomain OK
    ispcp.subdomain_alias OK
    ispcp.suexec_props OK
    ispcp.tickets OK
    ispcp.user_gui_props OK
    ispcp.web_software
    Error : Table 'ispcp.web_software' doesn't exist
    status : Operation failed
    ispcp.web_software_depot
    Error : Table 'ispcp.web_software_depot' doesn't exist
    status : Operation failed
    ispcp.web_software_inst
    Error : Table 'ispcp.web_software_inst' doesn't exist
    status : Operation failed
    ispcp.web_software_options
    Error : Table 'ispcp.web_software_options' doesn't exist
    status : Operation failed

  • Migrating form ispcp imscp RC3

    [/quote]


    Hello ;


    If you cannot deal alone with your migration, install teamviewer and send me the IDS. I'll be there this evening.
    [/quote]


    Meanwhile until the teamviewer meeting tonight a little info I've discovered:


    When I try to mysqldump I get a strange error with the ISPCP database. Also if you see the imscp install log its a similar error:


    root@sosaria:~# mysqldump --databases ispcp --opt -Qc --add-drop-database -p -r /root/mysqldump.sql
    Enter password:
    mysqldump: Got error: 1146: Table 'ispcp.php_ini' doesn't exist when using LOCK TABLES
    root@sosaria:~# cat /var/log/imscp/imscp-setup.log
    [Tue Aug 13 12:17:59 2013] [debug] iMSCP::Debug::verbose: Debug mode off
    [Tue Aug 13 12:18:44 2013] [error] main::setupUpdateDatabase: [ERROR] Database update failed: Database update 52 failed.


    Exception message was:
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.web_software_options' doesn't exist
    Query was:


    REPLACE INTO
    `web_software_options` (`use_webdepot`, `webdepot_xml_url`, `webdepot_last_update`)
    VALUES
    ('1', 'http://app-pkg.i-mscp.net/imscp_webdepot_list.xml', '0000-00-00 00:00:00')
    ;

    root@sosaria:~#

  • Migrating form ispcp imscp RC3

    Quote from aseques

    It seems to me that you are not starting from 1.0.7, hence all the inconsitencies with the database you are having.
    About testing the migration, what I usually do is to replicate ALL the system to another server (we're using virtualization), and test that with a different ip, once the upgrade process has gone flawlessly, I then to the upgrade to the real server.


    Hi, when I mean rollback I roll back with rsync to my last backup. Before any changes. At present I have a fully working 1.0.7 ISPCP system. If I launch the migrations scripts from the IMSCP RC3 I get the database error as posted above. I'm currently building a test VM system but the problem is with my stable production system. I can't advance :( What can I do as I really want to migrate ....

  • Migrating form ispcp imscp RC3

    Quote from aseques


    If you can rollback, it's the best thing you can do at this point.
    The error you are getting is because the layout of the database doesn't match what is expected.


    BTW, the only suported upgrade path from ispcp is from 1.0.7, earlier versions didn't have the protected field in the database, so the cause might came from there.


    Do you have any tools for me to test my ISPCP database before migrating? This would save a lot of time. I've rolled back and my ISPCP is backonline.
    [hr]

    Quote from aseques


    If you can rollback, it's the best thing you can do at this point.
    The error you are getting is because the layout of the database doesn't match what is expected.


    BTW, the only suported upgrade path from ispcp is from 1.0.7, earlier versions didn't have the protected field in the database, so the cause might came from there.


    After rolling back removing the manual DNS entries from my customers domains I now get a different error:



    Tue Aug 13 11:48:15 2013] [error] main::setupUpdateDatabase: [ERROR] Database update failed: Database update 52 failed.


    Exception message was:
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.web_software_options' doesn't exist
    Query was:


    REPLACE INTO
    `web_software_options` (`use_webdepot`, `webdepot_xml_url`, `webdepot_last_update`)
    VALUES
    ('1', 'http://app-pkg.i-mscp.net/imscp_webdepot_list.xml', '0000-00-00 00:00:00')
    ;
    [hr]


    Could this error come from my rollback. Basically I did a rsync of / before running the migration. to rollback I just rsync the copy back on top of my server and reboot. Should I remove and IMSCP files from the server before re-attempting the migration? If so what are the paths for these files to remove?

  • Migrating form ispcp imscp RC3


    Could this be due to some customers domains having entires in the manual DNS filed in ISPCP? If so I think I can remove these before the upgrade.


    I'm rolling back because its completely broken. I'll enable the debugger and re-run the upgrade (Without SSL and remove manual DNS entries) to see if it at least works.

  • postfix problems after migration ISPCP

    I've found another problem after migrating from ISPCP to latest RC.


    Looks like there are still old entries in my postfix configuration and I get the following error in my /var/log/mail.log


    I see lots of old ISCP references still uncommented in /etc/postfix/main.cf


    Aug 13 09:54:12 sosaria postfix/master[2319]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling


    No mail is coming through.

  • Migrating form ispcp imscp RC3

    Quote from gOOvER


    whats the problem exact with the cert?


    It accepted my private key ok but on the screen where you select the crt file it did not allow me to continue. I had the correct cry file selected. Press enter an nothing.


    So to continue I said: Enable SSL support but no I don't have a cert. This allowed me to migrate.


    So now I would like to manually add my cert? Not sure if this is possible?
    [hr]
    [Something has seriously gone wrong :(


    I ran the:


    Migrate from ispCP


    # cp -fR /tmp/imscp/* /
    # cd /var/www/imscp/engine/setup
    # perl imscp-migrate-from-ispcp
    # perl imscp-setup


    No errors (apart from my skipping the SSL) in the install.



    This is the last lines of the install log:


    Tue Aug 13 09:20:47 2013] [error] Modules::openssl::ssl_check_cert: Error loading file /etc/imscp/sosaria.secnet.es.pem
    10144:error:02001002:system library:fopen:No such file or directory:bss_file.c:126:fopen('/etc/imscp/sosaria.secnet.es.pem','r')
    10144:error:2006D080:BIO routines:BIO_new_file:no such file:bss_file.c:129:
    10144:error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib:by_file.c:274:
    usage: verify [-verbose] [-CApath path] [-CAfile file] [-purpose purpose] [-crl_check] [-engine e] cert1 cert2 ...
    recognized usages:
    sslclient SSL client
    sslserver SSL server
    nssslserver Netscape SSL server
    smimesign S/MIME signing
    smimeencrypt S/MIME encryption
    crlsign CRL signing
    any Any Purpose
    ocsphelper OCSP helper
    [Tue Aug 13 09:20:50 2013] [error] Modules::openssl::ssl_check_key: Key /etc/imscp/sosaria.secnet.es.pem doesn't exists. Exiting...
    [Tue Aug 13 09:22:58 2013] [error] main::setupUpdateDatabase: [ERROR] Database update failed: Database update 114 failed.


    Exception message was:
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.protected' in 'where clause'
    Query was:
    UPDATE
    `domain_dns` AS `t1`
    SET
    `t1`.`domain_dns` = CONCAT((SELECT `t2`.`domain_name` FROM `domain` AS `t2` WHERE `t1`.`domain_id` = `t2`.`domain_id`), '.')
    WHERE
    `t1`.`domain_dns` = ''
    AND
    `t1`.`protected` = 'yes'
    [hr]
    Should I re-run the migrations scripts?


    I'm not sure if its migrated anything. I see ISPCP is broken and does not load. :(