next »

[dink]

A continuance from another support thread (which I made more confusing than needed done).

I'm trying to make this new ide fly on a shared host with cPanel.

Perk, I can use the phpMyide command prompt to do just about all of the requirements from your 'how to' post in the announcements forum.

One that I cannot do is create the needed database phptest.  I get an error response like so:

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

In the other support thread you mentioned that you thought a command like 'create database' would require 'super' user status.  Since I can do that via cPanel, there ought to be a way for the ide to allow it.

I'll continue to search for an answer as well.

[nutballs]

i have a feeling most shared hosting environments are going to be no-joy for this because of the permissions requirements. For example on Mosso, I cant make SPs. The permissions are very strict. I am going to see about getting elevated perms or at least SP perms. But I think with most hosts, that will never happen.

[perkiset]

Since I can do that via cPanel, there ought to be a way for the ide to allow it.

It is possible that creating a DB in cpanel *looks* like it is happening under the user dink, but in may in fact be happening via another user account specifically to lock down permissions in a way that is more manageable for them. Although I don't know this at all, it makes sense if you can't simply do a create database from the command line that the user DINK doesn't have what it takes to do that naturally in MySQL.

It sounds as though I need to bump the "don't require phpmyide" portion of my todo up a bit - my intention is to make it so that you provide a database name and a prefix, much like WP and SMF - where you DO have permissions. That'd kill this problem dead.

I'll take a look today and see what it takes to get that done for you my friend.

TTYL,
/p

[perkiset]

i have a feeling most shared hosting environments are going to be no-joy for this because of the permissions requirements. For example on Mosso, I cant make SPs. The permissions are very strict. I am going to see about getting elevated perms or at least SP perms. But I think with most hosts, that will never happen.

I think you're pretty much right, although it is more an issue of ignorance than strictly security - CRUD with SPs, functions and views is not a dangerous addition at all because the stored code can only execute what <your user account> can do. Triggers seem to be a bit different - I think you need more to attach them, and if you have that privilege, you can do it to any database/table.

As the user base goes up, I'm sure we'll find out.

[dink]

You guys may be exactly right. 
 
I can install this ide on a system where I do have root privileges, but you guys have that end covered.  And, I could avoid the current perms problem by requesting that I be allowed a 'jailed' shell on my shared hosting.

That would void what I am/was trying to make happen: Allow the 1.312 x 10^21 webmasters with mySql on shared hosting the opportunity to take advantage of SP's.

Way far too many of the smaller hosts would not allow the jailed shell.  A large percentage of the affected webmasters wouldn't know that (some) hosts do allow a jailed shell.

I think it's a worthy battle.

[manilodisan]

The only host I found so far to support mysql triggers on shared packages is at placehost.net. I hope more will come. This is probably because hosting providers wait for plesk or cpanel to support such versions of PHP/MySql and those two are moving slower than anything else. PHP 5.2.9 came out recently and a lot of bugs were fixed yet nor cpanel or plesk supports this version. Mysql releases 5.4 soon so triggers will no longer need the super user privilege to be added, but, as always, how much time will the control panels need to support it?

[perkiset]

Nice follow up and wrap, Manilo. Welcome to The Cache.