[HCoop-Help] Drupal blues
tanveer1979 at gmail.com
Fri Apr 4 06:47:22 EDT 2008
On Fri, Apr 4, 2008 at 3:51 PM, docelic <docelic at mire.hcoop.net> wrote:
> On Fri, Apr 04, 2008 at 12:53:04PM +0530, Tanveer Singh wrote:
> > Hi,
> > I am trying to install drupal again today.
> > In the installation stage it tries create table/drop table etc., on
> > the database I created (tanveer_databasename).
> > It fails at that step.
> > Somehow my daemon user is not able to create or drop tables on this
> > particular database which I created with dbtool mysql createdb
> > Is somebody else also facing similar problems?
> > I was able to install another cms easily yesterday and no such issues
> > came at all
> > this is the error message
> > Failed to drop a test table from your MySQL database server. We tried
> > dropping a table with the command DROP TABLE drupal_install_test and
> > MySQL reported the following error DROP command denied to user
> > 'tanveer'@'mire.hcoop.net' for table 'drupal_install_test'.
> Yes, for security reasons (and MySQL shortcomings), we are not able to
> grant DROP privilege in advance. The problem is that we cannot grant
> DROP DATABASE privilege, and MySQL has no way of saying "allow drop on
> tables but not on the database". (The syntax DBNAME.* enables both
> tables and database drop).
> We have a workaround, though. The solution is to create your MySQL database
> and tables in there, and then run command mysql-fixperms. That will give
> you permission to drop all tables that are currently in your database,
> and then your drupal's script will work without problems.
> If the script is trying to DROP tables on its first run (i.e. the script
> uses a combination of DROP+CREATE instead of just CREATE), then the
> solution is to either remove the DROP statements, or to manually create
> the tables (just like: "create table TBLNAME (int a)" for each table) and
> then run mysql-fixperms .
If I use psql(drupal has support for both), in that case also I have
to do this jugglery?
HCoop-Help mailing list
HCoop-Help at lists.hcoop.net
More information about the HCoop-Help