svn commit: r1629611 - /marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm

[ss...@apache.org]

Author: sschaffert
Date: Mon Oct  6 10:51:18 2014
New Revision: 1629611

URL: http://svn.apache.org/r1629611
Log:
updated documentation for SPARQL (MARMOTTA-537)

Modified:
    marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm

Modified: marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm
URL: http://svn.apache.org/viewvc/marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm?rev=1629611&r1=1629610&r2=1629611&view=diff
==============================================================================
--- marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm (original)
+++ marmotta/site/trunk/content/markdown/kiwi/sparql.md.vm Mon Oct  6 10:51:18 2014
@@ -36,6 +36,31 @@ dependency to your Maven project:
      </dependency>
 
 
+Crypto Extensions
+-----------------
+
+The SPARQL standard defines a number of crypto functions (e.g. UUID or MD5)). These are all supported by KiWi Native
+SPARQL for PostgreSQL and MySQL. Note that when using these functions, plain text might still be sent over the network
+without encryption, depending on your setup (i.e. using SSL for accessing the SPARQL endpoint, and using SSL for
+connecting to the backend database). Depending on the database you are using, certain additional setups are required:
+
+### PostgreSQL
+
+In PostgreSQL, it is necessary to install the pgcrypto extension from the contrib package into the Marmotta database.
+Depending on your operating system and distribution, this might also require installation of additional software packages
+(under Debian: postgresql-contrib). To install the pgcrypto extension, connect to the database as superuser and run
+
+    CREATE EXTENSION IF NOT EXISTS pgcrypto;
+
+To connect to the `marmotta` database as superuser on Linux, you would e.g. run the following commands:
+
+    su - postgres
+    psql marmotta
+
+You can also use a graphical UI like pgadmin, but make sure to call the command on the correct database (not the whole
+server).
+
+
 Marmotta Extensions
 -------------------