next »

[dink]

Hello there.  Dink Murphy here.   

Perk, I'm having permission probs with the ide v 0.5a. No probs connecting to the ide.  Ajaxy stuff working nicely.  However...

When trying the command line:

Access denied for user 'dink@'localhost' to database 'phpmyide'

When trying to create a view:

Error:  ANY command denied to user 'dink@localhost' for table 'preferences'

I can access any of the tables and write sql on them from the phpmyadmin pane in the ide.  My config looks ok (I think  )

Config.php

Code:

<?php

$siteHost = 'dinksite.com';
$siteURL = 'http://www.dinksite.com/ide/main.php';
$sitePort = 80;

$connections = array();
$connections[0]['name'] = 'myide';
$connections[0]['host'] = 'localhost';
$connections[0]['user'] = 'dink';
$connections[0]['password'] = 'dinksLongAndSecureGhettoStyleThingy';
$connections[0]['phpmyadmin'] = '/phpMyAdmin/index.php';

?>

Have you done something inside the core code that would impinge on permissions?

**flinking flaky coders that take their sweetheart out for dinner and music whilst their subservient slugs beat their brain out trying to make something so seemingly simple into chinese calculus.**

Ok I feel better now.

Murphy out./

[thedarkness]

Dnk,

If you can:

GRANT ALL ON 'phpmyide' TO USER 'dink@localhost';

cheers,
td

[perkiset]

Yup & thanks TD - looks like when the phpmyide DB was created the "dink" user was left out in the cold.

TD's fix should do it.

[dink]

OK guys.  I'm not in a position to do it atm, but I will.

qq:  I didn't delete the db when I upgraded.  Just deleted the tables within it.  I had the perms before.  So.....

[perkiset]

Can you run a mysql prompt from the machine where the instance is?

mysql -udink -pDinksLongAndGhettoStylePW

... you should then try some of the commands you were trying against the phpMyIDE database and see what you get.

[dink]

Nope.  Shared hosting sans shell.

I didn't change any permissions before the upgrade.  Only deleted the tables in the ide db, then ran the sql file against it.

I guess I'll roll back to the previous working version and start looking at the changes from there.

What script/rountine/operation is called when the radio button for 'view' is selected?

[perkiset]

Just checked... you must have Create View and Show View available to deal with Views... and you should have Create Temporary Tables - does <that user> have those permissions?

When you click the Views radio, I request a list of views from the system... I just looked and I don't touch any of my tables at all, so this must be a views permission problem.

The exact query I do when you click the Views button is:

select table_name from information_schema.views where table_schema='{$_POST['dbname']}' order by table_name

... so it might be a problem with the information_schema database as well. How are you doing with Triggers?

[dink]

I'll get back to you on this.

Thanks

[dink]

Just tried to log in from shop computer.  Fag.  IE pukes.  I'll get to it again later from the home Firefox box.

[perkiset]

Just tried to log in from shop computer.  Fag.  IE pukes.  I'll get to it again later from the home Firefox box.

I am hoping to have complete IE compatibility in version 0.6 Dinker, till then, FF or Safari it is.

[dink]

Alrighty.  Back to the familiar feel of Firefox.   

Logged in to my instance of phpmyide.  Everything looks good.  db's are shown in the script explorer and in the db explorer.  When I select the phpmyide db, the radio box pane shows with the procedures, functions, triggers, and views, all available.

Just on the off chance that the command prompt would let me set the perms, I entered this:

Code:

GRANT ALL ON 'phpmyide' TO USER 'dink@localhost';

Rec'd this error msg:

Fatal Error:  Call to a member function fetch_row() on a non-object in home/dink/public_html/ide/source/ajax.prompt.php on line 87

I'm off to see what the mysterious non-object is on line 87.

**edit:

Ok.  Line 87 is in the 'function handleChunk()' section.  87 is this:

Code:

while ($row = $res->fetch_row())

back later...

**edit 2:

Tried to drop a db:

Code:

drop database if exists phptest
Access denied for user 'dink'@'localhost' to database 'phptest'

Gone hunting.

[dink]

Here's a readout on the schema and privileges for this server:

Code:

  Server: localhost  -   Database: information_schema  -   Table: SCHEMA_PRIVILEGES

GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
'dink'@'localhost'  NULL    dink\_phpmyide  SELECT                NO
'dink'@'localhost' NULL dink\_phpmyide INSERT                NO
'dink'@'localhost' NULL dink\_phpmyide UPDATE               NO
'dink'@'localhost' NULL dink\_phpmyide DELETE                NO
'dink'@'localhost' NULL dink\_phpmyide CREATE                NO
'dink'@'localhost' NULL dink\_phpmyide DROP         NO
'dink'@'localhost' NULL dink\_phpmyide REFERENCES     NO
'dink'@'localhost' NULL dink\_phpmyide INDEX                 NO
'dink'@'localhost' NULL dink\_phpmyide ALTER                 NO
'dink'@'localhost' NULL dink\_phpmyide CREATE TEMP.TABLES NO
'dink'@'localhost' NULL dink\_phpmyide LOCK TABLES             NO
'dink'@'localhost' NULL dink\_phpmyide EXECUTE       NO
'dink'@'localhost' NULL dink\_phpmyide CREATE VIEW             NO
'dink'@'localhost' NULL dink\_phpmyide SHOW VIEW     NO
'dink'@'localhost'  NULL    dink\_phpmyide  CREATE ROUTINE            NO
'dink'@'localhost' NULL dink\_phpmyide ALTER ROUTINE             NO

Looks like I think it should.

What does 'IS_GRANTABLE' mean?

[thedarkness]

Dude,

Use the console or phpmyadmin to issue.

GRANT ALL ON 'phpmyide' TO USER 'dink'@'localhost';

Note the quotes, the one above was wrong.

Don't do it through phpmyide as it appears to be barfing on it.

Hopefully that will get you past this error.

Cheers,
td

[perkiset]

Code:

GRANT ALL ON 'phpmyide' TO USER 'dink@localhost';

Rec'd this error msg:

Fatal Error:  Call to a member function fetch_row() on a non-object in home/dink/public_html/ide/source/ajax.prompt.php on line 87

Nice bug catch, I'll get after that

Tried to drop a db:

Code:

drop database if exists phptest
Access denied for user 'dink'@'localhost' to database 'phptest'

You'll need more than all rights on the phpmyide database to be able to do this... I use the phpMyAdmin privileges page to make my user able to do anything to any database ... I think what you need is "Super" to be able to create and drop databases. Not sure, but that's my supposition.

I'm going to do some testing with really limited privileges and see what I get.

[dink]

Dude,

Use the console or phpmyadmin to issue.

GRANT ALL ON 'phpmyide' TO USER 'dink'@'localhost';

Note the quotes, the one above was wrong.

Don't do it through phpmyide as it appears to be barfing on it.

Hopefully that will get you past this error.

Cheers,
td

Thanks for your help, td.  Here's the response:

Error

SQL query:

GRANT ALL ON 'frank3_phpmyide' TO USER 'frank3'@'localhost'

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''dink_phpmyide' TO USER 'dink'@'localhost'' at line 1

I absolutely love those clear, direct, and easy to debug errors that mySql throws.

I'll try some other variations.

@Perk

Don't think super user is available.  However, I can create, drop, mod, whatever, on all the other db's.