MyBB Community Forums

Hi

Im having problems with the Table Creation section of the installer.

After putting in all DB details I get the following:

---

Table Creation

Connection to the database server and table you specified was successful.

Database Engine: MySQL Improved 5.0.32

The MyBB database tables will now be created.

--


It just sits there indefinitely after that.

Ive seen similar threads highlighting the same issue but no resolution in them besides saying the installer was corrupted.

Ive attempted the following steps:

1.) Multiple redownloads of the .zip and .tar.gz
343717ea4d41df206e22de11a2514e78 mybb_1211.tar.gz
fcba4c6abded0c999a94a702a213bc88 mybb_1211.zip

2.) Connected manually from WWW server to DB server using commandline mysql (and created tables) successfully.

3.) Change Database Engine type from MySQL to MySQL Improved (and vice versa)

4.) Ran tcpdump to check that there was communication between webserver and db machines (there was)

5.) Obtained the following from mysql logs

080114 16:00:41 8 Connect [email protected] on
8 Init DB 4r_forum
8 Query SET NAMES 'utf8'
8 Query SELECT VERSION() as version
8 Query DROP TABLE IF EXISTS mybb_adminlog
9 Connect [email protected] on
9 Init DB 4r_forum
9 Query SET NAMES 'utf8'
8 Quit
9 Quit

No further input received while waiting for tables to be created.

6.) Checked that I had xml support in php (used phpinfo page)


I havent been able to get any further than the above (run out of time)

As an independant test to make sure my apache/php/db are setup properly I successfully installed phpBB3 using the same webserver/url/db so Im pretty sure that side is ok.

Please can someone shed some light on what could possibly be causing this

Thanks in advance.

Ahh!

Tried something different

Creating a user on the DB like this DIDNT work:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER ON 4r_forum.* TO '4r_forum'@'72.xxx.xxx.xxx' IDENTIFIED BY 'sdfsdfsdf';

Creating a user on the DB with full access DID work:

GRANT ALL ON 4r_forum.* TO '4r_forum'@'srv2.xx.xx.xx' IDENTIFIED BY 'sdfasdfasdf';

Please be aware that something the insertion process is doing requires more than the standard set of permissions some web hosts give their clients. I'll try figure out what it is when I have some more time.

Thx for reading

Its the DROP privilege

The installer tries to DROP the tables before it CREATES them (this is good practice actually )

Make sure ure db user has at least the following permissions

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER,DROP

Its been fun talking to myself.. hope this helps others who have the same problem!

I'm sure this will help...
every and every post saved here for future searches for details and support
thanks for sharing with us!

I've always wondered how to do this, thanks.

you'll need "REPLACE" too for the permissions