1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySql help me
Dorlevi1506
Big Clucker
***
Posts: 99
Threads: 27
Joined: Aug 2013
Reputation: 0
#1

13.12.2013, 16:47
Hello guys, I got MySql script and i cant start the server its automatic shutting down servers logs

Код:
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[19:52:02] filterscripts = ""  (string)
[19:52:02] 
[19:52:02] Server Plugins
[19:52:02] --------------
[19:52:02]  Loading plugin: libmysql.dll
[19:52:02]   Plugin does not conform to architecture.
[19:52:02]   Failed.
[19:52:02]  Loading plugin: mysql.dll
[19:52:02] 

  > MySQL plugin R7 successfully loaded.

[19:52:02]   Loaded.
[19:52:02]  Loading plugin: sscanf.dll
[19:52:02] 

[19:52:02]  ===============================

[19:52:02]       sscanf plugin loaded.     

[19:52:02]    © 2009 Alex "******" Cole

[19:52:02]    0.3d-R2 500 Players "dnee"

[19:52:02]  ===============================

[19:52:02]   Loaded.
[19:52:02]  Loading plugin: streamer.dll
[19:52:02] 

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

[19:52:02]   Loaded.
[19:52:02]  Loading plugin: Whirlpool.dll
[19:52:03]  
[19:52:03]  ==================
[19:52:03]  
[19:52:03]   Whirlpool loaded
[19:52:03]  
[19:52:03]  ==================
[19:52:03]  
[19:52:03]   Loaded.
[19:52:03]  Loading plugin: MySQL.dll
[19:52:03] 

  > MySQL plugin R7 successfully loaded.

[19:52:03]   Loaded.
[19:52:03]  Loaded 5 plugins.

[19:52:03] 
[19:52:03] Filterscripts
[19:52:03] ---------------
[19:52:03]   Loaded 0 filterscripts.

[19:52:03] OnGameo
[19:52:03]  
[19:52:03]  ======================================= 
[19:52:03]  |                                     | 
[19:52:03]  |        YSI version 1.03.0011        | 
[19:52:03]  |        By Alex "******" Cole        | 
[19:52:03]  |                                     | 
[19:52:03]  |  Checking the latest YSI version..  | 
[19:52:03]  |                                     | 
[19:52:03]  ======================================= 
[19:52:03]  
[19:52:24] [MySQL] (Main Pipelines) Connecting to 91.121.111.162...
[19:52:24] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 91.121.111.162 - DB: 9324_database - User: 9324_database
[19:52:24] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[19:52:24] [LoadHouses] Loading data from database...
[19:52:24] [LoadDynamicDoors] Loading data from database...
[19:52:24] [LoadDynamicMapIcons] Loading data from database...
[19:52:24] [LoadMailboxes] Loading data from database...
[19:52:24] [LoadTurfWars] 0 turfs loaded.
[19:52:24] [LoadPaintballArenas] 10 paintball arenas loaded.
[19:52:24] [LoadEventPoints] 0 event points loaded.
[19:52:24] [LoadGates] 400 gates loaded.
[19:52:24] [LoadElevatorStuff] 20 floors loaded.
[19:52:24] [LoadFamilies] 16 families loaded.
[19:52:24] [LoadPoints] 9 points loaded.
[19:52:24] [LoadCDealerships] 15 dealerships loaded.
[19:52:24] [MiscLoad] Misc Loaded
[19:52:24] [LoadCrates] Load Query Sent
[19:52:28]  
[19:52:28] -------------------------------------------
[19:52:28] Insanity Roleplay
[19:52:28]  
[19:52:28] Copyright © Insanity Roleplay, (2012-2013)
[19:52:28] All Rights Reserved
[19:52:28] -------------------------------------------
[19:52:28]  
[19:52:28] Number of vehicle models: 92
[19:52:28] --- Server Shutting Down.
[19:52:28] 

  > MySQL plugin unloaded.

[19:52:28] 

[19:52:28]  ===============================

[19:52:28]      sscanf plugin unloaded.    

[19:52:28]  ===============================

[19:52:28] 

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

[19:52:28]  
[19:52:28]  ====================
[19:52:28]  
[19:52:28]   Whirlpool unloaded
[19:52:28]  
[19:52:28]  ====================
[19:52:28]  
[19:52:28] 

  > MySQL plugin unloaded.
Find
Reply
ViruZz
Banned
Posts: 320
Threads: 16
Joined: Feb 2012
#2

13.12.2013, 16:58
Nah, we dont help NGRP copycats.
Find
Reply
Wizzy951
Huge Clucker
****
Posts: 285
Threads: 20
Joined: Jul 2013
Reputation: 0
#3

13.12.2013, 16:58
Could you show me your server.cfg please ? Are you trying to load libmysql.dll through it ?
Find
Reply
Dorlevi1506
Big Clucker
***
Posts: 99
Threads: 27
Joined: Aug 2013
Reputation: 0
#4

13.12.2013, 17:01
Quote:
Originally Posted by ViruZz
Посмотреть сообщение
Nah, we dont help NGRP copycats.
I found this script on the net.


Quote:
Originally Posted by Wizzy951
Посмотреть сообщение
Could you show me your server.cfg please ? Are you trying to load libmysql.dll through it ?
Yes im tried to load libmysql.dll
Код:
echo Executing Server Config...
lanmode 0
rcon_password 5
maxplayers 100
port 7777
hostname Professional Roleplay [Grand Opening | Refunding]
gamemode0 insanityrp3
filterscripts 
plugins libmysql.dll mysql.dll sscanf.dll streamer.dll Whirlpool.dll
announce 1
query 1
weburl
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
maxnpc 70
Find
Reply
Wizzy951
Huge Clucker
****
Posts: 285
Threads: 20
Joined: Jul 2013
Reputation: 0
#5

13.12.2013, 17:03
Quote:
Originally Posted by Dorlevi1506
Посмотреть сообщение
I found this script on the net.




Yes im tried to load libmysql.dll
Код:
echo Executing Server Config...
lanmode 0
rcon_password 5
maxplayers 100
port 7777
hostname Professional Roleplay [Grand Opening | Refunding]
gamemode0 insanityrp3
filterscripts 
plugins libmysql.dll mysql.dll sscanf.dll streamer.dll Whirlpool.dll
announce 1
query 1
weburl
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
maxnpc 70
It's not a plugin, it should be in the main folder, not in the plugins one and aso remove it from the server.cfg !
Find
Reply
Dorlevi1506
Big Clucker
***
Posts: 99
Threads: 27
Joined: Aug 2013
Reputation: 0
#6

13.12.2013, 17:07
Quote:
Originally Posted by Wizzy951
Посмотреть сообщение
It's not a plugin, it should be in the main folder, not in the plugins one and aso remove it from the server.cfg !
It's doesnt working..
The server still automatic shutting down

Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[20:11:49] filterscripts = ""  (string)
[20:11:49] 
[20:11:49] Server Plugins
[20:11:49] --------------
[20:11:49]  Loading plugin: libmysql.dll
[20:11:49]   Plugin does not conform to architecture.
[20:11:49]   Failed.
[20:11:49]  Loading plugin: mysql.dll
[20:11:49] 

  > MySQL plugin R7 successfully loaded.

[20:11:49]   Loaded.
[20:11:49]  Loading plugin: sscanf.dll
[20:11:49] 

[20:11:49]  ===============================

[20:11:49]       sscanf plugin loaded.     

[20:11:49]    © 2009 Alex "******" Cole

[20:11:49]    0.3d-R2 500 Players "dnee"

[20:11:49]  ===============================

[20:11:49]   Loaded.
[20:11:49]  Loading plugin: streamer.dll
[20:11:49] 

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

[20:11:49]   Loaded.
[20:11:49]  Loading plugin: Whirlpool.dll
[20:11:50]  
[20:11:50]  ==================
[20:11:50]  
[20:11:50]   Whirlpool loaded
[20:11:50]  
[20:11:50]  ==================
[20:11:50]  
[20:11:50]   Loaded.
[20:11:50]  Loaded 4 plugins.

[20:11:50] 
[20:11:50] Filterscripts
[20:11:50] ---------------
[20:11:50]   Loaded 0 filterscripts.

[20:11:50] OnGameo
[20:11:50]  
[20:11:50]  ======================================= 
[20:11:50]  |                                     | 
[20:11:50]  |        YSI version 1.03.0011        | 
[20:11:50]  |        By Alex "******" Cole        | 
[20:11:50]  |                                     | 
[20:11:50]  |  Checking the latest YSI version..  | 
[20:11:50]  |                                     | 
[20:11:50]  ======================================= 
[20:11:50]  
[20:12:11] [MySQL] (Main Pipelines) Connecting to 91.121.111.162...
[20:12:11] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 91.121.111.162 - DB: 9324_database - User: 9324_database
[20:12:11] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[20:12:11] [LoadHouses] Loading data from database...
[20:12:11] [LoadDynamicDoors] Loading data from database...
[20:12:11] [LoadDynamicMapIcons] Loading data from database...
[20:12:11] [LoadMailboxes] Loading data from database...
[20:12:11] [LoadTurfWars] 0 turfs loaded.
[20:12:11] [LoadPaintballArenas] 10 paintball arenas loaded.
[20:12:11] [LoadEventPoints] 0 event points loaded.
[20:12:11] [LoadGates] 400 gates loaded.
[20:12:11] [LoadElevatorStuff] 20 floors loaded.
[20:12:11] [LoadFamilies] 16 families loaded.
[20:12:11] [LoadPoints] 9 points loaded.
[20:12:11] [LoadCDealerships] 15 dealerships loaded.
[20:12:11] [MiscLoad] Misc Loaded
[20:12:11] [LoadCrates] Load Query Sent
[20:12:15]  
[20:12:15] -------------------------------------------
[20:12:15] Insanity Roleplay
[20:12:15]  
[20:12:15] Copyright © Insanity Roleplay, (2012-2013)
[20:12:15] All Rights Reserved
[20:12:15] -------------------------------------------
[20:12:15]  
[20:12:15] Number of vehicle models: 92
[20:12:15] --- Server Shutting Down.
[20:12:15] 

  > MySQL plugin unloaded.

[20:12:15] 

[20:12:15]  ===============================

[20:12:15]      sscanf plugin unloaded.    

[20:12:15]  ===============================

[20:12:15] 

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

[20:12:15]  
[20:12:15]  ====================
[20:12:15]  
[20:12:15]   Whirlpool unloaded
[20:12:15]  
[20:12:15]  ====================
[20:12:15]
Find
Reply
Wizzy951
Huge Clucker
****
Posts: 285
Threads: 20
Joined: Jul 2013
Reputation: 0
#7

13.12.2013, 17:11
Код:
[20:11:49]  Loading plugin: libmysql.dll
[20:11:49]   Plugin does not conform to architecture.
[20:11:49]   Failed.

[20:12:11] [MySQL] (Main Pipelines) Connecting to 91.121.111.162...
[20:12:11] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 91.121.111.162 - DB: 9324_database - User: 9324_database
[20:12:11] [MySQL] Note: Make sure that you have provided the correct connection credentials.
You are still trying to load libmysql.dll and also you haven't managed to connect to the mysql database properly.
Find
Reply
UnknownGamer
Gangsta
****
Posts: 518
Threads: 211
Joined: Apr 2012
Reputation: 0
#8

13.12.2013, 17:53
Please produce a MYSQL_LOG.

It will show us the MYSQL error's you're suffering.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help