MRBS: Unterschied zwischen den Versionen

Aus Doku-Wiki
Zur Navigation springenZur Suche springen
Zeile 46: Zeile 46:
 
==Datenbank Benutzer anlegen==
 
==Datenbank Benutzer anlegen==
 
  Im '''phpmyadmin''' einen Benutzer für die Datenbank '''mrbs''' anlegen und Rechte vergeben (grant)
 
  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
 +
  // 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 availabl'''e
 +
  ''' $db_tbl_prefix = "mrbs_";
 +
  // Uncomment this to NOT use PHP persistent (pooled) database connections:
 +
  // $db_nopersist = 1;

Version vom 22. August 2011, 08:49 Uhr

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