Posts: 13
Threads: 2
Joined: Feb 2014
Reputation:
0
So I have a Sa-Mp server running an GM with MySQL. I tryed to use the webhost database. I did it (i think). The servers load normaly. But when I join the game. No Login Screen or Registration Scree. I press spawn and it disconects me( because u cannot be spawned whitout login). Is from the DB or is from Pawno? It runs perfectly on my PC with XAMPP DB and everything. But on the Linux Server nope....it wont work. Any ideeas why?? (srry for bad english)
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Check the logs. If no dialog or anything comes up then there is likely no connection. Many webhosts do not allow external access to the back-end. Besides that, external MySQL connections are insecure and much, much slower than local connections and are therefore not suitable for fast paced systems like a gameserver.
Posts: 13
Threads: 2
Joined: Feb 2014
Reputation:
0
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team
[18:28:37] password = "" (string)
[18:28:37] filterscripts = "" (string)
[18:28:37] mapname = "San Andreas" (string)
[18:28:37] language = "" (string)
[18:28:37]
[18:28:37] Server Plugins
[18:28:37] --------------
[18:28:37] Loading plugin: crashdetect.so
[18:28:37] CrashDetect v4.15.1 is OK.
[18:28:37] Loaded.
[18:28:37] Loading plugin: fixes2.so
[18:28:37]
[18:28:37] ===============================
[18:28:37] fixes plugin loaded.
[18:28:37] © 2012 Alex "******" Cole
[18:28:37] ===============================
[18:28:37] Loaded.
[18:28:37] Loading plugin: streamer.so
[18:28:37]
*** Streamer Plugin v2.7.7 by Incognito loaded ***
[18:28:37] Loaded.
[18:28:37] Loading plugin: sscanf.so
[18:28:37]
[18:28:37] ===============================
[18:28:37] sscanf plugin loaded.
[18:28:37] Version: 2.8.1
[18:28:37] © 2012 Alex "******" Cole
[18:28:37] ===============================
[18:28:37] Loaded.
[18:28:37] Loading plugin: mysql.so
[18:28:37] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[18:28:37] Loading plugin: mysql_static.so
[18:28:37] >> plugin.mysql: R39-4 successfully loaded.
[18:28:37] Loaded.
[18:28:37] Loading plugin: Whirlpool.so
[18:28:37]
[18:28:37] ==================
[18:28:37]
[18:28:37] Whirlpool loaded
[18:28:37]
[18:28:37] ==================
[18:28:37]
[18:28:37] Loaded.
[18:28:37] Loaded 6 plugins.
[18:28:37]
[18:28:37] Filterscripts
[18:28:37] ---------------
[18:28:37] Loaded 0 filterscripts.
[18:28:37]
[18:28:37]
[18:28:37]
[18:28:37] =======================================
[18:28:37] | |
[18:28:37] | YSI version 3.09.0684 |
[18:28:37] | By Alex "******" Cole |
[18:28:37] | |
[18:28:37] =======================================
[18:28:37]
[18:28:37]
[18:28:37]
[18:28:37]
[ -- ] [ Gamemode is Starting ] [ -- ]
[18:28:37] [MySQL] Using connection no. 2
[18:28:37] [MYSQL]: Connection succesful!
[18:28:37]
[ -- ] [ Gamemode STARTED ] [ -- ]
[18:28:37] Number of vehicle models: 0
[18:30:20] [connection] 94.52.113.7:60356 requests connection cookie.
[18:30:21] [connection] incoming connection: 94.52.113.7:60356 id: 0
[18:30:21] [join] Maurice has joined the server (0:94.52.113.7)
[18:30:21] ABC: {FF0000}AdmBot{FFFFFF}: New Record, there are 1 players online (17.11.2015 18:30)
[18:30:39] [death] Maurice died 255
[18:30:39] [part] Maurice has left the server (0:2)
Posts: 312
Threads: 94
Joined: Jun 2012
Reputation:
0
Check out my mysql Tutorial below in my signiture
Posts: 13
Threads: 2
Joined: Feb 2014
Reputation:
0
Should I change the whole login system?
Posts: 312
Threads: 94
Joined: Jun 2012
Reputation:
0
its up to you, if yours is not working correctly then maybe you should
Posts: 13
Threads: 2
Joined: Feb 2014
Reputation:
0
I think it's from the DB. The problem it' it can only be accesible with phpMyAdmin. Because its on a webhost.
