Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Setup - keine Verbindung zu MariaDB

    Scheduled Pinned Locked Moved Betrieb
    2 Posts 1 Posters 2.5k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J Offline
      joe-eis
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • J Offline
        joe-eis
        last edited by

        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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post