mysql/java problem

Discussion in 'Mac Help/Tips' started by mnkeybsness, Apr 4, 2003.

  1. mnkeybsness macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #1
    so i'm trying to learn a little something about php and mysql. so i went ahead on my powermac, running os x 10.2.4, installed php and mysql. got everything to work. for mysql admin, i am using yoursql. now, my friend wanted to run a small forum for a little ranting on his 10.2.4 server machine. so we downloaded phpbb2 just as i had and set it up and everything, but when it comes time to use yoursql to set up the database in mysql, we try to connect and we get the following error

    can anyone help?
     
  2. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #2
    also of note is that when i use the mysql manager in the utilities folder, mysql seems to NOT start up. i can click the start button, but nothing happens. the start button is still clickable.
     
  3. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #3
    What did you put as your server? I connected to my local MySQL database using YourSQL through "localhost:3306" as the server. Give it a shot.
     
  4. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #4
    still the same problem...i was actually trying both 127.0.0.1 and localhost
     
  5. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #5
    Were you able to start up MySQL successfully? You should be able to start MySQL up through Terminal.
     
  6. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
  7. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #7
    actually, that's the tutorial i used!

    but i'm still having that weird java error. and really, i'm not seeing how java has anything to do with mysql???
     
  8. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #8
    Not directly, but if the java is trying to connect to MySQL and it's not running then you'll get an error message.

    Have you run "top" to check if mysqld is running?
     
  9. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #9
    yah i checked "top"-

    mysql is not running.

    what's the deal?
     
  10. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #10
    Start up MySQL with the command "mysqld" in Terminal. Are you getting an error? If so, what does it say?
     
  11. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #11
    i believe you meant the command "mysql"

    this is my error...

     
  12. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #12
    Did you set up a mysql user, like the tutorial specifies?

    Also, make sure you're in the right directory when you use the "sudo ./bin/mysqld_safe &" command to start it up. I know I goofed on that a couple times and MySQL wouldn't start.
     
  13. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #13
    one more errors i'm finding...

    when trying to start the web server, i get this error:
     
  14. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #14
    Is that a line you added in httpd.conf, or just something you uncommented?
     
  15. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #15
    that's a line from when i try to update the php module...i think
     
  16. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #16
    It's when Apache tries to load the PHP module, but it's not finding it.
     
  17. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #17
    okay, well i've tried to reinstall php and still the same thing
     
  18. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #18
    Did you install a more recent version of PHP?

    The one that's included has always worked fine for me.
     
  19. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
  20. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #20
    The only thing that comes to mind is to do a clean install. Not great, but it'll do the trick.
     
  21. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #21
    worst idea EVER...besides that i can't unless i want to do about 200mbs of software updates.

    if your php works, couldn't you just send me the php folder from you drive?
     
  22. Rower_CPU Moderator emeritus

    Rower_CPU

    Joined:
    Oct 5, 2001
    Location:
    San Diego, CA
    #22
    I don't believe that there's any one PHP folder. It's several files between Apache config and everything else.

    Sorry I can't do anything more for you at this point.
     
  23. NavyIntel007 macrumors 65816

    NavyIntel007

    Joined:
    Nov 24, 2002
    Location:
    Tampa, FL
    #23
    Let me tell you how fun SQL is. I have an assignment of an airline database. 9 tables each with multiple attributes and 5 attributes per table. 45 entries.... ouch.
     
  24. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #24
    mnkeybsness:

    Assuming you installed PHP correctly, I can send you my httpd.conf file for you to compare and look at. Just PM me your e-mail address.

    BTW, here's a FAQ from Marc Liyanage with some answers to some common MySQL problems:

    http://www.entropy.ch/software/macosx/mysql/#faq
     
  25. mnkeybsness thread starter macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #25
    another problem i have encountered...and this is just today, AFTER we re-installed os x server and went through all the updates. this time i didn't update php or mysql.

    there were tabs here to be able to turn on stuff for the server last night...and now there are no tabs. and YES, we did configure the server for web, file, mail, qt streaming, etc...
     

Share This Page