Author Topic: SSL/TLS and no headaches  (Read 6175 times)

Raistlin

  • Member
  • ****
  • Posts: 552
SSL/TLS and no headaches
« on: January 09, 2019, 04:46:51 PM »
Hi guys and gals, just thought I'd let you know of a nice little application I found whilst trolling
for a solution to my Oracle woes.

The idea was to add secure email SMTP functionality between a standard ad-hoc Gmail account (in-fact
you must use TLS, you don't have a choice) and Oracle DB PL/SQL code directly. The primary benefit then is, you
don't need an SMTP relay or email server and you won't have network routing problems connecting
to your email box. Connectivity from anywhere, at anytime. Another benefit is you can use Oracle 11g Express Ed (free)
without the need for certificate management - which is only available with the pay $$$ editions (see Oracle wallet).

So the app that solves the problem is stunnel (https://www.stunnel.org/docs.html).
A small footprint proxy you can implement that provides scale-able load-balancing SSL/TLS and even VPN
functionality to any server (without code modification) supporting the common internet protocols.
Works like a charm - right out of the box. I was so impressed  ;) I can now email within standard PL/SQL
code directly, using any format (text,html etc.) with any type of attachment (csv,html,pdf etc.) supported.

Have a great day friends
Raistlin

Are you pondering what I'm pondering? It's time to take over the world ! - let's use ASSEMBLY...

aw27

  • Guest
Re: SSL/TLS and no headaches
« Reply #1 on: January 10, 2019, 12:06:35 AM »
stunnel appears to be similar to openVPN*. I use the later occasionally and I think it is also embedded in various anonymous proxies softwares. It is good and easy to learn. Oracle? No thanks  :shock:

* They have a community edition somewhere, this is the one I use.

daydreamer

  • Member
  • *****
  • Posts: 2399
  • my kind of REAL10 Blonde
Re: SSL/TLS and no headaches
« Reply #2 on: January 10, 2019, 01:44:17 AM »
thanks Raistlin
my none asm creations
http://masm32.com/board/index.php?topic=6937.msg74303#msg74303
I am an Invoker
"An Invoker is a mage who specializes in the manipulation of raw and elemental energies."
Like SIMD coding

Raistlin

  • Member
  • ****
  • Posts: 552
Re: SSL/TLS and no headaches
« Reply #3 on: January 10, 2019, 02:18:21 AM »
@AW: hail master, good to hear from you.
You can use openvpn with stunnel to create
deep dive proof(ish) vpn tunnels that appear to be
standard SSL traffic. Thus ISP throttling or behind
the curtain types, might be avoided. I just love the
ease, convenience and reasonable security aspect
of the standard stunnel implementation. Oracle PL/Sql
is not reaaaallllly that different from MS SQL types -
Hey I teach both afterall - not much to it - small syntax
issues only :P
 
Are you pondering what I'm pondering? It's time to take over the world ! - let's use ASSEMBLY...

hutch--

  • Administrator
  • Member
  • ******
  • Posts: 10583
  • Mnemonic Driven API Grinder
    • The MASM32 SDK
Re: SSL/TLS and no headaches
« Reply #4 on: January 10, 2019, 02:26:05 AM »
I have learnt this much doing forum and server updates the MySql is being replaced in Linux distros with MariaDB which is supposed to be a better database.
hutch at movsd dot com
http://www.masm32.com    :biggrin:  :skrewy:

Raistlin

  • Member
  • ****
  • Posts: 552
Re: SSL/TLS and no headaches
« Reply #5 on: January 10, 2019, 03:51:16 AM »
Hutch: IBM just released the first commercial
quantum computer fully upgradeable for future
releases. Sooooo ASM in analog going forward ?
Are you pondering what I'm pondering? It's time to take over the world ! - let's use ASSEMBLY...

daydreamer

  • Member
  • *****
  • Posts: 2399
  • my kind of REAL10 Blonde
Re: SSL/TLS and no headaches
« Reply #6 on: January 10, 2019, 05:21:03 AM »
Hutch: IBM just released the first commercial
quantum computer fully upgradeable for future
releases. Sooooo ASM in analog going forward ?
a cpuid gives back this:"don't know how many ghz speed I have,but I know where my PC program counter is" or "I do know how many ghz speed I have,but have no clue where my PC program counter is" :P :bgrin:
my none asm creations
http://masm32.com/board/index.php?topic=6937.msg74303#msg74303
I am an Invoker
"An Invoker is a mage who specializes in the manipulation of raw and elemental energies."
Like SIMD coding

Raistlin

  • Member
  • ****
  • Posts: 552
Are you pondering what I'm pondering? It's time to take over the world ! - let's use ASSEMBLY...

daydreamer

  • Member
  • *****
  • Posts: 2399
  • my kind of REAL10 Blonde
Re: SSL/TLS and no headaches
« Reply #8 on: January 10, 2019, 05:55:20 AM »
LOL & LOL  :biggrin: possibly too much of a nerdy
comment though daydreamer - translate to normal ?

Pps here's the massive link for non-believers https://techcrunch-com.cdn.ampproject.org/v/s/techcrunch.com/2019/01/08/ibm-unveils-its-first-commercial-quantum-computer/amp/?amp_js_v=a2&amp_gsa=1&usqp=mq331AQECAFYAQ%3D%3D#referrer=https%3A%2F%2Fwww.google.com&amp_tf=From%20%251%24s&ampshare=https%3A%2F%2Ftechcrunch.com%2F2019%2F01%2F08%2Fibm-unveils-its-first-commercial-quantum-computer%2F
its just a cpuid version of the usual Heisenberg jokes about Heisenberg principle,often put Heisenberg in the role of "dont know how fast I went,but know where I am " or "I know how fast I went,but dont know where I am "(how a particle behaves),together with Einstein sometimes as police officer stopping him asking him -"did you know how fast you went?"
my none asm creations
http://masm32.com/board/index.php?topic=6937.msg74303#msg74303
I am an Invoker
"An Invoker is a mage who specializes in the manipulation of raw and elemental energies."
Like SIMD coding

Raistlin

  • Member
  • ****
  • Posts: 552
Re: SSL/TLS and no headaches
« Reply #9 on: January 10, 2019, 05:57:47 AM »
Exactly why I knew nobody would
understand...LOL again
Are you pondering what I'm pondering? It's time to take over the world ! - let's use ASSEMBLY...

hutch--

  • Administrator
  • Member
  • ******
  • Posts: 10583
  • Mnemonic Driven API Grinder
    • The MASM32 SDK
Re: SSL/TLS and no headaches
« Reply #10 on: January 14, 2019, 03:09:27 PM »
Something that I remember from long ago is that IRC clients had a method of transferring data that did not appear to use any of the standard methods of transferring data. I am not an internet jockey and I don't know how it was done but it did look useful in avoiding many forms of control and spying.
hutch at movsd dot com
http://www.masm32.com    :biggrin:  :skrewy:

Siekmanski

  • Member
  • *****
  • Posts: 2725
Re: SSL/TLS and no headaches
« Reply #11 on: January 14, 2019, 11:19:00 PM »
LOL & LOL  :biggrin: possibly too much of a nerdy
comment though daydreamer - translate to normal ?

Pps here's the massive link for non-believers https://techcrunch-com.cdn.ampproject.org/v/s/techcrunch.com/2019/01/08/ibm-unveils-its-first-commercial-quantum-computer/amp/?amp_js_v=a2&amp_gsa=1&usqp=mq331AQECAFYAQ%3D%3D#referrer=https%3A%2F%2Fwww.google.com&amp_tf=From%20%251%24s&ampshare=https%3A%2F%2Ftechcrunch.com%2F2019%2F01%2F08%2Fibm-unveils-its-first-commercial-quantum-computer%2F

Can't wait to play with the first String-Assembler.  8)
The analog representation of the qubit will be challenging to understand.
We programmers all have to do a trigonometry course to understand the working of the complex three-dimensional linear analog state of the qubits.
3D graphics programming will be a great basis to understand some of this complex material.  :t

Teleportation of qubits, how cool and fast that would be?

Check out these guys, Leo Kouwenhoven and Ronald Hanson, they are working on the future quantum computer.
In May 2014 it was announced that Ronald Hanson had succeeded in being the first to teleport a qubit, through quantum entanglement, over a distance of three meters.

https://www.tudelft.nl/en/2017/tu-delft/microsoft-and-tu-delft-collaboration-started/
Creative coders use backward thinking techniques as a strategy.

HSE

  • Member
  • *****
  • Posts: 2502
  • AMD 7-32 / i3 10-64
Re: SSL/TLS and no headaches
« Reply #12 on: January 14, 2019, 11:32:38 PM »
Can't wait to play with the first String-Assembler.  8)

What I understand from Verlinde speech (I think you send the link) is that Quantum computer only will be usefull for Quantum Mechanics calculations. Some kind of extension like FPU, SIMD, etc. but a lot more specific.
Equations in Assembly: SmplMath

Siekmanski

  • Member
  • *****
  • Posts: 2725
Re: SSL/TLS and no headaches
« Reply #13 on: January 14, 2019, 11:45:04 PM »
Can't wait to play with the first String-Assembler.  8)

What I understand from Verlinde speech (I think you send the link) is that Quantum computer only will be usefull for Quantum Mechanics calculations. Some kind of extension like FPU, SIMD, etc. but a lot more specific.

Think we will have to reset our minds from 1 dimensional ( 0 or 1 ) to multi-dimensional linear thinking (  qubits )

The Blochsphere:

Creative coders use backward thinking techniques as a strategy.

HSE

  • Member
  • *****
  • Posts: 2502
  • AMD 7-32 / i3 10-64
Re: SSL/TLS and no headaches
« Reply #14 on: January 15, 2019, 12:05:26 AM »
 :biggrin: multi-dimensional linear states could be not the problem with quantum computer, but randomness in results (or at list probabilistic distribution of results  :icon_eek:).
Equations in Assembly: SmplMath