[rt-2]

Hi,
I wasn't available for a moment recently and I just came back...
So I started updating my server from 0.3d to 0.3e.
I downloaded the new MySQL R7 and Streamer v2.6.1
I also tried to update my code to the new Mysql way of doing...

The problem is that when I start my server it crashes after only 5 seconds..
I'm just wondering if there's a way to use MySQL R7 and the streamer plugin in the same time.
I've read that the problem with MySQL and the streamer is about cache, but I don't even think we're talking about the same problem because I've read that it happens after 2-8h and I don't even need to connect any players to the server to make it crash within 5 seconds.


I have tried to remove one or the other from my server.cfg but my script does an runtime error anyway and I haven't really tested it but the server stay up in that way because I would have to rewrite my entire code for the test...

Here is my server.cfg

Quote:

echo Executing Server Config... lanmode 0 rcon_password XXXX maxplayers 100 port 7777 hostname SA Advanced Roleplay [ENG] gamemode0 SAarp 1 filterscripts announce 0 query 1 weburl www.rt-2.net onfoot_rate 40 incar_rate 40 weapon_rate 40 stream_distance 300.0 stream_rate 1000 maxnpc 10 logtimeformat [%c] plugins mysql streamer

And here is my server_log

Quote:

---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e-R2, ©2005-2012 SA-MP Team [18:25:44] filterscripts = "" (string) [09/25/12 18:25:44] [09/25/12 18:25:44] Server Plugins [09/25/12 18:25:44] -------------- [09/25/12 18:25:44] Loading plugin: mysql [09/25/12 18:25:44] > MySQL plugin R7 successfully loaded. [09/25/12 18:25:44] Loaded. [09/25/12 18:25:44] Loading plugin: streamer [09/25/12 18:25:44] *** Streamer Plugin v2.6.1 by Incognito loaded *** [09/25/12 18:25:44] Loaded. [09/25/12 18:25:44] Loaded 2 plugins. [09/25/12 18:25:44] [09/25/12 18:25:44] Filterscripts [09/25/12 18:25:44] --------------- [09/25/12 18:25:44] Loaded 0 filterscripts. [09/25/12 18:25:45] -Initializing principal game mode. [09/25/12 18:25:45] -Setting Variables. [09/25/12 18:25:45] -Connecting to MYSQL database. [09/25/12 18:25:45] -Connection to `saarp` succesful! [09/25/12 18:25:45] -Spawning map icons... [09/25/12 18:25:45] -Objects initializations... [09/25/12 18:25:45] -Acquiring object types [09/25/12 18:25:45] -Acquiring weapon types [09/25/12 18:25:45] -Spawning ground objects models [09/25/12 18:25:45] -Planes initializations... [09/25/12 18:25:45] -Acquiring plane ids [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Factions initializations... [09/25/12 18:25:45] -Loading City Planning faction. [09/25/12 18:25:45] -Spawning pickups and labels. [09/25/12 18:25:45] -Loading Police Forces faction [09/25/12 18:25:45] -Loading objects [09/25/12 18:25:45] -Loading pickups [09/25/12 18:25:45] -Taxi faction initializing [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Loading LS Military Police faction. [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Mush faction initializing [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -SASD faction initializing [09/25/12 18:25:45] -Setting routes [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -SAVA faction initializing (SADA/SAAA/SABA) [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Xoomer faction initializing [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Principal game mode initializing completed. [09/25/12 18:25:45] Game mode ready! [09/25/12 18:25:45] Number of vehicle models: 0

And here is my mysql_log

Quote:

[18:25:45] >> mysql_connect(127.0.0.1, saarp, saarp, ******) on port 3306 [18:25:45] CMySQLHandler::CMySQLHandler() - constructor called. [18:25:45] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "saarp" | Username: "saarp" [18:25:45] CMySQLHandler::Connect() - Connection was successful. [18:25:45] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [18:25:45] >> mysql_ping( Connection handle: 1 ) [18:25:45] CMySQLHandler::Ping() - Connection is still alive. [18:25:45] [18:25:45] ** MySQL Debugging enabled (09/25/12) [18:25:45] [18:25:45] >> mysql_query_callback( Connection handle: 1 ) [18:25:45] >> mysql_query_callback( Connection handle: 1 ) [18:25:45] Passing query SELECT * FROM objects_types | [18:25:45] ProcessQueryThread(ReceiveObjectTypes) - Query was successful. (SELECT * FROM objects_types) [18:25:45] ProcessQueryThread(ReceiveObjectTypes) - Data caching enabled. [18:25:45] CMySQLHandler::StoreResult() - Result was stored. [18:25:45] CMySQLHandler::FreeResult() - Result was successfully free'd. [18:25:45] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [18:25:45] Passing query SELECT * FROM objects_list WHERE p_type = 'ground' | [18:25:45] ProcessQueryThread(SpawnGroundObjects) - Query was successful. (SELECT * FROM objects_list WHERE p_type = 'ground') [18:25:45] ProcessQueryThread(SpawnGroundObjects) - Data caching enabled. [18:25:45] CMySQLHandler::StoreResult() - Result was stored. [18:25:45] CMySQLHandler::FreeResult() - Result was successfully free'd. [18:25:45] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [18:25:45] SpawnGroundObjects() - Threaded function called. [18:25:45] >> cache_get_data( Connection handle: 1 )

Thank you very much in advance for your help,
Yanick Coulombe

[rt-2]

Bump, I'm sure there's a way to use both in the same time, a lot of servers that need Mysql and Streamer are updated already, I'm sure it has been found by now....

[rt-2]

Bump

[Red_Dragon.]

Buddy, do not spam and bump your thread many times on a short time also average time for thread bumping is 48 hours and thanks

[MrPlatinum]

He bumped his thread once in 24 hours then again in 48 :P

[rt-2]

Thanks for bumping guys, but what more information do you think I should add?

[XtremeR]

get ur old version script, download a 0.3e 's fresh server, and from the 0.3e, take these files and replace the old version:

Quote:

samp-server.exe samp-npc.exe announce.exe samp-license.txt

and ur done now! no need to change all the files if ur having problem with it..

[M3mPHi$_S3]

recompile too !!!

[XtremeR]

no need to recompile if using my trick..

[M3mPHi$_S3]

Quote:

Originally Posted by XtremeR no need to recompile if using my trick..

Of course by changing this all files the server will be update but if you dont compile your game mode or your script with latest version of that includes then it's useless .