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.

In the Terminal issue the following command
$ps -el | grep mysqld

Does it show one or more mysqld processes running?

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.

Noo, don't paste it on an editor.

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

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:

I assume that you have already followed the instructions here. If it doesn't help, try MAMP.

I did. I know about MAMP but I want to do it this way because Ive got nearly everything done, except mysql working

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.

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.

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.

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

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/

and when I click on reload on xampp, it says mysql isnt running.

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.

ok, I went into Terminal with sudo pico, and searched for AuthLDAPAuthoritative and it said not found. how do I find this?

It is in your httpd.conf file, located somewhere in xampp folder.

ok, I went into the httpd file, opened it with textedit and searched for AuthLDAPAuthoritative but it wasnt there. There are loads of lines with Load Module Auth etc but not the one you were asking for. I dont know what to do now...

It is really difficult to figure out without looking all the logs. config files and so on. Have you ever considered reinstalling XAMPP? If so, you should remove the corresponding .plist file as well.

Line 159 error

The error with line 159 on it is usually because you have a previous MySQL instance running. You need to kill that before Xampp will work properly.

This does the trick in a brute force kinda way. Open up Terminal and type:

Then try running Xampp again.