Quote:
Originally Posted by xikkub
The server is running on my own machine. I guess I should contact myself and see what is going wrong.
|
You are hosting the game and the MySQL at the same (your own) computer?
Unless you have modified and compiled the source yourself, your ChatLog plugin connects to your default database. Check the
"default" settings in your
/addons/sourcemod/configs/databases.cfg. In there you should have something like this:
Code:
"default"
{
"driver" "default"
"host" "127.0.0.1"
"database" "<database>"
"user" "<username>"
"pass" "<password>"
}
Then check your MySQL user settings for <username>. It should be something like:
Code:
mysql> select * from mysql.user where User = '<username>';
+-----------+-------------+-------------------------------------------+...
| Host | User | Password |...
+-----------+-------------+-------------------------------------------+...
| localhost | <username> | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |...
+-----------+-------------+-------------------------------------------+...
1 row in set
mysql> select * from mysql.db where Db = '<database>' and User = '<username>';
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| localhost | <database> | <username> | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
1 row in set
Are they like so?