1. Welcome to the new MacRumors forums. See our announcement and read our FAQ

MySQL does not work

Discussion in 'Mac Programming' started by Mag3llan, Nov 13, 2010.

  1. macrumors newbie

    #1
    Hi! I just started learning php, and been using xampp for a little while now. It has worked very well untill now. I had some permission issues with a file so i thought, why not change the whole applications folder to read/write capability. But when i did that everything stopped working. I tried to fix it using the disk utility tool, but it still does not work. I can start apache and FTP but when I try to start mySQL i get this message: The operation couldn’t be completed. (XAMPPErrorDomain error 1.). I can't log in to phpmyadmin either. I also changed the whole xampp folder to read/write capability but still does not work. I think it must be a permissions problem but I can't figure out what to do...

    The xampp error log says:

    [Thu Nov 11 23:40:11 2010] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
    [Thu Nov 11 23:40:13 2010] [notice] Digest: generating secret for digest authentication ...
    [Thu Nov 11 23:40:13 2010] [notice] Digest: done
    [Thu Nov 11 23:40:15 2010] [notice] Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
    [Thu Nov 11 23:43:46 2010] [notice] caught SIGTERM, shutting down
    [Thu Nov 11 23:43:53 2010] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
    [Thu Nov 11 23:43:54 2010] [notice] Digest: generating secret for digest authentication ...
    [Thu Nov 11 23:43:54 2010] [notice] Digest: done
    [Thu Nov 11 23:43:54 2010] [notice] Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations

    I hope someone here has a solution so I can continue to learn PHP!

    Thank you!// Magellan
     
  2. Moderator emeritus

    angelwatt

    #2
  3. macrumors newbie

    #3
    When I try to access my site I get this error:

    Warning: session_start() [function.session-start]: open(/Applications/XAMPP/xamppfiles/temp//sess_463648763e2efe61375f04ab0c255f00, O_RDWR) failed: Permission denied (13) in /Applications/XAMPP/xamppfiles/htdocs/oslo/login.php on line 3

    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /Applications/XAMPP/xamppfiles/htdocs/oslo/login.php:3) in /Applications/XAMPP/xamppfiles/htdocs/oslo/login.php on line 3

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /Applications/XAMPP/xamppfiles/htdocs/oslo/login.php:3) in /Applications/XAMPP/xamppfiles/htdocs/oslo/login.php on line 3

    I am not very familiar with mac since I just started using it.

    Hope this helps...
     
  4. Moderator emeritus

    angelwatt

    #4
    The first error is about permissions. You'll need to make sure the XAMPP folder has permissions that let you and the web server have read, write, and execute permissions. You can probably change this by selecting the XAMPP folder from Finder and do a Get Info, then set the permissions at the bottom. Make sure System and your account have read/write.

    The other two errors are related to PHP code. The code appears to be attempting to adjust a header after some output has been sent to the browser. Read the manual for header to see how to resolve the issue with your code.
     
  5. macrumors 6502a

    #5
    The second and third errors are being triggered by the first, as angelwatt says check the file permissions, or switch to MAMP which works fine on my system.

    Also, are you using an Administrator account? If not, that may be why you can't write to the Applications directory.
     
  6. macrumors member

    #6
    Another vote for MAMP. It works fine on my system as well. I hope this helps.
     
  7. macrumors newbie

    #7
    I am administrator and I have read/write permission on all files in the xampp folder. so that is not it... but thanks anyway! I think i will try MAMP...
     
  8. macrumors 68020

    #8
    thread title is wrong...

    ... I don't know what any of this stuff is all about, but it's certainly not about MySQL, which works fine.
     
  9. macrumors member

    #9
    I used the following book to help me with installing and configuring LAMP: http://www.amazon.com/Web-Database-Applications-PHP-MySQL/dp/0596005431/ref=sr_1_5?ie=UTF8&qid=1289997556&sr=8-5

    I was a total newbie to LAMP before I built my first personal web database application. I learned PHP syntax and how it interacts with MySQL, etc.. This book helped a lot.

    When I got a new Mac Mini, I then ported over my web app to MAMP. I followed the installation and configuration directions from the MAMP site. Once I got the entire MAMP stack configured, the database imported, and the PHP code placed in the correct directories, everything worked.

    Good Luck!
     

Share This Page