500 internal server error MacOS agent

[PeLbmaN]

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : MacOS (all versions)

Server informations

Perl version : 5 Mysql / Mariadb / Percona version : 10.3.36-MariaDB-0+deb10u2 Debian 10

OCS Inventory informations

Ocs server version :latest

Problem's description

Describe your problem here Hi, i have problem with connect macos agent to ocs server My windows and Ububntu successfully сonnected, but macos spam 500 internal server error this is /var/log/ocsinventory-server/activity.log

OCS-NG_unified_unix_agent_v2.10.0;ipdiscover;checking if is enabled
OCS-NG_unified_unix_agent_v2.10.0;ipdiscover;checking if parameters are OK
OCS-NG_unified_unix_agent_v2.10.0;prolog;accepted
OCS-NG_unified_unix_agent_v2.10.0;session;started
OCS-NG_unified_unix_agent_v2.10.0;session;found
OCS-NG_unified_unix_agent_v2.10.0;inventory;incoming
OCS-NG_unified_unix_agent_v2.10.0;inventory;u:local_users
OCS-NG_unified_unix_agent_v2.10.0;end;error

MacOS report

[Mon Jan 16 17:47:31 2023][debug] Ocsinventory unified agent for UNIX, Linux and MacOSX 2.10.0

[Mon Jan 16 17:47:31 2023][debug] Log system initialised (File)

[Mon Jan 16 17:47:31 2023][debug] --scan-homedirs missing. Don't scan user directories

[Mon Jan 16 17:47:31 2023][debug] Accountinfo file: /var/lib/ocsinventory-agent/https:__ocs.bbrp.co_ocsinventory/ocsinv.adm

[Mon Jan 16 17:47:31 2023][debug] OCS Agent initialised

[Mon Jan 16 17:47:31 2023][debug] Turns hooks on for /etc/ocsinventory-agent/modules.conf

[Mon Jan 16 17:47:31 2023][debug] Ocsinventory unified agent for UNIX, Linux and MacOSX 2.10.0

[Mon Jan 16 17:47:31 2023][debug] Log system initialised (File)

[Mon Jan 16 17:47:31 2023][debug] Calling handlers : `start_handler'

[Mon Jan 16 17:47:31 2023][debug] [download] Calling download_start_handler

[Mon Jan 16 17:47:31 2023][debug]  - LWP loaded

[Mon Jan 16 17:47:31 2023][debug]  - LWP::Protocol::https loaded

[Mon Jan 16 17:47:31 2023][debug] Compress::Zlib is available.

[Mon Jan 16 17:47:31 2023][debug] Calling handlers : `prolog_writer'

[Mon Jan 16 17:47:31 2023][debug] checking XML

[Mon Jan 16 17:47:31 2023][debug] sending XML

[Mon Jan 16 17:47:31 2023][debug] sending: <?xml version="1.0" encoding="UTF-8"?>

<REQUEST>

  <DEVICEID>eadmins-MacBook-Air-3-2023-01-10-15-52-18</DEVICEID>

  <QUERY>PROLOG</QUERY>

</REQUEST>

[Mon Jan 16 17:47:32 2023][error] Cannot establish communication : 500 Server closed connection without sending any data back

[Mon Jan 16 17:47:38 2023][debug] Ocsinventory unified agent for UNIX, Linux and MacOSX 2.10.0

[Mon Jan 16 17:47:38 2023][debug] Log system initialised (File)

[Mon Jan 16 17:47:38 2023][debug] --scan-homedirs missing. Don't scan user directories

[Mon Jan 16 17:47:38 2023][debug] Accountinfo file: /var/lib/ocsinventory-agent/https:__ocs.bbrp.co_ocsinventory/ocsinv.adm

[Mon Jan 16 17:47:38 2023][debug] OCS Agent initialised

[Mon Jan 16 17:47:38 2023][debug] Turns hooks on for /etc/ocsinventory-agent/modules.conf

[Mon Jan 16 17:47:38 2023][debug] Ocsinventory unified agent for UNIX, Linux and MacOSX 2.10.0

[Mon Jan 16 17:47:38 2023][debug] Log system initialised (File)

[Mon Jan 16 17:47:38 2023][debug] Calling handlers : `start_handler'

[Mon Jan 16 17:47:38 2023][debug] [download] Calling download_start_handler

[Mon Jan 16 17:47:38 2023][debug]  - LWP loaded

[Mon Jan 16 17:47:38 2023][debug]  - LWP::Protocol::https loaded

[Mon Jan 16 17:47:38 2023][debug] Compress::Zlib is available.

[Mon Jan 16 17:47:38 2023][debug] Calling handlers : `prolog_writer'

[Mon Jan 16 17:47:38 2023][debug] checking XML

[Mon Jan 16 17:47:38 2023][debug] sending XML

[Mon Jan 16 17:47:38 2023][debug] sending: <?xml version="1.0" encoding="UTF-8"?>

<REQUEST>

  <DEVICEID>eadmins-MacBook-Air-3-2023-01-10-15-52-18</DEVICEID>

  <QUERY>PROLOG</QUERY>

</REQUEST>

[Mon Jan 16 17:47:38 2023][error] Cannot establish communication : 500 Server closed connection without sending any data back

I`m trying with ssl and without with CA and without IDK what to do Help pls

[PeLbmaN]

Apache error.log

[Tue Jan 17 00:00:23.894464 2023] [mpm_prefork:notice] [pid 29930] AH00163: Apache/2.4.38 (Debian) OpenSSL/1.1.1n mod_perl/2.0.10 Perl/v5.28.1 configured -- resuming normal operations
[Tue Jan 17 00:00:23.894493 2023] [core:notice] [pid 29930] AH00094: Command line: '/usr/sbin/apache2'
DBD::mysql::st execute failed: Table 'ocs.local_users' doesn't exist at /usr/local/share/perl/5.28.1/Apache/Ocsinventory/Server/Inventory/Update.pm line 173.

[Lea9250]

Hi @PeLbmaN,

You mentioned 'latest' as server version, are you using the official release (2.11.1) or nightlies ?

Regards, Léa

[charleneauger]

Hi,

Since there was no answer, I'll close this issue now.

Regards, Charlene