MYSQL Querying Error

[MoFFaTT]

I've managed to get the FT plugin to connect to a remote mysql database and I have used the "vault to mysql" conversion page to convert everyones xp over. That worked fine but no one is recieving their original xp although any xp they do gain (after the database was connected) is still saved.

This is the only error I can find in the log file which repeats itself every map change. I'm not sure why the select command is being denied, I've set the access rights to "all privileges" so the plugin should be able to query the database.

Code: Select all

L 08/04/2007 - 08:31:43: ** Plugin version: '3.0 RC8' 
L 08/04/2007 - 08:31:43: [MYSQLX] Error in querying database, location: 12
L 08/04/2007 - 08:31:43: [MYSQLX] Message: SELECT command denied to user 'cs167294_FT'@'8.2.122.172' for table 'tables' (1142)
L 08/04/2007 - 08:31:43: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'cs167294_csstuff' AND table_name = 'war3users'; 

Any help would be greatly appreciated, I'm all out of ideas.

--- Please enter the following information for support ---
War3ft Version: 3.0 RC8

Amxmodx Version: 1.76d

Metamod Version: v1.19p28

amxx list:

Code: Select all

Currently loaded plugins:
name               version  author            file             status   
Admin Base         1.76d    AMXX Dev Team     admin.amxx       running  
Admin Commands     1.76d    AMXX Dev Team     admincmd.amxx    running  
Admin Help         1.76d    AMXX Dev Team     adminhelp.amxx   running  
Slots Reservation  1.76d    AMXX Dev Team     adminslots.amxx  running  
Multi-Lingual Sys  1.76d    AMXX Dev Team     multilingual.am  running  
Menus Front-End    1.76d    AMXX Dev Team     menufront.amxx   running  
Commands Menu      1.76d    AMXX Dev Team     cmdmenu.amxx     running  
Players Menu       1.76d    AMXX Dev Team     plmenu.amxx      running  
Maps Menu          1.76d    AMXX Dev Team     mapsmenu.amxx    running  
Admin Chat         1.76d    AMXX Dev Team     adminchat.amxx   running  
Anti Flood         1.76d    AMXX Dev Team     antiflood.amxx   running  
Scrolling Message  1.76d    AMXX Dev Team     scrollmsg.amxx   running  
Info. Messages     1.76d    AMXX Dev Team     imessage.amxx    running  
Admin Votes        1.76d    AMXX Dev Team     adminvote.amxx   running  
NextMap            1.76d    AMXX Dev Team     nextmap.amxx     running  
Nextmap Chooser    1.76d    AMXX Dev Team     mapchooser.amxx  running  
TimeLeft           1.76d    AMXX Dev Team     timeleft.amxx    running  
Pause Plugins      1.76d    AMXX Dev Team     pausecfg.amxx    running  
Stats Configurati  1.76d    AMXX Dev Team     statscfg.amxx    running  
StatsX             1.76d    AMXX Dev Team     statsx.amxx      running  
Warcraft 3 Frozen  3.0 RC8  Geesu & Avanderi  war3ft.amxx      debug    
Admin Spectator E  1.3      KoST              admin_spec_esp.  running  
Allow round finis  1.0.2    EKS               allow_roundfini  running  
Descriptive 'Fire  0.1      VEN               descriptive_fir  running  
The Flop 10        2.1      FaNa              flop10.amxx      running  
Ghostchat          0.3      NetRipper         ghostchat.amxx   running  
Last man bets      0.9.3    JGHG              lastmanbets.amx  running  
Team Balancer      1.8b3    Ptahhotep         ptb.amxx         running  
Rush HP Bonus      1.0      KoST              rush_bonus.amxx  debug    
SpyAdmin v1        1.01     Smokey485         spyadmin.amxx    running  
Custom NextMap Ch  1.0      GHW_Chronic       GHW_Custom_Next  running  
AdminListen        2.3x     /dev/ urandom     adminlisten.amx

amxx modules:

Code: Select all

Currently loaded modules:
name                    version  author              
MySQL                   1.76b    AMX Mod X Dev Team  
Fun                     1.76     AMX Mod X Dev Team  
CStrike                 1.76     AMX Mod X Dev Team  
CSX                     1.76c    AMX Mod X Dev Team  
SQLite                  1.76b    AMX Mod X Dev Team  
Engine                  1.76     AMX Mod X Dev Team  
FakeMeta                1.76d    AMX Mod X Dev Team  

meta list:

Code: Select all

Currently running plugins:
 [  1] AMX Mod X, v1.76d, Mar 10 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  2] POD-Bot mm, v3.0B18b, Mar 19 2007, by Count Floyd & Bots United, see http://www.bots-united.com
 [  3] MySQL, v1.76b, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  4] Fun, v1.76, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  5] CStrike, v1.76, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  6] CSX, v1.76c, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  7] SQLite, v1.76b, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org/
 [  8] Engine, v1.76, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org
 [  9] FakeMeta, v1.76d, Mar  8 2007, by AMX Mod X Dev Team, see http://www.amxmodx.org

Code: Select all

[Geesu]

I've set the access rights to "all privileges" so the plugin should be able to query the database.

Unfortunately I think the problem is here - did you check per-table permissions?

[MoFFaTT]

I can only seem to find the option to set permissions to users on the database as a whole and can't find anywhere where I can set or view per table permissions.

I had a look through phpMyAdmin and I couldn't find an option for doing it through there. According to the wiki for it, there should be a "permissions" link on the main menu but I don't have the link.

Does this mean I'm going to have to set per table permissions by using sql statements? If so, I've never done that through before and a template would be great.

[MoFFaTT]

After looking around for the correct syntax I tried using this.

Code: Select all

grant all on cs167294_csstuff.* to 'cs167294_csstuff'@'8.2.122.172';

I got an "access denied for user", does this just mean I don't have the privileges required to set the required permissions?

[Geesu]

try to not use @'8.2.122.172';

Find out what the wildcard is for any host? that might be the problem

[MoFFaTT]

Still got the access denied error without the @'8.2.122.172'.

The wild card is "%". I added "%" as an access host but that still gave me the same error I originally posted about.

[Geesu]

Ahhhh it may not be working because information_schema is in another table... I'm not sure how the permissions would be changed to fix this :/

[DesasterUK]

Ahhhh it may not be working because information_schema is in another table... I'm not sure how the permissions would be changed to fix this :/

Josh?
This table/database is never been created.
So why should i change the permissions for a db that doesn't exist?