Problems with mysql connection

Found a bug? post about it here and your fix if you have one and we will review it and make them part of the official release.
TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Postby TI INDIAN » 02 Nov 2013, 20:47

Well i tried to run a query on phpmyadmin to grant access but it says access is denied to the database 'ip' ..

YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Postby YamiKaitou » 02 Nov 2013, 20:58

I never said anything about PMA

TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Postby TI INDIAN » 02 Nov 2013, 21:23

Hum... i tried to .. when i click and try to save or press enter it doesnt save it .. and it doesnt lemme save it :P

TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Postby TI INDIAN » 02 Nov 2013, 22:53

ok... I got something new.. I know but it is the same as the one who started this thread but please take a look at this

Code: Select all

Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query failed!
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Message: Table 'dg_site304.amx_serverinfo' doesn't exist (1146)
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '77.111.225.2:27015'
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query failed!
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Message: Table 'dg_site304.amx_reasons' doesn't exist (1146)
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] Query statement:
[AMXBans] No Reasons found
[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 11/02/2013 - 21:20:54: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Menu item 19 added to Menus Front-End: "AMXBans: Player-Flagging" from plugin "AMXBans Main"
Menu item 20 added to Menus Front-End: "AMXBans: Disconnected Players" from plugin "AMXBans Main"
Menu item 21 added to Menus Front-End: "AMXBans: Banhistory" from plugin "AMXBans Main"

YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Postby YamiKaitou » 03 Nov 2013, 00:37

You didn't install and setup the Web Interface yet

TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Postby TI INDIAN » 03 Nov 2013, 07:42

Hum... Can you explain a little more in a simple language.. didnt get you.. Web interface..Is it installed in mysql or in ftp?? or Do i have to make a support ticket to do it.. :)

Update: I have a rented a website and they have already made database in phpmyadmin... The setup is done by them not me...

Okay i got a message from them.. the message is

Hello,

All the informations on your database are available on the admin panel, in the "My website" menu :

http://verywiki.net/en/VeryGames_panel_ ... ase_access

---

We normally do not reject outside connection, and remote access to the database is allowed.

Can you give me examples of IP addresses that cannot reach the database ?

Best regards,


I sent them that my own game servers cant reach the database...

UPDATE2: How to know that which amx_table_prefix i will use... ?? now I am using amxbans as amx_table_prefix

YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Problems with mysql connection

Postby YamiKaitou » 04 Nov 2013, 14:58

Have you set up the web part yet?

TI INDIAN
Posts: 24
Joined: 31 Oct 2013, 09:50

Re: Problems with mysql connection

Postby TI INDIAN » 06 Nov 2013, 11:54

Ok yamikatou Now mysql works correctly.. i just had a small problem i wrote wrong table_prefix .. and now it works ... Special Thanks to Sami .. without him i could've done this and Thanks to you also yamikatou...


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 1 guest