Guest User

Untitled

a guest
Apr 3rd, 2018
583
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.64 KB | None | 0 0
  1. mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper
  2.  
  3. Connection id: 9
  4. Current database:
  5. Current user: test@db.test.com
  6. SSL: Cipher in use is DHE-RSA-AES256-SHA
  7. Current pager: stdout
  8. Using outfile: ''
  9. Using delimiter: ;
  10. Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)
  11. Protocol version: 10
  12. Connection: 0.0.0.0 via TCP/IP
  13. Server characterset: utf8mb4
  14. Db characterset: utf8mb4
  15. Client characterset: utf8mb4
  16. Conn. characterset: utf8mb4
  17. TCP port: 3306
  18. Uptime: 3 days 4 hours 53 min 35 sec
  19.  
  20. Threads: 1 Questions: 17 Slow queries: 0 Opens: 107 Flush tables: 1 Open tables: 26 Queries per second avg: 0.000
  21.  
  22. +---------------+-----------------+
  23. | Variable_name | Value |
  24. +---------------+-----------------+
  25. | have_openssl | YES |
  26. | have_ssl | YES |
  27. | ssl_ca | ca.pem |
  28. | ssl_capath | |
  29. | ssl_cert | server-cert.pem |
  30. | ssl_cipher | |
  31. | ssl_crl | |
  32. | ssl_crlpath | |
  33. | ssl_key | server-key.pem |
  34. +---------------+-----------------+
  35.  
  36. +-------------------------------------------------------------+
  37. | Grants for test@0.0.0.0 |
  38. +-------------------------------------------------------------+
  39. | GRANT USAGE ON *.* TO 'test'@'0.0.0.0' |
  40. | GRANT SELECT ON `testDB`.* TO 'test'@'0.0.0.0' |
  41. +-------------------------------------------------------------+
  42.  
  43. +--------------------------+------------------------+
  44. | Variable_name | Value |
  45. +--------------------------+------------------------+
  46. | character_set_client | utf8mb4 |
  47. | character_set_connection | utf8mb4 |
  48. | character_set_database | utf8mb4 |
  49. | character_set_filesystem | binary |
  50. | character_set_results | utf8mb4 |
  51. | character_set_server | utf8mb4 |
  52. | character_set_system | utf8 |
  53. | collation_connection | utf8mb4_unicode_520_ci |
  54. | collation_database | utf8mb4_unicode_520_ci |
  55. | collation_server | utf8mb4_unicode_520_ci |
  56. +--------------------------+------------------------+
  57.  
  58. +------------------+-------------+-----------------------+----------+
  59. | user | host | plugin | ssl_type |
  60. +------------------+-------------+-----------------------+----------+
  61. | test | 0.0.0.0 | sha256_password | X509 |
  62. +------------------+-------------+-----------------------+----------+
  63.  
  64. apache@web:~$ ls -al /etc/mysql-client
  65. total 20
  66. drwxr-xr-x 2 root root 4096 Mar 24 02:30 .
  67. drwxr-xr-x 99 root root 4096 Mar 30 20:04 ..
  68. -r-xr-xr-x 1 root root 1107 Mar 24 02:30 ca.pem
  69. -r-xr-xr-x 1 root root 1107 Mar 24 02:30 client-cert.pem
  70. -r-xr-xr-x 1 root root 1679 Mar 24 02:30 client-key.pem
  71.  
  72. $dsn = 'mysql:host=db.test.com;port=3306;dbname=testDB;charset=utf8mb4';
  73. $dbuser = 'test';
  74. $dbpass = 'sha256-hash';
  75.  
  76. $dboptions = array (
  77. PDO::MYSQL_ATTR_SSL_KEY =>'/etc/mysql-client/client-key.pem',
  78. PDO::MYSQL_ATTR_SSL_CERT =>'/etc/mysql-client/client-cert.pem',
  79. PDO::MYSQL_ATTR_SSL_CA =>'/etc/mysql-client/ca.pem',
  80. PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
  81. );
  82.  
  83. try {
  84. $conn = new PDO($dsn,$dbuser,$dbpass,$dboptions);
  85. if($conn){
  86. echo "Connection established";
  87. }
  88. } catch (PDOException $e) {
  89. echo 'Connection failed: ' . $e->getMessage();
  90. }
  91.  
  92. Connection to 0.0.0.0 3306 port [tcp/mysql] succeeded!
  93.  
  94. apache@web:~$ php -f test.php
  95. Connection failed: SQLSTATE[HY000] [2002]
Add Comment
Please, Sign In to add comment