Untitled
Never
2022-07-14 14:57:52,806 INFO [stdout] (default task-3) details-new-account 2022-07-14 14:57:52,807 INFO [stdout] (default task-3) prepareStatement: select reg_id, created_at, updated_at, status, gelar, tempat_lahir, tgl_lahir, agama, pendidikan_terakhir, status_perkawinan, alamat_ktp, rt_ktp, rw_ktp, kodepos_ktp, status_tempat_tinggal, alamat_domisili, rt_domisili, rt_domisili, rw_domisili, kodepos_domisili, pekerjaan, jabatan, nama_tempat_kerja, alamat_tempat_kerja, bidang_usaha, penghasilan_bulanan, sumber_penghasilan, tujuan_buka_rekening, tujuan_pemakaian_dana, kelurahan_ktp, kecamatan_ktp, kota_kab_ktp, propinsi_ktp, kelurahan_domisili, kecamatan_domisili, kota_kab_domisili, propinsi_domisili, jenis_kelamin from newaccount.account_registration as acc where reg_id = '726' 2022-07-14 14:57:52,808 INFO [stdout] (default task-3) prepareStatement: select reg_id, created_at, updated_at, status, jenis_kelamin, pgp_sym_decrypt( decode( nik, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nik, pgp_sym_decrypt( decode( email, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as email, pgp_sym_decrypt( decode( nohp, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nohp, pgp_sym_decrypt( decode( nama, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nama, gelar, tempat_lahir, tgl_lahir, agama, pendidikan_terakhir, status_perkawinan, pgp_sym_decrypt( decode( nama_ibu, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nama_ibu, alamat_ktp, rt_ktp, rw_ktp, kodepos_ktp, status_tempat_tinggal, alamat_domisili, rt_domisili, rt_domisili, rw_domisili, kodepos_domisili, pekerjaan, jabatan, nama_tempat_kerja, alamat_tempat_kerja, bidang_usaha, penghasilan_bulanan, sumber_penghasilan, tujuan_buka_rekening, tujuan_pemakaian_dana, file_ktp, file_selfie_only, file_selfie_w_ktp, file_selfie_npwp,file_ttd, vc_code,file_formulir, latitude, longitude,third_party_kyc_result, pgp_sym_decrypt( decode( reg_username, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as reg_username, fk_user, fcm_token, pgp_sym_decrypt( decode( npwp, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as npwp, kelurahan_ktp, kecamatan_ktp, kota_kab_ktp, propinsi_ktp, kelurahan_domisili, kecamatan_domisili, kota_kab_domisili, propinsi_domisili, pend.nama_pendidikan_terakhir, agama.nama_agama, perkawinan.nama_status_perkawinan, pekerjaan.nama_pekerjaan, jabatan.nama_jabatan,bidang.nama_bidang_usaha, penghasilan.nama_penghasilan_bulanan, dana.nama_sumber_penghasilan,tujuan.nama_tujuan_buka_rekening, penggunaan.nama_tujuan_penggunaan_dana,kec_ktp.nama_kecamatan_ktp, kel_ktp.nama_kelurahan_ktp, kota_ktp.nama_kota_kab_ktp, prov_ktp.nama_propinsi_ktp, kelurahan_dom.nama_kelurahan_domisili, kota_domisili.nama_kota_kab_domisili, prov_domisili.nama_propinsi_domisili, kec_domisili.nama_kecamatan_domisili, kelamin.nama_jenis_kelamin, tempat_lahir.nama_tempat_lahir, status_tempat_tinggal.nama_status_tempat_tinggal, note_reject, updated_at_video_call, updated_by_video_call, updated_at_core, updated_by_core, other_pekerjaan, other_jabatan, other_bidang_usaha, other_sumber_dana, other_tujuan_pembukaan, other_tujuan_penggunaan, up_user.nama_updated_by_video_call, core_user.nama_updated_by_core from (select * from newaccount.account_registration where reg_id ='726') as acc left join (select nama as nama_pendidikan_terakhir, data_id, kode, status_data from cif.pendidikan_terakhir where kode ='07') as pend on cast( pend.kode as text )= acc.pendidikan_terakhir left join (select nama as nama_agama, data_id, kode, status_data from cif.agama where kode = '1') as agama on cast ( agama.kode as text )= acc.agama left join (select nama as nama_status_perkawinan, data_id, kode, status_data from cif.status_perkawinan where kode = '1' ) as perkawinan on cast( perkawinan.kode as text )= acc.status_perkawinan left join (select nama as nama_pekerjaan, data_id, kode, status_data from cif.pekerjaan where kode = '99') as pekerjaan on cast (pekerjaan.kode as text) = acc.pekerjaan left join ( select nama as nama_jabatan, data_id, kode, status_data from cif.pangkat_pekerjaan where kode = '99') as jabatan on cast ( jabatan.kode as text) = acc.jabatan left join ( select nama as nama_bidang_usaha, data_id, kode, status_data from cif.bidang_usaha where kode ='9990' ) as bidang on cast (bidang.kode as text) = acc.bidang_usaha left join (select nama as nama_penghasilan_bulanan, data_id, kode,status_data from cif.penghasilan where kode = '07') as penghasilan on cast( penghasilan.kode as text) = acc.penghasilan_bulanan left join (select nama as nama_sumber_penghasilan, data_id, kode, status_data from cif.sumber_dana where kode = '99') as dana on cast( dana.kode as text) = acc.sumber_penghasilan left join (select nama as nama_tujuan_buka_rekening, data_id, kode,status_data from cif.tujuan_pembukaan where kode = '99') as tujuan on cast( tujuan.kode as text) = acc.tujuan_buka_rekening left join (select nama as nama_tujuan_penggunaan_dana, data_id, kode,status_data from cif.penggunaan_dana where kode = '99' ) as penggunaan on cast( penggunaan.kode as text) = acc.tujuan_pemakaian_dana left join (select nama as nama_kecamatan_ktp,id_kec, id_kab, kode_core from db_daerah.kecamatan where id_kec = '320807' ) as kec_ktp on cast( kec_ktp.id_kec as text) = acc.kecamatan_ktp left join (select nama as nama_kelurahan_ktp, id_kel, id_kec, kode_core from db_daerah.kelurahan where id_kel = '3208072018' ) as kel_ktp on cast( kel_ktp.id_kel as text) = acc.kelurahan_ktp left join ( select nama as nama_kota_kab_ktp, id_kab, id_prov from db_daerah.kabupaten where id_kab = '3208' ) as kota_ktp on cast( kota_ktp.id_kab as text)= acc.kota_kab_ktp left join (select nama as nama_propinsi_ktp, id_prov, kode_core from db_daerah.provinsi where id_prov = '32' ) as prov_ktp on cast ( prov_ktp.id_prov as text)= acc.propinsi_ktp left join (select nama as nama_kelurahan_domisili, id_kel, id_kec, kode_core from db_daerah.kelurahan where id_kel = '3208072018') as kelurahan_dom on cast( kelurahan_dom.id_kel as text) = acc.kelurahan_domisili left join ( select nama as nama_kota_kab_domisili, id_kab, id_prov from db_daerah.kabupaten where id_kab = '3208') as kota_domisili on cast ( kota_domisili.id_kab as text)= acc.kota_kab_domisili left join (select nama as nama_kecamatan_domisili,id_kec, id_kab, kode_core from db_daerah.kecamatan where id_kec = '320807') as kec_domisili on cast( kec_domisili.id_kec as text) = acc.kecamatan_domisili left join (select nama as nama_propinsi_domisili, id_prov, kode_core from db_daerah.provinsi where id_prov = '32') as prov_domisili on cast (prov_domisili.id_prov as text) = acc.propinsi_domisili left join (select nama as nama_jenis_kelamin, kode, data_id from cif.jenis_kelamin where kode = 'L') as kelamin on cast (kelamin.kode as text ) = acc.jenis_kelamin left join (select nama as nama_tempat_lahir, kode from cif.tempat_lahir where kode = '0117') as tempat_lahir on cast(tempat_lahir.kode as text ) = acc.tempat_lahir left join (select nama as nama_status_tempat_tinggal, kode from cif.status_tempat_tinggal where kode = '03' ) as status_tempat_tinggal on cast(status_tempat_tinggal.kode as text ) = acc.status_tempat_tinggal left join ( select user_id, nama_user as nama_updated_by_video_call from system_user ) as up_user on up_user.user_id = acc.updated_by_video_call left join ( select user_id, nama_user as nama_updated_by_core from system_user ) as core_user on core_user.user_id = acc.updated_by_core 2022-07-14 14:57:52,890 INFO [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='URL_VCALL_API' 2022-07-14 14:57:52,891 INFO [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='USR_VCALL_API' 2022-07-14 14:57:52,892 INFO [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='PWD_VCALL_API' 2022-07-14 14:57:53,382 INFO [stdout] (default task-3) 2022-07-14 14:57:53,382 INFO [stdout] (default task-3) Sending 'POST' request to URL : http://172.30.0.6:8056/token 2022-07-14 14:57:53,382 INFO [stdout] (default task-3) Post parameters : username=bbw&password=-Soulo]dzLT2T>K 2022-07-14 14:57:53,382 INFO [stdout] (default task-3) Response Code : 200 2022-07-14 14:57:53,383 INFO [stdout] (default task-3) result : {"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJiYnciLCJleHAiOjE2NTc3ODM2NzN9.woTxWenDy9swtEn3l5dHQf6j2m_I4bNUZ4ke-L1oAcY","token_type":"bearer"} 2022-07-14 14:57:53,383 INFO [stdout] (default task-3) Header : sun.net.www.protocol.http.HttpURLConnection:http://172.30.0.6:8056/vcall-url 2022-07-14 14:57:53,383 INFO [stdout] (default task-3) Authorization : Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJiYnciLCJleHAiOjE2NTc3ODM2NzN9.woTxWenDy9swtEn3l5dHQf6j2m_I4bNUZ4ke-L1oAcY 2022-07-14 14:57:53,385 INFO [stdout] (default task-3) 2022-07-14 14:57:53,385 INFO [stdout] (default task-3) Sending 'POST' request to URL : http://172.30.0.6:8056/vcall-url 2022-07-14 14:57:53,385 INFO [stdout] (default task-3) Post parameters : {"filename": "5d6c10486a723ea9725a7f9e2ddff825c300"} 2022-07-14 14:57:53,385 INFO [stdout] (default task-3) Response Code : 200 2022-07-14 14:57:53,385 INFO [stdout] (default task-3) result : {"url":"https://minio.bprlestari.com/vcall/5d6c10486a723ea9725a7f9e2ddff825c300.mp4?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=minio-vcall%2F20220714%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20220714T065753Z&X-Amz-Expires=7200&X-Amz-SignedHeaders=host&X-Amz-Signature=2cf55f24158dce84473aac06065493e5fdac3c93ce8650ca2d47e2bd1b6cef15"} 2022-07-14 14:57:53,510 INFO [stdout] (default task-3) myname : <ControllerApproval> 2022-07-14 14:57:53,510 INFO [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id = 'PATH_RECORDED_VIDEO' 2022-07-14 14:57:53,524 INFO [stdout] (default task-3) path video https://vc08.bprlestari.com 2022-07-14 14:58:54,141 INFO [async.newaccount.ServletHelper] (default task-3) getFormData api.timestamp 2022-07-14 14:58:54,141 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.log 2022-07-14 14:58:54,144 INFO [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/KTP/ktp_BC43061788063510_1657781521682.tmp saved successfully 2022-07-14 14:58:54,149 INFO [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/SELFIE_WITH_KTP/selfie_w_ktp_BC43061788063510_1657781521682.tmp saved successfully 2022-07-14 14:58:54,154 INFO [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/SELFIE_ONLY/selfie_only_BC43061788063510_1657781521682.tmp saved successfully 2022-07-14 14:58:54,155 INFO [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/AUTOGRAPH/autograph_BC43061788063510_1657781521682.tmp saved successfully 2022-07-14 14:58:54,155 INFO [async.newaccount.ServletHelper] (default task-3) validateUserDataFileUpload 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) ERR 0 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN 89504E470D0A1A0A vs 89504E470D0A1A0A > RESULT true 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData checksum_ktp 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData checksum_npwp 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData checksum_selfie_only 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData checksum_selfie_w_ktp 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData checksum_autograph 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.data 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.signature 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_citizenship 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_agree_tnc 2022-07-14 14:58:54,156 INFO [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_agree_promo 2022-07-14 14:58:54,206 INFO [async.newaccount.ServletHelper] (default task-3) getFormData api.lang 2022-07-14 14:58:54,207 INFO [async.newaccount.ServletHelper] (default task-3) getFormData mob.os_type
Raw Text
-
POV: Creampied by my Bumble Date
4 min ago
-
Sugar Defender Tom Green
28 min ago
-
ygbyhgytrgfytrgfrtfg
30 min ago
-
FIST4K. Curious nymph tries fisting during affair with BF in living room
36 min ago
-
Makers CBD Gummies Reviews
38 min ago
-
Life Boost CBD Gummies - FACTS, SCAM UPDATED PRICE 2024
38 min ago
-
https://www.facebook.com/CerebrozenReviews/
1 hour ago
-
Happy holiday, dear ladies!
1 hour ago
-
No Deposit Bonus
1 hour ago
-
Adult Telegram Channels
1 hour ago