MySql help me - Printable Version

MySql help me - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySql help me (/showthread.php?tid=480964)

MySql help me - Dorlevi1506 - 13.12.2013

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.

Re: MySql help me - ViruZz - 13.12.2013

Nah, we dont help NGRP copycats.

Re: MySql help me - Wizzy951 - 13.12.2013

Could you show me your server.cfg please ? Are you trying to load libmysql.dll through it ?

Re: MySql help me - Dorlevi1506 - 13.12.2013

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

Re: MySql help me - Wizzy951 - 13.12.2013

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 !

Re: MySql help me - Dorlevi1506 - 13.12.2013

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]

Re: MySql help me - Wizzy951 - 13.12.2013

Код:

[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.

Re: MySql help me - UnknownGamer - 13.12.2013

Please produce a MYSQL_LOG.

It will show us the MYSQL error's you're suffering.