Mysql fehler

Viget Drakedog · 30. Januar 2015

Guten Abend.

Ich habe ein Problem und zwar

Mein Plugin für MYSQL will nicht laden so wie es aussieht.

Code

Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3z-R3, (C)2005-2014 SA-MP Team


[21:48:47] filterscripts = ""  (string)
[21:48:47] 
[21:48:47] Server Plugins
[21:48:47] --------------
[21:48:47]  Loading plugin: mysql
[21:48:47]  >> plugin.mysql: R33 successfully loaded.
[21:48:47]   Loaded.
[21:48:47]  Loaded 1 plugins.


[21:48:47] 
[21:48:47] Filterscripts
[21:48:47] ---------------
[21:48:47]   Loaded 0 filterscripts.


[21:48:47] 
----------------------------------
[21:48:47]  Das Script wurde geladen!
[21:48:47] ----------------------------------


[21:48:47] Number of vehicle models: 0
[21:48:52] --- Server Shutting Down.
[21:48:52] plugin.mysql: Unloading plugin...
[21:48:52] plugin.mysql: Plugin unloaded.

Alles anzeigen

scrabber. · 30. Januar 2015

Zeig mal wie du die Plugins in die Server.cfg einträgst, außerdem zeig mal wie du die Verbindung aufbauen lässt.
Welches Skript verwendest du, vielleicht besteht keine MySQL Verbindung und der Server wird mit dem Befehl exit gestoppt.

Akino Kiritani · 30. Januar 2015

Dein Plugin lädt.
Es ist nur so, das sich dein Server beendet.

Schau mal in deinem Script nach "SendRconCommand("exit");"

Viget Drakedog · 30. Januar 2015

C

//includes
#include <a_samp>
#include <a_mysql>


//mysql




//farben
#define rot 0xFF0000FF
#define grün 0x00FF00FF
#define gelb 0xDEFF00FF
#define blau 0x0000FFFF
#define schwarz 0x000000FF
#define lila 0xFF00D7FF
#define babyblau 0x009BFFFF
#define weiß 0xFFFFFFFF
#define orange 0xFFAA00FF
#define pink 0xFF004BFF






//SQL----
#define sql_host "127.0.0.1"
#define sql_user "script"
#define sql_data "samp"
#define sql_pass "123"








main()
{
	print("\n----------------------------------");
	print(" Das Script wurde geladen!");
	print("----------------------------------\n");
}






public OnGameModeInit()
{
	mysql_connect(sql_host,sql_user,sql_data,sql_pass);
	SetGameModeText("pawnolernen");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}


public OnGameModeExit()
{
	mysql_close();
	return 1;
}


public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}


public OnPlayerConnect(playerid)
{
	new string[128];
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	format(string,sizeof(string),"Willkommen auf Exilium-Reallife,%s.",name);
	SendClientMessage(playerid,rot,string);
	return 1;
}


public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}


public OnPlayerSpawn(playerid)
{
	return 1;
}


public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}


public OnVehicleSpawn(vehicleid)
{
	return 1;
}


public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}


public OnPlayerText(playerid, text[])
{
	return 1;
}


public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}


public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}


public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}


public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}


public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}


public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}


public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}


public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}


public OnRconCommand(cmd[])
{
	return 1;
}


public OnPlayerRequestSpawn(playerid)
{
	return 1;
}


public OnObjectMoved(objectid)
{
	return 1;
}


public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}


public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}


public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}


public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}


public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}


public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}


public OnPlayerExitedMenu(playerid)
{
	return 1;
}


public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}


public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}


public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}


public OnPlayerUpdate(playerid)
{
	return 1;
}


public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}


public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}


public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}


public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	return 1;
}


public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

Alles anzeigen

Bilder:

huGGy · 30. Januar 2015

Deine Benutzerdaten für deinen MySQL Server existieren nicht.

Viget Drakedog · 30. Januar 2015

Wenn der account ja nicht angelegt wäre dann frage ich mich wieso er dann.

ich verzweifel momentan dran. Ich habe xampp und es geht nichts. na toll.

scrabber. · 30. Januar 2015

Wie lustig das klingt, Beweise..als würdest du einen nachweis für eine Anklage liefern.
Nimm mal den stinknormalen Root Benutzer ohne Kennwort, host: 127.0.0.1

Viget Drakedog · 30. Januar 2015

Code

----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team


[22:39:34] filterscripts = ""  (string)
[22:39:34] 
[22:39:34] Server Plugins
[22:39:34] --------------
[22:39:34]  Loading plugin: mysql
[22:39:34]  >> plugin.mysql: R38 successfully loaded.
[22:39:34]   Loaded.
[22:39:34]  Loaded 1 plugins.


[22:39:34] 
[22:39:34] Filterscripts
[22:39:34] ---------------
[22:39:34]   Loaded 0 filterscripts.


[22:39:34] 
----------------------------------
[22:39:34]  Das Script wurde geladen!
[22:39:34] ----------------------------------


[22:39:34] Number of vehicle models: 0
[22:39:54] --- Server Shutting Down.
[22:39:54] plugin.mysql: Unloading plugin...
[22:39:54] plugin.mysql: Plugin unloaded.

Alles anzeigen

Immer noch und ich habe das akutelle plugin

scrabber. · 30. Januar 2015

Also vorher stand in der Log r33 und jetzt steht dort r38.
Lad mal als Anhang deine Include hoch. (a_mysql.inc)

Viget Drakedog · 30. Januar 2015

ich habe alles versucht was ich kenne um es hin zu bekommen.

scrabber. · 30. Januar 2015

Füg das mal oben ins Skript so ein!

//SQL----
#define sql_host "127.0.0.1"
#define sql_user "root"
#define sql_data "samp"
#define sql_pass ""

Außerdem füg mal bitte das bei mysql_connect ein und gib uns bescheid was ausgegeben wird.
mysqlcon = mysql_connect(...);
printf("errno: %i",mysql_errno(mysqlcon));

Viget Drakedog · 30. Januar 2015

Es ist nicht besser geworden:

Code

C:\Users\Drakedog\Desktop\test.pwn(42) : error 029: invalid expression, assumed zero
C:\Users\Drakedog\Desktop\test.pwn(43) : warning 217: loose indentation
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase




1 Error.

scrabber. · 30. Januar 2015

Zeig mal die jeweiligen Zeilen!

Viget Drakedog · 30. Januar 2015

C

//includes
#include <a_samp>
#include <a_mysql>


//mysql




//farben
#define rot 0xFF0000FF
#define grün 0x00FF00FF
#define gelb 0xDEFF00FF
#define blau 0x0000FFFF
#define schwarz 0x000000FF
#define lila 0xFF00D7FF
#define babyblau 0x009BFFFF
#define weiß 0xFFFFFFFF
#define orange 0xFFAA00FF
#define pink 0xFF004BFF
#define mysqlcon




//SQL----
#define sql_host "127.0.0.1"
#define sql_user "root"
#define sql_data "samp"
#define sql_pass ""








main()
{
	print("\n----------------------------------");
	print(" Das Script wurde geladen!");
	print("----------------------------------\n");
}






public OnGameModeInit()
{
	mysqlcon = mysql_connect(...);
	printf("errno: %i",mysql_errno(mysqlcon));
	SetGameModeText("pawnolernen");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}


public OnGameModeExit()
{
	mysql_close();
	return 1;
}


public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}


public OnPlayerConnect(playerid)
{
	new string[128];
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	format(string,sizeof(string),"Willkommen auf Exilium-Reallife,%s.",name);
	SendClientMessage(playerid,rot,string);
	return 1;
}


public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}


public OnPlayerSpawn(playerid)
{
	return 1;
}


public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}


public OnVehicleSpawn(vehicleid)
{
	return 1;
}


public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}


public OnPlayerText(playerid, text[])
{
	return 1;
}


public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}


public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}


public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}


public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}


public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}


public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}


public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}


public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}


public OnRconCommand(cmd[])
{
	return 1;
}


public OnPlayerRequestSpawn(playerid)
{
	return 1;
}


public OnObjectMoved(objectid)
{
	return 1;
}


public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}


public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}


public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}


public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}


public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}


public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}


public OnPlayerExitedMenu(playerid)
{
	return 1;
}


public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}


public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}


public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}


public OnPlayerUpdate(playerid)
{
	return 1;
}


public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}


public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}


public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}


public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	return 1;
}


public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

Alles anzeigen

scrabber. · 30. Januar 2015

Och, bitte nicht verzweifeln.
Ich meine nicht den ganzen Quellcode nur die Zeilen vom Error.

Jeffry · 30. Januar 2015

Drei Punkte als Parameter sind falsch. Das muss schon so sein:
mysql_connect(sql_host,sql_user,sql_data,sql_pass);

Viget Drakedog · 30. Januar 2015

in den mysql logs kommt leider auch nichts mehr neues

Jeffry · 30. Januar 2015

Schalte mal den MySQL Debug Modus an und poste was im MySQL Log steht wenn du den Server startest.
Wie du das machst siehst du hier: Tipps: Scripting-Probleme richtig erklären (Kapitel 1.4)

Viget Drakedog · 30. Januar 2015

Code

[23:57:02] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "samp_db", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:57:02] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:57:02] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:57:02] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:57:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:05] [DEBUG] mysql_close - connection: 1
[23:57:05] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[23:57:05] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[23:57:05] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[23:57:05] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
[23:57:15] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "samp_db", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:57:15] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:57:15] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:57:15] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:57:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:57:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:57:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:57:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
'

Alles anzeigen

Beitrag von Viget Drakedog (30. Januar 2015)