Okay, MySQL has not been working. I've posted this in one other thread, but since I'm having this apache weirdness as well I figured I'd group them into one question.
Here you can see MySQL just not working. Now that I've got more time I'll see if I can search Splunk for anything related. Any pointers on using Splunk or checking error logs would be greatly appreciated as well!
[root@69-64-69-24 ~]# httpd -v
Server version: Apache/2.2.2
Server built: Jul 26 2006 11:12:08
[root@69-64-69-24 ~]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@69-64-69-24 ~]# php -v
PHP 5.1.6 (cli) (built: Feb 23 2007 10:11:28)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
with the ionCube PHP Loader v3.1.16, Copyright (c) 2002-2006, by ionCube Ltd.
This illustrates my directory structure.
[root@69-64-69-24 www]# pwd
[root@69-64-69-24 www]# ls -lah
drwxrwxrwx 4 root root 4.0K Apr 5 13:50 .
drwxrwxrwx 5 root root 4.0K Nov 29 10:40 ..
lrwxrwxrwx 1 root root 26 Mar 23 06:36 ckesler -> /home/ckesler/public_html/
drwxrwxrwx 2 root root 4.0K Nov 29 10:40 css
-rwxrwxrwx 1 root root 24 Mar 15 06:40 googlehostedservice.html
drwxrwxrwx 3 root root 4.0K Nov 29 10:40 img
-rwxrwxrwx 1 root root 3.5K Mar 13 14:28 index.html
-rw-r--r-- 1 root root 35K Apr 5 13:50 index.php
lrwxrwxrwx 1 root root 27 Apr 5 11:38 mcupples -> /home/mcupples/public_html/
lrwxrwxrwx 1 root root 27 Apr 5 11:38 mmongeau -> /home/mmongeau/public_html/
Now, the only problematic thing is that /home/www is not a real directory but a symlink itself. The real directory is /var/www/vhosts/default/htdocs. I don't think there's any issue with that, I just set it up that way so I didn't have to type all that out every time I go there.
I would post my httpd.conf file here but I'm afraid I'll get yelled at. Instead, I just hosted it at http://mcupples.com
. It's the index page.
* My issue with MySQL is the error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
* My issue with Apache is that my settings are incorrect for supporting virtual hosts.
Edit: Also, how can I change the name of my server at the bash prompt? Instead of [root@69-64-69-24 www], I'd like it to say [email@example.com www]. No worries about that, though!