Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 52AE54758E0 for ; Thu, 28 Mar 2002 00:08:21 -0500 (EST) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id PAA15965 for ; Thu, 28 Mar 2002 15:11:52 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3CA2A4E1.1040607@oasis.net.au> Date: Thu, 28 Mar 2002 15:06:41 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.8) Gecko/20020204 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: psql and password References: <3CA27648.7060307@oasis.net.au> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/368 X-Sequence-Number: 7242 Hi, Thanks for the suggestions, I ended up using Perl and DBI. First I create a new database, then create a new user, then change owership of the database to the new user, then create and entry for Apache's htpasswd facility. Then the new user logs into the new database with there new htpasswd account via phpPgAdmin. Thanks again. For those interested here's my script. Cheers Rudi. Script : #!/usr/bin/perl -w use DBI; $DBH = DBI ->connect("dbi:Pg:dbname=oasis;host=moon","postgres","rudi2000"); foreach $_ (@ARGV) { # get name and pwd @data = split(/:/,$_); $thisname = $data[0]; $thispwd = $data[1]; # create a new user $sql = $DBH->prepare("CREATE USER $thisname WITH PASSWORD '$thispwd' NOCREATEDB NOCREATEUSER;"); $sql->execute(); # create a new database $sql = $DBH->prepare("CREATE DATABASE $thisname WITH TEMPLATE=template0;"); $sql->execute(); # change database ownership $sql = $DBH->prepare("UPDATE pg_database SET datdba = (SELECT usesysid FROM pg_shadow WHERE usename = '$thisname') WHERE datname = '$thisname';"); $sql->execute(); # create htpaswd account system("/usr/local/apache/bin/htpasswd -b /home/realmz/phpPgAdmin $thisname $thispwd >> /root/scripts/htpasswd_log.txt 2>&1"); } $DBH->disconnect; Rudi Starcevic wrote: > Hi, > > I'm wondering how I can create a database for a user from within a > script. > I have Pg in 'password' mode. > To create this database I'm trying to pass in the password from the > script. > For example : > > echo myPgPassword | /usr/local/pgslq/bin/createdb yourNewPgDatabase > > But it's not working. > I'm still prompted for the password. > > My goal is to create the database then change ownership of the database. > The user can then log straight in using phpPgAdmin. > > Can you see where I'm going wrong ? > Any suggestions ? > Perhaps I need to use 'Expect' or something ( this is a Debian box )