| Requirement | Value / Description |
|---|---|
| Server software | Apache |
| Allow overwrite (.htaccess files) | On (used for cool URLs). Ignore this message if you are running something else than Apache. |
| Apache module rewrite (mod_rewrite) | 1 (used for cool URLs). Ignore this message if you are running something else than Apache. |
| Apache module gzip (mod_gzip) | On (turning it On would improve response times). |
| PHP 5.6.0+ | Ignore this message if you are running an exotic PHP runtime |
| PHP | 8.0.30 |
| Timezone undefined | If error, please check date.timezone into PHP.ini. |
mb_strimwidth function exists |
PHP must be compiled with multibyte string support. |
json_encode function exists |
PHP must be compiled with json support. |
| Jorani can write into logs folder | The folder application/logs/ must be writable. |
| Jorani can write files | The folder local/upload/leaves/ must be writable. |
| pdo_mysql is LOADED | PDO/mysql is the recommended database driver. |
| OPcache IS NOT LOADED. | Please consider activating OPcache for the best performances. |
| openssl is LOADED | PHP Extension openssl is required if you use PHP7.1. |
| curl is LOADED | PHP Extension curl is needed for OAuth2 authentication. |
| ldap is LOADED | PHP Extension ldap is optional and allows you to use LDAP for authentication. |
| zip is LOADED | PHP Extension zip allows you to use the export to Excel feature. |
| xml is LOADED | PHP Extension xml allows you to use the export to Excel feature (and SAML/SSO). |
| gd is LOADED | PHP Extension gd2 allows you to use the export to Excel feature. |
| date is LOADED | PHP Extension zlib allows you to use the Authentication by SAML feature (SSO). |
| zlib is LOADED | PHP Extension zlib allows you to use the Authentication by SAML feature (SSO). |
You can test the following settings, but you need to edit the corresponding PHP scripts :
| Requirement | Value / Description |
|---|---|
| Configuration file | Found |
| Database connection | OK |
| Database query | OK |
| Database procedures | Error. Please check if your hosting company allows custom procedures (e.g. Amazon RDS). |
| Organization structure | OK |
| Error | SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION joieycom_eleave.GetParentIDByID does not exist |
| Table | Signature |
|---|---|
| actions | 2a28186539ac7cd1fe9fe3b52fedd6bd |
| ci_sessions | 2d02dc38052b948a0327f314e9412699 |
| contracts | 0bfc5fded1037723eaa75ace1bb908a2 |
| dayoffs | 77e0730ae4f3e4ac044e7f724b644988 |
| delegations | ebb51cca46198f419a167f7f31b5f78c |
| entitleddays | 46695c6d488f80c3def41d8d96f5572b |
| excluded_types | f969572e8432678de1f892b9e5604d49 |
| leaves | 74428197a6f4178af600e37bea8d0da5 |
| leaves_history | ceaecb9f620dd22c78783611f621e062 |
| oauth_access_tokens | 5d8256f426314ac314d51a8e16f8aed0 |
| oauth_applications | f960e31a7018f3e8e782766720725132 |
| oauth_authorization_codes | 4ece7db37f65ea041c16151cebb9b410 |
| oauth_clients | 9ec16475823f145ffb79ce486d5baf5c |
| oauth_jwt | 676927e06afe7037087e72ddb421691f |
| oauth_refresh_tokens | 587866a2a7f07d61361a160ed6851577 |
| oauth_scopes | 14ca206c7e7d6fe4468ce421f54cf681 |
| oauth_users | 70c0d0404b22526a127fca9bf8d02752 |
| organization | 5f33d49e99376f49e6ba2c6afde0e735 |
| org_lists | 51469719f1bda253403c5ec682b5c5d8 |
| org_lists_employees | 50920c229b2e4fe342daa5149953ceb0 |
| overtime | e0a9aaf67b357eb53d4e989d29c01bb9 |
| parameters | bb1871cb015f723885ae86010f009b4b |
| positions | 9e209931cd8c28a74af7178caa1e402e |
| roles | a53a5b082de6f450d32bcee6e2171a36 |
| status | 27ee88b34c0dd284eadf4982325dba5b |
| types | 40f85737eb44730ca035f4906eca8872 |
| users | 1511ef3ecde9541b51965f9529635eff |