asemon / Discussion / Help: INFO ABOUT ASE 16 SP04 PL04

Rotix79 - 2023-06-01

Dear Team
we have this configuration

ASE Version : Adaptive Server Enterprise/16.0 SP04 PL04/EBF 30650 SMP/P/x86_64/SLES 12.4/ase160sp04pl04x/3585/64-bit/FBO/Tue Feb 14 09:59:39 2023
Linux : RHEL8
APACHE : Server version: Apache/2.4.37 (Red Hat Enterprise Linux)
PHP : PHP 8.1.18 (cli) (built: Apr 11 2023 16:47:45) (NTS gcc x86_64)
ASEMON Logger :asemon_logger_V3.2.1
ASEMON Reporter : asemon_report_V3.2.1

Is this configuration supported?
We have strange behaviour because we are able to retrieve data in "Summary" tab but no data from other tabs.
It is very strange because if we do the query direct to the DB we retrieve data.
Could you help us to understand?
Thanks in advance.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jean-Paul Martin - 2023-06-01

Hi,
can you send the output of asemon_logger (from the beginning)

Any error in Apache log ?

Regards
JP

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-01

Thank you JP
No error in Apache log.
Attached you can find logger logs and issue.
Thanks in advance.

Last edit: Rotix79 2023-06-01

ASEMON ISSUE.pdf

asemon_ER3IS.log

asemon_ER3MI.log

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jean-Paul Martin - 2023-06-02

Hi,
very strange,
how did you configure your ODBC driver on Linux for your Asemon server ?
Did you set "usecursor=1" ?
And did you install a very recent Open Client ?

Here is mine for example :

[JPMV16]
Description=Sybase ODBC Data Source
UserID=sa
Password=
Driver=/home/sybase16/SDK16SP04PL03/DataAccess64/ODBC/lib/libsybdrvodb.so
Server=myhost
Port=6000
Database=master
UseCursor=1

Regards
JP

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

Here is mine

Driver=/usr/users/sybase/ASE/DataAccess64/ODBC/lib/libsybdrvodb.so

[ER3IS]
Description=Sybase ODBC Data Source
UserID=asemon
Password=
Driver=/usr/users/sybase/ASE/DataAccess64/ODBC/lib/libsybdrvodb.so
Server=svmivm9106.mi.tdk-electronics.biz
Port=2028
Database=asemon
UseCursor=1

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

it is very strange because on some views I can see the data but for others not.
For example "Devices" is blank but "Siswaits" shows data.
M.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

I switched loglevel to "debug" to see what happens.
Here the log related to "devices" click

[Mon Jun 05 10:18:02.586958 2023] [authz_core:debug] [pid 1379911:tid 140542109271808] mod_authz_core.c(820): [client 172.16.148.116:65008] AH01626: authorization result of Require all granted: granted, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587041 2023] [authz_core:debug] [pid 1379911:tid 140542109271808] mod_authz_core.c(820): [client 172.16.148.116:65008] AH01626: authorization result of <requireany>: granted, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587096 2023] [proxy:debug] [pid 1379911:tid 140542109271808] mod_proxy.c(1265): [client 172.16.148.116:65008] AH01143: Running scheme unix handler (attempt 0), referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587113 2023] [proxy_ajp:debug] [pid 1379911:tid 140542109271808] mod_proxy_ajp.c(764): [client 172.16.148.116:65008] AH00894: declining URL fcgi://localhost/var/www/html/asemon_report/COMMON/simplequery.php, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587164 2023] [proxy_fcgi:debug] [pid 1379911:tid 140542109271808] mod_proxy_fcgi.c(1021): [client 172.16.148.116:65008] AH01076: url: fcgi://localhost/var/www/html/asemon_report/COMMON/simplequery.php proxyname: (null) proxyport: 0, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587211 2023] [proxy_fcgi:debug] [pid 1379911:tid 140542109271808] mod_proxy_fcgi.c(1028): [client 172.16.148.116:65008] AH01078: serving URL fcgi://localhost/var/www/html/asemon_report/COMMON/simplequery.php, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587237 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(2353): AH00942: FCGI: has acquired connection for ()
[Mon Jun 05 10:18:02.587329 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(2408): [client 172.16.148.116:65008] AH00944: connecting fcgi://localhost/var/www/html/asemon_report/COMMON/simplequery.php to localhost:8000, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587355 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(2445): [client 172.16.148.116:65008] AH02545: fcgi: has determined UDS as /run/php-fpm/www.sock, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587459 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(2634): [client 172.16.148.116:65008] AH00947: connected /var/www/html/asemon_report/COMMON/simplequery.php to httpd-UDS:0, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.587522 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(3006): AH02823: FCGI: connection established with Unix domain socket /run/php-fpm/www.sock ()
[Mon Jun 05 10:18:02.714808 2023] [proxy:debug] [pid 1379911:tid 140542109271808] proxy_util.c(2368): AH00943: FCGI: has released connection for ()
[Mon Jun 05 10:18:02.738443 2023] [authz_core:debug] [pid 1379911:tid 140542100879104] mod_authz_core.c(820): [client 172.16.148.116:65008] AH01626: authorization result of Require all granted: granted, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738515 2023] [authz_core:debug] [pid 1379911:tid 140542100879104] mod_authz_core.c(820): [client 172.16.148.116:65008] AH01626: authorization result of <requireany>: granted, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738567 2023] [proxy:debug] [pid 1379911:tid 140542100879104] mod_proxy.c(1265): [client 172.16.148.116:65008] AH01143: Running scheme unix handler (attempt 0), referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738580 2023] [proxy_ajp:debug] [pid 1379911:tid 140542100879104] mod_proxy_ajp.c(764): [client 172.16.148.116:65008] AH00894: declining URL fcgi://localhost/var/www/html/asemon_report/COMMON/getgriddata.php, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738591 2023] [proxy_fcgi:debug] [pid 1379911:tid 140542100879104] mod_proxy_fcgi.c(1021): [client 172.16.148.116:65008] AH01076: url: fcgi://localhost/var/www/html/asemon_report/COMMON/getgriddata.php proxyname: (null) proxyport: 0, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738600 2023] [proxy_fcgi:debug] [pid 1379911:tid 140542100879104] mod_proxy_fcgi.c(1028): [client 172.16.148.116:65008] AH01078: serving URL fcgi://localhost/var/www/html/asemon_report/COMMON/getgriddata.php, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738616 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(2353): AH00942: FCGI: has acquired connection for (</requireany>)
[Mon Jun 05 10:18:02.738630 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(2408): [client 172.16.148.116:65008] AH00944: connecting fcgi://localhost/var/www/html/asemon_report/COMMON/getgriddata.php to localhost:8000, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738642 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(2445): [client 172.16.148.116:65008] AH02545: fcgi: has determined UDS as /run/php-fpm/www.sock, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738764 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(2634): [client 172.16.148.116:65008] AH00947: connected /var/www/html/asemon_report/COMMON/getgriddata.php to httpd-UDS:0, referer: http://svmivm9107.mi.tdk-electronics.biz/asemon_report/
[Mon Jun 05 10:18:02.738840 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(3006): AH02823: FCGI: connection established with Unix domain socket /run/php-fpm/www.sock ()
[Mon Jun 05 10:18:02.884875 2023] [proxy:debug] [pid 1379911:tid 140542100879104] proxy_util.c(2368): AH00943: FCGI: has released connection for ()</requireany>

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jean-Paul Martin - 2023-06-05

Hi,
I see this in your trace :

declining URL fcgi://localhost/var/www/html/asemon_report/COMMON/simplequery.php

declining URL fcgi://localhost/var/www/html/asemon_report/COMMON/getgriddata.php

May be the directory COMMON has insufficient rights

Do you have selinux activated ?
If yes can you try without selinux (setenforce 0 to deactivate)

Or install a more recent Sybase ODBC driver
I have no more idea

Regards
JP

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

I will try to check COMMON folder.
SeLInux is disabled.
ODBC should be the latest. or PL03
In any case I will let you know.
M.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

here the permission for the folder COOMON

[root@svmivm9107 COMMON]# getfacl .

file: .

owner: apache

group: apache

user::rwx
group::rwx
other::rwx**

files behind are
[root@svmivm9107 COMMON]# getfacl simplequery.php

file: simplequery.php

owner: apache

group: apache

user::rwx
group::rwx
other::rwx

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

should PHP8 be the reason?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jean-Paul Martin - 2023-06-05

no, asemon V3.2.1 supports PHP 8 (with ODBC acces to Sybase ASE)
I tested with PHP 8.1.12 and 8.1.19

See my odbc config in attached file (you can check with "your_apache_host/asemon_report/phpinfo.php"

What do you have in your config.ph file
I have :

// If you use PHP8, need to configure ODBC module. Two possibilities : PHP-DBO_ODBC or PHP-ODBC $odbc_module="PHP-DBO_ODBC"; // Can be set to "PHP-ODBC" if you have difficulties to install PHP-DBO_ODBC

No more idea for the moment
Regards
JP

Capture d'écran 2023-06-05 132856.png
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rotix79 - 2023-06-05

it works!!!! I changed the config from PHP_ODBC to PHP-DBO_ODBC and now it works!
Thanks a lot!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jean-Paul Martin - 2023-06-05

Ok good, I'll try to find why it doesn't work with PHP_ODBC
(PHP_ODBC doesn't use same API calls as PHP-DBO)
Regards
JP

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

INFO ABOUT ASE 16 SP04 PL04

Forums

Help

INFO ABOUT ASE 16 SP04 PL04 document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Driver=/usr/users/sybase/ASE/DataAccess64/ODBC/lib/libsybdrvodb.so

file: .

owner: apache

group: apache

file: simplequery.php

owner: apache

group: apache

INFO ABOUT ASE 16 SP04 PL04