waiting for the server to be ready

Snakebyte1337

Hallo NG-Community.

Ich habe ein kleines Problem, und zwar wenn ich meinen Server starte funktioniert alles reibungslos
doch nun wenn ich den server beitrette kommt jedenmal "waiting for the server to be ready" und dies geht nicht weiter
es soll ja an der Datenbank liegen aber dort habe ich alles eingestellt mit der [lexicon]ExtDB[/lexicon].

rpt logs;

Code

StartProgress >
 1:17:37   Error position: <life_fnc_autoMessages; 







StartProgress >
 1:17:37   Error Undefined variable in expression: life_fnc_automessages
 1:17:37 File mpmissions\Altis_life.Altis\init.sqf, line 8
 1:17:37 Error: Object(2 : 107) not found
 1:17:37 Error: Object(2 : 109) not found
 1:17:37 Error: Object(2 : 111) not found
 1:17:37 Error: Object(2 : 113) not found
 1:17:37 Error: Object(2 : 118) not found
 1:17:37 Error: Object(2 : 120) not found
 1:17:37 Error: Object(2 : 122) not found
 1:17:37 Error: Object(2 : 124) not found
 1:17:37 Error: Object(2 : 126) not found
 1:17:37 Error: Object(2 : 128) not found
 1:17:37 Error: Object(2 : 130) not found
 1:17:37 Error: Object(2 : 132) not found
 1:17:37 Error: Object(2 : 134) not found
 1:17:37 Error: Object(2 : 136) not found
 1:17:37 Error: Object(2 : 138) not found
 1:17:37 Error: Object(2 : 140) not found
 1:17:37 Error: Object(2 : 223) not found
 1:17:37 c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
 1:17:37  Mission id: a5bf1f9345da3f978354a87eca66af90c27e9a2c
 1:17:37 "extDB: Version: 63"
 1:17:37 "extDB: Connected to the Database"
 1:17:38 "extDB2: uisleep [4]: 88.766"
 1:17:41 "extDB2: uisleep [4]: 91.655"
 1:17:41 "extDB2: uisleep [4]: 91.687"
 1:17:41 "extDB2: uisleep [4]: 91.687"
 1:17:41 "extDB2: uisleep [4]: 91.783"
 1:17:41 Error in expression <if(!_multiarr) then {
_return = _return select 0;
};




_return;
>
 1:17:41   Error position: <select 0;
};




_return;
>
 1:17:41   Error Generic error in expression
 1:17:41 File life_server\Functions\MySQL\fn_asyncCall.sqf, line 58
 1:18:40 Server: Object 2:2200 not found (message Type_92)
 1:18:54 Server: Object 2:2200 not found (message Type_120)
 1:19:00 Server: Object 2:2200 not found (message Type_92)
 1:19:20 Server: Object 2:2200 not found (message Type_92)
 1:19:31 Server: Object 2:2200 not found (message Type_120)
 1:19:40 Server: Object 2:2200 not found (message Type_92)
 1:20:00 Server: Object 2:2200 not found (message Type_92)
 1:20:07 Server: Object 2:2200 not found (message Type_120)
 1:20:20 Server: Object 2:2200 not found (message Type_92)
 1:20:40 Server: Object 2:2200 not found (message Type_92)
 1:20:44 Server: Object 2:2200 not found (message Type_120)
 1:21:00 Server: Object 2:2200 not found (message Type_92)
 1:21:21 Server: Object 2:2200 not found (message Type_92)
 1:21:21 Server: Object 2:2200 not found (message Type_120)
 1:21:41 Server: Object 2:2200 not found (message Type_92)
 1:21:58 Server: Object 2:2200 not found (message Type_120)
 1:22:01 Server: Object 2:2200 not found (message Type_92)
 1:22:21 Server: Object 2:2200 not found (message Type_92)
 1:22:34 Server: Object 2:2200 not found (message Type_120)
 1:22:41 Server: Object 2:2200 not found (message Type_92)
 1:23:01 Server: Object 2:2200 not found (message Type_92)
 1:23:11 Server: Object 2:2200 not found (message Type_120)
 1:23:21 Server: Object 2:2200 not found (message Type_92)
 1:23:41 Server: Object 2:2200 not found (message Type_92)
 1:23:48 Server: Object 2:2200 not found (message Type_120)
 1:24:01 Server: Object 2:2200 not found (message Type_92)
 1:24:21 Server: Object 2:2200 not found (message Type_92)
 1:24:24 Server: Object 2:2200 not found (message Type_120)
 1:24:41 Server: Object 2:2200 not found (message Type_92)
 1:25:01 Server: Object 2:2200 not found (message Type_120)
 1:25:01 Server: Object 2:2200 not found (message Type_92)

Alles anzeigen

nox

Code

1:17:37 Error Undefined variable in expression: life_fnc_automessages
 1:17:37 File mpmissions\Altis_life.Altis\init.sqf, line 8

Dort mal geschaut? Was sagen die [lexicon]extDB[/lexicon] Logs?

br1zey

würde denke ich auf

Code

1:17:41 Error in expression <if(!_multiarr) then {
_return = _return select 0;
};
_return;
>
 1:17:41 Error position: <select 0;
};
_return;
>
 1:17:41 Error Generic error in expression
 1:17:41 File life_server\Functions\MySQL\fn_asyncCall.sqf, line 58

Alles anzeigen

tippen an der [lexicon]extDb[/lexicon] und Datenbak liegt es nicht

Code

1:17:37 "extDB: Version: 63"
 1:17:37 "extDB: Connected to the Database"

Snakebyte1337

Erstmal danke für eure schnelle Antworten !! - Finde ich super wie ihr euch um die User und deren Probleme kümmert

fn_asyncCall:

Code

/*
	File: fn_asyncCall.sqf
	Author: Bryan "Tonic" Boardwine
	Description:
	Commits an asynchronous call to ExtDB
	Parameters:
		0: STRING (Query to be ran).
		1: INTEGER (1 = ASYNC + not return for update/insert, 2 = ASYNC + return for query's).
		3: BOOL (True to return a single array, false to return multiple entries mainly for garage).
*/




private["_queryStmt","_queryResult","_key","_mode","_return","_loop"];




_tickTime = diag_tickTime;




_queryStmt = [_this,0,"",[""]] call BIS_fnc_param;
_mode = [_this,1,1,[0]] call BIS_fnc_param;
_multiarr = [_this,2,false,[false]] call BIS_fnc_param;




_key = "extDB2" callExtension format["%1:%2:%3",_mode,(call life_sql_id),_queryStmt];




if(_mode == 1) exitWith {true};




_key = call compile format["%1",_key];
_key = _key select 1;




_queryResult = "";
_loop = true;




while{_loop} do
{
    _queryResult = "extDB2" callExtension format["4:%1", _key];
    if (_queryResult == "[5]") then {
		// extDB returned that result is Multi-Part Message
		_queryResult = "";
		while{true} do {
			_pipe = "extDB2" callExtension format["5:%1", _key];
			if(_pipe == "") exitWith {_loop = false};
        	_queryResult = _queryResult + _pipe;
        };
    } else {
		if (_queryResult == "[3]") then {
			diag_log format ["extDB2: uisleep [4]: %1", diag_tickTime];
			uisleep 0.1;
		} else {
			_loop = false;
		};
	};
};




_queryResult = call compile _queryResult;




if(count (_queryResult select 1) == 0) exitWith {[]};




_return = (_queryResult select 1);




if(!_multiarr) then {
        _return = _return select 0;
};




_return;

Alles anzeigen

[lexicon]ExtDB[/lexicon] - Verbindung:

Code

[AltisLife]
;; Example of MySQL
;; 	AtlisLifeRPG uses Database2 by default
Type = MySQL
Name = Meine Datenbank




Username = root
Password = Mein Passwort
IP = 127.0.0.1
Port = 3306




minSessions = 1
;maxSessions = 4
idleTime = 60




compress = false
; Should only use this if MySQL server is external. Also only for MySQL




Secure Auth = true
; Recommend you turn this on

Alles anzeigen

Snakebyte1337

Hat jemand noch eine Idee ?

B4v4r!4n_Str!k3r

Zitat von nox

Was sagen die [lexicon]extDB[/lexicon] Logs?

Snakebyte1337

Code

extDB2: Version: 63
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15







extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads (config settings)







[01:17:37:954 +02:00] [Thread 7340] extDB2: Database Type: MySQL
[01:17:37:954 +02:00] [Thread 7340] extDB2: Database Session Pool Started
[01:17:37:961 +02:00] [Thread 7340] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\A3Master\@extDB2\extDB\sql_custom_v2\altis-life-rpg-4.ini
[01:17:37:961 +02:00] [Thread 7340] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[01:17:38:073 +02:00] [Thread 5336] extDB2: SQL_CUSTOM_V2: 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;
[01:17:38:073 +02:00] [Thread 5336] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:17:38:073 +02:00] [Thread 5336] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: resetLifeVehicles
[01:17:41:232 +02:00] [Thread 5992] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Table 'arma3life.dynmarket' doesn't exist	[mysql_stmt_errno]: 1146	[mysql_stmt_sqlstate]: 42S02	[statemnt]: SELECT prices FROM dynmarket WHERE id=1;
[01:17:41:232 +02:00] [Thread 5992] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:17:41:232 +02:00] [Thread 5992] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 9817 Input String: DYNMARKET_Price_Get
[02:38:19:836 +02:00] [Thread 7340] extDB2: Stopping ...

Alles anzeigen

SBuserhy

Zitat von Snakebyte1337

[01:17:38:073 +02:00] [Thread 5336] extDB2: SQL_CUSTOM_V2: 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;

Der Datenbank-User "arma3" benötigt die Rechte zum ausführen der "resetLifeVehicles" Prozedur/Abfrage >> Benutzerrechte MySQL

Zitat von Snakebyte1337

01:17:41:232 +02:00] [Thread 5992] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Table 'arma3life.dynmarket' doesn't exist [mysql_stmt_errno]: 1146 [mysql_stmt_sqlstate]: 42S02 [statemnt]: SELECT prices FROM dynmarket WHERE id=1;

Die Tabelle "Dynmarket" ist in der Datenbank nicht vorhanden

waiting for the server to be ready

nox 25. März 2023 um 00:47

Ähnliche Themen

Eigenen Ladebildschirm

Server meldet Waiting for Server to be Ready

Hilfe | Waiting for the Server to be ready

Altis Life 4.4 R3 | Waiting for the Server to be Ready...

Waiting for the server to be ready...

Probleme beim Server

Benutzer online in diesem Thema