Tweet
Im not able to connect via ssh to my api users..
I've added two api users, exact same settings but different username (apikontakt and apiuser) and different api keys.
when trying to connect via
curl -i -X POST MYURL/api/v1/Lead -H "Content-Type: application/json" -H "Authorization: ApiKey MYAPIKEY" -d '{"firstName":"Test", "lastName":"Lead"}'
I get two different errors. With user apikontakt I get error 500, log data says:
[2025-10-14 15:01:14] CRITICAL: (22007) SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF3O' for column `crm`.`auth_log_record`.`username` at row 1 :: POST /Lead :: /volume1/web/crm/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
With user apiuser I get error 400 (couldn't even auth the key). Log data:
[2025-10-14 15:01:20] WARNING: (400) Auth: Bad authorization string provided. :: POST /Lead :: /volume1/web/crm/application/Espo/Core/Api/Auth.php(194)
I just spent two days on this, using chatgpt and searching through web. I still have no clue, what's happening. The usernames both are without any special characters..
Does anybody have an idea what to try next? I already tried regenerating the keys, clearing cache and rebuild in Espo Admin Panel.. Thanks for your time!
I've added two api users, exact same settings but different username (apikontakt and apiuser) and different api keys.
when trying to connect via
curl -i -X POST MYURL/api/v1/Lead -H "Content-Type: application/json" -H "Authorization: ApiKey MYAPIKEY" -d '{"firstName":"Test", "lastName":"Lead"}'
I get two different errors. With user apikontakt I get error 500, log data says:
[2025-10-14 15:01:14] CRITICAL: (22007) SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF3O' for column `crm`.`auth_log_record`.`username` at row 1 :: POST /Lead :: /volume1/web/crm/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
With user apiuser I get error 400 (couldn't even auth the key). Log data:
[2025-10-14 15:01:20] WARNING: (400) Auth: Bad authorization string provided. :: POST /Lead :: /volume1/web/crm/application/Espo/Core/Api/Auth.php(194)
I just spent two days on this, using chatgpt and searching through web. I still have no clue, what's happening. The usernames both are without any special characters..
Does anybody have an idea what to try next? I already tried regenerating the keys, clearing cache and rebuild in Espo Admin Panel.. Thanks for your time!
Comment