StuRa:Server/SRS20/2016: Unterschied zwischen den Versionen

Aus Wiki StuRa HTW Dresden
Zur Navigation springen Zur Suche springen
Zeile 359: Zeile 359:
==== [[Server/Jails#zsh | zsh]] ====
==== [[Server/Jails#zsh | zsh]] ====


== ohne config ==


* www/limesurvey
=== zusätzliche Konfigurationsdateien ===


== Konfiguration der Programme ==
==== Jail ====


=== Apache22 ===
===== /etc/rc.conf =====


*httpd.conf
<code>
apache22_enable="YES"
mysql_enable="YES"
</code>


==== Apache22 ====
===== httpd.conf =====
<code>
…
LoadModule php5_module        libexec/apache22/libphp5.so
  <IfModule php5_module>
  <IfModule php5_module>
   DirectoryIndex index.php index.html
   DirectoryIndex index.php index.html
Zeile 381: Zeile 391:
  ServerTokens ProductOnly
  ServerTokens ProductOnly
  ServerSignature Off
  ServerSignature Off
</code>


*/extra/httpd-ssl.conf
===== /extra/httpd-ssl.conf =====


<code>
  Listen <IP>:443
  Listen <IP>:443
  ...
  ...
Zeile 405: Zeile 417:
  nokeepalive ssl-unclean-shutdown \
  nokeepalive ssl-unclean-shutdown \
  downgrade-1.0 force-response-1.0
  downgrade-1.0 force-response-1.0
</code>


*/extra/httpd-vhost.conf
===== /extra/httpd-vhost.conf =====


  <code>
  <code>
Zeile 423: Zeile 436:
  </code>
  </code>


*data/
* data/
**impressum.html erstellt
** impressum.html erstellt
**images/
** images/
***image00.jpg
*** image00.jpg
***image01.png
*** image01.png


=== Limesurvey ===
==== Limesurvey ====


*config.php
===== config.php =====


<code>
  $databasepass      =  '<mysqlpassword>';
  $databasepass      =  '<mysqlpassword>';
  ...
  ...
Zeile 441: Zeile 455:
  $siteadminbounce = 'umfragen@stura.htw-dresden.de';
  $siteadminbounce = 'umfragen@stura.htw-dresden.de';
  $siteadminname = 'StuRa HTW Dresden';
  $siteadminname = 'StuRa HTW Dresden';
</code>


==== SQL Import ====
===== SQL Import =====


*limesurvey/admin/cmdline_importsurvey.php
; limesurvey/admin/cmdline_importsurvey.php


  <code>
  <code>
Zeile 450: Zeile 465:
  </code>
  </code>


=== Mysql-server ===
==== Mysql-server ====


starten
; starten


  <code>
  <code>
Zeile 458: Zeile 473:
  </code>
  </code>


Password setzen
; Password setzen


  <code>
  <code>
  mysqladmin -u <benutzer> password <password>
  mysqladmin -u <benutzer> password <password>
  </code>
  </code>
== Konfiguration des System ==
=== rc.conf ===
apache22_enable="YES"
mysql_enable="YES"


== Siehe auch ==
== Siehe auch ==

Version vom 28. Oktober 2012, 18:16 Uhr

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

zusätzliche Konfigurationsdateien

Jail

/etc/rc.conf

apache22_enable="YES"
mysql_enable="YES"

Apache22

httpd.conf

…
LoadModule php5_module        libexec/apache22/libphp5.so

<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>

Siehe auch

Media:Beispiel.mp3

Abgerufen von „https://wiki.stura.htw-dresden.de/index.php?title=StuRa:Server/SRS20/2016&oldid=21961“