Difference between revisions of "Troubleshooting"

From GExtension Wiki
Jump to navigation Jump to search
Line 2: Line 2:
  
 
==MySQL==
 
==MySQL==
 +
<pre style="color: red">PLEASE do not create support tickets for MySQL related problems. We can't say you much more than written here. Contact your hoster instead.</pre>
 +
 
'''"Access denied for user 'mysqluser'@'123.12.31.123' (using password: YES)"'''
 
'''"Access denied for user 'mysqluser'@'123.12.31.123' (using password: YES)"'''
 
*You are using a MySQL user that doesn't has access. This is caused by wrong password, not whitelisted IP or insufficient permissions to the database.
 
*You are using a MySQL user that doesn't has access. This is caused by wrong password, not whitelisted IP or insufficient permissions to the database.
Line 11: Line 13:
 
'''"Unknown MySQL server host '...'"'''
 
'''"Unknown MySQL server host '...'"'''
 
*If you are using a MySQL IP like *.mysql.db or similar: This is a custom hostname created by your (web)hoster. They will not work on your GMOD server. Ask for the correct IP and make sure that remote connections are allowed. If not: you entered an invalid IP/hostname or the MySQL server does not accept remote connections.
 
*If you are using a MySQL IP like *.mysql.db or similar: This is a custom hostname created by your (web)hoster. They will not work on your GMOD server. Ask for the correct IP and make sure that remote connections are allowed. If not: you entered an invalid IP/hostname or the MySQL server does not accept remote connections.
 +
'''"Connection refused"'''
 +
*Make sure you entered the correct IP/hostname of your MySQL server. Your MySQL server must also be reachable by your webserver (allow remote connections). Contact the hoster of your MySQL server, if you still have problems.
  
  

Revision as of 15:10, 3 January 2018

You have a problem with GExtension? The most common problems with their solutions are listed here.

MySQL

PLEASE do not create support tickets for MySQL related problems. We can't say you much more than written here. Contact your hoster instead.

"Access denied for user 'mysqluser'@'123.12.31.123' (using password: YES)"

  • You are using a MySQL user that doesn't has access. This is caused by wrong password, not whitelisted IP or insufficient permissions to the database.

"Can't connect to local MySQL server through socket"

  • Make sure that you used the correct IP (if you are using localhost, the MySQL server needs to be on the same machine as you GMOD/Web server)
  • You may used "localhost" as IP. Try 127.0.0.1, the IP or your hostname instead. If the problem persists, try entering the socket path in the config. The default is "/var/lib/mysql/mysql.sock", but may differs by hoster.

"Can't connect to MySQL server on '...'"

  • You may entered a wrong ip/hostname or the mysql server does not allow remote connections.

"Unknown MySQL server host '...'"

  • If you are using a MySQL IP like *.mysql.db or similar: This is a custom hostname created by your (web)hoster. They will not work on your GMOD server. Ask for the correct IP and make sure that remote connections are allowed. If not: you entered an invalid IP/hostname or the MySQL server does not accept remote connections.

"Connection refused"

  • Make sure you entered the correct IP/hostname of your MySQL server. Your MySQL server must also be reachable by your webserver (allow remote connections). Contact the hoster of your MySQL server, if you still have problems.


Web

"Could not update" + permission error / Warning: fopen(...): failed to open stream: Permission denied

"Servers" tab doesn't show status of my servers

  • Make sure that your servers have the correct time.

I lost my superadmin rank on the web

  • To regrant the rank, you need a server which is connected with GExtension. Run this command in the console: gex_setgroup <steamid64> superadmin 0

The console ist not working

  • Add -condebug to the start parameters of your Garry's Mod server. IMPORTANT: Make sure to delete/move the console.log file from time to time. Otherwise, the file may gets too big and creates lags.

Warning: curl_setopt(): CURLOPT_FOLLOWLOCATION cannot be activated when an open_basedir is set in ...

  • Set safe_mode = Off in your php.ini file and make sure that all OpenBaseDir options are disabled. Ask your hoster if you do not have access to it or switch to an other one.

Warning: curl_exec() has been disabled for security reasons in ...

  • Your hoster does not allow cURL. Switch to another one.

My users complete the Steam login, but do not get logged in

  • Make sure that you configured http/https correctly in the config.php

session_start(): open(..., O_RDWR) failed: Permission denied (13)

  • You webserver can't access the session path. Check php.ini and permissions.


Lua

The most issues can be solved by just taking a look into the SERVER console:

My server doesn't show up in the server list

  • Make sure to look at the server list in the settings. If the server doesn't show up, it's most likely a mysql issue. Make sure your credentials are correct and check the server log for [GExtension] related stuff.

GExtension is not initialized/Could not initialize

  • Take a look in the SERVER-console for errors. You may forgot to assign your server to a serverbundle or the mysql connection failed.

You need to have tmysql4 or mysqloo installed

  • You do not have a mysql module installed. See MySQL

Users are losing their groups on the server

  • You need to navigate to Admin -> Settings -> Groups and create all groups you have in GMOD with the EXACT SAME name.

I lost my group on the server

  • You most likely forgot to also set you a rank for the serverbundle. Navigate to Search -> Your Pofile and click on the pencil. Please note that the name of the web and gmod groups has to be the same (case sensitive!!!).

There are lags on my server

  • Make sure to use tMySQL4 and check that your console.log file isn't too big.

Some (DarkRP) commands (like /advert or /ooc) don't work anymore

  • Disable the ChatTags in the Lua config.

My admins can't ban users (permission error)

  • Make sure that theire group has the correct permissions and that they have a HIGHER permission level than the user they want to ban. You may also want to check if there are any ban-time limitations set in the group settings.

"[Error] addons/gextension/lua/gextension/server/sv_mysql.lua:53: Module not found!"

  • You did not install the mysql module correctly (you most likely forgot to upload the libmysql file). See MySQL