TimeTrex installation help

Ask your questions regarding TimeTrex installation here.
Post Reply
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

TimeTrex installation help

Post by rob14 »

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.
Attachments
postgres database users and role configuration
postgres database users and role configuration
postgres.PNG (7.87 KiB) Viewed 523 times
screenshot of the error i get
screenshot of the error i get
connection.PNG (6.71 KiB) Viewed 523 times
database config using multiple users and database passwords but i still get the errors
database config using multiple users and database passwords but i still get the errors
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

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:

Code: Select all

localhost

Code: Select all

127.0.0.1

Code: Select all

''
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.
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

i have tried all 3 options and nothing is working. how am i able to see how Postgres is listening to the connections.
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

Did you follow the directions on our website for CentOS 8 from start to finish?
https://www.timetrex.com/how-to-install ... nux-centos
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

yep tried it twice on Rocky Linux
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

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.
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

see attached
Attachments
postgres1.PNG
postgres1.PNG (5.54 KiB) Viewed 499 times
phperrolog.PNG
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

see attached log
Attachments
apache error log
apache error log
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

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.
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

still working on getting the whole php error log, but here is what i was able to find so far.
Attachments
phperrorlog1.PNG
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

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.
rob14
Posts: 7
Joined: Sun Jun 26, 2022 8:39 pm

Re: TimeTrex installation help

Post by rob14 »

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.
shaunw
Posts: 7822
Joined: Tue Sep 19, 2006 2:22 pm

Re: TimeTrex installation help

Post by shaunw »

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.
Post Reply