rabatfirstsight

[rabatfirstsight]

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

use:

mvn -Dmaven.wagon.http.ssl.insecure=true -Dmaven.wagon.http.ssl.allowall=true clean install

[rabatfirstsight]

rabbitmq quickstart

download rabbitmq zip

download compatible erlang.exe

install erlang

in system variables add ERLANG_HOME and point to erlang installation directory (ex. C:\Program Files\Erlang OTP)

in system variables Path, add %ERLANG_HOME%\bin

unzip rabbitmq zip

go to sbin folder and open cmd prompt

in cmd prompt run > rabbitmq-plugins.bat enable rabbitmq_management

9. in (another) cmd prompt, start mq by running > rabbitmq-server.bat

10. after startup, open browser and access http://localhost:15672/

11. login as guest/guest

[rabatfirstsight]

JAX-RS ExceptionMapper

maps rest exceptions to responses.

[rabatfirstsight]

SQLException ORA-01502 partition of such index is in unusable state

reference: https://dba.stackexchange.com/questions/3754/ora-01502-index-or-partition-of-such-index-is-in-usable-state-problem

for DBA:

SELECT 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;' FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE';

for non-DBA:

SELECT 'ALTER INDEX ' || INDEX_NAME || ' REBUILD;' FROM USER_INDEXES WHERE STATUS = 'UNUSABLE';

[rabatfirstsight]

could not read maven project

in eclipse, on project > right-click > maven > update project > force update

[rabatfirstsight]

manual set cookie in browser

[rabatfirstsight]

waterproofing

prefer "polyurethane acrylic" for better uv and thermal resistance

[rabatfirstsight]

view tapo cam in vlc

create cam's user/pwd in tapo app device's settings

get cam ip address in the device's settings

in vlc, open network stream using url rtsp://ipAdd/stream1 for HQ feed; rtsp://ipAdd/stream2 for LQ feed. use user/pass from #1

reference:

How to view Tapo camera on PC/NAS/NVR through RTSP/Onvif Protocol | Tapo

TP-Link - Tapo - How to view Tapo camera on PC through RTSP stream? (ic.plus)

[rabatfirstsight]

URL percent encoding

If you want to use password with special character, like an exclamation mark, you need to use percent encoding which is often called URL encoding.

[rabatfirstsight]

server startup log

look for "started on port"

[rabatfirstsight]

spring boot tutorial recommendations

[rabatfirstsight]

add ldpa user

[rabatfirstsight]

mysql workbench logs location

C:\Users\userfolder\AppData\Roaming\MySQL\Workbench\log

[rabatfirstsight]

Liberty clear cache

Run:

./server start --clean

see https://jazz.net/forum/questions/213865/clm-on-was-liberty-how-to-clear-the-cache

[rabatfirstsight]

[ERROR] No plugin found for prefix 'versions' in the current project and in the plugin groups

error running => mvn versions:set

workaround ==> use full artifact coordinates based on pom.xml:

example: mvn org.codehaus.mojo:versions-maven-plugin:2.4:set

[rabatfirstsight]

Liberty server port config

in liberty\wlp\usr\servers\defaultServer\server.xml

[rabatfirstsight]

Create DB ER Diagram using MySQL Workbench

reference https://medium.com/@tushar0618/how-to-create-er-diagram-of-a-database-in-mysql-workbench-209fbf63fd03

ensure DB is present

click Database > Reverse Engineer

select stored connection and click Next

on Connect to DBMS completion, click Next

on Select Schemas page, select target schema and then Next

on Retrieve Objects completion, click Next

on Select Objects, keep target tables for the ER diagram ON THE LEFT panel. Tables moved to the right panel will be excluded.

keep "Import MySQL Table Objects" checked

keep "Place imported objects on a diagram" checked

after selecting tables, click Execute

on Reverse Engineering Progress completion, click Next

to create image, File > Export As Png