swaudit time consuming and heavy load on opsi server

[inszekt_]

unfortunately the hw inventory still does not work despite the modified dispatch.conf:

backend_.* : file, mysql, opsipxeconfd
host_.* : file, opsipxeconfd
productOnClient_.* : file, opsipxeconfd
configState_.* : file, opsipxeconfd
license.* : mysql
softwareLicense.* : mysql
audit.* : mysql
.* : file

i thought it could be a connection problem, but i'm able to connect to the mysql database:

mysql_client_test -h 192.168.254.2 -D opsi -u opsi -p
Enter password:


#####################################
client_connect
#####################################

Establishing a connection to '192.168.254.2' ...OK
Connected to MySQL server version: 5.0.51a-24+lenny5 (50051)

Creating a test database 'client_test_db' ...../../tests/mysql_client_fw.c:344: check failed: 'r == 0'

can i set a more verbose logging somehow? at the moment i can't find any useful message in the logfiles.

[d.oertel]

Hi,

did you run again:

Code: Alles auswählen

opsi-setup --configure-mysql
opsi-setup --init-current-config
opsi-setup --set-rights
/etc/init.d/opsiconfd restart
/etc/init.d/opsipxeconfd restart

?

regards

d.oertel

[inszekt_]

of course

the problem still exists

[d.oertel]

Hi,

please post the opsiconfd log of this client while installing swaudit.

regards

d.oertel

[inszekt_]

hi

here is the last lines of the appropriate log file:

[5] [Dec 18 11:14:04] Application 'opsi linux bootimage 20120728' on client '192.168.2.9' did not send cookie (workers.py|161)
[5] [Dec 18 11:14:04] New session created (session.py|75)
[5] [Dec 18 11:14:04] Authorization request from host barack.ringcsoport.hu@192.168.2.9 (application: opsi linux bootimage 20120728) (workers.py|186)
[5] [Dec 18 11:14:05] Modules file signature verified (customer: Peter Nevelos) (MySQL.py|422)
[5] [Dec 18 11:14:05] -----> Executing: backend_getInterface() (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: configState_getClientToDepotserver([], u'barack.ringcsoport.hu', True, []) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: productOnDepot_getIdents(u'dict', {'depotId': u'opsidepot.ringcsoport.hu', 'productType': u'NetbootProduct', 'productId': u'win7'}) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: product_getObjects([], {'packageVersion': u'1', 'id': u'win7', 'productVersion': u'4.0.2'}) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: backend_setOptions({u'addProductPropertyStateDefaults': True}) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: productPropertyState_getObjects([], {'objectId': u'barack.ringcsoport.hu', 'productId': u'win7'}) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: backend_setOptions({u'addConfigStateDefaults': True}) (JsonRpc.py|123)
[5] [Dec 18 11:14:06] -----> Executing: configState_getObjects([], {'objectId': u'barack.ringcsoport.hu'}) (JsonRpc.py|123)
[5] [Dec 18 11:14:07] -----> Executing: user_getCredentials(u'pcpatch', u'barack.ringcsoport.hu') (JsonRpc.py|123)
[5] [Dec 18 11:14:07] -----> Executing: host_getObjects([], {'type': u'OpsiDepotserver', 'id': u'opsidepot.ringcsoport.hu'}) (JsonRpc.py|123)
[5] [Dec 18 11:14:07] -----> Executing: productOnClient_updateObjects(<ProductOnClient clientId 'barack.ringcsoport.hu', productId 'win7', installationStatus 'unknown', actionRequest 'None'>) (JsonRpc.py|123)
[5] [Dec 18 11:14:08] -----> Executing: auditHardware_getConfig(None) (JsonRpc.py|123)

thank you for your help,

np

[d.oertel]

Hi,

please more lines
(starting with -----> Executing: auditHardware_getConfig(None))
something like:

Code: Alles auswählen

[6] [Dec 18 13:06:57] Reusing session for client '192.168.2.111', application 'opsi linux bootimage 20121105' (Worker.py|391)
[5] [Dec 18 13:06:58] -----> Executing: auditHardware_getConfig(None) (JsonRpc.py|123)
[6] [Dec 18 13:06:58] Got result (JsonRpc.py|131)
[6] [Dec 18 13:07:04] Worker <opsiconfd.workers.WorkerOpsiconfdJsonRpc instance at 0x73242440> started processing (Worker.py|244)
[6] [Dec 18 13:07:04] Reusing session for client '192.168.2.111', application 'opsi linux bootimage 20121105' (Worker.py|391)
[5] [Dec 18 13:07:04] -----> Executing: auditHardwareOnHost_setObsolete(u'pctry1detlef.uib.local') (JsonRpc.py|123)
[6] [Dec 18 13:07:05] Got result (JsonRpc.py|131)
[6] [Dec 18 13:07:05] Worker <opsiconfd.workers.WorkerOpsiconfdJsonRpc instance at 0x7342a440> started processing (Worker.py|244)
[6] [Dec 18 13:07:05] Reusing session for client '192.168.2.111', application 'opsi linux bootimage 20121105' (Worker.py|391)
[5] [Dec 18 13:07:05] -----> Executing: auditHardwareOnHost_createObjects([<AuditHardwareOnHost hostId 'pctry1detlef.uib.local', hardwareClass 'AUDIO_CONTROLLER', name 'MCP61 High Definition Audio'>, <AuditHardwareOnHost hostId 'pctry1detlef.uib.local', hardwareClass 'PORT_...) (JsonRpc.py|123)
[6] [Dec 18 13:07:06] Got result (JsonRpc.py|131)
[6] [Dec 18 13:07:06] Worker <opsiconfd.workers.WorkerOpsiconfdJsonRpc instance at 0x802f40e0> started processing (Worker.py|244)
[6] [Dec 18 13:07:06] Reusing session for client '192.168.2.111', application 'opsi linux bootimage 20121105' (Worker.py|391)
[5] [Dec 18 13:07:06] -----> Executing: productOnClient_updateObjects(<ProductOnClient clientId 'pctry1detlef.uib.local', productId 'hwinvent', installationStatus 'installed', actionRequest 'none'>) (JsonRpc.py|123)
[6] [Dec 18 13:07:06] Got result (JsonRpc.py|131)

We have here in this example 6 seconds to run the inventory on the client and 2 seconds to send the result back to the server.

regards

d.oertel

d.oertel

[inszekt_]

hi

[5] [Dec 18 11:14:08] -----> Executing: auditHardware_getConfig(None) (JsonRpc.py|123)

this line is the last in the client log file. and now I'm watching the "Starte Hardware-Inventarisierung" line till the end of time.

[d.oertel]

Hi,

ok - it looks like that the servicecall auditHardware_getConfig never ends.

What happens if you run

Code: Alles auswählen

opsi-admin -d method auditHardware_getConfig

on the servers command line ?
What is the output of

Code: Alles auswählen

dpkg -l | grep opsi

?

d.oertel

[inszekt_]

i can't attach the output of the

Code: Alles auswählen

opsi-admin -d method auditHardware_getConfig command

command, because i've reached a board limit, or what. here is a small portion:

Code: Alles auswählen

          {
          "Values" :
                    [
                              {
                              "Opsi" : "name",
                              "WMI" : "Name",
                              "UI" : "Name",
                              "Linux" : "product",
                              "Scope" : "g",
                              "Type" : "varchar(100)"
                              },
                              {
                              "Opsi" : "description",
                              "WMI" : "Description",
                              "UI" : "Description",
                              "Linux" : "description",
                              "Scope" : "g",
                              "Type" : "varchar(100)"
                              },
                              {
                              "Opsi" : "vendor",
                              "WMI" : "Manufacturer",
                              "UI" : "Vendor",
                              "Linux" : "vendor",
                              "Scope" : "g",
                              "Type" : "varchar(50)"
                              },
                              {
                              "Opsi" : "model",
                              "WMI" : "Model",
                              "UI" : "Model",
                              "Linux" : "product",
                              "Scope" : "g",
                              "Type" : "varchar(100)"
                              },
                              {
                              "Opsi" : "serialNumber",
                              "WMI" : "SerialNumber",
                              "UI" : "Serial number",
                              "Linux" : "serial",
                              "Scope" : "i",
                              "Type" : "varchar(50)"
                              },
                              {
                              "Opsi" : "horizontalResolution",
                              "WMI" : "HorizontalResolution",
                              "UI" : "Horizontal resolution",
                              "Scope" : "g",
                              "Type" : "int",
                              "Unit" : "dpi"
                              },
                              {
                              "Opsi" : "verticalResolution",
                              "WMI" : "VerticalResolution",
                              "UI" : "Vertical resolution",
                              "Scope" : "g",
                              "Type" : "int",
                              "Unit" : "dpi"
                              },
                              {
                              "Scope" : "g",
                              "WMI" : "Capabilities",
                              "Type" : "varchar(200)",
                              "UI" : "Capabilities",
                              "Opsi" : "capabilities"
                              },
                              {
                              "Scope" : "g",
                              "WMI" : "PaperSizesSupported",
                              "Type" : "varchar(200)",
                              "UI" : "Supported paper sizes",
                              "Opsi" : "paperSizesSupported"
                              },
                              {
                              "Scope" : "i",
                              "WMI" : "DriverName",
                              "Type" : "varchar(100)",
                              "UI" : "Driver name",
                              "Opsi" : "driverName"
                              },
                              {
                              "Scope" : "i",
                              "WMI" : "PortName",
                              "Type" : "varchar(20)",
                              "UI" : "Port",
                              "Opsi" : "port"
                              }
                    ],
          "Class" :
                    {
                    "Opsi" : "PRINTER",
                    "WMI" : "select * from Win32_Printer",
                    "UI" : "Printer"
                    }
          }
]

output of the

Code: Alles auswählen

dpkg -l | grep opsi

command:

ii opsi-atftpd 0.7.dfsg-2.1 advanced TFTP server - opsi version with pcre, fifo and max-blksize patches
ii opsi-configed 4.0.2.5.8-1 OPSI config editor
ii opsi-depotserver 4.0.2.3-1 opsi depotserver configuration package
ii opsi-linux-bootimage 20120728-1 opsi linux bootimage
ii opsi-utils 4.0.2.3-1 opsi utils
ii opsiconfd 4.0.2.4-1 opsi configuration service
ii opsipxeconfd 4.0.2.6-1 opsi pxe configuration daemon
ii python-opsi 4.0.2.4-1 opsi python library

[d.oertel]

Hi,

looks good.
start at
[url]https://<your-opsi-server>:4447/interface[/url]
the method 'auditHardware_getConfig'
Does it still work ?

d.oertel