Hello community,
I want to automate the installation of ocsinventory with Ansible, using installation from RPMs on a single server CentOS 7_9.
So I've followed the doc over and over: http://wiki.ocsinventory-ng.org/03.Basic-documentation/Setting-up-a-OCS-Inventory-Server-with-rpm/
I have different concerns,
Step by step, what I do is :
1) Install packages
2) configure database
3) configure ocs
4) secure ocs
Step 1) & 2) are fine. Here are the packages that I have for OCS :
rpm -qa | grep ocs
ocsinventory-agent-2.6.0-2.1.el7.x86_64
ocsinventory-server-2.8.1-1.el7.ocs.noarch
ocsinventory-2.8.1-1.el7.ocs.noarch
ocsinventory-reports-2.8.1-1.el7.ocs.noarch
Problems starting at step 3), when I want to launch the install.php by requesting the url : http://my_server_name/ocsreports/install.php
I give it below infos :
- name: Install OCS database
ansible.builtin.uri:
url: "http://{{ target }}/ocsreports/install.php"
method: POST
body:
name: "{{ ocs_server_mysql_user }}"
password: "{{ ocs_server_mysql_root_password }}"
database: "{{ ocs_server_mysql_db }}"
host: "{{ ocs_server_mysql_bind_address }}"
port: "{{ ocs_server_mysql_port_listener }}"
The task is ok but nothing seems to happen on the server side.
TASK [ds-profile-ocs_server : Install OCS database] ****************************************************************************************************************************************************************************************
Thursday 06 May 2021 10:15:05 +0200 (0:00:04.690) 0:00:32.192 **********
ok:
Whereas when I do fil manually on the web page MySQL login, password, database, hostname, port... it's ok I can go to the next step.
I also tried different way mentioned in doc by doing a shell command :
- name: Launch db install using command line
ansible.builtin.shell: mysql -f -hlocalhost -uroot -p"{{ ocs_server_mysql_root_password }}" "{{ ocs_server_mysql_db }}" < "{{ ocs_server_ocs_reports_dir }}"/files/ocsbase.sql >log.log
This is working and create tables in database.
But when I go on URL : http://my_server_name/ocsreports/
I still have the formular page as for http://my_server_name/ocsreports/install.php
Whereas I should have login page ?
Even by restarting httpd.
Also, when doing the secure part, I observed that deleting the file install.php will result in an error 500 on the server.
How to avoid this when it is specifically said to remove this file ?
I would really appreciate some help and any feedback.
Additional Infos on important directories/files =>
ll /etc/httpd/conf
total 28
-rw-r--r-- 1 root root 11967 May 5 17:00 httpd.conf
-rw-r--r-- 1 root root 13064 Oct 9 2020 magic
ll /etc/httpd/conf.d/
total 56
-rw-r--r-- 1 root root 2926 Oct 9 2020 autoindex.conf
-rw-rw-r-- 1 root root 1008 Dec 8 2017 ocsinventory-lang-reports.conf
-rw-r--r-- 1 root root 4521 Apr 3 00:59 ocsinventory-reports.conf
-rw-r--r-- 1 root root 691 Apr 3 00:59 ocsinventory-restapi.conf
-rw-r--r-- 1 root root 14597 Apr 3 00:59 ocsinventory-server.conf
-rw-r--r-- 1 root root 1752 Nov 4 2019 perl.conf
-rw-r--r-- 1 root root 1252 Apr 27 16:40 php.conf
-rw-r--r-- 1 root root 366 Oct 9 2020 README
-rw-r--r-- 1 root root 1252 Oct 9 2020 userdir.conf
-rw-r--r-- 1 root root 516 Oct 9 2020 welcome.conf
ll /usr/share/ocsinventory-reports/ocsreports/
total 524
drwxrwxr-x 2 root apache 31 May 4 12:18 ajax
-rwxrwxr-x 1 root apache 1127 Sep 11 2020 ajax.php
drwxrwxr-x 6 root apache 67 May 4 12:18 backend
-rwxrwxr-x 1 root apache 27607 Sep 11 2020 Changes
-rwxrwxr-x 1 root apache 430 Sep 11 2020 composer.json
-rwxrwxr-x 1 root apache 6731 Sep 11 2020 composer.lock
-rwxrwxr-x 1 root apache 1027 Sep 11 2020 Contributors
drwxrwxr-x 2 root apache 46 May 4 12:18 crontab
drwxrwxr-x 2 root apache 270 May 4 12:18 css
-rw-rw---- 1 root apache 281 May 5 16:59 dbconfig.inc.php
-rwxrwxr-x 1 root apache 370070 Sep 11 2020 favicon.ico
drwxrwxr-x 4 root apache 88 May 4 12:18 files
-r-xr-xr-x 1 root apache 936 May 5 16:59 http_functions.php
-r-xr-xr-x 1 root apache 707 May 5 16:59 http_get.php
-r-xr-xr-x 1 root apache 1326 May 5 16:59 http_put.php
drwxrwxr-x 2 root apache 4096 May 4 12:18 image
-rwxrwxr-x 1 root apache 1697 Sep 11 2020 index.php
-rwxrwxr-x 1 root apache 13184 May 5 17:09 install.php
-rwxrwxr-x 1 root apache 20892 Sep 11 2020 ipdiscover-util.pl
drwxrwxr-x 2 root apache 274 May 4 12:18 js
drwxrwxr-x 9 root apache 135 May 4 12:18 libraries
-rwxrwxr-x 1 root apache 18046 Sep 11 2020 LICENSE
-rwxrwxr-x 1 root apache 4528 Sep 11 2020 README.md
drwxrwxr-x 26 root apache 4096 May 4 12:18 require
drwxrwxr-x 2 root apache 48 May 4 12:18 templates
drwxrwxr-x 3 root apache 17 May 4 12:18 themes
drwxrwxr-x 2 root apache 148 May 4 12:18 tools
-rwxrwxr-x 1 root apache 4829 Sep 11 2020 update.php
-rwxrwxr-x 1 root apache 5848 Apr 3 00:59 var.php
drwxrwxr-x 6 root apache 89 May 4 12:18 vendor
