Marks Notes

easy port test with optional webserver

13 days ago

## easy port test:

## ON SERVER:

dnf —assumeyes install nmap ; ## in case this has not yet been installed! systemctl stop firewalld.service ; ## or make the particular port available! ls -l | /usr/bin/ncat —listen 10000 ; date | /usr/bin/ncat —listen 3030 ;

https://www.cyberciti.biz/faq/unix-linux-check-if-port-is-in-use-command/
lsof -i -P -n | grep LISTEN ; ## make sure ports are listening
netstat -tulpn | grep LISTEN ; ## another way to make sure ports are listening

## ON CLIENT:

telnet 123.123.123.123 10000 ; ## should give us the directory (or date) and then the ncat command on the server STOPS

## working fake webserver test:

https://jameshfisher.com/2018/12/31/how-to-make-a-webserver-with-netcat-nc/

these did NOT work for me:

(this one requires ‘screen’ whatever that is)
https://support.cpanel.net/hc/en-us/articles/4403282341143-How-to-use-ncat-netcat-as-a-mini-webserver-to-diagnose-network-connectivity-related-issues

https://stackoverflow.com/questions/16640054/minimal-web-server-using-netcat

— Mark Edwards

torguard settings to share account

52 days ago

settings (but not working quite yet)

185.242.5.91 (185.242.5.90 / Protocol: TCP / OpenVpn Port: 443 / OpenConnect Port: 22)
Mark (185.242.5.91 / Protocol: UDP / OpenVpn Port: 443 / OpenConnect Port: 22)

— Mark Edwards

Complete feathers in console

76 days ago

Instructions to run feathers completely from console, no coding!

IMPORTANT: open up a new tab “about:blank”

Click to open a new about:blank page.

Load the libraries

/* load in libraries */
[ 'https://cdnjs.cloudflare.com/ajax/libs/socket.io/2.0.4/socket.io.js'
, 'https://unpkg.com/@feathersjs/client@^3.0.0/dist/feathers.js'
].forEach( (src) => {
    let script = document.createElement('script'); 
            // script.setAttribute('crossOrigin',  'anonymous' );  /* optional  */
    script.src =  src;
            // script.type = 'javascript';   /*optional  */
    script.src = src; 
    script.async = false;
    document.head.appendChild(script);
});

alternative method:

/usr/bin/cat <<END  | ncat --listen 80 ;
<!DOCTYPE html>
<html lang="en-us">
<head>
  <script src='https://cdnjs.cloudflare.com/ajax/libs/socket.io/2.0.4/socket.io.js'></script>
  <script src='https://unpkg.com/@feathersjs/client@^3.0.0/dist/feathers.js'></script>
</head>
<body>
  fake webserver page.  include extra jScript code in the console.
</body>
</html>
END

initialize constants

/* initialize constants */
const app = feathers();
const socket = io();   /*  defaults to:    const socket = io('ws://localhost:3030');    */
const socket = io('ws://###.###.###.###:3030');   /*if we need to connect to different host */
app.configure(feathers.socketio(socket));     /* PLEASE dont skip this one!!  */
/*   -- or --   */
app.configure(feathers.socketio(io('ws://###.###.###.###:3030')));  /* just combine the last two lines */

create(POST)

/* create(POST) */

async function createTiny(name, address) {
let createResult
      = await app.service(‘tiny-connect’).create({ name: name, address: address });
    console.log(‘createTiny function result: ‘ + JSON.stringify(createResult) );
    return createResult;
};

createTiny(‘Mark Edwards’, ’123 Swallow Lane’).then((value) => { /* create(POST) */
    console.log(‘createTiny: ‘ + JSON.stringify(value));
})

get(GET) just one using the primary index

/* get(GET) (just one by index) */ 

async function getTiny(id) {   return await app.service(‘tiny-connect’).get(id);   };
—- or —-
async function getTiny(id) {      
  let getResult = await app.service(‘tiny-connect’).get(id); 
  console.log(‘getTiny function: ‘ + JSON.stringify(getResult) ); 
  return getResult; 
}; 
let getTinyResult = null; let key = 1;   // assuming your row ID is one
getTiny(key).then( value => {      /* get(GET) */ 
  getTinyResult = value; 
  console.log(‘getTiny(’ + key + ‘) : ‘ + JSON.stringify(getTinyResult) ); 
}); 
/* one line test:  */
(async () => { try { let result = await app.service(‘stimword’).get(1) ; console.log(‘the result is: ‘ + JSON.stringify(result)) } catch (e) { console.log(e); }  } )() ;
/* or:  */
(async () => { let logoutResult = await app.service(‘stimword’).get(2); console.log(logoutResult); })().catch(e => { console.log(e) });

find(GET) all or by query

 /* find(GET) (get all or by query) */ 

async function findTiny(query) {     
  return await app.service(‘tiny-connect’).find(query); 
};
async function findTiny(query) {     
  console.log(‘Query function using: ‘ + JSON.stringify(query) ); 
  let findResult = await app.service(‘tiny-connect’).find(query); 
  console.log(‘findTiny function: ‘ + JSON.stringify(findResult) ); 
  return findResult; 
};
let findTinyResultAll; 
findTiny(null).then((value) => {      /* find(GET) (find all) */ 
  findTinyResultAll = value; 
  console.log(‘findTiny without query: ‘ + JSON.stringify(findTinyResultAll) ); 
});
        /*  is this supposed to be  “where:”  or “query:”  ???????    */
let findTinyResultOne; let findDataObject = {where:{ id: 0}};     // again, assuming your id is zero!
findTiny(findDataObject).then((value) => {      /* find(GET) (with data )  */
  findTinyResultOne = value; 
  console.log(‘findTiny with query: ‘ + JSON.stringify(findTinyResultOne) ); 
}); 
/* shortcut examples:  */
(async () => { try { let result = await app.service(‘stimword’).find() ; console.log(‘the result is: ‘ + JSON.stringify(result)) } catch (e) { console.log(e); }  } )  () ;
(async () => { try { let result = await app.service(‘stimword’).find({‘query’:{‘stimwordWord’:‘horse’}}) ; console.log(‘the result is: ‘ + JSON.stringify(result)) } catch (e) { console.log(e); }  } )  () ;

Accessing a KNEX RAW selecxt

     SELECT    JSON_ARRAYAGG(
                  JSON_OBJECT(
                      ..........
                  )
                )  'JSON_ARRAYAGG'
  .....................................
const result = await knex.raw( sqlStatement, sqlQuery);
return result[0][0].JSON_ARRAYAGG   ;
...................................
var newResult;
(async () => { try { let result = await  app.service('raw-service').find({query: sqlQuery}) ; newResult = result; } catch (e) { console.log(e); }  } )() ;
console.log(JSON.parse(newResult));

patch(PATCH) to update row(s)

/* patch(PATCH) */ 

async function patchTiny(id, data, params) {      /* patch(PATCH) */ 
  let patchResult = await app.service(‘tiny-connect’).patch(id, data, params); 
  console.log(‘patchTiny function: ‘ + JSON.stringify(patchResult) ); 
  return patchResult; 

};

let patchResult = null; let patchKey = 0; let patchData = {address: ’5678 There Street!’ }; 
patchTiny(patchKey, patchData ).then( value => {      /* patch(PATCH) */ 
  patchResult = value; 
  console.log(‘patchResult: ‘ + JSON.stringify(patchResult)); 
});

— Mark Edwards

complete feathers knex

79 days ago

0 – When server is first initialized

latest node here: https://www.hostingadvice.com/how-to/update-node-js-latest-version/

    npm   install -g feathersjs/cli  ;     ###  or    --global
    npm   install feathersjs/cli -g ;    ### for generating apps  (notice g trails.... i think only this one actually works!
    npm   install @feathersjs/feathers --save  ;

1 – Initial installations

  systemctl stop firewalld;   ## or just authorize port 3030
  ##   --or---
  firewall-cmd --add-port=3030/tcp ;.
  ##   --- or----
  firewall-cmd --add-port=3030/tcp --permanent   ;
feathers generate app ;         ## notice that NO npm install's are used
feathers generate service ;   
     ## select 'objection'
     ### connection string should look like this:  "mysql://knexUser:knexPassword@localhost:3306/comptonTransAnlys"
DEBUG=* npm start ;   ## test that app starts successfully, optional DEBUG

2 – modify these files

./config/default.js

  "paginate": {
    "default": 0,
    "max": 0

./src/services/tester/tester.class.js

add actual table name and unique id column name

     model: Model
        ,  'name'  : 'marksTestTable'   ,   'id'  :   'marksTestTableAutoIncr'               // line added by mark!!

./src/models/tester.model.js

line 8: [specify REAL table name]

     static get tableName() {
       return 'marksTestTable';       // make SURE table name is correct !!  (had to remove underscores)
    }

line 14 old: [specify column names in array]

   required: ['text'],

line 17 new:

    required: ['columnOne', 'columnTwo'],    /* original:    required: ['text'],  */

line 17 old: [specify column types {type: ‘string’ } { type: ‘number’ } { type: ‘timestamp’} ]

    text: { type: 'string' }

line 17 new:

    'columnOne': { type: 'string' }   , 'columnTwo': { type: 'number' }    /* original:    text: { type: 'string' }  */

see: https://knexjs.org/guide/schema-builder.html#date

line 22: comment out lines: ( or add .slice(0, 19).replace(‘T’, ‘ ‘); to dates.)

    $beforeInsert() {
      /* original:    this.createdAt = this.updatedAt = new Date().toISOString();     */
           // or possibly add this:
            this.createdAt = this.updatedAt = new Date().toISOString().slice(0, 19).replace(‘T’, ‘ ‘);

    $beforeUpdate() {
      /* original:    this.updatedAt = new Date().toISOString();      */
       // or possibly add this:
        this.updatedAt = new Date().toISOString().slice(0, 19).replace(‘T’, ‘ ‘);

per https://stackoverflow.com/questions/5129624/convert-js-date-time-to-mysql-datetime

line 35: [ eliminate the ‘create table’ stuff ]

/* most likely db.schema.createTable can be SKIPPED unless a table actually needs to be created this way!   */
 const db =  app.get('knex');
 db.schema.hasTable('marksTestTable').then(exists => {
    if (!exists) {
             console.error('table marksTestTable  missing!');
                       /*
                      db.schema.createTable('shit', table => {
                        table.increments('id');
                        table.string('text');
                        table.timestamp('createdAt');
                        table.timestamp('updatedAt');
                      })
                     */
        .then(() => console.log('Created shit table')) // eslint-disable-line no-console
        .catch(e => console.error('Error creating shit table', e)); // eslint-disable-line no-console
    }
  })
    .catch(e => console.error('Error creating shit table', e)); // eslint-disable-line no-console

it should ONLY contain:

module.exports = function (app) {
  return [class name];
}

3 – Start the app

DEBUG=* npm start ;   ## run the app, optional DEBUG

4 -Test the app

DONT USE “PUT”, USE “PATCH” INSTEAD!


Postman:     Body—->x-www-form-url-urlencoded    to POST (create)

POST:   http://192.168.123.220:3030/teachers?lastName=Edwards&firstName=Lori  (create)

PATCH:  http://192.168.123.220:3030/teachers/2/?firstName=Marky                    (update)

POST – http://192.168.123.220:3030/tester?columnOne=Column One Value&columnTwo=Column Two Value   (add new value)

GET – http://192.168.123.220:3030/tester/1/  (                                                  get by primary id)

GET – http://192.168.123.220:3030/tester/?columnOne=column One Value    (find by column value)

GET (find) – be sure “Body—>xx-www-form-urlencode” is blank

GET (get)  – be sure “Params” is blank

PATCH – be SURE “Params” is blank, only use “Body—>xx-www-form-urlencode”

## a complicated one!

http://192.168.123.220:3030/tester/  
  ? testerAutoIncr=1  
  & $select[]=columnTwo   
  & $select[]=columnOne  
  & $sort[columnOne]=-1

## will produce:  

## select `columnTwo`, `columnOne`, `tester`.`testerAutoIncr` from `tester` where `testerAutoIncr` = ? order by `columnOne` 

##     https://stackoverflow.com/questions/11889997/how-to-send-an-array-in-url-request/11890080#11890080

##   ?  col⁰ = val1 & col¹  =  val2 & col²  =  val3 

## will produce:

##  WHERE col= ‘val1’ OR col=‘val2’ OR col=‘val3’


###  reference:  https://dove.feathersjs.com/api/databases/querying.html#select

5 – Create a “before” hook to manipulate the SELECT statement.



feathers “before” hook:

./src/hooks/tester.js
    // Use this hook to manipulate incoming or outgoing data.
    // For more information on hooks see: http://docs.feathersjs.com/api/hooks.html

    // eslint-disable-next-line no-unused-vars
    module.exports = (options = {}) => {
      return async context => {
        context.params.query = {                          // added by mark
          …context.params.query,                         // added by mark
          $select: [‘columnTwo’,‘columnOne’],       // added by mark
          $sort: { ‘columnOne’ : 1 }                        // added by mark
        }                                                                // added by mark
        return context;
      };
    };



==========================================================


#####################npm   init —yes                                            ;

################npm   install @feathersjs/feathers —save   ;

#########   ????????  npm   install knex  —save                           ;

############npm   install feathers-knex  —save             ;



— Mark Edwards

, 






wordpress wildcard not working


83 days ago


problem:   jfbmusic.comptonpesltrainers.com  forwards to an error page

solution:

1) turn  OFF   vpn

2) cache flush


— Mark Edwards

,