Veritas-bu

Sv: [Veritas-bu] What database to track customer / billing info.. etc.. (Solaris 8 /Netbackup Datace

2003-03-14 08:45:42
Subject: Sv: [Veritas-bu] What database to track customer / billing info.. etc.. (Solaris 8 /Netbackup Datace
From: plb AT iotk DOT com (Peter L. Buschman)
Date: Fri, 14 Mar 2003 14:45:42 +0100
Paul:

Here's another option to consider:

If your database is on a Windows box already ( assuming it is NT or W2K ), 
you can install
a NetBackup Admin Console on the box and, by designating it as a server in 
the bp.conf file
on the NetBackup server, have full access to the NetBackup data via the 
command line.

NBUX is tested and works well natively on Windows NT and 2000 while ODBC 
supported is
included with ActiveState Perl.

I don't have any scripts written for populating a database with NetBackup 
data, but that's
really the easy part.... define your schema, read the data, and use SQL 
insert and update
statements.  You then have a billing database and application that are 
independent of the
NetBackup server except for data population.

--PLB


At 01:57 PM 3/13/2003 -0600, Paul Boatman wrote:

>Hey guys,
>
>Thanks for the replies. I am not really a Unix guru, and one of the
>challenges for me is.. my only access to the Solaris box is to SSH. So
>interacting with this database on the solaris box is going to have to go
>thru ssh. I will read up on mysql and see what kind of interface it has.
>The interface is going to have to be pretty much as dynamic as access,
>but be located right on the Netbackup Server (Solaris)...
>
>All of the class and netbackup info can obviously be read only, then
>the fields which we will need to edit will be for our purposes only...
>such as billing account number and customer contact person, alternate
>contact... etc.. etc..
>
>This is a huge priority for us, any more ideas would be much
>appreciated ! !
>
>- Paul
>
> >>> "Michael Graff Andersen" <ida3248b AT post.cybercity DOT dk> 03/13/03
>12:34PM >>>
>Hi Poul
>
>You could use some of the CLI commands to populate a mysql or similar
>database on the Solaris box.
>
>Another way I have seen done is to make a tape pool pr customer and
>then charge pr used tape/GB.
>
>I don't if NBUX has something like this, try to ask PLB.
>
>Regards
>Michael
>-----Oprindelig meddelelse-----
>Fra: Paul Boatman <boatm005 AT admin.ndis.umn DOT edu>
>Til: veritas-bu AT mailman.eng.auburn DOT edu
><veritas-bu AT mailman.eng.auburn DOT edu>
>Dato: 13. marts 2003 14:43
>Emne: [Veritas-bu] What database to track customer / billing info..
>etc.. (Solaris 8 /Netbackup Datacenter 3.4)
>
>
> >Hey guys,
> >
> >What database do you guys use to view customer and billing info along
> >with class / client info ? Where is the database located (seperate
> >server, right on the master, etc..) ?
> >
> >We currently use Access DB on a windoze machine, and unbelieveably,
>we
> >have to update the class or client info in Netbackup (running Solaris
>8)
> >and THEN WE HAVE TO GO INTO ACCESS AND UPDATE IT A SECOND TIME in
>order
> >to keep the records straight... I think this is crazy.
> >
> >Any suggestions ?
> >
> >- Paul
> >
> >
> >###############################################
> >ATTENTION - On June 1st 2003 e-mail addressed to @cafe.tc.umn.edu and
>@admin.ndis.umn.edu will no longer be accepted.
> >Those e-mail domains are being replaced with @groupwise.umn.edu
> >Please start using @groupwise.umn.edu.  Thank you.
> >##############################################
> >This e-mail and its attachments have been scanned for viruses.
> >OIT/NDIS -  University of Minnesota
> >
> >_______________________________________________
> >Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> >http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
>
>
>
>###############################################
>ATTENTION - On June 1st 2003 e-mail addressed to @cafe.tc.umn.edu and 
>@admin.ndis.umn.edu will no longer be accepted.
>Those e-mail domains are being replaced with @groupwise.umn.edu
>Please start using @groupwise.umn.edu.  Thank you.
>##############################################
>This e-mail and its attachments have been scanned for viruses.
>OIT/NDIS -  University of Minnesota
>
>_______________________________________________
>Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu



<Prev in Thread] Current Thread [Next in Thread>