Clovertech

database connection sqlite

› Clovertech Forums › Cloverleaf › database connection sqlite

  • Creator
    Topic
  • April 28, 2021 at 3:05 pm #118790
    Stewart
    Participant

      I’m attempting to connect to a sqlite db and am getting an exception.   I’ve attaached a screenshot.  That is the correct location and I don’t have a password associated w/ the DB.  Suggestions?

      Attachments:
      You must be logged in to view attached files.
    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • April 28, 2021 at 11:37 pm #118794
        Charlie Bursell
        Participant

          Looks to me like it is saying it cannot find the database (unknown source)

          Can you open it from the command line using the sqlite command?

        • April 29, 2021 at 8:26 am #118795
          Stewart
          Participant

            I can and execute .schema successfully.

          • April 29, 2021 at 10:50 pm #118798
            Charlie Bursell
            Participant

              I don’t understand what you mean by .schema

            • April 29, 2021 at 10:57 pm #118799
              Stewart
              Participant

                The tables and their configurations in the database.  I did find the solution/work around.  I couldn’t get the schema to load from the database configurations in site preferences.  I had to create the schema in Cloverleaf under database schemas after creating the connection.  I still couldn’t get it load from site settings / db configs however I am able to use the sqlite db now.

                Attachments:
                You must be logged in to view attached files.
              • April 30, 2021 at 11:11 pm #118811
                Charlie Bursell
                Participant

                  Glad you got it sorted

              • Author
                Replies
              Viewing 4 reply threads
              • You must be logged in to reply to this topic.