TimeTrex installation help
TimeTrex installation help
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.
Re: TimeTrex installation help
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.
Code: Select all
localhost
Code: Select all
127.0.0.1
Code: Select all
''
Re: TimeTrex installation help
i have tried all 3 options and nothing is working. how am i able to see how Postgres is listening to the connections.
Re: TimeTrex installation help
Did you follow the directions on our website for CentOS 8 from start to finish?
https://www.timetrex.com/how-to-install ... nux-centos
https://www.timetrex.com/how-to-install ... nux-centos
Re: TimeTrex installation help
yep tried it twice on Rocky Linux
Re: TimeTrex installation help
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.
Also check your PHP error log to see if it provides any more details.
Re: TimeTrex installation help
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.
Also please attach the entire log file here rather than just a small screenshot which isn't very helpful.
Re: TimeTrex installation help
still working on getting the whole php error log, but here is what i was able to find so far.
Re: TimeTrex installation help
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.
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.
Re: TimeTrex installation help
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.
Re: TimeTrex installation help
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.