The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. September 19, 2019, 02:35:19 PM

Login with username, password and session length


Pages: [1] 2
  Print  
Author Topic: What did you change in phpMyIDE 0.5a ?  (Read 8440 times)
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« on: June 04, 2008, 12:40:43 AM »

Hello there.  Dink Murphy here.   Wink

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:
Quote
Access denied for user 'dink@'localhost' to database 'phpmyide'

When trying to create a view:
Quote
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  Grin)

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./
Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
thedarkness
Lifer
*****
Offline Offline

Posts: 585



View Profile
« Reply #1 on: June 04, 2008, 03:00:31 AM »

Dnk,

If you can:

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

cheers,
td
Logged

"I want to be the guy my dog thinks I am."
 - Unknown
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #2 on: June 04, 2008, 08:55:31 AM »

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.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #3 on: June 04, 2008, 10:10:59 AM »

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.....

Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #4 on: June 04, 2008, 10:21:05 AM »

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.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #5 on: June 04, 2008, 04:04:25 PM »

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?
Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #6 on: June 04, 2008, 04:27:53 PM »

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?
« Last Edit: June 04, 2008, 04:29:24 PM by perkiset » Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #7 on: June 04, 2008, 06:02:04 PM »

I'll get back to you on this.

Thanks
Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #8 on: June 04, 2008, 08:22:39 PM »

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

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #9 on: June 04, 2008, 09:33:43 PM »

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.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #10 on: June 04, 2008, 11:27:02 PM »

Alrighty.  Back to the familiar feel of Firefox.   Grin

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:
Quote
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.

« Last Edit: June 04, 2008, 11:45:10 PM by dink » Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #11 on: June 05, 2008, 12:28:12 AM »

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?
Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
thedarkness
Lifer
*****
Offline Offline

Posts: 585



View Profile
« Reply #12 on: June 05, 2008, 02:02:01 AM »

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
Logged

"I want to be the guy my dog thinks I am."
 - Unknown
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #13 on: June 05, 2008, 09:05:15 AM »

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


Rec'd this error msg:
Quote
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.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
dink
Expert
****
Offline Offline

Posts: 349


View Profile
« Reply #14 on: June 05, 2008, 10:15:46 AM »

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:
Quote
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.
Logged

[quote Nutballs]
the universe has a giant fist, and its got enough whoop ass for everyone.
[/quote]
Pages: [1] 2
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!