Current time: 09-25-2021, 12:40 AM Hello There, Guest! (LoginRegister)


Post Reply 
1.0.7 upgrade problem
Author Message
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #1
1.0.7 upgrade problem
Hi all.

I've had a little problem with ispcp 1.0.6:

My phptemp folder was gone
My reseller folder was gone

I thought I might have to upgrade, so I followed the instructions on: http://isp-control.net/documentation/sta...ade/debian
(I have Lenny, so everythins is done accordingly).

Then I came to the well known password problem, so I removed the password from ispcp.conf and .old file, reset it with the correct root password through ispcp-db-passwd which went ok, I still get an error when updating:

Code:
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
makepath()                     | Starting...
makepath()                     | [NOTICE] '/var/log/ispcp/setup' exists ! Setting its permissions...
setfmode()                     | Starting...
setfmode()                     | Ending...
makepath()                     | Ending...
update_startup()               | Starting...
del_file()                     | Starting...
del_file()                     | [ERROR] File '/tmp/ispcp-setup.log' does not exist !
lock_system()                  | Starting...
lock_system()                  | Ending...
update_startup()               | Ending...
update_engine()                | Starting...
user_dialog()                  | Starting...
welcome_note()                 | Starting...
welcome_note()                 | Ending...
warn_msg()                     | Starting...
warn_msg()                     | Ending...
user_dialog()                  | Ending...
stop_services()                | Starting...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP Network Traffic Logger: ispcp_network
ispcp_network is already stopped (warning).
.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_network stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_daemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping domain name service...: bind9rndc: connect failed: 127.0.0.1#953: connection refused
.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/bind9 stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] httpd (no pid file) not running
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/usr/sbin/apache2ctl stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ftp server: proftpd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/proftpd stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping policyd-weight (incl. cache): policyd-weight.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/policyd-weight stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Postfix Mail Transport Agent: postfix.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/postfix stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier authentication services: authdaemond.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-authdaemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier POP3 server: pop3d.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-pop stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier IMAP server: imapd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-imap stop') | Ending...
stop_services()                | Ending...
load_old_ispcp_config()        | Starting...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
load_old_ispcp_config()        | Ending...
update_ispcp_cfg()             | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
store_conf()                   | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
store_file()                   | Starting...
setfmode()                     | Starting...
setfmode()                     | Ending...
store_file()                   | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Ending...
update_ispcp_cfg()             | Ending...
check_ispcp_cfg_file()         | Starting...
check_ispcp_cfg_file()         | Ending...
preinst()                      | Starting...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst()                      | Ending...
update_database_schema()       | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
sys_command_rs()               | Starting...
system()                       | [DEBUG]
[ERROR]: Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

StackTrace:
#0 /var/www/ispcp/gui/include/ispCP/Initializer.php(201): ispCP_Initializer->_initializeDatabase()
#1 /var/www/ispcp/gui/include/ispCP/Initializer.php(102): ispCP_Initializer->_processCLI()
#2 /var/www/ispcp/gui/include/environment.php(235): ispCP_Initializer::run(Object(ispCP_Config_Handler_File))
#3 /var/www/ispcp/gui/include/ispcp-lib.php(115): require_once('/var/www/ispcp/...')
#4 /var/www/ispcp/engine/setup/updDB.php(44): require_once('/var/www/ispcp/...')
#5 {main}



sys_command_rs()               | Ending...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 1
getCmdExitValue()              | Ending...
exit_msg()                     | Starting...
exit_msg()                     | Ending...
del_file()                     | Starting...
del_file()                     | Ending...

Debian Lenny, 32-bit, no mods.

I hope you can help me out, as half of my services aren't running at the moment.
(This post was last modified: 04-18-2011 08:57 PM by irix.)
04-18-2011 08:52 PM
Find all posts by this user Quote this message in a reply
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #2
RE: 1.0.7 upgrade problem
(04-18-2011 08:52 PM)irix Wrote:  Hi all.

I've had a little problem with ispcp 1.0.6:

My phptemp folder was gone
My reseller folder was gone

I thought I might have to upgrade, so I followed the instructions on: http://isp-control.net/documentation/sta...ade/debian
(I have Lenny, so everythins is done accordingly).

Then I came to the well known password problem, so I removed the password from ispcp.conf and .old file, reset it with the correct root password through ispcp-db-passwd which went ok, I still get an error when updating:

Code:
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
makepath()                     | Starting...
makepath()                     | [NOTICE] '/var/log/ispcp/setup' exists ! Setting its permissions...
setfmode()                     | Starting...
setfmode()                     | Ending...
makepath()                     | Ending...
update_startup()               | Starting...
del_file()                     | Starting...
del_file()                     | [ERROR] File '/tmp/ispcp-setup.log' does not exist !
lock_system()                  | Starting...
lock_system()                  | Ending...
update_startup()               | Ending...
update_engine()                | Starting...
user_dialog()                  | Starting...
welcome_note()                 | Starting...
welcome_note()                 | Ending...
warn_msg()                     | Starting...
warn_msg()                     | Ending...
user_dialog()                  | Ending...
stop_services()                | Starting...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP Network Traffic Logger: ispcp_network
ispcp_network is already stopped (warning).
.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_network stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_daemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping domain name service...: bind9rndc: connect failed: 127.0.0.1#953: connection refused
.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/bind9 stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] httpd (no pid file) not running
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/usr/sbin/apache2ctl stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ftp server: proftpd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/proftpd stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping policyd-weight (incl. cache): policyd-weight.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/policyd-weight stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Postfix Mail Transport Agent: postfix.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/postfix stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier authentication services: authdaemond.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-authdaemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier POP3 server: pop3d.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-pop stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier IMAP server: imapd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-imap stop') | Ending...
stop_services()                | Ending...
load_old_ispcp_config()        | Starting...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
load_old_ispcp_config()        | Ending...
update_ispcp_cfg()             | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
store_conf()                   | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
store_file()                   | Starting...
setfmode()                     | Starting...
setfmode()                     | Ending...
store_file()                   | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Ending...
update_ispcp_cfg()             | Ending...
check_ispcp_cfg_file()         | Starting...
check_ispcp_cfg_file()         | Ending...
preinst()                      | Starting...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst()                      | Ending...
update_database_schema()       | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
sys_command_rs()               | Starting...
system()                       | [DEBUG]
[ERROR]: Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

StackTrace:
#0 /var/www/ispcp/gui/include/ispCP/Initializer.php(201): ispCP_Initializer->_initializeDatabase()
#1 /var/www/ispcp/gui/include/ispCP/Initializer.php(102): ispCP_Initializer->_processCLI()
#2 /var/www/ispcp/gui/include/environment.php(235): ispCP_Initializer::run(Object(ispCP_Config_Handler_File))
#3 /var/www/ispcp/gui/include/ispcp-lib.php(115): require_once('/var/www/ispcp/...')
#4 /var/www/ispcp/engine/setup/updDB.php(44): require_once('/var/www/ispcp/...')
#5 {main}



sys_command_rs()               | Ending...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 1
getCmdExitValue()              | Ending...
exit_msg()                     | Starting...
exit_msg()                     | Ending...
del_file()                     | Starting...
del_file()                     | Ending...

Debian Lenny, 32-bit, no mods.

I hope you can help me out, as half of my services aren't running at the moment.

Probably you need to recover the keys from a previous backup:
.- /var/www/ispcp/engine/ispcp-db-keys.pl
.- /var/www/ispcp/engine/messenger/ispcp-db-keys.pl
.- /var/www/ispcp/gui/include/ispcp-db-keys.php
04-19-2011 01:10 AM
Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #3
RE: 1.0.7 upgrade problem
(04-19-2011 01:10 AM)aseques Wrote:  Probably you need to recover the keys from a previous backup:
.- /var/www/ispcp/engine/ispcp-db-keys.pl
.- /var/www/ispcp/engine/messenger/ispcp-db-keys.pl
.- /var/www/ispcp/gui/include/ispcp-db-keys.php

They were all the same. Replaced it, retried, same result:

Code:
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
makepath()                     | Starting...
makepath()                     | [NOTICE] '/var/log/ispcp/setup' exists ! Setting its permissions...
setfmode()                     | Starting...
setfmode()                     | Ending...
makepath()                     | Ending...
update_startup()               | Starting...
del_file()                     | Starting...
del_file()                     | [ERROR] File '/tmp/ispcp-setup.log' does not exist !
lock_system()                  | Starting...
lock_system()                  | Ending...
update_startup()               | Ending...
update_engine()                | Starting...
user_dialog()                  | Starting...
welcome_note()                 | Starting...
welcome_note()                 | Ending...
warn_msg()                     | Starting...
warn_msg()                     | Ending...
user_dialog()                  | Ending...
stop_services()                | Starting...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP Network Traffic Logger: ispcp_network failed!
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_network stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_daemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping domain name service...: bind9 waiting for pid 3123 to die.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/bind9 stop') | Ending...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/usr/sbin/apache2ctl stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ftp server: proftpd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/proftpd stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping policyd-weight (incl. cache): policyd-weight.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/policyd-weight stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Postfix Mail Transport Agent: postfix.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/postfix stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier authentication services: authdaemond.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-authdaemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier POP3 server: pop3d.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-pop stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier IMAP server: imapd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-imap stop') | Ending...
stop_services()                | Ending...
load_old_ispcp_config()        | Starting...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
load_old_ispcp_config()        | Ending...
update_ispcp_cfg()             | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
store_file()                   | Starting...
setfmode()                     | Starting...
setfmode()                     | Ending...
store_file()                   | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Ending...
update_ispcp_cfg()             | Ending...
check_ispcp_cfg_file()         | Starting...
check_ispcp_cfg_file()         | Ending...
preinst()                      | Starting...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst()                      | Ending...
update_database_schema()       | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
sys_command_rs()               | Starting...
system()                       | [DEBUG]
[ERROR]: Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

StackTrace:
#0 /var/www/ispcp/gui/include/ispCP/Initializer.php(201): ispCP_Initializer->_initializeDatabase()
#1 /var/www/ispcp/gui/include/ispCP/Initializer.php(102): ispCP_Initializer->_processCLI()
#2 /var/www/ispcp/gui/include/environment.php(235): ispCP_Initializer::run(Object(ispCP_Config_Handler_File))
#3 /var/www/ispcp/gui/include/ispcp-lib.php(115): require_once('/var/www/ispcp/...')
#4 /var/www/ispcp/engine/setup/updDB.php(44): require_once('/var/www/ispcp/...')
#5 {main}



sys_command_rs()               | Ending...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 1
getCmdExitValue()              | Ending...
exit_msg()                     | Starting...
exit_msg()                     | Ending...
del_file()                     | Starting...
del_file()                     | Ending...
04-19-2011 01:27 AM
Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #4
RE: 1.0.7 upgrade problem
I also get lots of error through mail now:

Code:
Dear admin,

An exception with the following message was raised in file
/var/www/ispcp/gui/include/ispCP/Initializer.php (Line: 382):

=================================================================

Error: Unable to establish connection to the database! SQL returned:
SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost'
(using password: YES)
=================================================================

Debug backtrace:
---------------

File: /var/www/ispcp/gui/include/ispCP/Initializer.php (Line: 153)
Method: ispCP_Initializer::_initializeDatabase()
File: /var/www/ispcp/gui/include/ispCP/Initializer.php (Line: 102)
Method: ispCP_Initializer::_processAll()
File: /var/www/ispcp/gui/include/environment.php (Line: 235)
Method: ispCP_Initializer::run()
File: /var/www/ispcp/gui/include/ispcp-lib.php (Line: 115)
Function: require_once()
File: /var/www/ispcp/gui/index.php (Line: 31)
Function: require()

Additional information:
----------------------

Http User Agent: NSV Player/0.0 (ultravox/2.0)
Request Uri: /
Remote Addr: 64.12.243.206
Server Addr: 192.168.1.75

____________________________________________________________
ispCP Exception Mail Writer


Note: If the same exception is raised several times, this mail will
not be re-send before 6 hours.

or with:

Code:
Additional information:
----------------------

Request Uri: 64.85.162.206:6667
Remote Addr: 69.162.65.77
Server Addr: 192.168.1.75

What are they trying to do?
04-19-2011 09:00 AM
Find all posts by this user Quote this message in a reply
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #5
RE: 1.0.7 upgrade problem
Have you done this? Cause it really looks like a database issue on your case.

http://isp-control.net/forum/thread-10465-page-2.html
04-19-2011 05:22 PM
Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #6
RE: 1.0.7 upgrade problem
Hi,

I did what roajayson said there, it does not work for me.
I also looked at what ctct said: the hashes were not empty and all the same.

Remember I never changed anything and all of a sudden some folders were gone. I think there is more to it, bottom line is I stil cannot update.
04-19-2011 06:54 PM
Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #7
RE: 1.0.7 upgrade problem
The problem is still there, so:

no webmail
no control panel
no phpmyadmin
and so on

please help?
04-30-2011 04:22 AM
Find all posts by this user Quote this message in a reply
kilburn Offline
Development Team
*****
Dev Team

Posts: 2,182
Joined: Feb 2007
Reputation: 34
Post: #8
RE: 1.0.7 upgrade problem
Make sure that you only have one version of the configuration file (backup out any /etc/ispcp/ispcp.conf.old or similar, leaving only /etc/ispcp/ispcp.conf there), and that it has the correct (encrypted) password in there.

Retry after that, and everything should work...
04-30-2011 06:22 PM
Visit this user's website Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #9
RE: 1.0.7 upgrade problem
That does not work:

Code:
Starting ispCP update
         * Stopping services: ..........                               [ Done ]

        ispCP main configuration file
         * Loading old ispCP configuration file:

        Please enter path to your ispcp.old.conf [/etc/ispcp/ispcp.old.conf]:

When I copy the new one as .old too and enter I get:

Code:
[ Done ]
         * Update ispCP configuration file:                                               [ Done ]
         * Check ispCP configuration file:                                                [ Done ]

        Pre-installation tasks for Debian
         * Postgrey configuration (Updating listening port):                              [ Done ]

        ispCP database
         * Update ispCP database schema:                                                [ Failed ]

        [FATAL] An error occurred during update process!
        Correct it and re-run this program.

        Log files are stored in /var/log/ispcp/setup
        You can also find help at http://isp-control.net/forum

I do seem to have a different error now:

Code:
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
makepath()                     | Starting...
makepath()                     | [NOTICE] '/var/log/ispcp/setup' exists ! Setting its permissions...
setfmode()                     | Starting...
setfmode()                     | Ending...
makepath()                     | Ending...
update_startup()               | Starting...
del_file()                     | Starting...
del_file()                     | [ERROR] File '/tmp/ispcp-setup.log' does not exist !
lock_system()                  | Starting...
lock_system()                  | Ending...
update_startup()               | Ending...
update_engine()                | Starting...
user_dialog()                  | Starting...
welcome_note()                 | Starting...
welcome_note()                 | Ending...
warn_msg()                     | Starting...
warn_msg()                     | Ending...
user_dialog()                  | Ending...
stop_services()                | Starting...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP Network Traffic Logger: ispcp_network.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_network stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_daemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping domain name service...: bind9 waiting for pid 2122 to die.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/bind9 stop') | Ending...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/usr/sbin/apache2ctl stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ftp server: proftpd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/proftpd stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping policyd-weight (incl. cache): policyd-weight.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/policyd-weight stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Postfix Mail Transport Agent: postfix.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/postfix stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier authentication services: authdaemond.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-authdaemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier POP3 server: pop3d.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-pop stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier IMAP server: imapd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-imap stop') | Ending...
stop_services()                | Ending...
load_old_ispcp_config()        | Starting...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '/etc/ispcp/ispcp.old.conf' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] Undefined input data, fname: || !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '        Starting ispCP update' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '         * Stopping services: ..........                               [ Done ]' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] Undefined input data, fname: || !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '        ispCP main configuration file' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '         * Loading old ispCP configuration file:' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] Undefined input data, fname: || !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] File '        Please enter path to your ispcp.old.conf [/etc/ispcp/ispcp.old.conf]:' does not exist !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | [ERROR] Undefined input data, fname: || !
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
load_old_ispcp_config()        | Ending...
update_ispcp_cfg()             | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
store_file()                   | Starting...
setfmode()                     | Starting...
setfmode()                     | Ending...
store_file()                   | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Ending...
update_ispcp_cfg()             | Ending...
check_ispcp_cfg_file()         | Starting...
check_ispcp_cfg_file()         | Ending...
preinst()                      | Starting...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst()                      | Ending...
update_database_schema()       | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
sys_command_rs()               | Starting...
system()                       | [DEBUG]
[ERROR]: Database update 33 failed:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.config' doesn't exist
Query: DELETE IGNORE FROM
                    `ispcp`.`config`
                WHERE
                    `config`.`name` = 'CRITICAL_UPDATE_REVISION'
                ;

sys_command_rs()               | Ending...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 1
getCmdExitValue()              | Ending...
exit_msg()                     | Starting...
exit_msg()                     | Ending...
del_file()                     | Starting...
del_file()                     | Ending...

Especially:

Code:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.config' doesn't exist
Query: DELETE IGNORE FROM
                    `ispcp`.`config`
                WHERE
                    `config`.`name` = 'CRITICAL_UPDATE_REVISION'
                ;

My db name is not ispcp!
In the config and config.old the correct db name is there.
(This post was last modified: 04-30-2011 07:22 PM by irix.)
04-30-2011 07:11 PM
Find all posts by this user Quote this message in a reply
irix Offline
Junior Member
*

Posts: 17
Joined: May 2010
Reputation: 0
Post: #10
RE: 1.0.7 upgrade problem
At the moment I'm real desparate because I really need to add some websites to my server and I can't because I can't use ISPCP.
Please any hints on how to fix this!
05-29-2011 11:21 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)