智慧经营验签失败解决

智慧经营验签失败解决

1,cms_biz_info表

确定以上两条数据PASSWD是否正确

image-20241011104540815

以上两条数据修改为如下信息:

'pay','Wtwd9ciZxqVUrsmNuh5PGUuuE1S7u1M5bwRPMw0RPLq6YdUDWPJakw=='

'spay','xOW4q6qvLBPqMoYl6kH+Djzlu7srVrdwigG6FAw35YbFAbmMLXydBA=='

2,cms_biz_key

插入KEY_NAME为 default 和 UCCB的三条数据()

UCCB表示乌鲁木齐,需自行替换为本银行对应的KEY_NAME和DATA,default 的两条数据按照以下数据插入即可

image-20241011104649007

INSERT INTO CMS_BIZ_KEY (ID, BIZ_MODULE, KEY_NAME, "DATA", KEY_FAMILY, VERSION, CREATE_TIME, MODIFY_TIME) VALUES ('4','spay','default','hVeYogMKddADx/adszEavINA1UEnWFGPTB7rbOSxsCrxmHXFzKHE0fg3qRCAncIzZaWtYEh0C+33Xj61HycldzQQTjgrjQQRcOKq/MIl5ti9IW3Kx8/4jW5XIxNv6bI8VjCGezOIOhQcKRbtpy53HC6d27N/MdfVkYzxH9XhV6WWuz5qoio1kj8MFjEvwu6j+oZ2pRQJwi0QJjlHZoz1h6DWfX5noZsGTF6x5eF0FH9r4Yl4lMGhbtCwW8/ki7Rd80RfuJc40mzghA2wAgTOSVdh2rAIQDmC7W41Zza35Ph5KBYT1JUX5pL4k9bIuwmoT/8qBd7RFkpLLeHJh0U2FsSQ4l1BicFYEtEFVHyo0mZIcOg0ascUvihszrUjRCp1/na30uhgKOX5A2m3n43zQsKfWqp+nb6xIwtKxzKXp6xdTIXuCESjZpl6EO7bpxsoA6wlkfekGR4rpajFPlkmsFJqhLDXR9Q1/yR8BjPqotbFV3gXgyTdM+/j+efhDxJRWc2SjpdMho42HLEBmzBxKjTW1JDPvDYxISz8sUb+5xvxy4Iw05r0Oxla1MRq0PrAiuEJGoW0ffcQp/HvRuvJe6PSUX1B1eMXChcVoj3ESabtG3nSd31pK9/UGhe83U8rRiu+Qwmo/6VVSUWm8sQLlbhxw8XrZi8j8122WpzIfPB24Q6tNKSA3CabOvcIChmWFNnv6Ggq40YofwOsuZAeEZKuJ+Op9IVniXOyfOuqYG8W360OZLo3GFilBeVGzsZIogerYB3JP7tuemLV2ZrMM2OiBsbKkZezyMebIj3q3db3QE+Xvca0kWf7Ewen+lnRePTYVMkvgmZyY/n6/VfkGeAJqPRSk01xlHTpZSnDR618UVfhPBJAMLu9uPkHWyf8+ki+P+tmWtapD3dvzcDOusxnRgIXL6DxxLOTiEMHwcwQmGb4FukxW0Z+L3IZNYo/gMFpDKzwYWxCWVM7K5R/e2RmE0KVIR466VHQP/X8t5z3HZj8wR2TStAa9Hkq3kXEe4Eo/BmWssEImtZhPZtubP/AMJzRxvbVv8LSU/nlfM64Ru7ZCmriQ/jLfLd3fvphRh0mTYLqkQMaSVfr34cLrz34hCBsymD1wc2+28iJPPn3H+1vjolmlvgJ9hqObjxB1tWBIMuiNJQDyPSYDF0ma1CJkOzgCOrtBfNWAWEyolozZJJyVNqYrPr47nWzM+5jron2sJZIsevhl2sWAUtqwo86TYDY52hMvZrsdaeLR654XA+x+H2PEQFMhFiH/K1JzxAgEzNGeo2IFTBWYckMnrxXNhq6dbm7u+SZDWdtieis6d0vevJIwBgqOAkPf37N4I0X6nV2HtejR4TlOGK3HfebHBizKE1PBCu8WYyPesiM+vFiMycceQUgAp1OOpJifrA/8mrC81ReWLmu/ySS3IYOQzmeL4Cf7RIp2BZDA5BdalduvrDzBv5w3ncLXdPik1tlvia8yU9v3ez2Ds1BpCz0j54ew3NV7ef9HwbL0At0XlwpOjfEnsY1GSlRqCQVKdGpGi8Px+OIoYbpEJ/QTVwoijkoeau+wmmeZiP6f6pc57ucXD21v4/mUSjmKGlXael4xNDfgZ76H8GpcEUOKFDGvcKFlpo211QfEe3uTCrgvqrQNOw2wWwZIoRSVilCoKNk4SfQh1sEzxPRJ0PF6AK535BkgJqxV/OinII9k1+i/gFWC2UnHN1+fJGJBeVCgNC79X/rdEJSnJ0lWz+c0VGSKv3DuxUPmPo6chLZcTx14CQRAqaKuwUZ0tNJnFCi+BdJpOG6crMo9SrIHPvLMHA+z3j1mio5DQV1T4oEmFJ673iPQN7yWmJISrcokd5pQWyxe7xiTQoDBmtY99H/ehDxZO7qlzzJfSNYLRhRlV3zgCBR37pT05L+vWPaIqq+M5B8jHz9Etc4KeASmN2npKaCp0IONP6orvFonEtwL3mJF0bamj93mu022PcROvTd5IEOb+9QogF8TcIb5bkEBdt5b6DX8+a3rzIhZcJMNAehn7WxmB5d6uhyLzP7JXcS6hjdip4nmWJmWFvDOUEs1/JHUIZtzuH+sE+c89eTmWo20PMZSO9CzwbVXlQLh9tOHuvMVmkUyLOAcCqbHBoHx21zlMcxPJUCnS8OcI+ULu7w1zzouM53LOHg/u4bsyyStpogSKWqXjqE98ewAqBqZHyB317aEwzZHgzaxfAgIvNabyWbalSxGPKQCifu9mO65kURNsshb1elLvflXUGuqcZudynvCaeJ3xuUdtJatdNdli6YyWKbe2Pxi0Gj4aM0V0tON/4dsQ6EGsIqBJ7oQ5htpPfNA5otxADxbmCQhFJy7AP4kSIdJICfpOEjOymHpabu1+NWavdyCXb876qx3BCG3XnsvzcAeOiue09MhA/ypcuDgUQLRvJM/I7u6uaKLv9G1qaehKpoV61Gi/fGz+nEqmVmsCX2MLKJDfPB95p96h24jFDnBQY+VReSb2qDNJdmLJ/DBV327rOlUc9fRWMq4Y1oZGa8kOCHTQ7UkknL9YPEIZJ1ijw2Zru/Dv+pfKFEUzIkTp07G6UlDMM5U3N6h1rU4J7nYDrdrUt7MZGG5NddC9nbZ9c8yKg/+e41FGUL5h1wi31dKP8tgdjLMIVSkJLIZiqfDcH/+K5VeGpb6XftNd8Js7Kq3XSOUJYjwZp4BKurm6ilvV2t1Mc5q7Ss2o3Un9rJQK8szGKUDrpG+aMGxbaZsA==','RSA','1',TIMESTAMP '2023-04-25 15:55:12.801000',TIMESTAMP '2023-04-25 15:55:12.801000');

INSERT INTO CMS_BIZ_KEY (ID, BIZ_MODULE, KEY_NAME, "DATA", KEY_FAMILY, VERSION, CREATE_TIME, MODIFY_TIME) VALUES ('3','pay','default','AtjPFPeFAk+eF259y5IJMGC83N5uUTile6KzUtk7NhL7KM5fTx1L3FMjhkhGbuFnOrpvpsC10ymU5ogydiPqcZ4kt0elgurbHjAwb0hLmv2JsnLoVOGavvKsTv7aPGhB7S6WnHyRtJTPej9FoULsQ2OBz/l5rr/F/qFQNOtZjkC1TXxnfmaDfPLR8jFeGNOdmij6/c2KFbeio4ntmZ1fcPb9279TJgsbhM1U1uEuSRPta9RMEdySvpZkOevkV0N8JLlz0oBYBgLzZHazcxEYIxLZx/cC5BuZwACbJg44VyjOELgSKt7hh5gLUHmd49Eb+6MiU6gOF84zH/WroiDilb1THWnSfjqczQRPAISHL5kiGT74J3bvF8bbZMcaxVnJQXy5q2p1iBVUsB7ydw5O8XA7UrlNs0WnYh5miUQGfC2HNakC4IqOLDWLmHnuc5OQm9LYezhf+R32NXRM/izuHco4tKiv9+aF60S4fToyKhBY4IXmkqrDMcrU3+duhPhwprONFkfc24HiF0R8JS5ezCWrD3PxTsFuRiHDljuYrl57dDdKJZaN2TqloujFuu/OTwTzJSr8KhkxWCKa997qQrougnLCDp9KlcVYvrjjKSYI1aP6cBoW4OyklslX6I8CX4ycMjTURHg9EYhVDDrHFpZN1go+Hc34cSpnsxgRycKU9/CNOAh8FMusA6Q/Dsin+L7F8mn2ViMqNmpE+iN5QhP5PppnlxkjrsAKm0KMqfo+n9Kd7DGQ1qcHcvbP+hH5FYmXmkjyyVAcWdujHVlQShaBiiHkBhun7dOEqhMgOZcNjbkh2yMJyoTsoZ6AYFsP5p7Jej4hdfbTrUDEGDhRVZ8SV/ltx2eq4ACrYICAiOmoc8r8GmFiz9ZFzmNSjiMQnbDcQA03bODwfoIENUHCf5dvxixZ1qXhtKnMb7dqS1jOvJ699JfX/N1Mz+vcZ9gWNksUbjLeknsFS1XySeGE/e3f7IAKTyIPdynrPL6FLTW5uT8wjZgN5MqzLwZkxIu8xySKwMZAq0f8nF5KgflF6fgoAy0NGxbBMjJtnX0JtJ+hNgT1ywt9OnkLuYGaFcNK26m/9A6ZG/9AUxS1FR/wHyajFNuffiNHpY+Tk2s7sGxUwkpNEsCUbCTfQAgExVONNfnz5dgnAJESOaNDLE5ReW9VR+BCU8iIZIR6Xem2elQ5i6j0DD1Cr2+wyGYr4i9EFfNJqo+3LFcEhKHb4Un9RuTHL+OSyL3nVLwj0/K2q1h4cgpXqqtffaMiFZ9piHgePugLM4peqNx5ALnM/tjyF7m4EsR/IZb5k7tVh+YTM/9dBbkEsU0Sbt2nHWgAWa2f5RQyJA576rf379Zcd9sMHgDuDkEeZE7hpWxjqPM81Lyycikx3OUo4I37qj7Q63WdonQbSHYBNuwYUMRxNKTDwLsmXYG5pj01XGJpNOtAec03qkuPYGiV8GQ2WT/3qi0182IC5ZYrLicL7hC3yPJEL04i4H09RHn59AIjGkFDayMtthHp3nEYbsBXp2lrOhIA7L1UuMdhIfuWj78vYf/DDvHEVqkiDqw7uHaCT2KFwv2EArGNw7BuVGggku7mtxw6u2deSSZnLJCcDjC3tXU70EpMZYnrVUqHHZNWVm1yIRQDjZCpwQ0WMe1Wp1xUowyrPECCgyCHeKlNRjECWgFsRvByPfadGnTOPNux7pxK/Cfy/Uhgu6eoxBHiqfPGrdfnnHGtuvbZ+p2eAwkMpCXCR4FUxsm+lHl4dk2BEeChW63ZSIrvJefWRAqwS5wG+yv8M7+4TNff0CHjVRZb5pkaGTmFgb6vThUifwYm8rRoGlYpGFxhGkoliBWxivlD/0sbSt30LkDhtf2Y0HMeR77EIxek+5++xGOFIhDj3aj7G+Q1mexVdjaXWLuf5LQzforu36SexyuLapB3yrxM9aoqO+kVitqkDZiIHC6tDhbel260/Bq4wOjiNEcggC76fI/MbtfA33qzYeYieK3xdTkPMbW+9Z2drzruXJh/+WAAohzvsNX0nocUQnKbX1YfHR30o25eNUjIFRysiHAvJFojEze3p7u1faOcFecwulzJR4aNuggaPJOyXL8c4SBE5HwmnJcTNdk8KhmRPl6zWhp2L1GsWB4PsfSzsI6KHnXT6yWRlAo6709gWlr5AlefRivQZ0mWqyiMTA9R4gyRyrsSC1+hqvcc8AqlKph5EapPcFy6eUsLar35t7MdD0elusSqT/BDQhnrc1MUTTnUaCs8GBYSQrG5EnAiA/fzDtIa/JKEKjSN0OdHyBm7c0NvEnAIKzMiB/RVuO/SIppq9K5PCEnqNAgdDtt1tTRNozXWw5Ts7anOY8ecZhOmGtSSR7WU3+ULDEjEynEg+Jw2402Nvkyq+tY+pOeMb+J+V220QtsJxhqrwNMcND/ogI+hwSJV1mLUP43q6xLD/jh4+QxSclC97oWvWYV6zvi7OVYBNeRYRkTFPIpHvzuWrAmSsP6q8fQtgvfaPwBbAh4UED4eMnd89ZuGL86GjhU31uKr1qNlv35m5l+kEWoBZx9zPPuvJ4LnBkzsBUZwYdkzuM2tXD5oSSAU7owEs7fIi7Ak7oj8dBSqmTRhoVVgapUEdAj3F03fMxLLbDGbYzS8besxilf1OcovhsTrPW91XE7HAR2owPO+4bZB5v8HUvUlhnCg3+2xDBlhLDa2FTvyYOci2Vp5+19HjYv+uksMKu8rcwt/iJGcthqI+w==','RSA','1',TIMESTAMP '2017-12-28 20:02:40',TIMESTAMP '2017-12-28 20:02:40');

INSERT INTO CMS_BIZ_KEY (ID, BIZ_MODULE, KEY_NAME, "DATA", KEY_FAMILY, VERSION, CREATE_TIME, MODIFY_TIME) VALUES ('44','pay','UCCB','FvARRkwOsCLrv9aX+FHsFF6hSdFdCnod+buxr+8J6xOe2PT2pBafRvn0fqqU1voUpzl5KPoHpv/mv4X0IVDores29Mtp9OEVldD6lZNyhj3JgS3eIOiHIRqJ24k3TSBeVjfXL2IbLrujxbS0U+7dpPEWLoIlhpuNrnfPq04N4vAOE1WjRdbU8dtsHO39KhplGsscqQPw5rYjfGEQ9ftNI7akWx2r2bUaoZr7URO5CrpMOM0rsTLb+XDTKUYJhgat80Oj6riQgVhAZBX98yIPH9wSzB39/AZm5BOpBsO3uV8BIuXX+S7RMFPDtB5J71POadXDhKZHxGTNHeDnr8bwGCvEZISZlqnrWrBltu5yNTuarAhLrZGTMJx1DY1GCmnFHG+wL7oVZCSvlUVUQxyO6O9kX/5T13hwyYLSXEbmkEAlBeSMhP9NcpF2yopFBgOPuTZ+nw4niE7WzWMCxBb/WOcd1E78D3wU3YjFyJSqUbXhxyh/TL0+q6/7C51lyaRlILOOjyB7tt/hvZqR4+au9nIWioo9qWk0HwJxDwCABT1tK8q6bhUMG0yhfC9PRLi9l45Zp0nBm7+/qWsuSTSHOu+jkiUNr4U8eea3DNRmQ6e+U6PqWoRy/+3bo4+pOsa/8nFPlEmLHMQPp6/UIeBKoI8v1J7I2HjoCPEPHm/TbrD8alAWAukL/AT8FhG89wBsB3JWHBGfBV2vElw+UC0gkiest8oVcHsFab3wttGKh//uqSq1Jny/Qsz/3OzLuGHXoj9MXb2pV/ostZMBDoCutlxALLNf3EPMLytA3HNFEfdPxeLOzGpa7AHb1SjOnFoEOo9AQBgKCuFE8TB6SyJ/T48xH4HygXsrpmfrmeVoistwuhPCHlVDqoU9+g826Gp51QSoglYslva5uNft3LXgIeqxMA9olm2nxqhAgT7qyZDVVBmsS5NDMpbb2hyn20ceHscFQC6Kp9a+ZXNaleMUvwKQgc/Sf0AxwMlVu0hq4DsgSPdhoRisphakjMcCTQg2GJBLKFEtcyeJAHS6GJ38B48RonZIBquewXzQjGRasMOR8hkddNhJE1Kia7VeR4xy9mT/debSyd2Q0NyZD9ynnCGznlip+b4tj3BpSGG1dki9cqb+06hKqlRrJibgmiCuxWONwQpcoV57ujD/JHixupF0ZOwG6sshUHN10Zqh27ePoY87sMXtpbWt2uIKL6ttQijY8s2pIZbiKdU5bY4hP9wjwcls1ch95Qz8VuRYcxGhths4ZBtf1Na83XyZw+wQ5AzopcROA3Vioz7KQBOS+8h5LbV06CiPpD0ELM5hwXItNkTDUvRROTekFnKxM1HrTRrpSbe8RxRIdGtQMAv6+UHluf3z0FOVtG5TiBjWceh9ub9yVCxHZnSV/O3Sj0WABBY+QTyDHVb2o8p7Lm82ZdAIW+UAtOeLI7wiaWcQo7e1Xx7aAJ8nffTyZaYVyv17LjPj/MfTBi7Bhl5RQiL1KbWkOZaIvc4RZysP8B6GAzP7qxMZyfU3DQdvOa7N1Zgsz4p79dmAlZprMnPCNdsf+EyFZuZypRyFCaekt0i9yd5fKw4UVYKRnLDApi1xGtlXHPP0Uxx35rwHdudQDrOfVt4KJsM1x+cFi6+GoFXB2f6RF9/AdKDAzU/TaE5Wo0myd7fOYgWT5rLzS/OkjcJ6hML0jxXVCSBUN7qukP6joT91ATsN2zbKKEtfLewZqPYyWjBR2pKsLBYf3HuhUoh6l/J1SsG/whl2IemZgHEdOpZfy3KMPMqHZAW4w0RWpR3Gfpx3DFPTXXCx6o9tBYl/CLZf6SHCxAYUhEe3SH5V20kUDfvWZYUCoJv8w/3atz4u8YZVAyoh8u6Cm8o/GrBDE++Y9m2frcV7DF41uf9ivMCvLiJLOaIt5jquj2EAfahZrQUQDbiXaPLLRFXRtS5xjgglFZ4qA63UDai8oPvccz2Ex7HR3eyBsvUuKWMuod2EyzjX1XIqHIxM7GIt2T/7W5xbyMvs2LSJ5tYx/PLzcd7hDVbFpIjjPORpKzCQyybR1SzKLTHe3x7mWAvdO99iEY6zj1j9xdOsfJREmqyQrZ11XnGBnPbaTL7Y06nvSV4HcdmB+a+uZrvlU/F+xmfkxKpMZSY5YlYgXbPNEC64l+mvHaHdpXgf6n1XsH3q58ygEvbFnHFLIsQ6b42kFZWRhyRt9KDmYEJIpeWlflSiHEPWb1eM19k+H1r0qpO8+kPU/OA0bWCRcWe1H9Lasnzya4PCS1ZyR01DYR/n5mQM4GkyDfuYszEDkbTJXkQg6PUqCEv/Ep5SIveQjdmFkRcoBY4yz5VVmSVR2s7pF3YEM56kONCAG8TmrMHUij4O1+7Bzl5WrJe4V6Cpz290wh59mDRDNPLRNaD5pMVH0migvu5yZidXQiJx0DTw4f7yZUP7PWNeP2CRWeq62SzKMQuBKJ7tVAKhSjgHCdQbOqWeL7v0wLGWO95piV7HX64I4YILCbENLz+LHN65KKL1e/gagEsbIhbTvFCeK5GK1VRL/VIKM6tOMKBKAbvv8XltrbJG58b+bk3sxBjgc0KObjiqyGM90ioZybqgR607HRmmh8gLM3UxmLXetZe81TpFNNrv+k1pideFmsPpmkPD/9bFMRqtallrZMtWtjXS8TC3SfHJ0mxsi2sLbWQlVPQo3thWiP+/hId9hacJESrkg/zva4kHS2NehA85','RSA','1',TIMESTAMP '2023-04-25 15:55:12.801000',TIMESTAMP '2023-04-25 15:55:12.801000');

3,CMS_ORG_SECRET_KEY_PARAMETER表

确认箭头指向是否UCCB(这里UCCB表示乌鲁木齐需自行替换为本银行的)

注意:这个配置的UCCB需和cms_biz_key表中的key_name相同

select * from CMS_ORG_SECRET_KEY_PARAMETER;

image-20241011104959034

4,CMS_ORG_PARAMETER_CONF 表

删除 SPAY_PUBLIC_KEY_FOR_PAY这条数据

删除这条数据后,会以网关配置文件中pay.platAgent的为准。

select * from CMS_ORG_PARAMETER_CONF copc WHERE PARAMETER_NAME = 'SPAY_PUBLIC_KEY_FOR_PAY';

5,key-server服务

修改为以下值

key-server修改application.yml

keyserver.passwd: "b13bdfa1d135d96aa45ed4efd9946157"
key-server修改bizinfo_pay_scr.txt

4f03560864f283a0202182d8121d324c

6,paymain服务

修改为以下值

pay-main修改application.conf

wft.keyserver.pay.passwd="4f03560864f283a0202182d8121d324c"


pay.platAgent: {
    2: {
        name: "SPAY",
        usedGroupNo: 2,
        pubKey: "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1gngbYfueoAFhTEQtA2jYio58AH1QiIVBMSB8ARY9NqkHOVbjs7njivyaCdS1MqHf+2Eq/dfolzSCjcK4E8Cd9cgtQsGP1py6425GRPf1oCrrEUvhVazhZ87ZyxZ3Lum7RG6/XbUg5TzTmgA6J1GDE4RGu49t1UMuM2RheddsD6eSBED1SJ4AhR15kDLiTF/zMlx7PbokC9T/AjM3/qfs85A96b0eCcwCSvgvS3mgHeHgiqCv8pBESsS9mtwezaHLD4kaqyeuPyAuc85zaDCQyFhF/SyxXVlYHCOnipAzKdpKhdyczToSFeX8S2R67gsaMEL3YCjiD4kjrQcGTTbpwIDAQAB"
    }   
}

7,spay-service服务

修改为以下值

spay-service修改biz_config.properties

bizModule=spay
passwd=f67bb628996a5d8ea9abc5683412dfa7
keyName=default
bizSignType=SHA256WithRSA

8,upay-ags服务

修改

upay-ags修改application.yml

    keyserver:
      bizModule: "spay"
      bizSignType: "SHA256WithRSA"
      keyName: "default"
      pwd: "f67bb628996a5d8ea9abc5683412dfa7"

可以在keyservice服务中测试

curl -vi http://127.0.0.1:8001/keyserver/restful/bizKey -d '{"keyFamily":"RSA","keyName":"UCCB","bizModule":"pay"}' -H "Content-Type: application/json" 

记得修改配置后服务重启,清除redis缓存后再验证,不然足以让你怀疑人生

image-20241012160214839


日夜颠倒头发少 ,单纯好骗恋爱脑 ,会背九九乘法表 ,下雨只会往家跑 ,搭讪只会说你好 ---- 2050781802@qq.com

×

喜欢就点赞,疼爱就打赏

相册 说点什么