Re: error 1142 can't solve 14 Years, 9 Months ago
|
Karma: 1
|
I'm afraid I'm confused.
My host, Host Gator, tells me they can't give me permissions on my Reseller account. That I have to get a VPS account or Dedicated Server. So, why was I able to create 15 slave sites in the past 3 weeks with no errors?
My other confusion is why I can create slave sites from a different template with no errors, but get errors from another?
Who am I to believe? I don't even know which way is up right now. Does anyone have a suggestion on hosts that support the permissions this JMS Multisites requires? I need to switch. I would like it to be a reseller shared account as I don't want to pay through the nose.
Buddy
|
|
buddyq
Expert Boarder
Posts: 106
|
|
|
Re: error 1142 can't solve 14 Years, 9 Months ago
|
Karma: 54
|
HostGator can give you the permission.
They provided us the permission on a "baby" account.
I don't see the reason why they would reject that with a more powerfull account.
Concerning the reason you have an error is because you try to share extensions.
You can replicate website without sharing.
As soon as you want share extension, you need MySQL privileges.
|
|
|
Last Edit: 2010/03/08 09:52 By edwin2win.
|
|
Re: error 1142 can't solve 14 Years, 9 Months ago
|
Karma: 1
|
This was Host Gators response to me this morning:
I can't see the grant table settings from 3 weeks ago. So I can't authoratatively answer why it worked then.
The root problem however is that mysql does not know what cpanel accounts are owned by which resellers.
What this means is that if I give permission for your mysql username to create mysql databases and edit mysql permissions for any database on the system, then it includes every database for every other customer as well.
As I am sure you can understand giving you that level of access is something we can never allow. I am sure you would never want me to give another customer who shares the server with you access to any of your databases.
This is why to do things the way you want to do them, you are going to need to move to a vps server.
Have a great day.
=========================
So, my instructions to them were that my mysql user gottesma_buddyq needs to have CREATE VIEWS and SHOW VIEWS permissions.
What should I tell them next? Maybe I am not telling them the right thing?
|
|
buddyq
Expert Boarder
Posts: 106
|
|
|
Re: error 1142 can't solve 14 Years, 9 Months ago
|
Karma: 54
|
Create and show view is totally independent on the privileges to create DB dynmically.
The answer of Hostgator correspond the the grant to create DB and not to the privileges to grant the "create and show views" that does not concern the "create DB".
In your case, you have to create the DB manually and use a MySQL user that authorize to share tables (create and show views).
Their reply concern the "create Dataabase" and NOT the "create and show views".
|
|
|
|
|
Re: error 1142 can't solve 14 Years, 9 Months ago
|
Karma: 1
|
I told them your answer and they gave me the proper permissions it seems.
|
|
buddyq
Expert Boarder
Posts: 106
|
|
|
|