Need help with setting up LAMP enviroment.

[obsoleto]

Knoppix 3.4 installed on my hard-drive.

Hi,

I'm very new to Linux and want to setup a learning enviroment for PHP/MySQL/Apache.

Scrounging around these forums for bits of info, I've managed to start Apache and check my version of Perl.

But I am having no luck with PHP. I've tried "apt-get install PHP" but get errors. Then tried "apt-get update" first then "apt-get install PHP" . Same errors. (Couldn't stat source package list http://ftp.us.debian.....) Maybe apt-get isn't the best approach, but I don't know any other.

Also any hints at where/how to install MySQL? I'm pretty sure I can config it with phpmyadmin. Just finding and installing this stuff is a problem for me.

Any help is greatly appreciated :)

Obs

[eco2geek]

If you've got Knoppix 3.4 installed, then you've already got some of PHP by default:


root@knoppixbox:/home/andrew# dpkg -l "php*"
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
pn php3 <none> (no description available)
pn php3-imap <none> (no description available)
pn php3-ldap <none> (no description available)
pn php3-mysql <none> (no description available)
pn php3-pgsql <none> (no description available)
ii php4 4.3.4-4 A server-side, HTML-embedded scripting langu
un php4-cgi <none> (no description available)
un php4-cgi-curl <none> (no description available)
un php4-cgi-domxm <none> (no description available)
un php4-cgi-gd <none> (no description available)
un php4-cgi-imap <none> (no description available)
un php4-cgi-ldap <none> (no description available)
un php4-cgi-mhash <none> (no description available)
un php4-cgi-mysql <none> (no description available)
un php4-cgi-pgsql <none> (no description available)
un php4-cgi-snmp <none> (no description available)
un php4-cgi-xml <none> (no description available)
un php4-dev <none> (no description available)
pn php4-imap <none> (no description available)
pn php4-ldap <none> (no description available)
ii php4-mysql 4.3.4-4 MySQL module for php4
un php4-pear <none> (no description available)
pn php4-pgsql <none> (no description available)
un php4-sablot <none> (no description available)
un php4-xml <none> (no description available)
un phpapi-2002091 <none> (no description available)
un phpdoc <none> (no description available)

Likewise, you've got some of MySQL:


root@knoppixbox:/home/andrew# dpkg -l "mysql*"
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
un mysql <none> (no description available)
un mysql-base <none> (no description available)
ii mysql-client 4.0.18-8 mysql database client binaries
ii mysql-common 4.0.18-8 mysql database common files (e.g. /etc/mysql
un mysql-dev <none> (no description available)
un mysql-devel <none> (no description available)
un mysql-doc <none> (no description available)
un mysql-gpl-clie <none> (no description available)
ii mysql-server 4.0.18-8 mysql database server binaries

I don't know anything about using them, but hopefully that gives you an idea of the packages that are available.

[obsoleto]

Thanks,

Apache and PHP are working. I've got MySQL installed and running too but my start up is very wierd.

mysql -h localhost -u root -p results in an error of: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

but this apparently starts the service....

root@laptop:~# mysqld version
mysqld: ready for connections.
Version: '4.0.18-log' socket: '/var/run/mysqld/mysqld.sock' port: 0

Then "mysql -h localhost -u root -p" works fine.

"service mysql start" does nothing either. (service is an unknown command).

I should probably be posting these question in a MySQL forum. But someone else might find usefull.

Obs

[obsoleto]

Hi again,

I'll post this for the next noobie ;-)

This assumes you have installed Knoppix to your hard drive.

1. Start Apache (already installed)
a) From shell run sudo /etc/init.d/apache start (as root)
should see...
Starting web server: apache[Sat May 22 10:23:22 2004] [warn] module ssl_module is already loaded skipping
b) Test by pointing browser to http://127.0.0.1/, should see a default web page for apache/debian.

2. Test PHP (already installed)
a) Create a text file (i used kwrite) with just <?php phpinfo(); ?> in it.
b) Save it to /var/www/
c) Test by pointing browser to http://127.0.0.1/test.php, should see PHP info page.

3. Install MySQL (not installed)
a) From shell run the following commands to download and install MySQL
apt-get update
apt-get install mysql-common mysql-client mysql-server
apt-get install php4-mysql
b) Run 'mysql_install_db'from shell to create system tables, etc.
c) Run 'safe_mysqld'
d) Start server "/etc/init.d/mysql start" (logged in a root)
e) mysql -h localhost -u root -p to connect.
f) see mysql doc for actually choosing/creating a db.

Obs