Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For some reason, MySQL won't start anymore. Suddenly happened out of the blue.

This is what is written in

/var/log/system.log

right after I try to open MySQL.

Feb  8 16:07:31 mys-MacBook-Air.local System Preferences[2795]: about to perform command
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Got user: mybak
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Got ruser: (null)
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Got service: authorization
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in od_principal_for_user(): No authentication authority returned
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in od_principal_for_user(): failed: 7
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Failed to determine Kerberos principal name.
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Done cleanup3
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): Kerberos 5 refuses you
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_authenticate(): pam_sm_authenticate: ntlm
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_acct_mgmt(): OpenDirectory - Membership cache TTL set to 1800.
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in od_record_check_pwpolicy(): retval: 0
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in od_record_attribute_create_cfstring(): returned 2 attributes for dsAttrTypeStandard:AuthenticationAuthority
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Establishing credentials
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Got user: mybak
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Context initialised
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Got euid, egid: 0 0
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Done getpwnam()
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Done setegid() & seteuid()
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): pam_sm_setcred: krb5 user mybak doesn't have a principal
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Done cleanup3
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Done seteuid() & setegid()
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): Done cleanup4
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): pam_sm_setcred: ntlm
Feb  8 16:07:36 mys-MacBook-Air.local authorizationhost[4202]: in pam_sm_setcred(): pam_sm_setcred: no domain found skipping
Feb  8 16:07:36 mys-MacBook-Air.local com.apple.SecurityServer[15]: UID 501 authenticated as user mybak (UID 501) for right 'com.mysql.administrator.server'
Feb  8 16:07:36 mys-MacBook-Air.local com.apple.SecurityServer[15]: Succeeded authorizing right 'com.mysql.administrator.server' by client '/Users/mybak/Library/PreferencePanes/MySQL.pre\
fPane/Contents/Resources/mahelper' [4200] for authorization created by '/Applications/System Preferences.app' [2795] (100003,0)
Feb  8 16:07:36 mys-MacBook-Air.local coreservicesd[26]: Application App:"System Preferences" [ 0x0/0xc40c4]  @ 0x0x7fe49cb90aa0 tried to be brought forward, but isn't in fPermittedFrontASN\
s ( ( ASN:0x0-0xe40e4:) ), so denying.
Feb  8 16:07:36 mys-MacBook-Air.local WindowServer[176]: [cps/setfront] Failed setting the front application to System Preferences, psn 0x0-0xc40c4, securitySessionID=0x186a4, err=-13066
Feb  8 16:07:39 mys-MacBook-Air.local System Preferences[2795]: status= 0

Further googling these lines did not return any clues.

share|improve this question
    
Same problem here with fresh install. – E.Freitas Feb 21 '13 at 0:38
    
You might have better luck in Stackoverflow. – Enrico Susatyo Feb 21 '13 at 5:13
    
Perhaps superuser might be more appropriate? – The Unfun Cat Feb 21 '13 at 6:49
    
Several questions about mysql in stack overflow base troubleshooting on a config file in /etc, which does not exist in the Mac version. – WGroleau Dec 2 '15 at 22:36

You can try and disable pam authentication under your ssh server and see if that helps

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.