Isitaki se-LAMP sihlanganisa isistimu yokusebenza ye-Linux, isofthiwe yeseva yewebhu ye-Apache, uhlelo lokuphathwa kwedathabhe ye-MySQL kanye nolimi lokuhlela lwe-PHP. I-LAMP iyinhlanganisela yesofthiwe esetshenziselwa ukunikeza izinhlelo zokusebenza zewebhu ze-PHP ezinamandla namawebhusayithi. Qaphela ukuthi i-P ingaphinda imele i-Perl noma i-Python esikhundleni se-PHP.
Esitakini se-LAMP, i-Linux iyisisekelo sesitaki (iphethe zonke ezinye izingxenye); I-Apache iletha okuqukethwe kwewebhu (njengamakhasi ewebhu, njll.) kumsebenzisi wokugcina nge-inthanethi uma ecelwa ngesiphequluli sew
Funda kabanzi →I-LEMP noma i-Linux, i-Engine-x, i-MySQL kanye ne-PHP isitaki inqwaba yesofthiwe ehlanganiswe nesofthiwe yomthombo ovulekile efakwe ohlelweni lokusebenza lwe-Linux ukuze isebenzise izinhlelo zokusebenza zewebhu ezisekelwe ku-PHP ezinikwa amandla iseva ye-Nginx HTTP kanye nesistimu yokuphatha imininingwane ye-MySQL/MariaDB.
Lesi sifundo sizokuqondisa ukuthi usifaka kanjani isitaki se-LEMP nge-Nginx, i-MariaDB, i-PHP, i-PHP-FPM ne-PhpMyAdmin kuma-OpenSuse server/desktop editions.
I-Nginx iyi-HTTP esheshayo nethembekile kanye neseva elibamba engaph
Funda kabanzi →Isitaki se-LAMP sakhiwe amaphakheji afana ne-Apache, MySQL/MariaDB kanye ne-PHP efakwe endaweni yesistimu ye-Linux yokusingatha amawebhusayithi nezinhlelo zokusebenza.
I-PhpMyAdmin iwumthombo wamahhala, ovulekile, owaziwayo, onezici ezigcwele, futhi ezinembile ezisekelwe kuwebhu zokuphatha isizindalwazi se-MySQL ne-MariaDB. Isekela imisebenzi ehlukahlukene yedathabheyisi, futhi inezici eziningi ezikuvumela ukuthi uphathe kalula imininingwane yakho yolwazi kusuka kusixhumi esibonakalayo sewebhu; njengokungenisa nokuthekelisa idatha ngamafomethi ahlukahlukene, ukukhiqiza imibuzo eyinkim
Funda kabanzi →Imvamisa, abasebenzisi abathuthukile bakhetha ukusebenzisa nokuphatha isistimu yokuphatha isizindalwazi se-MySQL ngokusuka komyalo wayo, ngakolunye uhlangothi, le ndlela ibonakale iyinselele enkulu kubasebenzisi abasha beLinux.
Ngakho-ke, ukuze wenze izinto zibe lula kwabaqalayo, i-PhpMyAdmin yadalwa.
I-PhpMyAdmin iwumthombo wamahhala novulekile, isofthiwe yokuphatha esekelwe kuwebhu ye-MySQL/MariaDB ebhalwe nge-PHP. Inikeza abasebenzisi indlela elula yokuxhumana ne-MySQL ngesiphequluli sewebhu.
Kulesi sihloko sizokwabelana ngamathiphu ukuze uvikele ukufakwa kwakho kwe-php
Funda kabanzi →Uma uhlela ukusebenzisa i-phpmyadmin njalo ukuze uphathe imininingwane yakho yolwazi kunethiwekhi (noma okubi nakakhulu, nge-inthanethi!), awufuni ukusebenzisa i-akhawunti yempande. Lokhu akusebenzi ku-phpmyadmin kuphela kodwa nanoma yisiphi esinye isixhumi esibonakalayo esisekelwe kuwebhu.
Ku-/etc/phpmyadmin/config.inc.php, bheka umugqa olandelayo bese uqinisekisa ukuthi AllowRoot isiyalelo simiswe ukuze sithi FALSE:
$cfg['Servers'][$i]['AllowRoot'] = FALSE; Funda kabanzi →I-MySQL iwuhlelo olusetshenziswa kakhulu emhlabeni lokuphathwa kwesizindalwazi somthombo ovulekile ku-ecosystem ye-Linux futhi ngesikhathi esifanayo abasanda kuhlanganyela be-Linux bakuthola kunzima ukuphatha kusukela ekwazisweni kwe-MySQL.
I-PhpMyAdmin yadalwa, iwuhlelo lokusebenza lokuphatha isizindalwazi se-MySQL esisekelwe kuwebhu, esihlinzeka ngendlela elula yabasanda kuhlanganyela be-Linux ukuthi baxhumane ne-MySQL ngesixhumi esibonakalayo sewebhu. Kulesi sihloko, sizokwabelana ngendlela yokuvikela isikhombimsebenzisi se-phpMyAdmin ngokuvikelwa kwephasiwedi ezinhlelweni ze-Linux
Funda kabanzi →Ukwethula leli thiphu, ake sihogele ithrafikhi ye-HTTP phakathi komshini weklayenti kanye neseva ye-Debian 8 lapho senze khona iphutha elimsulwa lokungena ngemvume sisebenzisa imininingwane yezimpande zesizindalwazi esihlokweni sethu sokugcina kokuthi: Shintsha futhi Uvikele Okuzenzakalelayo Okuzenzakalelayo kwe-PhpMyAdmin Login URL.
Njengoba sishilo kuthiphu edlule, ungazami ukwenza lokhu okwamanje uma ungafuni ukuveza imininingwane yakho. Ukuze siqale ukuhogela ithrafikhi, sibhale umyalo olandelayo bese sicindezela u-Enter:
# tcpdump port http -l -A | egrep -i 'pass=|pwd=|lo Funda kabanzi →Ngokuzenzakalelayo, ikhasi lokungena le-phpmyadmin litholakala kokuthi http://
Lokhu kwaziwa njengokuvikeleka ngokufiphazwa futhi nakuba abanye abantu bengase baphikise ngokuthi akusona isilinganiso esiphephile, bekwaziwa yibo bobabili abahlaseli abathena amandla nokuvikela ukugqekezwa.
Qaphela: Qiniseka ukuthi une-LAMP esebenzayo noma isethaphu ye-LEMP ene-PhpMyAdmin efakwe ohlelw
Funda kabanzi →Ukuphathwa kwe-MySQL ngomugqa womyalo ku-Linux kuwumsebenzi onzima kakhulu kunoma yimuphi umlawuli wesistimu ye-newbie noma umqondisi wesizindalwazi, ngoba iqukethe imiyalo eminingi esingenakuyikhumbula ekuphileni kwethu kwansuku zonke.
Ukwenza ukuphatha kwe-MySQL kube lula kakhulu sethula ithuluzi lokuphatha elisekelwe kuwebhu le-MySQL elibizwa nge-PhpMyAdmin, ngosizo lwaleli thuluzi ungakwazi ukulawula nokuphatha ukuphathwa kwesizindalwazi sakho usebenzisa isiphequluli sewebhu kalula.
I-PhpMyAdmin iyisixhumi esibonakalayo esisekelwe kuwebhu sokuphatha imininingwane yolwazi ye-
Funda kabanzi →Isitaki se-LEMP siyinhlanganisela ye-Nginx, MySQL/MariaDB kanye ne-PHP efakwe endaweni ye-Linux.
Isifinyezo sivela ezinhlamvini zokuqala zento ngayinye: i-Linux, i-Nginx (ebizwa ngokuthi Engine x), i-MySQL/MariaDB kanye ne-PHP.
Lesi sihloko sizofaka imiyalelo yesinyathelo ngesinyathelo indlela yokufaka isofthiwe ngayinye eqenjini kuseva esekelwe ku-Ubuntu 15.04 ngethuluzi le-PhpMyAdmin lokuphatha isizindalwazi kusuka kusiphequluli sewebhu.
Ngaphambi kokusetha i-LEMP, kunezidingo ezimbalwa okufanele zihlangatshezwe: