Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
Well i downloaded a script and all of it is mysql.
When i click the samp-server, everything loads, and then it just closes...
Can anyone please help, how do I run a mysql server.. please asap.
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Look inside your server_log and your mysql_log(if this is enabled).
En send us the last lines of those log files,
also explain a little more, does it close directly when you start it, or does it close when a player connects .
Posts: 1,938
Threads: 16
Joined: Feb 2007
Reputation:
0
Install XAMPP and connect to your local MySQL database over there or connect to an external database if you have bought one.
Also make sure you have the mysql plugin (correct version, mind you) and have it loaded
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Thats your server.cfg
I need the mysql_log.txt , mysql_debug(1); inside your ongamemodeinit if it isn't there yet, also look if there isn't a mysql_debug(0); inside of it so you can edit it to 1.
After that , restart the server, and post some of your mysql_log.txt lines.
If you look at your console, you see it cannot connect to mysql, try to set your IP to localhost, might this works, and be sure the database data is correct with the database inside your server.
Do you even have a database running on your local pc?
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
I don't know anything about scripting, by the way.
I know how to edit shit but not like, all that mysql.
[20:28:51]
[20:28:51] This server folder has been put together by Ricky Phelps.
[20:28:52] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[20:28:52] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 127.0.0.1 - DB: ngrp_main - User: root
[20:28:52] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[20:28:52] [LoadHouses] Loading data from database...
[20:28:52] [LoadDynamicDoors] Loading data from database...
[20:28:52] [LoadDynamicMapIcons] Loading data from database...
[20:28:52] [LoadTurfWars] 0 turfs loaded.
[20:28:52] [LoadPaintballArenas] 10 paintball arenas loaded.
[20:28:52] [LoadGates] 4000 gates loaded.
[20:28:52] [LoadFamilies] 16 families loaded.
[20:28:52] [LoadPoints] 9 points loaded.
[20:28:53] [LoadCDealerships] 15 dealerships loaded.
[20:28:53] [MiscLoad] Misc Loaded
[20:28:59] Number of vehicle models: 63
[20:28:59] --- Server Shutting Down.
[20:29:00]
*** Streamer Plugin v2.6.1 by Incognito unloaded ***
[20:29:00]
[20:29:00] ===============================
[20:29:00] sscanf plugin unloaded.
[20:29:00] ===============================
[20:29:00]
> MySQL plugin unloaded.
[20:29:00]
[20:29:00] ====================
[20:29:00]
[20:29:00] Whirlpool unloaded
[20:29:00]
[20:29:00] ====================
[20:29:00]
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Yes I gues you don't have a database running on your pc, you can install XAMPP and create the database.
But if you don't know anything about mysql, you better can use a gamemode without mysql, or learn it before you are going to work with this one.
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
how do i run it with xampp
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
download and install it, then you can make create a database, and you should make a database that corresponds with the database in the gamemode.
But i don't use XAMPP so maybe somebody else can help you with that.
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
roel do i need xampp to run this server?
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
On your local pc you need a database to run, and xampp is an example to do this. there are more tools to run a database, but you have to run a database to run this server yes.
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
how long will it take me to setup a database, can you help me with teamview or something?
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
I'm at my work so no, but it takes a while if your gamemode includes alot tables .
I don't know that, but I think it does. But I don't know where you get this gamemode from , isn't there a .sql file included with it?
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
Nah I searched all of the folder, no .sql - it's got like .dll and my friend sent me this script to see if it work i think its like the sarp one
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Well I don't know anything about those gamemodes, so you better can ask that at the topic of the gamemode release, or ask your friend for help. or just create the whole database.
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Okay, thats the same I told him , only in one post, and better english lol.
Posts: 727
Threads: 79
Joined: Mar 2012
Reputation:
0
Lol,
Create a local database.
Login to myphpadmin.
create database with the same name as the database in your gamemode.
and import that file. it's easy just follow the instructions that you can find at the xampp thing.
And if I look at the structure of that database, you better can create your own gamemode or find a better one, because this looks like shit.
Posts: 44
Threads: 8
Joined: Jul 2012
Reputation:
0
I'm going to install xampp now, ill inform you all if i need help because i know nothing of this shit.
what the fuck is myphpadmin>?
