From 85c2ddbd1de869de87001bbf16b50dd63ac4b6a1 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 26 Apr 2001 02:20:41 +0000 Subject: [PATCH] arg --- fs_webdemo/registerd.Pg | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/fs_webdemo/registerd.Pg b/fs_webdemo/registerd.Pg index 996ac8b23..7fa4c9a3d 100755 --- a/fs_webdemo/registerd.Pg +++ b/fs_webdemo/registerd.Pg @@ -1,6 +1,6 @@ #!/usr/bin/perl -w # -# $Id: registerd.Pg,v 1.5 2001-04-26 02:18:15 ivan Exp $ +# $Id: registerd.Pg,v 1.6 2001-04-26 02:20:41 ivan Exp $ use strict; use vars qw( @@ -85,14 +85,17 @@ while ( 1 ) { my $username = $row->{'username'}; my $email = $row->{'passwd'}; - $pdbh = DBI->connect( 'DBI:Pg:host=localhost;database=demo_template', 'freeside', 'maelcolm' ) + my $pdbh = DBI->connect( 'DBI:Pg:host=localhost;database=demo_template', 'freeside', 'maelcolm' ) or do { &myerr("$username: ". $DBI::errstr); next; }; - $psth = $pdbh->prepare("CREATE DATABASE demo_$username") + my $psth = $pdbh->prepare("CREATE DATABASE demo_$username") or do { &myerr("$username: ". $pdbh->errstr;); next; }; $psth->execute() or do { &myerr("$username: ". $psth->errstr;); next; }; + $pdbh->disconnect + or do { &myerr("fatal: $DBI:errstr"); die; }; + open(PSQL,"|psql -U freeside demo_$username") or do { &myerr("|psql -U freeside demo_$username: $!"); next; }; open(PSQLDATA, "