Setup - keine Verbindung zu MariaDB



  • Hallo Leute,

    zur Info: das Web-Setup geht bei mir nicht.
    Macht aber nichts, siehe letzte Zeile.


    Ich möchte I-do it (open) 1.4 auf CentOS 7 installieren…

    Step 1: System check
    Operating System
      Type: Linux OK
      Version: 3.10.0-123.el7.x86_64 #1 SMP Mon Jun 30 12:09:22 UTC 2014 OK
    Webserver
      Version: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.4.16 mod_perl/2.0.9-dev Perl/v5.16.3 OK
      PHP Version: 5.4.16 OK
      PHP Session Extension: Active OK
      PHP MySQL Extension: Active OK
      PHP XML Extension: Active OK
      PHP ZLIB Extension: Active OK
      PHP GD Extension: Active OK
      PHP SimpleXML Extension: Active OK
      PHP Setting "magic_quotes_gpc": Off OK
      PHP cURL Extension: Active - Needed for external web-services OK
      PHP PDO_MySQL Extension: Active OK
      PHP Mcrypt Extension: Active - Needed for encrypting/decrypting OK
    Database Access Interface (PHP MySQL Extension)
      Version: 5.5.37-MariaDB OK

    … und bekomme aber keine Verbindung zur Datenbank über das Web-Frontend: Database port: 3306  ERROR (111)

    Step 5: Configuration check
    Testing configuration …
    i-doit Directory: /var/www/html/i-doit/ OK
    Username: admin
    Password: *****
    Save path for file manager: /var/www/html/i-doit/upload/files/ FOUND
    Image path: /var/www/html/i-doit/upload/images/ FOUND
    Database host: localhost HOST FOUND
    Database port: 3306 ERROR (111)
    Database username: idoit OK
    Database password: ***** OK
    Database root username: root OK
    Database root password: ***** FAILED
    System Database Name: idoit NO LINK
    Database Config: n/a NO LINK
    Database mode: n/a NO LINK
    Mandator database name: idoit_data NO LINK
    Mandator Title: Firma OK
    Auto-Increment start value: 1 OK
    Configuration path: /var/www/html/i-doit/src WRITEABLE
    6 errors occured. Please fix the configuration in order to continue!

    Note: If some directories are not writeable, chown them to your Apache user or use the script "/var/www/html/i-doit/idoit-rights.sh" on unix systems!

    Auf dem MySQL-Server hatte sich nichts geändert:

    /var/www/html/i-doit]# mysql -h localhost -u root -p
    Enter password:
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 1015
    Server version: 5.5.37-MariaDB MariaDB Server

    Copyright © 2000, 2014, Oracle, Monty Program Ab and others.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    MariaDB [(none)]> select user from mysql.user;
    +–----+
    | user |
    +------+
    | root |
    | root |
    | root |
    +------+
    3 rows in set (0.00 sec)

    MariaDB [(none)]> show databases;
    +–------------------+
    | Database          |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    +--------------------+
    3 rows in set (0.01 sec)

    Die /var/log/httpd/error.log schweigt dazu. php-safe_mode = Off

    Über folgende Module kann der Apachen verfügen:

    ]# apachectl -t -D DUMP_MODULES
    Passing arguments to httpd using apachectl is no longer supported.
    You can only start/stop/restart httpd using this script.
    If you want to pass extra arguments to httpd, edit the
    /etc/sysconfig/httpd config file.
    Loaded Modules:
    core_module (static)
    so_module (static)
    http_module (static)
    access_compat_module (shared)
    actions_module (shared)
    alias_module (shared)
    allowmethods_module (shared)
    auth_basic_module (shared)
    auth_digest_module (shared)
    authn_anon_module (shared)
    authn_core_module (shared)
    authn_dbd_module (shared)
    authn_dbm_module (shared)
    authn_file_module (shared)
    authn_socache_module (shared)
    authz_core_module (shared)
    authz_dbd_module (shared)
    authz_dbm_module (shared)
    authz_groupfile_module (shared)
    authz_host_module (shared)
    authz_owner_module (shared)
    authz_user_module (shared)
    autoindex_module (shared)
    cache_module (shared)
    cache_disk_module (shared)
    data_module (shared)
    dbd_module (shared)
    deflate_module (shared)
    dir_module (shared)
    dumpio_module (shared)
    echo_module (shared)
    env_module (shared)
    expires_module (shared)
    ext_filter_module (shared)
    filter_module (shared)
    headers_module (shared)
    include_module (shared)
    info_module (shared)
    log_config_module (shared)
    logio_module (shared)
    mime_magic_module (shared)
    mime_module (shared)
    perl_module (shared)
    negotiation_module (shared)
    remoteip_module (shared)
    reqtimeout_module (shared)
    rewrite_module (shared)
    setenvif_module (shared)
    slotmem_plain_module (shared)
    slotmem_shm_module (shared)
    socache_dbm_module (shared)
    socache_memcache_module (shared)
    socache_shmcb_module (shared)
    status_module (shared)
    substitute_module (shared)
    suexec_module (shared)
    unique_id_module (shared)
    unixd_module (shared)
    userdir_module (shared)
    version_module (shared)
    vhost_alias_module (shared)
    dav_module (shared)
    dav_fs_module (shared)
    dav_lock_module (shared)
    lua_module (shared)
    mpm_prefork_module (shared)
    proxy_module (shared)
    lbmethod_bybusyness_module (shared)
    lbmethod_byrequests_module (shared)
    lbmethod_bytraffic_module (shared)
    lbmethod_heartbeat_module (shared)
    proxy_ajp_module (shared)
    proxy_balancer_module (shared)
    proxy_connect_module (shared)
    proxy_express_module (shared)
    proxy_fcgi_module (shared)
    proxy_fdpass_module (shared)
    proxy_ftp_module (shared)
    proxy_http_module (shared)
    proxy_scgi_module (shared)
    ssl_module (shared)
    systemd_module (shared)
    cgi_module (shared)
    php5_module (shared)

    Auf dem Rechner läuft ocsinventory und phpMyAdmin, auch per Konsole komme ich mit MySQL (MariaDB) zurecht.
    Das i-doit-right.sh set-Skript wurde ausgeführt

    OK, warum nicht gleich so?:
    Unter dem  Verzeichnis /var/www/html/i-doit/setup liegt ein install.sh, damit hat es funktionert.

    VG Jörn

    PS Der Bild-Code Zumutung



  • Ich habe nun das System "aufgefrischt", andere PHP- und MySQL-Programme,
    incl. deren Konfigurationsdateien unter httpd und mysql, entfernt und MariaDB neu installiert.

    Mit der Installtion von i-doit habe ich nun eine Datei i-doit.conf in die /etc/httpd/conf.d/ mit dem Inhalt

    
     <directory var="" www="" html="" i-doit="">AddHandler php-script .php
      Action php-script /cgi-bin/php5
      Options ExecCGI Indexes FollowSymLinks MultiViews
      AllowOverride AuthConfig
      Order allow,deny
      allow from all</directory> 
    
    

    angelegt.

    Anschliessend ist das Web-Frondend-Setup erfolgreich durchgelaufen.

    VG Jörn


 


Datenschutz / Privacy Policy