Hi everyone,

I am having trouble with the database connection / authentication. This occurred with previous builds already.

Installation went just fine and I was able to upload my guild data successfully, but when trying to install a first addon like "Memberlist", I am getting a databse error saying

Code: Select all

1044: Access denied for user 'dbuser'@'localhost' to database 'dbname'

(where dbuser and dbname exactly match the correct values)

Without posting the full lot, this is what it fails at:

Code: Select all

SQL:
CREATE TEMPORARY TABLE `backup_roster_addon_config` LIKE `roster_addon_config`
File: lib/dbal/mysql.php
Line: 202

Some info on the system:

Code: Select all

Basic Server Info
OS Linux
Server Software NOYB
MySQL Version 4.1.22-max-log

I checked the db and it seems to populate the roster_addon table correctly, but fails when it comes to roster_addon_config. I am using the German locale (if that matters).

When going back to the addon config after that, I got a green box indicating a successful install, when I repeat that for the activation bit, it also shows "green", but I actually never managed to see the memberlist yet.

I don't see a "user error" here, because I just provided the db login data once and the installation went right - so it's obviously the correct dbuser/pass information. But I can't figure what the problem is.

Kind regards,
Tweetor

The db user needs create temp table permissions.

Temp tables are needed so when an addons fails to install correctly, the roster_addon_config table can be restored.

We are working on a way to not have to use temp tables, but it probably will be awhile before it's in the beta.

Okay, thanks zanix!

I contacted my webhoster and asked whether they could allow permissions for temp tables, but unfortunately that doesn't seem to be possible with my web-package.

Anyway, at least I know what's causing that issue and will stick with good old roster 1.7.2 for the time being! :-)

Kind regards,
Tweetor

Similar problem to the one tweetor was having, only my error message seems to indicate an incorrect hostname of '%', and not the correct external host that I used when installing. Is this likely the problem, or does this percentage symbol always show up when not using 'localhost'? Main install seemed to go okay, but no addons will install without this message appearing. Values for dbuser and dbname are the correct ones. Also, the correct host name does appear in the conf.php file (on the line that begins $db_config['host']).

Server info:
OS Linux
Server Software Apache
MySQL Version 5.0.45-Debian_1-log
PHP SettingsPHP Version 5.2.3
PHP API Type apache2handler

Please advise - thanks!