Zabbix Proxy script fail - Segmentation fault

[markfree]

I set up a Proxy 6.2 with ODBC for an Oracle DB.
The connection is running and I can collect some data from the DB.

I can test the connection using iSQL and it works fine at the command line.

$ isql [dsn] [user] [pass] -b << EOF
select count(*) from GENESYS_[dsn].TABLE;
EOF
+-----------------------------------------+
| COUNT(*) |
+-----------------------------------------+
| 13

$ isql [dsn] [user] [pass] -b <<< 'select count(*) from GENESYS_[dsn].TABLE;'
+-----------------------------------------+
| COUNT(*) |
+-----------------------------------------+
| 13

Now, I wanted to execute manually that command from within Zabbix Frontend.
For that, I created a script in Administration/Scripts with the same command.
When I try to start the script upon an event, it fails with the following error.

sh: line 1: 1654538 Segmentation fault (core dumped) isql [dsn] [user] [pass] <<< 'select count(*) from GENESYS_[dsn].TABLE;'

The proxy log only shows the same error.

1650390:20221014:120210.382 Failed to execute command "isql [dsn] [user] [pass] <<< 'select count(*) from GENESYS_[dsn].TABLE;'": sh: line 1: 1650690 Segmentation fault (core dumped) isql [dsn] [user] [pass] <<< 'select count(*) from GENESYS_[dsn].TABLE;'

What would that be?

[satheshr90@]

Hi, were you able to fix this issue? even we are facing same problem now after zabbix 5 to zabbix 6 environment.

[markfree]

I actually forgot about this post. It is fixed but I'll have to check that environment later.

[aa-zabbix-user]

Hello, if anyone has the fix to this issue "zabbix proxy script fail segmentation fault 6.2" please post it here as we are having this issue after upgrading from 5.2.2 to 6.2.9

[markfree]

Hello, if anyone has the fix to this issue "zabbix proxy script fail segmentation fault 6.2" please post it here as we are having this issue after upgrading from 5.2.2 to 6.2.9

I have switched from iSQL to Oracle's SQLplus.