SERVIDOR OCS INVENTORY 2.1 [RESOLVIDO]

laurojr91
(usa Ubuntu)

Enviado em 27/03/2014 - 10:12h

Tem sim a tabela ocsweb. Criei um usuário adm e fiz o select no banco pra ver se estava funcionando normalmente. Usuário criado e funcionando normalmente. Não tenho certeza mas eu penso que pode ser o agente que ta zuado ou o server que não está importando as informações.

laurojr91
(usa Ubuntu)

Enviado em 27/03/2014 - 11:02h

Encontrei o log do cliente. A título de conhecimento o log do Agente OCS no Win7 fica em C:\ProgramData\OCS Inventory NG\Agent\OCSInventory.log || log do Server = /var/log/ocsinventory-server/activity.log

Dentro do log do agente contém -->

==============================================================================
Starting OCS Inventory NG Agent on Thursday, March 27, 2014 10:54:34.
AGENT => Running OCS Inventory NG Agent Version 2.1.0.3
AGENT => Using OCS Inventory NG FrameWork Version 2.1.0.3
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) succesfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.1.0.3>
AGENT => Sending getLabel request
COM SERVER => Initializing cURL library for getFile
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending fileGet request to URL <http://192.168.0.219/ocsinventory/deploy/label>
COM SERVER => fileGet response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
AGENT => Failed to retrieve Label <HTTP Status Code #500>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID <TI-006-2014-03-27-10-54-33> and MACs <F0:4D:A2:D5:A8:72> in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending HTTP Post request to URL <http://192.168.0.219/ocsinventory>
COM SERVER => HTTP Post response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:00.

==============================================================================
Starting OCS Inventory NG Agent on Thursday, March 27, 2014 10:55:41.
AGENT => Running OCS Inventory NG Agent Version 2.1.0.3
AGENT => Using OCS Inventory NG FrameWork Version 2.1.0.3
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) succesfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.1.0.3>
AGENT => Sending getLabel request
COM SERVER => Initializing cURL library for getFile
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending fileGet request to URL <http://192.168.0.219/ocsinventory/deploy/label>
COM SERVER => fileGet response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
AGENT => Failed to retrieve Label <HTTP Status Code #500>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID <TI-006-2014-03-27-10-54-33> and MACs <F0:4D:A2:D5:A8:72> in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending HTTP Post request to URL <http://192.168.0.219/ocsinventory>
COM SERVER => HTTP Post response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:00.

==============================================================================
Starting OCS Inventory NG Agent on Thursday, March 27, 2014 10:57:42.
AGENT => Running OCS Inventory NG Agent Version 2.1.0.3
AGENT => Using OCS Inventory NG FrameWork Version 2.1.0.3
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) succesfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.1.0.3>
AGENT => Sending getLabel request
COM SERVER => Initializing cURL library for getFile
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending fileGet request to URL <http://192.168.0.219/ocsinventory/deploy/label>
COM SERVER => fileGet response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
AGENT => Failed to retrieve Label <HTTP Status Code #500>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID <TI-006-2014-03-27-10-54-33> and MACs <F0:4D:A2:D5:A8:72> in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending HTTP Post request to URL <http://192.168.0.219/ocsinventory>
COM SERVER => HTTP Post response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:00.

==============================================================================
Starting OCS Inventory NG Agent on Thursday, March 27, 2014 11:00:09.
AGENT => Running OCS Inventory NG Agent Version 2.1.0.3
AGENT => Using OCS Inventory NG FrameWork Version 2.1.0.3
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) succesfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.1.0.3>
AGENT => Sending getLabel request
COM SERVER => Initializing cURL library for getFile
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending fileGet request to URL <http://192.168.0.219/ocsinventory/deploy/label>
COM SERVER => fileGet response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
AGENT => Failed to retrieve Label <HTTP Status Code #500>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID <TI-006-2014-03-27-10-54-33> and MACs <F0:4D:A2:D5:A8:72> in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <C:\ProgramData\OCS Inventory NG\Agent\cacert.pem>
COM SERVER => Sending HTTP Post request to URL <http://192.168.0.219/ocsinventory>
COM SERVER => HTTP Post response received <HTTP Status Code #500>
COM SERVER => Cleaning cURL library
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:01.

spolti
(usa Fedora)

Enviado em 27/03/2014 - 11:07h

ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>


http://forums.ocsinventory-ng.org/viewtopic.php?id=9412


O mysql tá certo? veja os comentários do link aí acima

clesousa
(usa Outra)

Enviado em 27/03/2014 - 11:35h

Ainda acho que seu problema está na conexão com mysql..

laurojr91
(usa Ubuntu)

Enviado em 27/03/2014 - 15:53h

Como eu imaginava o problema estava nas configurações. A solução é bem simples.


Acessar o arquivo com qualquer editor de texto /etc/httpd/conf.d/z-ocsinventory-server.conf e alterar usuário e senha conforme cadastrado na instalação do servidor Mysql.


Por padrão virá USER e PWD = ocs.


PerlSetEnv OCS_DB_NAME ocsweb
PerlSetEnv OCS_DB_LOCAL ocsweb
# User allowed to connect to database
PerlSetEnv OCS_DB_USER ocs
# Password for user
PerlSetVar OCS_DB_PWD ocs



No meu caso ficou assim após a alteração.

PerlSetEnv OCS_DB_NAME ocsweb
PerlSetEnv OCS_DB_LOCAL ocsweb
# User allowed to connect to database
PerlSetEnv OCS_DB_USER "root"
# Password for user
PerlSetVar OCS_DB_PWD "654321"

spolti
(usa Fedora)

Enviado em 27/03/2014 - 16:37h

Que bom, contribua também, :) marque o tópico como resolvido e marque a resposta que você acha que lhe ajudou a resolver o problema.


Abraços