Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th November 2009, 11:54
woggo_85 woggo_85 is offline
Junior Member
 
Join Date: Nov 2009
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default SELECT command denied

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
Reply With Quote
Sponsored Links
  #2  
Old 5th November 2009, 17:34
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th November 2009, 22:27
woggo_85 woggo_85 is offline
Junior Member
 
Join Date: Nov 2009
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #4  
Old 6th November 2009, 07:13
woggo_85 woggo_85 is offline
Junior Member
 
Join Date: Nov 2009
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #5  
Old 15th November 2009, 00:36
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 74
Thanks: 1
Thanked 5 Times in 5 Posts
Default

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?
Reply With Quote
  #6  
Old 15th November 2009, 10:22
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 15th November 2009, 15:58
Justin Albstmeijer Justin Albstmeijer is offline
Member
 
Join Date: Dec 2007
Posts: 74
Thanks: 1
Thanked 5 Times in 5 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix: "unknown user" with mysql auth. Kruser Server Operation 3 18th June 2009 18:20
ISPconfig 3, dropmail issue Justin Albstmeijer Developers' Forum 10 6th October 2008 21:21
Rejected e-mail (unknown user) w/Postfix doronkeller HOWTO-Related Questions 9 27th January 2008 20:09
Problems with the Virtual Users And Domains With Postfix, Courier And MySQL tutorial wwinfrey HOWTO-Related Questions 12 15th August 2006 16:38
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 04:19


All times are GMT +2. The time now is 02:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.