Marks Notes

0) etc.hosts – add ip ## & domain name

1) create a new google-vm or virtualbox-vm with apache, php & mariadb

2) echo ‘‘ > /var/www/html/phpinfo.php ;

3) http://domainName/phpinfo.php — check if page loads

4) create mariadb user:

    CREATE USER ‘WpUser’@‘localhost’ IDENTIFIED BY ‘WpPassword’;

    GRANT ALL ON `WpDb`.* TO ‘WpUser’@‘localhost’	
    IDENTIFIED BY ‘WpPassword’ 							
    WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 
    MAX_USER_CONNECTIONS 0	;

    DROP DATABASE IF EXISTS `wpDb` ; 
   CREATE DATABASE IF NOT EXISTS `wpDb` 			;

    GRANT ALL PRIVILEGES ON `wpDb`.* TO ‘wpUser’@‘localhost’	;

    # test:  mariadb  —host=localhost —user=wpUser  —password=wpPassword  wpDb    ;   

5) wget https://wordpress.org/latest.tar.gz ;

6) gzip —decompress and tar into position
6a) rm -f *.php readme.html ./wc-content/ ./wp-includes/ ./wp-admin/ ;
6b) chown -R apache:apache /var/www/html

7) create new WP site using db info from step two

8) install prime-mover plugin

9) prime-mover import data

10) EXPORT new website using something like all-in-one migration

shared-hosting-cpanel:

1) create LAMP
2) manually install WP
3) install prime-mover plugin
4) import from previous step

EasyWP import: 1) create an EasyWP website

2) use all-in-one to IMPORT the export from step 10.

3) delete google-analytics plugin, some sort of conflict.

in this example i use waveSurfer

step one: visit the webpage: about:blank

step two: enter the following code in the console:

var WaveSurfer = null;   // required for creating a global variable.
let script		        = document.createElement('script')		;
script.type		= 'module'				             ;
script.innerText	= `
    import ws from 'https://unpkg.com/wavesurfer.js@beta'; 
    WaveSurfer=ws;
`;
let script		= document.createElement('script')		;
script.type		= 'module'				;
Object.assign(script, 	{innerText } );  // fancy way of assigning a key:value to this object
document.head.appendChild(script);

step three: after waiting a half-second, enter the following code in the console:

const wavesurfer = WaveSurfer.create({
  'container': document.body,
  waveColor: '#4F4A85',
  progressColor: '#383351',
  url: 'https://wavesurfer-js.org//wavesurfer-code/examples/audio/audio.wav',
})
wavesurfer.once('interaction', () => {
  wavesurfer.play()
})

wavesurfer shoudl appear in the browser window.

timeline example:

var WaveSurfer = null;        // required for creating a global variable.
var TimelinePlugin = null;    // required for creating a global variable.
let innerText = `
    import ws from ‘https://unpkg.com/wavesurfer.js@beta’; 
    WaveSurfer = ws;
    import tlPlugin from ‘https://unpkg.com/wavesurfer.js@beta/dist/plugins/timeline.js’;
    TimelinePlugin = tlPlugin;
`;

let script		= document.createElement(‘script’)		;
script.type		= ‘module’				;
Object.assign(script,  { innerText } ); // fancy way of assigning this object a value!
document.head.appendChild(script);

const wavesurfer = WaveSurfer.create({
  ‘container’: document.body,
  waveColor: ‘#4F4A85’,
  progressColor: ‘#383351’,
  url: ‘https://wavesurfer-js.org//wavesurfer-code/examples/audio/audio.wav’,
})
wavesurfer.registerPlugin(TimelinePlugin.create());

wavesurfer.once(‘interaction’, () => {
  wavesurfer.play()
})

it appears that ‘insert on duplicate key update’ will actually create some sort of temporary record then delete it. you can see this in the AUTO_INCREMENT value.

https://mariadb.com/kb/en/insert-on-duplicate-key-update/#:~:text=INSERT%20…,API’s%20CLIENT_FOUND_ROWS%20flag%20is%20set.

DROP TABLE IF EXISTS testTable ;

CREATE TABLE testTable
( nameFirst VARCHAR NOT NULL
, nameLast VARCHAR NOT NULL
, addr VARCHAR NULL
, city VARCHAR NULL
, id INTEGER NOT NULL AUTO_INCREMENT
, UNIQUE KEY (nameFirst, nameLast)
, PRIMARY KEY (id)
);

INSERT INTO testTable SET nameFirst = ‘mark’ , nameLast = ‘edwards’ , addr = ’123 swallow lane’ ;

SELECT * FROM testTable;

INSERT INTO testTable SET nameFirst = ‘pete’ , nameLast = ‘robinson’ , addr = ’246 starling’ , city = ‘oceanside’ ON DUPLICATE KEY UPDATE addr = ’123 swallow lane’ , city = ‘oceanside, ca’ ;

SELECT * FROM testTable;

INSERT INTO testTable SET nameFirst = ‘pete’ , nameLast = ‘robinson’ , addr = ’246 starling’ , city = ‘oceanside’ ON DUPLICATE KEY UPDATE city=‘oceanside, ca’ ;

SELECT * FROM testTable;

INSERT INTO testTable SET nameFirst = ‘lori’, nameLast=‘edwards’, addr = ’948 south third’ ON DUPLICATE KEY UPDATE addr = ’123 swallow ln’, city=‘oceanside’ ;

SELECT * FROM mark ;

INSERT INTO testTable SET nameFirst = ‘lori’, nameLast=‘edwards’, addr = ’948 south third’ ON DUPLICATE KEY UPDATE addr = ’123 swallow ln’, city=‘oceanside’ ;

SELECT * FROM testTable ;

INSERT INTO testTable SET nameFirst = ‘marky’, nameLast=‘edwards’, addr = ’123 swallow lane’ ON DUPLICATE KEY UPDATE addr = ’123 swallow lane’, city=‘oceanside, ca’ ;

SELECT * FROM testTable ;

easiest to install: qbittorrent:

dnf install epel-release ;
dnf —assumeyes install qbittorrent ;
dnf —assumeyes install qt5-qtsvg ;
dnf —assumeyes install qbittorrent-nox ;
/usr/bin/qbittorrent-nox —webui-port=12345 ; ## this also gives you the default username/password

https://www.qbittorrent.org/

written from: https://www.linuxbabe.com/redhat/install-qbittorrent-centos-8-rhel-8#comment-961469

second easiest: deluge (but this requires snap)

https://deluge-torrent.org/
https://idroot.us/install-deluge-bittorrent-client-centos-8/ (very helpful)
https://www.linuxhelp.com/how-to-install-deluge-in-centos

could not get installed: ruTorrent

this requires some packages that are no longer available on rocky-linux 8

REPLACED WITH: https://github.com/edwardsmarkf/selinux-wordpress

## 2023-02-28
## apparently when SELinux was introduced, it caused serious WP installation issues. these steps get around that without
## resorting to setting /etc/selinux/config “SELINUX=permissive”

## written from: https://www.tecmint.com/install-wordpress-rhel-apache/

dnf —assumeyes update ;

dnf —assumeyes install wget unzip ;

dnf —assumeyes install mariadb-server ;
dnf —assumeyes install httpd ;

## php 7.4 installation

dnf —assumeyes install http://rpms.remirepo.net/enterprise/remi-release-8.rpm ;
dnf —assumeyes module reset php ;
dnf —assumeyes module enable php:remi-7.4 ;

dnf —assumeyes install php-fpm php-cli php-common php-zip php-gd php-mcrypt php-mbstring php-curl php-xml php-pear php-bcmath php-json php-pdo php-mysql ;

systemctl enable —now mariadb.service ; ## —now is a new feature that MIGHT not work!
systemctl start mariadb.service ;

systemctl enable —now httpd.service ;
systemctl start httpd.service ;

systemctl enable —now php-fpm.service ;
systemctl start php-fpm.service ;

mysql —verbose <<END ; CREATE DATABASE `wpDb`; GRANT ALL ON `wpDb`.* TO ‘wpUser’@‘localhost’ IDENTIFIED BY ‘wpPassword’; FLUSH PRIVILEGES;
END

1. to test:
   mysql —user=wpUser —password=wpPassword wpDb < SHOW databases;
   SELECT VERSION;
   exit
   END

cd /var/www/html ;

firewall-cmd —zone=public —permanent —add-service=http ; firewall-cmd —reload ;

echo ‘‘ > phpinfo.php ; ## visit http://IP#/phpinfo.php to test

wget https://wordpress.org/latest.zip ;
unzip /var/www/html/latest.zip ;

mv —verbose ./wordpress/* /var/www/html/ ;
rmdir —verbose ./wordpress ;

/usr/bin/chown —recursive —verbose apache:apache /var/www/html/ ; ## omitted wordpress
/usr/bin/chcon —recursive —verbose —type=httpd_sys_rw_content_t /var/www/html/ ;

find /var/www/html -type d -exec chmod —verbose 755 {} ; ; find /var/www/html -type f -exec chmod —verbose 644 {} ; ;

/usr/sbin/semanage fcontext —add —type httpd_sys_rw_content_t “/var/www/html(/.*)?” ;
/usr/sbin/restorecon -R -v /var/www/html/ ;

echo “rebooting – be sure to go to http:/###.###.###.###/ and install wordpress!” ; /usr/sbin/shutdown —reboot now ;