[SOLVED] Upgrade 1.0.2 to 1.0.3 error

[sfera]

Stopping Services:......... [done]

ispCP main configuration file
Loading old ispCP configuration file: [done]
Update ispCP configuration file: [done]

ispCP database
Update ispCP database schema: [failed]


FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum


any idea?

[gOOvER]

Enable debug in ispcp.conf, start update again and post output here.

[sfera]

/var/www/ispcp/engine/setup# perl ispcp-update
DEBUG: push_el() sub_name: update_startup(), msg: Starting...
DEBUG: push_el() sub_name: update_startup(), msg: Ending...
DEBUG: push_el() sub_name: update_engine(), msg: Starting...
DEBUG: push_el() sub_name: user_dialog(), msg: Starting...
DEBUG: push_el() sub_name: welcome_note(), msg: Starting...

Welcome to ispCP '1.0.3 OMEGA' Update Dialog.

This program will update your current ispCP OMEGA installation on this
server.
Please make sure you did a backup of all your server data.

NOTE: During the migration process some or all services might require to
be shut down.

WARNING: Only services that are not marked with 'NO' in your ispcp.conf
configuration file will be processed by this program.

Do you want to continue [Y/n]: y
DEBUG: push_el() sub_name: welcome_note(), msg: Ending...
DEBUG: push_el() sub_name: warn_msg(), msg: Starting...

NOTICE: Make sure you have read and performed all steps from
docs/distro/INSTALL document (where distro is your linux distribution).

Do you want to continue [Y/n/?]: y
DEBUG: push_el() sub_name: warn_msg(), msg: Ending...
DEBUG: push_el() sub_name: user_dialog(), msg: Ending...

Stopping Services:DEBUG: push_el() sub_name: stop_services(), msg: Starting...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/ispcp_network stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/ispcp_daemon stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/bind9 stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/usr/sbin/apache2ctl stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/proftpd stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/postfix stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/courier-authdaemon stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/courier-pop stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/etc/init.d/courier-imap stop &>/tmp/ispcp-update-services.log'), msg: Ending...
.DEBUG: push_el() sub_name: stop_services(), msg: Ending...
[done]

ispCP main configuration file
Loading old ispCP configuration file:DEBUG: push_el() sub_name: load_old_ispcp_config(), msg: Starting...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: load_old_ispcp_config(), msg: Ending...
[done]
Update ispCP configuration file:DEBUG: push_el() sub_name: update_ispcp_config(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: store_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: store_conf(), msg: Ending...
DEBUG: push_el() sub_name: update_ispcp_config(), msg: Ending...
[done]

ispCP database
Update ispCP database schema:DEBUG: push_el() sub_name: update_database_schema(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
[failed]


FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

DEBUG: push_el() sub_name: exit_msg(), msg: Ending...

[Nuxwin]

Please, post the content of your logs who are in /tmp

[sfera]

Hi in de update database log only apair "1"

Code:

# cat ispcp-update-database.log
1

Code:

# cat ispcp-update-services.log
Stopping Courier IMAP server: imapd.

In the first try i get error of database password I use the How to http://www.isp-control.net/documentation..._db_pass). for change it, (you say it in other post) but now i dont get error in database log, only the number 1

[Nuxwin]

(12-21-2009 07:34 PM)sfera Wrote:  Hi in de update database log only apair "1"

Code:

# cat ispcp-update-database.log
1

Code:

# cat ispcp-update-services.log
Stopping Courier IMAP server: imapd.

In the first try i get error of database password I use the How to http://www.isp-control.net/documentation..._db_pass). for change it, (you say it in other post) but now i dont get error in database log, only the number 1

Ok

First, please enable your private messagerie because i can answer you.

sfera Wrote:Hi and sorry for my poor english if you want i send you a root password for check it.

thx in advanced

Ok, send me the following information:

Your IP
Your root password
Your sql password

I'll check it

[sfera]

(12-21-2009 07:43 PM)nuxwin Wrote:  Ok, send me the following information:

Your IP
Your root password
Your sql password

I'll check it

Ok the PM have send

[Nuxwin]

ok

Code:

DEBUG: push_el() sub_name: update_engine(), msg: Ending...
DEBUG: push_el() sub_name: setup_rkhunter(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: save_file(), msg: Starting...
DEBUG: push_el() sub_name: save_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_rkhunter(), msg: Ending...
DEBUG: push_el() sub_name: update_shutdown(), msg: Starting...
DEBUG: push_el() sub_name: setup_cleanup(), msg: Ending...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: setup_cleanup(), msg: Ending...


    Congratulations, you updated ispCP '1.0.3 OMEGA' successfully!

    Type http://admin.www.sferaxxxxxxx.com into your browser to log in
    to your panel.

Now please, send me the admin name and pasword for the panel

[sfera]

(12-21-2009 08:31 PM)nuxwin Wrote:  Now please, send me the the admin name and pasword for the panel

The password was sent..

Thx very much for your great work.

Is my first important error in 2 years using ispcp. is the first time i have error in the upgrade. Thx for all

[Nuxwin]

Grrrzzz - I'll kill you

Work fine now but I can't update the ispcp database. I've postponed the DB update during the update process but i can't update the database via the panel now. Why ? Because you have patched the database manually with the patch of blondak (dns feature).

you must correct your base (your own shit). After that I would end the update if you wish.

Let this be clear to everyone, the update script has not been designed for exotic configuration!

Code:

Actualización de la Base de Datos 19 erronea
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'domain_dns'
Sql Statement was failed: ALTER IGNORE TABLE `domain` ADD `domain_dns` VARCHAR( 15 ) NOT NULL DEFAULT 'no';