welcome to the world of container, you cannot use localhost here, localhost is not good, a container is like another VM somewhere, use the IP and also please take into account that your user of mariadb cannot be be restricted to localhost, use ``
migrate web data and mariadb mysql database to ns8
https://www.comparitech.com/net-admin/sftp-commands-cheat-sheet/
how to create a user inside mariadb container, first on the node ssh to the userLinux
# connect to mariadb1 (module_id)
ssh mariadb1@localhost
# connect to the mysql container as root
podman exec -ti mariadb-app mysql
# create the database and grant user to all from any IP (external port is closed to 127.0.0.1)
MariaDB [(none)]> CREATE DATABASE IF NOT EXISTS mydatabase;
MariaDB [(none)]> grant all privileges on mydatabase.* to username identified by 'password';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit
add data to the database from a mysql dump
podman exec -i mariadb-app mysql < toto.sql
the example content of toto.mysql, like you can see the user is able to connect from any host, this is a mandatory because we connect from outside the container, but the tcp port random is restricted to localhost
CREATE DATABASE if not exists foo;
CREATE USER if not exists 'foo' IDENTIFIED BY "foo";
GRANT ALL PRIVILEGES ON foo.* TO 'foo';
FLUSH PRIVILEGES;
use foo;
CREATE TABLE IF NOT EXISTS pages (
id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(30),
content TEXT,
INDEX(title)
) engine=InnoDB;
INSERT IGNORE INTO pages VALUES (1, 'Bienvenue', 'Bienvenue ');
then on the remote host running the web server send all local files by scp (login 9001 password 9001 for the first vhost you have created inside the ns8-webserver )
the default port is tcp 3092, think to enable the external access, the 9001 is the login of the first vhost
sftp -P 3092 9001@r1.rocky9.org
# move to you local web folder and cp everything to the vhost of NS8
lcd Téléchargements/wordpress-6.2.2-fr_FR/wordpress/
sftp> put -r *
Is there a way to ‘solve’ the infamous ‘Mixed content’. issue with WP by means of htaccess, thus not via an extra WP module? Examples that I found on the net did not work for me yet, maybe because these examples are not ‘container’ aware?
https and http. scripts are called over http and will not load due to enforced https. It seems to be a common problem, but I do not want to solve it at application level but at webserver level.
Replace https with http, but I do not know if that will do what you want.
How to change a WordPress URL step-by-step - IONOS CA. Change WordPress site URL in the admin dashboard.
The most common and easiest way to change the WordPress URL is to enter it directly in the admin dashboard. To do this, navigate to “Settings” > “General” in the admin area. There you will find the input fields where you can change the WordPress site URL or the website URL.
Yes, that is the case and I did change it already by advise of @stephdl in an old thread (directly in db tables). But still the mixed content, scripts are pulled in via http and thus blocked. I am the only one? (Rocky Linux)
I remember commenting all the long keys in wp-config.php.
I do not know if it is related.
To allow the reading of all the .htaccess files (AllowOverride ALL), I am more familiar with Apache in NS-7 than with Nginx in NS8.
There is a directive in the conf file to pass the header as is, with no change, from the requesting URL, but I cannot find it anymore . @mrmarkuz should remember and know how to use it with Nginx.