You are not authorized to execute SQL queries

[PAKIDIL]

Can any 1 please tell me why i m having this error ? when every i click on execute sql queires option its shows "

"You are not authorized to execute SQL queries "

instead of login box so can any 1 please help me out in this thanks.

[HMBeaty]

You need to edit your includes/config.php file here:

PHP Code:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = ''; 


[washingtonboise]

After doing so, I get the same message.

$config['SpecialUsers']['canrunqueries'] = '1,3';

It doesn't matter if I log in as user 1, or user 3.

Is there a plan B for what to check when this happens?

[AMcDermott]

Originally Posted by washingtonboise

After doing so, I get the same message.

$config['SpecialUsers']['canrunqueries'] = '1,3';

It doesn't matter if I log in as user 1, or user 3.

Is there a plan B for what to check when this happens?

I've got the same issue - still getting "not authorized" message when 'canrunqueries' has my admin userid there. What should I check next?

[kh99]

If that's a "not authorized to do queries" specific message, the the only time that should happen is if the userid is not listed in $config['SpecialUsers']['canrunqueries']. We use APC for caching and I know we need to clear the cache before changes to php files will work, do you have something like that?

[AMcDermott]

Originally Posted by kh99

If that's a "not authorized to do queries" specific message, the the only time that should happen is if the userid is not listed in $config['SpecialUsers']['canrunqueries']. We use APC for caching and I know we need to clear the cache before changes to php files will work, do you have something like that?

Thanks for the reply, much appreciated.

Yes, the error is "Not authorized to execute SQL queries".

My userid is in $vbbinstallroot/includes/config.php like so, 5201 being my userid on this forum:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '5201';

The error message appears at the following location:

hxxp://forums.domain.com/admincp/queries.php?do=modify

I've tried an APC cache clearing script, server doesn't seem to be running APC.

Is there anything else it could be?

Edit: config file encoding seems ok, ANSI and it's obviously getting parsed correctly or VBB just wouldn't run, right?

[Brandon Sheley]

Do you need to be a "super user" as well
TBH, adding your userID to that line should work, it's always worked for me.
Are you sure that's your userID?

[AMcDermott]

I'm pretty sure the userid is correct. From AdminCP - User Manager:

User: username (id: 5201)

What's the "super user" thing?

Here's what my user looks like in admincp:

[kh99]

I was going by what I saw in the code, but just to make sure I did a test and it seems that if a userid is an admin and is listed in the config.php file, the user can execute queries even if they have no other admin permissions and are not a superadmin. (They don't see the Maintenance menu at all if they don't have that admin permission, but it doesn't stop them from going directly to admincp/queries.php).

Anyway, what you posted above looks right, and you're right, if there was any error in the config.php you'd know it. So triple check the userid as Brandon suggested, and maybe make sure that you're actually changing the correct config.php file (if you're uploading it after editing, did you upload it to the right place)? Edit: ...and did the file get overwritten successfully?

[AMcDermott]

Ok, couple of issues here... firstly the VBB version is v4.1.7 - not v3.x - the config file references vBulletin 3.6.8.

Secondly, I'm not editing the right file. The one I'm editing is not effecting the live site.

Assuming this is question is still relevant, how can I work my way from the webroot to finding where the config file is actually located? Can I trace it from file to file?

Thanks for your help in any event!

--------------- Added [DATE]1350579681[/DATE] at [TIME]1350579681[/TIME] ---------------

And the conclusion thus far is that the FTP user is incorrect - this is an old mirror of the existing site, fully installed but not connected to live site in any way. Killer.

--------------- Added [DATE]1350580292[/DATE] at [TIME]1350580292[/TIME] ---------------

And final update: success, after receiving the correct FTP info from the site owner.

Thanks, kh99 and Brandon Sheley, for your help with this.