ispCP 1.0.2 update to 1.0.3-1 database problem [SOLVED]

[alectronic]

Hi,

i had an excellent running iscCP 1.0.2 before. I followed ALL instructions in /ispcp-omega-1.0.3/docs/Debian/INSTALL rgd. the update. INSTALLED all new dependencies with aptitude as desribed.

Running "perl ispcp-update" i receive:

ispCP database
Update ispCP database schema: [failed]

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


Wow. Great. Looking into /tmp/ispcp-update-database.log i find:

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)


Yeah, sure.. I didn't do anything with or to the db since first install. So i read in these forums, that ispCP's crappy code might not handle passwords with special characters like "$". My db password was long, but without this character. I changed it into a very simple password with mysql and with /var/www/ispcp/engine/ispcp-db-passwd.


Still, i receive that dumb error. Any ideas? Any other logfiles that could help?


Thank you


alectronic

---

SOLVED:

The /var/www/ispcp/engine/ispcp-db-passwd changed the password in /etc/ispcp/ispcp.conf

However, the /var/www/ispcp/engine/setup/ispcp-update OVERWRITES this new information with the info from ispcp.old.conf everytime it is run.

So be aware to change the DATABASE_PASSWORD value MANUALLY ALSO in ispcp.old.conf with the information from ispcp.conf.