FUDforum: FUDforum Installation Issues » Step 2: MySQL temporary table creation denied

Home » FUDforum » FUDforum Installation Issues » Step 2: MySQL temporary table creation denied

Show: Today's Messages :: Polls :: Message Navigator

Step 2: MySQL temporary table creation denied [message #20797]

Thu, 28 October 2004 22:51

dadij

Messages: 9
Registered: October 2004

Karma: 0

Junior Member

When I hit the Next button in installation step 2 I get:

FATAL ERROR: your MySQL account does not have permissions to create temporary tables.
Enable this functionality and restart the script.

It looks like this error message comes from lines 160-162 in install.php when it tries to execute the following SQL statement:

CREATE TEMPORARY TABLE fud_forum_install_test_table (test_val INT)

I copied that statement into PHPMyAdmin and tried it there and it seems to be executed without an error:

Your SQL-query has been executed successfully (Query took 0.0026 sec)

I could not find anything about this problem in the forums.

FUDforum v2.6.8 Release Candidate #1
MySQL 4.0.18.
PHP Version 4.3.6
safe_mode off

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20798 is a reply to message #20797]

Thu, 28 October 2004 23:15

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

When you tried that query via phpmyadmin were you using the same user /database that you specified to the forum?

FUDforum Core Developer

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20800 is a reply to message #20798]

Thu, 28 October 2004 23:34

dadij

Messages: 9
Registered: October 2004

Karma: 0

Junior Member

Yes, it was the same database and user (I only have one user defined).

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20805 is a reply to message #20800]

Fri, 29 October 2004 03:32

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Can you open the install.php script and inside the
if (!mysql_query("CREATE TEMPORARY TABLE fud_forum_install_test_table (test_val INT)")) {

add var_dump(mysql_error());

FUDforum Core Developer

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20822 is a reply to message #20805]

Fri, 29 October 2004 12:45

dadij

Messages: 9
Registered: October 2004

Karma: 0

Junior Member

var_dump(mysql_error()) gives:

string(94) "Access denied for user: 'myusername(at)localhost(dot)localdomain' to database 'my_-_database'"

This is interesting as some operations on the database have already been performed without error in the script before it comes to testing for temporary tables. And maybe the problem has nothing to do with the temporary tables, just the login??

For comparison this is what phpmyadmin says when I use the wrong password:

#1045 - Access denied for user: 'myusername@localhost' (Using password: YES)

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20824 is a reply to message #20822]

Fri, 29 October 2004 12:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It is very likely your SQL permissions are HOST limited, so myusername@localhost has permisssion and myusername(at)localhost(dot)localdomain does.

The fix is to either connect to MySQL via unix domain socket which is the same as localhost or to allow localhost.localdomain full access to your database.

FUDforum Core Developer

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20863 is a reply to message #20824]

Sun, 31 October 2004 10:39

dadij

Messages: 9
Registered: October 2004

Karma: 0

Junior Member

My host only allows 1 user to be defined. I changed the host to 'localhost', but then I got an error on the LOCK TABLES test in install.php.

I found this conversation in the forums:

User: "Would it be possible to add LOCK to the list of allowed actions on the mySQL server?"

Host: "This is a global privilege and therefore is something that we cannot allow mysql users in a shared environment access to. Sorry."

So the question seems to be if FUDforum can be set up, or easily modified, so that LOCK TABLES is not needed, or only needed under certain conditions that I would be able to control? Or am I asking the wrong question here?

Report message to a moderator

Re: Step 2: MySQL temporary table creation denied [message #20869 is a reply to message #20863]

Sun, 31 October 2004 18:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Your host is wrong, LOCK is a per database/user setting with no impact on other users on the system.

FUDforum uses locking to ensure data consistency and without lock it will simply not work.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	nntp.php
Next Topic:	[Error Message] Notice: Undefined index:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 15:57:08 GMT 2024

Total time taken to generate the page: 0.03467 seconds