Upgrade 11.09 #1 to #2 now get apache user error?

[KTeller]

Error:

New files of configuration for Apache web server were not built due to errors in configuration templates: Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES). The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating broken configuration or click here to retry generating of all configurations.


Now i got no email (it said it sent one but i didnt get it)

when i click both links, i get the go ahead that it worked, but error doesnt leave home page:

In the App section i have this:

Error
Internal error: [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)

Message [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
File aps_php.php
Line 7536
Type Exception

 

[IgorG]

Look at thread http://forum.parallels.com/showthread.php?t=260538

 

[KTeller]

i went thru that page and still have the error:

if there's a way to revert to the older parallels that you upgraded from?

 

[IgorG]

Downgrade is impossible for Plesk. There are several KB articles aboou problem with Apache configuration. Did you try to find and apply them?

 

[KTeller]

yes, i did based on the info i found.

can you tell me what configurations changed from 11.09 #1 to 2? everything was fine, till upgrade to 11.9 #2.

 

[KTeller]

[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
File aps_php.php
Line 7536
Type Exception


error in the apps panel..

Is there any info on this?

 

[IgorG]

[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
File aps_php.php
Line 7536
Type Exception


error in the apps panel..

Is there any info on this?

Did you try this solution from mentioned thread? http://forum.parallels.com/showpost.php?p=628554&postcount=18

 

[KTeller]

yes sir i did,

aps_password | t**********P | is a long string looks to be encrypted.. tried with that long string.. nothing updated

 

[KTeller]

the encrypted pass word, can it be changed to plain text in phpmyadmin.. using MD5 maybe that would work?

 

[Evilmachine]

Same problem here.

Password mismatch after upgrade in the night.

Due to password is encrypted in the psa.misc tsble i am not able to set that as new password.

seems to be a massive problem.

The much bigger problem is that after the bootrapper repair the apache config istn working anymore after nginx was running.

And without the Panel there will nothing be changed.

 

[Evilmachine]

Found a temporary solution for the APS Problem.

mysql -u root -p
Enter your password:
mysql> UPDATE `psa`.`misc` SET `val` = 'password' WHERE `misc`.`param` = 'aps_password';
mysql> update mysql.user set password=PASSWORD('password') where User='apsc';

After that the password in unencrypted in the database but Plesk can read it so i think that new Encryption feature is not working.

Panel and recreation of configuration files are working again after this.

 

[Nikolay.]

KTeller, Evilmachine, proper workaround is following:

# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/register_apsc_database.php --register -host localhost -port 3306 -database apsc -login apsc -password "`< /dev/urandom tr -dc 'A-Za-z0-9_' | head -c 12 `"

Of course, you should replace arguments other than -password with their current values in misc, if they differ:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e 'select * from misc where param like "aps%"'

AFAIK, replacing password with plain text directly in DB will also work, but this solution is preferable.

 

[Kirill K]

This issue was fixed. Please install MU#3 using autoinstaller.

 

[IgorG]

Parallels Plesk Panel 11.0.9 MU#3 - http://kb.parallels.com/en/114271

 

[GravuTrad]

KTeller, Evilmachine, proper workaround is following:


Of course, you should replace arguments other than -password with their current values in misc, if they differ:



AFAIK, replacing password with plain text directly in DB will also work, but this solution is preferable.

I still have:

ERROR: Exception: ODBC error #HY000: [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)

Additionally, an exception has occurred while trying to report this error: Exception
ODBC error #HY000: [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES) (aps_php.php:12519)

even after this workaround. How to solve this please?

 

[GravuTrad]

Fixed with:

/usr/local/psa/var/fix_apsc_password