1. Forum
  2. Usenet
  3. COMP.LANG.CLIPPER.VISUAL-

  • Cavo reads MySql

    From Henry Fidler@21:1/5 to All on Thu Mar 4 10:16:15 2021
    What will be the way for CaVo to read/write MySql (on a internet host)?

    Thanks
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Fabio Rotheia@21:1/5 to All on Thu Mar 4 20:15:16 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Fri Mar 5 03:27:03 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to Henry Fidler on Fri Mar 5 13:33:34 2021
    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



    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Fri Mar 5 11:36:05 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Franz Rachbauer@21:1/5 to All on Sat Mar 6 09:24:33 2021
    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


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to Franz Rachbauer on Sun Mar 7 17:24:45 2021
    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




    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Mon Mar 8 05:48:46 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Phil McGuinness@21:1/5 to All on Tue Mar 9 02:16:25 2021
    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
    ---------

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Tue Mar 9 13:04:57 2021
    Phil, many thanks for your important info.
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)