[alexinno]

both configs are exactly like mine on ubuntu just one difference , you have commented out

bind-address           = 127.0.0.1

so when you try to create symlink it says that /var/run/mysqld/mysqld.sock is not there ?
sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

i'd say it's a mysql version issue

[Mordekay]

I've commented out this line to allow a friend of mine to use my mysql-server for his servers.
It created the symlink and now the error message changed to

L 08/16/2009 - 16:49:27: Server cannot connect to database
L 08/16/2009 - 16:49:27: Error (1045): Access denied for user 'XXXXXXXX'@'localhost' (using password: NO)

Wtf???

I've removed the username as it is the user who runs the servers and i don't want to risk idiots spamming my server with false passwords

[alexinno]

for that you can add some iptables rules , to allow only trusted IP or IP classes to connect to the mysql server and drop the rest

/sbin/iptables -A INPUT -p tcp -m tcp -s xxx.xxx.xxx.xxx --dport 3306 -j ACCEPT
/sbin/iptables -A INPUT -p tcp -m tcp -s xxx.xxx.xxx.xxx/24 --dport 3306 -j ACCEPT
/sbin/iptables -A INPUT -p tcp -m tcp --dport 3306 -j DROP

so the plugin it's working as it should ?

[Mordekay]

Sadly he changes his server more often than others do it with their underwear .
That's not a big problem at all. The server is setup to ban IP's that do false requests to often.

But that does not explain why psychostats now tries to connect with the username of the user that is running the server, because the username for the msql-database is another.

[alexinno]

so basically we were debuging ... nothing , just a wrong mysql mysql user
it was fun anyway, i like this kind of stuff (debugging i mean)

[Mordekay]

the data in the psychostats.sma is correct.
But now it tries to connect with false datas, why?

[liryck]

i dont know why but when i use a command from this plugin server freeze for seconds =S i dont understood why.

my server and psycho database is in the same machine =/

[Dark-Master]

Originally Posted by liryck i dont know why but when i use a command from this plugin server freeze for seconds =S i dont understood why. my server and psycho database is in the same machine =/

Mine too.

[trifty]

hey guys .. can u tell me why i cant use this ?

my log

* AMXX Psychostats errors will be listed here:
------------------------------------------------------
L 11/09/2009 - 19:59:43: Server cannot connect to database
L 11/09/2009 - 19:59:43: Error (2003): Can't connect to MySQL server on '1' (10051)
L 11/09/2009 - 20:01:19: Server cannot connect to database
L 11/09/2009 - 20:01:19: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:01:22: Server cannot connect to database
L 11/09/2009 - 20:01:22: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:03:51: Server cannot connect to database
L 11/09/2009 - 20:03:51: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:03:53: Server cannot connect to database
L 11/09/2009 - 20:03:53: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:11:59: Server cannot connect to database
L 11/09/2009 - 20:11:59: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:13:01: Server cannot connect to database
L 11/09/2009 - 20:13:01: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:15:47: Server cannot connect to database
L 11/09/2009 - 20:15:47: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/09/2009 - 20:15:50: Server cannot connect to database
L 11/09/2009 - 20:15:50: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO)
L 11/10/2009 - 17:05:11: Server cannot connect to database

ive been trying hard for few days but it cant work.. i placed the files as same as said in the txt file but still cant.. plz help thankss~

[Dr.G]

Originally Posted by trifty hey guys .. can u tell me why i cant use this ? my log * AMXX Psychostats errors will be listed here: ------------------------------------------------------ L 11/09/2009 - 19:59:43: Server cannot connect to database L 11/09/2009 - 19:59:43: Error (2003): Can't connect to MySQL server on '1' (10051) L 11/09/2009 - 20:01:19: Server cannot connect to database L 11/09/2009 - 20:01:19: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:01:22: Server cannot connect to database L 11/09/2009 - 20:01:22: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:03:51: Server cannot connect to database L 11/09/2009 - 20:03:51: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:03:53: Server cannot connect to database L 11/09/2009 - 20:03:53: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:11:59: Server cannot connect to database L 11/09/2009 - 20:11:59: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:13:01: Server cannot connect to database L 11/09/2009 - 20:13:01: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:15:47: Server cannot connect to database L 11/09/2009 - 20:15:47: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/09/2009 - 20:15:50: Server cannot connect to database L 11/09/2009 - 20:15:50: Error (1045): Access denied for user 'ODBC'@'localhost' (using password: NO) L 11/10/2009 - 17:05:11: Server cannot connect to database ive been trying hard for few days but it cant work.. i placed the files as same as said in the txt file but still cant.. plz help thankss~

Did you fix this or? Guess you just need to tell it the password to the DB (: