erstmals Riesenlob an OPSI Team für so ein tolles Produkt.
Ich setze OPSI hauptsächlich für die Client Installation mit Win 7 x64 ein.
Auf dem Server läuft Debian Wheezy 7.x mit OPSI 404
Ich möchte für das Backend die MySql Datenbank einsetzen, soll für die HW/SW Inventarisierung kostenlos sein.
Problem 1:
Mir ist aufgefallen, dass opsiconfd und opsipxeconfd nach Hochfahren bzw. Neustarten des Servers, nicht automatisch gestartet werden.
Wenn ich die Dienste manuell starte, werden diese ordnungsgemäß gestartet.
Momentane dispatch.conf
Code: Alles auswählen
backend_.* : mysql, opsipxeconfd
host_.* : file, opsipxeconfd
productOnClient_.* : file, opsipxeconfd
configState_.* : file, opsipxeconfd
audit.* : mysql
.* : file
Code: Alles auswählen
S01opsipxeconfd -> ../init.d/opsipxeconfd
S16opsiconfd -> ../init.d/opsiconfd
S17mysql -> ../init.d/mysql
Ich habe bereits die symbolischen Links mit größeren Startnummern versehen, damit OPSI Dienste nach MySql starten, jedoch ohne Erfolg.
Sogar S99 hat keine Besserung gebracht.
Auszug aus der opsipxeconfd.log
Code: Alles auswählen
==================================================================
= opsi pxe configuration service starting =
==================================================================
(Logger.py|840)
[5] [Feb 13 20:25:49] Starting opsipxeconfd main thread (opsipxeconfd|163)
[2] [Feb 13 20:25:51] Traceback: (Logger.py|754)
[2] [Feb 13 20:25:51] line 160 in '_createConnectionPool' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 74 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 224 in 'connect' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 387 in '__init__' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 741 in '_do_get' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 188 in '_create_connection' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 270 in '__init__' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 330 in '__connect' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 72 in 'creator' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 81 in 'Connect' in file '/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 187 in '__init__' in file '/usr/lib/python2.7/dist-packages/MySQLdb/connections.py' (Logger.py|754)
[2] [Feb 13 20:25:51] ==>>> (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") (MySQL.py|163)
[2] [Feb 13 20:25:51] Traceback: (Logger.py|754)
[2] [Feb 13 20:25:51] line 165 in 'run' in file '/usr/bin/opsipxeconfd' (Logger.py|754)
[2] [Feb 13 20:25:51] line 112 in '_createBackendInstance' in file '/usr/bin/opsipxeconfd' (Logger.py|754)
[2] [Feb 13 20:25:51] line 209 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 314 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 364 in '__loadBackends' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 422 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 137 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] line 164 in '_createConnectionPool' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:51] ==>>> Backend I/O error: Failed to connect to database 'opsi' address 'localhost': (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") (opsipxeconfd|174)
Code: Alles auswählen
==================================================================
= opsi configuration service starting =
==================================================================
(Logger.py|840)
[5] [Feb 13 20:25:54] Starting opsiconfd main thread (opsiconfd.py|447)
[5] [Feb 13 20:25:54] Opening socket /var/run/opsiconfd/opsiconfd.socket for interprocess communication. (opsiconfd.py|424)
[2] [Feb 13 20:25:54] Traceback: (Logger.py|754)
[2] [Feb 13 20:25:54] line 160 in '_createConnectionPool' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 74 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 224 in 'connect' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 387 in '__init__' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 741 in '_do_get' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 188 in '_create_connection' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 270 in '__init__' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 330 in '__connect' in file '/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 72 in 'creator' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 81 in 'Connect' in file '/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 187 in '__init__' in file '/usr/lib/python2.7/dist-packages/MySQLdb/connections.py' (Logger.py|754)
[2] [Feb 13 20:25:54] ==>>> (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") (MySQL.py|163)
[2] [Feb 13 20:25:54] Traceback: (Logger.py|754)
[2] [Feb 13 20:25:54] line 453 in 'run' in file '/usr/lib/pymodules/python2.7/opsiconfd/opsiconfd.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 264 in '_createBackendInstance' in file '/usr/lib/pymodules/python2.7/opsiconfd/opsiconfd.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 209 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 314 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 364 in '__loadBackends' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/BackendManager.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 422 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 137 in '__init__' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] line 164 in '_createConnectionPool' in file '/usr/lib/pymodules/python2.7/OPSI/Backend/MySQL.py' (Logger.py|754)
[2] [Feb 13 20:25:54] ==>>> Backend I/O error: Failed to connect to database 'opsi' address 'localhost': (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") (opsiconfd.py|469)
[5] [Feb 13 20:25:54] Stopping opsiconfd main thread (opsiconfd.py|175)
[5] [Feb 13 20:25:54] Opsiconfd main thread exiting... (opsiconfd.py|472)
Problem 2:
Hab bei OPSI Einrichtung zusätzlich zur adminuser noch einen zweiten Benutzer (admin) erstellt und genau so wie adminuser eingerichtet.
Die Anmeldung an OPSI über PXE Boot von Client aus funktioniert mit admin nicht, mit adminuser ist alles bestens.
Genau so ist die Anmeldung an den Web Frontend auch nur mit adminuser möglich und mit admin schlägt die Anmeldung fehl.
Besten Dank