TimeTrex Time and Attendance

hello I am trying to complete TimeTrex Community Edition installation. Im currently on Rocky Linux 8 and I am getting the "Connection test to your database as a non-privileged user has Failed. i have created users with roles in Postgres but still unable to connect. Can anyone help me figure out what I am doing wrong. I have tried creating multiple users in postgres and even gave them superuser role but still cannot connect to database during install. any help in the right direction would be appreciated.

Either your username/password is incorrect, or PostgreSQL is not listening for connections the way you are expecting. Try all of the following for the Host Name setting:
The last one is two single quotes, which should force it to use a local unix socket connection. Unless the hostname is blank, there shouldn't be any quotes around it.

i have tried all 3 options and nothing is working. how am i able to see how Postgres is listening to the connections.

Did you follow the directions on our website for CentOS 8 from start to finish?
https://www.timetrex.com/how-to-install ... nux-centos

yep tried it twice on Rocky Linux

What the full and exact command line you used to connect with "psql" ?

Also check your PHP error log to see if it provides any more details.

see attached

see attached log

That is the access log, not the error log.

Also please attach the entire log file here rather than just a small screenshot which isn't very helpful.

still working on getting the whole php error log, but here is what i was able to find so far.

Thats what we needed to see.

So it appears that you didn't change the pg_hba.conf file properly as described in the instructions:
https://www.timetrex.com/how-to-install ... nux-centos

Either that or after the change PostgreSQL wasn't restarted properly, as its complaining that password authentication is not enabled.

after the restart of postgresql and checking the .conf file making sure it says md5 its still not working. im not sure i believe i have checked everything and followed instructions to the best of my knowledge.

You can try connecting to "psql" without first using "su postgres", as that is closer to what TimeTrex is doing, and it should give you immediate feedback as to the error.