Oxide - SQLStats [Unmaintained]

kantzz1

Not connected...
reason?
It requires a detailed explanation.

"Navicat for MySQL" 과는 상관없는지??

Config
{
"dbConnection": {
"Database": " ? ",
"Host": "My Host IP?",
"Password": "Server Password?",
"Port": 3306,
"Username": "My Steam?"
}
}

Last edited by a moderator: Dec 22, 2015

kantzz1, Dec 22, 2015

#21

Visagalis

Does your password contains exotic symbols? Please use a_z, A_Z, 0-9, @!#$%&*-+() only in password and see if issue is resolved

Visagalis, Dec 22, 2015

#22

kantzz1

Heatst0rm said: ↑

Maybe weapons WITH holosight and silencer

Click to expand...

Continue errors.
What's wrong with me?

[12/22/2015 3:28:10 PM] [Oxide] 3:28 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)

kantzz1, Dec 22, 2015

#23

Visagalis

kantzz1 said: ↑

Continue errors.
What's wrong with me?

[12/22/2015 3:28:10 PM] [Oxide] 3:28 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)

Click to expand...

Seems like your host firewall might be blocking it?
Or you've set up MySQL account wrong?

Visagalis, Dec 22, 2015

#24

Heatst0rm

You should check your parameters and firewall configuration @kantzz1

Heatst0rm, Dec 22, 2015

#25

kantzz1

Firewall settings are perfect!
I was not the MySQL configuration.
What version of MySQL?
So many versions
MySQL :: MySQL Downloads

kantzz1, Dec 22, 2015

#26

antisoma

Contact your host and ask them to allow incoming connections - you might be able to do it in cpanel from RemoteSQL?

antisoma, Dec 23, 2015

#27

cyris69

Finally got this working, not sure what but I think it was a type issue with either db or user. Then ran the provided SQL query command to create all the tables. Now my question is I'm not a coder at least in php/SQL at all. I know there used to be a plugin similar to this but it also added a simple webhost that displayed all this information with pie charts etc but can't find it. How would I go about setting up something to display the gathered information on my server site?

cyris69, Dec 25, 2015

#28

Visagalis

cyris69 said: ↑

Finally got this working, not sure what but I think it was a type issue with either db or user. Then ran the provided SQL query command to create all the tables. Now my question is I'm not a coder at least in php/SQL at all. I know there used to be a plugin similar to this but it also added a simple webhost that displayed all this information with pie charts etc but can't find it. How would I go about setting up something to display the gathered information on my server site?

Click to expand...

You need a guy who knows php and ask him to do it for you

Visagalis, Dec 25, 2015

#29

[ZB]MrGrimm

Anyone offering help on how to get this in website form?

[ZB]MrGrimm, Dec 30, 2015

#30

Galgenjunge

I have little problem with the store names in the database. I have a Russian player on my server name will not be stored in the database. Кош... is a name.

Galgenjunge, Jan 10, 2016

#31

DosAi

How fix it? Please help me!

Code:

[Oxide] 8:51 AM [Info] Loaded plugin SQLStats v1.0.2 by Visagalis
[Oxide] 8:51 AM [Info] [SQLStats] Opening connection.
[Oxide] 8:51 AM [Info] [SQLStats] Connection opened.
[Oxide] 8:51 AM [Error] MySql handle raised an exception (MySqlException: Access denied for user 'u488039502_admin'@'5.19.161.13' (using password: YES))
[Oxide] 8:51 AM [Debug]   at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket () [0x00000] in <filename unknown>:0
[Oxide] 8:51 AM [Error] MySql handle raised an exception in 'SQLStats v1.0.2' plugin (MySqlException: Access denied for user 'u488039502_admin'@'5.19.161.13' (using password: YES))
[Oxide] 8:51 AM [Debug]   at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket () [0x00000] in <filename unknown>:0

DosAi, Jan 17, 2016

#32

Galgenjunge

DosAI:
So in this case it could be folgenes:
Mysql password is incorrect
Mysql user may only connect Local
MySQL Server responds to the IP does not say is set to bind 127.0.0.1
hosting you by nitrado?

Last edited by a moderator: Jan 17, 2016

Galgenjunge, Jan 17, 2016

#33

DosAi

My hosting - Hostinger. I connect to my database with external IP. Password 100% valid. May be i need open port?

DosAi, Jan 17, 2016

#34

Galgenjunge

Can you connect whis Navicat on MySQL Server. You can Download Demo

I have Port Scan on 5.19.161.13 Port 3306 not open from external.

Last edited by a moderator: Jan 18, 2016

Galgenjunge, Jan 18, 2016

#35

raidrust

antisoma said: ↑
This is a wonderful plugin, very powerful. I've been testing it on my server and it is working extremely well.

Our stats are here:
[EU] BEST - European Rust Server

Want a list of players on your website that build the most on your server?

Connect to your SQL database -
Code:
<?php
$servername = "localhost";
$username = "sqldatabaseusername";
$password = "sqldatabasepassword";
$dbname = "sqldabasename";// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
}
?>
Select specific sql data - create table -
Code:
<table><thead>
<tr>
<th data-column-id="name">Name</th>
<th data-column-id="kills" data-type="numeric">Building Parts Created</th>
</tr>
</thead>
<tbody>
               
<?php
$sql = "SELECT name, SUM(count) FROM q_PlayerBuilds GROUP BY name ORDER BY SUM(count) DESC LIMIT 25";
$result = $conn->query($sql);if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr><td>".$row["name"]."</td><td>".$row["SUM(count)"]."</td></tr>";
}
echo "</tbody>";
echo "</table>";
} else {
echo "0 results";
}
?>
</div>
Kill connection to sql -
Code:
<?php
$conn->close();
?>
Click to expand...
HI please can u tell me hot what script i need for create it ? in my page? i need a new page in menu or can use witget ??
[DOUBLEPOST=1453298548,1453275794][/DOUBLEPOST]please help me to make the page i am Connect in DB but idk how to make the tables in my page
i can PAY or update this and im donate u 10 USD

Last edited by a moderator: Jan 20, 2016

raidrust, Jan 20, 2016

#36

Galgenjunge

I have written to you privately chat. "Raidrust".

Galgenjunge, Jan 21, 2016

#37

Reynostrum

I have remote conections enabled and tested in MySQL, but I still get.
Code:
[Error] 
[SQLStats] Opening connection.
[SQLStats] Connection opened.MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
The permissions for 3306 are also ok. I tested the connection by php from other host, and everything is fine.

There is nothing wrong, everything is fine, but it does not work.

Reynostrum, Jan 31, 2016

#38

Cayos

i made this today using your stats plugin, Thank you for this. I would love to talk to you about making a few addons so i can make a tool to allow everyone the ability to use my script.

http://iplayrust.com/index.php/main/stats/stats_player - notice the menu at the top.

I know this is not pretty its just functional.

Cayos, Jan 31, 2016

#39

Loup-des-Neiges

Cayos said: ↑

i made this today using your stats plugin, Thank you for this. I would love to talk to you about making a few addons so i can make a tool to allow everyone the ability to use my script.

http://iplayrust.com/index.php/main/stats/stats_player - notice the menu at the top.

I know this is not pretty its just functional.

Click to expand...

Nice work, but it is not prudent to view the IP of your players.

Loup-des-Neiges, Jan 31, 2016

#40