Advertisement
Guest User

Untitled

a guest
May 22nd, 2016
744
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.34 KB | None | 0 0
  1. Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.
  2.  
  3. mysqli_query(): SSL operation failed with code 1. OpenSSL Error messages: error:0607A082:digital envelope routines:EVP_CIPHER_CTX_set_key_length:invalid key length error:0607A082:digital envelope routines:EVP_CIPHER_CTX_set_key_length:invalid key length
  4.  
  5. mysqli_query(): MySQL server has gone away
  6.  
  7. mysqli_query(): Error reading result set's header
  8.  
  9. expro_app@ubuntu-app:/etc/mysql$ mysql --ssl-ca=ca-cert.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem -h XX.XXX.X.103 -P 7306 -u admin_secure -p
  10. Enter password:
  11. Welcome to the MySQL monitor. Commands end with ; or g.
  12. Your MySQL connection id is 45
  13. Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu)
  14.  
  15. Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
  16.  
  17. Oracle is a registered trademark of Oracle Corporation and/or its
  18. affiliates. Other names may be trademarks of their respective
  19. owners.
  20.  
  21. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  22.  
  23. mysql> status;
  24. --------------
  25. mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3
  26.  
  27. Connection id: 45
  28. Current database:
  29. Current user: admin_secure@ubuntu-app
  30. SSL: Cipher in use is DHE-RSA-AES256-SHA
  31. Current pager: stdout
  32. Using outfile: ''
  33. Using delimiter: ;
  34. Server version: 5.5.49-0ubuntu0.14.04.1 (Ubuntu)
  35. Protocol version: 10
  36. Connection: XX.XXX.X.103 via TCP/IP
  37. Server characterset: latin1
  38. Db characterset: latin1
  39. Client characterset: utf8
  40. Conn. characterset: utf8
  41. TCP port: 7306
  42. Uptime: 2 days 8 hours 7 min 31 sec
  43.  
  44. Threads: 1 Questions: 126 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.000
  45.  
  46. /* Authentication type */
  47. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  48. /* Server parameters */
  49. $cfg['Servers'][$i]['host'] = 'XX.XXX.X.103';
  50. $cfg['Servers'][$i]['port'] = 'XXXX';
  51. $cfg['Servers'][$i]['connect_type'] = 'tcp';
  52. $cfg['Servers'][$i]['compress'] = false;
  53. $cfg['Servers'][$i]['AllowNoPassword'] = false;
  54. $cfg['Servers'][$i]['ssl']=true;
  55. $cfg['Servers'][$i]['ssl_key'] = '/etc/mysql/client-key.pem';
  56. $cfg['Servers'][$i]['ssl_cert'] = '/etc/mysql/client-cert.pem';
  57. $cfg['Servers'][$i]['ssl_ca'] = '/etc/mysql/ca-cert.pem';
  58. $cfg['Servers'][$i]['ssl_ciphers'] = 'DHE-RSA-AES256-SHA';
  59. $cfg['Servers'][$i]['ssl_verify'] = false;
  60.  
  61. if ($cfg['Server']['ssl']) {
  62. mysqli_ssl_set(
  63. $link,
  64. $cfg['Server']['ssl_key'],
  65. $cfg['Server']['ssl_cert'],
  66. $cfg['Server']['ssl_ca'],
  67. $cfg['Server']['ssl_ca_path'],
  68. $cfg['Server']['ssl_ciphers']
  69. );
  70. /*
  71. * disables SSL certificate validation on mysqlnd for MySQL 5.6 or later
  72. * @link https://bugs.php.net/bug.php?id=68344
  73. * @link https://github.com/phpmyadmin/phpmyadmin/pull/11838
  74. */
  75. if (! $cfg['Server']['ssl_verify']) {
  76. mysqli_options(
  77. $link,
  78. MYSQLI_OPT_SSL_VERIFY_SERVER_CERT,
  79. $cfg['Server']['ssl_verify']
  80. );
  81. $client_flags |= MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT;
  82. }
  83. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement