[BCLUG] New and Confused older user

[Ron / BCLUG]

Frank Hilliard via Discuss wrote on 2024-09-27 19:02:

> "index.html" worked and "info.php" worked. This meant both Apache and
> php were up and running. Then I found postgresql was running.

Were these strictly on your local machine / network?


A quick check (might be wrong / out of date): WordPress doesn't
really support PostgreSQL out-of-the-box:

> Currently, the official WordPress distribution only supports the 
> MySQL and MariaDB database engines. A number of people have
> requested support for other database engines, particularly the
> open-source PostgreSQL. This page is an effort to summarize the
> previous discussion on the topic, and to get a solid roadmap for
> supporting more databases in WordPress.
> 
> https://codex.wordpress.org/Using_Alternative_Databases

So, that might be your problem.

Have you followed any special procedures to get it to work with postgresql?



> When I opened that file, or any html file in the wordpress directory
> I got booted directly to the company that Lightspeed uses in Kelowna
> to provide my Internet service, CipherKey Exchange Corp. Here's what
> my IP looks like: 172.103.205.70

That IP is not responding to http/https requests. Is it your home IP?

Oh, I see it is a home cable internet connection.




> So, I guess my question is how do I re-attach Wordpress to Apache in
> Linux? I admit something very obvious may be the problem.
Might be worth posting the output of phpinfo() as processed by Apache, 
so in a test.php file as described off-list.

That might help determine if there's a postgres module loaded in PHP.


I just ran this to check my WordPress site (running MariaDB / MySQL):

 > php -r "phpinfo();" | grep -i "postgres"

Got these results:

PostgreSQL driver for PDO => Edin Kadribasic, Ilia Alshanetsky
PostgreSQL => Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne


On the other hand, there were 31 lines of output when running:

 > php -r "phpinfo();" | grep -i "mysql" | wc -l


So:

a) what did you do to enable WP & PG to work together?
b) what does phpinfo() say?