Why seg0 is so big? MirthConnect , derby -> PostgreSQL + Mirth

Because : 

https://forums.mirthproject.io/forum/mirth-connect/support/12368-why-seg0-is-so-big

he seg0 is too big!One of the files(*.dat) in it is about 90+G suddenly one day
.The mirth is running in the computer in a hospital.I am a beginner in Mirth.Please help me!
The files(*.bat) are in "D:\Mirth Connect\appdata\mirthdb\seg0".

Pruning can certainly help reduce the size of your database, yes. Make sure to actually enable pruning on the Data Pruner settings view (Message Pruner in 2.x). However, pruning does not shrink the database disk size. For that you will still need to vacuum. If you were using PostgreSQL, then TRUNCATE statements should auto-shrink database sizes (which is what happens when you Delete All Messages for a channel).

Solution : 

Install : https://consultzen.com/webinars-replacing_the_database/

Setting : 

 https://stackoverflow.com/questions/28573486/mirth-connect-is-it-safe-to-drop-the-old-messages-table-after-upgrading-to-ver

The same thing happened to me after upgrading from Mirth Connect 2 to 3. The old_message table took a lot of disk space and I didn't need the messages anymore. I truncated the old_message table and it did not have any adverse effects in Mirth Connect.

We are using Postgres instead of MySQL, but the truncate syntax is the same.

# ./psql mirthdb postgres
psql (9.0.13)
Type "help" for help.

mirthdb=# TRUNCATE TABLE old_message;
TRUNCATE TABLE
mirthdb=#

NTP service on windows 2016 for cisco device

 https://belajarcomputernetwork.com/2014/01/25/configure-windows-server-as-ntp-server/

https://www.meinbergglobal.com/english/sw/#win

How to stop Firefox from making automatic connections

 https://support.mozilla.org/en-US/kb/how-stop-firefox-making-automatic-connections

2.4 Ghz vs 5Ghz wifi

 https://www.digikey.hk/en/articles/compare-24-ghz-5-ghz-wireless-lan-industrial-applications

sl230 fix

rear break

https://ameblo.jp/tankoro2019/entry-12469163864.html

Cisco 3702i Web GUI does not work + CCA

 https://community.cisco.com/t5/wireless-and-mobility/cisco-cap3702i-web-gui-does-not-work/td-p/3874532

 

How to take ownership of files and folders

1.    Open File Explorer.

2.    Browse and find the file or folder you want to have full access.

3.    Right-click it, and select Properties.

4.    Click the Security tab to access the NTFS permissions.

5.    Click the Advanced button.

6.    On the "Advanced Security Settings" page, you need to click the Change link, in the Owner's field.

更多項目...

•

2016年9月28日

How to take ownership of files and folders on Windows 10 ...

 

 

First things first, make sure you have the latest version of java installed.

 

If that doesn't work, a lot of users find success by modifying a configuration file in the path,

C:\Program Files\Cisco Systems\Cisco Network Assistant\startup\startup.properties

using a text editor like notepad and change this specific line, from

"JVM_MAXIMUM_HEAP=1024m" 

to

"JVM_MAXIMUM_HEAP=512m" 

 

 

 

 

excel interface with python , openyxl

 first need to install the openyxl

https://zhuanlan.zhihu.com/p/61234249

https://medium.com/@will.wang/%E6%92%A5%E9%96%8B-python-pip-site-packages-%E7%9A%84%E8%97%8D%E8%89%B2%E8%9C%98%E8%9B%9B%E7%B6%B2-90e398bb3785

1. install anaconda 

2.To install this package with conda run:

conda install -c anaconda openpyxl

https://anaconda.org/anaconda/openpyxl

2.1 出error , 

(base) C:\Users\ham>conda -V

conda 4.8.3

(base) C:\Users\homartin>conda install -c anaconda openpyxl

Collecting package metadata (current_repodata.json): done

3. follow https://automatetheboringstuff.com/chapter12/

4. python vlookup function of two excel by pandas

GPUpdate /force everytime

 https://community.spiceworks.com/topic/355881-gpupdate-force-everytime

GUIn00b

Thai Pepper

GUIn00b

Jul 6, 2013 at 4:57 AM

I put this batch script called gpupdate_noreboot.bat on a network share:

gpupdate /force /wait:60

and then deployed a Scheduled Task to all computers through Group Policy so I can run it on demand.  That way I can just use the task scheduler from the command prompt targeting whatever computer I want to gpupdate.  I also made some other batch scripts to run the task en masse.  Totally free.

Example:

schtasks /run /s COMPUTERNAME /tn gpupdate_noreboot

MSSQL Reporting Server Services

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/174d4eb1-d4dc-46de-9223-23d063894233/how-to-start-and-stop-ssrs-services-using-windows-scheduler?forum=sqlreportingservices

More help is available by typing NET HELPMSG 2185.


C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\R
eportServer\bin>
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\R
eportServer\bin>net stop ReportServer
The SQL Server Reporting Services (MSSQLSERVER) service is stopping.
The SQL Server Reporting Services (MSSQLSERVER) service was stopped successfully
.


C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\R
eportServer\bin>net start ReportServer
The SQL Server Reporting Services (MSSQLSERVER) service is starting..
The SQL Server Reporting Services (MSSQLSERVER) service was started successfully
.


C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\R
eportServer\bin>

Enabling SNMP in Cisco Routers / Switches

https://www.manageengine.com/products/oputils/enable-snmp-cisco-router.html

snmp-server host  MAC-Notification

https://enotepad.wordpress.com/2008/08/17/logging-any-new-mac-addresses/

https://www.manageengine.com/products/mibbrowser-free-tool/documents.html

https://fortinetweb.s3.amazonaws.com/docs.fortinet.com/v2/attachments/be7fcde9-9685-11e9-81a4-00505692583a/Configuring_Traps_for_MAC_Notification.pdf

MASS DATA-ENTRY AND TRANSFER BETWEEN TWO INCOMPATIBLE APPLICATIONS, OR FROM A WINDOWS APPLICATION TO A WEBSITE.

MASS DATA-ENTRY AND TRANSFER BETWEEN TWO INCOMPATIBLE APPLICATIONS, OR FROM A WINDOWS APPLICATION TO A WEBSITE.

Intelligently copy data from one application to another.
Automate Data entry into any application or web form.
A utomate data entry at high speeds, or copy data from one application to another.
“We are an IT Integrator working a project with a manufacturing company to implement an ERP system to replace their home-grown system. The plan is to have both systems running 3-6 months before powering off the home-grown. Hence, there is a need to populate data from one system to another to avoid double input and error. Since I have heard about WinTask before (from associates), therefore, we used your software for this purpose.”

“I use WinTask to take data in an excel spreadsheet and perform data entry into my accounting system. As my spreadsheet lists 1000 items that need to be entered, the automation script saves a lot of time.”

“I needed to replicate some keystrokes several thousand times. Your software allowed me to do that quite easily.”

“Each institution has to build information having its systems as source. Then, they need to enter then in a browser form (!!!!) manually. Super Wintask does the work. It reads the input file, generally in access, enters information and navigates though the browser, built a log, and at the end generates an input for other system.”

https://assistantcomputercontrol.com/

https://assistantcomputercontrol.com/

use Dropbox instead of Google Drive for middeware of command

most active

0) https://discordapp.com/channels/412587078992265216/412587966825758730

1) https://assistantcomputercontrol.com/

2) https://acc.readme.io/

3) https://github.com/AlbertMN/AssistantComputerControl/

Example in discordapp for ACC

Google Assistant -> IFTTT -> cmd -> Google Drive -> local AssistantComputerControl

Google Assistant -> IFTTT -> cmd -> Google Drive -> local AssistantComputerControl

alternative to http://triggercmd.com

Google Assistant (iphone )

https://assistantcomputercontrol.com/

Hint : trouble shooting your setup :

https://ifttt.com/my_applets

allow ( access to your google drive "AssistantComputerControl" folder)

allow interpret Google Assistant command that trigger from phone ( iphone my case)

A) Finial Download the command applet on https://assistantcomputercontrol.com/action/mute

B) Learn more there https://acc.readme.io/docs/how-to-use-the-open-action

C) write_out function : https://acc.readme.io/docs/actions

Github reference : https://github.com/AlbertMN/AssistantComputerControl/issues/49

write_out log file of ACC

C) below screen capture typo . Left side Google Drive , then right side should search ACC Google Drive , not ACC (Drop Box) applets

his page explains how to do web scraping with Selenium IDE commands. Web scraping works if the data is inside the HTML of a website. If you want to extract data from a PDF, image or video you need to use visual screen scraping instead.

https://superuser.com/questions/1172697/specific-webpages-field-fill-up-with-autohotkey-based-pulovers-macro-creator

But you can automate the same task with Kantu. This web automation browser is based on Google Chromium and works well for automatically changing settings on my router's internal web pages.

Web Scraping with Selenium IDE

his page explains how to do web scraping with Selenium IDE commands. Web scraping works if the data is inside the HTML of a website. If you want to extract data from a PDF, image or video you need to use visual screen scraping instead.

https://ui.vision/rpa/docs/selenium-ide/web-scraping

cisco switch 3750 port mirroring

https://www.cisco.com/c/en/us/td/docs/switches/lan/catalyst3750/software/release/12-2_52_se/configuration/guide/3750scg/swspan.html
Switch(config)#monitor session 1 source int
Switch(config)#monitor session 1 source interface f
Switch(config)#monitor session 1 source interface fastEthernet 1/0/1
Switch(config)#mo
Switch(config)#monitor es
Switch(config)#monitor se
Switch(config)#monitor session 1 de
Switch(config)#monitor session 1 destination in
Switch(config)#monitor session 1 destination interface fa
Switch(config)#monitor session 1 destination interface fastEthernet 1/0/2 en
Switch(config)#$tination interface fastEthernet 1/0/2 encapsulation re
Switch(config)#$nterface fastEthernet 1/0/2 encapsulation replicate
Switch(config)#
Switch(config)#mon
Switch(config)#monitor se
Switch(config)#monitor session 2 sou
Switch(config)#monitor session 2 source in
Switch(config)#monitor session 2 source interface fa
Switch(config)#monitor session 2 source interface fastEthernet 1/0/3
Switch(config)#mo
Switch(config)#monitor se
Switch(config)#monitor session 2 de
Switch(config)#monitor session 2 destination int
Switch(config)#monitor session 2 destination interface fa
Switch(config)#monitor session 2 destination interface fastEthernet 1/0/4 e
Switch(config)#$tination interface fastEthernet 1/0/4 encapsulation re
Switch(config)#$nterface fastEthernet 1/0/4 encapsulation replicate
Switch(config)#exit
Switch#
00:48:50: %SYS-5-CONFIG_I: Configured from console by console
00:51:40: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet1/0/1, changed state to down
00:51:41: %LINK-3-UPDOWN: Interface FastEthernet1/0/1, changed state to down
00:51:48: %LINK-3-UPDOWN: Interface FastEthernet1/0/1, changed state to up
00:51:49: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet1/0/1, changed state to up
00:52:25: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet1/0/1, changed state to down
00:52:26: %LINK-3-UPDOWN: Interface FastEthernet1/0/1, changed state to down
00:52:32: %LINEPROTO-5-UPDOWN: Line protocol on Interface FastEthernet1/0/3, changed state to down
00:52:32: %LINEPROTO-5-UPDOWN: Line protocol on Interface Vlan191, changed state to down
00:52:33: %LINK-3-UPDOWN: Interface FastEthernet1/0/3, changed state to down
Switch#
Switch#
Switch#no
Switch#no
% Incomplete command.

Switch#
Switch#no mo
Switch#sh mo
Switch#sh monitor se
Switch#sh monitor session 1
Session 1
---------
Type              : Local Session
Source Ports      :
    Both          : Fa1/0/1
Destination Ports : Fa1/0/2
    Encapsulation : Replicate
          Ingress : Disabled


Switch#sh monitor session 2
Session 2
---------
Type              : Local Session
Source Ports      :
    Both          : Fa1/0/3
Destination Ports : Fa1/0/4
    Encapsulation : Replicate
          Ingress : Disabled


Switch#conf t
Enter configuration commands, one per line.  End with CNTL/Z.
Switch(config)#not
Switch(config)#no mo
Switch(config)#no monitor se
Switch(config)#no monitor session 1
Switch(config)#no monitor session 2
Switch(config)#exit
Switch#

Godaddy and G Suite

n this case, our services scope will be like this:

1. G Suite Business - 3 user - USD6*3 users*12 months = USD216/year, ~HKD1695/year depends on actual exchange rate.

2. GoDaddy/Namecheap domain registration fee for sinotopper.cc - Around USD20/year depends on actual availability

3. One-time setup fee for Domain application, Domain MX record setup, G Suite Account application, G Suite Domain Verification - HKD2800

4. (Optional) G Suite users account creation, G Suite training materials, Email/Tel. Technical Support services, Mailbox migration consultation support - HKD19999/year (Optional)



Why not me do that ?

Failed domain verification?



https://medium.com/@kvnsanghvi/my-experience-on-smtp-with-g-suite-1-4216b79eb366

Monitoring Ip address (MAC) on which cisco switch port for the movement checking

https://networkengineering.stackexchange.com/questions/9301/finding-non-cisco-end-device-ip-addresses-connected-to-cisco-switch