湖濱散記部落格的樹心幽徑[<a href=login.php>login</a>][<a href= . >主頁</a>]<hr>
415:20180629openssl操作<br><table width=800 border=8><tr><td bgcolor=cyan><p>treehrt@hrt:~/mysqlc$ <span style="background-color: #ffff00;">openssl genrsa -out server.key 2048</span></p>
<p>treehrt@hrt:~/mysqlc$ <span style="background-color: #ffff00;">cat server.key </span><br />-----<span style="background-color: #ffff00;">BEGIN RSA PRIVATE KEY</span>-----<br />MIIEpAIBAAKCAQEAocpKIi6uVmkfOIWDcS3EQoB2eX8wQzU2pHK5PT5DptIIfk/c<br />TE9mP+Czx2rG7waU/ufSwKCppCqawA4RmSNezxLVPym8VuNdNfrxwzq3TM5Xn28L<br />4UkmT19uRhXC8+NrUblHvdcbg4P6PRUPLSwkUcev59v217Xp7jDIRP5mmL5K4xQS<br />X0CG7hb5sofgLxaWF5grw7W+PEhShY9o3E2/Ibo+I53S0Up2GxN3BXkpp3zWJ19o<br />CydqB4lIAQhKjDUz7Yee3Pen6+FHE6GMCwRMYci4mr/b8K30RlJUXWeTNOST1Ptq<br />0t/xTOOgwucjaGbcFoI8zp+0mzWdRxLh6gP2nQIDAQABAoIBAA1OY9Z33GLC9oxh<br />frP6PZ/yjMvlSATfBYV04gNFca7wqz4oN0gXZ6NtSZvnDkFuWyazzkOFcy5LSrrs<br />7UmY/R0uwVcWiaTjwjDEWMnjtFuexNoZ+fInX/07LgiZlZUVaSgpgtr8LAke+5+2<br />ca8XaE1JjRAWqTCIh5rNbEswWSPKsUPCO3rANsgUTgYGoKvTNA1TGsrZHu+cdkAz<br />2mT+8J3T5e0UZpB6lJjTbAtf4ZccGysXr7SB3MofMRGRXmbU9DCtLnmkhZebDTPh<br />Xt9mIfMQdk+ciAXAEooVHJ5EzMGZl8g+ZUK9jEhVvms72K70bDVo1LCjpgzVsIme<br />VQqKikECgYEA0iIjGug822D/+OnQ+Y9qcq+7LNKd8UaTPzexxoCaqhQGhEQ/o2C0<br />auddO8uXRp6e1VLKQIXLBiMSnyYWbTTkM5U1GIQuBk9lVacteuNO0PxKahhLeX+9<br />j6vKqrOmeAZCkzXAEXJECQvIjA9EsbWerl72lldPmb3wDHLZzrq/9/kCgYEAxRrT<br />jkNy7S0ArOQ7GEhJcuNL2DATcPlYd0w++KoZNza2rrZQ/54glYlkf3yRw4uvEIq7<br />97s9vdlyCyJzt+e7oJymiXE/dMUDvcym2e3P000PrBJrqau72W9TYnMROsuKeVzr<br />fEeu21dVFZrsosVAqqNDW4smXwtzGJqFs3zMRMUCgYArM72H8KtiZyT5ZgkC5gt6<br />nMqcwoiabGolmyu/pf0mbouQcf+rdVxihkLS4l6ttDrvnN/cOCWvk1JmygveU/t+<br />53RNIA/eWEB7Ra3CEC3KJbSe73PE/RBaE3XNdrYJAzB415ovfBCk03ld4l27M532<br />N6v26OiCsVxDEvHY4OhK8QKBgQChylJrTVwx6SXLxQ/o77Uyk/a2v0fGDTabvj9W<br />WDGYi9XKdabpG8A9XujaaMMxkyAhYO/H+q9Efg/Jqf74r0PpI4zj9sySqgFXM3ym<br />GDnmhTPfF8O+I1Rvt5zni/JRo6/HzQkTG7ghHX+e22twdJ+PMbJhm0fk7n4MbRJg<br />cYkuzQKBgQCY002bVTT0v/ND0zx5YCFo2OkN1pNw13+m2ar9omg6KHsmmIghsgUG<br />p8+4fnJus+0CYE/t+nuAD7JDfFcfYt53hqjCP2SgLMyAp5EVmW80v3l1E4ro8cqR<br />KX9lMTAwimMxF6ueY36g/k8/vKQuyG+uzsnBZtNAFmIGm1gGWjHBXA==<br />-----<span style="background-color: #ffff00;">END RSA PRIVATE KEY</span>-----<br />treehrt@hrt:~/mysqlc$</p>
<p>&nbsp;</p>
<p>treehrt@hrt:~/mysqlc$ o<span style="background-color: #ffff00;">penssl req -new -key server.key -out server.csr</span></p>
<p>&nbsp;</p>
<p>treehrt@hrt:~/mysqlc$ cat server.csr<br />-----<span style="background-color: #ffff00;">BEGIN CERTIFICATE REQUEST</span>-----<br />MIIC3TCCAcUCAQAwgZcxCzAJBgNVBAYTAlRXMRMwEQYDVQQIDApTb21lLVN0YXRl<br />MQ8wDQYDVQQHDAZLaW5tZW4xDTALBgNVBAoMBGttdnMxFDASBgNVBAsMC2luZm9y<br />bWF0aW9uMRswGQYDVQQDDBJ3d3cua212cy5rbS5lZHUudHcxIDAeBgkqhkiG9w0B<br />CQEWEXRyZWVocnRAZ21haWwuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB<br />CgKCAQEAocpKIi6uVmkfOIWDcS3EQoB2eX8wQzU2pHK5PT5DptIIfk/cTE9mP+Cz<br />x2rG7waU/ufSwKCppCqawA4RmSNezxLVPym8VuNdNfrxwzq3TM5Xn28L4UkmT19u<br />RhXC8+NrUblHvdcbg4P6PRUPLSwkUcev59v217Xp7jDIRP5mmL5K4xQSX0CG7hb5<br />sofgLxaWF5grw7W+PEhShY9o3E2/Ibo+I53S0Up2GxN3BXkpp3zWJ19oCydqB4lI<br />AQhKjDUz7Yee3Pen6+FHE6GMCwRMYci4mr/b8K30RlJUXWeTNOST1Ptq0t/xTOOg<br />wucjaGbcFoI8zp+0mzWdRxLh6gP2nQIDAQABoAAwDQYJKoZIhvcNAQELBQADggEB<br />ADD8jLMZHANsQvKtu9Pwq/9fF8+LAD0W8BXO956AAONfs49wtZNxU6iC05Ugcpm/<br />ZmwraZGo0eUp3k58mxENPsCJNNENh2m0suLV8l1WZ5MCF+ErSBbS5ipaxfeMETsM<br />CIpj+WbxdRiglsuaQ5yw6zDh3f3+SutFicFfKgksWq3NOliJNQiC5/HHsw+N6RGU<br />wAM1Gn5wcZPDmWgaYE9uJvJ0Ix37WMqhINnnogAJL6TR4kb4nY2+VlPYASZInLqd<br />dEtzOfTWNiTj0Nzj8NmfQloQY1NN6Zee9c2/7wOtgskzeFtyc6IdLLmJLDP7rGxt<br />KY3cD9NaaRt6guv+t8P2vmE=<br />-----<span style="background-color: #ffff00;">END CERTIFICATE REQUEST</span>-----<br />treehrt@hrt:~/mysqlc$</p>
<p>&nbsp;</p></table><br> select id,article_id,topic,text from lt_articles_text where article_id =415; ok.
update lt_articles set num_reads=num_reads +1 where id=415; ok.