V-antena and Tanimoto's page



月: 2016年4月


1.Remote debug
2.Heap memory monitor
// visualVM and jstatd

CATALINA_OPTS=”-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.por
-Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremot

There were many ufw block logs in syslog, ufw.log and messages under /var/log/
,like as
Apr 15 16:29:05 raspberrypi kernel: [2831949.081700] [UFW BLOCK] IN=wlan0 OUT= MAC=xxxxxxxxxxxxxxxx SRC=IP address of router DST= LEN=28 TOS=0x00 PREC=0xC0 TTL=1 ID=28502 PROTO=2

Work around:
$ sudo ufw allow in from ‘IP address of router’ to
$ sudo ufw block in from ‘IP address of router’ to

Another garbage was like as
Apr 15 16:41:44 raspberrypi rsyslogd-2007: action ‘action 18’ suspended, next retry bla bla bla

Work around:
$ sudo nano /etc/rsyslog.conf

Comment out of rear part such as
#.=notice;.=warn |/dev/xconsole

then reboot

wordpress 用のデータをバックアップするためにExpectを使ってバックアップのためのス
クリプトを作ったので掲載。 後はcronで自動実行。
To backup wordpress data easily, I created a script with Expect and post it to
this site.

‘ install method in debian, ubuntu, raspbian
$ sudo apt-get install expect

――――from here―――――――――――――――――-
set timeout 300
spawn sudo scp -r aaa@192.168.xxx.yyy:/abc /backups/xxx
expect “aaa@192.168.xxx.yyy’s password:”
send “password\n”
expect “aaa@hostname ~ $”
spawn sudo scp -r aaa@192.168.xxx.yyy:/defg /backups/xxx
expect “aaa@192.168.xxx.yyy’s password:”
send “password\n”
expect “aaa@hostname ~ $”
spawn sudo scp -r bbb@192.168.zzz.uuu:/abc /backups/zzz
expect “bbb@192.168.zzz.uuu’s password:”
send “password2\n”
expect “bbb@hostname2 ~ $”
exit 0
――――――― until here―――――――――?

aaa, bbb, xxx, yyy, abc, defg, abc, hostname, hostname2 are
dummy just for open for public.


This article explains methods of [1. automatic build scatter chart independent f
rom record size (# of rows)], [2. display the plot of a specific record (top r
ow) with a different color], [3. Identification and indication about the record
of the selected plot]

data sheet
=COUNTA($A$3:$A$10000) | |
record | dat1 | dat2 | dat3 | dat4 |
id1 | 1.18 | 2.11 | 0.97 | 1.63 |
id2 | 1.26 | 1.41 | 1.27 | 4.71 |
id3 | 1.24 | 2.52 | 1.38 | 2.26 |
id4 | 1.47 | 2.02 | 1.29 | 3.92 |

scatter sheet ( two scatter charts)


  1. automatic build scatter chart independently from record size

a) register names columns by using CTL+F3 and OFFSET function
e.g. name: val1
ref. range : =OFFSET(data!$B$3,0,0,data!$A$1,1)
name: val2
ref.range : = OFFSET(data!$c$3,0,0,data!$A$1,1)

b) create scatter chart with data range settings like as following e.g.
x series value: =data!val1
y series value: =data!val2


  1. display the plot of top row with a different color

This method is simple.
Just add a data series with top record row , then overwrite the graph with this
e.g. series name: = “head_object”
x series value: =data!$b$3
y series value: =data!$c$3


  1. Identification and indication about the record of the selected plot

I implemented this functionality with VBA.
a) create a class module
e.g. chart_event
b) write code in the chart_event module.

Option Explicit
Public WithEvents scatterchart As Chart
Private Sub scatterchart_Select(ByVal ElementID As Long, ByVal x As Long, ByVal
y As Long)
‘ I don’t know ,but getChartElement was not necessary
‘ x is series index, y is plot index
If (ElementID = xlSeries) And (y <> -1) Then MsgBox Worksheets(“Data”).Cells(2 +
y, 1).Value()
End Sub

c) write code in a standard module
e.g. (in this case : enableplot is a macro activated by a button)

Dim scattercharts(1) As New chart_event
‘ don’t forget “new”
Sub enableplot()
‘ Keep the order of “dim” senetense and “sub” sentense
‘ if “sub” ? “dim” order, events are not captured
Set scattercharts(0).scatterchart = Worksheets(“scatter_chart”).ChartObjects(1).
Set scattercharts(1).scatterchart = Worksheets(“scatter_chart”).ChartObjects(2).
End Sub

d) put a button as control on scatterchart sheet and bind this button to the “en
ableplot” sub procedure

V-antena and Tanimoto's page