| author | weiher |
| Tue, 27 Mar 2018 16:07:14 +0200 | |
| changeset 15 | 523ca1dfd077 |
| parent 13 | a21f3604f1db |
| child 18 | 57431f642e82 |
| permissions | -rw-r--r-- |
| 3 | 1 |
%% Generated by Sphinx. |
2 |
\def\sphinxdocclass{report}
|
|
3 |
\documentclass[letterpaper,10pt,english]{sphinxmanual}
|
|
4 |
\ifdefined\pdfpxdimen |
|
5 |
\let\sphinxpxdimen\pdfpxdimen\else\newdimen\sphinxpxdimen |
|
6 |
\fi \sphinxpxdimen=.75bp\relax |
|
7 |
||
8 |
\usepackage[utf8]{inputenc}
|
|
9 |
\ifdefined\DeclareUnicodeCharacter |
|
10 |
\ifdefined\DeclareUnicodeCharacterAsOptional |
|
11 |
\DeclareUnicodeCharacter{"00A0}{\nobreakspace}
|
|
12 |
\DeclareUnicodeCharacter{"2500}{\sphinxunichar{2500}}
|
|
13 |
\DeclareUnicodeCharacter{"2502}{\sphinxunichar{2502}}
|
|
14 |
\DeclareUnicodeCharacter{"2514}{\sphinxunichar{2514}}
|
|
15 |
\DeclareUnicodeCharacter{"251C}{\sphinxunichar{251C}}
|
|
16 |
\DeclareUnicodeCharacter{"2572}{\textbackslash}
|
|
17 |
\else |
|
18 |
\DeclareUnicodeCharacter{00A0}{\nobreakspace}
|
|
19 |
\DeclareUnicodeCharacter{2500}{\sphinxunichar{2500}}
|
|
20 |
\DeclareUnicodeCharacter{2502}{\sphinxunichar{2502}}
|
|
21 |
\DeclareUnicodeCharacter{2514}{\sphinxunichar{2514}}
|
|
22 |
\DeclareUnicodeCharacter{251C}{\sphinxunichar{251C}}
|
|
23 |
\DeclareUnicodeCharacter{2572}{\textbackslash}
|
|
24 |
\fi |
|
25 |
\fi |
|
26 |
\usepackage{cmap}
|
|
27 |
\usepackage[T1]{fontenc}
|
|
28 |
\usepackage{amsmath,amssymb,amstext}
|
|
29 |
\usepackage{babel}
|
|
30 |
\usepackage{times}
|
|
31 |
\usepackage[Bjarne]{fncychap}
|
|
32 |
\usepackage[dontkeepoldnames]{sphinx}
|
|
33 |
||
34 |
\usepackage{geometry}
|
|
35 |
||
36 |
% Include hyperref last. |
|
37 |
\usepackage{hyperref}
|
|
38 |
% Fix anchor placement for figures with captions. |
|
39 |
\usepackage{hypcap}% it must be loaded after hyperref.
|
|
40 |
% Set up styles of URL: it should be placed after hyperref. |
|
41 |
\urlstyle{same}
|
|
42 |
\addto\captionsenglish{\renewcommand{\contentsname}{Contents:}}
|
|
43 |
||
44 |
\addto\captionsenglish{\renewcommand{\figurename}{Fig.}}
|
|
45 |
\addto\captionsenglish{\renewcommand{\tablename}{Table}}
|
|
46 |
\addto\captionsenglish{\renewcommand{\literalblockname}{Listing}}
|
|
47 |
||
48 |
\addto\captionsenglish{\renewcommand{\literalblockcontinuedname}{continued from previous page}}
|
|
49 |
\addto\captionsenglish{\renewcommand{\literalblockcontinuesname}{continues on next page}}
|
|
50 |
||
51 |
\addto\extrasenglish{\def\pageautorefname{page}}
|
|
52 |
||
53 |
\setcounter{tocdepth}{1}
|
|
54 |
||
55 |
||
56 |
||
57 |
\title{Labfolder at FHI Documentation}
|
|
| 15 | 58 |
\date{Mar 27, 2018}
|
| 3 | 59 |
\release{1.0}
|
60 |
\author{Stefan Weiher}
|
|
61 |
\newcommand{\sphinxlogo}{\vbox{}}
|
|
62 |
\renewcommand{\releasename}{Release}
|
|
63 |
\makeindex |
|
64 |
||
65 |
\begin{document}
|
|
66 |
||
67 |
\maketitle |
|
68 |
\sphinxtableofcontents |
|
69 |
\phantomsection\label{\detokenize{index::doc}}
|
|
70 |
||
71 |
||
72 |
||
73 |
\chapter{Installation of labfolder}
|
|
74 |
\label{\detokenize{installation:welcome-to-elog2labfolder-s-documentation}}\label{\detokenize{installation::doc}}\label{\detokenize{installation:installation-of-labfolder}}
|
|
75 |
Labfolder is easy to install. Follow the instructions given in the \sphinxstyleemphasis{labfolder Installation Manual}. The broad steps are: \sphinxstylestrong{install MySQL, docker and labolder; configure labfolder via the server.cnf file}. This labfolder config file could look like this:
|
|
76 |
||
77 |
\fvset{hllines={, ,}}%
|
|
78 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
79 |
\PYGZsh{} Network settings
|
|
80 |
DEFAULT\PYGZus{}HTTP\PYGZus{}PROTOCOL=https://
|
|
81 |
DEFAULT\PYGZus{}DOMAIN=labfolder.rz\PYGZhy{}berlin.mpg.de
|
|
82 |
||
83 |
\PYGZsh{} JDBC Properties
|
|
84 |
JDBC\PYGZus{}SERVER\PYGZus{}TIMEZONE=Europe/Berlin
|
|
85 |
JDBC\PYGZus{}DATABASE\PYGZus{}URL=jdbc:mysql://localhost:3306/labfolder?useUnicode=true\PYGZam{}characterEncoding=UTF\PYGZhy{}8
|
|
86 |
JDBC\PYGZus{}USERNAME=labfolder
|
|
87 |
JDBC\PYGZus{}PASSWORD=fhilab
|
|
88 |
JDBC\PYGZus{}SCHEMA\PYGZus{}NAME=labfolder
|
|
89 |
\PYGZsh{}REMOVE\PYGZus{}ABANDONED\PYGZus{}TIMEOUT=60
|
|
90 |
||
91 |
\PYGZsh{} Mail client properties
|
|
92 |
MAIL\PYGZus{}STARTTLS=false
|
|
93 |
MAIL\PYGZus{}AUTHENTICATION\PYGZus{}ENABLE=false
|
|
94 |
MAIL\PYGZus{}HOST=mail.fhi\PYGZhy{}berlin.mpg.de
|
|
95 |
MAIL\PYGZus{}PORT=25
|
|
96 |
\PYGZsh{}MAIL\PYGZus{}USERNAME=
|
|
97 |
\PYGZsh{}MAIL\PYGZus{}PASSWORD=
|
|
98 |
MAIL\PYGZus{}EMAIL=ppb@fhi\PYGZhy{}berlin.mpg.de
|
|
99 |
||
100 |
\PYGZsh{} Server Event logging
|
|
101 |
LOG\PYGZus{}TO\PYGZus{}FILE=true
|
|
102 |
||
103 |
\PYGZsh{}Maximum upload file size
|
|
104 |
FILEUPLOAD\PYGZus{}MAXUPLOADSIZE=25000000
|
|
105 |
||
106 |
\PYGZsh{} User and group control
|
|
107 |
DEFAULT\PYGZus{}GROUP\PYGZus{}SIZE=50
|
|
108 |
DEFAULT\PYGZus{}GROUP\PYGZus{}TYPE\PYGZus{}MAXI=true
|
|
109 |
DEFAULT\PYGZus{}USER\PYGZus{}STORAGE=3221225472
|
|
110 |
FEATURE\PYGZus{}GLOBAL\PYGZus{}PREVENT\PYGZus{}DELETE\PYGZus{}CONTENT=false
|
|
111 |
||
112 |
\PYGZsh{} Terms and Privacy links
|
|
113 |
TERMS\PYGZus{}OF\PYGZus{}USE\PYGZus{}LINK=https://www.labfolder.com/terms\PYGZhy{}external\PYGZhy{}servers/
|
|
114 |
PRIVACY\PYGZus{}LINK=https://www.labfolder.com/privacy\PYGZhy{}external\PYGZhy{}servers/
|
|
115 |
||
116 |
\PYGZsh{} LDAP Authentication
|
|
117 |
FEATURE\PYGZus{}LDAP\PYGZus{}AUTHENTICATION=true
|
|
118 |
LDAP\PYGZus{}URL=ldap://ldap.rz\PYGZhy{}berlin.mpg.de:389
|
|
119 |
LDAP\PYGZus{}BASE=ou=people,dc=ppb,dc=rz\PYGZhy{}berlin,dc=mpg,dc=de
|
|
120 |
\PYGZsh{}LDAP\PYGZus{}SERVER\PYGZus{}TYPE=
|
|
121 |
LDAP\PYGZus{}USER\PYGZus{}DN=cn=pwCheck,dc=rz\PYGZhy{}berlin,dc=mpg,dc=de
|
|
122 |
LDAP\PYGZus{}PASSWORD=ProstetnikVogonJeltz
|
|
123 |
\PYGZsh{}LDAP\PYGZus{}ANONYMOUS\PYGZus{}READ\PYGZus{}ONLY=
|
|
124 |
LDAP\PYGZus{}USER\PYGZus{}DN\PYGZus{}PATTERNS=uid=\PYGZob{}0\PYGZcb{}
|
|
125 |
\PYGZsh{}LDAP\PYGZus{}IS\PYGZus{}TLS\PYGZus{}ENABLED=
|
|
126 |
\PYGZsh{}LDAP\PYGZus{}IS\PYGZus{}ATTRIBUTE\PYGZus{}SEARCH\PYGZus{}ENABLED=
|
|
127 |
\PYGZsh{}LDAP\PYGZus{}ATTRIBUTE\PYGZus{}SEARCH\PYGZus{}NAME=
|
|
128 |
||
129 |
\PYGZsh{} Usage monitoring
|
|
130 |
ACTIVE\PYGZus{}USER\PYGZus{}REPORT\PYGZus{}USE\PYGZus{}DEFAULT\PYGZus{}MAIL\PYGZus{}CLIENT=true
|
|
131 |
CUSTOMER\PYGZus{}IDENTIFIER=\PYGZsq{}Fritz\PYGZhy{}Haber\PYGZhy{}Institut\PYGZsq{}
|
|
132 |
||
133 |
\PYGZsh{} Mendeley
|
|
134 |
FEATURE\PYGZus{}MENDELEY=false
|
|
135 |
\PYGZsh{}MENDELEY\PYGZus{}CLIENT\PYGZus{}ID=
|
|
136 |
\PYGZsh{}MENDELEY\PYGZus{}CLIENT\PYGZus{}SECRET=
|
|
137 |
\PYGZsh{}MENDELEY\PYGZus{}CLIENT\PYGZus{}CALLBACKURL=http://localhost:9091/eln/mendeley/oauthCallback
|
|
138 |
||
139 |
\PYGZsh{} Dropbox
|
|
140 |
FEATURE\PYGZus{}DROPBOX=false
|
|
141 |
\PYGZsh{}DROPBOX\PYGZus{}CONSUMER\PYGZus{}KEY=
|
|
142 |
\PYGZsh{}DROPBOX\PYGZus{}CONSUMER\PYGZus{}SECRET=
|
|
143 |
||
144 |
\PYGZsh{} Figshare
|
|
145 |
FEATURE\PYGZus{}FIGSHARE=false
|
|
146 |
||
147 |
\PYGZsh{} XHTML Export
|
|
148 |
FEATURE\PYGZus{}XHTML\PYGZus{}EXPORT=true
|
|
149 |
EXPORT\PYGZus{}DOCUMENT\PYGZus{}REPOSITORY\PYGZus{}TYPE=fileSystem
|
|
150 |
\end{sphinxVerbatim}
|
|
151 |
||
152 |
The configuration is explained in detail in the installation manual. Now, \sphinxstylestrong{create the labfolder database and run labfolder} (see the manual for details). Additionally, you could install Apache and set it up as a reverse proxy in order to make labfolder only available through https. The exact steps are:
|
|
153 |
||
154 |
\fvset{hllines={, ,}}%
|
|
155 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
156 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo apt\PYGZhy{}get install build\PYGZhy{}essential
|
|
157 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo apt install apache2
|
|
158 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo a2enmod proxy proxy\PYGZus{}ajp proxy\PYGZus{}http rewrite deflate headers proxy\PYGZus{}balancer proxy\PYGZus{}connect proxy\PYGZus{}html xml2enc
|
|
159 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo a2enmod ssl
|
|
160 |
||
161 |
\PYGZsh{}\PYGZsh{}\PYGZsh{} Use certificates from e.g. let\PYGZsq{}s encrypt. Please see below for more information.
|
|
162 |
||
163 |
\PYGZsh{}\PYGZsh{}\PYGZsh{} create /etc/apache2/sites\PYGZhy{}available/labfolder.conf with virtual hosts for http and https:
|
|
164 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo a2ensite labfolder.conf
|
|
165 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo a2dissite 000\PYGZhy{}default.conf
|
|
166 |
labfolder@lf:\PYGZti{}\PYGZdl{} sudo service apache2 restart
|
|
167 |
\end{sphinxVerbatim}
|
|
168 |
||
169 |
To get SSL certificates from letsencrypt is quite straight forward. For example this guide shows how to set up SSL certificates: |
|
170 |
||
171 |
\sphinxurl{https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-16-04}
|
|
172 |
||
173 |
The Apache labfolder config file could look like this: |
|
174 |
||
175 |
\fvset{hllines={, ,}}%
|
|
176 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
177 |
\PYG{o}{\PYGZlt{}}\PYG{n}{VirtualHost} \PYG{o}{*}\PYG{p}{:}\PYG{l+m+mi}{80}\PYG{o}{\PYGZgt{}}
|
|
178 |
\PYG{n}{ErrorLog} \PYG{o}{/}\PYG{n}{var}\PYG{o}{/}\PYG{n}{log}\PYG{o}{/}\PYG{n}{apache2}\PYG{o}{/}\PYG{n}{error}\PYG{o}{.}\PYG{n}{log}
|
|
179 |
\PYG{n}{LogLevel} \PYG{n}{warn}
|
|
180 |
||
181 |
\PYG{n}{ServerName} \PYG{n}{labfolder}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}
|
|
182 |
\PYG{n}{Redirect} \PYG{o}{/} \PYG{n}{https}\PYG{p}{:}\PYG{o}{/}\PYG{o}{/}\PYG{n}{labfolder}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}\PYG{o}{/}
|
|
183 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{VirtualHost}\PYG{o}{\PYGZgt{}}
|
|
184 |
||
185 |
\PYG{o}{\PYGZlt{}}\PYG{n}{VirtualHost} \PYG{o}{*}\PYG{p}{:}\PYG{l+m+mi}{443}\PYG{o}{\PYGZgt{}}
|
|
186 |
\PYG{n}{ErrorLog} \PYG{o}{/}\PYG{n}{var}\PYG{o}{/}\PYG{n}{log}\PYG{o}{/}\PYG{n}{apache2}\PYG{o}{/}\PYG{n}{error}\PYG{o}{.}\PYG{n}{log}
|
|
187 |
\PYG{n}{LogLevel} \PYG{n}{warn}
|
|
188 |
||
189 |
\PYG{n}{ServerName} \PYG{n}{labfolder}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}
|
|
190 |
||
191 |
\PYG{n}{SSLEngine} \PYG{n}{On}
|
|
192 |
\PYG{n}{SSLCertificateFile} \PYG{o}{/}\PYG{n}{etc}\PYG{o}{/}\PYG{n}{letsencrypt}\PYG{o}{/}\PYG{n}{live}\PYG{o}{/}\PYG{n}{labfolder}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}\PYG{o}{/}\PYG{n}{fullchain}\PYG{o}{.}\PYG{n}{pem}
|
|
193 |
\PYG{n}{SSLCertificateKeyFile} \PYG{o}{/}\PYG{n}{etc}\PYG{o}{/}\PYG{n}{letsencrypt}\PYG{o}{/}\PYG{n}{live}\PYG{o}{/}\PYG{n}{labfolder}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}\PYG{o}{/}\PYG{n}{privkey}\PYG{o}{.}\PYG{n}{pem}
|
|
194 |
||
195 |
\PYG{n}{ProxyPass} \PYG{o}{/} \PYG{n}{http}\PYG{p}{:}\PYG{o}{/}\PYG{o}{/}\PYG{l+m+mf}{141.14}\PYG{o}{.}\PYG{l+m+mf}{138.230}\PYG{p}{:}\PYG{l+m+mi}{9091}\PYG{o}{/}
|
|
196 |
\PYG{n}{ProxyPassReverse} \PYG{o}{/} \PYG{n}{http}\PYG{p}{:}\PYG{o}{/}\PYG{o}{/}\PYG{l+m+mf}{141.14}\PYG{o}{.}\PYG{l+m+mf}{138.230}\PYG{p}{:}\PYG{l+m+mi}{9091}\PYG{o}{/}
|
|
197 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{VirtualHost}\PYG{o}{\PYGZgt{}}
|
|
198 |
\end{sphinxVerbatim}
|
|
199 |
||
200 |
||
| 13 | 201 |
\chapter{Printing via CUPS and attaching files to labfolder logbooks}
|
202 |
\label{\detokenize{installation_cups:printing-via-cups-and-attaching-files-to-labfolder-logbooks}}\label{\detokenize{installation_cups::doc}}
|
|
| 15 | 203 |
Follow this guide to set up CUPS virtual printers to be able to print webpages and pictures/files (PDF, PNG, JPG, PS) to one of labfolder’s logbooks, thus, creating a new entry with an attachment. If you are an admin of the labfolder VM read the section {\hyperref[\detokenize{installation_cups:section-cups-admin}]{\sphinxcrossref{\DUrole{std,std-ref}{Set up CUPS as labfolder admin}}}}. Users of labfolder read the section {\hyperref[\detokenize{installation_cups:section-cups-user}]{\sphinxcrossref{\DUrole{std,std-ref}{Printing to labfolder projects}}}}.
|
204 |
||
205 |
||
206 |
\section{Set up CUPS as labfolder admin}
|
|
207 |
\label{\detokenize{installation_cups:section-cups-admin}}\label{\detokenize{installation_cups:set-up-cups-as-labfolder-admin}}
|
|
208 |
First, you need to install CUPS on the virtual machine that runs labfolder: |
|
| 13 | 209 |
|
210 |
\fvset{hllines={, ,}}%
|
|
211 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
212 |
\PYG{n}{sudo} \PYG{n}{apt}\PYG{o}{\PYGZhy{}}\PYG{n}{get} \PYG{n}{install} \PYG{n}{cups} \PYG{n}{cups}\PYG{o}{\PYGZhy{}}\PYG{n}{client} \PYG{n}{cups}\PYG{o}{\PYGZhy{}}\PYG{n}{bsd}
|
|
213 |
\end{sphinxVerbatim}
|
|
214 |
||
| 15 | 215 |
Next, configure \sphinxcode{/etc/cups/cupsd.conf}:
|
| 13 | 216 |
|
217 |
\fvset{hllines={, ,}}%
|
|
218 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
219 |
\PYG{c+c1}{\PYGZsh{} Sample configuration file for the CUPS scheduler. See \PYGZdq{}man cupsd.conf\PYGZdq{} for a}
|
|
220 |
\PYG{c+c1}{\PYGZsh{} complete description of this file.}
|
|
221 |
||
222 |
\PYG{c+c1}{\PYGZsh{} Log general information in error\PYGZus{}log \PYGZhy{} change \PYGZdq{}warn\PYGZdq{} to \PYGZdq{}debug\PYGZdq{}}
|
|
223 |
\PYG{c+c1}{\PYGZsh{} for troubleshooting...}
|
|
224 |
\PYG{n}{LogLevel} \PYG{n}{debug}
|
|
225 |
||
226 |
\PYG{c+c1}{\PYGZsh{} Deactivate CUPS\PYGZsq{} internal logrotating, as we provide a better one, especially}
|
|
227 |
\PYG{c+c1}{\PYGZsh{} LogLevel debug2 gets usable now}
|
|
228 |
\PYG{n}{MaxLogSize} \PYG{l+m+mi}{0}
|
|
229 |
||
230 |
\PYG{c+c1}{\PYGZsh{} Administrator user group...}
|
|
231 |
\PYG{n}{SystemGroup} \PYG{n}{lpadmin}
|
|
| 15 | 232 |
\PYG{n}{ServerAdmin} \PYG{o}{\PYGZlt{}}\PYG{n}{name}\PYG{o}{\PYGZgt{}}\PYG{n+nd}{@fhi}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}
|
| 13 | 233 |
|
234 |
\PYG{n}{HostNameLookups} \PYG{n}{On}
|
|
235 |
\PYG{n}{ServerAlias} \PYG{o}{*}
|
|
236 |
||
237 |
\PYG{c+c1}{\PYGZsh{} Only listen for connections from the local machine.}
|
|
238 |
\PYG{n}{Listen} \PYG{n}{lftest}\PYG{o}{.}\PYG{n}{rz}\PYG{o}{\PYGZhy{}}\PYG{n}{berlin}\PYG{o}{.}\PYG{n}{mpg}\PYG{o}{.}\PYG{n}{de}\PYG{p}{:}\PYG{l+m+mi}{631}
|
|
239 |
\PYG{n}{Listen} \PYG{o}{/}\PYG{n}{var}\PYG{o}{/}\PYG{n}{run}\PYG{o}{/}\PYG{n}{cups}\PYG{o}{/}\PYG{n}{cups}\PYG{o}{.}\PYG{n}{sock}
|
|
240 |
||
241 |
\PYG{c+c1}{\PYGZsh{} Show shared printers on the local network.}
|
|
242 |
\PYG{n}{Browsing} \PYG{n}{Off}
|
|
243 |
\PYG{n}{BrowseOrder} \PYG{n}{allow}\PYG{p}{,}\PYG{n}{deny}
|
|
244 |
\PYG{n}{BrowseAllow} \PYG{n+nb}{all}
|
|
245 |
\PYG{n}{BrowseLocalProtocols} \PYG{n}{CUPS} \PYG{n}{dnssd}
|
|
246 |
\PYG{n}{BrowseAddress} \PYG{n+nd}{@LOCAL}
|
|
247 |
||
248 |
\PYG{c+c1}{\PYGZsh{} Default authentication type, when authentication is required...}
|
|
249 |
\PYG{n}{DefaultAuthType} \PYG{n}{Basic}
|
|
250 |
||
251 |
\PYG{c+c1}{\PYGZsh{} Web interface setting...}
|
|
252 |
\PYG{n}{WebInterface} \PYG{n}{Yes}
|
|
253 |
||
254 |
\PYG{c+c1}{\PYGZsh{} Restrict access to the server...}
|
|
255 |
\PYG{o}{\PYGZlt{}}\PYG{n}{Location} \PYG{o}{/}\PYG{o}{\PYGZgt{}}
|
|
256 |
\PYG{n}{Satisfy} \PYG{n}{All}
|
|
257 |
\PYG{n}{Allow} \PYG{n}{localhost}
|
|
258 |
\PYG{n}{Allow} \PYG{l+m+mf}{141.14}\PYG{o}{.}\PYG{o}{*}
|
|
259 |
\PYG{n}{Allow} \PYG{l+m+mf}{172.16}\PYG{o}{.}\PYG{o}{*}
|
|
260 |
\PYG{n}{Allow} \PYG{l+m+mf}{192.}\PYG{o}{*}
|
|
261 |
\PYG{n}{Allow} \PYG{n+nb}{all}
|
|
262 |
\PYG{c+c1}{\PYGZsh{} Allow shared printing and remote administration...}
|
|
263 |
\PYG{n}{Order} \PYG{n}{allow}\PYG{p}{,}\PYG{n}{deny}
|
|
264 |
\PYG{n}{Allow} \PYG{n+nb}{all}
|
|
265 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{Location}\PYG{o}{\PYGZgt{}}
|
|
266 |
||
267 |
\PYG{c+c1}{\PYGZsh{} Restrict access to the admin pages...}
|
|
268 |
\PYG{o}{\PYGZlt{}}\PYG{n}{Location} \PYG{o}{/}\PYG{n}{admin}\PYG{o}{\PYGZgt{}}
|
|
269 |
\PYG{n}{Order} \PYG{n}{deny}\PYG{p}{,}\PYG{n}{allow}
|
|
270 |
\PYG{n}{Satisfy} \PYG{n}{All}
|
|
271 |
\PYG{n}{AuthType} \PYG{n}{Basic}
|
|
272 |
\PYG{n}{Require} \PYG{n}{user} \PYG{n+nd}{@SYSTEM}
|
|
273 |
\PYG{n}{Deny} \PYG{n}{All}
|
|
274 |
\PYG{n}{Allow} \PYG{n}{localhost}
|
|
275 |
\PYG{n}{Allow} \PYG{l+m+mf}{141.14}\PYG{o}{.}\PYG{o}{*}
|
|
276 |
\PYG{n}{Allow} \PYG{l+m+mf}{172.16}\PYG{o}{.}\PYG{o}{*}
|
|
277 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{Location}\PYG{o}{\PYGZgt{}}
|
|
278 |
||
279 |
\PYG{c+c1}{\PYGZsh{} Restrict access to configuration files...}
|
|
280 |
\PYG{o}{\PYGZlt{}}\PYG{n}{Location} \PYG{o}{/}\PYG{n}{admin}\PYG{o}{/}\PYG{n}{conf}\PYG{o}{\PYGZgt{}}
|
|
281 |
\PYG{n}{Order} \PYG{n}{deny}\PYG{p}{,}\PYG{n}{allow}
|
|
282 |
\PYG{n}{AuthType} \PYG{n}{Default}
|
|
283 |
\PYG{n}{Require} \PYG{n}{user} \PYG{n+nd}{@SYSTEM}
|
|
284 |
\PYG{n}{Satisfy} \PYG{n}{All}
|
|
285 |
\PYG{n}{Require} \PYG{n}{user} \PYG{n}{root}
|
|
286 |
\PYG{n}{Deny} \PYG{n}{All}
|
|
287 |
\PYG{n}{Allow} \PYG{l+m+mf}{127.0}\PYG{o}{.}\PYG{l+m+mf}{0.1}
|
|
288 |
\PYG{n}{Allow} \PYG{l+m+mf}{141.14}\PYG{o}{.}\PYG{o}{*}
|
|
289 |
\PYG{n}{Allow} \PYG{l+m+mf}{172.16}\PYG{o}{.}\PYG{o}{*}
|
|
290 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{Location}\PYG{o}{\PYGZgt{}}
|
|
291 |
||
292 |
\PYG{c+c1}{\PYGZsh{} Set the default printer/job policies...}
|
|
293 |
\PYG{o}{\PYGZlt{}}\PYG{n}{Policy} \PYG{n}{default}\PYG{o}{\PYGZgt{}}
|
|
294 |
\PYG{o}{.}\PYG{o}{.}\PYG{o}{.} \PYG{c+c1}{\PYGZsh{} probably as in the original}
|
|
295 |
\PYG{o}{\PYGZlt{}}\PYG{o}{/}\PYG{n}{Policy}\PYG{o}{\PYGZgt{}}
|
|
296 |
\end{sphinxVerbatim}
|
|
297 |
||
| 15 | 298 |
Change the \sphinxstyleemphasis{Server Admin}’s e-mail address and the server that shall be listened to (see the \sphinxcode{Listen} statement). Set \sphinxcode{FileDevice Yes} in \sphinxcode{/etc/cups/cups-files.conf}. Now, create a directory where all printers will go, e.g. \sphinxcode{/usr/local/labfolder/printers}.
|
299 |
||
300 |
Get the package for creating new printers from git: |
|
| 13 | 301 |
|
302 |
\fvset{hllines={, ,}}%
|
|
303 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
| 15 | 304 |
labfolder@lftest:\PYGZti{}\PYGZdl{} git clone https://github.molgen.mpg.de/weiher/cupsPrinters
|
305 |
labfolder@lftest:\PYGZti{}\PYGZdl{} ls
|
|
306 |
cupsPrinters labfolder |
|
| 13 | 307 |
\end{sphinxVerbatim}
|
308 |
||
| 15 | 309 |
The only file you need to adapt is \sphinxcode{newPrinter.sh}. It is not a must but it is suggested to name the printers like the projects. For example, the FEL projects \sphinxstyleemphasis{operating} and \sphinxstyleemphasis{installation} could be placed at \sphinxcode{.../printers/FEL/operating} and \sphinxcode{.../printers/FEL/installation}. Execute the script with sudo rights:
|
| 13 | 310 |
|
311 |
\fvset{hllines={, ,}}%
|
|
312 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
| 15 | 313 |
labfolder@lftest:\PYGZti{}/cupsPrinters\PYGZdl{} sudo ./newPrinter.sh
|
| 13 | 314 |
\end{sphinxVerbatim}
|
315 |
||
| 15 | 316 |
To prevent \sphinxcode{DENIED} errors from apparmor install and set the following and restart the CUPS server:
|
| 13 | 317 |
|
318 |
\fvset{hllines={, ,}}%
|
|
319 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
| 15 | 320 |
\PYGZdl{} sudo apt\PYGZhy{}get install apparmor\PYGZhy{}utils apparmor\PYGZhy{}profiles
|
321 |
\PYGZdl{} sudo aa\PYGZhy{}complain cupsd
|
|
322 |
\PYGZdl{} sudo service cups restart
|
|
| 13 | 323 |
\end{sphinxVerbatim}
|
324 |
||
| 15 | 325 |
In case you need to debug some logfiles can be found here: \sphinxstyleemphasis{/var/log/syslog}, \sphinxstyleemphasis{/var/log/cups/error\_log} and \sphinxstyleemphasis{/var/log/cups/acces\_log}
|
| 13 | 326 |
|
| 15 | 327 |
One last change is that you need to once add a user named \sphinxstyleemphasis{Printer Print} (firstname lastname) to the labfolder database. This can be done manually inside the DB by this command:
|
| 13 | 328 |
|
329 |
\fvset{hllines={, ,}}%
|
|
330 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
| 15 | 331 |
\PYGZdl{} mysql \PYGZhy{}u root \PYGZhy{}p
|
332 |
Enter password: |
|
333 |
... |
|
334 |
mysql\PYGZgt{} use labfolder;
|
|
335 |
mysql\PYGZgt{} INSERT INTO user (email, password, firstname, lastname, signupTimestamp, maxStorage) VALUES (\PYGZsq{}printer@fhi\PYGZhy{}berlin.mpg.de\PYGZsq{}, \PYGZsq{}91a13f2aba4a35b00c35dfacadd1d75f4a5171dfa7a465fca9c40e6b007ce982\PYGZsq{}, \PYGZsq{}Printer\PYGZsq{}, \PYGZsq{}Print\PYGZsq{}, \PYGZsq{}2018\PYGZhy{}03\PYGZhy{}21 10:54:00\PYGZsq{}, \PYGZsq{}10000000\PYGZsq{});
|
|
| 13 | 336 |
\end{sphinxVerbatim}
|
337 |
||
338 |
||
| 15 | 339 |
\section{Printing to labfolder projects}
|
340 |
\label{\detokenize{installation_cups:printing-to-labfolder-projects}}\label{\detokenize{installation_cups:section-cups-user}}
|
|
| 13 | 341 |
The last thing you need to do is to set up a printer \sphinxstyleemphasis{operating} on your local machine. In Ubuntu Gnome hit Alt+F2 keys and enter \sphinxcode{system-config-printer}. In this printer config interface add a new printer \sphinxstyleemphasis{operating} as follows:
|
342 |
||
343 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer01}.png}\hspace*{\fill}}
|
|
344 |
||
345 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer02}.png}\hspace*{\fill}}
|
|
346 |
||
347 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer03}.png}\hspace*{\fill}}
|
|
348 |
||
349 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer04}.png}\hspace*{\fill}}
|
|
350 |
||
351 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer05}.png}\hspace*{\fill}}
|
|
352 |
||
353 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer06}.png}\hspace*{\fill}}
|
|
354 |
||
355 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{create_local_printer07}.png}\hspace*{\fill}}
|
|
356 |
||
357 |
||
| 3 | 358 |
\chapter{Groups, ownership and sharing in labfolder}
|
359 |
\label{\detokenize{groups:groups-ownership-and-sharing-in-labfolder}}\label{\detokenize{groups::doc}}
|
|
360 |
As labfolder user you can create groups (ultimately: group projects) and private projects. In \sphinxstyleemphasis{Manage \textgreater{} Projects} you see all projects that you own and that you are a member of.
|
|
361 |
||
362 |
||
363 |
\section{Private projects}
|
|
364 |
\label{\detokenize{groups:private-projects}}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
365 |
You alone are the owner of these projects in \sphinxstyleemphasis{My Private Projects}. Their ownership cannot be transfered from you to anyone else via the webinterface. Only via accepting the invitation to a group with the policy that private projects are not allowed the content of the former private project would be visible (and administrable) also to the group’s admin(s). By directly manipulating the database the ownership could be changed to an active user as well.
|
| 3 | 366 |
|
367 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{private_projects}.png}\hspace*{\fill}}
|
|
368 |
||
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
369 |
\sphinxstylestrong{Private projects are possible through a back door} if a user creates their own group which doesn’t necessarily mean that they invite other users to this group. In their own group they could create as many (private) projects as they like.
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
370 |
|
| 3 | 371 |
|
372 |
\section{Group projects}
|
|
373 |
\label{\detokenize{groups:group-projects}}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
374 |
Any labfolder user can create groups and subgroups in \sphinxstyleemphasis{Manage \textgreater{} Groups \textgreater{} Button “+Add”}. But within an already existing group a member can only create subgroups if they are set as an administrator of this group. In the role of the admin you can do the following:
|
| 3 | 375 |
\begin{itemize}
|
376 |
\item {}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
377 |
Create (sub)groups |
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
378 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
379 |
\item {}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
380 |
Invite users to your (sub)group via e-mail |
| 3 | 381 |
|
382 |
\item {}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
383 |
Move users between subgroups |
| 3 | 384 |
|
385 |
\item {}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
386 |
Set and remove (sub)group members as admins |
| 3 | 387 |
|
388 |
\item {}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
389 |
Remove users from a (sub)group e.g. when they are leaving the institute (\sphinxstylestrong{In this case the ownership of this user’s projects within the (sub)group needs to be transfered first!})
|
| 3 | 390 |
|
391 |
\item {}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
392 |
Delete (sub)groups (before deleting it you need to remove all group members) |
| 3 | 393 |
|
394 |
\end{itemize}
|
|
395 |
||
396 |
||
397 |
\section{Group settings}
|
|
398 |
\label{\detokenize{groups:group-settings}}
|
|
399 |
Administrators of groups (but not the ones of the subgroups) can edit the general settings of groups. |
|
400 |
||
401 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{group_settings}.png}\hspace*{\fill}}
|
|
402 |
\begin{itemize}
|
|
403 |
\item {}
|
|
404 |
Through the option \sphinxstyleemphasis{Prevent group members from deleting content} all users (including the admin) are prevented from deleting projects or any other data from the labfolder database. Projects will merely be hidden if a user decides to \sphinxstyleemphasis{Remove} it from their list of projects.
|
|
405 |
||
406 |
\item {}
|
|
407 |
By checking the option \sphinxstyleemphasis{Prevent group members from having private projects}, group members will not be allowed to have private projects. All private projects of group members will be moved into the group projects, but will not be shared with any other group members.
|
|
408 |
||
409 |
\item {}
|
|
410 |
By switching on \sphinxstyleemphasis{Users can be members of several subgroups}, users which are already members of a group can be invited again to another subgroup within the group. If switched to off members cannot be invited to subgroups of their current group.
|
|
411 |
||
412 |
\end{itemize}
|
|
413 |
||
414 |
||
415 |
\chapter{Import and export of projects and entries}
|
|
416 |
\label{\detokenize{import_export::doc}}\label{\detokenize{import_export:import-and-export-of-projects-and-entries}}
|
|
417 |
||
418 |
\section{Import}
|
|
419 |
\label{\detokenize{import_export:import}}
|
|
420 |
The import of projects (from another labfolder instance or from another logbook software) is only possible via the labfolder API. An import of labfolder-own projects via webinterface is not possible to date. You can find the API documentation here: |
|
421 |
||
422 |
\begin{DUlineblock}{0em}
|
|
423 |
\item[] Version 1: \sphinxurl{http://labfolder.rz-berlin.mpg.de:9091/api/v1}
|
|
424 |
\item[] Version 2: \sphinxurl{https://labfolder.rz-berlin.mpg.de/api/v2/docs/development.html}
|
|
425 |
\end{DUlineblock}
|
|
426 |
||
427 |
Version 2 is still in the development phase. |
|
428 |
||
429 |
||
430 |
\section{Export}
|
|
431 |
\label{\detokenize{import_export:export}}
|
|
| 13 | 432 |
Exporting projects (or just single entries) is possible in three different formats: PDF, XHTML and JSON. The \sphinxstylestrong{export as PDF} can be done from within a project …
|
| 3 | 433 |
|
434 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{export_of_projects}.png}\hspace*{\fill}}
|
|
435 |
||
436 |
… or from the project overview (\sphinxstyleemphasis{Manage \textgreater{} Projects}):
|
|
437 |
||
438 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{export_of_projects2}.png}\hspace*{\fill}}
|
|
439 |
||
| 13 | 440 |
The \sphinxstylestrong{XHTML export} can be done via the settings:
|
| 3 | 441 |
|
442 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=0.700\linewidth]{{export_xhtml}.png}\hspace*{\fill}}
|
|
443 |
||
444 |
However, to use this type of export it has to be installed first in the \sphinxstyleemphasis{Manage \textgreater{} Apps} section. By means of the XHTML export all projects that one owns will be exported. A detailled selection of projects or entries to be exported is not possible. As soon as the export process is finished a download link appears in the settings in \sphinxstyleemphasis{Data exports}. The downloadable ZIP file contains all images and files along with an index.html file that contains information about all entries. You could open and view the index.html file in a browser similar to the view in labfolder.
|
|
445 |
||
| 13 | 446 |
The \sphinxstylestrong{JSON export} is only useable via the API endpoint \sphinxcode{GET /entries}. However, at the moment the response only contains useful information such as dates and tags. The author name is hidden behind the author ID and the entry text content is completely missing.
|
| 3 | 447 |
|
448 |
||
449 |
\chapter{Importing projects from e.g. the ELOGbook to Labfolder at the FHI}
|
|
450 |
\label{\detokenize{importing_from_elog:importing-projects-from-e-g-the-elogbook-to-labfolder-at-the-fhi}}\label{\detokenize{importing_from_elog::doc}}
|
|
451 |
The ELOG entries of a certain project need to be exported as \sphinxstyleemphasis{Raw} which looks like this:
|
|
452 |
||
453 |
\fvset{hllines={, ,}}%
|
|
454 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
455 |
\PYGZdl{}@MID@\PYGZdl{}: 12
|
|
456 |
Date: Tue, 03 Dec 2013 12:15:14 +0100 |
|
457 |
Author: Wieland SchÃ\P{}llkopf
|
|
458 |
Author Email: mailto:wschoell@fhi\PYGZhy{}berlin.mpg.de
|
|
459 |
Category: Shift summary |
|
460 |
Subject: 1st solid\PYGZhy{}state experiment with FHI FEL
|
|
461 |
Severity: DOCU |
|
462 |
Keywords: |
|
463 |
Record date: 1386069171 |
|
464 |
Attachment: |
|
465 |
Encoding: HTML |
|
466 |
======================================== |
|
467 |
\PYGZlt{}p\PYGZgt{}Today Alex Paarmann and Marc Herzog are measuring in the wavelength range from 10 to 20 micron with a 0.5 mm thick GGG (Gadolinium Gallium Garnet, \PYGZlt{}a title=\PYGZdq{}Gadolinium\PYGZdq{} href=\PYGZdq{}http://en.wikipedia.org/wiki/Gadolinium\PYGZdq{}\PYGZgt{}Gd\PYGZlt{}/a\PYGZgt{}\PYGZlt{}sub\PYGZgt{}3\PYGZlt{}/sub\PYGZgt{}\PYGZlt{}a title=\PYGZdq{}Gallium\PYGZdq{} href=\PYGZdq{}http://en.wikipedia.org/wiki/Gallium\PYGZdq{}\PYGZgt{}Ga\PYGZlt{}/a\PYGZgt{}\PYGZlt{}sub\PYGZgt{}5\PYGZlt{}/sub\PYGZgt{}\PYGZlt{}a title=\PYGZdq{}Oxygen\PYGZdq{} href=\PYGZdq{}http://en.wikipedia.org/wiki/Oxygen\PYGZdq{}\PYGZgt{}O\PYGZlt{}/a\PYGZgt{}\PYGZlt{}sub\PYGZgt{}12\PYGZlt{}/sub\PYGZgt{}). Electron energy is set to 26 MeV.\PYGZlt{}/p\PYGZgt{}
|
|
468 |
\end{sphinxVerbatim}
|
|
469 |
||
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
470 |
The entry shown above looks like this in the ELOG webinterface: |
| 3 | 471 |
|
472 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=1.000\linewidth]{{elog_entry}.png}\hspace*{\fill}}
|
|
473 |
||
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
474 |
What is noticeable is that the ELOG export comes with an “Ã\P{}” instead of an “ö”. Interestingly, if only entries done by Wieland are exported the export file has UTF-8 encoding which can actually print German “Umlaute” (ö, ä, ü). If, however, all entries are exported the encoding changes to an encoding that cannot handle e.g. “ö”.
|
| 3 | 475 |
|
476 |
After importing the above ELOG entry into labfolder this entry appears like that: |
|
477 |
||
478 |
\noindent{\hspace*{\fill}\sphinxincludegraphics[width=1.000\linewidth]{{entry_after_import}.png}\hspace*{\fill}}
|
|
479 |
||
480 |
||
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
481 |
\section{Using python to import from ELOG to labfolder}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
482 |
\label{\detokenize{importing_from_elog:using-python-to-import-from-elog-to-labfolder}}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
483 |
There is a GitHub project containing a python program for importing a raw (see the export example above) ELOG project. Get the project files by typing: |
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
484 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
485 |
\fvset{hllines={, ,}}%
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
486 |
\begin{sphinxVerbatim}[commandchars=\\\{\}]
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
487 |
\PYGZdl{} git clone https://github.molgen.mpg.de/weiher/elog2labfolder.git
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
488 |
\end{sphinxVerbatim}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
489 |
|
| 13 | 490 |
The script \sphinxstyleemphasis{elog2labfolder.py} is meant to be executed from remote, that is, not on the machine on which labfolder is running. A prerequisit is the python MySQLDB package because for a few methods the labfolder API cannot be used, instead, direct manipulation of the labfolder MySQL database is needed. The actual labfolder API is applied in the methodes collected in \sphinxstyleemphasis{myPythonAPIv1.py} and \sphinxstyleemphasis{myPythonAPIv2.py}. Mostly, API version 2 is used but adding text at the end of an entry can only be accomplished by using the version 1 API call. \sphinxstyleemphasis{getListOfAuthors.py} gives you a list of all authors that are mentioned in a raw ELOG export file.
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
491 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
492 |
|
| 13 | 493 |
\section{Alternatives to manipulating the labfolder DB on MySQL level}
|
494 |
\label{\detokenize{importing_from_elog:alternatives-to-manipulating-the-labfolder-db-on-mysql-level}}
|
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
495 |
As mentioned previously: a few methods in the python API use a direct manipulation of the labfolder DB via MySQL queries. These methods are: |
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
496 |
\begin{itemize}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
497 |
\item {}
|
| 13 | 498 |
\sphinxstyleemphasis{createUserAccount(email, author, entryContent, verboseOutput, cursor, db)}: If an author of an ELOG logbook entry does not yet have a labolder account this account is created on the fly by setting a default (encrypted) password. This password is irrelevant because labfolder checks the entered password with the one from the LDAP server. Note: when setting a password in the DB labfolder’s LDAP authentication needs to be disabled (FEATURE\_LDAP\_AUTHENTICATION=false) beforehand and enabled again after the setting process is finished.
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
499 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
500 |
\item {}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
501 |
\sphinxstyleemphasis{updateAuthor(userID, blockID, cursor, db)}: Update the author of an entry. With the script \sphinxstyleemphasis{elog2labfolder.py} an entry is created with the author that is the person whose labfolder credentials are used to get the login token. Via this method the true author can be set to the passed in \sphinxstyleemphasis{userID}.
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
502 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
503 |
\item {}
|
| 13 | 504 |
\sphinxstyleemphasis{updateDateAndTime(date, blockID, cursor, db)}: Similar to \sphinxstyleemphasis{updateAuthor()} this method sets the creation and modification date to the creation time and date of the entry to be imported. This is necessary because otherwise creation and modification date in labfolder are the time and date when the import took place.
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
505 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
506 |
\end{itemize}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
507 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
508 |
The labfolder support suggested the following alternative involving using the labfolder API: |
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
509 |
\begin{itemize}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
510 |
\item {}
|
| 13 | 511 |
User account: A user account can be created via the API 2 endpoint \sphinxcode{/auth/signup}. The password will be an encrypted dummy password. In order for this to work the LDAP authentication must be turned off when this endpoint is called. After the account creation LDAP authentication should be turned on again. Once the true user of this account logs in labfolder will ignore the dummy password and check the entered password against the password stored in LDAP.
|
512 |
||
513 |
\item {}
|
|
514 |
Author: To create a labfolder entry by using the original entry’s author needs a special work-around. \sphinxstylestrong{First, make sure to prevent labfolder users from accessing labfolder for the time of the import.} Then, manually change all user passwords in the DB to the same (encrypted) password. Switch off the LDAP authentication and restart labolder. Now, import entry by entry and get a new login token for each new entry. It is only possible to get login tokens for all users because they all have the same known password. If the author of the entry to be imported does not exist yet in the DB you need to create an account via the API 2 endpoint \sphinxcode{/auth/signup}. Now you reopen the access to the labfolder instance and switch on LDAP again restarting labfolder afterwards. The users can login using their FHI credentials no matter the “universal” password in the DB. If LDAP authentication is not turned on the users could do a password recovery on the login screen and re-set their password to their liking.
|
|
515 |
||
516 |
\item {}
|
|
517 |
Date and time: Since you cannot change creation and modification time stamp of an entry via the API you could instead create custom dates during the import of an entry. The original entry creation timestamp could be “Original entry creation” followed by the creation time and date of the import. All entries can be filtered and searched by the custom dates. |
|
|
11
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
518 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
519 |
\end{itemize}
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
520 |
|
|
ccfe3c7fa0d2
Erweiterung der Doku um ein Kapitel zum Import und Export; das Kapitel ist noch nicht ganz fertig
weiher
parents:
3
diff
changeset
|
521 |
|
| 3 | 522 |
|
523 |
\renewcommand{\indexname}{Index}
|
|
524 |
\printindex |
|
525 |
\end{document} |