Mark05e Tek

Had to mess around (add keys) with some Java keystore files for AACC Multimedia Email. Monitoring the output from the keytool command was boring. Keystore Explorer (http://www.keystore-explorer.org/) has a pretty decent interface to check this out.

Formatting Dates examples for reports. I got:

Faced issue with starting the service and also see the below error in the postgres logs.

runas /netonly /user:domain\username program.exe

Some portable ftp servers to use on the field when required.

Quick ‘n Easy FTP Server Lite

http://www.pablosoftwaresolutions.com/html/quick__n_easy_ftp_server_lite.html

CoreFTP mini-sftp-server

So I got into a bit of a trouble on a customer’s server which according to the customer, was not sending snmp traps. It took me a few tries to figure out that telnet will not work as it only works on TCP. Anyway, I did the following and able to verify if the ports were open between two servers.

Tool Required: Netcat - https://eternallybored.org/misc/netcat/ Snmptrapgen - http://www.snmpsoft.com/freetools/snmptrapgen.html

One server run netcat listening to udp port 162

C:\Users\Administrator\Desktop>nc -uvl -p 162

One server run snmptrapgen to send packet to first server

E:\Misc Tools\SnmpTrapGen>snmptrapgen.exe -r:192.168.10.15 -t:10 -to:.1.3.6.1.2.1.1.4.0

Details I get this error every night - 'One or more configuration history records have been altered' Problem Clarification

This is an Ignorable Alarm.

Add the following in the property entry “audit.suppress=true” in the .properties file

Cause

This is NOT a service impacting alarm.

Solution

Search for calls older than “Date of oldest call held on disk “ (Recorder Status > Server)

Replay that call. Find the replay entry on the acr.log file and note the inum value. Example:

acr.log 261680 2015-07-06 15:37:01,594 [http-bio-8080-exec-50] INFO  com.swhh.cs.servlets.ReplayAPIServlet - Replay request for inum: 812298043573298

Login to the Postgres database:

psql -U eware -p 6432

OPTIONAL: Enter \dt if you want to see list of tables.

eware=> \dt             List of relations Schema |       Name       | Type  | Owner --------+------------------+-------+------- public | alarms           | table | eware public | archives         | table | eware public | calls            | table | eware public | callsegments     | table | eware public | callsets         | table | eware public | confighistory    | table | eware public | cssegments       | table | eware public | fields           | table | eware public | jobqueue         | table | eware public | jobqueue_bkp     | table | eware public | layouts          | table | eware public | licencetokens    | table | eware public | media            | table | eware public | nonarchivedcalls | table | eware public | parties          | table | eware public | recordings       | table | eware public | sessions         | table | eware public | sessionstates    | table | eware public | settings         | table | eware public | stnranges        | table | eware public | strings          | table | eware public | tarinums         | table | eware public | tars             | table | eware public | udfnames         | table | eware public | udfs             | table | eware public | XXXXXXXXX        | table | eware public | userlayouts      | table | eware public | XXXXXXXXXXXXX    | table | eware public | userroles        | table | eware public | XXXXX            | table | eware (30 rows)

Enter the below select command to find the tar file.

eware=> select * from tarinums where inum=812298043573298;      inum       | recorderid | tarid -----------------+------------+------- 812298043573298 |     812298 | 65006 (1 row)

From the above query we can see that 65006 is our tar filename,

To see where this tar file is located, we search in the archives table.

eware=> select * from archives where archiveid=(select archiveid from tars where tarid=65006); archiveid |           path           | comment | archivetype -----------+--------------------------+---------+-------------         3 | \\ACRCIFS\RECORD\ACR\9 |         |           1 (1 row)

List all the connections by:

net use

Find the resource that is screwing up:

net use /delete \\MyServer\MyShare