CYBER-ATTACKS :- We’re too late! Engage clocking device then notify the fleet and return to base.

May 17, 2017 2 comments

CYBER-ATTACKS

We’re too late! Engage clocking device then notify the fleet and return to base.

Future cyber-attacks won’t be done by man. Cyber-attacks will be performed by AI.  Various AI trained by machine learning will vulnerability check and then drop helper bots on vulnerable networks and computers along the way.  Undetected, these additional bots will further the attack by increasing the depth and breadth that gives worldwide impact to such attacks. Quite possibly it will run on one of the major cloud platforms where global staging of bits that do the damage are housed and can go undetected for a long time.  Not only are they asking for ransom but the biggest ransomed users will start demanding global ID’s in hopes of stopping these types of attacks. In fact I believe that the attacks will increase until that nefarious plan succeeds.  Granted, personal activities that are initiated by you either via an email link, or some other source of link, or do some kind of application install causes most of the issues.  But not all.  More education in this area would help.

Not only will these attacks continue, but the online games that millions of kids of varying ages use every day, have live chat rooms.

Why is that important? And, how does that relate to cyber-attacks?

Chat rooms are being used in games to organize others as groups in the games and to make trades for items gathered during game play. That’s easy enough. But, with young kids for the thought of getting extra game items or items for free, will click on, download and install some application only to find out their password was stolen, game assets drained and have been locked out of their account. Not quite the same as recent cyber-attacks that have struck around the world, but a personal attack nevertheless and ones that often go unreported. And, just maybe a yet to be detected bot?  (Parental setup and security control of a kid’s computer is another topic)

Most online games and platforms for game play state that those under certain age should not have access unless they have their legal guardian’s permission.  I wonder how many pass up reading the access rules!  Kids seem to have more computer knowledge than parents and many don’t bother following up after setting up a kid on a platform.  A lot use Facebook whom are under the age of 18. The smart kids will gain access quite easily.

This should bother everyone.   Kids really don’t know how old or who the person’s on the other end of the chat are. Their susceptible to screen chatter and are not on the guard when someone might be asking probing questions such as do you have pets. What’s your school’s mascot name? Etc, add your own and it can be scary indeed. The social engineering aspect that kids face can be challenging.  They exist and everyone has vulnerabilities.

Kids are now playing augmented reality games on smart devices and as the games move to 3d glasses, uncontrolled augmented reality games could be a catalyst for cyberattacks.  Couldn’t it? Meet me at the cemetery our job is to grave rob.  The prize is located 6 feet down and looks like a sack of shingles If found will be worth 20,000 bit coins.  Hey we’re having a 100 person march tonight in support of macaroni and cheese school lunch Thursdays. Meet us at the school with a can of orange paint for a chance for a secret Santa surprise.

Perhaps none of this will be like that if we’re aware and teach our kids. But what if things like that have happened and are continuing to happen?

I mean parents can’t sit and watch everything a kid does online or can they?  Are you a parent with school age kids?  Kids that use the internet that play games such as ROBLOX.COM? And, other free online games?  They are fun but I would be very concerned if you did not check into and understand what these online games are.   As mentioned most have chat rooms to communicate with others in a game. But, kids really don’t know how old the persons on the other end of the chat are. Maybe an AI Trained chat bot that we help train!! Nice. And, that has recently happened.

Some possible solutions.

  1. Create automatic sandboxes for running games either on desktop or place browser functionality into a sandbox no matter who the vendor of the browser.
  2. Deliver all email with links and active content turned off by default.
  3. Allow easier access to mail headers and provide mail header tracing for validation and research.
  4. Remove cross site cookie tracking and web beacons. Less tracking would eliminate targeted threats.
  5. Allow 3d glasses to work only within 20 feet of a matched base station.
  6. A drive for personal photos and documents that could never be used or locked by unauthorized sources. Cloud as backup perhaps?
  7. Two factor authentication where the parent receives the code to login. Could be too much but is a good idea if it would work.
  8. And, while not mentioned above fix IoT security. This will help as well.

However, removing tracking will be difficult as it generates millions of dollars for advertisers. Media watching and usage changes are taking the industry by storm. Many have given up cable and are doing so at a rapid pace.  Desktop usage has gone down as users become more mobile.  Advertisers large and small still need a way to push advertisements to consumers.

Just a few years ago bandwidth was more expensive and users did not want all the extra ads being displayed.  Application availability was sparse and not many that good. Bubble popper was my favorite and could be heard in many restrooms.  Now at the speed of thought and light our devices via tracking, application usage, site participation with voice activation and weather are presenting the prepared “Just For You” items that tracks across owned devices.  The metrics!!! Damn, the metrics.

We all need knowledge of how to protect ourselves and our families in the digital age from current and future cyber-attacks.   The rapidly changing false headlines this past year could have been a cyber attack. Couldn’t it?  Makes us all Wanna Cry.

Perspective is what it is.

3D ART :- Never Stop Reaching

I’ve been a long time fan of Robert Browning’s work and this is one of my favorite quotes from his collection.

“Ah, but a man’s reach should exceed his grasp, Or what’s a heaven for?” Robert Browning

A quote by me. “Stung by imaginations melded glory, pulled and connected life’s odd demeanor. As I alone amongst the stars grasp at life’s curiosities”… #kravis

So many people give up with each small obstacle they face. Those small obstacles add up if you don’t deal with them appropriately on your way to the big picture dream.  I use to count myself in with that group of people. However, I’ve always been dreaming and I’ve been grasping and reaching. I’m still trying and will never give up!

My commitment is to Self in order to become a better me for you. 🙂

Joseph

3D ART :- The Night Is Still Young

3D ART :- The Night Is Still Young

This is a little of everything.  I bought an item from renderosity from artist EDART3D (off site link  https://www.renderosity.com/mod/bcs/?ViewProduct=118117) and they in turn gave me a free copy of this character with cool face designs. And, some items from DAZ3d of course my own photography is included.  Image was simple in nature, just made sure that the pose and all the items worked well together.

As I put this image together it kind of reminded me of Halle Berry as Jinx in the James Bond movie “Die Another Day”.

Joseph Kravis

The Night Is Still Young!

“To me, every hour of the day and night is an unspeakably perfect miracle.”
Walt Whitman

3D ART :- Porcelain I’m Fragile

3D ART :- Porcelain I’m Fragile

If we’re so fragile we’ll never know or have the opportunity to expand and grow. Using downtime for quite reflection can help
achieve many wondrous things. The ability to understand and work on our frailties is something we all need.  I’m learning
that it’s OK to make mistakes, learn from it and move on. Wishing the same for you as well.

“I love those who can smile in trouble, who can gather strength from distress, and grow brave by reflection. ‘Tis the business of little minds to shrink, but they whose heart is firm, and whose conscience approves their conduct, will pursue their principles unto death.”
Leonardo da Vinci

3D ART :- In The Park

3D ART :- In The Park

Spring brings out all the flowers.

“The beauty of a woman must be seen from in her eyes, because that is the doorway to her heart, the place where love resides.”
Audrey Hepburn

SQL :- Many Flavors (PostGreSQL).

SQL :- Many Flavors (PostGreSQL).

Recently I installed PostGreSQL on windows so, I can work on a little project that I’ve been wanting to do.  The objective was to learn PostgreSQL and since I’ve started to dig into the free software DAZ Studios (DAZ3D) I wanted a better understanding of the data in the tables and wanted to be able to learn various configurations of PostgreSQL,
By default DAZ Studio installs pgAdmin3 LTS as the graphical interface manager. But, there is a new pgAdmin4 1.4 that I’ll eventually be switching too for viewing data tables.  For now as pgAdmin30 is out I’ll use that for this article mainly because that’s what DAZ Studio utilizes.  After all items are connected I’ll show you how to create  external  connections via ODBCmanager for 32bit and 64bit connections. With those connections, I’ll show you how to connect to Excel and SSRS reporting. I’m keeping the examples short for now and in the future I will be posting more complex ideas and samples of how to work with the data to enhance more control over content management.

Installed PostgreSQL By DAZ

It is not necessary to actually download PostgreSQL as DAZ Studio installs a version in to the default setup as in the below image. I won’t go over DAZ Studio setup here.

And, to run the PostgreSQL graphical interface program you can select the pgAdmine3.exe

Download and Install PostgreSQL

If you want more power then what the DAZ studio installed version you can download
and install from here.

DAZ STUDIO CMS Version

Once you get here with your installation or DAZ defaults, you will need to connect PostgreSQL to your DAZ content database. From within DAZ studio you can find the
default port that DAZ Studio has used for setup. I’ve kept things at the default but you can change to suit your environment.
To get the port number to use for PostgreSQL for DAZ Studio select Edit preferences or “F2”. Select the CMS Settings tab and you’ll see the installation folder and the Port number that daz uses to communicate with the database.

To connect PostgreSQL to DAZ Studio I’ll keep the default port at 17237.
Although I’ve already connected to DAZ3D CMS database in this image, the application displayed should look like this.

Next we will want to add a new server in this case is 127.0.0.1 which is the local machine.

Fill out the values like this. If you want a password on the database you can add one here.
I named my Server “MyDaz” and used the user name of “dzcms” a name to use that I found
on DAZ3d forums.

After setup if you’re not familiar with PostgreSQL make sure you use DAZ Studio Interface to backup your database.

DAZ Studio Query Tables

To show connectivity is working I’ll show you a couple quick methods for displaying data from within tables without major coding. 🙂
From the PostgreSQL interface you can choose to view rows

Selected Content Table Rows (100 rows) is the default. On real large databases you’ll want to limit the number of results returned.

And, you want to select rows it’s similar with a slightly different interface. Select the “Select Script”

Just a few ways to query the data in the tables.

PostgreSQL ODBC Driver Installation

To access PostgreSQL form other windows applications you will need to install ODBC drivers  for PostgreSQL for both 32/64bit versions.

You can find them at https://odbc.postgresql.org/
And since I’m running 64bit windows I’ll just download the MSI version for now and the 32bit if required.  And, I’ve downloaded the code so I can see how it is constructed.  https://www.postgresql.org/ftp/odbc/versions/msi/ get both
Psqlodbc_09_06_0200-x86.zip and Psqlodbc_09_06_0200-x64.zip as I’ve noticed that some apps that I’ve tried to connect with like 32bit versus the 64bit version.

Download and virus checked.  And, unzipped into a folder. Always read the readme file.
PSQLODBC.DLL – A library to talk to the PostgreSQL DBMS using ODBC.

ODBC Setup Screens

Select Next

Select Check BOX- Select Next

Select to install documentation or just select next.

Select Install

After installation complete select Finish.

Both installations for 32/64bit follow the same installation and setup style.

Create DSN for ODBC driver assocation

You can search for this “What is a DSN (Data Source Name)?” or go to this link https://support.microsoft.com/en-us/help/966849/what-is-a-dsn-data-source-name
further explanation of what a “DSN” name is.

From windows “RUN” type the following for 64BIT  DSN creation.

I chose Unicode for my DSN.

From windows “RUN” type the following for 32BIT  DSN creation.

When you select finish you can create your DSN name that will be used in other applications.

The name of the database is defined when you connect using pgAdmin3. The ports, server name and user name are the same as used

for PostgreSQL database attachment.

You can actually create this with corresponding names based on 32/64bit naming conventions.

Using “DSN” created in Excel

After you open up a new sheet in Excel, select item “From Other Sources” located on the “Data Tab”

We can select the “From Data Connection Wizard” and from there select the ODBC DSN.

Select next after ODBC DSN

What is nice about this method we get a list of tables that we can work with.

Joseph Kravis

Select a table

Choosing next gives us this screen.

Review make adjustments if needed and select Finish

You can paste into existing sheet or create a new sheet.

 

As this isn’t really a tutorial on using Excel, I thought I might add that you can sort columns filter and organize

And, by filtering you can see what purchases you made for a given date much faster then having to track this down.

Column Filter By Date

Using “DSN” Created in SSRS

Not many people have SSRS or the desire to create reports with SSRS. This isn’t a full blown tutorial on using SSRS, but on

creation of the data sources. Either Shard Data Sources or Shared Data Sets and using those to connect the DSN for reporting

from DAZ Studios CMS database.

After opening up Visual Studio I’m using 2013 here. right click on Shared Data Sources

Create a name for your Shared Data Source with type as ODBC, then select edit.

Select the PostgreSQL30_32 item after testing the connection select OK.

Your connection string will be “Dsn=PostgreSQL30_32”  Select OK on the Shared Data Source Properties screen.

I’ll create a new report.

Select the newly created “Shared Data Source” and select next. If you have a query

already created and is syntax checked enter that as your query string.  You can select next or

enter the query builder where if there are errors will show you.

Product ‘4422’ is one that I’ve been using in my postings about DAZ3d Content Management. Or you could just drop the

WHERE clause and return all records. And if you enter the query editor you can select tables or views to work with for this report

this is the selection returned form query editor

SELECT store_id, name, guid, last_update
FROM dzcontent.product

From that Here is a simple created report from or DSN through created report.

Create Simple Tabular Report

Select how items are grouped

Jump to the end and select finish

Simple report with adjust column headings

Article Recap

Hopefully I’ve kept this article simple and easy to use. I like the follow along approach an article like this offers.

  • PostgreSQL up front information
  • Setup and installation of ODBC drivers
  • Simple Excel Report Process
  • Simple SSRS Report Process

Also, these steps for using PostgreSQL aren’t only meant for usage with DAZ Studio.  You can use theses tips to install ODBC for
other usages as well. You could also set this up with Microsoft access.
My goal is to build a mini accounting system for my content. Knowing how much I paid in relation to content in my database and content on my machine
will help me out if I ever get to that PAID ARTIST category. 🙂

If you see errors or omissions please let me know. Comments are always welcome.
Thank you,

Joseph

 

Categories: DAZ3D, PostgreSQL, Technology, TSQL Tags: ,

3D ART :- A Walk In The Garden

3D ART :- A Walk In The Garden

This is great how this image came together.  Not much to explain on this post. I just thought

that all came together very nice. Image composition and colors all work very well together. 🙂

  • HIGHER RESOLUTION IMAGES AVAILABLE.