Pesky [1045] error

[Gardner Treneman]

I've struggled and won up to this point, but now I'm hitting a wall. I've got the server up and running but I can't get the sumaserver/admin to work with the things I've setup.

I can login with the sumaserver admin account, but then I get this error:

SQLSTATE[HY000] [1045] Access denied for user 'suma_user'@'localhost' (using password: YES

suma_user is the application account I setup in mysql.

All the correct privileges are there (I even tried GRANT ALL), the database is there and initialized.

The config file I have looks like this:

sumaserver:

  db:

    host: localhost

    platform: Pdo_Mysql

    dbname: floor_count

    user: suma_user

    pword: ***********

    port: 3306

**If I set the user as root in the config.yaml file - it works. (but I won't be using that)

The log file just shows the same thing as the [1045] error - that's it.

I tried clearing caches and restarting apache, mysql and php.

**I'm also getting a 500 Server Error when I try to Edit Locations - but one problem at a time.

Please - can anyone help me with this?

[Jason Casden]

I have run into something similar in the past. Unfortunately, I believe this is a MySQL configuration issue rather than a Suma issue. I recommend doing your diagnostic work outside of Suma, with the mysql command line tool on the same server. Try something like:

mysql -h localhost -u suma_user -p floor_count

This should prompt you for the password. If you are able to connect this way, then maybe it does have something to do with Suma. When I've seen this in the past, it's sometimes had something to do with mismatched hosts (e.g. the user specifies localhost but the server sees something else) or incomplete database permissions. I would also see if there is anything useful in the MySQL log.

Best,

Jason

--
You received this message because you are subscribed to the Google Groups "Suma: mobile library assessment toolkit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to suma-mobile-library-asses...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/suma-mobile-library-assessment-toolkit/1aa58fd2-b508-466c-8472-69652b55b57dn%40googlegroups.com.