Mark05e Tek

[mark05e-tek]

Scene Releases

All archive file have password the generic password is www.webscene.ir

[mark05e-tek]

We develop highest quality software to simplify Computer usage

Bunch of tools similar to Nirsoft and Sysinternals.

[mark05e-tek]

Keystore Explorer

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.

... And its free!

[mark05e-tek]

Posts about BusinessObjects written by ibusinessintelligence

Formatting Dates examples for reports. I got:

=FormatDate(CurrentDate();”Dddd dd Mmmm yyyy hh:mm”)

[mark05e-tek]

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

ERROR: storage sync failed on magnetic disk: Permission denied

[mark05e-tek]

How do I know the script file name in a Bash script?

How can I determine the name of the Bash script file inside the script itself? Like if my script is in file runme.sh, then how would I make it to display "You are running runme.sh" message without

[mark05e-tek]

Conntect different Windows user in SQL Management Studio

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

Reference: http://stackoverflow.com/questions/849149/connect-different-windows-user-in-sql-server-management-studio-2005-or-later

[mark05e-tek]

[mark05e-tek]

FTP Servers

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

http://www.coreftp.com/server/download/msftpsrvr.exe

[mark05e-tek]

Verifying open UDP ports

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

You should be able to verify that the port is open on either side depending on the test.

[mark05e-tek]

PostgreSQL Tutorial - Learn PostgreSQL from basic to advanced covering database programming, select, insert, update, like, with, having, group by, limit, like, distinct clauses, operators, expressions, functions administration queries and usage along with php, perl, c, c++ and java in simple steps.

Pretty decent tutorial page on figuring out PSQL queries.

[mark05e-tek]

Avaya Contact Recorder v12 - One or more configuration history records have been altered

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

If audit.suppress=true doesn't work then, wait for 30 days after which it would stop appearing.

[mark05e-tek]

Avaya Contact Recorder v12 - Find tar file on external storage location

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)

You can see the path from the query and over there we should be able to find the .tar file.

[mark05e-tek]

BulkFileChanger is a small utility that allows you to create files list from multiple folders, and then make some action on them - Modify their created/modified/accessed time, change their file attribute (Read Only, Hidden, System), run an executable with these files as parameter, and copy/cut paste into Explorer.

http://www.nirsoft.net/utils/bulk_file_changer.html

[mark05e-tek]

Windows: The Network folder specified is currently mapped using a different user name and password

List all the connections by:

net use

Find the resource that is screwing up:

net use /delete \\MyServer\MyShare

Reference: http://travisepperson.blogspot.com/2007/01/windows-network-folder-specified-is.html