Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Imspector can't connect to mysql database

    Scheduled Pinned Locked Moved pfSense Packages
    8 Posts 3 Posters 4.1k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      fribert
      last edited by

      Hi All

      I have a mysql running on my NAS.
      I would like to use the NAS for storing the log files.
      I've created a imspector user, with an imspector database.
      I've tried creating the user both as a user only accessing from the firewall, and also a '%' user from anywhere.
      I've reseting the password.
      I've even created the table inside the database, as per the imspector.org page.

      The imspector is enabled on the LAN. The imspector settings have the IP of the nas box as mysql server.

      But I just get the following in the system log:
      imspector: MySQL: Couldn't connect to database, Error: Access denied for user 'imspector'@'firewall.domain' (using password: YES)
      imspector: MySQL: Couldn't connect to database, Error: Access denied for user 'imspector'@'firewall.domain' (using password: YES)

      The error is logical, I just don't see what I need to do more???

      1 Reply Last reply Reply Quote 0
      • F
        fribert
        last edited by

        Sigh, sometimes things work out, without anyone is knowing why.
        I created a new user again with % as host, and then it could connect.
        Then I created a new user with the pfsense as host, and it could still connect.
        Very odd, but it's connecting now at least.

        Have I understood it correctly in assuming that the Imspector Log Viewer will only show content if the file logging is enabled?

        1 Reply Last reply Reply Quote 0
        • J
          jigpe
          last edited by

          Hello i know this too late for the reply. I just want to ask if i could save the logs inside the pfsense where i instll also  the imspector?If so how to install mysql in pfsense so that imspector will forward the logs inside the folder of mysql… I already tried in other windows machine but it doesnt store anything. i Got same error. Thanks

          1 Reply Last reply Reply Quote 0
          • B
            billm
            last edited by

            @jigpe:

            Hello i know this too late for the reply. I just want to ask if i could save the logs inside the pfsense where i instll also  the imspector?If so how to install mysql in pfsense so that imspector will forward the logs inside the folder of mysql… I already tried in other windows machine but it doesnt store anything. i Got same error. Thanks

            Wow, way to resurrect a 4 month old thread that isn't relevant to your question.  If I understand your question, you want to store the pfsense logs in mysql also?  Nope.  No plans to ever support that either.

            –Bill

            pfSense core developer
            blog - http://www.ucsecurity.com/
            twitter - billmarquette

            1 Reply Last reply Reply Quote 0
            • J
              jigpe
              last edited by

              I already read the thread that you can set timer or every friday the logs will erase.

              jigp
              Davao

              1 Reply Last reply Reply Quote 0
              • B
                billm
                last edited by

                @jigpe:

                I already read the thread that you can set timer or every friday the logs will erase.

                jigp
                Davao

                No idea what you are talking about I'm afraid.

                –Bill

                pfSense core developer
                blog - http://www.ucsecurity.com/
                twitter - billmarquette

                1 Reply Last reply Reply Quote 0
                • J
                  jigpe
                  last edited by

                  Im referring to this post which is your post :) its a timer right? correct me if im wrong please.. thanks :)

                  Good point, I'll see what I can do about that.  In the meantime insert this into /conf/config.xml before the and reboot (or back up, edit, and restore the config file):
                        <minute>0</minute>
                          <hour>0</hour>
                          <mday></mday>
                          <month>
                  </month>
                          <wday>*</wday>
                          <who>root</who>
                          <command></command>find /var/imspector -ctime +14 -type f -delete

                  Note, I didn't test the above, it should work, I don't believe there are any special characters that the XML will barf on in there.

                  –Bill

                  1 Reply Last reply Reply Quote 0
                  • B
                    billm
                    last edited by

                    @jigpe:

                    Im referring to this post which is your post :) its a timer right? correct me if im wrong please.. thanks :)

                    Good point, I'll see what I can do about that.  In the meantime insert this into /conf/config.xml before the and reboot (or back up, edit, and restore the config file):
                          <minute>0</minute>
                             <hour>0</hour>
                             <mday></mday>
                             <month>
                    </month>
                             <wday>*</wday>
                             <who>root</who>
                             <command></command>find /var/imspector -ctime +14 -type f -delete

                    Note, I didn't test the above, it should work, I don't believe there are any special characters that the XML will barf on in there.

                    –Bill

                    And that has what to do with this thread?

                    Locking as we've appeared to gone completely off topic.

                    –Bill

                    pfSense core developer
                    blog - http://www.ucsecurity.com/
                    twitter - billmarquette

                    1 Reply Last reply Reply Quote 0
                    • First post
                      Last post
                    Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.