[Lorenzosdm]

Hello,

I bought yesterday a VPS with Centos 6 x64 at the beginning i had many problems with installing Mysql,PhP,Apache etc, Cuz i'm new in linux and i was so stupid by thinking "ow i can do this easily with some tutorials" but no... Now i have finally succeeded my script connecting to my mysql database after some problems with the mysql plugins and libmysqlclient_r.so.16 . But now the main problem, when i connect to the server i can create an player account, but when i log out and join again with the same player account then the server crashes after i entered my player password. I did tested the server also on my windows and everything worked fine.

But where is the problem? in the plugin, database, script, vps?

This is what happening when the server crashes:

pawn Код:

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

[15:34:00] 
[15:34:00] Server Plugins
[15:34:00] --------------
[15:34:00]  Loading plugin: crashdetect.so
[15:34:00]   CrashDetect v4.14 is OK.
[15:34:00]   Loaded.
[15:34:00]  Loading plugin: mysql.so
[15:34:00] 

  > MySQL plugin R7 successfully loaded.

[15:34:00]   Loaded.
[15:34:00]  Loading plugin: streamer.so
[15:34:00]   Loaded.
[15:34:00]  Loading plugin: Whirlpool.so
[15:34:00]  
[15:34:00]  ==================
[15:34:00]  
[15:34:00]   Whirlpool loaded
[15:34:00]  
[15:34:00]  ==================
[15:34:00]  
[15:34:00]   Loaded.
[15:34:00]  Loading plugin: sscanf.so
[15:34:00] 

[15:34:00]  ===============================

[15:34:00]       sscanf plugin loaded.     

[15:34:00]          Version:  2.8.1        

[15:34:00]    (c) 2012 Alex "******" Cole  

[15:34:00]  ===============================

[15:34:00]   Loaded.
[15:34:00]  Loading plugin: audio.so
[15:34:00] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[15:34:00]   Loaded.
[15:34:00]  Loading plugin: dns.so
[15:34:00] 

*** DNS Plugin v2.4 by Incognito loaded ***

[15:34:00]   Loaded.
[15:34:00]  Loading plugin: nativechecker.so
[15:34:00]   Loaded.
[15:34:00]  Loaded 8 plugins.

[15:34:00] 
[15:34:00] Filterscripts
[15:34:00] ---------------
[15:34:00]   Loading filterscript 'movefs.amx'...
[15:34:00]   Loading filterscript 'FC.amx'...
[15:34:00] 

 ----------------------------------------------------------
[15:34:00] |    Flying Camera Filterscript [V2.0] by Sandra loaded!   |
[15:34:00]  ----------------------------------------------------------


[15:34:00]   Loaded 2 filterscripts.

[15:34:00]  
[15:34:00]  
[15:34:00]  
[15:34:00]  ======================================= 
[15:34:00]  |                                     | 
[15:34:00]  |        YSI version 3.09.0684        | 
[15:34:00]  |        By Alex "******" Cole        | 
[15:34:00]  |                                     | 
[15:34:00]  ======================================= 
[15:34:00]  
[15:34:00]  
[15:34:00]  
[15:34:01] Number of vehicle models: 0
[15:34:01]  
[15:34:01]  ========================================== 
[15:34:01]  |                                        | 
[15:34:01]  |  A new version (v<html>
  ) of YSI is  | 
[15:34:01]  |            available from:             | 
[15:34:01]  |                                        | 
[15:34:01]  |     [url]www.y-less.com/YSI/YSI_1.0.zip[/url]     | 
[15:34:01]  |                                        | 
[15:34:01]  ========================================== 
[15:34:01]  
[15:34:30] Incoming connection: XX.XX.XX.XX
[15:34:31] [join] Test_Guy has joined the server (0:XX.XX.XX.XX)
[15:35:25] [nick] Test_Guy nick changed to Test_Guy
[15:36:19] [debug] Run time error 4: "Array index out of bounds"
[15:36:19] [debug]  Accessing element at index 3 past array upper bound 2
[15:36:19] [debug] AMX backtrace:
[debug] #0 00000598 in public OnPlayerDisconnect (0x00000000, 0x00000001) from FC.amx
[15:36:19] [part] Test_Guy has left the server (0:1)
[15:37:24] Incoming connection: XX.XX.XX.XX
[15:37:25] [join] Test_Guy has joined the server (0:XX.XX.XX.XX)
[15:37:30] [debug] Server crashed while executing BSRP.amx
[15:37:30] [debug] AMX backtrace:
[debug] #0 00000004 in public OnPlayerLoginAttempt (0x00000000) from BSRP.amx
[15:37:30] [debug] Native backtrace:
[debug] #0 b7bdf66b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[debug] #1 b7bd85bf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[debug] #2 b7bd98fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[debug] #3 b7bda3e6 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[debug] #4 b7bdf2bc in ?? () from plugins/crashdetect.so
[debug] #5 b7ee4a60 in ?? () from /lib/libpthread.so.0

Hopefully i gave you guys enough information.

Thanks in advance.

[Younes44]

i think your Script are Bugged..
Or check your MySQL DataBase xD

[Lorenzosdm]

if its bugged why it does work smoothly on localhost :/

[PMH]

i think u dont have proper file permissions. try setting scriptfiles' permissions to 777

[Lorenzosdm]

I dont use scriptfiles, only Mysql DB

[Lorenzosdm]

sorry for bump but any one else can helping me solving this?

[Ajvanho]

Is it a RCON login or normal login?
RCON login is maybe to the host or something wrong with the database.
If normal login then it's to you gamemode. (I had this problem for 34 hours until I figured it out when I was making my first gamemode few years back)

[Lorenzosdm]

Normal Login, I figured it is my gamemode. Its something with OnPlayerLoginAttempt:

pawn Код:

[debug] Server crashed while executing BSRP.amx
[15:37:30] [debug] AMX backtrace:
[debug] #0 00000004 in public OnPlayerLoginAttempt (0x00000000) from BSRP.amx

[EPIC2LA]

Or You might search for these, and change their values!

Код:

#define NEW_VULNERABLE 24
#define TIME_TO_CLAIM 1
#define TIME_TO_TAKEOVER 10
#define MAX_FAMILY 20
#define MAX_POINTS 9
#define MAX_DMAPICONS 400
#define MAX_DDOORS 800
#define MAX_HOUSES 200
#define MAX_BUSINESS 60
#define MAX_GATES 100
#define MAX_EVENTPOINTS 50
#define INVALID_HOUSE_ID -1

for e.g :

Код:

#define MAX_GATES 100 Change it to : #define MAX_GATES 50

// Then there will be no crash!

[Lorenzosdm]

Hmm not thought about that, I'm going to give it a try. thanks