example, to add a user with the username test and password 1234, edit the following content: test pptpd 1234 * (specifying the ip address assigned to the user test)6. Modify the kernel settings to support forwarding. Edit/etc/sysctl. conf file: www.2cto.com # vim/etc/sysctl. conf. ipv4.ip _ forward "is changed to 1 and becomes the following form: net. ipv4.ip _ forward = 1 save and exit, and execute the following command to take effect: # sysctl-p7. Add iptables forwarding rules. After the prev
. the last step is to add iptables forwarding rules. Enter the following command:
# Iptables-t nat-a postrouting-s 192.168.0.0/24-o eth0-j MASQUERADE
Note that the "192.168.0.0/24" in this command is changed according to the "localip" network segment in the previous configuration file, for example, the "10.0.0.1" network segment you set, it should be changed to "10.0.0.0/24 ″. in addition, you need to note eth0. If your Internet Nic is not eth0, but eth1 (for example, the
you set, change to "10.0.0.0/24 ". In addition, you need to note that eth0, if your internet nic is not eth0, but eth1 (such as the SoftLayer server, you can use the ifconfig command to view the Ethernet port name). Remember to change eth0 to the corresponding NIC number. Otherwise, the network cannot be connected!Then, enter the following command to allow iptables to save the forwarding rule we just added so that you do not need to add it
as you set the "10.0.0.1″ network segment, it should be changed to" 10.0.0.0/24″. In addition there is a point to note is eth0, if your extranet network card is not eth0, but eth1 (such as the SoftLayer of the server is such a situation), then please remember to change the eth0 also to the corresponding network card number, otherwise it is not on the net.
We then enter the following instructions to let iptables save our forwarding rules so that we d
For LIKE fuzzy search, you can use the wildcard "%" and "_": %: to indicate any character, including zero; _: to indicate any character; SQL code Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> select * from dept; deptno dname loc ------ ------------ ------------- 10 accounting new york 20 research dallas 30 sales chicago 40 operations boston "%" and "_" Demo: SQL code SQL> select * from dept where DNAME
president 17-11 month-81 5000 10 7876 adams clerk 7788 month-87 1100 20 7902 ford analyst 7566 03-12 month-81 3000 20 7934 miller clerk 7782 23-1 month-82 1300 10. Eight rows have been selected. Use the UNION operator to calculate the total salary of each department in scott's emp table and the salary of each department's position. SQL code> break on deptno skip 2; SQL> select deptno, job, sum (sal) from emp group by deptno, job 2 union 3 select deptno, to_char (null), sum (sal) from emp group
* from dept;
DEPTNO DNAME LOC
-------------------------------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL>
SQL>
4. utlsampl. SQL script contentThere are many scripts in the ORACLE_HOME \ RDBMS \ ADMIN directory. utlsampl. SQL is only one of them. If you are interested in these scripts, you will also find some benefits. Here, let's take a look at the utlsampl. SQL script content.
Rem Copyright (c) 1990,199
Canonical held a Ubuntu developer Summit (UDS) in Dallas, Texas last week to discuss the development plan for Ubuntu10.04 with attendees. One important thing is that GIMP will no longer be used as the default installer for Ubuntu10.04. Although this decision has aroused a lot of controversy, the basis behind the withdrawal of the default program GIMP is indeed very good. Many industry analysts believe that, giving up this professional and powerful gra
requirements. Today pieces will take you to understand appfog!One, Appfog free cloud Space Application tutorial1, first enter the registered address Https://console.appfog.com/signup, fill in the relevant information, password must be 8 or more.2, after the registration is completed, your cloud space has been opened! Now you can create a new app. Click "Create app" to make the first step: Select an application. Here we choose to install WordPress as an example.3, the second step: is the choice
1-Wire Bus Technology and Its Application Abstract: This paper introduces the principle and signal transmission mode of the single bus technology introduced by Dallas, and describes the single bus communication protocol, finally, the single-bus data transmission method is presented based on the application of the single bus device iButton in the security system. keywords: Single-bus single-bus protocol iButton 1 Introduction at present, the com
health experts point out, every year thousands of Americans die from the flu.Second, Ebola is actually a difficult disease to catch. It ' s not transmitted through the air like the flu. You cannot get it from the just riding on a plane or a bus. The only-to-a person can contract the disease are by coming to direct contact with the bodily fluids of somebody wh O is already showing symptoms. I ' ve met and hugged some of the doctors and nurses who ' ve treated Ebola patients. I ' ve met with a Eb
= = 0 strHere are 4 files for 1.txt 2.txt a.txt B.txt, respectively, as follows:1.txtNFC East rival quarterbacks Tony Romo (notes) of the Dallas Cowboys and Eli Manning (notes) of the New York giants now has Something else in common?? They ' ve used the same wedding planner to help them tie the knot. Todd Fiscus, the man and the plan, set up and what he called "Mans food" at Dallas ' Arlington Hall on Sat
condition is to filter the previous operation (such as the tableResult set, for example.
-- EMP. deptno = Dept. deptno is the connection condition -- Dept. loc = 'Dallas 'restriction condition select EMP. ename from EMP, DEPT where EMP. deptno = Dept. deptno and dept. loc = 'Dallas'10-1
On the one hand, connection conditions can be used to filter data. On the other hand, in order to minimize the amount of
the waveform to pinyin, and then convert the pinyin text. Zhao Jian is mainly responsible for converting pinyin into text. But in Dallas, Texas, it seems that this place is too small, or it may be a habit in China. His first impression of the city was: I'm going to watch the Dallas Mavericks match! It's too small. Take a taxi for 10 minutes. It will take less than half an hour. It will be Gobi after leavin
What is savepoint?
Use
The SAVEPOINT statement to identify a point in a transaction to which you can
Later roll back.
For example:
SQL> SELECT * FROM SCOTT. DEPT;
DEPTNODNAME LOC---------------------------------10ACCOUNTING NEW YORK20 RESEARCH DALLAS30SALES CHICAGO40 OPERATIONS BOSTONSQL> UPDATESCOTT. dept set loc = 'A' WHERE loc = 'New YORK ';
1 row updatedSQL>SAVEPOINT;
Savepoint createdSQL> update scott. dept set loc = 'B'WHERE loc = 'Dallas ';
1
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.