[SOLVED] Upgrade 1.0.2 to 1.0.3 error

[SOLVED] Upgrade 1.0.2 to 1.0.3 error - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: [SOLVED] Upgrade 1.0.2 to 1.0.3 error (/thread-8855.html)

Pages: 1 2 3

[SOLVED] Upgrade 1.0.2 to 1.0.3 error - sfera - 12-21-2009 06:36 PM

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?

RE: Upgrade 1.0.2 to 1.0.3 error - gOOvER - 12-21-2009 06:53 PM

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

RE: Upgrade 1.0.2 to 1.0.3 error - sfera - 12-21-2009 07:01 PM

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

RE: Upgrade 1.0.2 to 1.0.3 error - Nuxwin - 12-21-2009 07:27 PM

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

RE: Upgrade 1.0.2 to 1.0.3 error - sfera - 12-21-2009 07:34 PM

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/doku.php?id=howto:ispcp:change_db_pass). for change it, (you say it in other post) but now i dont get error in database log, only the number 1

RE: Upgrade 1.0.2 to 1.0.3 error - Nuxwin - 12-21-2009 07:43 PM

(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/doku.php?id=howto:ispcp:change_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

RE: Upgrade 1.0.2 to 1.0.3 error - sfera - 12-21-2009 07:56 PM

(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

RE: Upgrade 1.0.2 to 1.0.3 error - Nuxwin - 12-21-2009 08:31 PM

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

RE: Upgrade 1.0.2 to 1.0.3 error - sfera - 12-21-2009 08:43 PM

(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 Wink

RE: Upgrade 1.0.2 to 1.0.3 error - Nuxwin - 12-21-2009 09:03 PM

Grrrzzz - I'll kill you Tongue

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';