Apache and mysql configuration problems

English Programming/Scripting
#1

Recently I got my OpenSuse 11.1 and installed lamp using

zypper install -t pattern lamp_server

The installation was susccessful
However whenever I start my apache2ctl I get the follwing error message
**
httpd2: Syntax error on line 188 of /etc/apache2/httpd.conf: Could not open configuration file /etc/apache2/sysconfig.d/include.conf: No such file or directory

Also I get this error with mysql stating
**
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)****

I referred to previous forum entries but it did not help a lot

PS This is a freshly installed system as I got it yesterday only

#2

Hi, I can’t say anything specific about the error messages you’re getting. But I’ve done one project in Suse with LAMP, so this suggestion can be helpful. You don’t need to install LAMP-Server separately. Apache, Mysql, php support comes in default with Suse. Just check in YaST whether they are installed. Then just configure the httpd.conf file and php modules(You’ll get instruction in any standard book or on internet & it’s simple & sort). Then start the apache server, mysqld and simply test your php pages.

#3

run ‘rcapache2 start’ and see if you get same issue. The include.conf file is made when you start apache

secondly, bind mysql to listen on sockets, not TCP/IP ports. This is done by enabling the skip-networking option in /etc/my.cnf

#4

Thank you my apache is running after using “rcapache2 start”:slight_smile:

However I cannot get mysql working the same problem occurs when I try to run it… after enabling the skip-networking option

#5

how did you start mysql? with rcmysql start ?

Here’s my config and it works perfectly

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

Here follows entries for some specific programs

The MySQL server

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

Don’t listen on a TCP/IP port at all. This can be a security enhancement,

if all processes that need to connect to mysqld run on the same host.

All interaction with mysqld must be made via Unix sockets or named pipes.

Note that using this option without enabling named pipes on Windows

(via the “enable-named-pipe” option) will render mysqld useless!

skip-networking

#6

Sorry, but my crystal ball is currently broken.

What happens when you do (as root):

rcmysql status
rcmysql start

And what is in the error log to be found under /var/lib/mysql/ (the only file which ends in *.err) ?

MySQL is rock-solid. When you install and enable it with yast (as you should) and have a fresh install of 11.1 it should start without any problems.