[2026-08-27 17:19:32] ====================================================== [2026-08-27 17:19:32] API REQUEST START [2026-08-27 17:19:32] REQUEST ID: CFUSER_6a9071a4db5b13.32973749 [2026-08-27 17:19:32] METHOD: GET [2026-08-27 17:19:32] URI: /cmms_test_api/insert_new_user1.php [2026-08-27 17:19:32] REMOTE IP: 45.135.193.11 [2026-08-27 17:19:32] REQUEST DATA: null [2026-08-27 17:19:32] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-08-27 17:19:32] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6a9071a4db5b13.32973749 [2026-08-28 21:53:51] ====================================================== [2026-08-28 21:53:51] API REQUEST START [2026-08-28 21:53:51] REQUEST ID: CFUSER_6a92036f3c8803.99880347 [2026-08-28 21:53:51] METHOD: GET [2026-08-28 21:53:51] URI: /cmms_test_api/insert_new_user1.php [2026-08-28 21:53:51] REMOTE IP: 113.196.56.150 [2026-08-28 21:53:51] REQUEST DATA: null [2026-08-28 21:53:51] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-08-28 21:53:51] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6a92036f3c8803.99880347 [2026-08-29 03:22:27] ====================================================== [2026-08-29 03:22:27] API REQUEST START [2026-08-29 03:22:27] REQUEST ID: CFUSER_6a92507384ecb4.23711308 [2026-08-29 03:22:27] METHOD: GET [2026-08-29 03:22:27] URI: /cmms_test_api/insert_new_user1.php [2026-08-29 03:22:27] REMOTE IP: 113.196.56.150 [2026-08-29 03:22:27] REQUEST DATA: null [2026-08-29 03:22:27] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-08-29 03:22:27] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6a92507384ecb4.23711308 [2026-08-30 11:19:42] ====================================================== [2026-08-30 11:19:42] API REQUEST START [2026-08-30 11:19:42] REQUEST ID: CFUSER_6a9411cee29477.83601552 [2026-08-30 11:19:42] METHOD: GET [2026-08-30 11:19:42] URI: /cmms_test_api/insert_new_user1.php [2026-08-30 11:19:42] REMOTE IP: 127.0.0.1 [2026-08-30 11:19:42] REQUEST DATA: null [2026-08-30 11:19:42] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-08-30 11:19:42] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6a9411cee29477.83601552 [2026-09-08 09:28:39] ====================================================== [2026-09-08 09:28:39] API REQUEST START [2026-09-08 09:28:39] REQUEST ID: CFUSER_6a9fd54715a442.91944701 [2026-09-08 09:28:39] METHOD: OPTIONS [2026-09-08 09:28:39] URI: /cmms_test_api/insert_new_user1.php [2026-09-08 09:28:39] REMOTE IP: 127.0.0.1 [2026-09-08 09:28:39] REQUEST DATA: null [2026-09-08 09:28:39] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-08 09:28:39] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6a9fd54715a442.91944701 [2026-09-08 09:28:39] ====================================================== [2026-09-08 09:28:39] API REQUEST START [2026-09-08 09:28:39] REQUEST ID: CFUSER_6a9fd54726e8a4.01459865 [2026-09-08 09:28:39] METHOD: POST [2026-09-08 09:28:39] URI: /cmms_test_api/insert_new_user1.php [2026-09-08 09:28:39] REMOTE IP: 127.0.0.1 [2026-09-08 09:28:39] REQUEST DATA: {"empl_id":"SAI_LOG","name":"SAI","default_site":"CRT","default_language":"DEFAULT","audit_user":"sekhar_001","password":"********","template":"","cf_user_failed_attempt":"0","sys_admin":true,"cf_user_locked":0,"cf_user_disable_auto_logout":0,"last_login":"","last_pwd_changed":"","expired_date":"","emp_mst_privilege_template":"","login_id":"SAI_LOG","emp_mst_create_by":"sekhar_001"} [2026-09-08 09:28:39] PARSED VALUES | login_id='SAI_LOG' | empl_id='SAI_LOG' | name='SAI' | default_site='CRT' | default_language='DEFAULT' | sys_admin=true | audit_user='sekhar_001' [2026-09-08 09:28:39] CHECKING SQL SERVER LOGIN FOR empl_id='SAI_LOG' [2026-09-08 09:28:39] SQL SERVER LOGIN DOES NOT EXIST | Creating login | empl_id='SAI_LOG' [2026-09-08 09:28:39] sp_addlogin SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] sp_addsrvrolemember SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] DELETE cf_site_user SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] DELETE cf_user_access SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] sp_dropuser FAILED/IGNORED | ERROR: Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 15008 [code] => 15008 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'SAI_LOG' does not exist in the current database. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'SAI_LOG' does not exist in the current database. ) ) [2026-09-08 09:28:39] sp_adduser SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] sp_addrolemember SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] cf_site_user RECORD COUNT = 0 | empl_id='SAI_LOG' | site='CRT' [2026-09-08 09:28:39] INSERT cf_site_user SUCCESS | empl_id='SAI_LOG' [2026-09-08 09:28:39] INSERT cf_user_access F SUCCESS [2026-09-08 09:28:39] INSERT cf_user_access R SUCCESS [2026-09-08 09:28:39] INSERT cf_user_access M SUCCESS [2026-09-08 09:28:39] ------------------------------------------------------ [2026-09-08 09:28:39] CF_USER INSERT ATTEMPT [2026-09-08 09:28:39] REQUEST ID: CFUSER_6a9fd54726e8a4.01459865 [2026-09-08 09:28:39] CF_USER VALUES | empl_id='SAI_LOG' | name='SAI' | default_site='CRT' | default_language='DEFAULT' | sys_admin=true | audit_user='sekhar_001' | expired_date=NULL [2026-09-08 09:28:39] EXECUTING CF_USER INSERT [2026-09-08 09:28:39] CF_USER INSERT SUCCESS | REQUEST ID: CFUSER_6a9fd54726e8a4.01459865 [2026-09-08 09:28:39] API REQUEST END | REQUEST ID: CFUSER_6a9fd54726e8a4.01459865 [2026-09-08 09:28:39] ====================================================== [2026-09-09 01:50:10] ====================================================== [2026-09-09 01:50:10] API REQUEST START [2026-09-09 01:50:10] REQUEST ID: CFUSER_6aa0bb525e7055.63033477 [2026-09-09 01:50:10] METHOD: GET [2026-09-09 01:50:10] URI: /cmms_test_api/insert_new_user1.php [2026-09-09 01:50:10] REMOTE IP: 127.0.0.1 [2026-09-09 01:50:10] REQUEST DATA: null [2026-09-09 01:50:10] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-09 01:50:10] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6aa0bb525e7055.63033477 [2026-09-15 11:51:48] ====================================================== [2026-09-15 11:51:48] API REQUEST START [2026-09-15 11:51:48] REQUEST ID: CFUSER_6aa931547d8f11.51212581 [2026-09-15 11:51:48] METHOD: GET [2026-09-15 11:51:48] URI: /cmms_test_api/insert_new_user1.php [2026-09-15 11:51:48] REMOTE IP: 127.0.0.1 [2026-09-15 11:51:48] REQUEST DATA: null [2026-09-15 11:51:48] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-15 11:51:48] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6aa931547d8f11.51212581 [2026-09-17 21:55:12] ====================================================== [2026-09-17 21:55:12] API REQUEST START [2026-09-17 21:55:12] REQUEST ID: CFUSER_6aac61c0e4eb34.43611116 [2026-09-17 21:55:12] METHOD: GET [2026-09-17 21:55:12] URI: /cmms_test_api/insert_new_user1.php [2026-09-17 21:55:12] REMOTE IP: 127.0.0.1 [2026-09-17 21:55:12] REQUEST DATA: null [2026-09-17 21:55:12] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-17 21:55:12] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6aac61c0e4eb34.43611116 [2026-09-22 03:41:16] ====================================================== [2026-09-22 03:41:16] API REQUEST START [2026-09-22 03:41:16] REQUEST ID: CFUSER_6ab1f8dc87ef64.23247280 [2026-09-22 03:41:16] METHOD: POST [2026-09-22 03:41:16] URI: /cmms_test_api/insert_new_user1.php [2026-09-22 03:41:16] REMOTE IP: 127.0.0.1 [2026-09-22 03:41:16] REQUEST DATA: {"empl_id":"zakaria@evantagedevoutlook.onmicrosoft.com","name":"test","default_site":"CPI","default_language":"DEFAULT","audit_user":"admin","password":"********","template":"","cf_user_failed_attempt":"0","sys_admin":0,"cf_user_locked":0,"cf_user_disable_auto_logout":0,"last_login":"","last_pwd_changed":"","expired_date":"","emp_mst_privilege_template":"ADMIN","login_id":"zakaria@evantagedevoutlook.onmicrosoft.com","emp_mst_create_by":"admin"} [2026-09-22 03:41:16] PARSED VALUES | login_id='zakaria@evantagedevoutlook.onmicrosoft.com' | empl_id='zakaria@evantagedevoutlook.onmicrosoft.com' | name='test' | default_site='CPI' | default_language='DEFAULT' | sys_admin=0 | audit_user='admin' [2026-09-22 03:41:16] CHECKING SQL SERVER LOGIN FOR empl_id='zakaria@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:16] SQL SERVER LOGIN ALREADY EXISTS | username='zakaria@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] ====================================================== [2026-09-22 03:41:30] API REQUEST START [2026-09-22 03:41:30] REQUEST ID: CFUSER_6ab1f8ea0e6e23.14561202 [2026-09-22 03:41:30] METHOD: POST [2026-09-22 03:41:30] URI: /cmms_test_api/insert_new_user1.php [2026-09-22 03:41:30] REMOTE IP: 127.0.0.1 [2026-09-22 03:41:30] REQUEST DATA: {"empl_id":"zakaria1@evantagedevoutlook.onmicrosoft.com","name":"test","default_site":"CPI","default_language":"DEFAULT","audit_user":"admin","password":"********","template":"","cf_user_failed_attempt":"0","sys_admin":0,"cf_user_locked":0,"cf_user_disable_auto_logout":0,"last_login":"","last_pwd_changed":"","expired_date":"","emp_mst_privilege_template":"ADMIN","login_id":"zakaria1@evantagedevoutlook.onmicrosoft.com","emp_mst_create_by":"admin"} [2026-09-22 03:41:30] PARSED VALUES | login_id='zakaria1@evantagedevoutlook.onmicrosoft.com' | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' | name='test' | default_site='CPI' | default_language='DEFAULT' | sys_admin=0 | audit_user='admin' [2026-09-22 03:41:30] CHECKING SQL SERVER LOGIN FOR empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] SQL SERVER LOGIN DOES NOT EXIST | Creating login | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] sp_addlogin SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] sp_addsrvrolemember SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] DELETE cf_site_user SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] DELETE cf_user_access SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] sp_dropuser FAILED/IGNORED | ERROR: Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 15008 [code] => 15008 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'zakaria1@evantagedevoutlook.onmicrosoft.com' does not exist in the current database. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'zakaria1@evantagedevoutlook.onmicrosoft.com' does not exist in the current database. ) ) [2026-09-22 03:41:30] sp_adduser SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] sp_addrolemember SUCCESS | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' [2026-09-22 03:41:30] cf_site_user RECORD COUNT = 0 | empl_id='zakaria1@evantagedevoutlook.onmicrosoft.com' | site='CPI' [2026-09-22 03:41:30] INSERT cf_site_user FAILED | ERROR: Array ( [0] => Array ( [0] => 22001 [SQLSTATE] => 22001 [1] => 8152 [code] => 8152 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated. ) [1] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 3621 [code] => 3621 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated. ) ) [2026-09-22 19:20:24] ====================================================== [2026-09-22 19:20:24] API REQUEST START [2026-09-22 19:20:24] REQUEST ID: CFUSER_6ab2d4f8dff8b8.27274562 [2026-09-22 19:20:24] METHOD: GET [2026-09-22 19:20:24] URI: /cmms_helpdesk_api/insert_new_user1.php [2026-09-22 19:20:24] REMOTE IP: 127.0.0.1 [2026-09-22 19:20:24] REQUEST DATA: null [2026-09-22 19:20:24] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-22 19:20:24] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6ab2d4f8dff8b8.27274562 [2026-09-22 22:28:54] ====================================================== [2026-09-22 22:28:54] API REQUEST START [2026-09-22 22:28:54] REQUEST ID: CFUSER_6ab301269b0444.10601237 [2026-09-22 22:28:54] METHOD: GET [2026-09-22 22:28:54] URI: /cmms_helpdesk_api/insert_new_user1.php [2026-09-22 22:28:54] REMOTE IP: 127.0.0.1 [2026-09-22 22:28:54] REQUEST DATA: null [2026-09-22 22:28:54] PARSED VALUES | login_id=NULL | empl_id=NULL | name=NULL | default_site=NULL | default_language=NULL | sys_admin=NULL | audit_user=NULL [2026-09-22 22:28:54] VALIDATION FAILED | empl_id is empty | REQUEST ID: CFUSER_6ab301269b0444.10601237