Setup - keine Verbindung zu MariaDB

joe-eis

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

joe-eis

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