Differences

This shows you the differences between two versions of the page.

--- userspace:centos_6.3 [2013/02/09 01:14] – added external screenshot SisterOfMercy
+++ userspace:centos_6.3 [2021/08/23 10:37] (current) – external edit 127.0.0.1
@@ Line 55: / Line 55: @@
 ===== Iptables configuration =====
-To make OPSI work correctly we have to open some ports on the firewall. I can never remember the iptables commands, and with Spacewalk I deployed the following to: /etc/sysconfig/network/iptables:\\
+To make OPSI work correctly we have to open some ports on the firewall. I can never remember the iptables commands, and with Spacewalk I deployed the following to: /etc/sysconfig/network/iptables:
+//(In my case, after clean installation of Centos 6.3 the path of the file is not the same. On my machine the file is located at: /etc/sysconf/iptables)//\\
 <code winst>
 # Firewall configuration written by system-config-firewall
@@ Line 259: / Line 261: @@
 If I have transcribed my notes correctly you now have a working OPSI server!\\
-If not, it isn't my fault! ;-)
+If not, it isn't my fault! ;-)\\
+\\
+I was talking with the nice people at uib.de, and it seems the mysql backend can be used for hardware and software audit purposes, without a license. When I find the time I will expand this entry to include the mysql configuration.
+==== Change to mysql for inventory ====
+That's right and we recommend to use the mysql-Database for inventory-functions. To change from file-backend to mysql for the inventory data, you must at first install the mysql-server. If you don't have done before, you can use the following commands:
+<code bash>
+yum install mysql-server
+/etc/init.d/mysqld start
+mysql_secure_installation
+chkconfig mysqld on
+</code>
+No you can run opsi-setup to configure your mysql-database (create a opsi database, create opsi user, set privileges and patch backend-configuration file from opsi.) For the next step you need the root password, that you have set with the command: mysql_secure_installation:
+<code bash>
+opsi-setup --configure-mysql
+</code>
+Now you must configure the opsi-Dispatcher to use mysql for Hard- and Software Inventory (You should set the licensemanagement to mysql-server too. If you don't use opsi-licensemanagement, this entries doing nothing. For this modification edit the file:
+<file>
+/etc/opsi/backendManager/dispatch.conf
+</file>
+The important entries are the following:
+backend_.*         : file, **mysql**, opsipxeconfd\\
+...\\
+license.*          : **mysql**\\
+softwareLicense.*  : **mysql**\\
+audit.*            : **mysql**\\
+...\\
+After a new init-current-config and a webservice-restart your Inventory-data should be written in mysql:
+<code bash>
+opsi-setup --init-current-config
+/etc/init.d/opsiconfd restart
+/etc/init.d/opsipxeconfd restart
+</code>
+**Finally your right, to use mysql for the Inventorydata, you don't need a valid license.**