Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13277 > unrolled thread

Cavo reads MySql

Started byHenry Fidler <zodcomag@gmail.com>
First post2021-03-04 10:16 -0800
Last post2021-03-09 13:04 -0800
Articles 10 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-04 10:16 -0800
    Re: Cavo reads MySql Fabio Rotheia <fabiorotheia@gmail.com> - 2021-03-04 20:15 -0800
      Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-05 03:27 -0800
        Re: Cavo reads MySql "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-03-05 13:33 +0100
          Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-05 11:36 -0800
            Re: Cavo reads MySql Franz Rachbauer <office@rachbauer.org> - 2021-03-06 09:24 +0100
              Re: Cavo reads MySql "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-03-07 17:24 +0100
                Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-08 05:48 -0800
                  Re: Cavo reads MySql Phil McGuinness <sherlocksoftware@gmail.com> - 2021-03-09 02:16 -0800
                    Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-09 13:04 -0800

#13277 — Cavo reads MySql

FromHenry Fidler <zodcomag@gmail.com>
Date2021-03-04 10:16 -0800
SubjectCavo reads MySql
Message-ID<a953f330-d0d4-4155-9c7e-8b6b1ee51c45n@googlegroups.com>
What will be the way for CaVo to read/write MySql (on a internet host)?

Thanks
Henry

[toc] | [next] | [standalone]


#13278

FromFabio Rotheia <fabiorotheia@gmail.com>
Date2021-03-04 20:15 -0800
Message-ID<1066ca7c-6a84-4062-8daf-3a5af9ae5853n@googlegroups.com>
In reply to#13277
Em quinta-feira, 4 de março de 2021 às 15:16:16 UTC-3, Henry Fidler escreveu:
> What will be the way for CaVo to read/write MySql (on a internet host)? 
> 
> Thanks 
> Henry
Hello Henry!

You can use the ODBC driver for mysql and VO`s SQL classes, but make sure the database is marked for external access on the internet host.

Best regards,
Fábio Rotheia

[toc] | [prev] | [next] | [standalone]


#13279

FromHenry Fidler <zodcomag@gmail.com>
Date2021-03-05 03:27 -0800
Message-ID<8ed36d65-4458-458e-ba77-c3d61d36af84n@googlegroups.com>
In reply to#13278
Fábio many thanks

I understand I have to use: 
	<oSQLConnection>:Connect([<cDataSource>], [<cUserID>], [<cPassword>])

I have a WordPress website which uses a MySql  DataBank with a name and password.
What will be the cDataSource?

Many thanks
Henry

[toc] | [prev] | [next] | [standalone]


#13280

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-03-05 13:33 +0100
Message-ID<iaemovF6pvqU1@mid.individual.net>
In reply to#13279
Hi Henry,

something like that should work:

cDriver := "MySQL ODBC 3.51 Driver" 
cServer := "192.168.254.20"
cDB := "MyDB"
cUser := "myuser"
cPassword := "Mypassword"

oConn := SQLConnection{}	
cConnectString	:= "DRIVER={" + cDriver + "};SERVER=" + cServer + ;
 ";DATABASE=" + cDB + ";UID=" + cUser + ";PWD=" + cPassword + ;
 "; OPTION=3"		// OPTION=16834"
oConn:DriverConnect( self, SQL_DRIVER_NOPROMPT, cConnectString )


But please pay attention if your provider permits external access to
the database!
Normally internet server databases are not opened for external
connections!

Wolfgang


Henry Fidler wrote:

> Fábio many thanks
> 
> I understand I have to use: 
> 	<oSQLConnection>:Connect([<cDataSource>], [<cUserID>], [<cPassword>])
> 
> I have a WordPress website which uses a MySql  DataBank with a name
> and password.  What will be the cDataSource?
> 
> Many thanks
> Henry



-- 

[toc] | [prev] | [next] | [standalone]


#13282

FromHenry Fidler <zodcomag@gmail.com>
Date2021-03-05 11:36 -0800
Message-ID<65fc41fa-16a3-4fed-8ccb-7f69479a2efcn@googlegroups.com>
In reply to#13280
Wolfgang thanks for your answer

1.  Driver: Where do I find the driver for MySQL ?
2.  Server: How do I find the server name? (is it the URL?) 

Thanks
Henry 

[toc] | [prev] | [next] | [standalone]


#13283

FromFranz Rachbauer <office@rachbauer.org>
Date2021-03-06 09:24 +0100
Message-ID<s1ve8c$1k1i$1@gioia.aioe.org>
In reply to#13282
Actual and previous ODBC Drivers for MySQL you can find here:
https://dev.mysql.com/downloads/connector/odbc/

Server Name ist the IP of the host where the MySQL DB is hostet, but as 
Wolfgang already says: Providers do not permit external access to their 
DB hosts! So I always use small PHP apps at the providers host, which 
get the request by url, read the db and get back the result.

Franz

Am 05.03.2021 um 20:36 schrieb Henry Fidler:
> Wolfgang thanks for your answer
> 
> 1.  Driver: Where do I find the driver for MySQL ?
> 2.  Server: How do I find the server name? (is it the URL?)
> 
> Thanks
> Henry
> 

[toc] | [prev] | [next] | [standalone]


#13284

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-03-07 17:24 +0100
Message-ID<iakd2eFakkgU1@mid.individual.net>
In reply to#13283
Hi Henry,

please let me add a few things to what Franz wrote (I use a similar
approach to access databases that have no public access):

- you don't need any ODBC driver in that case
- please beware that you have a public access to the database then.
First, use a SSL connection, and second, protect the access with a
password
- since you don't need any ODBC driver, you don't have to configure
anything on the client machines

Every time when it comes to connections over the internet, security has
to be the most important issue!

Sometimes it may be better to build a webservice to interact with your
internet application, maybe up- and downloading CSV, XML or JSON files
(but always use password protection and SSL).

Wolfgang


Franz Rachbauer wrote:

> Actual and previous ODBC Drivers for MySQL you can find here:
> https://dev.mysql.com/downloads/connector/odbc/
> 
> Server Name ist the IP of the host where the MySQL DB is hostet, but
> as Wolfgang already says: Providers do not permit external access to
> their DB hosts! So I always use small PHP apps at the providers host,
> which get the request by url, read the db and get back the result.
> 
> Franz
> 
> Am 05.03.2021 um 20:36 schrieb Henry Fidler:
> > Wolfgang thanks for your answer
> > 
> > 1.  Driver: Where do I find the driver for MySQL ?
> > 2.  Server: How do I find the server name? (is it the URL?)
> > 
> > Thanks
> > Henry
> > 



-- 

[toc] | [prev] | [next] | [standalone]


#13285

FromHenry Fidler <zodcomag@gmail.com>
Date2021-03-08 05:48 -0800
Message-ID<d942f38a-6c21-4fbe-9f04-2742d704405fn@googlegroups.com>
In reply to#13284
Wofgang many thanks

My host makes it possible to choose external access.

I understand the security risk, and I hope the site (built with WordPress) will be interesting enough also for hackers,
otherwise I´ll have to learn PHP (or similar)

Thanks
Henry

[toc] | [prev] | [next] | [standalone]


#13286

FromPhil McGuinness <sherlocksoftware@gmail.com>
Date2021-03-09 02:16 -0800
Message-ID<982b9ca3-feb5-4189-b0d5-670de94bc64dn@googlegroups.com>
In reply to#13285
Henry

A VO + PHP + Wordpress developers.

Number one platform to hack for web is Wordpress.... constant attack because of its market share, like Windows a big foot print.
With 39,000 plugins there is one problem. How you lock it down to Administrator verse power user important.
We refuse to provide top level access to anybody.  Client take my business elsewhere we say good buy.
The security risk allow SEO people or others to install plugins it is just not worth it.
Then you have brute force attacks, DDOS attacks.. know and published back doors etc.. have to maintain standards.
To allow external access to SQL database on public website known IP .. the hackers love it.
24x7 there are the robots that look for the holes.

The only way to exchange data to and from that works is HTTPS / User passed, Encode 64 and usual JSON data.
The SQL service on other end returns JSON or XML.

You do not have to learn PHP at all,, who is building and securing the Wordpress site. Wordpress written in PHP.
You plan what want to request or send and those scripts written.

In VO you use POST / GET and deliver and receive data.
We do this across system maybe 20,000 times a day 

snip[  My host makes it possible to choose external access.  ]
You host has to deal with the hack attacks and enough attacks they change their mine.
Have been through all this learning curve over say 17 years and I can tell what works and will continue to work.

snip[  > I understand the security risk, ]
No.. you think you do.   When you waste hours and hours of down time trying to fight off the endless, endless hack attacks.
My developer setup a new MS 2016 server and had not activate the virus/malware protection.
Basically a bare server with IIS running.    Within 4 hours the server was totally encrypted and wanted ransomware.
He also thought.. it will be safe have not put any sites on their yet.

snip[ and I hope the site (built with WordPress) will be interesting enough also for hackers, ]
The hacker community in this area massive.

We have one of our cPANEL running 120 x WP sites..  Thursday 70 x time normal traffic and XRP attack on Wordpress.
We can deal with the port, but this attack at 400 hits a second had like 30 different attack vectors trying to take cPANEL down.
That particular attack and how it was organised, never seen before.  So it is a constantly changing attack system.

Why you would not protect your SQL from attack and handle the data in the way they works and is safer is HUGE RISK.
When a host gets this sort of hack they have to block IP all the time.. they soon tell you sort it out.

Phil McGuinness
---------

[toc] | [prev] | [next] | [standalone]


#13287

FromHenry Fidler <zodcomag@gmail.com>
Date2021-03-09 13:04 -0800
Message-ID<4c94c459-f0cc-43b5-afab-4b32a485639fn@googlegroups.com>
In reply to#13286
Phil, many thanks for your important info.
Henry

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web