| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011214 | Taler | merchant backend | public | 2026-03-09 15:53 | 2026-03-09 19:52 |
| Reporter | vecirex | Assigned To | vecirex | ||
| Priority | urgent | Severity | block | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Summary | 0011214: Possible KYC Auth issue in taler-merchant v1.5.0 | ||||
| Description | See screenshot, before going too -vvvvv here, I check if I can reproduce, if taler-merchant-wise sth can be seen / done. | ||||
| Additional Information | See data used in screenshots. | ||||
| Tags | No tags attached. | ||||
|
|
Sebastian explains: PL/pgSQL function merchant_do_account_kyc_set_status(text,bytea,text,bigint,integer,integer,bytea,jsonb,boolean,boolean,text,text,bigi> /PGRES_FATAL_ERROR/ERROR: function substr(text, bigint, integer) does not exist LINE 3: substr(alphabet, ((bit_buf >> bit_count) & 3... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: chars := array_append( chars, substr(alphabet, ((bit_buf >> bit_count) & 31) + 1, 1) ) CONTEXT: PL/pgSQL function base32_crockford(bytea) line 24 at assignment SQL statement "INSERT INTO merchant_reports ( |
|
|
Added cast, should be fixed, needs testing! |
|
|
Will test with a newer version v1.5.x, in v1.5.0 taler-merchant-httpd logs just like this (other instance, other IBAN) -- that is, issue is reproducible for v1.5.0; in case such info still needed, here you go:[...] Mar 09 18:04:00 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO account_kyc_get_status returned 1 records Mar 09 18:04:02 betel taler-merchant-httpd[548657]: (GR6EDZ3SCSCGFPYSGAQBD5ES3G) INFO Handling request (GET) for URL '/instances/merchant_kycauth_1_5_0/private/accounts/0C4CV7WZXQGY3MK2X8QKWK6D43J6GZBX828XG562XBGMGPPEMJFT3CV4EYJGQR3A4QF1M7WNPZW4GEVT1FPPS21E0EW16WAV80MP3Z8' Mar 09 18:04:02 betel taler-merchant-httpd[548657]: (GR6EDZ3SCSCGFPYSGAQBD5ES3G) INFO Request for `/instances/merchant_kycauth_1_5_0/private/accounts/0C4CV7WZXQGY3MK2X8QKWK6D43J6GZBX828XG562XBGMGPPEMJFT3CV4EYJGQR3A4QF1M7WNPZW4GEVT1FPPS21E0EW16WAV80MP3Z8' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (179HT703XXE1E62DS1REKAGBJW) INFO Handling request (GET) for URL '/webui/' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (179HT703XXE1E62DS1REKAGBJW) INFO Request for `/webui/' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (4GJDJ1R4JFN0N1FMZT08GAT2WR) INFO Handling request (GET) for URL '/webui/index.js' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (4GJDJ1R4JFN0N1FMZT08GAT2WR) INFO Request for `/webui/index.js' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (988Q30P3ESRB42ME2JAQWDBR9C) INFO Handling request (GET) for URL '/webui/index.css' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (988Q30P3ESRB42ME2JAQWDBR9C) INFO Request for `/webui/index.css' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (D1E2707904GKQA4R4JCAY10D7C) INFO Handling request (GET) for URL '/webui/' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (D1E2707904GKQA4R4JCAY10D7C) INFO Request for `/webui/' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (61YPNC1DXC9JMFXRFV22887YA4) INFO Handling request (GET) for URL '/webui/' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (61YPNC1DXC9JMFXRFV22887YA4) INFO Request for `/webui/' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (4YGAGZNX9N9N5V3AC32MR8VM04) INFO Handling request (GET) for URL '/webui/index.css' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (4YGAGZNX9N9N5V3AC32MR8VM04) INFO Request for `/webui/index.css' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (A7GKJABJRE7Q6NBD9QQYRCGZD8) INFO Handling request (GET) for URL '/webui/index.js' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (A7GKJABJRE7Q6NBD9QQYRCGZD8) INFO Request for `/webui/index.js' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (DVW6FPKFGGTQZ6A7CZGE85D7N0) INFO Handling request (GET) for URL '/webui/index.js' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (DVW6FPKFGGTQZ6A7CZGE85D7N0) INFO Request for `/webui/index.js' completed with HTTP status 200 (0) Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (JRWN9CKP1FC6VECT2EXJP3N9R4) INFO Handling request (GET) for URL '/webui/index.css' Mar 09 18:04:06 betel taler-merchant-httpd[548657]: (JRWN9CKP1FC6VECT2EXJP3N9R4) INFO Request for `/webui/index.css' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (WH8CM9FGAWN9D9D0Q5SDZCQWAC) INFO Handling request (GET) for URL '/webui/index.css.map' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (WH8CM9FGAWN9D9D0Q5SDZCQWAC) INFO Request for `/webui/index.css.map' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (VET7N6N62PF23R6GBXZWN89QC8) INFO Handling request (GET) for URL '/webui/index.js.map' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (VET7N6N62PF23R6GBXZWN89QC8) INFO Request for `/webui/index.js.map' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (CB97654AFEJBFQ4DHCPFWX8S1R) INFO Handling request (GET) for URL '/webui/settings.json' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (CB97654AFEJBFQ4DHCPFWX8S1R) INFO Generating HTTP response with status 404 and code 21 (settings.json) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (CB97654AFEJBFQ4DHCPFWX8S1R) INFO Request for `/webui/settings.json' completed with HTTP status 404 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (NSKM28NQ4JN29SS91PQE7EX5CM) INFO Handling request (GET) for URL '/config' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (NSKM28NQ4JN29SS91PQE7EX5CM) INFO Request for `/config' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (WF60HCM0EA1YQEGV5106ZMD2SR) INFO Handling request (GET) for URL '/webui/XRXV3I6Li01BKofINeaE-34D53UZZ.ttf' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (WF60HCM0EA1YQEGV5106ZMD2SR) INFO Request for `/webui/XRXV3I6Li01BKofINeaE-34D53UZZ.ttf' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (QZ04NPDS18W6R36193Y14WVYQG) INFO Handling request (GET) for URL '/webui/logo-2021-VSZSJ4QZ.svg' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (QZ04NPDS18W6R36193Y14WVYQG) INFO Request for `/webui/logo-2021-VSZSJ4QZ.svg' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (3S96SD3TETCAQTESTNJ84N42BG) INFO Handling request (GET) for URL '/webui/question-RJEDR5FJ.svg' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (3S96SD3TETCAQTESTNJ84N42BG) INFO Request for `/webui/question-RJEDR5FJ.svg' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (QF9QMMYZ7FPPBQ01Q9EMV3AAA0) INFO Handling request (GET) for URL '/instances/merchant_kycauth_1_5_0/private/accounts' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (QF9QMMYZ7FPPBQ01Q9EMV3AAA0) INFO Request for `/instances/merchant_kycauth_1_5_0/private/accounts' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (YTPW58V00N0T94R92TD93B5M84) INFO Handling request (GET) for URL '/webui/languageicon-LWKRUH5D.svg' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (YTPW58V00N0T94R92TD93B5M84) INFO Request for `/webui/languageicon-LWKRUH5D.svg' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (JW63FJJ9TXD0P6N3VSW2VKR03C) INFO Handling request (GET) for URL '/webui/materialdesignicons-webfont-4.9.95-7W2GKO6O.woff2' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (ETA72RCVTB66JCFDMRB73WCE64) INFO Handling request (GET) for URL '/instances/merchant_kycauth_1_5_0/config' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (ETA72RCVTB66JCFDMRB73WCE64) INFO Request for `/instances/merchant_kycauth_1_5_0/config' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (JW63FJJ9TXD0P6N3VSW2VKR03C) INFO Request for `/webui/materialdesignicons-webfont-4.9.95-7W2GKO6O.woff2' completed with HTTP status 200 (0) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Handling request (GET) for URL '/instances/merchant_kycauth_1_5_0/private/kyc' Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO KYC status requested for format application/json Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Checking KYC status for merchant_kycauth_1_5_0 (0/(null)) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Got 1 KYC records Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Account has unknown KYC status for all exchanges. Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Resuming /kyc handling as exchange interaction is done (200) Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO account_kyc_get_status returned 1 records Mar 09 18:04:07 betel taler-merchant-httpd[548657]: (4WBKK7TTBZC61XPKESWEYEGFCG) INFO Request for `/instances/merchant_kycauth_1_5_0/private/kyc' completed with HTTP status 200 (0) Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Handling request (GET) for URL '/instances/merchant_kycauth_1_5_0/private/kyc' Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO KYC status requested for format application/json Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Checking KYC status for merchant_kycauth_1_5_0 (0/(null)) Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Got 1 KYC records Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Account has unknown KYC status for all exchanges. Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Status unchanged, not returning response yet Mar 09 18:04:08 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO account_kyc_get_status returned 1 records Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO Checking KYC status for merchant_kycauth_1_5_0 (0/(null)) Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO Got 1 KYC records Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO Account has unknown KYC status for all exchanges. Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO Resuming /kyc handling as exchange interaction is done (200) Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO account_kyc_get_status returned 1 records Mar 09 18:04:15 betel taler-merchant-httpd[548657]: (YE60DR3S2M4P95WTTMCG1W9YD4) INFO Request for `/instances/merchant_kycauth_1_5_0/private/kyc' completed with HTTP status 200 (1) Mar 09 18:04:23 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Checking KYC status for merchant_kycauth_1_5_0 (0/(null)) Mar 09 18:04:23 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Got 1 KYC records Mar 09 18:04:23 betel taler-merchant-httpd[548657]: (T2KB0VS68HD2Z0GBW03280TPGM) INFO Account has unknown KYC status for all exchanges. [...] taler-merchant-v1_5_0-kyc-auth-prob-3.png (258,685 bytes) |
|
|
This looks better in v1.5.2 now, pending KYC auth process. taler-merchant-v1_5_2-kyc-auth-prob-presumably-solved.png (80,424 bytes) |
