Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13277 > unrolled thread
| Started by | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| First post | 2021-03-04 10:16 -0800 |
| Last post | 2021-03-09 13:04 -0800 |
| Articles | 10 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-03-04 10:16 -0800 |
| Subject | Cavo 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]
| From | Fabio Rotheia <fabiorotheia@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2021-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Phil McGuinness <sherlocksoftware@gmail.com> |
|---|---|
| Date | 2021-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]
| From | Henry Fidler <zodcomag@gmail.com> |
|---|---|
| Date | 2021-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