Announcement

Collapse
No announcement yet.

Remote HTTP Tunnel - Protocol mismatch - 107 HTTP response status: 403 forbidden

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Remote HTTP Tunnel - Protocol mismatch - 107 HTTP response status: 403 forbidden

    After upgrading to 11.0.20 I have not been able to get remote access to my DB. Local access works fine

    This may have coincided with a hosting server upgrade that may be blocking embedded SQL in PHP scripts. I will check there also.

  • #2
    Would you tell us which version were you using previosly before upgrading to Mac version 11.0.20? Would you provide us your connection information in Connection Properties?

    Comment


    • #3
      The previous version would have been around 11.0

      The connection works fine. The error occurs whenever an SQL statement is passed back to the server, e.g. listing the tables, or even simple SQL statements in the Console.

      Hence, I believe the hosting server is now restricting posted SQL.

      Therefore, SSH access for SQLite would be desirable.

      A Connection Property of interest may be, that on previous versions, I have had to enable "Encode query as base64" for the connection to fully function with SQL queries.

      Here is the connection information:

      ********************
      *General Information
      ********************
      Connection Name: SCEC
      Database File: /home/clarsys/public_html/scec/data/scec.sqlite

      ********************
      *Advanced Information
      ********************
      Setting Save Path: /Users/garryclaridge/Library/Application Support/PremiumSoft CyberTech/Navicat for SQLite/navicatcloud/garry@clarsys.com.au/SCEC
      Auto connect: NO
      Encryped: NO
      Attached Database: NO

      ********************
      *HTTP Information
      ********************
      Use HTTP tunnel: YES
      Tunnel URL: http://www.clarsys.com.au/scec/tools/ntunnel_sqlite.php
      User authentication: NO
      Encode query as base64: YES

      ********************
      *Other Information
      ********************
      Server Version: 3.7.7.1

      Comment


      • #4
        Could you able to access your tunnel php file from web browser? You can copy and paste the URL onto the web broswer to test. If you can access it, show us the information displayed on that page.

        Comment


        • #5
          Here it is: System Environment Test
          [SQLite2] PHP version >= 5.0.0 Yes
          [SQLite2] sqlite_open() available No
          [SQLite3] PHP version >= 5.3.0 Yes
          [SQLite3] SQLite3 class available Yes
          Server Test
          Database File:
          Connection Success!

          Comment


          • #6
            In my initial post I stated "... may be blocking embedded SQL in PHP scripts."

            This should have been: "... may be blocking SQL posted to PHP scripts."

            Garry

            Comment

            Working...
            X