Hallo zusammen,
ich bin schon recht weit gekommen, openpetra in folgendem docker-compose setup...
- openpetra + nginx
- phpmyadmin
- mariadb
- draußen herum traefik reverse proxy
... zum Laufen zu bekommen.
Im Grunde nutze ich getopenpetra.sh (mit ein Paar Anpassungen um systemd aus dem Weg zu gehen).
cat Dockerfile
FROM debian:10
RUN apt-get update && apt-get install -y curl wget vim net-tools netcat cron
RUN mkdir -p /home/openpetra && cd /home/openpetra && \
curl -o getopenpetra.sh https://getopenpetra.com && \
sed -i 's/systemctl/#systemctl/g' getopenpetra.sh && \
sed -i '/initdb/d' getopenpetra.sh && \
bash getopenpetra.sh test
ADD run.sh /run.sh
CMD [ "/run.sh" ]
cat run.sh
#!/bin/bash
# init home of $OP_CUSTOMER
useradd -s /bin/bash -m -d /home/${OP_CUSTOMER} ${OP_CUSTOMER}
chown -R ${OP_CUSTOMER}:openpetra /home/${OP_CUSTOMER}
/home/openpetra/openpetra-server.sh init
# init database
## only execute this at first run!
## make sure /home/${OP_CUSTOMER}/etc/PetraServerConsole.config is filled with database config
# /home/openpetra/openpetra-server.sh initdb
# start nginx
/usr/sbin/nginx
# start server for $OP_CUSTOMER
su ${OP_CUSTOMER} bash -c "/home/openpetra/openpetra-server.sh start"
Außerdem habe ich eine angepasste /home/${OP_CUSTOMER}/etc/PetraServerConsole.config mit Verweis auf den mysql container.
initdb schlägt nun Fehl mit folgender Meldung:
/home/openpetra/openpetra-server.sh initdb
cat: /usr/lib/systemd/system/openpetra.service: No such file or directory
preparing OpenPetra database...
creating tables...
ERROR 1050 (42S01) at line 5: Table 's_user' already exists
initial data...
ERROR 1062 (23000) at line 1: Duplicate entry 'SYSADMIN' for key 'PRIMARY'
loading database from /home/openpetra/db/clean.yml.gz with config /home/${OP_CUSTOMER}/etc/PetraServerConsole.config
13:55:43 Running InitThread for thread id 1
13:55:43 FindSessionID: Session ID not found in the HttpContext
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 number of database connections 1
13:55:43 Connecting to database MySQL SessionInitThread (Conn.Identifier: 26b1c340-eccc-46d5-9e79-6c68a494e495) (Connection Name: SessionInitThread): SERVER=db;DATABASE=openpetra;Convert Zero Datetime=True;UID=openpetra;PASSWORD=*hidden* (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
13:55:43 Begin Transaction WriteTransaction in Connection SessionInitThread with level Serializable
13:55:43 TSession: Creating new session: 120281db-f88a-4c46-8c1e-7164b3e39b36
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 (Context: 'Ict.Common.DB.TDataBase.ExecuteNonQuery()')
The SQL query is:
DELETE
FROM PUB_s_session
WHERE s_valid_until_d < NOW()
13:55:43 Entering Ict.Common.DB.TDataBase.Command()...
13:55:43 Ict.Common.DB.TDataBase.Command: now getting DbCommand(DELETE FROM PUB_s_session WHERE s_valid_until_d < NOW())...
13:55:43 Query formatted for MySQL: DELETE FROM s_session WHERE s_valid_until_d < NOW()
13:55:43 Number of rows affected: 0
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 (Context: 'Ict.Common.DB.TDataBase.ExecuteScalar()')
The SQL query is:
SELECT COUNT(*)
FROM PUB_s_session
WHERE s_session_id_c = ?
13:55:43 Parameter: 1 120281db-f88a-4c46-8c1e-7164b3e39b36 System.String VarChar 36
13:55:43 Ict.Common.DB.TDataBase.ExecuteScalar: now creating Command(SELECT COUNT(*) FROM PUB_s_session WHERE s_session_id_c = ?)...
13:55:43 Entering Ict.Common.DB.TDataBase.Command()...
13:55:43 Ict.Common.DB.TDataBase.Command: now getting DbCommand(SELECT COUNT(*) FROM PUB_s_session WHERE s_session_id_c = ?)...
13:55:43 Query formatted for MySQL: SELECT COUNT(*) FROM s_session WHERE s_session_id_c = ?
13:55:43 Ict.Common.DB.TDataBase.ExecuteScalar: now calling Command.ExecuteScalar...
13:55:43 Ict.Common.DB.TDataBase.ExecuteScalar: finished calling Command.ExecuteScalar
13:55:43 Result from ExecuteScalar is 0 System.Int64
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 (Context: 'Ict.Common.DB.TDataBase.ExecuteNonQuery()')
The SQL query is:
INSERT INTO PUB_s_session (s_session_values_c, s_session_id_c, s_valid_until_d) VALUES (?,?,?)
13:55:43 Parameter: 1 {} System.String Text 2
13:55:43 Parameter: 2 120281db-f88a-4c46-8c1e-7164b3e39b36 System.String VarChar 36
13:55:43 Parameter: 3 01/09/2020 13:55:43 System.DateTime DateTime 0
13:55:43 Entering Ict.Common.DB.TDataBase.Command()...
13:55:43 Ict.Common.DB.TDataBase.Command: now getting DbCommand(INSERT INTO PUB_s_session (s_session_values_c, s_session_id_c, s_valid_until_d) VALUES (?,?,?))...
13:55:43 Query formatted for MySQL: INSERT INTO s_session (s_session_values_c, s_session_id_c, s_valid_until_d) VALUES (?,?,?)
13:55:43 Number of rows affected: 1
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
13:55:43 Transaction WriteTransaction in Connection SessionInitThread committed
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
13:55:43 DB Transaction (Trans.Identifier: 327544e7-b473-41f7-b493-1218d90ec600) (Transaction Name: WriteTransaction) got rolled back. Before that, its DB Transaction Properties were: Valid: True, IsolationLevel: Serializable (it got started on Thread System.Threading.Thread in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe').
13:55:43 Waiting to obtain Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Obtained Thread-safe access to the Database Abstraction Layer... (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')
13:55:43 Closing Database connection... (Conn.Identifier: 26b1c340-eccc-46d5-9e79-6c68a494e495) (Connection Name: SessionInitThread)
13:55:43 TDataBase.CloseDBConnectionInternal: (Conn.Identifier: 26b1c340-eccc-46d5-9e79-6c68a494e495) (Connection Name: SessionInitThread) before calling FDBConnectionInstance.CloseODBCConnection(FConnection) in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe'
TLogWriter:Log was not able to write to the log file. msg: TDataBase.CloseDBConnectionInternal: (Conn.Identifier: 26b1c340-eccc-46d5-9e79-6c68a494e495) (Connection Name: SessionInitThread) before calling FDBConnectionInstance.CloseODBCConnection(FConnection) in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe'
System.ArgumentException: Empty path name is not legal.
at System.IO.StreamWriter..ctor (System.String path, System.Boolean append, System.Text.Encoding encoding, System.Int32 bufferSize, System.Boolean checkHost) [0x0003e] in <d0e12f672b88444ab4b6d9b2ecf20142>:0
at System.IO.StreamWriter..ctor (System.String path, System.Boolean append, System.Text.Encoding encoding, System.Int32 bufferSize) [0x00000] in <d0e12f672b88444ab4b6d9b2ecf20142>:0
at System.IO.StreamWriter..ctor (System.String path, System.Boolean append) [0x00008] in <d0e12f672b88444ab4b6d9b2ecf20142>:0
at (wrapper remoting-invoke-with-check) System.IO.StreamWriter..ctor(string,bool)
at System.IO.File.AppendAllText (System.String path, System.String contents) [0x00000] in <d0e12f672b88444ab4b6d9b2ecf20142>:0
at Ict.Common.TLogWriter.Log (System.String strFile, System.String strMessage) [0x00127] in <d7679a5332214acbb276fa24a36da2f5>:0
Unhandled Exception:
Ict.Common.ENoLoggingToFile_WrongConstructorUsedException: Exception of type 'Ict.Common.ENoLoggingToFile_WrongConstructorUsedException' was thrown.
at Ict.Common.TLogging.Log (System.String Text, Ict.Common.TLoggingType ALoggingType, Ict.Common.TLogging+TStatusCallbackProcedure ACustomStatusCallbackProcedure) [0x0021e] in <d7679a5332214acbb276fa24a36da2f5>:0
at Ict.Common.DB.TDataBase.CloseDBConnectionInternal (System.Boolean ASuppressThreadCompatibilityCheck) [0x0016c] in <6d939accbca64f6d9a704e907d217e23>:0
at Ict.Common.DB.TDataBase.CloseDBConnection (System.Boolean ASuppressThreadCompatibilityCheck) [0x00021] in <6d939accbca64f6d9a704e907d217e23>:0
at Ict.Common.Session.TSession.InitThread (System.String ASessionID) [0x00092] in <e5e2f192c90a49939f0f34aa58ac0868>:0
at Ict.Petra.Tools.MSysMan.YmlGzImportExport.TYmlGzImportExport.Main (System.String[] args) [0x0006c] in <a089e5e4b08249658eb3fa64a72a60e3>:0
13:55:43 Released Thread-safe access to the Database Abstraction Layer. (Call performed in Thread 1 in AppDomain 'Ict.Petra.Tools.MSysMan.YmlGzImportExport.exe')...
[ERROR] FATAL UNHANDLED EXCEPTION: Ict.Common.ENoLoggingToFile_WrongConstructorUsedException: Exception of type 'Ict.Common.ENoLoggingToFile_WrongConstructorUsedException' was thrown.
at Ict.Common.TLogging.Log (System.String Text, Ict.Common.TLoggingType ALoggingType, Ict.Common.TLogging+TStatusCallbackProcedure ACustomStatusCallbackProcedure) [0x0021e] in <d7679a5332214acbb276fa24a36da2f5>:0
at Ict.Common.DB.TDataBase.CloseDBConnectionInternal (System.Boolean ASuppressThreadCompatibilityCheck) [0x0016c] in <6d939accbca64f6d9a704e907d217e23>:0
at Ict.Common.DB.TDataBase.CloseDBConnection (System.Boolean ASuppressThreadCompatibilityCheck) [0x00021] in <6d939accbca64f6d9a704e907d217e23>:0
at Ict.Common.Session.TSession.InitThread (System.String ASessionID) [0x00092] in <e5e2f192c90a49939f0f34aa58ac0868>:0
at Ict.Petra.Tools.MSysMan.YmlGzImportExport.TYmlGzImportExport.Main (System.String[] args) [0x0006c] in <a089e5e4b08249658eb3fa64a72a60e3>:0
Im browser lädt eine openpetra Seite, jedoch hat diese nur den Inhalt:
"icon" Loading...
Hat jemand einen Tipp, was noch falsch läuft.
Grüße,
yeoldegrove
