Php 5.6 Error Unable to connect to MySQL

Discussion in 'HOWTO-Related Questions' started by scorpious, Aug 2, 2018.

  1. scorpious

    scorpious Member

    Hi All

    I followed the How to install PHP 7.1, 7.2 and 5.6 as PHP-FPM & FastCGI for ISPConfig 3 on Debian 9

    When I set the Php version to 5.6 I get the follow errors

    Php 5.6 fast-cgi Unable to connect to MySQL
    Php 5.6 PHP-FPM ERROR 503 - Service Unavailable!

    When I set the Php version to Php 7.1 or Php 7.2 the both are working and I can connect to the Mysql Server

    When I view PHP settings using phpinfo()
    I see PHP Version 5.6.33

    When I test Php with
    <?php
    echo "Hello World!";
    ?>
    It works ok

    What could be causing this?

    Cheers
    Scorp
     
  2. scorpious

    scorpious Member

    Hi
    Any tips for the above problem ?
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Check you have installed php mysql module also for PHP 5.6.
     
  4. scorpious

    scorpious Member

    Hi Taleman
    Which is the best way to check to see if I have installed php mysql module also for PHP 5.6.
    When I view the phpinfo this is what I get
    Php 5.6
    Configuration File (php.ini) Path /opt/php-5.6/lib
    Loaded Configuration File /opt/php-5.6/lib/php.ini
    Scan this dir for additional .ini files (none)

    PHP Version 7.0.30
    Configuration File (php.ini) Path /etc/php/7.0/cgi
    Loaded Configuration File /etc/php/7.0/cgi/php.ini
    Scan this dir for additional .ini files /etc/php/7.0/cgi/conf.d
    Below is the info from the phpinfo
    mysqli
    MysqlI Support enabled
    Client API library version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
    Active Persistent Links 0
    Inactive Persistent Links 0
    Active Links 0

    Directive Local Value Master Value
    mysqli.allow_local_infile On On
    mysqli.allow_persistent On On
    mysqli.default_host no value no value
    mysqli.default_port 3306 3306
    mysqli.default_pw no value no value
    mysqli.default_socket no value no value
    mysqli.default_user no value no value
    mysqli.max_links Unlimited Unlimited
    mysqli.max_persistent Unlimited Unlimited
    mysqli.reconnect Off Off
    mysqli.rollback_on_cached_plink Off Off

    Cheers
    Scorp
     
    Last edited: Aug 9, 2018
  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Find out what the Debian package name is. I think it is php5.6-mysql. Then do
    Code:
    apt-cache policy php5.6-mysql
     
  6. scorpious

    scorpious Member

    Hi Taleman
    this is what I see when I run the command
    apt-cache policy php5.6-mysql
    N: Unable to locate package php5.6-mysql
    N: Couldn't find any package by glob 'php5.6-mysql'
    N: Couldn't find any package by regex 'php5.6-mysql'

    Cheers
    Scorp
     
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    That is strange. On my Debian 9.5 Stretch it returns:
    Show what this command returns on your setup:
     
  8. scorpious

    scorpious Member

    Hi Taleman
    lsb_release -a
    No LSB modules are available.
    Distributor ID: Debian
    Description: Debian GNU/Linux 9.5 (stretch)
    Release: 9.5
    Codename: stretch

    When I change the php to 7.1 or 7.2 or even leave it at the Default everything is working ok, its only when I want to use Php 5.6 I get the connection error
    Cheers
    Scorp
     
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  10. scorpious

    scorpious Member

    Hi Taleman
    Cheers for the advise i will look at the other way

    Scorp
     
  11. Gruppo Pegaso

    Gruppo Pegaso New Member

    Same problem here. I followed your guide step by step.
    How to workaround? I need to restart from scratch the system installation?

    I noticed also a little error under point 3 of installing php 7.1:
    you wrote:
    cp /usr/local/src/php7.1-build/php-7.1/php.ini-production /opt/php-7.1/lib/php.ini

    correct:
    cp /usr/local/src/php7.1-build/php-7.1.14/php.ini-production /opt/php-7.1/lib/php.ini

    Thank you, your guides are all very useful.
     
  12. Gruppo Pegaso

    Gruppo Pegaso New Member

    I reinstalled Debian 9 from scratch. The only part i've changed is about php 5.6. I first installed the sury.org repository. And all seems to work.
    But i put a test.php with phpinfo inside.

    Using PHP 5.6 FPM i got a 503 error

    Using PHP 5.6 FAST CGI all seems to work (as seen on phpinfo):

    mysqli
    MysqlI Support enabled
    Client API library version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
    Active Persistent Links 0
    Inactive Persistent Links 0
    Active Links 0
    Directive Local Value Master Value
    mysqli.allow_local_infile On On
    mysqli.allow_persistent On On
    mysqli.default_host no value no value
    mysqli.default_port 3306 3306
    mysqli.default_pw no value no value
    mysqli.default_socket no value no value
    mysqli.default_user no value no value
    mysqli.max_links Unlimited Unlimited
    mysqli.max_persistent Unlimited Unlimited
    mysqli.reconnect Off Off
    mysqli.rollback_on_cached_plink Off Off
    mysqlnd
    mysqlnd enabled
    Version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
    Compression supported
    core SSL supported
    extended SSL supported
    Command buffer size 4096
    Read buffer size 32768
    Read timeout 31536000
    Collecting statistics Yes
    Collecting memory statistics No
    Tracing n/a
    Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
    API Extensions pdo_mysql,mysqli
    mysqlnd statistics
    bytes_sent 0
    bytes_received 0
    packets_sent 0
    packets_received 0
    protocol_overhead_in 0
    protocol_overhead_out 0
    bytes_received_ok_packet 0
    bytes_received_eof_packet 0
    bytes_received_rset_header_packet 0
    bytes_received_rset_field_meta_packet 0
    bytes_received_rset_row_packet 0
    bytes_received_prepare_response_packet 0
    bytes_received_change_user_packet 0
    packets_sent_command 0
    packets_received_ok 0
    packets_received_eof 0
    packets_received_rset_header 0
    packets_received_rset_field_meta 0
    packets_received_rset_row 0
    packets_received_prepare_response 0
    packets_received_change_user 0
    result_set_queries 0
    non_result_set_queries 0
    no_index_used 0
    bad_index_used 0
    slow_queries 0
    buffered_sets 0
    unbuffered_sets 0
    ps_buffered_sets 0
    ps_unbuffered_sets 0
    flushed_normal_sets 0
    flushed_ps_sets 0
    ps_prepared_never_executed 0
    ps_prepared_once_executed 0
    rows_fetched_from_server_normal 0
    rows_fetched_from_server_ps 0
    rows_buffered_from_client_normal 0
    rows_buffered_from_client_ps 0
    rows_fetched_from_client_normal_buffered 0
    rows_fetched_from_client_normal_unbuffered 0
    rows_fetched_from_client_ps_buffered 0
    rows_fetched_from_client_ps_unbuffered 0
    rows_fetched_from_client_ps_cursor 0
    rows_affected_normal 0
    rows_affected_ps 0
    rows_skipped_normal 0
    rows_skipped_ps 0
    copy_on_write_saved 0
    copy_on_write_performed 0
    command_buffer_too_small 0
    connect_success 0
    connect_failure 0
    connection_reused 0
    reconnect 0
    pconnect_success 0
    active_connections 0
    active_persistent_connections 0
    explicit_close 0
    implicit_close 0
    disconnect_close 0
    in_middle_of_command_close 0
    explicit_free_result 0
    implicit_free_result 0
    explicit_stmt_close 0
    implicit_stmt_close 0
    mem_emalloc_count 0
    mem_emalloc_amount 0
    mem_ecalloc_count 0
    mem_ecalloc_amount 0
    mem_erealloc_count 0
    mem_erealloc_amount 0
    mem_efree_count 0
    mem_efree_amount 0
    mem_malloc_count 0
    mem_malloc_amount 0
    mem_calloc_count 0
    mem_calloc_amount 0
    mem_realloc_count 0
    mem_realloc_amount 0
    mem_free_count 0
    mem_free_amount 0
    mem_estrndup_count 0
    mem_strndup_count 0
    mem_estndup_count 0
    mem_strdup_count 0
    proto_text_fetched_null 0
    proto_text_fetched_bit 0
    proto_text_fetched_tinyint 0
    proto_text_fetched_short 0
    proto_text_fetched_int24 0
    proto_text_fetched_int 0
    proto_text_fetched_bigint 0
    proto_text_fetched_decimal 0
    proto_text_fetched_float 0
    proto_text_fetched_double 0
    proto_text_fetched_date 0
    proto_text_fetched_year 0
    proto_text_fetched_time 0
    proto_text_fetched_datetime 0
    proto_text_fetched_timestamp 0
    proto_text_fetched_string 0
    proto_text_fetched_blob 0
    proto_text_fetched_enum 0
    proto_text_fetched_set 0
    proto_text_fetched_geometry 0
    proto_text_fetched_other 0
    proto_binary_fetched_null 0
    proto_binary_fetched_bit 0
    proto_binary_fetched_tinyint 0
    proto_binary_fetched_short 0
    proto_binary_fetched_int24 0
    proto_binary_fetched_int 0
    proto_binary_fetched_bigint 0
    proto_binary_fetched_decimal 0
    proto_binary_fetched_float 0
    proto_binary_fetched_double 0
    proto_binary_fetched_date 0
    proto_binary_fetched_year 0
    proto_binary_fetched_time 0
    proto_binary_fetched_datetime 0
    proto_binary_fetched_timestamp 0
    proto_binary_fetched_string 0
    proto_binary_fetched_json 0
    proto_binary_fetched_blob 0
    proto_binary_fetched_enum 0
    proto_binary_fetched_set 0
    proto_binary_fetched_geometry 0
    proto_binary_fetched_other 0
    init_command_executed_count 0
    init_command_failed_count 0
    com_quit 0
    com_init_db 0
    com_query 0
    com_field_list 0
    com_create_db 0
    com_drop_db 0
    com_refresh 0
    com_shutdown 0
    com_statistics 0
    com_process_info 0
    com_connect 0
    com_process_kill 0
    com_debug 0
    com_ping 0
    com_time 0
    com_delayed_insert 0
    com_change_user 0
    com_binlog_dump 0
    com_table_dump 0
    com_connect_out 0
    com_register_slave 0
    com_stmt_prepare 0
    com_stmt_execute 0
    com_stmt_send_long_data 0
    com_stmt_close 0
    com_stmt_reset 0
    com_stmt_set_option 0
    com_stmt_fetch 0
    com_deamon 0
    bytes_received_real_data_normal 0
    bytes_received_real_data_ps 0
     
  13. Gruppo Pegaso

    Gruppo Pegaso New Member

    As a note i'm using mariadb.
     
  14. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You wrote
    but what is the problem?
    If you do have the exact same problem, do the same answers help to fix it?
     
  15. Gruppo Pegaso

    Gruppo Pegaso New Member

    Using sury.org yes. But after the first installation (without sury) i got problem.
    Putting sury.org first it seems to work only FAST-CGI and not FPM.
     

Share This Page