5602 Error creating UDF/XSP/UDM/UDT/JAR: problem accessing the external file %VSTR

Problem:

DATABASE test;

CALL SQLJ.INSTALL_JAR('SJ?/tmp/gdpr/gdpr.jar', 'Encrypt_JAR', 0);

Failed [5602 : HY000] Error creating UDF/XSP/UDM/UDT/JAR: problem accessing the external file '/tmp/gdpr/gdpr.jar '.

Solution:

Check the permission for the jar file and provide read permission.

SMP001-01:/tmp # ls -lrt gdpr

-rw-r----- 1 ec2-user users 1751 Dec 28 08:37 gdpr.jar

SMP001-01:/tmp # chmod 775 -R gdpr

SMP001-01:/tmp # ls -lrt gdpr

-rwxrwxr-x 1 ec2-user users 1751 Dec 28 08:37 gdpr.jar