Question

I'm trying to install Fogbugz 7.2.16 on a 64-bit Debian Lenny box running MySQL 5.0.51. I've created a fogbugz system user and MySQL user, and I can connect to MySQL from the command line as both root and the fogbugz user.

When I run the installer it prompts for MySQL connection details and then fails to go any further:

Failed to create user.
Trying out connections settings.  Connecting to MySQL on
localhost as fogbugz.
Unable to connect.  Was the password correct?
Configuration did not pass muster.

In the MySQL log I get the following, so it's trying to connect to the right place but failing:

38 Connect     Access denied for user 'root'@'localhost' (using password: YES)
39 Connect     Access denied for user 'fogbugz'@'localhost' (using password: YES)

Has anybody else seen this? I've tried creating the fogbugz database before running the installer and that made no difference. Also tried specifying IP instead of socket connection, also no difference.

Answer 1

We've tried to make the install script handle a couple different situations, but it's tricky covering all the bases, so we built in an escape hatch. If you're sure you're typing the passwords correctly (first thing to check, I have to ask), the installer gives you the option to continue after the failed setup. Take that option.

After the install, edit the fogbugz/Accessories/application.data file and look for the sConnectionString line. Edit as necessary to get the user and password correct. For the server= field, you can enter a socket file name with a leading /, or a hostname or IP address.

I'd like to hear what needed changing afterwards if you get it working. If you still have trouble, please email support.

Answer 2

can you make sure that the fogbugz user has permissions from both 'localhost' and not just '%'?

mysql> grant all on fogbugz.* to fogbugzuser identified by 'fogbugzpassword';
mysql> grant all on fogbugz.* to fogbugzuser@'localhost' identified by 'fogbugzpassword';