Superraptor123 created this task.
Superraptor123 added projects: Wikibase (3rd party installations), 
Wikidata-Query-Service.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  I'm trying to get a local, standalone Wikibase with Wikidata Query Service 
enabled setup together (so that I can potentially teach it to others for 
educational purposes). I've been documenting everything up to this point to the 
best of my ability, but I've hit a wall. Because it's a standalone instance, 
I've had to combine aspects of other guides here 
<https://github.com/wikimedia/wikidata-query-rdf/blob/master/docs/getting-started.md>
 and here 
<https://www.mediawiki.org/wiki/Wikidata_Query_Service/Implementation/Standalone>.
 A hope to write a guide of my own after I get things up and running.
  
  Basic info:
  
  - Operating System: Ubuntu 20.04.4 LTS (GNU/Linux 5.13.0-1022-aws x86-64)
  - MediaWiki Version: 1.37.2
  
  I've established that all components of MediaWiki and Wikibase are working as 
intended using the various implementation tests. In order to dump the RDF data 
I've done the following (there's only one entity in the instance):
  
    php /var/lib/mediawiki/extensions/Wikibase/repo/maintenance/dumpRdf.php 
--server http://localhost:400 --output 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/data/wikibase-05072022-all.ttl
  
  Then I go in and delete `schema:name` or `skos:prefLabel` from the `ttl` doc 
manually because it will fail to load correctly otherwise. I'm not sure if 
there is a workaround for this, but since it's only one entity, it takes like 2 
seconds, so it isn't a huge deal right now.
  
  Next I load Blazegraph with:
  
    sudo BLAZEGRAPH_OPTS="-DwikibaseConceptUri=http://localhost:400"; bash 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/runBlazegraph.sh
  
  This works with no errors. Then I preprocess the `ttl` using munge:
  
    sudo bash 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/munge.sh
 -f 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/data/wikibase-05072022-all.ttl
 -d 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/data/split
 -- --conceptUri http://localhost:400
  
  This works with no errors. Following that, I load in using:
  
    sudo bash 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/loadRestAPI.sh
 -n placeholdernamespace -d 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/data/split
  
  Finally, I run:
  
    sudo bash 
/var/lib/mediawiki/extensions/wikidata-query-rdf/dist/target/service-0.3.111-SNAPSHOT/runUpdate.sh
 -n placeholdernamespace -- --wikibaseUrl http://localhost:400 --conceptUri 
http://localhost:400
  
  This crashes immediately providing the following trace:
  
    15:36:36.069 [main] INFO  o.w.q.r.t.change.ChangeSourceContext - Checking 
where we left off
    15:36:36.069 [main] INFO  o.w.query.rdf.tool.rdf.RdfRepository - Checking 
for left off time from the updater
    15:36:36.467 [main] INFO  o.w.query.rdf.tool.rdf.RdfRepository - Checking 
for left off time from the dump
    15:36:36.580 [main] INFO  o.w.q.r.t.change.ChangeSourceContext - Found 
start time in the RDF store: 2022-05-08T02:41:03Z
    15:36:36.649 [main] ERROR org.wikidata.query.rdf.tool.Update - Error during 
updater run.
    java.lang.RuntimeException: org.apache.http.conn.HttpHostConnectException: 
Connect to localhost:400 [localhost/127.0.0.1] failed: Connection refused 
(Connection refused)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.fetchRecentChanges(WikibaseRepository.java:244)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.doFetchRecentChanges(RecentChangesPoller.java:325)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.fetchRecentChanges(RecentChangesPoller.java:314)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.batch(RecentChangesPoller.java:338)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.firstBatch(RecentChangesPoller.java:162)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.firstBatch(RecentChangesPoller.java:38)
            at org.wikidata.query.rdf.tool.Updater.run(Updater.java:152)
            at org.wikidata.query.rdf.tool.Update.run(Update.java:174)
            at org.wikidata.query.rdf.tool.Update.main(Update.java:98)
    Caused by: org.apache.http.conn.HttpHostConnectException: Connect to 
localhost:400 [localhost/127.0.0.1] failed: Connection refused (Connection 
refused)
            at 
org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:151)
            at 
org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:353)
            at 
org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:380)
            at 
org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
            at 
org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:184)
            at 
org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:88)
            at 
org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
            at 
org.apache.http.impl.execchain.ServiceUnavailableRetryExec.execute(ServiceUnavailableRetryExec.java:84)
            at 
org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184)
            at 
org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
            at 
org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:107)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.getJson(WikibaseRepository.java:439)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.fetchRecentChanges(WikibaseRepository.java:241)
            ... 8 common frames omitted
    Caused by: java.net.ConnectException: Connection refused (Connection 
refused)
            at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
            at 
java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
            at 
java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
            at 
java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
            at 
java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
            at java.base/java.net.Socket.connect(Socket.java:609)
            at 
org.apache.http.conn.socket.PlainConnectionSocketFactory.connectSocket(PlainConnectionSocketFactory.java:74)
            at 
org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:134)
            ... 20 common frames omitted
    Exception in thread "main" java.lang.RuntimeException: 
org.apache.http.conn.HttpHostConnectException: Connect to localhost:400 
[localhost/127.0.0.1] failed: Connection refused (Connection refused)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.fetchRecentChanges(WikibaseRepository.java:244)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.doFetchRecentChanges(RecentChangesPoller.java:325)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.fetchRecentChanges(RecentChangesPoller.java:314)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.batch(RecentChangesPoller.java:338)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.firstBatch(RecentChangesPoller.java:162)
            at 
org.wikidata.query.rdf.tool.change.RecentChangesPoller.firstBatch(RecentChangesPoller.java:38)
            at org.wikidata.query.rdf.tool.Updater.run(Updater.java:152)
            at org.wikidata.query.rdf.tool.Update.run(Update.java:174)
            at org.wikidata.query.rdf.tool.Update.main(Update.java:98)
    Caused by: org.apache.http.conn.HttpHostConnectException: Connect to 
localhost:400 [localhost/127.0.0.1] failed: Connection refused (Connection 
refused)
            at 
org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:151)
            at 
org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:353)
            at 
org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:380)
            at 
org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
            at 
org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:184)
            at 
org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:88)
            at 
org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
            at 
org.apache.http.impl.execchain.ServiceUnavailableRetryExec.execute(ServiceUnavailableRetryExec.java:84)
            at 
org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184)
            at 
org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
            at 
org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:107)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.getJson(WikibaseRepository.java:439)
            at 
org.wikidata.query.rdf.tool.wikibase.WikibaseRepository.fetchRecentChanges(WikibaseRepository.java:241)
            ... 8 more
    Caused by: java.net.ConnectException: Connection refused (Connection 
refused)
            at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
            at 
java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
            at 
java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
            at 
java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
            at 
java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
            at java.base/java.net.Socket.connect(Socket.java:609)
            at 
org.apache.http.conn.socket.PlainConnectionSocketFactory.connectSocket(PlainConnectionSocketFactory.java:74)
            at 
org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:134)
            ... 20 more
  
  However, I have confirmed that `http://localhost:400` is up and running as 
intended. I'm wondering if perhaps I've done something wrong during the loading 
process? Or if something is not running correctly? Any help at all would be 
much appreciated and I can provide more information if necessary.

TASK DETAIL
  https://phabricator.wikimedia.org/T307951

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Superraptor123
Cc: Aklapper, Superraptor123, MPhamWMF, CBogen, darthmon_wmde, Namenlos314, 
Gq86, Lucas_Werkmeister_WMDE, EBjune, merbst, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Lydia_Pintscher
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to