Error at Step 7 Install Gallery Core

RV4

Joined: 2004-09-22
Posts: 22
Posted: Thu, 2004-12-16 17:00

Error (ERROR_STORAGE_FAILURE) :

Attached txt file of Stack trace and Debug Output.

Thanks for your help.

AttachmentSize
error.txt8.93 KB
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2004-12-16 18:36
Quote:
mysql error: [1142: create command denied to user:
'sureshot@dbase.digitronicweb.com' for table 'g2_schema']

your db user needs to be able to create tables.

 
RV4

Joined: 2004-09-22
Posts: 22
Posted: Thu, 2004-12-16 18:56

Contacted my server host regarding this and this is the answer:

Quote:
Due to security concerns the creation of tables in the
MySQL database is limited to our systems administrator.

please create an SQL command file that will create the tables you want. Upload that file to your site and respond to this email with the path to it. We will check the file and run it for you

SO, my question now becomes, is there a way to access the SQL command file within galley, extract it and have the administrators run it, and then by-pass that section on G2 install? OR, some other way around the inability to run the install with MySQL create command disabled from my host?

Thanks

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2004-12-17 05:48

Oy. We generate the SQL files based on the information you enter into config.php, at install time. We *could* output the SQL files for you, but it hasn't been a high priority for us :-( Would you file this as an RFE for us? Thanks...

 
RV4

Joined: 2004-09-22
Posts: 22
Posted: Fri, 2004-12-17 12:52

bhrat, Thanks for your reply, I would gladly file this as an a "RFE" for you, if I kew what an RFE was, I am guessing "Request For **something**", please advise along with how and where to file and I will gladly do so.

Sorry for my ignorance, but I am willing to learn at all times!

 
CSpotkill

Joined: 2004-12-11
Posts: 113
Posted: Fri, 2004-12-17 14:10

It's okay, RV4. I didn't know either, three days ago. It's a Request For Enhancement, a fancy term SourceForge uses for what is essentially a feature wishlist. Gallery's RFE list is right here: http://sourceforge.net/tracker/?group_id=7130&atid=357130

Read a few RFEs first, to get an idea of what its all about ;)

 
RV4

Joined: 2004-09-22
Posts: 22
Posted: Sat, 2004-12-18 13:49

Thank You, I submitted the RFE as requested.

One might ask, "how come this problem has not happened to RV4 before".

Interesting enough, I was able to send the "install.sql" file from the Jenado Cart to my host system administrators which I added to G1, and they created the MySQL table for me.

I am now requesting information on hosting services that allow user to create and manipulate MySQL tables. In addition, I would like to have Miva Merchant installed on the serve I place my G2 on. Any hosting suggestions would be great.

Basically I either have to send the MySQL create command to my current host server admintrators, or move my site a host that is not so restrictive, or just let everyone else enjoy the fun of G2 while I sit on the side-lines.

 
virshu
virshu's picture

Joined: 2003-09-13
Posts: 314
Posted: Sat, 2004-12-18 16:14
RV4 wrote:
I either have to send the MySQL create command to my current host server admintrators, or move my site a host that is not so restrictive, or just let everyone else enjoy the fun of G2 while I sit on the side-lines.

I would choose the second option (move to another host). :evil: I am not going to mention my host by name (I can send you a PM if you want or check whois for www.rabinovich.org) - but I've been with them for a year now; $6/mo for 1GB of storage / 15MB of bandwidth and everything that you can think of in terms of DB, languages, etc. The idea of imposing crippling limitations in the name of security is just unaccepatble (and we didn't have any security breaches as far as I can say). A good host can maintain both security and functionality!

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Sat, 2004-12-18 22:16

Most other web apps don't allow you to customize the way that you create the tables like Gallery does, so they have static SQL files. But since we want you to be able to squeeze G2 into any database configuration, we allow you to set your own table and column prefix, which means our readymade SQL files require a little post-processing in order to be useable.

This is going to be a problem for you because G2 requires the ability to create new tables whenever you install or upgrade a module, and you can do that at any time .. not just at installation time.

I'd be really curious to hear what security concerns that your ISP has. MySQL has a sophisticated permission system and if they give you your own database (which is the way to make it secure) then there shouldn't be a problem with letting you create your own tables. Perhaps they're using a half-baked security scheme where they make you and a bunch of other users share the same database and don't tell you about the other users' tables (don't laugh -- I've seen ISPs that do this! fear!)

 
virshu
virshu's picture

Joined: 2003-09-13
Posts: 314
Posted: Sat, 2004-12-18 23:45
bharat wrote:
I'd be really curious to hear what security concerns that your ISP has. MySQL has a sophisticated permission system and if they give you your own database (which is the way to make it secure) then there shouldn't be a problem with letting you create your own tables. Perhaps they're using a half-baked security scheme where they make you and a bunch of other users share the same database and don't tell you about the other users' tables (don't laugh -- I've seen ISPs that do this! fear!)

I don't think it's about security... I looked at their site - they are charging $3/month extra for the database. It's probably their billing system forces them to cram everyone on the same database! So, it's $7/mo for 400MB, and $3/mo for every database (+$20 additional setup fee just for the database if I read correctly). And on top of that - there is $30 setup fee; so they pretty much have you by the privates :evil: And this all from a company that is not even mentioned on WebHostingTalk - how on earth you found them in the first place :evil:

I realize, it's off-topic, but Bharat - it's not funny; it's pathetic, and it gives hosting industry bad name! </rant>

 
RV4

Joined: 2004-09-22
Posts: 22
Posted: Sun, 2004-12-19 20:54

I sent the host service an e-mail requesting their "security concerns". I think you are correct in that they are really cramming everyone into one DB.

I pay for a DB, I pay for a set-up fee., and I cannot use the DB.

In fact, 60% of the time, G1 using the Jenado Cart does not succeed in making an entry into the DB. However, sometimes it appears to recall data.

I will wait for a reply, and then seek a refund.

As for the other web hosting suggestions you have, I also need the ability to run Miva Merchant with a secured socket to accept Credit Card payments, and would prefer a host that pre-installs that software.

Thank each of you for time and reponses.