Kungani i-Adminer.php ingenalutho? Kodwa-ke, ukuyiqamba kabusha kusebenza kahle? Ukuhlaziywa kwembangela kanye nesisombululo esinezinyathelo ezintathu.

Izolo ntambama, bengilungiselela ithuluzi lokuphatha isizindalwazi se-Adminer kuseva. I-Adminer ilula futhi kulula ukuyisebenzisa; ifayela elilodwa le-PHP lenza umsebenzi, ngokungafani...phpMyAdminLokho kuzofaka izinto eziningi ezixhomeke kukho. Ngilande inguqulo yakamuva kuwebhusayithi esemthethweni, ngayilayisha kuseva, ngayibeka izimvume, ngayivula isiphequluli sami, futhi ngalungiselela ukuzibonela mathupha.

Ngemuva kwalokho, konke kwaphela.

Ngivuselele ikhasi kathathu, iminwe yami ibuhlungu ngenxa yokucindezela i-F5 izikhathi eziningi. Akukho lutho. Ngivule amathuluzi onjiniyela wesiphequluli; kubonise iphutha elingu-200 OK, kodwa umzimba wempendulo wawungenalutho. Ngamangala ngokuphelele. Kwenzekani?

Ngicabange ngakho okwesikhashana. Ingabe kungaba inkinga yemvume yefayela? Ngihlolile, futhi kwakungu-755. Ingabe kungaba ukungahambelani kwenguqulo ye-PHP? Ngihlolile, futhi kuyi-PHP 8.2, okuyinto enhle. Ingabe ifayela ngokwalo lingaba nephutha? Ngilande ikhophi entsha, ngayibhala ngaphezulu, futhi isengenalutho.

Ngacabanga ukuthi, ngesizathu esingaqondakali, kungani ngingazami ukushintsha igama lami?

Ngiqambe kabusha i-adminer.php yaba yi-adminer1.php futhi ngavuselela ikhasi.

Ukufinyelela kuphumelele.

Ngangididekile ngempela. Ifayela elifanayo, ikhodi efanayo, iseva efanayo, futhi iyatholakala ngokushintsha igama? Lolu hlobo luni lomqondo oluyimfihlakalo?

Inkinga yefayela elingenalutho le-adminer.php

Kamuva ngaqaphela ukuthi lokhu kwakungeyona inkolelo-ze ethile; kwakuyi-PHP caching eyayibangela inkinga.

I-OPcache, efushanisiwe ne-Opcode Cache, isandiso sokwenza ngcono ukusebenza kwe-PHP. Isimiso sayo silula: i-PHP ulimi oluhunyushwayo, futhi isicelo ngasinye sidinga ukuthi ikhodi ye-PHP ihlanganiswe ibe yi-opcode ngaphambi kokusetshenziswa. I-OPcache igcina umphumela ohlanganisiwe kwimemori, ivumela izicelo ezilandelayo ukuthi zisebenzise inguqulo egciniwe ngqo ngaphandle kokuhlanganiswa kabusha, okuholela ekuthuthukisweni okukhulu kokusebenza.

Kodwa yilapho inkinga ikhona khona.

Ngaphambilini, i-adminer.php ibonise ukuthi "Ifayela alitholakalanga" (ngangilayishe ifayela elingalungile), kanti i-OPcache yayigcine umphumela ohlanganisiwe walokho okuqukethwe okungalungile. Kamuva, ngafaka ikhodi efanele esikhundleni se-adminer.php, kodwa i-OPcache yayingayinaki futhi yaqhubeka nokufunda i-cache endala kusuka kwimemori, okwaholela ekhasini elingenalutho noma umlayezo wephutha omdala.

Uma uyiqamba kabusha ibe yi-admininer1.php, iba yindlela entsha yefayela ye-OPcache, futhi izoyilayisha kabusha futhi iyixazulule ngendlela efanele.

Kufana nokuthi usuvele uthole incwadi entsha, kodwa ikhadi lenkomba yomtapo wolwazi lisenayo inombolo yocingo yencwadi endala. Uma uya ukuyoyifuna eshalofini, vele, ayinalutho. Kodwa uma ushintsha isihloko sencwadi, umtapo wolwazi uzokwakhela ikhadi elisha lenkomba, bese ulithola.

Isizathu 1: I-OPcache cache ibangela izikhala ezingenalutho

Ungabhekana kanjani nayo?

Qala kabusha isevisi ye-PHP-FPM bese usula i-cache ye-OPcache.

# 查看正在运行的PHP版本
php -v

# 重启对应的PHP-FPM（例如PHP 8.5）
sudo systemctl restart php8.5-fpm

# 或者重启所有PHP-FPM服务
sudo systemctl restart php*-fpm

Ngemva kokuqala kabusha, qamba kabusha ifayela libe yi-adminer.php, uvuselele ikhasi lewebhu (kunconywa ukuthi ucindezele i-Ctrl+F5 ukuze uphoqe ukuvuselela isiphequluli), bese inkinga kufanele ixazululwe.

Kodwa indaba ayikapheli.

Ngemva kokuqala kabusha i-PHP-FPM, ngishintshe ifayela le-adminer.php, ngavuselela ikhasi, kodwa lalisangenalutho. Ngangididekile ngokuphelele.

Isizathu 2: Imikhawulo yomthetho wokucushwa kwe-Nginx

Lokhu kuholela esizathwini sesibili okungenzeka.

Ifayela lokucushwa kwe-Nginx lingase libe nemithetho ekhethekile evimbela i-adminer.php.

Bengilapha ngaphambiliI-HestiaCPI-F ilungiselelwe kuphaneli.aiI-l2Ban isebenzise umthetho oqondile wokufanisa we-adminer.php ukuvimbela ukuhlaselwa kwe-brute-force. Lo mthetho uqinisa igama lefayela le-adminer.php, ngakho-ke uma uliqamba kabusha libe yi-adminer1.php, uyawudlula lo mthetho we-Nginx futhi ungafinyelela isayithi ngokujwayelekile.

Indlela yokuxazulula izinkinga ilula: sesha okufakiwe okunekhodi eqinile ekucushweni kwe-Nginx.

sudo grep -rn "adminer.php" /etc/nginx/

Uma uthola imithetho efana nethi `location = /adminer.php { … }`, kusho ukuthi i-Nginx iphatha leli gama lefayela elithile ngokukhethekile. Vele ulisuse noma ulishintshe.

Isizathu 3: Izilungiselelo zokubonisa iphutha le-PHP

Isizathu sesithathu sicashile kakhulu.

Isikripthi se-PHP siyabanjwa noma siphonsa iphutha, kodwa ikhasi likhubaza ukuboniswa kwamaphutha (display_errors = Valiwe). Endaweni yokukhiqiza, i-PHP ifihla amaphutha ngokuzenzakalelayo, ibonise ikhasi elingenalutho. Uma ifayela lakho lokufaka (isb., index.php) liphahlazeka ngesizathu esithile ngenkathi lizama ukufaka i-"./adminer.php", ikhasi lizomane lingabi nalutho.

Kulesi simo, ukuhlola ilogi yamaphutha kuyindlela ethembeke kakhulu:

# 查看Nginx错误日志
sudo tail -n 20 /var/log/nginx/error.log

# 或者查看HestiaCP对应域名的error日志
sudo tail -n 20 /var/log/nginx/domains/adminer.domain.com.error.log

Ilogi izokutshela isizathu sangempela sesikrini esimhlophe.

Uma ngikhuluma iqiniso, ekugcineni ngithole inkinga ngokuhlola i-error.log. Kwavela ukuthi i-adminer.php yayibiza isandiso se-PHP esingekho, futhi i-display_errors yayivaliwe, ngakho ikhasi lalingenalutho, kodwa i-log yamaphutha yaliqopha ngokucacile.

Izixazululo nezinyathelo zokuxazulula izinkinga

Lesi sigameko singishiye nombono ojulile.

Izinkinga zobuchwepheshe ngokuvamile azilula njengoba zibonakala phezulu. Ifayela elingenalutho le-adminer.php lingase libonakale liyinkinga yefayela ekuqaleni, kodwa ukumba ngokujulile kungaveza inkinga yokugcina isikhashana, kamuva kungaba inkinga yokucushwa, futhi kamuva kamuva kungaba inkinga ngekhodi uqobo.

Uma ungeyena umhleli wezinhlelo, ungase ucabange ukuthi lezi zinto azibalulekile kuwe. Kodwa cabanga ngakho: lonke uhlelo lokusebenza olusebenzisayo, ikhasi ngalinye lewebhu olivakashelayo, linesistimu efanayo esebenza ngemuva kwezigcawu. Ukugcina isikhashana, ukucushwa, ukuphathwa kwamaphutha—le mibono ikhona yonke indawo.

Njengathi nje bantu. Izikhathi eziningi, "izimpawu" esizibonisayo, njengokuhlehlisa izinto, ukukhathazeka, nokucasuka, zingase zibonakale sengathi ubuvila obubonakalayo, kodwa ukumba ngokujulile, kungase kube ngenxa yemigomo engacacile, ukumba ngokujulile, ukwesaba ukwehluleka, kanye nokujula nakakhulu, isimo sengqondo esakhiwe yizinto ezenzeka ebuntwaneni.

Kungokuthola imbangela yangempela kuphela lapho singakunikeza khona umuthi ofanele.

Okokugcina, uma uhlangabezana nenkinga yefayela elingenalutho le-adminer.php, lihlole ngale ndlela:

Okokuqala, qala kabusha i-PHP-FPM bese usula i-cache, bese uhlola ukucushwa kwe-Nginx, bese ekugcineni uhlola i-error.log.

Ezimweni eziningi, izinyathelo ezimbili zokuqala zanele ukuxazulula inkinga.

Vele, uma lokho kungasebenzi, hlola i-error.log.

Kuzokutshela impendulo.

Njengoba usufundile kuze kube manje, uma ukuthole kuwusizo, sicela uthande futhi wabelane ngakho. Uma ufuna ukuthola izibuyekezo kuqala, ungangilandela futhi!

Ngiyabonga ngokufunda isihloko sami. Sizobonana ngesikhathi esizayo.