MRBS: Unterschied zwischen den Versionen
Aus Doku-Wiki
Zur Navigation springenZur Suche springenUli (Diskussion | Beiträge) |
Uli (Diskussion | Beiträge) |
||
Zeile 50: | Zeile 50: | ||
cp -r mrbs-1.4.7/web/* [WEBROOT]/ | cp -r mrbs-1.4.7/web/* [WEBROOT]/ | ||
vi config.inc.php | vi config.inc.php | ||
+ | $timezone = "Europe/Berlin"; | ||
+ | |||
+ | /******************* | ||
+ | * Database settings | ||
+ | ******************/ | ||
// Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL, | // Which database system: "pgsql"=PostgreSQL, "mysql"=MySQL, | ||
// "mysqli"=MySQL via the mysqli PHP extension | // "mysqli"=MySQL via the mysqli PHP extension |
Version vom 22. August 2011, 09:54 Uhr
Inhaltsverzeichnis
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;