The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. September 19, 2019, 12:10:13 AM

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Permissions seem to be a deal breaker  (Read 2003 times)
nutballs
Administrator
Lifer
*****
Offline Offline

Posts: 5627


Back in my day we had 9 planets


View Profile
« on: May 27, 2008, 10:33:45 AM »

My environment which I just tried to set this up on is the Mosso hosting service, and there seems to be some issues at the database, which i am thinking will not be able to avoided, and i think will be a problem with most shared mysql environments.

I cannot edit user permissions, so i got what I got.
I only can see the database the user is assigned to, so i cannot see a list of databases.
A user can only be assigned to 1 database.

basically, security is bolted down as much as possible.

so i think thats dead in the water for shared hosting.

The one thing i thought about what what if you instead took it all out of the database? went to the file level? then it would work anywhere, regardless of permissions? I know that probably is not where you are heading with this, but i still gotta throw it out there.
Logged

I could eat a bowl of Alphabet Soup and shit a better argument than that.
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #1 on: May 27, 2008, 10:43:55 AM »

Actually, the backup stuff and offline triggers are in a database of your choosing (they are currently bolted to a db named phpmyide, but I'm going to convert that to a table-prefix notion, like SMF and WP...) - so it could be used the way you are suggesting even though it can't be actually tied to real procedures, functions and triggers.

Clearly, if you can't access stored procedures you can't use 'em, so the IDE would be worthless I agree. And this could be the reason why they have been so slow to take off... if shared hosts don't allow you to access anything about them then very few people would understand how to use them. I wonder if a trouble ticket with Mosso would give you (at the least) CREATE ROUTINE, ALTER ROUTINE and EXECUTE on *your own database* - there's no security risk for them to give you stored procedures on your own database.
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.
nutballs
Administrator
Lifer
*****
Offline Offline

Posts: 5627


Back in my day we had 9 planets


View Profile
« Reply #2 on: May 27, 2008, 11:45:18 AM »

actually, i never tried making any SPs on this host, so you are probably right. I am going to start a ticket to find out.
Logged

I could eat a bowl of Alphabet Soup and shit a better argument than that.
Pages: [1]
  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!