Mysql server run help
#1

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.
Reply
#2

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 .
Reply
#3

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
Reply
#4

Here's a pic of the samp-server. It loads everything, 10 seconds later. This shit comes up.


Here are like the last 8 lines of the server_log

filterscripts yom_buttons gcustom
announce 1
query 1
plugins streamer sscanf mysql Whirlpool
weburl samp.com
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
maxnpc 0
logtimeformat [%H:%M:%S]
Reply
#5

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?
Reply
#6

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]
Reply
#7

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.
Reply
#8

how do i run it with xampp
Reply
#9

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.
Reply
#10

roel do i need xampp to run this server?
Reply
#11

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.
Reply
#12

how long will it take me to setup a database, can you help me with teamview or something?
Reply
#13

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?
Reply
#14

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
Reply
#15

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.
Reply
#16

Quote:
Originally Posted by Roel
View Post
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?
Really dude? REALLY? You really needed the stuff in a text format when it was there on the screen? "Wrong credentials for server" it didn't even say it couldn't connect just that it had the wrong login information but you really needed to have it in text?

@OP: Setting up XAMPP takes 5 minutes on an average PC. Then you go into PHPMyAdmin and create a database. In your GM (that is the PWN file) you will have to specify the account credentials to your database. Standard: Server: localhost User: root Password: no password. The database is the one you just created in PHPMyAdmin.

If the gamemode does not create the tables, there has to be a .sql file or other instructions what has to be in the database. If not, then you can basically throw everything away or you will be stuck with looking through all the code for the database info and guessing and it will take you a few months to get it 60% right.
Reply
#17

Okay, thats the same I told him , only in one post, and better english lol.
Reply
#18

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.
Reply
#19

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>?
Reply
#20

It's included with xampp, not sure how to start it lol, I never used xampp, maybe it's a button , but I guess it will be something like http://localhost:8080/phpmyadmin.
But I use USBwebserver, and that looks like that.
Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)