登录报access_token异常
<p>1.问题:登录报access_token异常
auth日志里是账号认证信息为空
iam日志里是账号与应用不存在有效的绑定信息</p>
<p>解决办法:
1)查看是否缺少数据,更换rel_account_id
SELECT
accountapp.id AS id,
accountapp.create_time AS createTime,
accountapp.create_by AS createBy,
accountapp.update_time AS updateTime,
accountapp.update_by AS updateBy,
accountapp.rel_account_id AS relAccountId,
accountapp.rel_app_id AS relAppId,
accountapp.special AS special,
app.name AS relAppName,
app.icon AS icon,
accountapp.status
FROM
iam_account_app accountapp
LEFT JOIN iam_app AS app ON accountapp.rel_app_id = app.id
WHERE accountapp.rel_app_id ='83449694678887219200'
AND accountapp.rel_account_id ='bbfd4c04-62d5-4b5b-9dca-c0229d822ce6';
2)插入数据
查到登录用户对应的account_id,例如:P000038
SELECT ac.rel_account_id FROM iam_account_ident ac
WHERE ac.ak = 'P000038' AND ac.rel_tenant_id = '83449456322462924800';</p>
<p>更新rel_account_id,插入一条数据:
INSERT INTO iam_account_app(id,create_time,create_by,update_time,update_by,rel_account_id,rel_app_id,status,special) VALUES
('22341dd1-40dd-49f5-940f-75f274c52d49','2022-06-16 00:00:00','ISC','2022-06-16 00:00:00','ISC','bbfd4c04-62d5-4b5b-9dca-c0229d822ce6','83449694678887219200','1',0);</p>
<p>替换ak,完整sql:
INSERT INTO iam_account_app(id,create_time,create_by,update_time,update_by,rel_account_id,rel_app_id,status,special) VALUES
(UUID(),'2022-06-16 00:00:00','ISC_ADMIN','2022-06-16 00:00:00','ISC_ADMIN',
(SELECT ac.rel_account_id FROM iam_account_ident ac
WHERE ac.ak = 'smartQ01' AND ac.rel_tenant_id = '83449456322462924800')
,'83449694678887219200','1',0);</p>