Summary of methods to prevent SQL injection attacks (1/2)

Source: Internet
Author: User
Tags ini php code php script phpinfo safe mode sql injection

First, on the server-side configuration

Security, PHP code writing is on the one hand, PHP configuration is very critical.

Our PHP hand-installed, PHP default profile in/usr/local/apache2/conf/php.ini, our main is to configure the content of PHP.ini, let us execute PHP can be more secure. Security settings throughout PHP are primarily designed to prevent Phpshell and SQL injection attacks, and we'll explore it slowly. We first use any editing tool to open/etc/local/apache2/conf/php.ini, and if you are installing in a different way, the profile may not be in that directory.

(1) Open PHP security mode

PHP's Safe mode is a very important embedded security mechanism that can control functions in PHP, such as System (),

At the same time, a lot of file operation functions are controlled by permissions, also do not allow some key file files, such as/etc/passwd,

But the default php.ini is not open safe mode, we turn it on:

Safe_mode = On

(2) User group security

When the Safe_mode is turned on, the Safe_mode_gid is turned off, so the PHP script can access the file and the same

Users of a group can also access files.

The recommended setting is:

Safe_mode_gid = Off

If you do not set it, we may not be able to operate on our server web directory files, such as we need

When you are working on a file.

(3) Safe Mode executable Program Home directory

If Safe mode is open, but you want to execute some programs, you can specify the home directory where you want to execute the program:

Safe_mode_exec_dir = D:/usr/bin

In general, there is no program to perform, so it is recommended not to execute the System program directory, you can point to a directory,

Then copy the program that needs to be executed, such as:

Safe_mode_exec_dir = D:/tmp/cmd

However, I recommend that you do not execute any programs, then you can point to our web directory:

Safe_mode_exec_dir = d:/usr/www

(4) Include files in Safe mode

If you want to include some public files in Safe mode, modify the options:

Safe_mode_include_dir = d:/usr/www/include/

In fact, the general PHP script contains files are in the program itself has been written, this can be set according to the specific needs.

(5) Control the directory that the PHP script can access

Using the Open_basedir option to control PHP scripts can only access the specified directory, so that you can avoid PHP script access

Files that should not be accessed, to some extent limit the harm of phpshell, we can generally set to access only the site directory:

Open_basedir = d:/usr/www

(6) Close the dangerous function

If Safe mode is turned on, the function prohibition is not necessary, but we consider it for security. Like what

We don't feel like executing PHP functions that can execute commands, including system (), or can view PHP information

Phpinfo () and so on, then we can ban them:

Disable_functions = System,passthru,exec,shell_exec,popen,phpinfo

If you want to disable the operation of any files and directories, you can turn off many file operations

Disable_functions = Chdir,chroot,dir,getcwd,opendir,readdir,scandir,fopen,unlink,delete,copy,mkdir, Rmdir,rename, File,file_get_contents,fputs,fwrite,chgrp,chmod,chown

The above is just a list of not commonly used file processing functions, you can also perform the above command function and this function combined,

will be able to resist most of the Phpshell.

(7) Turn off the disclosure of PHP version information in HTTP headers

In order to prevent hackers from obtaining information about the PHP version of the server, you can turn off the information ramp in the HTTP header:

expose_php = Off

For example, when the hacker in Telnet www.12345.com 80, then will not be able to see the PHP information.

(8) Turning off registration of global variables

Variables submitted in PHP, including those submitted using post or get, are automatically registered as global variables and can be accessed directly.

This is very unsafe for the server, so we cannot have it registered as a global variable and turn off the registration global variable option:

Register_globals = Off

Of course, if you set this up, then you need to get the corresponding variable in a reasonable way, such as getting the variable var of get commit,

Then you need to use $_get[' var ' to get it, the PHP programmer should pay attention.

(9) Open MAGIC_QUOTES_GPC to prevent SQL injection

SQL injection is a very dangerous problem, small web site backstage was invaded, heavy the entire server fell,

So be sure to be careful. There is a setting in php.ini:

MAGIC_QUOTES_GPC = Off

This default is turned off, and if it is turned on, it will automatically convert the user to the SQL query.

For example, the ' switch ' and so on, which has a significant effect on preventing SQL injection. So we recommend setting it to:

MAGIC_QUOTES_GPC = On

(10) Error information control

General PHP is not connected to the database or other circumstances will be prompted error, the general error message will contain PHP script when

Before the path information or query SQL statements, such as information, such information provided to hackers, is not secure, so the general server recommended to prohibit error prompts:

Display_errors = Off

If you are trying to display an error message, be sure to set the level at which the error is displayed, such as displaying only the information above the warning:

error_reporting = e_warning & E_error

Of course, I recommend closing the error prompt.

(11) Error log

It is recommended that the error message can be logged after the display_errors is turned off to make it easier to find out why the server is running:

Log_errors = On

Also set the directory where the error log is stored, and suggest that the log of the root Apache be present together:

Error_log = D:/usr/local/apache2/logs/php_error.log

Note: You must allow the Apache users and groups to have write permissions to the file.

Home 1 2 last page

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.