Moin Brotfische,
Ratlosigkeit zieht durchs Land. Ich wollte meine Datenbank von Local zur externen wechseln. Sollte eigentlich gehen, aber der SAMP-Server (Was weiterhin local ist) stürzt ab wenn er eine Verbindung zur externen MySQL-Datenbank aufgebaut hat. Aber wenn ich die locale Datenbank verbinden lasse, funktioniert alles reibungslos. Die Inhalter beider Datenbanken sind gleich.
Server-Log
Code
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[15:25:02]
[15:25:02] Server Plugins
[15:25:02] --------------
[15:25:02] Loading plugin: crashdetect
[15:25:02] CrashDetect plugin 4.19.4
[15:25:02] Loaded.
[15:25:02] Loading plugin: sscanf
[15:25:02]
[15:25:02] ===============================
[15:25:02] sscanf plugin loaded.
[15:25:02] Version: 2.8.2
[15:25:02] (c) 2012 Alex "Y_Less" Cole
[15:25:02] ===============================
[15:25:02] Loaded.
[15:25:02] Loading plugin: mysql
[15:25:02] >> plugin.mysql: R41-3 successfully loaded.
[15:25:02] Loaded.
[15:25:02] Loading plugin: streamer
[15:25:02]
*** Streamer Plugin v2.9.4 by Incognito loaded ***
[15:25:02] Loaded.
[15:25:02] Loading plugin: timerfix
[15:25:02] Timer Fix plugin v1.1.0 by KashCherry loaded.
[15:25:02] Loaded.
[15:25:02] Loaded 5 plugins.
[15:25:02]
[15:25:02] Filterscripts
[15:25:02] ---------------
[15:25:02] Loading filterscript 'ntd.amx'...
[15:25:02]
[NTD PL]Edytor TextDrawow od Nickk888 v4.45 Beta zostal pomyslnie zinicjalizowany!
[15:25:02] [NTD ENG]The TextDraw editor from Nickk888 v4.45 Beta has been successfully initialized!
[15:25:02] Loading filterscript 'mapedit.amx'...
[15:25:03] Fusez's Map Editor wurde erolgreich geladen.
[15:25:03] Loaded 2 filterscripts.
[15:25:03]
[15:25:03]
[15:25:03]
[15:25:03] =======================================
[15:25:03] | |
[15:25:03] | YSI version 4.00.0001 |
[15:25:03] | By Alex "Y_Less" Cole |
[15:25:03] | |
[15:25:03] =======================================
[15:25:03]
[15:25:04] *** YSI Error: Invalid hook name: @yH_OnVehicleDamageStatusUpdate
[15:25:04] [MAP] Adminprison wurde geladen!
[15:25:04] [SERVER] Alle NTV-Objekt Variablen sind bereit.
[15:25:04] [MAP] NTV Interior geladen
[15:25:04] [SERVER] Blacklist der Spielernamen geladen (2)
[15:25:05] [MYSQL] Die Verbindung wurde erfolgreich hergestellt!
[15:25:05] [MAP] Der Neulingsspawn wurde geladen.
[15:25:05]
----------------------------------
[15:25:05] (c) Vortex Reallife by palwal
[15:25:05] ----------------------------------
[15:25:05] Number of vehicle models: 1
[15:25:05] error while processing timer: cannot execute public 'Malloc_SolidifyTimer'
[15:25:05] error while processing timer: cannot execute public 'Malloc_SolidifyTimer'
[15:25:13] [debug] Server crashed due to an unknown error
[15:25:13] [debug] Native backtrace:
[15:25:13] [debug] #0 004016eb in ?? () in samp-server.exe
[15:25:13] [debug] #1 58a96889 in ?? () in plugins\mysql.DLL
[15:25:13] [debug] #2 58a99198 in ?? () in plugins\mysql.DLL
[15:25:13] [debug] #3 58a7d26a in ?? () in plugins\mysql.DLL
[15:25:13] [debug] #4 58a7e3b4 in ?? () in plugins\mysql.DLL
[15:25:13] [debug] #5 58a7eaae in ?? () in plugins\mysql.DLL
[15:25:13] [debug] #6 00469a66 in ?? () in samp-server.exe
[15:25:13] [debug] #7 0048d4db in ?? () in samp-server.exe
[15:25:13] [debug] #8 0049b4a1 in ?? () in samp-server.exe
[15:25:13] [debug] #9 0049b4b1 in ?? () in samp-server.exe
[15:25:13] [debug] Registers:
[15:25:13] [debug] EAX: 0ffff840 EBX: 00897ab4 ECX: 10013020 EDX: 00000008
[15:25:13] [debug] ESI: 00000218 EDI: ffffd8c1 EBP: 0049b4a1 ESP: 0019fe98
[15:25:13] [debug] EIP: 0049b4b1 EFLAGS: 00010246
[15:25:13] [debug] Stack:
[15:25:13] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff
[15:25:13] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0
[15:25:13] [debug] ESP+00000040: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+00000060: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+00000080: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000
[15:25:13] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 758338f4
[15:25:13] [debug] ESP+00000100: 77555663 002d7000 eadf25a6 00000000
[15:25:13] [debug] ESP+00000120: 00000000 00000000 eadf25a6 0019ffa0
[15:25:13] [debug] ESP+00000140: 00000000 0019ffec 7755562e ffffffff
[15:25:13] [debug] ESP+00000160: 002d7000 00000000 78746341 00000020
[15:25:13] [debug] ESP+00000180: 00000020 00000000 00000014 00000001
[15:25:13] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+000001c0: 00000044 000002e0 00000254 00000000
[15:25:13] [debug] ESP+000001e0: 00000336 00000000 2d59495b 000008b8
[15:25:13] [debug] ESP+00000200: 32ceeacd 00000bdc 00000042 00000c20
[15:25:13] [debug] ESP+00000220: 0000005e 00000fa4 00000356 00000000
[15:25:13] [debug] ESP+00000240: 00000386 00000010 00000009 000000ec
[15:25:13] [debug] ESP+00000260: 00000001 00000002 00001714 000007a0
[15:25:13] [debug] ESP+00000280: 00000001 00000004 00002d40 00000314
[15:25:13] [debug] ESP+000002a0: 00000002 00000006 000030ec 000000cc
[15:25:13] [debug] ESP+000002c0: 00000001 00000009 000032a8 00000028
[15:25:13] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001
[15:25:13] [debug] ESP+00000300: 00000001 00001560 0000002c 0000005e
[15:25:13] [debug] ESP+00000320: 00000000 00000000 00000000 00000000
[15:25:13] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c
[15:25:13] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000
[15:25:13] [debug] ESP+00000380: 00000254 00000001 f33271ba 000003b8
[15:25:13] [debug] ESP+000003a0: 2d59495b 0000073c 00000032 00000770
[15:25:13] [debug] ESP+000003c0: 00000042 00000aa4 00000324 00000004
[15:25:13] [debug] ESP+000003e0: 00000356 00000005 b1280544 00001180
[15:25:13] [debug] Loaded modules:
[15:25:13] [debug] 00400000 - 00519000 samp-server.exe
[15:25:13] [debug] 774f0000 - 7766b000 ntdll.dll
[15:25:13] [debug] 75820000 - 75900000 KERNEL32.DLL
[15:25:13] [debug] 75930000 - 75aae000 KERNELBASE.dll
[15:25:13] [debug] 741e0000 - 755df000 SHELL32.dll
[15:25:13] [debug] 77430000 - 774ee000 msvcrt.dll
[15:25:13] [debug] 773f0000 - 77427000 cfgmgr32.dll
[15:25:13] [debug] 75ce0000 - 761d9000 windows.storage.dll
[15:25:13] [debug] 755e0000 - 7579d000 combase.dll
[15:25:13] [debug] 763e0000 - 7648d000 RPCRT4.dll
[15:25:13] [debug] 74140000 - 7415e000 SspiCli.dll
[15:25:13] [debug] 74130000 - 7413a000 CRYPTBASE.dll
[15:25:13] [debug] 761e0000 - 76238000 bcryptPrimitives.dll
[15:25:13] [debug] 75c90000 - 75cd4000 sechost.dll
[15:25:13] [debug] 757a0000 - 7581b000 advapi32.dll
[15:25:13] [debug] 76490000 - 764d5000 shlwapi.dll
[15:25:13] [debug] 772a0000 - 773ef000 GDI32.dll
[15:25:13] [debug] 75ab0000 - 75bf7000 USER32.dll
[15:25:13] [debug] 77290000 - 7729c000 kernel.appcore.dll
[15:25:13] [debug] 75c00000 - 75c8d000 shcore.dll
[15:25:13] [debug] 762b0000 - 762f4000 powrprof.dll
[15:25:13] [debug] 763d0000 - 763df000 profapi.dll
[15:25:13] [debug] 70930000 - 70938000 WSOCK32.dll
[15:25:13] [debug] 6f160000 - 6f184000 WINMM.dll
[15:25:13] [debug] 764e0000 - 7653f000 WS2_32.dll
[15:25:13] [debug] 007a0000 - 007c3000 WINMMBASE.dll
[15:25:13] [debug] 75900000 - 7592b000 IMM32.DLL
[15:25:13] [debug] 58c20000 - 58c71000 crashdetect.DLL
[15:25:13] [debug] 58bb0000 - 58c19000 MSVCP100.dll
[15:25:13] [debug] 58af0000 - 58baf000 MSVCR100.dll
[15:25:13] [debug] 10000000 - 1000f000 sscanf.DLL
[15:25:13] [debug] 58ad0000 - 58ae3000 VCRUNTIME140.dll
[15:25:13] [debug] 72d20000 - 72e01000 ucrtbase.dll
[15:25:13] [debug] 58a70000 - 58ac2000 mysql.DLL
[15:25:13] [debug] 58960000 - 5897c000 log-core.dll
[15:25:13] [debug] 58980000 - 58a61000 libmariadb.dll
[15:25:13] [debug] 588f0000 - 5895e000 MSVCP140.dll
[15:25:13] [debug] 588d0000 - 588e2000 napinsp.dll
[15:25:13] [debug] 588b0000 - 588c6000 pnrpnsp.dll
[15:25:13] [debug] 58890000 - 588a4000 NLAapi.dll
[15:25:13] [debug] 73eb0000 - 73eff000 mswsock.dll
[15:25:13] [debug] 73e20000 - 73ea4000 DNSAPI.dll
[15:25:13] [debug] 763a0000 - 763a7000 NSI.dll
[15:25:13] [debug] 58880000 - 5888b000 winrnr.dll
[15:25:13] [debug] 5cee0000 - 5cef1000 wshbth.dll
[15:25:13] [debug] 73e10000 - 73e18000 rasadhlp.dll
[15:25:13] [debug] 58810000 - 58877000 streamer.DLL
[15:25:13] [debug] 58800000 - 5880b000 timerfix.DLL
[15:25:13] [debug] 73de0000 - 73e0f000 IPHLPAPI.DLL
[15:25:13] [debug] 73d90000 - 73dd7000 fwpuclnt.dll
[15:25:13] [debug] 74050000 - 7406b000 bcrypt.dllMySQL-Log
Code
[15:25:04] [INFO] changed log level from 'warning, error' to 'debug, info, warning, error'
[15:25:04] [DEBUG] mysql_connect("185.101.93.129", "root", "*****", "vortex", 0)
[15:25:04] [DEBUG] CHandleManager::Create(this=0x8543e0, host='185.101.93.129', user='root', pass='****', db='vortex', options=0x8538b0)
[15:25:04] [INFO] Creating new connection handle...
[15:25:04] [DEBUG] CConnection::CConnection(this=0x8564d0, host='185.101.93.129', user='root', passw='****', db='vortex', options=0x8538b0)
[15:25:04] [DEBUG] CConnection::CConnection - new connection = 0x87d8e8
[15:25:04] [DEBUG] CConnection::CConnection(this=0x5352020, host='185.101.93.129', user='root', passw='****', db='vortex', options=0x8538b0)
[15:25:05] [DEBUG] CConnection::CConnection - new connection = 0x88add0
[15:25:05] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x5352020, connection=0x5352020)
[15:25:05] [DEBUG] CConnectionPool::CConnectionPool(size=2, this=0x856290)
[15:25:05] [DEBUG] CThreadedConnection::WorkerFunc(this=0x5352020, connection=0x5352020)
[15:25:05] [DEBUG] CConnection::CConnection(this=0x5d4a020, host='185.101.93.129', user='root', passw='****', db='vortex', options=0x8538b0)
[15:25:05] [DEBUG] CConnection::CConnection - new connection = 0x895400
[15:25:05] [DEBUG] CThreadedConnection::WorkerFunc(this=0x5d4a020, connection=0x5d4a020)
[15:25:05] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x5d4a020, connection=0x5d4a020)
[15:25:05] [DEBUG] CConnection::CConnection(this=0x6f40020, host='185.101.93.129', user='root', passw='****', db='vortex', options=0x8538b0)
[15:25:05] [DEBUG] CConnection::CConnection - new connection = 0x894ad8
[15:25:05] [DEBUG] CThreadedConnection::WorkerFunc(this=0x6f40020, connection=0x6f40020)
[15:25:05] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x6f40020, connection=0x6f40020)
[15:25:05] [INFO] Connection handle with id '1' successfully created.
[15:25:05] [DEBUG] CHandleManager::Create - new handle = 0x87b3e0
[15:25:05] [DEBUG] mysql_connect: return value: '1'
[15:25:05] [DEBUG] mysql_errno(1)
[15:25:05] [DEBUG] CHandle::GetErrorId(this=0x87b3e0)
[15:25:05] [DEBUG] CConnection::GetError(this=0x8564d0, connection=0x87d8e8)
[15:25:05] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: ''
[15:25:05] [DEBUG] mysql_errno: return value: '0'
[15:25:05] [DEBUG] mysql_format(1, 0x1CCDF8C8, 256, "SELECT * FROM server_settings WHERE id = 1")
[15:25:05] [DEBUG] mysql_format: return value: '42'
[15:25:05] [DEBUG] mysql_pquery(1, "SELECT * FROM server_settings WHERE id = 1", "OnServerLoad", "")
[15:25:05] [DEBUG] CCallback::Create(amx=0x2907578, name='OnServerLoad', format='', params=0x1ccdf8b4, param_offset=5)
[15:25:05] [DEBUG] CCallback::Create - callback index for 'OnServerLoad': 67
[15:25:05] [INFO] Callback 'OnServerLoad' set up for delayed execution.
[15:25:05] [DEBUG] created delayed callback with 0 parameter
[15:25:05] [DEBUG] CHandle::Execute(this=0x87b3e0, type=2, query=0x8a0dd8)
[15:25:05] [DEBUG] CConnectionPool::Queue(query=0x8a0dd8, this=0x856290)
[15:25:05] [DEBUG] CHandle::Execute - return value: true
[15:25:05] [DEBUG] mysql_pquery: return value: '1'
[15:25:05] [DEBUG] CConnection::Execute(query=0x8a0dd8, this=0x5d4a020, connection=0x895400)
[15:25:05] [DEBUG] CQuery::Execute(this=0x8a0dd8, connection=0x895400)
[15:25:05] [ERROR] error #1146 while executing query "SELECT * FROM server_settings WHERE id = 1": Table 'vortex.server_settings' doesn't exist
[15:25:05] [DEBUG] CConnection::GetError(this=0x5d4a020, connection=0x895400)
[15:25:05] [DEBUG] CCallback::Create(amx=0x2907578, name='OnQueryError', format='dsssd)
[15:25:05] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10047
[15:25:05] [DEBUG] processing specifier 'd'
[15:25:05] [DEBUG] retrieved and pushed value '1146'
[15:25:05] [DEBUG] processing specifier 's'
[15:25:05] [DEBUG] retrieved and pushed value 'Table 'vortex.server_settings' doesn't exist'
[15:25:05] [DEBUG] processing specifier 's'
[15:25:05] [DEBUG] retrieved and pushed value 'OnServerLoad'
[15:25:05] [DEBUG] processing specifier 's'
[15:25:05] [DEBUG] retrieved and pushed value 'SELECT * FROM server_settings WHERE id = 1'
[15:25:05] [DEBUG] processing specifier 'd'
[15:25:05] [DEBUG] retrieved and pushed value '1'
[15:25:05] [INFO] Callback 'OnQueryError' set up for delayed execution.
[15:25:05] [DEBUG] created delayed callback with 5 parameters
[15:25:05] [DEBUG] CCallback::Execute(amx=0x2907578, index=-10047, num_params=5)Wäre Klasse wenn jemand eine Idee hat oder wüsste woran das liegt und wie man das beheben kann.
Liebe Grüße,
palwal
