StuRa:Server/SRS20/2016
- für limesurvey (aka Umfragen-Server)
|
In diesem Abschnitt befinden sich Inhalte, welche noch angepasst werden müssen, da Sie auf noch nicht verfassten Inhalten basieren. |
Ports
installierte Ports
- apache22
- apr
- autoconf
- autoconf-wrapper
- automake
- automake-wrapper
- bdftopcf
- bigreqsproto
- bison
- bitstream-vera
- cmake
- cmake-modules
- compositeproto
- cups-client
- damageproto
- db41
- db42
- encodings
- expat
- fixesproto
- font-bh-ttf
- font-misc-ethiopic
- font-misc-meltho
- font-util
- fontconfig
- fontsproto
- freetype2
- gdbm
- gettext
- glib
- gmake
- gperf
- help2man
- hicolor-icon-theme
- inputproto
- intltool
- jasper
- jbigkit
- jpeg
- kbproto
- libICE
- libSM
- libX11
- libXau
- libXaw
- libXcomposite
- libXcursor
- libXdamage
- libXdmcp
- libXext
- libXfixes
- libXfont
- libXft
- libXi
- libXinerama
- libXmu
- libXp
- libXpm
- libXrandr
- libXrender
- libXt
- libcheck
- libffi
- libfontenc
- libgcrypt
- libgpg-error
- libiconv
- libpthread-stubs
- libtool
- libxcb
- libxml2
- libxslt
- limesurvey
- m4
- mkfontdir
- mkfontscale
- mysql-client
- mysql-server
- oniguruma
- openldap-client
- p5-Locale-gettext
- p5-XML-Parser
- pcre
- perl-threaded
- php5
- php5-ctype
- php5-dom
- php5-gd
- php5-hash
- php5-iconv
- php5-json
- php5-ldap
- php5-mbstring
- php5-mysql
- php5-session
- php5-simplexml
- php5-xmlwriter
- php5-zip
- pkgconf
- png
- portaudit
- portupgrade
- printproto
- python27
- randrproto
- renderproto
- ruby
- ruby18-bdb
- t1lib
- tiff
- unzip
- xcb-proto
- xcb-util
- xcmiscproto
- xextproto
- xf86bigfontproto
- xineramaproto
- xorg-fonts-truetype
- xorg-macros
- xproto
- xtrans
- zsh
konfigurierte Ports
apache22
OPTIONS_FILE_SET+=AUTH_BASIC
OPTIONS_FILE_SET+=AUTH_DIGEST
OPTIONS_FILE_SET+=AUTHN_ALIAS
OPTIONS_FILE_SET+=AUTHN_ANON
OPTIONS_FILE_UNSET+=AUTHN_DBD
OPTIONS_FILE_SET+=AUTHN_DBM
OPTIONS_FILE_SET+=AUTHN_DEFAULT
OPTIONS_FILE_SET+=AUTHN_FILE
OPTIONS_FILE_SET+=AUTHZ_DBM
OPTIONS_FILE_SET+=AUTHZ_DEFAULT
OPTIONS_FILE_SET+=AUTHZ_GROUPFILE
OPTIONS_FILE_SET+=AUTHZ_HOST
OPTIONS_FILE_SET+=AUTHZ_OWNER
OPTIONS_FILE_SET+=AUTHZ_USER
OPTIONS_FILE_UNSET+=AUTHNZ_LDAP
OPTIONS_FILE_UNSET+=LDAP
OPTIONS_FILE_UNSET+=DBD
OPTIONS_FILE_SET+=CACHE
OPTIONS_FILE_SET+=DISK_CACHE
OPTIONS_FILE_SET+=FILE_CACHE
OPTIONS_FILE_UNSET+=MEM_CACHE
OPTIONS_FILE_SET+=DAV
OPTIONS_FILE_SET+=DAV_FS
OPTIONS_FILE_UNSET+=DAV_LOCK
OPTIONS_FILE_SET+=ACTIONS
OPTIONS_FILE_SET+=ALIAS
OPTIONS_FILE_SET+=ASIS
OPTIONS_FILE_SET+=AUTOINDEX
OPTIONS_FILE_SET+=CERN_META
OPTIONS_FILE_SET+=CGI
OPTIONS_FILE_UNSET+=CGID
OPTIONS_FILE_SET+=CHARSET_LITE
OPTIONS_FILE_SET+=DEFLATE
OPTIONS_FILE_SET+=DIR
OPTIONS_FILE_SET+=DUMPIO
OPTIONS_FILE_SET+=ENV
OPTIONS_FILE_SET+=EXPIRES
OPTIONS_FILE_SET+=HEADERS
OPTIONS_FILE_SET+=IMAGEMAP
OPTIONS_FILE_SET+=INCLUDE
OPTIONS_FILE_SET+=INFO
OPTIONS_FILE_SET+=LOG_CONFIG
OPTIONS_FILE_SET+=LOGIO
OPTIONS_FILE_SET+=MIME
OPTIONS_FILE_SET+=MIME_MAGIC
OPTIONS_FILE_SET+=NEGOTIATION
OPTIONS_FILE_SET+=REWRITE
OPTIONS_FILE_SET+=SETENVIF
OPTIONS_FILE_SET+=SPELING
OPTIONS_FILE_SET+=STATUS
OPTIONS_FILE_SET+=UNIQUE_ID
OPTIONS_FILE_SET+=USERDIR
OPTIONS_FILE_SET+=USERTRACK
OPTIONS_FILE_SET+=VHOST_ALIAS
OPTIONS_FILE_SET+=FILTER
OPTIONS_FILE_UNSET+=SUBSTITUTE
OPTIONS_FILE_SET+=VERSION
OPTIONS_FILE_SET+=SSL
OPTIONS_FILE_UNSET+=SUEXEC
OPTIONS_FILE_UNSET+=SUEXEC_RSRCLIMIT
OPTIONS_FILE_UNSET+=SUEXEC_USERDIR
OPTIONS_FILE_SET+=REQTIMEOUT
OPTIONS_FILE_UNSET+=PROXY
OPTIONS_FILE_UNSET+=IPV4_MAPPED
OPTIONS_FILE_UNSET+=BUCKETEER
OPTIONS_FILE_UNSET+=CASE_FILTER
OPTIONS_FILE_UNSET+=CASE_FILTER_IN
OPTIONS_FILE_UNSET+=EXT_FILTER
OPTIONS_FILE_UNSET+=LOG_FORENSIC
OPTIONS_FILE_UNSET+=OPTIONAL_HOOK_EXPORT
OPTIONS_FILE_UNSET+=OPTIONAL_HOOK_IMPORT
OPTIONS_FILE_UNSET+=OPTIONAL_FN_IMPORT
OPTIONS_FILE_UNSET+=OPTIONAL_FN_EXPORT
OPTIONS_FILE_UNSET+=PROXY_AJP
OPTIONS_FILE_UNSET+=PROXY_BALANCER
OPTIONS_FILE_UNSET+=PROXY_CONNECT
OPTIONS_FILE_UNSET+=PROXY_FTP
OPTIONS_FILE_UNSET+=PROXY_HTTP
OPTIONS_FILE_UNSET+=PROXY_SCGI
apr
OPTIONS_FILE_SET+=THREADS
OPTIONS_FILE_SET+=IPV6
OPTIONS_FILE_SET+=DEVRANDOM
OPTIONS_FILE_SET+=BDB
OPTIONS_FILE_SET+=GDBM
OPTIONS_FILE_UNSET+=LDAP
OPTIONS_FILE_SET+=MYSQL
OPTIONS_FILE_UNSET+=NDBM
OPTIONS_FILE_UNSET+=PGSQL
OPTIONS_FILE_UNSET+=SQLITE
cups-client
OPTIONS_FILE_UNSET+=GNUTLS
gdbm
WITHOUT_COMPAT=true
glib20
WITHOUT_COLLATION_FIX=true
help2man
jasper
WITHOUT_OPENGL=true
WITHOUT_UUID=true
libiconv
libxslt
WITHOUT_MEM_DEBUG=true
WITH_CRYPTO=true
m4
mysql
OPTIONS_FILE_SET+=SSL
OPTIONS_FILE_UNSET+=FASTMTX
mysql55-client
OPTIONS_FILE_SET+=SSL
OPTIONS_FILE_UNSET+=FASTMTX
openldap24-client
OPTIONS_FILE_UNSET+=FETCH
OPTIONS_FILE_UNSET+=SASL
pcre
perl-threaded
php5
OPTIONS_FILE_SET+=CLI
OPTIONS_FILE_SET+=CGI
OPTIONS_FILE_UNSET+=FPM
OPTIONS_FILE_SET+=APACHE
OPTIONS_FILE_UNSET+=AP2FILTER
OPTIONS_FILE_UNSET+=EMBED
OPTIONS_FILE_UNSET+=DEBUG
OPTIONS_FILE_UNSET+=DTRACE
OPTIONS_FILE_SET+=IPV6
OPTIONS_FILE_UNSET+=MAILHEAD
OPTIONS_FILE_UNSET+=LINKTHR
php5-gd
OPTIONS_FILE_SET+=T1LIB
OPTIONS_FILE_SET+=TRUETYPE
OPTIONS_FILE_UNSET+=JIS
OPTIONS_FILE_SET+=X11
OPTIONS_FILE_UNSET+=VPX
php5-mbstring
OPTIONS_FILE_SET+=REGEX
php5-mysql
OPTIONS_FILE_UNSET+=MYSQLND
png
OPTIONS_FILE_UNSET+=APNG
portupgrade
python27
OPTIONS_FILE_SET+=EXAMPLES
OPTIONS_FILE_UNSET+=FPECTL
OPTIONS_FILE_SET+=IPV6
OPTIONS_FILE_SET+=NLS
OPTIONS_FILE_UNSET+=PTH
OPTIONS_FILE_SET+=PYMALLOC
OPTIONS_FILE_UNSET+=SEM
OPTIONS_FILE_SET+=THREADS
OPTIONS_FILE_UNSET+=UCS2
OPTIONS_FILE_SET+=UCS4
ruby
zsh
ohne config
- www/limesurvey
Konfiguration der Programme
Apache22
- httpd.conf
<IfModule php5_module> DirectoryIndex index.php index.html AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps </IfModule> ... ServerName <domain>:80 ... Include etc/apache22/extra/httpd-ssl.conf ... ServerTokens ProductOnly ServerSignature Off
- /extra/httpd-ssl.conf
Listen <IP>:443 ... <VirtualHost <IP>:443> ... Serveradmin <mailadresse> ... Servername <domain> ... SSLEngine on ... SSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL ... SSLCertificateFile "/usr/local/www/apache22/data/ssl/certs/cert.pem" ... SSLCertificateKeyFile "/usr/local/www/apache22/data/ssl/key/key.pem" ... SSLCACertificateFile "/usr/local/www/apache22/data/ssl/certs/cazertifikate.pem" ... SetEnvIf User-Agent ".*MSIE.*" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0
- /extra/httpd-vhost.conf
NameVirtualHost <IP>:80
...
<VirtualHost 1<IP>:80>
ServerAdmin webmaster@<domain>
DocumentRoot "/usr/local/www/limesurvey/"
ServerName <domain>
RewriteEngine On
RewriteCond %{REQUEST_METHOD} ^TRACE
RewriteRule .* - [F]
RewriteCond %{SERVER_PORT} !443
RewriteRule (.*) https://<domain> [R]
</VirtualHost>
- data/
- impressum.html erstellt
- images/
- image00.jpg
- image01.png
Limesurvey
- config.php
$databasepass = '<mysqlpassword>'; ... $defaultuser = '<adminusername>'; $defaultpass = '<password>'; ... $siteadminemail = 'umfragen@stura.htw-dresden.de'; $siteadminbounce = 'umfragen@stura.htw-dresden.de'; $siteadminname = 'StuRa HTW Dresden';
SQL Import
- limesurvey/admin/cmdline_importsurvey.php
php cmdline_importsurvey <File to import> [<user> <password>]
Mysql-server
starten
/usr/local/etc/rc.d/mysql-server onestart
Password setzen
mysqladmin -u <benutzer> password <password>
Konfiguration des System
rc.conf
apache22_enable="YES" mysql_enable="YES"