{"id":9680,"date":"2022-11-24T22:31:58","date_gmt":"2022-11-24T22:31:58","guid":{"rendered":"https:\/\/stevepedwards.today\/DebianAdmin\/?p=9680"},"modified":"2025-06-09T04:20:32","modified_gmt":"2025-06-09T03:20:32","slug":"running-apache2-and-mysql-on-win11-wsl-ubuntu","status":"publish","type":"post","link":"https:\/\/stevepedwards.today\/DebianAdmin\/running-apache2-and-mysql-on-win11-wsl-ubuntu\/","title":{"rendered":"Running Apache2, MYSQL and WordPress on Win11 WSL Ubuntu"},"content":{"rendered":"
<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n

As I've done so much work on my websites and WordPress recently rebuilding\/fixing\/designing them for uploading to the web (here! lol) and I have about 256GB of space on my Win11 laptop, I wondered if all my Posts would work flawlessly on WSL, following my How-Tos line by line, and see if they worked as on Linux Mint or if there were issues. It would also be very useful to have a 2nd working backup of my home site should my very old Linux laptop fail. I thought I'd document it and log all that happens, from first steps following this Post first:<\/p>\n

https:\/\/stevepedwards.today\/DebianAdmin\/new-mint-install-want-wordpress-at-home-full-steps-i-take\/<\/span><\/p>\n

I thought I'd make this version clearer for beginners to understand better what is going on so there's more explained each step than before, and as it's WSL and Win11, I don't know what may happen myself.<\/p>\n

Before that though - for those who know Windows but not Linux much and want to learn - how do you install WSL first? In my case it's installed already but follow the instructions.<\/p>\n

WSL Setup<\/strong><\/p>\n

Open a Powershell prompt as Administrator and run:<\/p>\n

wsl --install <\/span><\/p>\n

Windows Subsystem for Linux is already installed.<\/span>
\nThe following is a list of valid distributions that can be installed.<\/span>
\nInstall using 'wsl --install -d <Distro>'.<\/span><\/strong><\/p>\n

NAME FRIENDLY NAME<\/span>
\nUbuntu Ubuntu<\/span>
\nDebian Debian GNU\/Linux<\/span>
\nkali-linux Kali Linux Rolling<\/span>
\nSLES-12 SUSE Linux Enterprise Server v12<\/span>
\nSLES-15 SUSE Linux Enterprise Server v15<\/span>
\nUbuntu-18.04 Ubuntu 18.04 LTS<\/span>
\nUbuntu-20.04 Ubuntu 20.04 LTS<\/span>
\nOracleLinux_8_5 Oracle Linux 8.5<\/span>
\nOracleLinux_7_9 Oracle Linux 7.9<\/span><\/p>\n

PS C:WINDOWSsystem32> wsl --list --verbose<\/span>
\nNAME STATE VERSION<\/span>
\n* Ubuntu Running 2<\/span><\/p>\n

To access the files in the wsl2 UBUNTU distro from the WINDOWS 11 explorer:<\/h4>\n

Open windows explorer and enter wsl$ in the address bar - it's the same place as the Linux icon under the Network link:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

NEVER<\/span> change files with Win tools in here as you can corrupt the Linux OS!! It's just for reference and orientation!!<\/strong><\/p>\n

IF you want GUI access to your Linux systems, see this link for Win10 - it doesn't work for my Win11 - it won't get past the Ubuntu login page then Win RDT drops out:<\/p>\n

https:\/\/dev.to\/aitorsol\/wsl2-windows-linux-subsystem-a-guide-to-install-a-local-web-server-ubuntu-20-04-apache-php8-y-mysql8-3bbk<\/a><\/p>\n

Once your Linux Distribution choice is installed, search for WSL in Windows, create a penguin shortcut to put on your Taskbar, open a terminal and feel free to update all the packages from the repositories of whatever Distro you chose, using it's command - Ubuntu in my case. Get to your home directory first for reference:<\/p>\n

cd<\/span><\/p>\n

stevee@laptop:~$ ls -al<\/span>
\ntotal 52<\/span>
\ndrwxr-xr-x 5 stevee stevee 4096 Nov 21 23:57 .<\/span>
\ndrwxr-xr-x 3 root root 4096 Sep 22 14:32 ..<\/span>
\n-rw------- 1 stevee stevee 8252 Nov 24 19:12 .bash_history<\/span>
\n-rw-r--r-- 1 stevee stevee 220 Sep 22 14:32 .bash_logout<\/span>
\n-rw-r--r-- 1 stevee stevee 3771 Sep 22 14:32 .bashrc<\/span>
\n-rw-r--r-- 1 stevee stevee 62 Oct 17 11:11 .gitconfig<\/span>
\ndrwxr-xr-x 2 stevee stevee 4096 Sep 22 14:32 .landscape<\/span>
\ndrwxr-xr-x 3 stevee stevee 4096 Oct 16 20:19 .local<\/span>
\n-rw-r--r-- 1 stevee stevee 0 Nov 24 15:43 .motd_shown<\/span>
\n-rw-r--r-- 1 stevee stevee 807 Sep 22 14:32 .profile<\/span>
\ndrwx------ 2 stevee stevee 4096 Nov 24 15:43 .ssh<\/span>
\n-rw-r--r-- 1 stevee stevee 0 Sep 22 14:45 .sudo_as_admin_successful<\/span>
\n-rw------- 1 stevee stevee 3893 Oct 17 10:57 .viminfo<\/span><\/p>\n

\u00a0sudo apt update<\/span><\/p>\n

30 packages can be upgraded. Run 'apt list --upgradable' to see them.<\/span><\/p>\n

\u00a0sudo apt upgrade<\/span><\/p>\n

sudo apt autoremove<\/span><\/p>\n

Samba Setup<\/strong><\/p>\n

Now I can start with my first steps from my Post above toward a WSL based webserver for my WordPress sites:<\/p>\n

sudo apt-get install ssh nmap vim automake autoconf module-assistant nbtscan locate libnss-winbind winbind g++ gparted intel-microcode amd64-microcode linux-firmware mysql-server wordpress apache2 samba libapache2-mod-php php-mbstring php-curl php php-mysql<\/span><\/p>\n

If you have a slow ADSL connection for the downloads, open another Linux terminal to continue other tasks like setting a root password:<\/p>\n

stevee@laptop:~$ sudo passwd root<\/span>
\nNew password:<\/span>
\nRetype new password:<\/span>
\npasswd: password updated successfully<\/span><\/p>\n

A samba network share password is required to access other Linux network shares later - the same password as the your user name on those other PCs to keep logins simple:<\/p>\n

sudo smbpasswd -a stevee<\/span><\/p>\n

New SMB password:<\/span>
\nRetype new SMB password:<\/span>
\nAdded user stevee.<\/span><\/p>\n

sudo vim \/etc\/samba\/smb.conf<\/span><\/p>\n

Uncomment the [homes] section - permissions according to what read\/write access you want to allow from remote PCs:<\/p>\n

[homes]<\/span><\/p>\n

; comment = Home Directories<\/span>
\nbrowseable = 1<\/span><\/p>\n

read only = 0<\/span><\/p>\n

create mask = 0775<\/span><\/p>\n

directory mask = 0775<\/span><\/p>\n

valid users = %S<\/span><\/p>\n

To add extra shares, write them at the bottom of the smb.conf file in the form:<\/p>\n

[var_www]<\/span>
\npath = \/var\/www\/<\/span>
\nwriteable = 1<\/span>
\nbrowseable = 1<\/span><\/p>\n

Save the file in vim with<\/p>\n

:wq<\/span><\/p>\n

Check it for errors:<\/p>\n

stevee@laptop:~$ testparm<\/span>
\nLoad smb config files from \/etc\/samba\/smb.conf<\/span>
\nLoaded services file OK.<\/span>
\nWeak crypto is allowed<\/span><\/p>\n

Start Samba services:<\/p>\n

sudo service smbd start<\/span><\/p>\n

sudo service nmbd start<\/span><\/p>\n

But nothing on the network is visible - windows stopped using SMB for network connections a while ago, why Linux and Windows can oly connect via mapped drives out of the box now - but the Linux laptop should be seen?:<\/p>\n

stevee@laptop:\/var\/www$ sudo smbstatus<\/span>
\nsudo: unable to resolve host laptop: System error<\/span><\/p>\n

Samba version 4.13.17-Ubuntu<\/span>
\nPID Username Group Machine Protocol Version Encryption Signing<\/span><\/p>\n

APACHE2 Setup<\/strong><\/p>\n

For WP to run, not just read the wp-*php files it will require:<\/p>\n

sudo apt install mysql-server wordpress apache2 libapache2-mod-php php-mbstring php-curl php php-mysql<\/span><\/p>\n

As these have already been installed above, there may be nothing to do except another:<\/p>\n

sudo apt autoremove<\/span><\/p>\n

Configure the Apache2 files to suit your site - I only want 2 sites available whose WordPress content folders will be stored in \/var\/www:<\/p>\n

sudo vi \/etc\/apache2\/sites-enabled\/000-default.conf<\/span><\/p>\n

DocumentRoot \/var\/www<\/span>
\nAlias \"DebianAdmin\" \"\/var\/www\/DebianAdmin\"<\/span>
\nAlias \"ElectronicsStuff\" \"\/var\/www\/ElectronicsStuff\"<\/span><\/p>\n

Amend this file accordingly:<\/p>\n

sudo vi \/etc\/apache2\/apache2.conf<\/span><\/p>\n

# Global configuration<\/span>
\n#<\/span>
\nServerName laptop<\/strong><\/span>
\n# In vim, press\u00a0\/\u00a0then search \"var\/www\", and change code to:<\/span><\/p>\n

<Directory \/var\/www><\/span>
\nOptions Indexes FollowSymLinks<\/span>
\nAllowOverride All<\/strong><\/span>
\nRequire all granted<\/strong><\/span>
\n<\/Directory><\/span><\/p>\n

stevee@laptop:~$ sudo service apache2 restart<\/span>
\n* Restarting Apache httpd web server apache2<\/span><\/p>\n

If you now enter your http site name in a browser bar you should see the insecurity compliant:<\/p>\n

\"\"<\/a><\/p>\n

If you continue, you won't see any site files, as I haven't copied the WP contents folder or index.html to \/var\/www or set the permissions yet.<\/p>\n

So my user and Apache2 has access to the web folder \/var\/www, set the ownership of user:group:<\/p>\n

sudo chown stevee:www-data -R \/var\/www\/<\/span><\/p>\n

sudo chmod 775 -R \/var\/www\/<\/span><\/p>\n

ls -l \/var\/www\/<\/span>
\ntotal 4<\/span>
\ndrwxrwxr-x 2 stevee www-data 4096 Nov 24 22:55 html<\/span><\/p>\n

Now I have to copy the WP site's content folders here from where they are already - I don't need to be root as I own both source and destination folders - about 7.4GB in total:<\/p>\n

cp -vr \/mnt\/c\/MyShare\/www\/* \/var\/www\/<\/span><\/p>\n

The files retain their old ownership permissions so have to be changed again for Apache2 group access.<\/p>\n

stevee@laptop:\/var\/www$ ls -l \/var\/www\/<\/span>
\ntotal 4653712<\/span>
\n-rwxr-xr-x 1 stevee stevee<\/strong> 2480 Nov 24 23:36 android-chrome-96x96.png<\/span>
\n-rwxr-xr-x 1 stevee stevee<\/strong> 3167 Nov 24 23:36 Apache2SSLCerts.txt<\/span>
\n-rwxr-xr-x 1 stevee stevee<\/strong> 1898 Nov 24 23:36 apple-touch-icon.png<\/span><\/p>\n

Assume all wp site folders are unpacked or copied into \/var\/www\/. Set all files to correct permissions for a local PC only (755\/644) or network group access (775\/664) and user:group permissions:<\/p>\n

sudo chown stevee:www-data -R \/var\/www<\/span><\/p>\n

sudo find \/var\/www\/ -type d -exec chmod 775 -R {} +<\/span><\/p>\n

sudo find \/var\/www\/ -type f -exec chmod 664 -R {} +<\/span><\/p>\n

stevee@laptop:\/var\/www$ ls -l \/var\/www\/<\/span>
\n-rw-rw-r-- 1<\/strong> stevee www-data<\/strong> 4603540204 Nov 24 23:36 backup-11.23.2022_20-15-52_steveped.tar.gz<\/span>
\ndrwxrwxr-x<\/strong> 2 stevee www-data<\/strong> 4096 Nov 24 23:36 CTQuiz<\/span>
\ndrwxrwxr-x<\/strong> 6 stevee www-data<\/strong> 4096 Nov 24 23:40 DebianAdmin<\/span><\/p>\n

These permissions allow network access to the site.<\/p>\n

To be sure WP can update plugins and Themes if 775\/644 doesn't allow them to change the updates\/plugins folders in wp-content:
\nsudo find \/var\/www\/*\/wp-* -type d -exec chmod 777 -R {} ;<\/span><\/p>\n

If this was a production site it would have to be changed back to 755\/644 afterward if necessary. My web host sites don't have to be changed from default permissions 755\/644, but home sites do.<\/p>\n

MYSQL Setup\u00a0<\/strong><\/p>\n

Before I import the different site's SQL database files, they need to have all references to the old site name - localhost - changed to the new server's name - \"localhost\" (IMPORTANTLY in this case - as I found out after doing all this Post).<\/p>\n

Alos importantly, is to use the full https:\/\/localhost line in the database so legitimate use of the word \"localhost\" isn't changed to localhost in normal text etc - but only for the web links!<\/p>\n

Note the forward slashes (\/) have to be escaped with a backslash in Linux () and because this site will be upgraded to HTTPS later, I'll keep the current file's HTTPS links intact.<\/p>\n

I use SED for this as it is fast and effective - if unforgiving of errors - like most old linux commands so be SURE you have the correct strings to search and replace before you run it!!<\/p>\n

sed -i 's\/https:\/\/stevepedwards.today\/https:\/\/stevepedwards.today\/g' DebianAdmin.SQL<\/span><\/p>\n

sed -i 's\/https:\/\/stevepedwards.today\/https:\/\/stevepedwards.today\/g' ElectronicsStuff.sql<\/span><\/p>\n

Now I can access MYSQL, create and import the WP databases, hopefully:<\/p>\n

stevee@laptop:\/var\/www$ sudo service mysql start<\/span>
\n* Starting MySQL database server mysqld su: warning: cannot change directory to \/nonexistent: No such file or directory.<\/strong><\/span><\/p>\n

Hmm, dunno what that means? Research later...<\/p>\n

stevee@laptop:\/var\/www$ sudo mysql -u root -p<\/span>
\nEnter password:<\/span>
\nWelcome to the MySQL monitor. Commands end with ; or g.<\/span>
\nYour MySQL connection id is 10<\/span>
\nServer version: 8.0.31-0ubuntu0.20.04.1 (Ubuntu)<\/span><\/p>\n

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.<\/p>\n

mysql> show databases ;<\/span><\/span>
\n+--------------------+<\/span>
\n| Database |<\/span>
\n+--------------------+<\/span>
\n| information_schema |<\/span>
\n| mysql |<\/span>
\n| performance_schema |<\/span>
\n| sys |<\/span>
\n+--------------------+<\/span>
\n4 rows in set (0.02 sec)<\/span><\/p>\n

mysql> create database DebianAdmin ;<\/span><\/span>
\nQuery OK, 1 row affected (0.02 sec)<\/span><\/p>\n

mysql> create database ElectronicsStuff ;<\/span><\/span>
\nQuery OK, 1 row affected (0.00 sec)<\/span><\/p>\n

mysql> show databases ;<\/span><\/span>
\n+--------------------+<\/span>
\n| Database |<\/span>
\n+--------------------+<\/span>
\n| DebianAdmin |<\/span>
\n| ElectronicsStuff |<\/span>
\n| information_schema |<\/span>
\n| mysql |<\/span>
\n| performance_schema |<\/span>
\n| sys |<\/span>
\n+--------------------+<\/span>
\n6 rows in set (0.00 sec)<\/span><\/p>\n

mysql> use DebianAdmin ;<\/span><\/span>
\nDatabase changed<\/span><\/p>\n

mysql> <\/span>source \/var\/www\/DebianAdmin.SQL ;<\/span><\/p>\n

mysql> use ElectronicsStuff ;<\/span><\/span><\/p>\n

mysql> source \/var\/www\/ElectronicsStuff.sql ;<\/span><\/span><\/p>\n

mysql> show databases ;<\/span><\/span>
\n+--------------------+<\/span>
\n| Database |<\/span>
\n+--------------------+<\/span>
\n| DebianAdmin |<\/span>
\n| ElectronicsStuff |<\/span>
\n| information_schema |<\/span>
\n| mysql |<\/span>
\n| performance_schema |<\/span>
\n| sys |<\/span>
\n+--------------------+<\/span>
\n6 rows in set (0.00 sec)<\/span><\/p>\n

I have to allow access to these Dbs for my local user with my password:<\/p>\n

mysql>\u00a0<\/span><\/span><\/p>\n

CREATE USER 'stevee'@'%' IDENTIFIED BY 'pword';<\/span><\/span><\/p>\n

OR:<\/p>\n

CREATE USER 'stevee'@'localhost' IDENTIFIED BY 'pword';<\/span><\/p>\n

DROP USER 'wronguser'@'%';<\/span><\/p>\n

GRANT ALL on *.* TO 'stevee'@'localhost' ;<\/span><\/p>\n

mysql> SHOW GRANTS FOR 'stevee'@'localhost';<\/span><\/span>
\n+--------------------------------------------------------------------------------------------------------------------------------+<\/span>
\n| Grants for stevee@localhost<\/span>
\n|<\/span>
\n+--------------------------------------------------------------------------------------------------------------------------------+<\/span>
\n| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REFERENCES, ALTER ON *.* TO `stevee`@`localhost` WITH GRANT OPTION |<\/span>
\n+--------------------------------------------------------------------------------------------------------------------------------+<\/span>
\n1 row in set (0.00 sec)<\/span><\/p>\n

The principle user name given access here is the name that goes into wp-config.php file for that database name.<\/p>\n

sudo vi DebianAdmin\/wp-config.php<\/span><\/p>\n

\/\/ ** MySQL settings - You can get this info from your web host ** \/\/<\/span>
\n\/** The name of the database for WordPress *\/<\/span>
\ndefine('DB_NAME', 'DebianAdmin');<\/span><\/p>\n

\/** MySQL database username *\/<\/span>
\ndefine('DB_USER', 'stevee');<\/span><\/p>\n

\/** MySQL database password *\/<\/span>
\ndefine('DB_PASSWORD', 'xxx');<\/span><\/p>\n

\/** MySQL hostname *\/<\/span>
\ndefine('DB_HOST', 'localhost');<\/span><\/p>\n

Now check out and test user stevee can access MYSQL:<\/p>\n

mysql> exit<\/span><\/span>
\nBye<\/span><\/p>\n

stevee@laptop:\/var\/www$ sudo mysql -u stevee -p<\/span>
\n[sudo] password for stevee:<\/span>
\nEnter password:<\/span>
\nWelcome to the MySQL monitor. Commands end with ; or g<\/span><\/p>\n

Restart MYSQL:<\/p>\n

stevee@laptop:\/var\/www$ sudo service mysql restart<\/span>
\n* Stopping MySQL database server mysqld [ OK ]<\/span>
\n* Starting MySQL database server mysqld su: warning: cannot change directory to \/nonexistent: No such file or directory<\/strong><\/span><\/p>\n

For issue:<\/strong><\/p>\n

su: warning: cannot change directory to \/nonexistent: No such file or directory<\/strong><\/p>\n

\"I'd like to verify this is the problem. Here's the line from my \/etc\/passwd<\/code>\u00a0with the\u00a0\/nonexistent<\/code>\u00a0directory name:\u00a0mysql:x:112:119:MySQL Server,,,:\/nonexistent:\/bin\/false\"<\/code><\/em><\/p>\n

FIX - give mysql a valid directory, not \/nonexistent:<\/strong><\/p>\n

sudo service mysql stop<\/span><\/p>\n

sudo usermod -d \/var\/lib\/mysql\/ mysql<\/span><\/p>\n

sudo service mysql start<\/span><\/p>\n

Now, mysql has a valid directory as seen in:<\/p>\n

stevee@laptop:\/var\/www$ grep --color mysql \/etc\/passwd<\/span>
\nmysql:x:113:120:MySQL Server,,,:\/var\/lib\/mysql\/:\/bin\/false<\/span><\/p>\n

To Export DBs:<\/strong><\/p>\n

stevee@laptop:\/var\/www$ sudo mysqldump -vu root -p DebianAdmin > \/var\/www\/DA.sql<\/span><\/p>\n

Check all required web services are running:<\/p>\n

nmap localhost<\/span><\/p>\n

Not shown: 998 closed ports<\/span>
\nPORT STATE SERVICE<\/span>
\n80\/tcp open http<\/span>
\n3306\/tcp open mysql<\/span><\/p>\n

Now input:<\/p>\n

localhost\/<\/p>\n

into your browser page to see your index.html Landing Page if you have one - it works:<\/p>\n

\"\"<\/a>BUT! Access to the WP sites is not working - and notice it tried the PC name, not localhost:<\/p>\n

\"\"<\/a><\/p>\n

FOR net access from PCs, edit 127.0.0.1 bind addr\u00a0 to 0.0.0.0:<\/p>\n

# Instead of skip-networking the default is now to listen only on
\n# localhost which is more compatible and is not less secure.
\nbind-address = 0.0.0.0<\/span><\/p>\n

sudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/span><\/p>\n

Let's see what nmap says:<\/p>\n

stevee@laptop:\/var\/www$ nmap localhost<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 13:20 GMT<\/span>
\nNmap scan report for localhost (127.0.0.1)<\/span>
\nHost is up (0.000022s latency).<\/span>
\nNot shown: 998 closed ports<\/span>
\nPORT STATE SERVICE<\/span>
\n80\/tcp open http<\/span><\/strong>
\n3306\/tcp open mysql<\/span><\/strong><\/p>\n

OK, so the services are running for localhost but only http for server name laptop:<\/p>\n

stevee@laptop:\/var\/www$ nmap laptop<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 13:23 GMT<\/span>
\nNmap scan report for laptop (127.0.1.1)<\/span>
\nHost is up (0.000026s latency).<\/span>
\nrDNS record for 127.0.1.1: laptop.localdomain<\/span>
\nNot shown: 999 closed ports<\/span>
\nPORT STATE SERVICE<\/span>
\n80\/tcp open http<\/span>
\n3306\/tcp open mysql<\/span><\/p>\n

That means I should<\/em> have access to the WP AND Apache sites:<\/p>\n

\"\"<\/a><\/p>\n

My Electronics site is partly showing so that's a WP config issue mostly, but DebianAdmin is not showing at all as it is redirecting from localhost to \"laptop\"- but still a WP config or Apache HTTPS re-direct issue, probably from the old Linux laptop Apache file settings:<\/p>\n

\"\"<\/a><\/p>\n

I can also get local access via IP address: https:\/\/172.31.108.16\/ElectronicsStuff\/<\/p>\n

You can use Better Search Replace plugin to change any errant non http links that may affect things like YouTube vids not showing:<\/p>\n

\"\"<\/a>I DONT have remote PC access though either by browser address name \/laptop or IP address so I cannot login as it's link is via PC name.<\/p>\n

Let's look at some network issues like firewall access to the network connections. This laptop only has a wifi card but no ethernet port.<\/p>\n

In WSL Ubuntu, unlike Mint, ifconfig does not work until net-tools is installed:<\/p>\n

sudo apt install net-tools<\/span><\/p>\n

ifconfig<\/span><\/p>\n

eth0<\/strong>: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500<\/span>
\ninet 172.31.104.71 netmask 255.255.240.0 broadcast 172.31.111.255<\/span><\/strong><\/p>\n

What weird IP addresses are these?? My router DHCP is set to 192.168.1.x addresses?<\/p>\n

Ok, some independent \/20 WSL network? Using a net calc, as my Networking skills are way overdue for a recap...like by 12 years..lol<\/p>\n

Netmask<\/div>\n
255.255.240.0 = 20<\/div>\n
Network<\/div>\n
172.31.96.0\/20<\/div>\n
Broadcast<\/div>\n
172.31.111.255<\/div>\n
First IP<\/div>\n
172.31.96.1<\/div>\n
Last IP<\/div>\n
172.31.111.254<\/div>\n
Hosts\/Net<\/div>\n
4094<\/div>\n

I only have wifi on this laptop too and WSL says it's eth0?!<\/p>\n

That's because WSL runs on a VM with a virtual network adaptor, so the name doesn't matter - it's just an IP gateway.<\/p>\n

My Win11 netcard is 192.168.1.16. Is there some WSL aliasing going on here to share the wifi adaptor? What does nmap make of it all? Interesting, neither IP addresses show mysql port 3306 so STILL will not be able to connect to my WP\/MYSQL websites:<\/p>\n

stevee@laptop:\/var\/www$ nmap 172.31.104.71<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 01:16 GMT
\nNmap scan report for 172.31.104.71<\/span>
\nHost is up (0.000065s latency).<\/span>
\nNot shown: 999 closed ports<\/span>
\nPORT STATE SERVICE<\/span>
\n80\/tcp open http<\/span><\/strong><\/p>\n

stevee@laptop:\/var\/www$ nmap 192.168.1.16 -Pn<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 01:29 GMT<\/span>
\nNmap scan report for laptop (192.168.1.16)<\/span>
\nHost is up (0.00044s latency).<\/span>
\nNot shown: 996 filtered ports<\/span>
\nPORT STATE SERVICE<\/span>
\n135\/tcp open msrpc<\/span><\/strong>
\n139\/tcp open netbios-ssn<\/span><\/strong>
\n445\/tcp open microsoft-ds<\/span><\/strong>
\n5357\/tcp open wsdapi<\/span><\/strong><\/p>\n

I will need to let mysql out of the firewall at least maybe? Been a long time since I've done that shit in Windows...hmm..just for fun, lets turn it off the firewall first as the easiest thing to see what connects or not then..<\/p>\n

\"\"<\/a><\/p>\n

No change for nmap on:<\/p>\n

stevee@laptop:\/var\/www$ nmap 172.31.108.16 -Pn<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 13:43 GMT
\nNmap scan report for 172.31.108.16
\nHost is up (0.000025s latency).
\nNot shown: 999 closed ports
\nPORT STATE SERVICE
\n80\/tcp open http<\/span><\/strong><\/p>\n

The Win11 wifi IP is:<\/p>\n

Windows key + I<\/span> to open the Settings menu.<\/strong><\/p>\n

\"\"<\/a><\/p>\n

Or, in cmd:<\/p>\n

\"\"<\/a><\/p>\n

stevee@laptop:\/var\/www$ nmap 192.168.1.16 -Pn<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 13:46 GMT
\nNmap scan report for laptop (192.168.1.16)
\nHost is up (0.00038s latency).
\nNot shown: 996 closed ports
\nPORT STATE SERVICE
\n135\/tcp open msrpc<\/span>
\n139\/tcp open netbios-ssn<\/span>
\n445\/tcp open microsoft-ds<\/span>
\n5357\/tcp open wsdapi<\/span><\/p>\n

So, no external access to WSL via the local network at all on ports 80 or 3306...so I need to research how WSL works with the Win11 network, as even after opening up port 80 inbound\/outbound in the Firewall:<\/p>\n

\"\"<\/a><\/p>\n

I did ports for both In and OUT Rules:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

There is also the UFW firewall on Ubuntu, so disable that too:<\/p>\n

sudo ufw disable<\/span><\/p>\n

Firewall stopped and disabled on system startup<\/span><\/p>\n

This still doesn't allow any different access than before:<\/p>\n

stevee@laptop:\/var\/www$ nmap 192.168.1.16 -Pn<\/span>
\nStarting Nmap 7.80 ( https:\/\/nmap.org ) at 2022-11-25 13:57 GMT
\nNmap scan report for laptop (192.168.1.16)
\nHost is up (0.00059s latency).
\nNot shown: 996 filtered ports
\nPORT STATE SERVICE
\n135\/tcp open msrpc<\/span>
\n139\/tcp open netbios-ssn<\/span>
\n445\/tcp open microsoft-ds<\/span>
\n5357\/tcp open wsdapi<\/span><\/p>\n

Research time...ho hum - nothing is or was ever simple in Windows networking...<\/p>\n

For now I'll continue with the SSL and upgrading the PHP version as this site was running on PHP8.0 on the Linux laptop as that may clear up the local re-direct and HTTPS link issues inside the WP site docs.<\/p>\n

The PPA is maintained by\u00a0Ond?ej Sur\u00fd<\/a>, a Debian developer who has been packaging PHP for Debian since PHP 5.<\/p>\n

stevee@laptop:\/var\/www$ php -v<\/span>
\nPHP 7.4.3<\/strong> (cli) (built: Nov 2 2022 09:53:44) ( NTS )<\/span>
\nCopyright (c) The PHP Group<\/span>
\nZend Engine v3.4.0, Copyright (c) Zend Technologies<\/span>
\nwith Zend OPcache v7.4.3, Copyright (c), by Zend Technologies<\/span><\/p>\n

sudo apt-add-repository ppa:ondrej\/php<\/span><\/p>\n

sudo apt update && sudo apt upgrade<\/span><\/p>\n

sudo apt install php8.0<\/span><\/p>\n

sudo apt autoremove<\/span><\/p>\n

Ah, I see it just goes to ver8.1 not 8.0.<\/p>\n

stevee@laptop:\/var\/www$ php -v<\/span>
\nPHP 8.1.12<\/strong> (cli) (built: Oct 28 2022 17:39:37) (NTS)<\/span>
\nCopyright (c) The PHP Group<\/span>
\nZend Engine v4.1.12, Copyright (c) Zend Technologies<\/span>
\nwith Zend OPcache v8.1.12, Copyright (c), by Zend Technologies<\/span><\/p>\n

stevee@laptop:\/var\/www$ sudo a2dismod php7.4<\/span>
\nModule php7.4 disabled.<\/span><\/p>\n

stevee@laptop:\/var\/www$ sudo a2enmod php8.0<\/span>
\nEnabling module php8.0.<\/span>
\nTo activate the new configuration, you need to run:<\/span>
\nsudo service apache2 restart<\/span><\/p>\n

To see WP errors, set DEBUG true in wp-config.php:<\/p>\n

define('WP_DEBUG', true);<\/span><\/p>\n

\"\"<\/a><\/p>\n

The bloody Chrome caching oh dear!s up testing SO much!! In Incognito mode, BOTH sites are suffering from the same missing extension issue! Damn..going backwards here.<\/p>\n

The php-mysql extension WAS installed earlier, so I don't know why it's complaining..? But it IS missing mysqli.ini here.<\/p>\n

Compare the PHP details of old and new sites in the browser - you can see mysqli.ini is missing from this new install in phpinfo.php:<\/p>\n

https:\/\/stevepedwards.today\/phpinfo.php; https:\/\/stevepedwards.today\/phpinfo.php<\/p>\n

\"\"<\/a><\/p>\n

To create a phpinfo file, in your root Apache2 html directory (\/var\/www\/ in my case) create an empty file:<\/p>\n

vi phpinfo.php\u00a0<\/span><\/p>\n

and type or copy into it:<\/p>\n

<?php<\/span>
\nphpinfo();<\/span>
\n?><\/span><\/p>\n

If you TAB the command:<\/p>\n

sudo apt install php-<\/span><\/p>\n

you will see all the php extensions available for install. Not that it helps ATM, but handy to know when the WP Site Health complains you have extension like GD missing, so you can search for them with this command and install what's missing e.g:<\/p>\n

sudo apt install php-gd<\/span><\/p>\n

Ah! I was trying to remember the extension command because I used it last week, but it's specific to the PHP version! It's<\/p>\n

sudo apt-get install php8.0-mysql<\/span><\/p>\n

Has it helped? No.<\/p>\n

But if you get Site Health complaints like:<\/p>\n

\"\"<\/a><\/p>\n

You can add these missing extensions by using the php version based command of php-mysqlXX and Tabbing to complete the extension options - especially if marked Critical with a red X, as it may be why your site isn't fully functional:<\/p>\n

\"\"<\/a><\/p>\n

You may have to restart Apache to remove the extension warning after install, as Shift-F5 cache refresh did not work to re-read the database state.<\/p>\n

The 8.1 version is already installed - so what version IS running exactly?<\/p>\n

stevee@laptop:\/var\/www$ php -v<\/span>
\nPHP 8.1.12 (cli) (built: Oct 28 2022 17:39:37) (NTS)<\/span>
\nCopyright (c) The PHP Group<\/span>
\nZend Engine v4.1.12, Copyright (c) Zend Technologies<\/span>
\nwith Zend OPcache v8.1.12, Copyright (c), by Zend Technologies<\/span><\/p>\n

Ok, let's downgrade to 8.0 as that was what the WP site was running fine on before export using this Post:<\/p>\n

Downgrading PHP Versions<\/a><\/p><\/blockquote>\n