cluster with centos7

Discussion in 'Installation/Configuration' started by Arianna, May 8, 2019.

Page 1 of 2
  1. Arianna

    Arianna Member

    Hi everybody,

    using this guide https://www.howtoforge.com/tutorial...l-php-pureftpd-postfix-dovecot-and-ispconfig/ I installed 2 servers and than I enabled the cluster according to https://www.howtoforge.com/tutorial...abase-cluster-on-debian-8.4-with-ispconfig-3/

    When I try to connect to the master gui I have a white page and error_log says:
    [Tue May 07 16:52:31.176857 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Tue May 07 16:52:31.176915 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: Stack trace:
    [Tue May 07 16:52:31.176920 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Tue May 07 16:52:31.176924 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(380): app->initialize_session()
    [Tue May 07 16:52:31.176928 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Tue May 07 16:52:31.176931 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: #3 {main}
    [Tue May 07 16:52:31.176935 2019] [fcgid:warn] [pid 15631] [] mod_fcgid: stderr: thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166
    [Tue May 07 16:52:31.900611 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Tue May 07 16:52:31.900694 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: Stack trace:
    [Tue May 07 16:52:31.900702 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Tue May 07 16:52:31.900709 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(380): app->initialize_session()
    [Tue May 07 16:52:31.900715 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Tue May 07 16:52:31.900720 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: #3 {main}
    [Tue May 07 16:52:31.900726 2019] [fcgid:warn] [pid 15800] [] mod_fcgid: stderr: thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166

    Any problem with the php version or php mysql module?

    Thanks,
    A.
     
    Arianna, May 8, 2019
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which PHP version ado you use and are there any other errors before the ones above? To me, it looks as if the ISPConfig DB lib could not be loaded.
     
    till, May 8, 2019
    #2
  3. Arianna

    Arianna Member

    According to the guide:
    PHP 7.2.18 (cli) (built: Apr 30 2019 15:26:52) ( NTS )
    Copyright (c) 1997-2018 The PHP Group
    Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies

    No errors before that.

    php packages:
    Installed Packages
    php.x86_64 7.2.18-1.el7.remi @remi-php72
    php-bcmath.x86_64 7.2.18-1.el7.remi @remi-php72
    php-cli.x86_64 7.2.18-1.el7.remi @remi-php72
    php-common.x86_64 7.2.18-1.el7.remi @remi-php72
    php-devel.x86_64 7.2.18-1.el7.remi @remi-php72
    php-fedora-autoloader.noarch 1.0.0-1.el7 @epel
    php-fpm.x86_64 7.2.18-1.el7.remi @remi-php72
    php-gd.x86_64 7.2.18-1.el7.remi @remi-php72
    php-imap.x86_64 7.2.18-1.el7.remi @remi-php72
    php-intl.x86_64 7.2.18-1.el7.remi @remi-php72
    php-json.x86_64 7.2.18-1.el7.remi @remi-php72
    php-ldap.x86_64 7.2.18-1.el7.remi @remi-php72
    php-mbstring.x86_64 7.2.18-1.el7.remi @remi-php72
    php-mysqlnd.x86_64 7.2.18-1.el7.remi @remi-php72
    php-odbc.x86_64 7.2.18-1.el7.remi @remi-php72
    php-pdo.x86_64 7.2.18-1.el7.remi @remi-php72
    php-pdo-dblib.x86_64 7.2.18-1.el7.remi @remi-php72
    php-pear.noarch 1:1.10.9-2.el7.remi @remi-php72
    php-pecl-apcu.x86_64 5.1.17-1.el7.remi.7.2 @remi-php72
    php-pecl-apcu-bc.x86_64 1.0.5-1.el7.remi.7.2 @remi-php72
    php-pecl-imagick.x86_64 3.4.4-1.el7.remi.7.2 @remi-php72
    php-pecl-mcrypt.x86_64 1.0.2-2.el7.remi.7.2 @remi-php72
    php-pecl-zip.x86_64 1.15.4-1.el7.remi.7.2 @remi-php72
    php-php-gettext.noarch 1.0.12-1.el7 @epel
    php-process.x86_64 7.2.18-1.el7.remi @remi-php72
    php-pspell.x86_64 7.2.18-1.el7.remi @remi-php72
    php-snmp.x86_64 7.2.18-1.el7.remi @remi-php72
    php-soap.x86_64 7.2.18-1.el7.remi @remi-php72
    php-tcpdf.noarch 6.2.26-1.el7 @epel
    php-tcpdf-dejavu-sans-fonts.noarch 6.2.26-1.el7 @epel
    php-tidy.x86_64 7.2.18-1.el7.remi @remi-php72
    php-xml.x86_64 7.2.18-1.el7.remi @remi-php72
    php-xmlrpc.x86_64 7.2.18-1.el7.remi @remi-php72
    phpMyAdmin.noarch 4.4.15.10-3.el7 @epel

    [PHP Modules]
    apc
    apcu
    bcmath
    bz2
    calendar
    Core
    ctype
    curl
    date
    dom
    exif
    fileinfo
    filter
    ftp
    gd
    gettext
    hash
    iconv
    imagick
    imap
    intl
    json
    ldap
    libxml
    mbstring
    mcrypt
    mysqli
    mysqlnd
    odbc
    openssl
    pcntl
    pcre
    PDO
    pdo_dblib
    pdo_mysql
    PDO_ODBC
    pdo_sqlite
    Phar
    posix
    pspell
    readline
    Reflection
    session
    shmop
    SimpleXML
    snmp
    soap
    sockets
    SPL
    sqlite3
    standard
    sysvmsg
    sysvsem
    sysvshm
    tidy
    tokenizer
    wddx
    xml
    xmlreader
    xmlrpc
    xmlwriter
    xsl
    zip
    zlib

    [Zend Modules]
     
    Arianna, May 8, 2019
    #3
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Is that PHP version the default that comes with Centos 7? ISPConfig is only supported on the PHP version that comes with the operating system. If you added some other PHP, it may well break ISPConfig.
    Additional PHP version can be used for websites, ISPConfig has mechanism for that.
    On Ubuntu and Debian I know how to set the default PHP back to the original that came with operaring system, but I have newer used CentOS.
     
    Taleman, May 8, 2019
    #4
  5. Arianna

    Arianna Member

    No. It isn't.
    I already have a server with centos 7.4 and php 7.0 and it works fine.
    This is centos 7.6 and php 7.2. As I said, I followed the guide written by Till.
     
    Arianna, May 8, 2019
    #5
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    For CentOS, it is ok to use a different PHP version as the new version uses the exact same paths than the older versions.

    Did you change anything in php.ini, especially regarding include path or did you set a global open_basedir or something similar?
     
    till, May 8, 2019
    #6
  7. Arianna

    Arianna Member

    As mentioned at the guide point 12, I uncommented cgi.fix_pathinfo=1.
     
    Arianna, May 8, 2019
    #7
  8. Arianna

    Arianna Member

    I tryed to comment it again, restarted php-fpm and httpd, but nothing changed.
     
    Arianna, May 8, 2019
    #8
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    That's ok as mentioned in the tutorial. But you did not do any other changes in php.ini? Are there other errors in the global apache error.log when you access ISPConfig?
     
    till, May 8, 2019
    #9
  10. Arianna

    Arianna Member

    no, nothing. I noticed that the package installed is php-mysqldn and not php-mysql: don't know why. May be this the problem?
     
    Arianna, May 9, 2019
    #10
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    I don't think that you have a problem with the PHP MySQL driver. the problem is that the ISPConfig mysql class seems not to be loaded. Try to do an ispconfig update with ispconfig_update.sh command and choose git-stable as update source, just to ensure that no files are missing on your server.
     
    till, May 9, 2019
    #11
  12. Arianna

    Arianna Member

    :'( nothing changed.

    I will try the microsoft way: reinstall everything.

    [Thu May 09 10:01:23.959984 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Thu May 09 10:01:23.960073 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: Stack trace:
    [Thu May 09 10:01:23.960083 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Thu May 09 10:01:23.960091 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(380): app->initialize_session()
    [Thu May 09 10:01:23.960099 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Thu May 09 10:01:23.960124 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: #3 {main}
    [Thu May 09 10:01:23.960133 2019] [fcgid:warn] [pid 27134] [] mod_fcgid: stderr: thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166
     
    Arianna, May 9, 2019
    #12
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Before you reinstall, please add a info.php file with:

    <?php
    phpinfo();

    inside in /usr/local/ispconfig/interface/web/

    and post the result.
     
    till, May 9, 2019
    #13
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    phpinfo must show that the installed php has mysqli support.
     
    till, May 9, 2019
    #14
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    And the tutorial that you followed installed all required PHP modules on page 2, maybe you left something out from the guide?

    Code:
    yum -y install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-pecl-apc php-mbstring php-mcrypt php-mssql php-snmp php-soap php-tidy curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel mod_fcgid php-cli httpd-devel php-fpm php-intl php-imagick php-pspell wget
     
    till, May 9, 2019
    #15
  16. Arianna

    Arianna Member

    Here I am.

    mysqli
    MysqlI Support enabled
    Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
    Active Persistent Links 0
    Inactive Persistent Links 0
    Active Links 0
    Directive Local Value Master Value
    mysqli.allow_local_infile Off Off
    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 /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
    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.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
    Compression supported
    core SSL supported
    extended SSL supported
    Command buffer size 4096
    Read buffer size 32768
    Read timeout 86400
    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 mysqli,pdo_mysql
    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_estrdup_count 0
    mem_strdup_count 0
    mem_edupl_count 0
    mem_dupl_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



    And:
    yum install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-pecl-apc php-mbstring php-mcrypt php-mssql php-snmp php-soap php-tidy curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel mod_fcgid php-cli httpd-devel php-fpm php-intl php-imagick php-pspell wget
    [...]
    Nothing to do
     
    Arianna, May 9, 2019
    #16
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    Are you able to log into the ispconfig database with the hostname, username and password from /usr/local/ispconfig/interface/lib/config.inc.php by using the mysql command?

    mysql -h localhost -u ispconfig -p dbispconfig
     
    till, May 9, 2019
    #17
  18. Arianna

    Arianna Member

    no, I can't.
    In /usr/local/ispconfig/interface/lib/config.inc.php there are two passwords: $conf['db_password'] and $conf['dbmaster_password']. No one works.
    I tried to change the ispconfig user password in the db using the PASSWORD function but things didn't change.
     
    Arianna, May 9, 2019
    #18
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then your problem has most likely to do with the changes you made for the mysql cluster and the function not found error is just the result of the login error.
     
    till, May 9, 2019
    #19
  20. Arianna

    Arianna Member

    Via phpmyadmin I can log into the db but I don't see the dbispconfig db.
    Privilegies are:
    Host Type Privileges Grant Action
    root 127.0.0.1 global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root 192.168.69.42 global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root 192.168.79.42 global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root ::1 global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root localhost global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root webusers-isp-slave.srvsi-mgmt.unimi.it global ALL PRIVILEGES Yes [​IMG] Edit Privileges
    root webusers-isp-slave.srvsi.unimi.it global ALL PRIVILEGES Yes [​IMG] Edit Privileges

    ispconfig user hasn't acess to the db
     
    Arianna, May 9, 2019
    #20
Page 1 of 2

Share This Page