Project

General

Profile

Bug #3061

winstitute: mysql connection durcheinander - nmhp17 (ag7)/QFQ arbeitet mit DB/Tabellen von biostat.

Added by Carsten Rose over 4 years ago. Updated 5 months ago.

Status:
Some day maybe
Priority:
High
Assignee:
Target version:
Start date:
01.02.2018
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

Auf winstitute gibt u.a. die Instanzen:

a) http://www.biostat.uzh.ch/ >> winstitute: ag_7

T3: 'database' => 't3_ag7','username' => 't3_ag7',
QFQ Extension QFQ Extension
DB User: t3_ag7 (/srv/www/ag_7/typo3conf/ext/qfq/config.ini)
form2 Extension form2 Extension
DBQ2 Extension DBQ2 Extension
DB User: dbquser (/srv/www/ag_7/typo3conf/dbq2.config.ini)

b) http://www.math.uzh.ch/nmhp17 >> winstitute: conferences_7
math.inc.conf:Alias /conferences_7 /srv/www/conferences_62

T3: database' => 't3_zss', 'username' => 't3_zss'
QFQ Extension QFQ Extension
DB_USER = zgsm, DB_NAME = zgsm (/srv/www/conferences_62/typo3conf/config.qfq.ini)
DBQ2 Extension DBQ2 Extension
DB_USER = zgsm, DB_NAME = zgsm (/srv/www/conferences_62/typo3conf/config.qfq.ini)
Das Problem:
  • je nachdem welche Website, nach einem Apache restart als erstes auferufen wird, gilt diese fuer a) und b).

Folgenen Code zum debuggen

sql1 = SELECT USER()
rend1 = <br><br>

sql2 = SHOW tables;
rend2 = <br>
tail2 = <br>

sql2a = SHOW databases;
rend2a = <br>
tail2a = <br>

Test

Biostat Seite:

  • Apache restart

Also available in: Atom PDF