Raised This Month: $ Target: $400
 0% 

Amxbans 6.x


Post New Thread Reply   
 
Thread Tools Display Modes
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-19-2006 , 16:23  
Reply With Quote #301

Code:
L 04/19/2006 - 15:35:44: [amxbans.amxx] [AMXBANS] SQL error: can't connect: 'Host '216.130.181.4' is not allowed to connect to this MySQL server'
L 04/19/2006 - 15:35:44: [MYSQL] Invalid database handle 0
L 04/19/2006 - 15:35:44: [AMXX] Displaying debug trace (plugin "amxbans.amxx")
L 04/19/2006 - 15:35:44: [AMXX] Run time error 10: native error (native "dbi_query")
L 04/19/2006 - 15:35:44: [AMXX]    [0] phpd5ifm3.sma::banmod_online (line 293)
L 04/19/2006 - 15:35:44: [AMXX]    [1] phpd5ifm3.sma::init_function (line 234)
What am i not doing right. The web part of the amxbans works and the plugins on the server are recognized.

This is my mysql.cfg
Code:
amx_sql_host	"hollosite.com"
amx_sql_user	"username_goes_here"
amx_sql_pass	"password_goes_here"
amx_sql_db		"misson_amxbans"
amx_sql_table	"admin"
Please help

This is my admin_sql.sma
Code:
#if defined USING_SQL
	register_srvcmd("amx_sqladmins", "adminSql")
	register_cvar("amx_sql_table", "admin")
#endif
	register_cvar("amx_sql_host", "hollosite.com")
	register_cvar("amx_sql_user", "username_goes_here")
	register_cvar("amx_sql_pass", "password_goes_here")
	register_cvar("amx_sql_db", "misson_amxbans")
This is my plugins.ini
Code:
; Admin Base - Always one has to be activated
;admin.amxx		; admin base (required for any admin-related)
;admin_sql.amxx		; admin base - SQL version (comment admin.amxx)
admin_sql.amxx
amxbans.amxx debug
This is where i put amxbans (the website part):
http://misson.hollosite.com/amxbans/ban_list.php
I guessing since it cant connect to the MySQL, I can't see live bans, server info, etc

Please Help Me Set this Up Correctly

EDIT: They also gave me the MySQL Host: 65.98.98.66 Which I'm guessing is the same thing as hollosite.com. I tried both of them, but still get the same error.
cerberus414 is offline
Trip~Hazard
Senior Member
Join Date: Jun 2004
Location: North Carolina
Old 04-19-2006 , 18:13  
Reply With Quote #302

Whew!! Turning off the update checker in config worked like a champ. Sheez I was starting to panic....I realized just today how heavily I rely on amxbans.
__________________
Trip~Hazard is offline
Janet Jackson
Veteran Member
Join Date: Mar 2005
Location: far, far away from here
Old 04-19-2006 , 20:58  
Reply With Quote #303

Quote:
Originally Posted by cerberus414
Code:
L 04/19/2006 - 15:35:44: [amxbans.amxx] [AMXBANS] SQL error: can't connect: 'Host '216.130.181.4' is not allowed to connect to this MySQL server'
What am i not doing right. The web part of the amxbans works and the plugins on the server are recognized.
The answer is in your post : add 216.130.181.4 to the list of allowed hosts in your MySQL configuration.

To add live bans you will have to enter the rcon password first (in the web interface).
__________________
Janet Jackson is offline
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-19-2006 , 21:21  
Reply With Quote #304

is that why im getting errors with the amxbans plugin
cerberus414 is offline
Janet Jackson
Veteran Member
Join Date: Mar 2005
Location: far, far away from here
Old 04-19-2006 , 21:24  
Reply With Quote #305

Yup.
__________________
Janet Jackson is offline
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-19-2006 , 21:26  
Reply With Quote #306

ok, i got a mysql from freesql.org, but havent tried it out yet, do u think it will allow incoming connections?
cerberus414 is offline
Janet Jackson
Veteran Member
Join Date: Mar 2005
Location: far, far away from here
Old 04-19-2006 , 21:40  
Reply With Quote #307

Regarding this information I would assume they do.

However, the ip you mentioned (65.98.98.66) doesn't look like it's the right one. It is linked to mail.hollosite.com, not www.freesql.org.
__________________
Janet Jackson is offline
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-19-2006 , 22:02  
Reply With Quote #308

oh yea, freesql.org is a totally different database, screw hollosite since they dont allow any incoming connections. The ip I mentioned earlier was related to the hollosite db.
cerberus414 is offline
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-20-2006 , 04:33  
Reply With Quote #309

ok i got the servers to appear on the websites but then i tried to add a webadmin and i got this: "Your username or password is incorrect, or you are not an admin." And now whatever i do, it keeps displaying that. Help me please
cerberus414 is offline
cerberus414
Junior Member
Join Date: Oct 2005
Old 04-20-2006 , 05:48  
Reply With Quote #310

seems like the problems is only occuring with Mozilla Firefox, works fine with IE. Any ideas to why? Only thing i can think of is that when i enter a password, firefox automatically saves it and when u come back it keeps spiting out this error. And the only fix i see, is to reinstall amxbans again

Also now everytime I ban someone and go to ban_list.php i get this error:

Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat FROM amx_banhistory WHERE player_id = 'STEAM_ID_OF_BANNED_PERSON'
cerberus414 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:28.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode