{"id":1036,"date":"2006-09-19T00:58:06","date_gmt":"2006-09-19T00:58:06","guid":{"rendered":""},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"captcha-mysql-5-guben-blogger-ve-amerikan-aksanli-winxp","status":"publish","type":"post","link":"https:\/\/www.emresururi.com\/blogs\/sururi\/2006\/09\/19\/captcha-mysql-5-guben-blogger-ve-amerikan-aksanli-winxp\/","title":{"rendered":"CAPTCHA, MySQL 5, GUBEN Blogger ve Amerikan Aksanl\u0131 WinXP"},"content":{"rendered":"

Ge\u00e7en g\u00fcn comment spammerlar\u0131<\/i> gene i\u015fba\u015f\u0131 yapt\u0131lar. Benim de can\u0131ma tak etti, “resimde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz harfleri \u015furaya \u015furaya giriniz…” t\u00fcr\u00fcnden bir spam engelleyici yazay\u0131m dedim ama vaktim olmay\u0131nca, bakal\u0131m ellerde ne var<\/i> d\u00fcsturu uyar\u0131nca biraz web’de gezindim ve CAPTCHA<\/b> kavram\u0131 ile tan\u0131\u015ft\u0131m. CAPTCHA<\/i>, “Computer Assisted Program for Telling Computers and Humans Apart” tan\u0131m\u0131n\u0131n k\u0131salt\u0131lmas\u0131 ve bir t\u00fcrl\u00fc anlayamad\u0131\u011f\u0131m, anlatamad\u0131\u011f\u0131m Turing makinelerine g\u00fczel g\u00fczel referanslar i\u00e7eriyor. Bozulmu\u015f harflerin yaz\u0131lmas\u0131n\u0131 istemek de bu dal\u0131n i\u015fi, resimler g\u00f6sterip, i\u00e7inde yer alan nesneleri \u00e7oktan se\u00e7meli olarak belirletmek de, hatta bir \u015feyleri sesli olarak \u00e7al\u0131p, s\u00f6ylenen \u015feyleri yazd\u0131rtmak da. Hayli ilgin\u00e7 bir \u015fey asl\u0131na bakarsan\u0131z. Zira insanlar, insanlar\u0131 ay\u0131rt etmek i\u00e7in makineleri kullan\u0131yorlar ve makine vs. makine <\/i>durumlar\u0131 has\u0131l oluyor. Sonu\u00e7ta ben, http:\/\/www.php.meezerk.com\/<\/a> adresinden PHP ile yaz\u0131lm\u0131\u015f, basit ama etkili olabilece\u011fini d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir kodu indirdim, bug\u00fcn yar\u0131n GUBEN Blogger’a eklerim in\u015fallah. <\/p>\n

Gelelim bir ba\u015fka soruna: Evelsi hafta yeni bilgisayar\u0131ma kavu\u015ftum (a\u011fabeyim sa\u011folsun!). Kendileri bir adet Sony VAIO olup, VGN-FE11H ad\u0131yla gitmektedirler ama biz ona k\u0131saca V\u00e2l\u00e2<\/i> diyoruz (as in V\u00e2l\u00e2 Nurettin<\/i>). Aletin i\u015fletim sistemi Windows XP Professional Media Center Edition<\/i>. San\u0131r\u0131m bu sondaki Media Center Edition olay\u0131ndan dolay\u0131 i\u015fletim sistemi \u0130ngilizce olmu\u015f. Ba\u015fta sorun yok dedim ama karakter tablolar\u0131 beni \u00f6ld\u00fcr\u00fcyor. Zannederim yak\u0131n bir zaman i\u00e7erisinde dayanacak takat\u0131m kalmayacak ve pa\u015fa pa\u015fa WinXP T\u00fcrk\u00e7e kuraca\u011f\u0131m. <\/p>\n

\u015eimdi bilgisayar yeni ya, o y\u00fczden \u00f6zenle programlar\u0131 kurdum. \u0130\u015f Apache-PHP-MySQL \u00fc\u00e7l\u00fcs\u00fcne gelince, Apache’nin 1’li, PHP’nin ise 4’l\u00fc versiyonlar\u0131n\u0131n en son \u00e7\u0131kan kararl\u0131 s\u00fcr\u00fcmlerini kurarken, nedense \u015feytana uydum ve MySQL’in 5’ini kuruverdim. Ba\u015flang\u0131\u00e7ta her \u015fey iyi gidiyordu — ben MySQL’e PHP’den ba\u011flanamay\u0131ncaya kadar! Efenim neymi\u015f, authentication’\u0131m\u0131 be\u011fenmemi\u015f, client’\u0131m pek bir demode kalm\u0131\u015f falan filan. SEN O CLIENT’A KURBAN OL, E M\u0130! Neyse ki OLD_PASSWORD() deyu bir fonksiyon eklemi\u015fler, o sayede root hesab\u0131m\u0131n \u015fifresini eski formata sokabildim de, mevcut PHP kodumu \u00e7al\u0131\u015ft\u0131rabildim \/ \u00e7al\u0131\u015ft\u0131rabildi\u011fimi zannettim.<\/p>\n

Ama kaz\u0131n aya\u011f\u0131 \u00f6yle de\u011filmi\u015f. Bunu, yay\u0131la yay\u0131la \u015fu CAPTCHA kodunu GUBEN’ime yamay\u0131m diye GUBEN’i lokalde \u00e7al\u0131\u015ft\u0131rmaya te\u015febb\u00fcs edince anlad\u0131m. Kod bir g\u00fczel Apache’yi uzaya g\u00f6nderiyor, bekle bekle gelmiyor, bilgisayar da bir s\u00fcre sonra k\u00fcs\u00fcyor, yan\u0131t vermemeye ba\u015fl\u0131yor. Sonunda ald\u0131m elime bir echo “lala”;exit;<\/i> sat\u0131r\u0131, koydum copy ka\u015fesine, ad\u0131m ad\u0131m ilerlemeye ba\u015flad\u0131m kilitlenme oluncaya kadar. Nihayet buldum. HANG\u0130 \u0130NSAN EVLADI <\/b>TIMESTAMP format\u0131n\u0131 YYYYMMDDHHMMSS’dan k\u00fct diye YYYY-MM-DD HH:MM:SS format\u0131na \u00e7evirir ve eski s\u00fcr\u00fcme destek kap\u0131s\u0131n\u0131 aralamaz? Tabii hal b\u00f6yle olunca, benim b\u00fct\u00fcn substr fonksiyonlar\u0131m sa\u00e7malamaya ba\u015flad\u0131. Ha, bir de ya bu MySQL’de has\u0131l olmu\u015f, ya da phpmyadmin’i de son s\u00fcr\u00fcme y\u00fckselttim, o y\u00fczden fark etmeye ba\u015flad\u0131m, bir COLLATION diye ba\u015f a\u011fr\u0131s\u0131 \u00e7\u0131kartm\u0131\u015flar. Benim bilgisayar ki T\u00fcrk\u00e7e klavyeli \u0130ngilizce i\u015fletim sistemli bilgisayar, veritabanlar\u0131m\u0131n \u0130SVE\u00c7\u00c7E oldu\u011funu bas bas ba\u011f\u0131r\u0131yor, ne desem d\u00f6nmedi karar\u0131ndan. B\u00f6ylelikle Amerikan aksanl\u0131 T\u00fcrk\u00e7e konu\u015fan bir i\u015fletim sistemim ve bo\u015f zamanlar\u0131nda kendi aralar\u0131nda \u0130sve\u00e7\u00e7e konu\u015fmay\u0131 tercih eden blog giri\u015flerim var. Hay\u0131r, \u0130sve\u00e7 cand\u0131r, hi\u00e7bir \u015feyi olmasa bile Nina’s\u0131 var, ABBA’y\u0131 \u00e7\u0131kartm\u0131\u015f, Ace of Base cabas\u0131, ona bir \u015fey demeyece\u011fim ama zorrr geliyor belli bir ya\u015ftan sonra, de\u011fil mi can\u0131m… <\/p>\n

\u015eimdi ne yapaca\u011f\u0131m\u0131 merak edenlere: pa\u015fa pa\u015fa bana birka\u00e7 boy b\u00fcy\u00fck gelen MySQL 5’i kald\u0131raca\u011f\u0131m, 4.1 \u00f6ncesine gidece\u011fim; kimse kusura kalmas\u0131n. Bilgisayara da fazla program y\u00fcklemeyeyim de, bir ara m\u00fcsait olunca g\u00fczel g\u00fczel WinXPTur kuray\u0131m.<\/p>\n","protected":false},"excerpt":{"rendered":"

Ge\u00e7en g\u00fcn comment spammerlar\u0131 gene i\u015fba\u015f\u0131 yapt\u0131lar. Benim de can\u0131ma tak etti, “resimde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz harfleri \u015furaya \u015furaya giriniz…” t\u00fcr\u00fcnden bir spam engelleyici yazay\u0131m dedim ama vaktim olmay\u0131nca, bakal\u0131m ellerde ne var d\u00fcsturu uyar\u0131nca biraz web’de gezindim ve CAPTCHA kavram\u0131 ile tan\u0131\u015ft\u0131m. CAPTCHA, “Computer Assisted Program for Telling Computers and Humans Apart” tan\u0131m\u0131n\u0131n k\u0131salt\u0131lmas\u0131 ve bir … Okumaya devam et “CAPTCHA, MySQL 5, GUBEN Blogger ve Amerikan Aksanl\u0131 WinXP”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/posts\/1036"}],"collection":[{"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/comments?post=1036"}],"version-history":[{"count":0,"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/posts\/1036\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/media?parent=1036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/categories?post=1036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.emresururi.com\/blogs\/sururi\/wp-json\/wp\/v2\/tags?post=1036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}