[sleejay]

Код:

[04:26:10] 
[04:26:10] Filterscripts
[04:26:10] ---------------
[04:26:10]   Loading filterscript 'gate.amx'...
[04:26:10]   Unable to load filterscript 'gate.amx'.
[04:26:10]   Loaded 0 filterscripts.

[04:26:10]    Error: Function not registered: 'samp_mysql_connect'
[04:26:10]    Error: Function not registered: 'samp_mysql_select_db'
[04:26:10]    Error: Function not registered: 'samp_mysql_ping'
[04:26:10]    Error: Function not registered: 'samp_mysql_close'
[04:26:10]    Error: Function not registered: 'samp_mysql_query'
[04:26:10]    Error: Function not registered: 'samp_mysql_store_result'
[04:26:10]    Error: Function not registered: 'samp_mysql_fetch_row'
[04:26:10]    Error: Function not registered: 'samp_mysql_free_result'
[04:26:10]    Error: Function not registered: 'samp_mysql_real_escape_string'
[04:26:10]    Error: Function not registered: 'samp_mysql_num_rows'
[04:26:10] Script[gamemodes/berzerk.amx]: Run time error 19: "File or function is not found"
[04:26:10] Number of vehicle models: 0

I'm using the Evolution Roleplay script, found here:

https://sampforum.blast.hk/showthread.php?tid=336776

I understand that I might have to update my MySQL files or something, and if that's the case - can someone send the files I need to change in the script? I'm having a lot of trouble here, been trying to get this to work for two whole days now. Please help me if you know what the problem is.

[sleejay]

Anyone? I'm running a Linux server, via Color Host.

[sleejay]

This is all I need to get my server up and running - doesn't anyone know how to fix this? I've tried everything, literally. I got Skype, and Teamviewer - if you need that to help me!

[InfiniTy.]

Do you got the right version of MySQL ? Because there are 2-3 ( i think ) different plugins..
https://sampforum.blast.hk/showthread.php?tid=7106
Try that plugin

[sleejay]

Okay, I am using my web host to have the database uploaded. I've put everything on there, including the MySQL user and pass, plus database name via Pawno.

Now, I get this error:

[20:04:28] MYSQL: Attempting to connect to server...
[20:04:28]
Connection to MySQL database: Failed !
[20:04:28] Access denied for user 'dj'@'184.171.165.221' (using password: YES)
[20:04:28] Error in mysql_select_db: MySQL server has gone away
[20:04:28] MYSQL: Connection error, retrying...
[20:04:28]
Connection to MySQL database: Failed !
[20:04:28] Access denied for user 'dj'@'184.171.165.221' (using password: YES)
[20:04:28] Error in mysql_select_db: MySQL server has gone away
[20:04:28] MYSQL: Could not reconnect to server, terminating server...
[20:04:28] Error in mysql_query: MySQL server has gone away
[20:04:28] Error in mysql_store_result: MySQL server has gone away[/code]

And yes Adytza, that plugin did move me up a step from my last problem. Thanks!

[InfiniTy.]

Well seems like the password isn't correct..
(Did you allow your server ip to access the DB ? in your webhost cpanel ? )

[sleejay]

Hmm, no I didn't. Could you tell me how I go about doing that?

[InfiniTy.]

Do you have skype ? if yes then leave your username here

[sleejay]

david.stricka

[sleejay]

Adytza helped me get past all that, but now I am faced with this problem:

Код:

SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[21:23:20] password = ""  (string)
[21:23:20] maxnpc = 0  (int)
[21:23:20] 
[21:23:20] Server Plugins
[21:23:20] --------------
[21:23:20]  Loading plugin: streamer.so
[21:23:20] 

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

[21:23:20]   Loaded.
[21:23:20]  Loading plugin: sampmysql.so
[21:23:20] 
/*************************************************/
/* SAMP-MySQL v0.15 Plugin loaded successfully ! */
/*************************************************/

[21:23:20]   Loaded.
[21:23:20]  Loading plugin: nativechecker.so
[21:23:20]   Loaded.
[21:23:20]  Loading plugin: mysql.so
[21:23:20]   Failed (plugins/mysql.so: invalid ELF header)
[21:23:20]  Loaded 3 plugins.

[21:23:20] 
[21:23:20] Filterscripts
[21:23:20] ---------------
[21:23:20]   Loading filterscript 'gate.amx'...
[21:23:20]   Unable to load filterscript 'gate.amx'.
[21:23:20]   Loaded 0 filterscripts.

[21:23:20] MYSQL: Attempting to connect to server...
[21:23:20] 
Connection to MySQL database: Successfull !
[21:23:20] Error in mysql_select_db: Access denied for user 'berzerkr_dj'@'184.171.165.221' to database 'berzerkr_berzerkroleplay'
[21:23:20] MYSQL: Database connection established.
[21:23:20] Error in mysql_query: No database selected
[21:23:20] Error in mysql_store_result: No database selected

You can see that the database has been created, I've created a username on my web host to and allowed my server IP to get access to the MySQL. Now it says no database selected? On my gamemode's Pawno, I've set it up like this:

#define MYSQL_HOST "184.171.165.222"
#define MYSQL_USER "berzerkr_dj"
#define MYSQL_PASS "HIDDEN"
#define MYSQL_DB "berzerkr_berzerkroleplay"

That's exactly how it is supposed to be set up, as well. Now, what am I doing wrong?