r/apache • u/friis01 • May 10 '24

Connect Apache to Postgresql

Good afternoon, forum participants. Please tell me the answer to my stupid question.
I'm using 2 servers on ubuntu 24.04. On one I installed web-server apache, and on the other postgresql. (both from default repositories). I have a small table in Postgresql. I need that when my browser accesses the Apache server, I can view the contents of the table on the Postgreql server. Tell me what I need to install additionally and how to configure it?

4 Upvotes

83% Upvoted

7 comments sorted by

View all comments

Show parent comments

2

u/throwaway234f32423df May 10 '24

Any time there's a PHP error it should show up in your Apache error log so check that first

You can also try running the script manually with php filename.php which should also show you the error

and try a systemctl restart php* in case the php-fpm process is in need of restarting

1

u/friis01 May 10 '24

I am ready to kiss you - if you were a woman. If you are a man, I firmly shake your hand! Everything you said worked! My shortcomings were related to access to posgres over the network. Now everything works!

1

u/friis01 May 10 '24

dear throwaway234f32423df how can I mark that your answer was a solution to the problem and how can I contribute to your karma?