Admin-Login: Access denied for user 'apsc'@'localhost'

[hassi2k7]

hi there,

i updated my plesk 9 to the current plesk10 release. all services are running correctly and my websites are all online - perfect, so far

but if i try to login into the plesk panel (with the admin user) i recieve this error:

Operation failed

[MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)[MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
---------------------- Debug Info -------------------------------
0: aps_php.php:8020
aps_controller_registry_getpackage(resource, string '')
1: aps_php.php:8020
APS_Controller_Registry->getPackage(NULL null)
2: Config.php:26
HelpDesk_Config::getHelpDeskInstances()
3: NavigationContext.php:356
NavigationContext->_fetchHelpDeskSectionNodes(object of type UserAdmin)
4: NavigationContext.php:210
NavigationContext->fetchCustomButtonsSectionNodes(object of type UserAdmin)
5: NavigationContext.php:75
NavigationContext->fetchSection(object of type UserAdmin, string 'custom_buttons', array)
6: NavigationContext.php:416
NavigationContext->get(object of type UserAdmin)
7: Navigation.php:100
Navigation->getUserContextList(object of type UserAdmin)
8: Navigation.php:118
Navigation->getRoot(object of type UserAdmin)
9: Navigation.php:362
Navigation->buildPathbar(string '/license.php3', NULL null, object of type UserAdmin, string 'dashboard')
10: Navigation.php:353
Navigation->getPathbar(NULL null)
11: Navigation.php:149
Navigation->detectCurrentUpLevelURI()
12: Abstract.php:306
Form_Abstract->_getUpLevelLink()
13: Abstract.php:315
Form_Abstract->renderPathbarButton(object of type Navigation, NULL null)
14: Form.php:111
Form->assign()
15: license.php3:75


How can i solve the problem?

thanks for help

best regards

 

[IgorG]

Strange that you have 'aspc' user there. It should be 'admin'. Look at article http://kb.parallels.com/en/1561

 

[hassi2k7]

thank you for your reply.
i resetted the admin password with the command in your link. but if i try to login with 'admin' i get the same error as before "Access denied for user 'apsc'@'localhost'"

what should i do?

 

[IgorG]

Perhaps you have incorrect password for aspc user. Check it with following steps:

1. Find password with following SQL command:

"%plesk_bin%\dbclient" --direct-sql --sql="select * from misc where param like '%aps%'"

You will see something like

param val

aps_database apsc

aps_host 127.0.0.1

aps_login apsc

aps_password XXXXXXXXX

aps_port 8306

2. Check that password is correct:

"%plesk_dir%\MySQL\bin\mysql" -uapsc -pXXXXXXXXX -P 8306

 

[hassi2k7]

thanks for help. the password seems to be wrong "Access denied" (or maybe the user doesnt exist anymore?)

how can i solve this problem?

 

[IgorG]

What sort of engine for psa database? MSSQL or MySQL?

 

[hassi2k7]

its a MySQL database

 

[IgorG]

Looks like database of APS controller was not created during upgrade procedure for some reasons. I suggest you contact Support Team. They will correctly create this database for you and fix this issue.

 

[hassi2k7]

okay, thank you for your help. but to contact the support i have to register an licence-key.

i think that the keys are displayed in the plesk admin panel (but i cant login into that, cause of my problem)

i have no idea how to find the licence-key - what i have to do now?

thank you again

 

[IgorG]

Look at screenshot - http://tinyurl.com/7wscntn

 

[hassi2k7]

hm, no idea what you mean. its a screenshot of the plesk panel. and i cant login into it. so i have no chance to get this screen on my machine.. or whats the idea?

 

[IgorG]

What about

"%plesk_bin%\keymng.exe" --get-key-number

 

[hassi2k7]

i was able to find out my plesk licence-key. but if i enter it on the support-form, i get this error:

Our records indicate that your license belongs to one of Parallels Partners/Resellers. As such, they are your first point of contact for support and general inquiry.

The problem is, thats the licence is from 1&1 company, but they dont offer support for root servers, so i cant contact them for this problem.... what should i do now?

 

[IgorG]

You can buy per-incident support.

 

[aachen]

Good business modell

You can buy per-incident support.

Yes, this is a new and profitable business modell. Make a programming error and let the customer pay for support. Well done...
I have the same error when trying to get into the application fault. I want to install sitebuilder. Not because I need it, just because the Backup always ends with error on sitebuilder backup, which is not installed.

And you do not get any support from anyone. Well done.

 

[IgorG]

You can submit ticket to support regarding this problem. Support guys will help you and if it is really Plesk bug you will be refunded for this ticket.

 

[yatint]

Hello

Go to mysql command prompt with port 8306 and execute below sql quries :

UPDATE `psa`.`misc` SET `val` = '1qazXSW@' WHERE `misc`.`param` = 'aps_password';
update mysql.user set password=PASSWORD('1qazXSW@') where User='apsc';

This will fix your issue

Thanks

hi there,

i updated my plesk 9 to the current plesk10 release. all services are running correctly and my websites are all online - perfect, so far

but if i try to login into the plesk panel (with the admin user) i recieve this error:

Operation failed

[MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)[MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
---------------------- Debug Info -------------------------------
0: aps_php.php:8020
aps_controller_registry_getpackage(resource, string '')
1: aps_php.php:8020
APS_Controller_Registry->getPackage(NULL null)
2: Config.php:26
HelpDesk_Config::getHelpDeskInstances()
3: NavigationContext.php:356
NavigationContext->_fetchHelpDeskSectionNodes(object of type UserAdmin)
4: NavigationContext.php:210
NavigationContext->fetchCustomButtonsSectionNodes(object of type UserAdmin)
5: NavigationContext.php:75
NavigationContext->fetchSection(object of type UserAdmin, string 'custom_buttons', array)
6: NavigationContext.php:416
NavigationContext->get(object of type UserAdmin)
7: Navigation.php:100
Navigation->getUserContextList(object of type UserAdmin)
8: Navigation.php:118
Navigation->getRoot(object of type UserAdmin)
9: Navigation.php:362
Navigation->buildPathbar(string '/license.php3', NULL null, object of type UserAdmin, string 'dashboard')
10: Navigation.php:353
Navigation->getPathbar(NULL null)
11: Navigation.php:149
Navigation->detectCurrentUpLevelURI()
12: Abstract.php:306
Form_Abstract->_getUpLevelLink()
13: Abstract.php:315
Form_Abstract->renderPathbarButton(object of type Navigation, NULL null)
14: Form.php:111
Form->assign()
15: license.php3:75


How can i solve the problem?

thanks for help

best regards

 

[JoswaldM]

User apsc deleted

Hello

Go to mysql command prompt with port 8306 and execute below sql quries :

UPDATE `psa`.`misc` SET `val` = '1qazXSW@' WHERE `misc`.`param` = 'aps_password';
update mysql.user set password=PASSWORD('1qazXSW@') where User='apsc';

This will fix your issue

Thanks

What can I do if user apsc@localhost was deleted? Does exist a script for creating the user? In case of doing manually which permissions do I need to grant for the user?

Regards,

 

[maxxchen]

<Access denied for user 'apsc'@'localhost'

This here is just for the Fact that Google spits this page out as main result for this error

This is for Plesk 11.5 on Linux. In http://kb.parallels.com/en/117621 advice is to run mass-password-reset to fix this, because password in misc is crypted in plesk 11.5
Beware folks, this will reset all passwords! I don't wanted to do that so i followed second part for earlier Plesk versions in #117621 but with a little twist as the password must be crypted in table misc.

1. Chose a Password, set this as Plesk panel admin password
2. Got Crypted password from /etc/psa/.psa.shadow, put that in in sql table misc

update misc set val='$AES-128-CBC$and_so_on_password_hash' where param='aps_password';

3. Used plain password to set password for SQL User

update user set password=password('plainpasswordhere') where user='apsc';

4. Set Permissions ( Wasn't working without that)

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` mysql -e "grant all privileges on apsc.* to 'apsc'@'localhost' identified by '<non_encrypted_passwd>'"

5. reset admin's plesk password to old one

Worked again.