[BCLUG] New and Confused older user

[Ronald Barnes]

Frank Hilliard via Discuss wrote on 2024-09-28 13:35:

> Here's an image from info.php

That doesn't look like enough PostgreSQL modules are loaded.



Let us know what tables are showing in PG's WP DB.

+-----------------------+
| Tables_in_bclug       |
+-----------------------+
| wp_commentmeta        |
| wp_comments           |
| wp_links              |
| wp_options            |
| wp_postmeta           |
| wp_posts              |
| wp_term_relationships |
| wp_term_taxonomy      |
| wp_termmeta           |
| wp_terms              |
| wp_usermeta           |
| wp_users              |
+-----------------------+







Back to PG modules, note, for example, the PDO and other mysql entries 
below (mysqli.default_{host,port,socket} etc.):


php -r "phpinfo();" | grep -i "mysql"
Additional .ini files parsed => /etc/php/8.1/cli/conf.d/10-mysqlnd.ini,
/etc/php/8.1/cli/conf.d/20-mysqli.ini,
/etc/php/8.1/cli/conf.d/20-pdo_mysql.ini,
mysqli
MysqlI Support => enabled
Client API library version => mysqlnd 8.1.2-1ubuntu2.18
mysqli.allow_local_infile => Off => Off
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => /var/run/mysqld/mysqld.sock =>
/var/run/mysqld/mysqld.sock
mysqli.default_user => no value => no value
mysqli.local_infile_directory => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
mysqli.rollback_on_cached_plink => Off => Off
mysqlnd
mysqlnd => enabled
Version => mysqlnd 8.1.2-1ubuntu2.18
Loaded plugins =>
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysq
l_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions => mysqli,pdo_mysql
PDO drivers => mysql
pdo_mysql
PDO Driver for MySQL => enabled
Client API version => mysqlnd 8.1.2-1ubuntu2.18
pdo_mysql.default_socket => /var/run/mysqld/mysqld.sock =>
/var/run/mysqld/mysqld.sock
MySQL driver for PDO => George Schlossnagle, Wez Furlong, Ilia
Alshanetsky, Johannes Sc[...]
MySQLi => Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd => Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter





 > Yes, I'm running PostgreSQL

Is there a database for WP showing in psql?

What is shown running when connecting to PG and listing DBs?:

psql [your connection details]
\l


If there's a WP DB, then what tables are shown in it in psql?

\c [your WP DB]
\dt




> Let me get back to the key problem, the fact that my browser refuses
> to jump from 127.0.0.1 to 127.0.0.1/wordpress/wp-admin
> 
> When I try to do this, I get this fantastic URL in the location box:
> 
> https://172.103.205.70/wordpress/wp-login.php?redirect_to=http%3A%2F%2F127.0.0.1%2Fwordpress%2Fwp-admin%2F&reauth=1

So it's trying to redirect to the secure https.

This can be overridden in the database by updating `site_url` and `home` 
records in table `wp_options` to http versions of existing values.


> *************************** 1. row ***************************
>    option_id: 1
>  option_name: siteurl
> option_value: https://bclug.ca
>     autoload: yes
> *************************** 2. row ***************************
>    option_id: 2
>  option_name: home
> option_value: https://bclug.ca
>     autoload: yes


Do you have a domain or just using IP addresses?



>  I also get this fault page:
> 
> Notice; Wordpress has added the "s" to "http", and has redirected the
> browser to the CyberKey IP in Kelowna. How is this possible? What
> does MY copy of Wordpress even know about my internet connection?

It looks like it's redirecting to *your* IP address on port 443 (https) 
and you aren't port-forwarding 443 to your Apache.  Probably not 
port-forwarding 80 to Apache either.

Maybe try accessing your WP site via its LAN address?

Or, registering a domain if you don't have one...



rb

>