ansibleguy76 / ansibleforms

A webapplication to create pretty advanced forms to run ansible playbooks or awx templates.
https://ansibleforms.com/
GNU General Public License v3.0
66 stars 10 forks source link

error: [ansibleforms] Query error : Error: Unknown column 'use_credentials' in 'field list' #199

Closed birb57 closed 1 month ago

birb57 commented 1 month ago

Hi

I am trying to use your tool but I got issue configuring awx connection

when I try to configure awx connection with credential (login/password) I get below error message when I "Update AWX" :

error: [ansibleforms] Query error : Error: Unknown column 'use_credentials' in 'field list'

Thanks for your support

To reproduce try to configure an awx connection

When try to update AWX connection: Failed to update awx, Error: Unknown column 'use_credentials' in 'field list'

Build v5.0.3

ansibleguy76 commented 1 month ago

I will look into it. Thank you for reporting

ansibleguy76 commented 1 month ago

The docker compose project is updated. The use_credentials was indeed not present in the init script. This usually get's fixed in the code when it starts, but I cleaned up some older database patches and seems like that was one of them. In your case you will need redeploy or wait for the new release, where I will reintroduce the patch.

ansibleguy76 commented 1 month ago

5.0.4 beta (alias ansibleguy/ansibleforms:beta) is being pushed. You will need to change the image to beta, pull the image and rebuild the container. If all is well, the use_credentials patch will be applied.