Raised This Month: $ Target: $400
 0% 

ChatLog v1.3.7 (Extended)


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
muukis
Veteran Member
Join Date: Apr 2009
Old 05-12-2009 , 15:43   Re: ChatLog v1.3.1 (Extended)
Reply With Quote #11

Quote:
Originally Posted by xikkub View Post
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?

Last edited by muukis; 05-12-2009 at 15:52. Reason: More MySQL
muukis is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:51.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode