Installation woes

[Adrian Nabarro]

Hi there

I've been trying to get SugarCRM CE running on a CentOS box for most of the day with little luck. I started off installing 6.4.0RC3 and run into the issues list below, so then tried 6.3.10 with the same issues.

I get up to the "Database Configuration" screen before the system either says the username and password is not correct (it is, I'm able to connect via the CLI using the same credentials) or "stuck" on the "Verifying DB Credentials" stage.

There doesn't appear to be any issues relating to this in the apache logs.

Any help would be greatly appreciated!

Thanks
Adrian

[Adrian Nabarro]

Could it have something to do with the way mysql is configured?

Is 'localhost' to sugar different to 'localhost' to mysql?

I really can't figure this out!

[Adrian Nabarro]

Looks like I've got it sorted. I'm posting this here just in case it helps anyone else.

Looks like it was an issue with the root user.

Creating a separate user with all privileges on the database seemed to do the trick.

mysql> grant usage on *.* to sugarcrm@localhost identified by ‘yourpassword’;

mysql> grant all privileges on sugarcrm.* to sugarcrm@localhost ;

[Chris_C]

Assuming you have mysql installed on the same linux machine as Apache/PHP/Sugar, then yes, localhost refers to the local machine address, and you would put localhost as the address of the database machine, in the Sugar installer.

Is it a shared hosting account?

If yes - check your database username -

It's usually a hybrid of your share hosting account name + the username you selected for the database user.

For example, if your shared hosting account name is adrian, and you made a database user called sugaruser....

....then the CentOS shared hosting control panel will usually make you a mysql database username of adrian_sugaruser

Post back with your progress, or your solution !

[Angel]

In addition to Chris suggestions/comments, try using 127.0.0.1.

As odd as it may sound, I have some situations where the IP will work, but 'localhost' won't.

[morrighu]

As a matter of good practice, you should create the user both ways - with @'localhost' and @'127.0.0.1'