Using subprocess.popen with multiple stdin to configure system : Python 2.7

Question

My goal is to configure my new AWS instances with a python script that installs my repositories and packages, then utilizing subprocess to configure, (in this case), postgres. Values are read from a yaml or json file. So far I have had success installing all the packages and repos for the environment. Where I'm stuck is a python script that will create a user in postgres then create a database.

import subprocess
# out is to show output, com is the stdin value(s) to pass
def run(command, out=False, com=False, ):

  process = subprocess.Popen(
    command,
    close_fds=True,
    stdin=subprocess.PIPE,
    stdout=subprocess.PIPE,
    stderr=subprocess.STDOUT
  )

  if out:
    out = iter(process.stdout.readline, b'')
    for line in out:
      print(line)

  if com:
    process.stdin.write(com)
    # http://stackoverflow.com/questions/16091112/python-pipe-to-popen-stdin
    # process.communicate(com) doesn't fit, i need multiple stdin

run(['ls', '-l'], True) # works 
run(['sudo', 'su', '-', 'postgres']) # works 

run(['createuser'], False, 'testuser') 
# broken, also after i get this working, this should be a list of stdin values    
# this results in infinite lines:
# Shall the new role be a superuser? (y/n)
# I do have a workaround, run(['createuser', '-d', '-r', '-s', '-w', 'username'], False)
# Confirmed workaround created user successfully

dstromberg · Accepted Answer · 2013-07-27 20:36:08Z

0

I haven't used Postgres in ages, but I'm guessing you want to su to postgres, and then run a command that requires postgres' rights.

But your run(['sudo', 'su', '-', 'postgres']) will probably just open a shell and wait; run(['createuser'], False, 'testuser') will likely never get run.

Instead, I believe you should combine these two commands. See the "-c" option to su.

Alternatively, and a little more securely, you could give your source user postgres rights in sudo, to take root out of the equation and make your code a little simpler.

answered Jul 27, 2013 at 20:36

dstromberg

7,2412 gold badges31 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Michael Benin Over a year ago

it gets ran. See the infinite output of: Shall the new role be a superuser? (y/n)

Michael Benin Over a year ago

So the best way to solve this, is not to run commands with subprocess that require multiple stdin's. I have a feeling this works in Python 3 though.

Michael Benin Over a year ago

Accomplished from this: github.com/muhuk/cuisine-postgresql/blob/master/…

Collectives™ on Stack Overflow

Using subprocess.popen with multiple stdin to configure system : Python 2.7

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related