Tags: space span font log string intercept--Color Oracle function --1. The Lpad function populates the left string with some specific characters whose syntax is formatted as follows:Lpad (String,n,[pad_string])
--string: But the character or argument
--N: The length of the character, is the number of strings returned, if this number is shorter than the length of the original string, the Lpad function will intercept the string as a left-to-right n character;
--pad_string: is an optional parameter
1) LPAD method:
SELECTLPAD (sal, 8,'0')FROMEmp;
2) TO_CHAR Method
SELECTTO_CHAR (sal,'123')FromEmp;
3) SUBSTR Method
SELECTSUBSTR ('123'| Sal,-8)FROMEmp;
========================================================== ========================================================== ============================================
Supplement:
LPAD and RPAD usage:
Lpad () function usage:
The lpad function fills the string on the left with some specific characters. The syntax format is as follows:
Lpad (str
Defined in MenifestDefined in XMLResourcesXmlns:xliff= "urn:oasis:names:tc:xliff:document:1.2"> tech-list> Tech>Android.nfc.tech.MifareUltralightTech> Tech>Android.nfc.tech.NdefTech> Tech>Android.nfc.tech.NfcATech> tech-list>
Lpad () function usage:
The lpad function fills the string on the left with some specific characters. The syntax format is as follows:
Lpad (string, n, [pad_string])
String: but a character or Parameter
N: the length of the character, which is the number of returned strings. If the number is shorter than the length of the original string, the lpad function splits the string into n characters from left to right;
Pad_string: it is an optional parameter. This string is to be pasted to the left of t
=" http://www.ibm.com/developerworks/cn/linux/l-10sysadtips/figure3.jpg "to the parameter Width= "572"/>Then press Enter and B, and the kernel will boot into single-user mode. Then run passwd the command to change the user root password:sh-3.00# passwdNew UNIX password:Retype new UNIX password:passwd: all authentication tokens updated successfullyIt is now possible to reboot and the machine will start with the new password.Back to top of pageTip 5:ssh Back DoorA lot of times, my site needs someo
Apache implements https certificate key verification-Linux Enterprise Application-Linux server application information. The following is a detailed description. Build basic Apache services and access them properly.
1. Install the mod_ssl module to allow Linux to support SSL:
Yum install mod_ssl-y
2. Create a certificate and key file:
Cd/etc/pki/tls/certs
Make httpd. crt // The Name Of The certificate file. Do not change the extension. At last, two fil
1. Install the ssl module
# Yum-y install mod_ssl
2. Tell apache which website is to Use https, that is, to build a website. It can also be the same as what was previously set up in http.
# Vi/etc/httpd/conf. d/ssl. conf
DocumentRoot/var/www/test/html
Servername www.bkjia.com
3. Create a certificate file
# Cd/etc/pki/tls/certs
[Root@www.bkjia.com] # make server. key ### generate a key file
[Root@www.bkjia.com] # openssl rsa-in server. key-out server.
Python's PKCS7 encryption seems to be different, and the results are completely different.
The code for PHP is as follows public static function Envelope ($data) {$Millisecond = Signenvelope::getmillisecond (); Save the source data file $dataFile = "./rsa/". $Millisecond. " Data.txt "; Save the signature file $signedFile = "./rsa/". $Millisecond. " Signed.txt "; After saving the signature base64 file $signedDataFile = "./rsa/". $Millisecond. " SignedData.txt "; File $envelopeFile = "./r
on IP address, so only one HTTPS virtual host can be used on a single IP hostTwo: Configure HTTPD to support HTTPS(1) Apply for a digital certificate for the server;Testing: Issuing a certificate through a privately built CA(a) creating a private CA(b) Create a certificate signing request on the server(c) CA Visa(2) Configure HTTPD to support the use of SSL, and the use of certificates;# yum-y Install Mod_sslConfiguration file:/etc/httpd/conf.d/ssl.confDocumentRootServerNameSslcertificatefileSs
Self-built CA Based on OpenSSL and SSL certificate issuance
For details about SSL/TLS, see the SSL/TLS principles.For more information about Certificate Authority (CA) and digital certificate, see OpenSSL and SSL digital certificate concepts.
Openssl is a suite of open-source programs. It consists of three parts: one islibcryto, This is a general function of the encryption library, which implements a large number of encryption libraries; secondlibsslThis implements the ssl mechanism. It is used
Here is a simple demonstration of Apache encryption based authentication access----HTTPS encryption method access.
1.DNS Resolution resolution:
[Root@localhost html]# nslookup www.downcc.com
server:192.168.2.115
address:192.168.2.115#53
Name:www.downcc.com
address:192.168.2.115
2. Install the Apache SSL support module: # yum install-y mod_ssl (default yum installation httpd is not installed this module, automatic production of/etc/httpd/conf.d/ssl.conf files after installation) and genera
.# mkdir Results/home/myftp#chmod 755 Results#chattr +i/home/resultsVI. Configuring SSL Encryption1, through Rpm-qa | OpenSSL to see if OpenSSL is installed, install first2, new directory, in order to place the certificate, it is possible that the Certs folder already exists, but to confirm that the existing folder is only a link.
Mkdir-p/etc/ssl/certs
chmod 700/etc/ssl/
/ Staticloggerbinder.class]Slf4j:see http://www.slf4j.org/Codes.html#multiple_bindings forAn explanation. Slf4j:actual binding is ofType[org.slf4j.impl.Log4jLoggerFactory]Hive> UseZhangchao; OK Time Taken:1.023seconds Hive>Show tables; OK Jigou time Taken:0.255Seconds, fetched:1row (s) Hive> Select * fromJigou limitTen; OK d64ceb0d-c85a-43ca-a705-c34f4258e938002Chengdu High-Tech zone West Park Community Health Service Center CDGXQXYSQW1 09465
blackbox.example.com. The machine behind the company's firewall is called Ginger. The machines supported by this technology are called Tech. Figure 4 illustrates the setup process.
Figure 4. Add a hole in the firewall
The procedure is as follows:
Check what is allowed, but make sure you have the right person. Most people worry that you have enabled the firewall, but they do not understand that this is completely encrypted. Moreover, external machin
CentOS/RHEL:
In CentOS/RHEL, you must first enable EPEL or Repoforge software repository.
# yum install monit
Monit comes with a well-documented configuration file, which contains many examples. The main configuration file is in/etc/monit. conf (Fedora/CentOS/RHEL), or/etc/monit/monitrc (Debian/Ubuntu/Mint ). The Monit configuration file has two parts: Global and Services ).
Global Configuration: Web Status Page (Global Configuration: Web Status Page)
Monit can use the mail service to send n
support for our servers. In this case, you need to edit the/etc/proftpd. conf configuration file. Before that, we need to back up the current configuration file to ensure that the file can be restored after the problem is rectified.
$ sudo cp /etc/proftpd.conf /etc/proftpd.conf.bak
Then, we can use our favorite text editor to modify the configuration file.
$ sudo vi /etc/proftpd.conf
Then, append the following lines to the content we added in step 1.
TLSEngine on
TLSRequired on
TLSPro
you decide if you want to add nginx to the front end)3.1 Installing and configuring NginxAs you can see from the above procedure, unless the firewall is restricted, any host can create an account and want to push the image, it is safer to join the login authentication mechanism in the outer layer.最好安装1.4.x版本,不然下面的有些配置可能会不兼容# yum install nginx创建两个登录用户# htpasswd -c /etc/nginx/docker-registry.htpasswd seanNew password: Re-type new password: Adding password for user sean# htpasswd -c /etc/nginx/doc
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.