+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: SQL Update Failed (/thread-3074.html)
SQL Update Failed - metalmessiah - 04-18-2008 05:05 AM
Hy,
I'm going to update from RC2c to RC4, I did all steps on the Documentation. By starting perl ispcp-update, I get the follow error:
Code:
Welcome to ispCP '1.0.0 RC4 OMEGA' Update Dialog.
This program will update your VHCS / ispCP OMEGA system on your server.
Please make sure you have a backup of your server data.
NOTE: During the migration process some or all services might require to be
shut down or restarted.
Please select from which version you want to update:
(1) VHCS 2.4.7 or VHCS 2.4.7.1
(2) VHCS 2.4.8 RC1
(3) ispCP OMEGA 1.0.0 RC2 (incl. b and c)
(4) ispCP OMEAG 1.0.0 RC3
(0) abort
Your selection: 3
Stopping vhcs2_daemon: No /var/www/vhcs2/daemon/vhcs2_daemon found running; none killed.
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
Stopping ispCP Network Traffic Logger: ispcp_network
* ispcp_network is already stopped
.
Upgrading system values ...
Use which PHP Version? (4 or 5). [5]:
Activate AWStats. [no]: yes
AWStats Mode:
Possible values [d]ynamic and [s]tatic. [dynamic]:
Use MySQL Prefix.
Possible values: [i]nfront, [b]ehind, [n]one. [none]:
done
Upgrading database structure...ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
SQL Update failed.Ispcp worked nice before, I didn't change any SQL Passwort in the /etc/ispcp/ispcp.conf, so what's the matter?
Regards.
RE: SQL Update Failed - metalmessiah - 04-21-2008 05:49 AM
No Ideas?
RE: SQL Update Failed - RatS - 04-21-2008 03:55 PM
two Ideas:
1) you have overwritten your key-files
2) there is a bug in the update script.
RE: SQL Update Failed - metalmessiah - 04-22-2008 03:41 AM
RatS Wrote:two Ideas:
1) you have overwritten your key-files
2) there is a bug in the update script.
So, what shall I do? Is it possible to override the update-script for a re-enter of my SQL pass?
Regards.
EDIT: I recovered the keys, update did finish successful, but when I'm going access my Logon Page I get this errors:
Code:
Notice: Undefined index: LOGIN_TEMPLATE_PATH in /var/www/ispcp/gui/include/system-message.php on line 37
Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(/system-message.tpl) is not within the allowed path(s): (/var/www/ispcp/gui/:/etc/ispcp/:/tmp/ispcp.lock:/proc/:/bin/df:/bin/mount:/var/log/rkhunter.log:/var/log/chkrootkit.log:/usr/share/php/) in /var/www/ispcp/gui/include/system-message.php on line 39
Notice: Undefined index: LOGIN_TEMPLATE_PATH in /var/www/ispcp/gui/include/system-message.php on line 41
Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(..//system-message.tpl) is not within the allowed path(s): (/var/www/ispcp/gui/:/etc/ispcp/:/tmp/ispcp.lock:/proc/:/bin/df:/bin/mount:/var/log/rkhunter.log:/var/log/chkrootkit.log:/usr/share/php/) in /var/www/ispcp/gui/include/system-message.php on line 43
ERROR: Unable to connect to SQL server !
SQL returned: Access denied for user 'root'@'localhost' (using password: YES)RE: SQL Update Failed - joximu - 04-22-2008 07:37 AM
http://www.isp-control.net/forum/error-after-succes-update-%28index-website%29-t-2943.html
RE: SQL Update Failed - metalmessiah - 04-23-2008 04:36 AM
joximu Wrote:http://www.isp-control.net/forum/error-after-succes-update-%28index-website%29-t-2943.htmlHi
That didn't work for me, I still have this error.
What should I recover from my backuped files before the update?
Regards.
RE: SQL Update Failed - metalmessiah - 04-23-2008 04:51 AM
Hi,
You forgot to say in the Upgrade Guide, that you must recopy all DB-Keys on the old place. Please add some lines on your Guide.
Regards
RE: SQL Update Failed - joximu - 04-23-2008 07:41 AM
The important message in your Log above is:
***
ERROR: Unable to connect to SQL server !
SQL returned: Access denied for user 'root'@'localhost' (using password: YES)
***