Datenbankproblem

    Hallo liebe Gemeinde,

    bevor die Fragen aufkommen, ja ich habe alle Tutorials gelesen und auch verstanden. Bin auch genau nach dieses vorgegangen.

    Nur leider möchte meine Datenbank einfach nicht richtig laufen, wenn ich es den Logs richtig entnehme, scheint sie sich ja zu verbinden, aber ich habe immer "Setting up Client"

    Hier mal der Log von [lexicon]extDB[/lexicon]:

    Spoiler anzeigen

    [17:49:23 +02:00] [Thread 2630795112] extDB: Version: 35
    [17:49:23 +02:00] [Thread 2630795112] extDB: Windows Version
    [17:49:23 +02:00] [Thread 2630795112] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
    [17:49:23 +02:00] [Thread 2630795112] Message: If you like extDB consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
    [17:49:23 +02:00] [Thread 2630795112] Message: Note currently most/all development for extDB is done on a Linux Server
    [17:49:23 +02:00] [Thread 2630795112] Message: Torndeco: 24/01/15
    [17:49:23 +02:00] [Thread 2630795112]
    [17:49:23 +02:00] [Thread 2630795112] extDB: Found extdb-conf.ini
    [17:49:23 +02:00] [Thread 2630795112] extDB: Detected 8 Cores, Setting up 6 Worker Threads
    [17:49:23 +02:00] [Thread 2630795112] extDB: Database Type: MySQL
    [17:49:23 +02:00] [Thread 2630795112] extDB: Database Session Pool Started
    [17:49:23 +02:00] [Thread 2630795112] extDB: DB_RAW_V3: Initialized: ADD_QUOTES True
    [17:49:24 +02:00] [Thread 3111113247] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist [mysql_stmt_errno]: 1449 [mysql_stmt_sqlstate]: HY000 [statemnt]: CALL resetLifeVehicles
    [17:49:24 +02:00] [Thread 3111113247] extDB: DB_RAW_V3: Error StatementException: SQL: CALL resetLifeVehicles
    [17:49:24 +02:00] [Thread 1679263722] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist [mysql_stmt_errno]: 1449 [mysql_stmt_sqlstate]: HY000 [statemnt]: CALL deleteOldHouses
    [17:49:24 +02:00] [Thread 1679263722] extDB: DB_RAW_V3: Error StatementException: SQL: CALL deleteOldHouses
    [17:49:24 +02:00] [Thread 1591850036] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist [mysql_stmt_errno]: 1449 [mysql_stmt_sqlstate]: HY000 [statemnt]: CALL deleteDeadVehicles
    [17:49:24 +02:00] [Thread 1591850036] extDB: DB_RAW_V3: Error StatementException: SQL: CALL deleteDeadVehicles
    [17:49:24 +02:00] [Thread 3953720383] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist [mysql_stmt_errno]: 1449 [mysql_stmt_sqlstate]: HY000 [statemnt]: CALL deleteOldGangs
    [17:49:24 +02:00] [Thread 3953720383] extDB: DB_RAW_V3: Error StatementException: SQL: CALL deleteOldGangs
    [17:53:37 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561197997760921' AND owned='1'
    [17:53:37 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561197997760921' AND owned='1'
    [17:58:29 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198103448349' AND owned='1'
    [17:58:29 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198103448349' AND owned='1'
    [17:58:58 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198103448349' AND owned='1'
    [17:58:58 +02:00] [Thread 1421207040] extDB: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198103448349' AND owned='1'


    Den RPT-Log füge ich als Anhang hinzu!

    Ich würde mich sehr freuen, wenn mir jemand helfen könnte.

    MfG

    Coredainity

    Achte auch darauf einen User zu erstellen und nicht root zu verwenden. Papa nox meint das wäre unsicher!
    (Ist es auch davon mal abgesehen)

    Jedoch solltest du deinen Datenbank User genauso nennen wie es dort steht: arma3

    //EDIT: Grammatik Fehler behoben.





    Jeffry ist das lebende PAWN-Lexikon.
    Quini  :love:
    Server Teamspeak 5.189.163.112

    Im rpt-log wird mir jetzt folgendes gespammt:

    "Wrong player index passed to NetworkObjectInfo::GetPlayerObjectInfo - max=0, received=1"

    Der [lexicon]extDB[/lexicon]-Log sieht nun besser aus:

    Spoiler anzeigen

    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Version: 35
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Windows Version
    [18:16:32 +02:00] [Thread 4073628490] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
    [18:16:32 +02:00] [Thread 4073628490] 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:16:32 +02:00] [Thread 4073628490] Message: Note currently most/all development for [lexicon]extDB[/lexicon] is done on a Linux Server
    [18:16:32 +02:00] [Thread 4073628490] Message: Torndeco: 24/01/15
    [18:16:32 +02:00] [Thread 4073628490]
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Found [lexicon]extdb[/lexicon]-conf.ini
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Detected 8 Cores, Setting up 6 Worker Threads
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Database Type: MySQL
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Database Session Pool Started
    [18:16:32 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: DB_RAW_V3: Initialized: ADD_QUOTES True
    [18:25:19 +02:00] [Thread 4073628490] [lexicon]extDB[/lexicon]: Stopping ...