search

earthchem / EarthChemWebServiceAndClient

Web services from EarthChem such as PetDB data XML export, SedDB data XML export and EarthChem Datalink for Data compliance Tool
Apache License 2.0
0 stars 0 forks source link

broken link #3

Open lulin-song opened 6 years ago

lulin-song commented 6 years ago

http://app.iedadata.org/ws/gfgDataLinkList.php?num=0841006&format=json is broken. But http://app.iedadata.org/ws/gfgDataLinkList.php?num=0819368&format=json works.

lulin-song commented 6 years ago

PHP installed on the server app.iedadata.org was re-compiled with newer version openSSL. But it was not compiled with oracle extension. The first link will connect to Oracle database. The second does not. So the first link failed and second link succeeded.

lulin-song commented 6 years ago

Moved the package to a different server which has PHP with Oracle extension enabled. Re-purpose the URL submit.geoinfogeochem.org to launch the link. It became http://submit.geoinfogeochem.org/ws/gfgDataLinkList.php?num=0841006&format=json

mcorlando commented 6 years ago

One consequence of the broken link is that the Data Compliance Reporting Tool is not showing some holdings. I confirmed that, for awards that have only SESAR or EarthChem Library-related content, all related content is showing. For awards that have only PetDB-related content or PetDB-related content and some other content, holdings are not showing. SedDB content is not showing either. See, e.g., http://dev-app.iedadata.org/dcr/report.php?award_id=0841006 (dev site).

These do not work: 0841006 (PetDB, ECL) 9911418 (PetDB) 0137453 (SedDB) 9906752 (VentDB) (maybe shouldn't work)

Work: 1043274 (ECL, SESAR) 0910941 (ECL, SESAR)

lulin-song commented 6 years ago

I copied dcr_table.php to server 'isotope'. All above Oracle database access needed awards will return contents if it is launched from isotope. http://submit.geoinfogeochem.org/ws/dcr_table.php?award_id=0841006 http://submit.geoinfogeochem.org/ws/dcr_table.php?award_id=9911418 http://submit.geoinfogeochem.org/ws/dcr_table.php?award_id=0137453 9906752 is related to VentDB. I have turned off the VentDB database. If needed, I can turn it on.

But dcr_table.php will fail if it is launched from dev-app.iedadata.org server. http://dev-app.iedadata.org/dcr/dcr_table.php?award_id=0841006 http://dev-app.iedadata.org/dcr/dcr_table.php?award_id=9911418 http://dev-app.iedadata.org/dcr/dcr_table.php?award_id=0137453 So the problem must be on the server 'app.iedadata.org' (dev-app.iedadata.org is on the same server). The server may have configuration issues as pointed out by Vicki.