Recommended MySQL Version?! For AMXBANS!

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
mrkiller2010
Posts: 8
Joined: 16 Jul 2014, 00:04

Recommended MySQL Version?! For AMXBANS!

Postby mrkiller2010 » 16 Jul 2014, 00:56

So my MySQL database is so weird, keeps disconnecting and crash all the time.
What is the best MySQL database you can have? For AMXBANS

Currently I have: Image

Do I need to tell the webhost to update or something?
Because these sucks, It's a really big delay between the server and the datebase.
Some times it doesn't even connect.

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

Re: Recommended MySQL Version?! For AMXBANS!

Postby YamiKaitou » 16 Jul 2014, 03:35

I haven't noticed an issue with this version

Code: Select all

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.5.37                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.37-cll                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)



What are the exact errors you are having?

mrkiller2010
Posts: 8
Joined: 16 Jul 2014, 00:04

Re: Recommended MySQL Version?! For AMXBANS!

Postby mrkiller2010 » 16 Jul 2014, 16:06

[QUOTE=YamiKaitou;2168427]I actually never stop developing it since I took it over, just put it on hold and only worked on supporting the current code.

Also, I haven't noticed an issue with this version

Code: Select all

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.5.37                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.37-cll                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)
[/QUOTE]

The connection is bad I think..
What the problem for me is that sometimes the database doesn't work so /amxbans says "Connection to the datebase is required" (not exactly that error but kind of that error) And that happends, everyone that is banned can join the server.

And we can't ban anyone neither.

Image

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

Re: Recommended MySQL Version?! For AMXBANS!

Postby YamiKaitou » 17 Jul 2014, 07:26

I need the exact error

mrkiller2010
Posts: 8
Joined: 16 Jul 2014, 00:04

Re: Recommended MySQL Version?! For AMXBANS!

Postby mrkiller2010 » 17 Jul 2014, 20:11

There is no error. The connection with this datebase and the server is slow.
And why is there a ! red mark on the amx site?

Can't you check if there is anything that you can optimze?

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

Re: Recommended MySQL Version?! For AMXBANS!

Postby YamiKaitou » 17 Jul 2014, 22:21

mrkiller2010 wrote:There is no error. The connection with this datebase and the server is slow.

Is it slow only on the website or also for the game server?

And why is there a ! red mark on the amx site?

I don't know where that image is from.

Can't you check if there is anything that you can optimze?

Is the SQL host on the same machine as the site?

mrkiller2010
Posts: 8
Joined: 16 Jul 2014, 00:04

Re: Recommended MySQL Version?! For AMXBANS!

Postby mrkiller2010 » 17 Jul 2014, 23:53

Image

It's the same hosting comapny www.citynetwork.se I don't know if it's on the same machine.

And I talked to them, They said it was the latest version of MySQL For solaris11.

The ban doesn't connect to the site sometimes.
I mean the connection lose sometimes.
On the /amxbans.php it says Connection to database lost
and in the server once you ban someone nothing happens.

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

Re: Recommended MySQL Version?! For AMXBANS!

Postby YamiKaitou » 18 Jul 2014, 02:13

In your config, are you using localhost or something else?

mrkiller2010
Posts: 8
Joined: 16 Jul 2014, 00:04

Re: Recommended MySQL Version?! For AMXBANS!

Postby mrkiller2010 » 18 Jul 2014, 11:15

I use: amx_sql_host "mysql12.citynetwork.se"

using localhost:

[AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 07/18/2014 - 11:14:53: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 07/18/2014 - 11:14:53: [amxbans_main.amxx] [AMXBans] Connection failed!
L 07/18/2014 - 11:14:53: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17
L 07/18/2014 - 11:14:53: [amxbans_main.amxx] [AMXBans] Message: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (2002)
L 07/18/2014 - 11:14:53: [amxbans_main.amxx] [AMXBans] Query statement:

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

Re: Recommended MySQL Version?! For AMXBANS!

Postby YamiKaitou » 18 Jul 2014, 12:30

Unless your Game Server and SQL server are on the same machine, do not use localhost.

My question was related to your Web Host


Return to “Support and Help”

Who is online

Users browsing this forum: No registered users and 0 guests