[HCoop-Help] Drupal blues

[docelic]

On Fri, Apr 04, 2008 at 04:17:22PM +0530, Tanveer Singh wrote:
> 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 .
> >
> >  -doc
> thanks doc,
> If I use psql(drupal has support for both), in that case also I have
> to do this jugglery?

No, postgres drops tables without any problems.

-doc


_______________________________________________
HCoop-Help mailing list
HCoop-Help at lists.hcoop.net
https://lists.hcoop.net/listinfo/hcoop-help