API error for changing MariaDB user password

davegaeddert

I'm having trouble with the password change API and can't figure out what I'm doing wrong. I get an "Invalid input" error but can't figure out if that's a password pattern/validation error or if something else is off (I think noticed another area of the API that took a different input format than what I saw in the docs).

Anyway, here's a basic example in Python:

response = requests_session.post("https://my.opalstack.com/api/v0/mariauser/pwdch/", json={
    "id": maria_user_uuid,
    "password": "Testing123$",
})

Which gives me: {"errors": "Invalid input."}

I tested the same password (and others) in the UI and it it validated fine.

https://my.opalstack.com/api/v0/redoc/#operation/MariaDB%20user%20password%20change

Thanks in advance!

sean

davegaeddert I think the password change API takes a list of parameters so you can change multiple DB user passwords at once, eg:

response = requests_session.post("https://my.opalstack.com/api/v0/mariauser/pwdch/", json=[{
    "id": maria_user_uuid,
    "password": "Testing123$",
},])

Can you please try that and let me know how it goes?

sean

And yes, we know the API docs and responses need a lot of improvement. We'll get there!

davegaeddert

Thanks @sean! That works. I should have tried it... you're probably aware but that's the same as the discrepancy I found with the domains API.

sean

davegaeddert yep, that list stuff is in a few different places. I think any place in the dashboard where you see a button like "add another whatever", the underlying API is using a list as the input.

The dashboard UI uses the API for almost everything, so if you get stuck on a particular input feel free to open your browser console and watch the XHRs for clues 🙂