[Console]: Getting database error while fetching AMT hardware info

[amarnath-ac]

In console, Getting database error while fetching AMT hardware info.
AMT hardware info output:
curl -s http://localhost:8181/api/v1/amt/hardwareInfo/ | jq .
{
"error": "database error",
"message": "database error"
}
Also, observed same issue with other AMT API's.

curl -s http://localhost:8181/api/v1/amt/features/ | jq .
{
"error": "database error",
"message": "database error"
}

OS: Ubuntu 22.04.5 LTS

Analysis:
Recent database migration added nullable password columns, but the Go code was scanning directly into string types and attempting decryption on empty values which is leading to database error. mpspassword and mebxpassword are empty.

[sudhir-intc]

@amarnath-ac : could you please update with which version of DMT Console you have observed this issue. Additionally please capture this: Whether this was fresh installation i.e. no prior DB exists or was it kind of migration scenario

[amarnath-ac]

@amarnath-ac : could you please update with which version of DMT Console you have observed this issue. Additionally please capture this: Whether this was fresh installation i.e. no prior DB exists or was it kind of migration scenario

Issue details are in #728.

[amarnath-ac]

This issue is fixed with PR #753.