could not connect to mysql database

Tagged:
  • anuragkumar
        5 years ago #14842

        I have created a mysql connector but I am getting below error:-

        {
        “message”: “Connector Call AnuragSQLConnector / getAlInventories produced an unexpected error during execution: Error executing connector ‘AnuragSQLConnector’ of type ‘SQL’: Couldn’t connect to the Database.”,
        “success”: false
        }

        Please find the details of my SQL Connector configs in the attachments below.

        I have a database named “shopping_mall” with a table “inventory” on my local mysql.

        Please let me know what can be going wrong.

        Thanks in advance.

        Attachments:
        You must be logged in to view attached files.
        Chris Bouveret
            Has successfully completed the online course Introduction
            Has successfully completed the online course Intermediate (200)
            Has successfully completed the online course Advanced (300)
            Has successfully completed the online course Basics (100)
            Has successfully completed the online course Advanced (320)
            Has successfully completed the Intermediate Certification
            Has successfully completed the Advanced Certification
          5 years ago #14853
          Up
          1
          Down
          ::

          Hi,

          you are trying to connect to a Database on your localhost. This ist not possible because the Simplifier Freemium Instance cannot access your localhost. The easiest way is to move your Database to the Web so that is reachable via IP adress or hostname.

          Hope that helps

          Best
          Chris

          anuragkumar
              5 years ago #14867
              Up
              0
              Down
              ::

              @Chris, Thanks..

              Can you please provide some example of websites where I can move my database to and which can be accessed from freemium simplifier instance.

              Regards

              Chris Bouveret
                  Has successfully completed the online course Introduction
                  Has successfully completed the online course Intermediate (200)
                  Has successfully completed the online course Advanced (300)
                  Has successfully completed the online course Basics (100)
                  Has successfully completed the online course Advanced (320)
                  Has successfully completed the Intermediate Certification
                  Has successfully completed the Advanced Certification
                5 years ago #14868
                Up
                0
                Down
                ::

                Hi,

                well there is no limits. You could use AWS Database Services or any other Webserver that has e.g. MySQL or other Database Services running. You could also use SQLite which would be stored on your Freemium Simplifier Instance. In this case you would just have to migrate your data to SQLite. In general, the SQL Connector of Simplifier can access any Endpoint that is reachable in the Internet.

                Best
                Chris

                anuragkumar
                    5 years ago #14870
                    Up
                    0
                    Down
                    ::

                    Hi @Chris

                    Thanks again,

                    As I am a complete newbie to simplifier, please guide me how I can use SQLite that as per you would be stored on my Freemium Simplifier Instance.
                    Will I need to install SQLite on my system for this? I am clueless on this.

                    If possible share some link which I can refer for detailed info.

                    Thanks in advance.

                    Regards
                    Anurag

                    Chris Bouveret
                        Has successfully completed the online course Introduction
                        Has successfully completed the online course Intermediate (200)
                        Has successfully completed the online course Advanced (300)
                        Has successfully completed the online course Basics (100)
                        Has successfully completed the online course Advanced (320)
                        Has successfully completed the Intermediate Certification
                        Has successfully completed the Advanced Certification
                      5 years ago #15225
                      Up
                      0
                      Down
                      ::

                      Hi,

                      please see the “ITIZ_Template_SQL_ShoppingList” Example App, it uses SQLite and you can see how data is stored and SQLite is managed

                      Hope that helps
                      Chris

                      anuragkumar
                          5 years ago #15236
                          Up
                          0
                          Down
                          ::

                          Thanks Chris. It worked.

                        Viewing 7 posts - 1 through 7 (of 7 total)

                        You must be logged in to reply to this topic.