AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Ask questions about errors and problems related to the amxbans project.
The more details you give, the better answer you will receive, READ the sticky topics before posting!

Be sure to post in the right sub forum: Bugs and Security
thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 26 Mar 2020, 18:51

With amxbans_use_admins_file 0 (to use SQL), I get this in the game console when trying to access commands in-game:
You have no access to that command

tier69
Posts: 11
Joined: 21 Dec 2019, 00:26

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby tier69 » 01 Apr 2020, 15:51

Hi! If you game server and mysql server using one host, when by default is localhost or 127.0.0.1 and mysql port 3306.
if you game server and mysql server of different servers, when for setting game server amxbans use remote ip mysql
Good luck

User avatar
indianiso1
Posts: 162
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 02 Apr 2020, 20:56

Check if in WEB view.php (Servers) it shows properly IP and player list
Check if RCON in admin area is set correctly
Check if there are no blocks for incoming requests for server (I know few who has it)

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

AMXBANS IS connecting game server BUT no admins

Postby thescaryguy » 08 May 2020, 15:38

Game server is now connecting to sql database, but no admins.

LOGS:
L 05/08/2020 - 08:29:00: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 74.91.115.106:27015
L 05/08/2020 - 08:29:00: [amxbans_main.amxx] [AMXBANS DEBUG] UPDATE `amx_serverinfo` SET timestamp=1588944540,hostname='TEK Community Axis Bot Server (Modified Maps)',gametype='dod',amxban_version='6.13', amxban_menu=1 WHERE address = '74.91.115.106:27015'
L 05/08/2020 - 08:29:00: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 is online
L 05/08/2020 - 08:29:01: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 05/08/2020 - 08:33:19: [admincmd.amxx] Cmd: "TEK Community Axis Bot Server (<0><><>" ask for players list

amxbans.cfg
// How AMXBans should handle the admins
// 0 = SQL, 1 = users.ini, 2 = load no admins
amxbans_use_admins_file 0

sql.cfg
// SHOULD THIS BE <<<<<<<<<<<<<<<<<<<<<<
// admins (NO)
// amx_amxadmins (NO) -OR- _amxadmins (NO) -OR- amxadmins (NO) *
// amx_admins_servers (NO) -OR- _admins_servers (NO) -OR- admins_servers (NO)
amx_sql_table "admins"

All these bots should have "a" (admin) access, instead they have "z"

Code: Select all

Clients on server:
 #  nick             authid               userid   imm  res  access
 1  Gen. Mark Wahlb  BOT                  1        No     No     z
 2  Gen. Crappy Fra  BOT                  2        No     No     z
 3  Gen. Gottlieb D  BOT                  3        No     No     z
 4  Gen. Adolphus B  BOT                  4        No     No     z
 5  Gen. Albert Ein  BOT                  5        No     No     z
 6  Gen. Ferdinand   BOT                  6        No     No     z
 7  Gen. Adolph Coo  BOT                  7        No     No     z
 8  Gen. Joseph Goe  BOT                  8        No     No     z
 9  Gen. Mercedes B  BOT                  9        No     No     z
10  Gen. Ferdinand   BOT                  10       No     No     z
11  Gen. Ludwig Bee  BOT                  11       No     No     z
12  Gen. Heidi Klum  BOT                  12       No     No     z
13  Gen. Oscar Maye  BOT                  13       No     No     z
14  Gen. Rudolf Die  BOT                  14       No     No     z
15  Gen. Levi Strau  BOT                  15       No     No     z
16  Gen. Wiener Sch  BOT                  16       No     No     z
Total 16


When I use users.ini intstead, admin works fine.

Code: Select all

Clients on server:
 #  nick             authid               userid   imm  res  access
 1  Gen. Mark Wahlb  BOT                  34       Yes    No     a
 2  Gen. Crappy Fra  BOT                  35       Yes    No     a
 3  Gen. Gottlieb D  BOT                  36       Yes    No     a
 4  Gen. Adolphus B  BOT                  37       Yes    No     a
 5  Gen. Albert Ein  BOT                  38       Yes    No     a
 6  Gen. Ferdinand   BOT                  39       Yes    No     a
 7  Gen. Adolph Coo  BOT                  40       Yes    No     a
 8  Gen. Joseph Goe  BOT                  41       Yes    No     a
 9  Gen. Mercedes B  BOT                  42       Yes    No     a
10  Gen. Ferdinand   BOT                  43       Yes    No     a
11  Gen. Ludwig Bee  BOT                  44       Yes    No     a
12  Gen. Heidi Klum  BOT                  45       Yes    No     a
13  Gen. Oscar Maye  BOT                  46       Yes    No     a
14  Gen. Rudolf Die  BOT                  47       Yes    No     a
15  Gen. Levi Strau  BOT                  48       Yes    No     a
16  Gen. Wiener Sch  BOT                  49       Yes    No     a
Total 16

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 09 May 2020, 14:05

I have a work-around solution to the problem. I am writing a php script to read the amxbans amx_amxadmins database to create a users.ini file.
That way, only the amxbans admins list has to be updated and the users.ini is updated from that.

User avatar
indianiso1
Posts: 162
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 13 May 2020, 17:20

Why should You need bots to be with special accesses?

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 24 May 2020, 15:04

indianiso1 wrote:Why should You need bots to be with special accesses?

So they don't get banned for TK's of other bots/players on their team. They only have immunity.
Last edited by thescaryguy on 28 May 2020, 17:19, edited 1 time in total.

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 28 May 2020, 17:18

Getting these errors:
Warning: Creating default object from empty value in /home4/tek/public_html/amxbans/include/config.inc.php on line 24

Warning: Cannot modify header information - headers already sent by (output started at /home4/tek/public_html/amxbans/include/config.inc.php:24) in /home4/tek/public_html/amxbans/login.php on line 74

Warning: Cannot modify header information - headers already sent by (output started at /home4/tek/public_html/amxbans/include/config.inc.php:24) in /home4/tek/public_html/amxbans/login.php on line 106

User avatar
indianiso1
Posts: 162
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 02 Jun 2020, 21:57

That is not a huge problem. Disable display_errors in Your php.ini file


Return to “Support and Help”

Who is online

Users browsing this forum: No registered users and 4 guests