MRBS

Aus Doku-Wiki
Zur Navigation springenZur Suche springen

Links

Installation

Pakete für Debian Squeeze

aptitude install apache2 mysql-server libapache2-mod-php5 libapache2-mod-auth-mysql phpmyadmin

Webserver einrichten

#---HTTP

<VirtualHost 172.20.60.20:80>
    ServerAdmin administrator@example.com
    ServerName booking.blb-karlsruhe.de
    Redirect permanent / https://booking.blb-karlsruhe.de/
</VirtualHost>

#---SSL 

<VirtualHost 172.20.60.20:443>
    ServerAdmin administrator@example.com
    SSLEngine On
    SSLCertificateFile /etc/apache2/ssl-cert/mrbs.crt.pem
    SSLCertificateKeyFile /etc/apache2/ssl-cert/mrbs.key.op.pem
    SSLCertificateChainFile /etc/apache2/ssl-cert/SSLCertifikateChainFile.pem
    DocumentRoot /var/www/mrbs/htdocs
    ServerName mrbs.example.com
    ServerAlias mrbs.example.com
    ErrorLog  /var/log/apache2/mrbs/error_log
    CustomLog /var/log/apache2/mrbs/access_log common

<Directory />
    AllowOverride None
    Options -Indexes
    <FilesMatch "^\.ht">
      Order deny,allow
      Deny from All
    </FilesMatch>
</Directory>

include /etc/phpmyadmin/apache.conf

</VirtualHost>

MySQL Datenbank anlegen

Über phpmyadmin die Datenbank mrbs anlegen

Datenbanktabellen erzeugen

 mysql -uroot -p'passwort' mrbs < mrbs-1.4.7/tables.my.sql

Datenbank Benutzer anlegen

Im phpmyadmin einen Benutzer für die Datenbank mrbs anlegen und Rechte vergeben (grant)

Konfiguration

cp -r mrbs-1.4.7/web/* [WEBROOT]/
vi config.inc.php

  $timezone = "Europe/Berlin";

  /*******************
   * Database settings
   ******************/
  // Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL,
  // "mysqli"=MySQL via the mysqli PHP extension
  $dbsys = "mysql";
  // Hostname of database server. For pgsql, can use "" instead of localhost
  // to use Unix Domain Sockets instead of TCP/IP.
  $db_host = "localhost";
  // Database name:
  $db_database = "mrbs";
  // Database login user name:
  $db_login = "mrbs";
  // Database login password:
  $db_password = 'mrbs-password';
  // Prefix for table names.  This will allow multiple installations where only
  // one database is available
  $db_tbl_prefix = "mrbs_";
  // Uncomment this to NOT use PHP persistent (pooled) database connections:
  // $db_nopersist = 1;