Changeset 37738 for trunk/ippScripts/scripts/stack_bkg_mk_mdc.pl

Timestamp:

Dec 10, 2014, 5:04:19 PM (12 years ago)

Author:

watersc1

Message:

Convert to use the correct way to get database information.

File:

• trunk/ippScripts/scripts/stack_bkg_mk_mdc.pl (modified) (3 diffs)

trunk/ippScripts/scripts/stack_bkg_mk_mdc.pl

@@ -13 +13 @@
 
 my ($dbname,$stack_id,$label,$camera,$filter);
+
+my $ipprc =  PS::IPP::Config->new(); # IPP Configuration
+my $siteConfig = $ipprc->{_siteConfig};
+
 #$dbname = 'gpc1';
 #$camera = 'GPC1';
@@ -29 +33 @@
 
 use constant DB_SOCKET => '/var/run/mysqld/mysqld.sock';
-my $dbserver = 'ippdb01';
-my $dbuser = 'ippuser';
-my $dbpass = 'ippuser';
+my $dbserver = metadataLookupStr($siteConfig, 'DBSERVER');
+my $dbuser = metadataLookupStr($ipprc->{_siteConfig}, "RO_DBUSER");
+my $dbpass = metadataLookupStr($ipprc->{_siteConfig}, "RO_DBPASSWORD");
+die "database configuration not set up" unless defined($dbserver);
+die "database configuration not set up" unless defined($dbuser);
+die "database configuration not set up" unless defined($dbpass);
 my $db = DBI->connect("DBI:mysql:database=${dbname};host=${dbserver};" .
                    "mysql_socket=" . DB_SOCKET(),
@@ -38 +45 @@
     ) or die "Unable to connect to database $DBI::errstr\n";
 
-my $ipprc = PS::IPP::Config->new( $camera );
+$ipprc = PS::IPP::Config->new( $camera );
 my $mdcParser = PS::IPP::Metadata::Config->new;