{"id":1241,"date":"2017-12-18T12:51:58","date_gmt":"2017-12-18T10:51:58","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=1241"},"modified":"2017-12-18T12:51:58","modified_gmt":"2017-12-18T10:51:58","slug":"windows-pleskte-yanlislikla-yonetim-erisimini-sinirlandirip-erisemez-isek-ne-yapabiliriz","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2017\/12\/windows-pleskte-yanlislikla-yonetim-erisimini-sinirlandirip-erisemez-isek-ne-yapabiliriz\/","title":{"rendered":"Windows plesk’te yanl\u0131\u015fl\u0131kla y\u00f6netim eri\u015fimini s\u0131n\u0131rland\u0131r\u0131p eri\u015femez isek ne yapabiliriz?"},"content":{"rendered":"

Yine ba\u015f\u0131m\u0131za gelen bir hadise , Windows Plesk te y\u00f6netim eri\u015fimini yanl\u0131\u015f ayarlama sebebi ile hi\u00e7 bir \u015fekilde Plesk aray\u00fcz\u00fcne giremez olduk. Tekrar nas\u0131l a\u00e7ar\u0131z diye d\u00fc\u015f\u00fcn\u00fcrken \u00e7\u00f6z\u00fcm\u00fc a\u015fa\u011f\u0131daki \u015fekilde bulduk.<\/p>\n

O sunucuya RDP ile ba\u011flan\u0131n ve komut konsolunu a\u00e7\u0131n. (cmd)<\/p>\n

A\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131ral\u0131m ve sonras\u0131nda direkt olak mysql in i\u00e7ine d\u00fc\u015fece\u011fiz.<\/p>\n

C:\\Users\\Administrator>plesk db<\/strong>
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 22731
\nServer version: 5.5.52 MySQL Community Server (GPL)<\/p>\n

Copyright (c) 2000, 2016, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n

mysql><\/p>\n

\u015eimdi ilgili veritaban\u0131na eri\u015felim , access_policy de\u011feri psa isimli veritaban\u0131m\u0131z\u0131n i\u00e7inde misc isimli tabloda yer al\u0131yor.<\/p>\n

mysql> use psa;<\/strong>
\nDatabase changed<\/p>\n

\u015eu anda psa isimli tablomuzda i\u015flem yapabiliriz , \u00f6nce yanl\u0131\u015fl\u0131kla kapatt\u0131\u011f\u0131m\u0131z de\u011ferimizi g\u00f6relim, bak\u0131n\u0131z deny durumunda yani kimse eri\u015femesin demi\u015fiz , \u015fimdi bunu allow olarak de\u011fi\u015ftirmemiz gerekiyor.<\/p>\n

mysql> select * from misc;<\/strong>
\n+———————————+————-
\n—————+
\n| param | val
\n|
\n+———————————+————-
\n—————+
\n| access_policy | deny<\/strong><\/p>\n

Bu de\u011feri allow yapmak i\u00e7in a\u015fa\u011f\u0131daki sorgumuzu \u00e7al\u0131\u015ft\u0131ral\u0131m.<\/p>\n

mysql> update misc set val=”allow” where param=”access_policy”;<\/strong><\/p>\n

\u015eimdi de\u011fere tekrar bakt\u0131\u011f\u0131m\u0131zda art\u0131k deny yazan yerde allow yazd\u0131\u011f\u0131n\u0131 g\u00f6receksiniz ve farkl\u0131 hi\u00e7 bir i\u015flem yapmadan Plesk y\u00f6netim aray\u00fcz\u00fcne eri\u015febilirsiniz.<\/p>\n

Ayhan ARDA<\/p>\n

\"Share<\/a>