Differences

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

--- userspace:centos_6.3 [2013/02/22 15:36]
ueluekmen [Iptables configuration]
+++ userspace:centos_6.3 [2021/08/23 08:37] (current)
@@ Line 264: / Line 264: @@
 \\
 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.**

OPSI DokuWiki

User Tools

Site Tools

Differences

Page Tools