• Hilfe bei Datenbank

      Schön guten Tag
      ich habe nun meien datenbnak so weit einrerichtet das ich mir Admin rechte geben kann.
      kann auch dann Spawnwn , gehe ich nach dem Spawn wieder in die Lobby und will wieder rein , meldet mir der Server nur empfange Daten ...... Überprüfe
      kann mir da jemadn sagen was da dass Problem ist oder was ich da gegen tun muss

      Am besten ist es dazu die Datenbank & Serverseitigen RPT-Logs zu posten. Auf Anhieb, kann man da halt nur sagen, dass er in dem Skript für das beziehen der Daten aus der DB hängen bleibt. Aber genaueres kann man nur aus den Logs entnehmen.

      Datenbank-Logs
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Version: 35
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Windows Version
      [15:21:08 +02:00] [Thread 3702463178] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
      [15:21:08 +02:00] [Thread 3702463178] Message: If you like [lexicon]extDB[/lexicon] consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
      [15:21:08 +02:00] [Thread 3702463178] Message: Note currently most/all development for [lexicon]extDB[/lexicon] is done on a Linux Server
      [15:21:08 +02:00] [Thread 3702463178] Message: Torndeco: 24/01/15
      [15:21:08 +02:00] [Thread 3702463178]
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Found [lexicon]extdb[/lexicon]-conf.ini
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Detected 2 Cores, Setting up 2 Worker Threads
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Database Type: MySQL
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: Database Session Pool Started
      [15:21:08 +02:00] [Thread 3702463178] [lexicon]extDB[/lexicon]: DB_RAW_V3: Initialized: ADD_QUOTES True
      [15:21:09 +02:00] [Thread 692091952] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: execute command denied to user 'arma3'@'localhost' for routine 'arma3life.resetLifeVehicles' [mysql_stmt_errno]: 1370 [mysql_stmt_sqlstate]: 42000 [statemnt]: CALL resetLifeVehicles
      [15:21:09 +02:00] [Thread 692091952] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: CALL resetLifeVehicles

      Ja ich habe damals bei meiner DB eine extra Datenbank angelegt für einen User, der nur auf diese Datenbank Vollzugriff hatte und damit dann den Arma3Server verbinden lassen.
      Außerdem habe ich diese Prozeduren selber nochmal geschrieben und sie etwas verbesser. Aber es kann gut möglich sein, dass es da Probleme gibt.

      Ich würde auch aus Sicherheitsgründen empfehlen, nie den Root-User für externe Datenbank-Verbindungen zu nutzen.

      @Cris
      habe neue logs
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Version: 35
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Windows Version
      [18:48:41 +02:00] [Thread 158350107] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
      [18:48:41 +02:00] [Thread 158350107] Message: If you like [lexicon]extDB[/lexicon] consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
      [18:48:41 +02:00] [Thread 158350107] Message: Note currently most/all development for [lexicon]extDB[/lexicon] is done on a Linux Server
      [18:48:41 +02:00] [Thread 158350107] Message: Torndeco: 24/01/15
      [18:48:41 +02:00] [Thread 158350107]
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Found [lexicon]extdb[/lexicon]-conf.ini
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Detected 2 Cores, Setting up 2 Worker Threads
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Database Type: MySQL
      [18:48:41 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: Database Session Pool Started
      [18:48:42 +02:00] [Thread 158350107] [lexicon]extDB[/lexicon]: DB_RAW_V3: Initialized: ADD_QUOTES True

      @Cris
      20:20:22 BattlEye Server: Initialized (v1.214)
      20:20:22 Host identity created.
      20:20:22 Mission Altis Life RPG read from bank.
      20:20:24 BattlEye Server: Ping detection currently not working, MaxPing command disabled
      20:20:24 Roles assigned.
      20:20:24 Reading mission ...
      20:22:58 Mission read.
      20:23:12 Hanz Peter schwarz uses modified data file
      20:23:12 BattlEye Server: Player #0 Hanz Peter schwarz (178.19.234.232:2304) connected
      20:23:12 Player Hanz Peter schwarz connecting.
      20:23:12 Grind uses modified data file
      20:23:12 BattlEye Server: Player #1 Grind (87.156.89.120:2304) connected
      20:23:12 Player Grind connecting.
      20:23:12 Game started.
      20:23:14 BattlEye Server: Player #0 Hanz Peter schwarz - GUID: 7dc9a89c61c2e79cb2a596764596c20e
      20:23:14 BattlEye Server: Player #1 Grind - GUID: 69b6d4b097727d95c2439ae886251b4e
      20:23:18 BattlEye Server: Starting with Arma 3 1.58 all server admins will have to define a dedicated port in BEServer.cfg in order to be able to use BE RCon. Please see https://www.battleye.com/support/documentation/ for details.
      20:23:30 Player Grind disconnected.
      20:23:30 BattlEye Server: Player #1 Grind disconnected
      20:23:45 Player Hanz Peter schwarz disconnected.
      20:23:45 BattlEye Server: Player #0 Hanz Peter schwarz disconnected
      20:23:51 Hanz Peter schwarz uses modified data file
      20:23:51 BattlEye Server: Player #0 Hanz Peter schwarz (178.19.234.232:2304) connected
      20:23:51 Player Hanz Peter schwarz connecting.
      20:23:53 BattlEye Server: Player #0 Hanz Peter schwarz - GUID: 7dc9a89c61c2e79cb2a596764596c20e
      20:24:00 Grind uses modified data file
      20:24:00 BattlEye Server: Player #1 Grind (87.156.89.120:2304) connected
      20:24:00 Player Grind connecting.
      20:24:02 BattlEye Server: Player #1 Grind - GUID: 69b6d4b097727d95c2439ae886251b4e
      20:24:19 Player Grind disconnected.
      20:24:20 BattlEye Server: Player #1 Grind disconnected