[Nightmares]

Help i get this error while trying to run ngrp game MYSQl, there is only 54 lines in the pawno, how do I know if it connected to mysql? Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[15:59:16]
[15:59:16] Server Plugins
[15:59:16] --------------
[15:59:16] Loading plugin: streamer.dll
[15:59:16]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[15:59:16] Loaded.
[15:59:16] Loading plugin: mysql.dll
[15:59:17] >> plugin.mysql: R33 successfully loaded.
[15:59:17] Loaded.
[15:59:17] Loading plugin: sscanf.dll
[15:59:17]

[15:59:17] ===============================

[15:59:17] sscanf plugin loaded.

[15:59:17] © 2009 Alex "******" Cole

[15:59:17] 0.3d-R2 500 Players "dnee"

[15:59:17] ===============================

[15:59:17] Loaded.
[15:59:17] Loading plugin: whirlpool.dll
[15:59:20]
[15:59:20] ==================
[15:59:20]
[15:59:20] Whirlpool loaded
[15:59:20]
[15:59:20] ==================
[15:59:20]
[15:59:20] Loaded.
[15:59:20] Loaded 4 plugins.

[15:59:20]
[15:59:20] Filterscripts
[15:59:20] ---------------
[15:59:20] Loading filterscript 'Server.amx'...
[15:59:20] Loading filterscript 'playerinteriors.amx'...
[15:59:20] Loading filterscript 'playerexteriors.amx'...
[15:59:20] Loading filterscript 'anims.amx'...
[15:59:20] Loading filterscript 'buttons.amx'...
[15:59:20] Loaded 5 filterscripts.

[15:59:24]
[15:59:24] =======================================
[15:59:24] | |
[15:59:24] | YSI version 3.01.0002 |
[15:59:24] | By Alex "******" Cole |
[15:59:24] | |
[15:59:24] =======================================
[15:59:24]
[15:59:26] Number of vehicle models: 0
[15:59:26]
[15:59:26] ==========================================
[15:59:26] | |
[15:59:26] | A new version (v3.09.0684) of YSI is |
[15:59:26] | available from: |
[15:59:26] | |
[15:59:26] | www.y-less.com/YSI/YSI_1.0.zip |
[15:59:26] | |
[15:59:26] | Changelog: |
[15:59:26] | |
[15:59:26] | 3.09.0684: |
[15:59:26] | |
[15:59:26] | Reverted to old download location. |
[15:59:26] | Improved (and fixed) version checks; |
[15:59:26] | added y_bitmap, y_areas, y_races, |
[15:59:26] | y_zonenames, better documentation; |
[15:59:26] | MANY other bug fixes - see the github |
[15:59:26] | repository for more details: |
[15:59:26] | |
[15:59:26] ==========================================
[15:59:26]
[16:00:02] --- Server Shutting Down.

[God'Z War]

Did you upload all scriptfiles ?

[Naoufal]

Be sure you uploaded all scriptfiles, and in the right map.

[Nightmares]

to mysql? i have all scriptfiles. but i dont understand how the GM will work wince the pwn is only 54 lines[its just the connection and closing to the mysql db] i dont even know if it is properly done. here is my pwno file. I MAKE ADMIN OR REP WHOEVER HELPS

Quote:

/* ---------------- SCRIPT REVISION ----------------- */ // Do not forget to change this everytime you commit - it's mandatory! #define SQL_HOST 127.0.0.1 #define SQL_USER vfwx10mx_ghost #define SQL_DATA vfwx10mx_samp #define SQL_PASS ******* #define SERVER_GM_TEXT "GRP v2.2.34" #include <a_samp> #include <a_mysql> #include <streamer> #include <yom_buttons> #include <ZCMD> #include <sscanf2> #include <foreach> #include <YSI\y_timers> #include <YSI\y_utils> #if defined SOCKET_ENABLED #include <socket> #endif #include "./includes/defines.pwn" #include "./includes/enums.pwn" #include "./includes/variables.pwn" #include "./includes/timers.pwn" #include "./includes/functions.pwn" #include "./includes/commands.pwn" #include "./includes/mysql.pwn" #include "./includes/OnPlayerLoad.pwn" #include "./includes/callbacks.pwn" #include "./includes/textdraws.pwn" #include "./includes/streamer.pwn" #include "./includes/OnDialogResponse.pwn" main() {} public OnGameModeInit() { mysql_connect("127.0.0.1", "vfwx10mx_ghost", "vfwx10mx_samp", "****"); return 1; } public OnGameModeExit() { mysql_close(); return 1; }

[Ironboy]

Check the mysql log whether the connection is enabled or not.

[Nightmares]

[QUOTE]15:59:25] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' 15:59:25] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[15:59:26] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[19:28:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'vfwx10mx_ghost'@'localhost' (using password: YES)
[19:28:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'vfwx10mx_ghost'@'localhost' (using password: YES)

[Ironboy]

Quote:

15:59:25] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' 15:59:25] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061) [15:59:26] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061) [19:28:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'vfwx10mx_ghost'@'localhost' (using password: YES) [19:28:12] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'vfwx10mx_ghost'@'localhost' (using password: YES)

You haven't provided the right connection details and the coding seemed to be wrong

pawn Код:

#define SQL_HOST "127.0.0.1"
#define SQL_USER "vfwx10mx_ghost"
#define SQL_DATA "vfwx10mx_samp"
#define SQL_PASS "password"

mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);

[Nightmares]

what is correct can u help i am bad scripter

[Ironboy]

Quote:

Originally Posted by Nightmares what is correct can u help i am bad scripter

Check the code above and give your connection details.

[RoC4life]

It may have Controlled by a RAT system or its permission is not fixed like 777 if ur using ultra-h.com fix permission