UseBB Community

Hello everyone,

I have some problems to know what to do besides browsing to./install/index.php, filling in the forms and pushing a few buttons.

So far I have done the following:
1) renamed config.php and chmodded it to 0777
2) created a user account in MySQL for the forumuser
3) created a table in MySQL

After filling in the first page of the wizzard I get:

In file db_mysql.php on line 86:

E_WARNING - mysql_connect(): Lost connection to MySQL server during query

And I don't know how to get around this (except maybe by using the installation method by hand .

I'm not sure about the following things:
1) Are table-prefixes fully supported?
I ask this because the manual installation seems to fix this to usebb_.
2) What privileges does the MySQL user need for proper installation?
At this moment the user has the following privileges:
- Select, Insert, Update for Data
- Create, Alter for Structure.
3) Do I have to prepare anything else for the Wizzard?

I'm using the following versions:

UseBB 0.7
MySQL 4.0.2
PHP 4.3.10-15

Many thanks in advance,

Joris

There is a known problem in 0.7 with table prefixes, but to my knowledge only in the ACP. This will be fixed in the next release.

About the privileges, you will also need DELETE for the forum to work. Although I suspect there's another problem with your database server.

Hi Dietrich,

Thanks for getting back to me.

I've toyed around a bit by using several settings etc, and now it works smoothly.

Although the MySQL-server is installed fine (we use it for other things as well), some other settings might have been wrong:
- as host: % (any host) instead of just localhost
- privileges: now the usebbuser has all privileges on the usebb database

The table prefixes seem to work nice through the installer.

Many thanks,

Joris

Hi Dietrich,

I justed wanted to let you know, after spending a few hours hours on looking into it, that it seems that the wizzard automatically filters out some characters of the passwords being used (I'm only sure about the dollar sign).

It would be nice if you (or someone else) document it somewhere. This would save other people's time into looking into this kind of weirdness.

Greets,

Joris

The MySQL access rights seem to be fine, although allow host % is not really neccessary when the SQL server is on the same machine as the HTTP server and you don't want to access the server from somewhere else.

About what password are you talking? User account passwords can only contain alphanumeric characters, spaces, _ and -.

Hi Dietrich,

I have set it up now only using 'localhost' and it works fine!

I meant the password for making the connection with MySQL. MySQL is more flexible in terms of characters it accepts and if I change the config.php myself is also possible to use that kind of characters to connect to MySQL.

However using the Installation Wizzard, these characters get filtered out (probably it uses the same filter as the one for passwords for useraccounts of UseBB itself) although in my opinion it shouldn't (or otherwise be documented regardless being a 0.x release).

Joris