LAMP - Open Source Experiments

LAMP (Linux, Apache, MySQL, Perl) configuration on OpenSUSE Linux 10.0.

Here is some useful information :

The configuration files are in
/etc/apache2/

I had to create an empty file named include.conf in /etc/apache2/sysconfig.d
Else 'httpd2 -k start' (the way you need to start the daemon) was giving an error.

HTML files and other stuff like images go by default into :
/srv/www/htdocs
CGI files in /srv/www/cgi-bin


Also did some experimentation with 'mysql' based on info that I had got from the LFY magazine.
First installed the mysql server. Then the following commands to craete and update databases.

linux:~ # mysqladmin -u root -p XXXXX

linux:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.8-standard

mysql> create database testdb;
Query OK, 1 row affected (0.17 sec)

mysql> show databases
->
-> ;
+----------+
Database
+----------+
mysql
test
testdb
tmp
+----------+
4 rows in set (0.07 sec)

mysql> use testdb;
Database changed

mysql> create table registration ( memid int not null primary key, name varchar(20),
emailID varchar(30), Location varchar(25));
Query OK, 0 rows affected (0.06 sec)

mysql> describe registration
-> ;
+----------+-------------+------+-----+---------+-------+
Field Type Null Key Default Extra
+----------+-------------+------+-----+---------+-------+
memid int(11) PRI 0
name varchar(20) YES NULL
emailID varchar(30) YES NULL
Location varchar(25) YES NULL
+----------+-------------+------+-----+---------+-------+

mysql> insert into registration values(1,'Surendranath Boral','suboral@gmail.com',
'Jayanagar Bangalore');
Query OK, 1 row affected (0.04 sec)

mysql> select * from registration
-> ;
+-------+--------------------+-------------------+---------------------+
memid name emailID Location
+-------+--------------------+-------------------+---------------------+
1 Surendranath Boral suboral@gmail.com Jayanagar Bangalore
+-------+--------------------+-------------------+---------------------+
1 row in set (0.07 sec)

mysql> quit
Bye

Another thing:
Kaffeine gives this problem and doesnt play any mp3 or video by default
WIN32 Codecs...
No WIN32 codecs found in /usr/lib/win32. You're not able to play Windows Media 9 files,
newer Real Media files and some less common formats.