1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by hassi2k7, Apr 19, 2012.

  1. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    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
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  3. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    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?
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Perhaps you have incorrect password for aspc user. Check it with following steps:

    1. Find password with following SQL command:

    You will see something like

    2. Check that password is correct:
     
  5. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    thanks for help. the password seems to be wrong "Access denied" (or maybe the user doesnt exist anymore?)

    how can i solve this problem?
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    What sort of engine for psa database? MSSQL or MySQL?
     
  7. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    its a MySQL database
     
  8. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    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.
     
  9. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    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 :)
     
  10. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  11. hassi2k7

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    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?
     
  12. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    What about

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

    hassi2k7 New Pleskian

    10
    85%
    Joined:
    Apr 19, 2012
    Messages:
    11
    Likes Received:
    0
    i was able to find out my plesk licence-key. but if i enter it on the support-form, i get this error:
    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?
     
  14. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    You can buy per-incident support.
     
  15. aachen

    aachen New Pleskian

    22
    20%
    Joined:
    Mar 20, 2006
    Messages:
    6
    Likes Received:
    0
    Good business modell

    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.
     
  16. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    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.
     
  17. yatint

    yatint Basic Pleskian

    19
    60%
    Joined:
    Aug 2, 2010
    Messages:
    91
    Likes Received:
    0
    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

     
  18. JoswaldM

    JoswaldM New Pleskian

    6
    20%
    Joined:
    May 23, 2013
    Messages:
    2
    Likes Received:
    0
    User apsc deleted

    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,
     
  19. maxxchen

    maxxchen New Pleskian

    15
    55%
    Joined:
    Nov 18, 2010
    Messages:
    1
    Likes Received:
    0
    <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.
     
Loading...