Ignore:
Timestamp:
02/07/05 12:00:47 (20 years ago)
Author:
Kris Deugau
Message:

/branches/stable

Updated CustIDCK.pm and checkcusts.pl with new billing server
due to old machine being rather unstable.

Location:
branches/stable/cgi-bin
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/stable/cgi-bin/CustIDCK.pm

    r151 r156  
    3636  my $dbh;
    3737  eval {
    38     local $SIG{ALRM} = sub { die "failed connection to billing!!" };
     38    local $SIG{ALRM} = sub { die "failed connection to newbilling!!" };
    3939    alarm 3;    # 3-second timeout.  This may be too aggressive.
    4040
    4141    eval {
    42       $dbh = DBI->connect ("DBI:Pg:host=billing;dbname=custids", "cidcheck", "c1dch4ck");
    43       die "failed connection to billing!!" if !$dbh;
     42      $dbh = DBI->connect ("DBI:Pg:host=newbilling;dbname=custids", "cidcheck", "c1dch4ck");
     43      die "failed connection to newbilling!!" if !$dbh;
    4444# Not certain if this is needed here.  It doesn't seem to be.
    4545#      $dbh->ping;      # Gotta do this to "force" a "failure".  NRGH.
     
    4949  };
    5050  alarm 0;      # avoid race conditions.  May not be needed here.  (Hah!)
    51   if ($@ && $@ !~ /failed connection to billing!!/) {
     51  if ($@ && $@ !~ /failed connection to newbilling!!/) {
    5252    $CustIDCK::Error = 1;
    53     $CustIDCK::ErrMsg = "Failed connection to billing DB host!  Unable to verify CustIDs.";
     53    $CustIDCK::ErrMsg = "Failed connection to newbilling DB host!  Unable to verify CustIDs.";
    5454    return 0;
    5555  }
  • branches/stable/cgi-bin/checkcusts.pl

    r128 r156  
    2626
    2727($dbh,$errstr) = connectDB("ipdb", "ipdb", "ipdbpwd");
    28 $IDH = DBI->connect ("DBI:Pg:host=billing;dbname=custids", "cidcheck", "c1dch4ck");
     28$IDH = DBI->connect ("DBI:Pg:host=newbilling;dbname=custids", "cidcheck", "c1dch4ck");
    2929$sth = $dbh->prepare("select cidr,custid from searchme where not (custid='6750400') ".
    3030        "and not (custid='STAFF') order by cidr");
Note: See TracChangeset for help on using the changeset viewer.