changes on mysql and php

When I installed php and mysql.
I wanted to run drupal through it..So i came through some hurdles...
The notes for that ..
1.mysql -u root -p
-->gave the password (*****4*)
Now created a database named drupal and gave complete access to the user

2.mysql>create database drupal;

3.mysql> GRANT ALL PRIVILEGES ON *.* TO 'sree'@'localhost' IDENTIFIED BY '*****4**' WITH GRANT OPTION;
So Now I should be able to Install drupal on my desktop...
but came with one more problem related to the PHP

"Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 117327 bytes) in /drupal/drupal-6.9/includes/cache.inc on line 105"

So to fix this we need to change the php files with drupal

i.e
1.vim drupal/sites/default/settings.php
added the ini_set('memory_limit', '16M');
and am not sure abt adding below line but i added it.
php_value memory_limit 16M in your .htaccess file in the Drupal root folder

-sree

Apache webserver

TO Run a apache webserver from Home.

1.apt-get install apache2
2.Change the Document root directory on /etc/apache2/sites-available/default
3. a2ensite default
4. apache2ctl graceful

Now its ready to restart the apache2, which can be tested on browser with localhost.

Webserver options

I wanted to Run a Webserver from my home.
So first thing for that to happen in this open source platform is

1.Create a dyndns account with somethin like ****.homelinux.com
2.Edit your Router settings for dyndns account
3.Edit the router to have your desktop a staticIp and complete pass through of the http traffic.

which will let you have the access to the public domain from your desktop,Now The main requirements are having Lamp server on your desktop ..If its Ubuntu...

install LAMP server,Mysql

To install Lamp server on Kubuntu
We can use tasksel util.
So jus type
sudo tasksel install lamp-server
or Individually install packages with
sudo apt-get install apache2 php5-mysql libapache2-mod-php5 mysql-server

But doing so gave me some errors in mysql also.
for example errors like
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)


To solve these
sudo su
aptitude purge mysql-common mysql-server
aptitude install mysql-server

Permission Error while Running Apache webserver

I am Trying to Run a apache webserver on My linux Box.
when I try to do that.
I came up with an issue like

Forbidden

You don't have permission to access / on this server.

---

Apache/2.2.9 (Ubuntu) Server at localhost Port 80

But after going through some internet research, I came to know that the document Root doesnt have permissions according to the apache configuration.
So I changed the file "/etc/apache2/sites-available/default"
As like

Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all


Which gave me the access to the public as well as able to run the server
after changing this you just need to do

/etc/init.d/apache2 restart

Expedition towards Ubuntu

I bought a Desktop Dell to use it for My personal Fun,Development and blah..blah...

When i bought this Dell Studio Desktop,It has Vista.. But As I am rigorous linux user,I wanted to install Linux in to it.I tried Suse, Fedora Since I am using Ubuntu at Office,I wanted to have different Linux at Home..

So I tried different OS's and finally decided to use Ubuntu8.10..The reasons might be..

1.I am used to ubuntu.

2.Better Hardware access than others.

3.Easy to resolve the issues with Open source Community.

4.Easy to install drivers,plugins since all of them are reachable 

5.Wireless drivers...Its damn easy to setup the b43 firmware 

My desktop details are

1.Dell Studio Mini Tower Core 2 Duo Processor E7300

2. 2.66 GHZ,1066Mhz FSB and 4Gb Ram

3.Broadcomm Bcm ethernet/wireless card