Tuesday, March 7, 2017

Getting PowerAqua Running with Tomcat 7 - NLQ for Semantic Search

I navigated to the PowerAqua site:
http://technologies.kmi.open.ac.uk/poweraqua/

Then I navigated to SourceForge

https://sourceforge.net/projects/poweraqua/files/code/webapps-tomcat/poweraqualinked.zip

I dumped the unzipped PowerAquaLinked folder into my tomcat7/webapps/ROOT directory, but it does not initiate with the init.jsp script like I think it should from index.html.

The sample app works https://tomcat.apache.org/tomcat-7.0-doc/appdev/sample/ and a static index.html file work. Perhaps it is a configuration option.
I did not touch anything. It just 404s now.

Investigation of the file service_properties.xml shows a lot of paths with the prefix http://kmi-web03.open.ac.uk . ping http://kmi-web03.open.ac.uk gives
ping: http://kmi-web03.open.ac.uk unknown host. The same for port 8080.
ping: unknown host http://kmi-web03.open.ac.uk:8080

service_properties.xml contains the host kmi-web15.open.ac.uk on port 8890, which also does not exist. (ping: unknown host kmi-web15.open.ac.uk:8890) .

multi_index_properties.xml contains installation specific code like:
/Applications/apache-tomcat-5.5.23/webapps/poweraqualinked/LuceneIndexes/

so does indexproperties: index_properties.xml .

--------------------------------------------

so I need to derive a list of services that I need to set up, and then I need to reference them:

First I know I need a sql database:
https://sourceforge.net/projects/poweraqua/files/mysql%20indexes%20backup/

From service_properties.xml :

See: https://sourceforge.net/projects/sesame/

<PLUGIN_MANAGER>/Applications/apache-tomcat-5.5.23/webapps/poweraqualinked/WEB-INF/aquaplugins</PLUGIN_MANAGER>

<SERVER>http://kmi-web03.open.ac.uk:8080/sesame</SERVER>

cat service_properties.xml | grep -o "<REPOSITORY_NAME>http://[a-z0-9.\/:-]*" | grep -o "/[a-z]*" | grep -o "[a-z]*" | sort | uniq

academia
agent
aktivesa
angioplasty
animals
apocalypse
autos
baberuth
baltimoremayor
beavers
beer
bengal
biomedical
biopax
biosphere
biozen
calcium
census
chevrolet
children
coastalontology
conclusions
cyclic
danchundogs
dbpedia
deer
diseases
doap
dog
earthrealm
eculture
eldorado
elements
fao
fasting
fearlus
filmfestival
finance
flows
foaf
food
formdemo
functions
fungalv
galen
geneontology
gps
gutenberg
helmet
human
hunger
imdb
infrastructure
jackierobinson
jamendo
jennifer
kanzakimusic
kappaalphapsi
kimo
kmi
koala
ksw
lavalamps
lighbulb
lod
magnatude
material
mensa
mid
moses
moviedatabase
music
mygrid
ncioncology
newport
ontoworld
parkinson
peergynt
people
periodictable
person
phenomena
phenomenon
pizza
plainmoor
premises
process
property
rosebowl
royalcaribbean
russia
semanticconferences
sesame
skoda
space
sparql
stconcepts
steinbach
sweetjplnasa
tapfull
tartan
taxonomy
time
tiposcomida
tmj
traffic
travel
trees
upm
utexas
wave
wildlife
zirconium

Virtuoso Properties (virtuoso_properties.xml):

<?xml version="1.0" encoding="UTF-8"?>
<CONFIGURATION>

<SERVER>
    <URL>kmi-web15.open.ac.uk</URL>
    <PORT>8890</PORT>
    <LOGIN>dba</LOGIN>
    <PASSWORD>dba</PASSWORD>
    <GRAPHS>
        <GRAPH>
            <IRI>http://dbpedia.org</IRI>
            <TYPE>OWL</TYPE>
        </GRAPH>
    </GRAPHS>
</SERVER>

</CONFIGURATION>

Multi-Index Properties ():

<CONFIGURATION>
    <WATSON>true</WATSON>
   <POWERMAP>true</POWERMAP>
   <VIRTUOSO>true</VIRTUOSO>     <REMOTESPARQLVIRTUOSO>false</REMOTESPARQLVIRTUOSO><ONTOLOGY_INDEX_DB>
jdbc:mysql://localhost:3306/ontologyindexrelation
</ONTOLOGY_INDEX_DB>
<ONTOLOGY_INDEX_DB_LOGIN>
root
</ONTOLOGY_INDEX_DB_LOGIN>
<ONTOLOGY_INDEX_DB_PASSWORD/>
<INDEX_GLOBAL_PATH>
/Applications/apache-tomcat-5.5.23/webapps/poweraqualinked/LuceneIndexes/</INDEX_GLOBAL_PATH>
 <INDEX_INFO_FOLDER>
 ./indexListInformation/indexkmiweb07-philips/
 </INDEX_INFO_FOLDER>
</CONFIGURATION>

cat index_properties.xml | grep -o "<METADATA_INDEX_TABLE>[a-z0-9.\/:-]*" |  grep -o "[a-z0-9.\/:-]*" | sort | uniq

<INDEX_DIRECTORY>
indexkmiweb07linkedata/index
indexkmiweb07mysql/index
indexkmiweb07pg/index
indexkmiweb07trec/index
indexkmiweb07uam/index

compare to: /poweraqualinked/LuceneIndexes$

indexkmiweb07linkedata
indexkmiweb07mysql
indexkmiweb07pg
indexkmiweb07trec
indexkmiweb07-trec
indexkmiweb07uam

<SPELL_INDEX_DIRECTORY>
indexkmiweb07linkedata/spell
indexkmiweb07mysql/spell
indexkmiweb07pg/spell
indexkmiweb07trec/spell
indexkmiweb07uam/spell

<METADATA_INDEX_TABLE>
indexkmiweb07linkedata
indexkmiweb07mysql
indexkmiweb07pg
indexkmiweb07trec
indexkmiweb07uam

----------------------
The next step should be to look at the database backup. I don't know where all of the repositories come from for sesame. I was unable to find them in the downloaded files (excluding the database backup).

backup-ontologyindexrelation_2012-01-03_19.13.03.sql
backup-metadataindex-jul09_2012-01-03_19.13.34.sql

https://forums.mysql.com/read.php?10,195091,195097

I get something like:
ERROR 1045: Access denied for user: 'root@localhost' (Using 
password: NO)
 
 
metadataindex

    indexkmiweb07eculturedirectclasses

       id  ontologyId  entityURI  classURI  classLabel
    indexkmiweb07eculturedirectsubclasses
    indexkmiweb07eculturedirectsuperclasses
    indexkmiweb07ecultureequivalent
    indexkmiweb07eculturesubclasses
    indexkmiweb07eculturesuperclasses
    indexkmiweb07fiatdirectclasses
    indexkmiweb07fiatdirectsubclasses
    indexkmiweb07fiatdirectsuperclasses
    indexkmiweb07fiatequivalent
    indexkmiweb07fiatsubclasses
    indexkmiweb07fiatsuperclasses
    indexkmiweb07linkedatadirectclasses
    indexkmiweb07linkedatadirectsubclasses
    indexkmiweb07linkedatadirectsuperclasses
    indexkmiweb07linkedataequivalent
    indexkmiweb07linkedatasubclasses
    indexkmiweb07linkedatasuperclasses
    indexkmiweb07mysqldirectclasses
    indexkmiweb07mysqldirectsubclasses
    indexkmiweb07mysqldirectsuperclasses
    indexkmiweb07mysqlequivalent
    indexkmiweb07mysqlsubclasses
    indexkmiweb07mysqlsuperclasses
    indexkmiweb07pgdirectclasses
    indexkmiweb07pgdirectsubclasses
    indexkmiweb07pgdirectsuperclasses
    indexkmiweb07pgequivalent
    indexkmiweb07pgsubclasses
    indexkmiweb07pgsuperclasses
    indexkmiweb07swdirectclasses
    indexkmiweb07swdirectsubclasses
    indexkmiweb07swdirectsuperclasses
    indexkmiweb07swequivalent
    indexkmiweb07swsubclasses
    indexkmiweb07swsuperclasses
    indexkmiweb07trecdirectclasses
    indexkmiweb07trecdirectsubclasses
    indexkmiweb07trecdirectsuperclasses
    indexkmiweb07trecequivalent
    indexkmiweb07trecsubclasses
    indexkmiweb07trecsuperclasses
 
ontologyindexrelation

    ontologyindextable
 
    id ontologyId indexManagerId  

https://help.ubuntu.com/community/MysqlPasswordReset

Useful References: (PowerAqua: supporting users in querying and exploring the Semantic Web)
http://www.semantic-web-journal.net/sites/default/files/swj102_2.pdf

(A thesis presented for the degree of Doctor of Philosophy in Computer SciencePowerAqua:Open Question Answeringon the Semantic Web, V. Lopez)
http://technologies.kmi.open.ac.uk/poweraqua/thesis-master-viva.pdf

No comments:

Post a Comment