Opened 16 years ago
Closed 16 years ago
#31 closed defect (fixed)
find_archives.pl - update to a/c for schema changes
| Reported by: | MatthewWhiting | Owned by: | MatthewWhiting |
|---|---|---|---|
| Priority: | major | Component: | web archive |
| Version: | Keywords: | ||
| Cc: |
Description
The perl script source:trunk/htdocs/perl/find_archives.pl needs to be updated to account for the changed database schema.
We will also need to change the way vap is used, as there is a problem running vap on herschel. Perhaps we could write out the table of additions to a text file, and then import the text file into the database via a command sent over ssh?
Either that, or find some way of connecting to the database (which resides on herschel) remotely, e.g. from tycho.
Change History (6)
comment:1 Changed 16 years ago by
| Status: | new → assigned |
|---|
comment:2 Changed 16 years ago by
comment:3 Changed 16 years ago by
As part of this upgrade, make sure the precision in the values is sensible, rather than positions such as -47:30:00.00000000000
comment:4 Changed 16 years ago by
| Summary: | find_archives.pl → find_archives.pl - update to a/c for schema changes |
|---|
comment:5 Changed 16 years ago by
The script is ready for use, but we are waiting for a cleanup of the data files before reading the full amount of data into the database.
comment:6 Changed 16 years ago by
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
This script has been replaced with a c++ program called DBUpdater, this program works for current schema
Also, the locations of the scripts have changed. They will be run on draco, from the directory /pulsar/psr/archive_scrunch/scripts and so should be copied there (the scrunching scripts are located there as well).