SELECT command denied

[woggo_85]

Hey,

I have installed ispconfig on a master and slave. When the slave is trying to delete logs out of the table monitor_data, it recieves the error SELECT command denied.

I first thought this was due to permissions on the MySQL DB on the master server, but this did not fix it.

I have searched the forums for this issue, and did not have any luck. The full error is below. Many thanks in advancef for your help!

DB::query(DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1257238501) -> mysql_query SELECT command denied to user 'ispcsrv5'@'pop' for column 'type' in table 'monitor_data'

--julian

[till]

Must be a permission isssue. Please check if all occurences of the mysql user ispcsrv5 in the master database have delete permissions on the table monitor_data.

This is most likely a bug in the ispconfig installer if the permissions are not set correctly.

[woggo_85]

I thought it was a permission issues. On hte master server I ran the GRANT ALL ON *.* 'ispcsrv5'@'pop'; just to see if it would fix it.

No joy...

Any other ideas?

Is there any other info I can post that will assist?

[woggo_85]

I'd be happy to try more if someone could inform me how I can manually debug that user.

How would I find out what password ispconfig set for the user ispcsrv5?

[Justin Albstmeijer]

Same issue here after upgrading from 3.0.1.4 to 3.0.1.6.. I suddenly got warnings for the servers on the ispconfig monitor.

DB::query(DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1258240203) -> mysql_query SELECT command denied to user 'ispconfig'@'server.bla.com' for column 'type' in table 'monitor_data'

trying to do a select from such server:

select * from monitor_data WHERE type ='sys_log';

I get

ERROR 1142 (42000): SELECT command denied to user 'ispconfig'@'server.bla.com' for table 'monitor_data'

should their not be a server_id id filter btw?

[till]

Hello Justin, the poster before you has a multiserver setup while your setup is a single server setup according to the sql queries and mysql users you posted. single and multiserver setups use a completely different user setup in mysql, so your problem must be a different problem.

Please check that the passwords in the config.inc.php files for the user ispconfig on your server are correct.

@woggo_85

The select permission was missing in the grant statement in the installer. This has been fixed in svn already. Please add the select privelige for all ispcsrv* in the master database for the monitor_data table and reload the priveliges or restart mysal on the master.

[Justin Albstmeijer]

Hello Till,

I do have a multi-server setup too.
The usename 'ispconfig' might be confusing compared to a ispcsrv* one, as it was set manually during the trancission from a single to multiserver setup in the past.


Is there still something in the sql statement besides the user, that indicates to you that this is not a multi-server setup?

If I understand correctly

UPDATE `mysql`.`tables_priv` SET `Timestamp` = NOW( ) , `Table_priv` = 'Select,Insert,Delete' WHERE `tables_priv`.`Host` = 'SERVERNAME' AND `tables_priv`.`Db` = 'dbispconfig' AND `tables_priv`.`User` = 'USER' AND `tables_priv`.`Table_name` = 'monitor_data' LIMIT 1 ;
flush privileges;

Where SEVERNAME and USER are replaced with the correct values of course

should fix it for me?

Justin