CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • "Unable to create temporary tables." preventing install
Pages: [1]

Author Topic: "Unable to create temporary tables." preventing install  (Read 8807 times)

Elfreda

  • Guest
"Unable to create temporary tables." preventing install
September 28, 2008, 04:52:55 am
Hello,
I have created a sandbox installation so that I could see if CiviCRM would be suitable for our organization.
I have installed the latest xampp on ubuntu 8.04 installed on VirtualBox and then got drupal 6.4 working. I have followed the steps for installing CiviCRM 2.1.beta6. I resolved a couple of issues (changed InnoDB settings and memory allocation) The last problem is that the installer says that the user specified does not have permission to create temporary tables. I have checked this setting in phpadmin and the user has all privileges for everything.
I'm not sure what else to check.
Thanks for any help/suggestions,
Elfreda

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: "Unable to create temporary tables." preventing install
September 29, 2008, 04:54:35 am
Phpmyadmin has menus to choose which database the users permissions are related to.
Did you look at the settings for the right user?
And is this the user the script is trying to make the database with?
Can you try it at the command line as well?
mysql -u root -ppassword

then
create database;
or create other type of table etc?

Elfreda

  • Guest
Re: "Unable to create temporary tables." preventing install
September 29, 2008, 07:29:41 am
Thanks for the answer.
I have tried using both the user I created (has 'all privileges' showing in phpmyadmin) and 'root' to run the install script. I can see the checkbox ticked for 'create temporary tables' for my user. I had also granted my user rights to the drupal database explicitly.
I logged in as my user and as root at the command line and created databases and temporary tables without errors.
I'm not sure what to try next except for a re-install.

Elfreda

  • Guest
Re: "Unable to create temporary tables." preventing install
September 29, 2008, 12:05:19 pm
Yay! I got it installed. I had to manually create the civicrm database first.

The instructions state
Quote
The installer will create a new database for CiviCRM automatically if you enter a database name that doesn't already exist on your database server AND the database user you enter has permission to create databases.
Both the conditions were satisfied so this fix didn't occur to me right away. So, just a little glitch.

It looks interesting--I'm really looking forward to playing with this!

sypl

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Re: "Unable to create temporary tables." preventing install
October 05, 2008, 05:14:41 am
Quote from: Elfreda on September 29, 2008, 12:05:19 pm
Yay! I got it installed. I had to manually create the civicrm database first.

Do you mean you created the database manually via a command line? Or is there another way to grant the 'CREATE TEMPORARY TABLE' permission?

Elfreda

  • Guest
Re: "Unable to create temporary tables." preventing install
October 05, 2008, 07:02:22 am
I tried creating databases and temporary tables using the 'root' login and the user id that I had created from the mysql command line as alfred_nutile had suggested to try to track down the problem. Then I decided to create the empty civicrm database before trying to run the install script again. I created the database using phpmyadmin and double-checked that my user had full permissions. I think the glitch might have been that the script was testing if the user had the permission to create temporary tables on a non-existant table.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: "Unable to create temporary tables." preventing install
October 05, 2008, 12:25:42 pm

i assume u mean a non-existent database

I just checked the code and seems like we dont do the right thing if the db does not exist (which matches the behavior u get). Can you please file an issue for this. We'll fix this in the 2.2 installer.

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Elfreda

  • Guest
Re: "Unable to create temporary tables." preventing install
October 05, 2008, 01:29:02 pm
Yes, non-existent database.
Thanks for the reply--I wasn't sure about filing an issue or not.
elfreda

BrightBold

  • Guest
Re: "Unable to create temporary tables." preventing install
October 18, 2008, 07:24:09 am
Thanks for this thread! I was having trouble eliminating all the barriers to installation (I'm new to both Linux and server admin so dealing with all the permissions problems isn't yet second nature), but creating the database manually before installation has solved the problem.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • "Unable to create temporary tables." preventing install

This forum was archived on 2017-11-26.