Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    Unhappy Problems with MySQL
    Hi people,

    I installed MySQL, Apache, PHP, and XAMPP. I fired up XAMPP and clicked start everything, and, MySQL isnt running! (PHP is, version 5.2.4) It says:

    XAMPP: Starting MySQL...
    /Applications/xampp/xamppfiles/bin/mysql.server: line 159: kill: (790) - No such process

    What does this mean please? Please help!

    Thanks,

    Bilal.

  2. #2
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    In the Terminal issue the following command
    $ps -el | grep mysqld

    Does it show one or more mysqld processes running?

  3. #3
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    Hi Novicew,

    Thanks for your reply. Im a complete novice at programming but I went into Terminal and used sudo pico and pasted the command that you sent me but nothing happened. What did I do wrong?

    Bilal.

  4. #4
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    Noo, don't paste it on an editor.

    Just try to Copy and Paste it on the Terminal and press enter(Avoid copying $).

  5. #5
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    hey, thanks again for the reply, I opened Terminal, pasted the command directly and it did nothing, just a message underneath saying bilal-bhams-computer:
    The novice wannabe web programmer!

  6. #6
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    I assume that you have already followed the instructions here. If it doesn't help, try MAMP.

  7. #7
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    I did. I know about MAMP but I want to do it this way because Ive got nearly everything done, except mysql working
    The novice wannabe web programmer!

  8. #8
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    Ol'right. I think the bets bet would be to have a look at the mysql log reports. I am not sure how it is organized in XAMPP. Please, browse through the /Applications/XAMPP and report back with the error log.

  9. #9
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    ok, Im a complete novice, how do I get the error log? Im sorry for not knowing anything! Ive gone into the file for error but dont know what I should be looking for.
    The novice wannabe web programmer!

  10. #10
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    Go to the installation folder (users is most likely be /Applications/XAMPP). Here you should see all the apps and folders belong to XAMPP. Check whether there is a folder called logs. If so, go the the log folder and open the mysql error log.

    In the meantime you can also do the following.
    Goto the terminal and type cd Desktop(you are now in Desktop folder)
    Type ps aux > running.txt and hit enter (this should read all the running processes and write it to a file called running.txt)
    Now from Finder, go to the Desktop and open the running.txt
    Post the content here.

  11. #11
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    Here is the error log

    [Fri Nov 23 21:32:31 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Nov 23 21:32:31 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Fri Nov 23 21:32:31 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Fri Nov 23 21:32:32 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Nov 23 21:32:32 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Fri Nov 23 21:32:32 2007] [notice] Digest: generating secret for digest authentication ...
    [Fri Nov 23 21:32:32 2007] [notice] Digest: done
    [Fri Nov 23 21:32:32 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/4.4.7 configured -- resuming normal operations
    [Fri Nov 23 21:52:07 2007] [notice] caught SIGTERM, shutting down
    [Fri Nov 23 21:52:11 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Nov 23 21:52:11 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Fri Nov 23 21:52:11 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Fri Nov 23 21:52:12 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Nov 23 21:52:12 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Fri Nov 23 21:52:12 2007] [notice] Digest: generating secret for digest authentication ...
    [Fri Nov 23 21:52:12 2007] [notice] Digest: done
    [Fri Nov 23 21:52:12 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/5.2.4 configured -- resuming normal operations
    [Sat Nov 24 02:12:28 2007] [notice] caught SIGTERM, shutting down
    [Thu Nov 29 20:38:29 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:38:29 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:38:29 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Thu Nov 29 20:38:30 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:38:30 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:38:31 2007] [notice] Digest: generating secret for digest authentication ...
    [Thu Nov 29 20:38:31 2007] [notice] Digest: done
    [Thu Nov 29 20:38:31 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/5.2.4 configured -- resuming normal operations
    [Thu Nov 29 20:39:41 2007] [notice] caught SIGTERM, shutting down
    [Thu Nov 29 20:39:45 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:39:45 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:39:45 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Thu Nov 29 20:39:46 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:39:46 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:39:46 2007] [notice] Digest: generating secret for digest authentication ...
    [Thu Nov 29 20:39:46 2007] [notice] Digest: done
    [Thu Nov 29 20:39:46 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/4.4.7 configured -- resuming normal operations
    [Thu Nov 29 20:40:03 2007] [notice] caught SIGTERM, shutting down
    [Thu Nov 29 20:40:08 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:40:08 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:40:08 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Thu Nov 29 20:40:09 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Thu Nov 29 20:40:09 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Thu Nov 29 20:40:09 2007] [notice] Digest: generating secret for digest authentication ...
    [Thu Nov 29 20:40:09 2007] [notice] Digest: done
    [Thu Nov 29 20:40:09 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/5.2.4 configured -- resuming normal operations
    [Fri Nov 30 00:03:06 2007] [notice] caught SIGTERM, shutting down
    [Sat Dec 01 14:01:31 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Sat Dec 01 14:01:31 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Sat Dec 01 14:01:31 2007] [notice] suEXEC mechanism enabled (wrapper: /Applications/xampp/xamppfiles/bin/suexec)
    [Sat Dec 01 14:01:32 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Sat Dec 01 14:01:32 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
    [Sat Dec 01 14:01:32 2007] [notice] Digest: generating secret for digest authentication ...
    [Sat Dec 01 14:01:32 2007] [notice] Digest: done
    [Sat Dec 01 14:01:32 2007] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8e DAV/2 PHP/5.2.4 configured -- resuming normal operations
    The novice wannabe web programmer!

  12. #12
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    And here is the running text:

    USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
    bilalbha 89 8.1 12.9 722432 135520 ?? S 11:46AM 26:39.53 /Applicati
    bilalbha 223 3.6 1.7 385836 18012 ?? S 11:49AM 13:15.82 /Applicati
    bilalbha 651 2.5 6.1 464304 63664 ?? S 3:49PM 19:25.21 /Applicati
    windowse 54 2.2 5.3 399896 55908 ?? Ss 11:46AM 5:26.24 /System/Li
    bilalbha 646 1.0 3.3 419888 34652 ?? S 3:30PM 1:32.44 /Applicati
    bilalbha 81 0.8 1.1 358912 11060 ?? S 11:46AM 0:24.57 /System/Li
    bilalbha 241 0.6 0.7 345512 7376 ?? S 12:37PM 0:48.79 /System/Li
    bilalbha 745 0.5 0.6 350380 6568 ?? S 5:40PM 0:00.29 /Applicati
    bilalbha 354 0.2 0.6 350548 6484 ?? S 2:01PM 1:12.37 /Applicati
    root 37 0.0 0.2 32736 2300 ?? Ss 11:46AM 0:00.47 /usr/sbin/
    root 38 0.0 0.1 27804 1076 ?? Ss 11:46AM 0:00.38 /usr/sbin/
    root 39 0.0 0.1 28324 572 ?? Ss 11:46AM 0:00.02 /usr/sbin/
    root 40 0.0 0.2 29268 1932 ?? Ss 11:46AM 0:00.33 /usr/sbin/
    root 42 0.0 0.0 27864 444 ?? Ss 11:46AM 0:00.24 /usr/sbin/
    root 44 0.0 0.1 27676 788 ?? Ss 11:46AM 0:00.38 /usr/sbin/
    root 47 0.0 0.0 27252 224 ?? Ss 11:46AM 0:19.43 /usr/sbin/
    root 55 0.0 0.2 30744 2044 ?? Ss 11:46AM 0:00.45 /usr/sbin/
    root 58 0.0 1.2 49720 12428 ?? Ss 11:46AM 0:01.75 /System/Li
    root 59 0.0 0.2 37828 1608 ?? S 11:46AM 0:00.21 /usr/sbin/
    bilalbha 64 0.0 0.7 85696 7112 ?? Ss 11:46AM 0:02.56 /System/Li
    bilalbha 65 0.0 1.0 359104 10500 ?? Ss 11:46AM 0:06.56 /System/Li
    bilalbha 75 0.0 0.2 55340 1712 ?? Ss 11:46AM 0:00.32 /System/Li
    bilalbha 82 0.0 0.8 357256 7968 ?? S 11:46AM 0:05.21 /System/Li
    bilalbha 84 0.0 1.4 379452 14496 ?? S 11:46AM 0:09.22 /System/Li
    bilalbha 87 0.0 8.3 554272 86556 ?? S 11:46AM 3:06.97 /Applicati
    bilalbha 91 0.0 0.3 340692 2672 ?? S 11:46AM 0:31.83 /System/Li
    root 123 0.0 0.0 27252 204 ?? Ss 11:47AM 0:00.00 /usr/libex
    root 126 0.0 0.0 29312 200 ?? Ss 11:47AM 0:00.00 nfsiod -n
    root 140 0.0 0.0 27312 212 ?? Ss 11:47AM 0:00.00 rpc.lockd
    root 144 0.0 0.1 29720 1012 ?? Ss 11:47AM 0:00.03 /usr/sbin/
    root 163 0.0 0.1 27728 596 ?? S 11:47AM 0:00.02 /bin/sh ./
    root 191 0.0 0.1 29424 992 ?? Ss 11:47AM 0:00.03 /usr/sbin/
    mysql 202 0.0 1.3 63412 13412 ?? S 11:47AM 0:06.31 /usr/local
    root 208 0.0 0.4 45464 4052 ?? Ss 11:47AM 0:18.15 /System/Li
    root 211 0.0 0.2 37184 2580 ?? Ss 11:47AM 0:00.67 /usr/sbin/
    www 212 0.0 0.0 32636 480 ?? S 11:47AM 0:00.00 /usr/sbin/
    bilalbha 232 0.0 0.6 347108 6520 ?? S 12:37PM 0:00.62 /System/Li
    bilalbha 233 0.0 0.5 344636 5248 ?? S 12:37PM 0:00.32 /System/Li
    bilalbha 234 0.0 1.1 357248 11992 ?? S 12:37PM 0:04.46 /System/Li
    bilalbha 235 0.0 0.9 357260 9412 ?? S 12:37PM 0:01.51 /System/Li
    bilalbha 236 0.0 0.7 348088 6840 ?? S 12:37PM 0:00.48 /System/Li
    bilalbha 237 0.0 0.9 354952 9448 ?? S 12:37PM 0:01.16 /System/Li
    bilalbha 238 0.0 0.5 345912 4776 ?? S 12:37PM 0:00.27 /System/Li
    bilalbha 239 0.0 0.5 353188 5224 ?? S 12:37PM 0:00.32 /System/Li
    bilalbha 240 0.0 1.7 360544 18344 ?? S 12:37PM 0:06.35 /System/Li
    bilalbha 242 0.0 0.7 348596 7328 ?? S 12:37PM 0:00.80 /System/Li
    bilalbha 243 0.0 0.6 347436 6492 ?? S 12:37PM 0:04.09 /System/Li
    bilalbha 302 0.0 0.2 38676 1960 ?? S 1:10PM 0:00.28 /System/Li
    root 391 0.0 0.7 54532 7380 ?? Ss 2:01PM 0:00.61 /Applicati
    nobody 414 0.0 0.0 31828 500 ?? Ss 2:01PM 0:00.15 proftpd: (
    nobody 422 0.0 0.1 50816 912 ?? S 2:01PM 0:00.00 /Applicati
    nobody 440 0.0 0.1 53388 904 ?? S 2:01PM 0:00.00 /Applicati
    nobody 441 0.0 0.1 53388 904 ?? S 2:01PM 0:00.00 /Applicati
    nobody 442 0.0 0.1 53388 904 ?? S 2:01PM 0:00.00 /Applicati
    nobody 443 0.0 0.1 53388 904 ?? S 2:01PM 0:00.00 /Applicati
    nobody 444 0.0 0.1 53388 900 ?? S 2:01PM 0:00.00 /Applicati
    bilalbha 647 0.0 0.1 330320 1412 ?? S 3:30PM 0:00.18 /Applicati
    nobody 679 0.0 0.2 39356 2140 ?? SNs 4:41PM 0:00.17 /System/Li
    bilalbha 729 0.0 0.6 347744 6584 ?? S 4:57PM 0:00.34 /Applicati
    root 736 0.0 0.1 29204 1308 ?? Ss 5:11PM 0:00.08 /usr/sbin/
    bilalbha 739 0.0 0.3 40092 3332 ?? SNs 5:17PM 0:00.23 /System/Li
    bilalbha 744 0.0 0.6 348684 6416 ?? S 5:39PM 0:00.19 /Applicati
    root 747 0.0 0.1 27576 664 p1 Ss 5:40PM 0:00.01 login -pf
    bilalbha 748 0.0 0.1 27728 780 p1 S 5:40PM 0:00.01 -bash
    root 749 0.0 0.0 27328 448 p1 R+ 5:40PM 0:00.00 ps aux
    root 1 0.0 0.1 28356 532 ?? S<s 11:46AM 0:00.34 /sbin/laun
    root 21 0.0 0.0 27268 140 ?? Ss 11:46AM 0:00.00 /sbin/dyna
    root 25 0.0 0.1 28328 1060 ?? Ss 11:46AM 0:01.52 kextd
    root 30 0.0 0.0 27844 440 ?? Ss 11:46AM 0:00.02 /usr/sbin/
    root 31 0.0 0.1 28016 1000 ?? Ss 11:46AM 0:00.86 /usr/sbin/
    root 32 0.0 0.0 27580 500 ?? Ss 11:46AM 0:00.59 /usr/sbin/
    root 33 0.0 0.0 27288 396 ?? Ss 11:46AM 0:00.37 /usr/sbin/
    root 36 0.0 0.2 30508 2280 ?? Ss 11:46AM 0:05.37 /usr/sbin/
    The novice wannabe web programmer!

  13. #13
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    and when I click on reload on xampp, it says mysql isnt running.
    The novice wannabe web programmer!

  14. #14
    Problems with MySQL
    novicew's Avatar
    Member Since
    Jan 04, 2006
    Location
    Hamburg, Germany
    Posts
    1,385
    Specs:
    MacBook Pro | iMac(2.1 G5) | MacBook(2.16 C2D) | MacMini (1.67 CD) | iPhone 4 | iPad (3rd Gen)
    From what I have read, the problem is something to do with the security setting in httpd.conf. You have to find the following line and set it to no.
    AuthLDAPAuthoritative yes > AuthLDAPAuthoritative no
    Then restart the server.

  15. #15
    Problems with MySQL

    Member Since
    Nov 05, 2007
    Location
    English expat in Frankfurt am Main, Germany
    Posts
    24
    Specs:
    Macbook 2.16 GHz Intel Core 2 Duo
    ok, I went into Terminal with sudo pico, and searched for AuthLDAPAuthoritative and it said not found. how do I find this?
    The novice wannabe web programmer!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mySQL
    By burnedfaceless in forum Web Design and Hosting
    Replies: 1
    Last Post: 02-03-2014, 08:36 AM
  2. Want to install MySQL etc....
    By watfordkev in forum OS X - Operating System
    Replies: 4
    Last Post: 08-03-2008, 08:16 AM
  3. mySQL ODBC Problems
    By jonny in forum OS X - Operating System
    Replies: 0
    Last Post: 05-04-2007, 11:33 AM
  4. PHP mysql
    By richardmojo in forum Web Design and Hosting
    Replies: 2
    Last Post: 05-09-2005, 10:05 PM
  5. MySQL
    By ftjogoh in forum Web Design and Hosting
    Replies: 3
    Last Post: 11-21-2004, 11:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •