Squid basic_db_auth: ukuxhuma ku-database ye-MySQL ekude
Dlulisa i-host ye-MySQL ngokukhetha i-DSN okusekelwa yi-basic_db_auth ngenkathi ugcina ukulungiselelwa kwethebula le-akhawunti elikhona ku-helper.
Ekufakweni kwe-Squid okusebenzisa basic_db_auth, indawo ye-database isegameni lomthombo wedatha we-DBI we-helper. Umthombo we-helper ku-Squid 7 uhlinzeka ngokukhetha --dsn; umshayeli we-MySQL wamukela izinkambu ze-host ne-port:
--dsn "DBI:mysql:database=squid;host=db.example.net;port=3306"Lena ingxenye yezimpikiswano zokushayela i-helper ekhona, hhayi umyalo ozimele. Yengeza kumyalo we-auth_param basic program osevele uqalisa i-helper efakiwe. Indlela yefayela elisebenzayo incike kuphakethe lwe-Squid.
Gcina ukulungiselelwa okunye kwe-helper. Amanani ayo --user ne---password avula ukuxhumana kwe-database. Izinketho zayo zethebula, ikholomu yegama lomsebenzisi, ikholomu yephasiwedi nefomethi yephasiwedi zichaza amarekhodi e-akhawunti ye-proxy agcinwe lapho. Ukushintsha i-host ye-database akushintshi leso sikhimu noma ifomethi yephasiwedi.
I-helper idlulisela i-DSN nezimpawu zokungena ze-database ku-DBI->connect. Ngakho-ke umshayeli we-Perl DBI ofanele kufanele atholakale endaweni ye-helper, futhi i-database kufanele yamukele ukuxhumana okuvela ku-host ye-proxy.
Ukusebenzisa ukukhetha okunikeziwe kugcina ikheli le-database ekulungiseleleni kokufakwa. Asikho isidingo sokushintsha umbhalo we-DSN ozenzakalelayo kukhodi yomthombo ye-Perl ye-helper.