+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: [howto] RC7 => 1.0.x Upgrade Problem with Access Denied (/thread-7689.html)
[howto] RC7 => 1.0.x Upgrade Problem with Access Denied - icat - 08-28-2009 11:35 PM
If people run in to the problem like me during upgrade from rc7 to 1.0.x "Access Denied". Consider the belowing steps:
1: Don't give here root for the ftp user when your asked for
Please enter ispCP ftp SQL user. [vftp]:
Upgrade process will delete this user (see ispcp-update):
DELETE FROM tables_priv WHERE Host = '$hostname' AND Db = '$main::db_name' AND User = '$vftp_sql_user'
AND
DELETE FROM user WHERE Host = '$hostname' AND User = '$vftp_sql_user'
2: If you don't have vftp user and password, you can look for in
proftpd.conf in /etc/proftpd
If the user there is also root, you can look for vftp user in MySQL DB and change the Password in both MySQL and proftpd.conf
3: Restart ispCP upgrade-process
If you already run into this problem, then you propably dont have root acces to the database.
To reanimate the root user, you have to create the root user in MySQL with all the privaladges again.