{"id":246,"date":"2011-06-22T09:25:00","date_gmt":"2011-06-22T07:25:00","guid":{"rendered":"https:\/\/www.interlink.ro\/blog\/?p=246"},"modified":"2011-06-22T09:41:25","modified_gmt":"2011-06-22T07:41:25","slug":"cum-instalam-apache2-cu-php5-si-mysql-support-pe-centos-5-6-lamp","status":"publish","type":"post","link":"https:\/\/www.interlink.ro\/blog\/cum-instalam-apache2-cu-php5-si-mysql-support-pe-centos-5-6-lamp","title":{"rendered":"Cum instalam Apache2 cu PHP5 si MySQL Support pe CentOS 5.6 (LAMP)"},"content":{"rendered":"Timp de citit: <\/span> 4<\/span> minutes<\/span><\/span>

Ca sa intelegeti despre ce este vorba o sa va spun mai intai ca LAMP este o prescurtare pentru Linux, Apache, MySQL, PHP, iar in acest tutorial o sa va explic cum sa instalati un webserver Apache2 cu suport MySQL si PHP5 pe un server <\/strong> ce are instalat sistemul de operare CentOS 5.6. O sa folosesc ca hostname server.exemplu.ro cu adresa 192.168.0.100, aceste exemple vor fii schimbate de dumneavoastra cu cele de care aveti nevoie.<\/p>\n

A. Instalarea MySQL<\/strong>:
\nCa sa instalam Mysql folosim comanda:
\n<?php phpinfo();\u00a0 ?><\/p>\n

yum install mysql mysql-server<\/code><\/p><\/p>\n

Apoi creem linkurile de startup ale sistemului pentru serverul MySQL ( ca MySQL sa porneasca automat de cate ori serverul buteaza) si pornim serverul MySQL.<\/p>\n

chkconfig --levels 235 mysqld on<\/code><\/p>
\n

\/etc\/init.d\/mysqld start<\/code><\/p><\/p>\n

Setam parola pentru root user MySQL<\/p>\n

mysql_secure_installation<\/code><\/p><\/p>\n

[root@server1 ~]# mysql_secure_installation<\/p>\n

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
\nSERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!<\/p>\n

In order to log into MySQL to secure it, we’ll need the current
\npassword for the root user. If you’ve just installed MySQL, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/p>\n

Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/p>\n

Setting the root password ensures that nobody can log into the MySQL
\nroot user without the proper authorisation.<\/p>\n

Set root password? [Y\/n] <– ENTER
\nNew password: <– yourrootsqlpassword
\nRe-enter new password: <– yourrootsqlpassword
\nPassword updated successfully!
\nReloading privilege tables..
\n… Success!<\/p>\n

By default, a MySQL installation has an anonymous user, allowing anyone
\nto log into MySQL without having to have a user account created for
\nthem. This is intended only for testing, and to make the installation
\ngo a bit smoother. You should remove them before moving into a
\nproduction environment.<\/p>\n

Remove anonymous users? [Y\/n] <– ENTER
\n… Success!<\/p>\n

Normally, root should only be allowed to connect from ‘localhost’. This
\nensures that someone cannot guess at the root password from the network.<\/p>\n

Disallow root login remotely? [Y\/n] <– ENTER
\n… Success!<\/p>\n

By default, MySQL comes with a database named ‘test’ that anyone can
\naccess. This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/p>\n

Remove test database and access to it? [Y\/n] <– ENTER
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/p>\n

Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/p>\n

Reload privilege tables now? [Y\/n] <– ENTER
\n… Success!<\/p>\n

Cleaning up…<\/p>\n

All done! If you’ve completed all of the above steps, your MySQL
\ninstallation should now be secure.<\/p>\n

Thanks for using MySQL!<\/p>\n

[root@server1 ~]#<\/p>\n

B. Instalarea Apache2:<\/strong><\/p>\n

Apache2 se gaseste in lista pachetelor CentOS si poate fii instalat folosind urmatoarele comenzi:<\/p>\n

yum install httpd<\/code><\/p><\/p>\n

Acum configurati serverul Apache sa porneasca odata cu sistemul:<\/p>\n

chkconfig --levels 235 httpd on<\/code><\/p><\/p>\n

…si porniti Apache<\/p>\n

\/etc\/init.d\/httpd start<\/code><\/p><\/p>\n

Acum accesati in browser adresa http:\/\/192.168.0.100 si veti gasi pagina de pornire Apache<\/p>\n

\"\"<\/a><\/p>\n

Locatia root a serverului Apache este \/var\/www\/html in CentOS, iar fisierul pentru configurare este \/etc\/httpd\/conf\/httpd.conf. Configuratiile aditionale sunt stocate in directorul\/etc\/httpd\/conf.d\/.<\/p>\n

C. Instalarea PHP5:<\/strong><\/p>\n

Putem instala modulele PHP5 sau Apache PHP5 dupa cum urmeaza:<\/p>\n

yum install php<\/code><\/p><\/p>\n

Dupa aceasta serverul Apache-ul trebuie restartat<\/p>\n

\/etc\/init.d\/httpd restart<\/code><\/p><\/p>\n

D. Testarea PHP5 si detalii despre instalare<\/strong><\/p>\n

Documentul root al web site-ului este \/var\/www\/html. Acum o sa cream un mic fisier PHP in acest document (info.php) si o sa il accesam dintr-un browser. Acest fisier ne da multe detalii despre php-ul instalat, detalii cum ar fii versiunea de PHP instalata.<\/p>\n

vi \/var\/www\/html\/info.php<\/code><\/p><\/p>\n

Continutul fisierului:<\/p>\n

&lt;?php phpinfo(); ?&gt;<\/code><\/p><\/p>\n

Acum putem accesa aceasta pagina intr-un browser (exemplu: http:\/\/192.168.0.100\/info.php)<\/p>\n

\"\"<\/a>Dupa cum puteti vedea PHP5 functioneaza prin Apache2 Handler, acest lucru ne este aratat de rubrica Server API. Facand scroll pe aceasta pagina puteti observa modulele activate in PHP5 iar MySQL nu se numara printre acestea ceea ce inseamna ca nu avem inca suport pentru serverul MySQL in PHP5.<\/p>\n

E. Obtinerea suportului MySQL in PHP5<\/strong>:<\/p>\n

Pentru a obtine suport MySQL in PHP5 putem instala pachetul php-mysql. Puteti instala si alte module PHP5 deoarece va vor folosii la diverse aplicatii. Cautati dupa module PHP5 asa:<\/p>\n

yum search php<\/code><\/p><\/p>\n

Alegeti modulele de care aveti nevoie dupa care instalati-le asa:<\/p>\n

yum install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc<\/code><\/p><\/p>\n

Acum restartati Apache2<\/p>\n

\/etc\/init.d\/httpd restart<\/code><\/p><\/p>\n

Reincarcati pagina http:\/\/192.168.0.100\/info.php din browser si faceti scroll pe pagina, acum veti gasi toate modulele instalate inclusiv MySQL.\"\"<\/a><\/p>\n

F. phpMyAdmin<\/strong><\/p>\n

MyphpAdmin este o interfata web cu ajutorul careia va puteti administra baza de date MySQL.<\/p>\n

In prima faza activati RPMforge repository pe sistemul CentOS deoarece phpMyAdmin nu este disponibil in lista oficiala CentOS 5.6.<\/p>\n

Pentru sistemele x84 64:<\/p>\n

wget http:\/\/packages.sw.be\/rpmforge-release\/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm<\/code><\/p>
\n

rpm -Uhv rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm<\/code><\/p><\/p>\n

Pentru sistemele i386:<\/p>\n

wget http:\/\/packages.sw.be\/rpmforge-release\/rpmforge-release-0.5.2-2.el5.rf.i386.rpm<\/code><\/p>
\n

rpm -Uhv rpmforge-release-0.5.2-2.el5.rf.i386.rpm<\/code><\/p><\/p>\n

phpMyAdmin poate fii instalat dupa cum urmeaza:<\/p>\n

yum install phpmyadmin<\/code><\/p><\/p>\n

Acum configuram phpMyAdmin.\u00a0 Schimbat configuratia serverului Apache astfel incat phpMyAdmin sa suporte conexiuni nu doar din reteaua locala (putem face asta prin comentarea liniei <Directory “\/usr\/share\/phpmyadmin”>) <\/em><\/p>\n

vi \/etc\/httpd\/conf.d\/phpmyadmin.conf<\/code><\/p><\/p>\n

#
\n# Web application to manage MySQL
\n#<\/code><\/p><\/p>\n

#
\n# Order Deny,Allow
\n# Deny from all
\n# Allow from 127.0.0.1
\n#<\/code><\/p><\/p>\n

<\/code><\/p><\/p>\n

 <\/p>\n

Alias \/phpmyadmin \/usr\/share\/phpmyadmin
\nAlias \/phpMyAdmin \/usr\/share\/phpmyadmin
\nAlias \/mysqladmin \/usr\/share\/phpmyadmin<\/code><\/p><\/p>\n

Acum trebuie sa schimbam modul in care se face autentificarea in phpMyAdmin din cookie in http:<\/p>\n

vi \/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/p>
\n

[...]
\n\/* Authentication type *\/
\n$cfg['Servers'][$i]['auth_type'] = 'http';
\n[...]<\/code><\/p><\/p>\n

Restartati Apache:<\/p>\n

\/etc\/init.d\/httpd restart<\/code><\/p><\/p>\n

Acum puteti accesa phpMyAdmin la adresa http:\/\/192.168.0.100\/phpmyadmin\/:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Felicitari! Tocmai ai terminat de configurat serverul LAMP.<\/p>\n

PS: in cazul in care doriti o masina special construita pentru a functiona ca server va rugam accesati categoria servere second hand<\/a>. Daca doriti doar testarea acestor programe, puteti folosi un calculator<\/a> obisnuit!<\/p>\n\t

\r\n\t