update_brat_parameters failing for some users

[MattReimer]

@tyler1218hatch is trying to run scripts/update_brat_parameters.py using the brat_data_steward

but he gets:

Seems like maybe a permissions problem?

[tyler1218hatch]

@philipbaileynar Any updates on this? If there's a quick workaround for this, let me know. I just need the watershed parameters updated for this one run.

[philipbaileynar]

Sorry @tyler1218hatch

I just set a reminder to do this at 9am. Should be quick.

[tyler1218hatch]

Thanks!

…

On Mon, Jul 19, 2021 at 7:45 PM Philip Bailey ***@***.***> wrote: Sorry @tyler1218hatch <https://github.com/tyler1218hatch> I just set a reminder to do this at 9am. Should be quick. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#339 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGOUNLZDXEU7JOPS6WZKF4DTYTBL5ANCNFSM5ADPX7VQ> .

[philipbaileynar]

@tyler1218hatch I do not get this error. And I have confirmed that brat_data_steward can indeed read from the watersheds table.

What credentials do you have in your .env file in your Python environment. DON'T POST THEM HERE. Perhaps give me a ping on Google Chat or BaseCamp to discuss.

[philipbaileynar]

I have tweaked my setup so that I am now running update parameters using the brat_data_steward postgres account. I get past the error that @tyler1218hatch was having but then it fails for me when it is trying to determine the primary keys of tables by reading from the postgres information_schema.table_constraints table:

https://github.com/Riverscapes/riverscapes-tools/blob/master/packages/brat/scripts/update_brat_parameters.py#L74-L80

Running this query on the root account returns rows. Running it as data steward does not. Which then causes an error in the script.

[philipbaileynar]

Script was tweaked. No one reported the error in 2 years. Closing.