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

    Imspector and MYSQL database configuration

    Scheduled Pinned Locked Moved pfSense Packages
    5 Posts 2 Posters 3.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.
    • J Offline
      jigpe
      last edited by

      Good afternoon guys. I use pfsense 1.2.2 and i installed IMSPECTOR. Works really great for 2 days. Then day 3 i disabled Imspector because users disconnect after they send messages using yahoo messenger. I think i did not get the configuration of MYSQL . I installed MYSQL in different pc (windows) am i right? Please do correct me if im wrong. But when i tried to look for the unit pc windows 192.168.2.4, there is nothing really there in c:\mysql\imspector .. No logs there.. I was thinking if i could install mysql in pfsense box ( same box where i installed the package) is this possible? i dont want to messed up again in my pfsense. its my 88th reformat and install (for the record) . How to configure the database? Where to install the mysql database so that it will log all the conversations? Attached here is my configuration. Thanks in advance :)

      jigp
      Davao City

      configuration.JPG
      configuration.JPG_thumb

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

        @jigpe:

        Good afternoon guys. I use pfsense 1.2.2 and i installed IMSPECTOR. Works really great for 2 days. Then day 3 i disabled Imspector because users disconnect after they send messages using yahoo messenger. I think i did not get the configuration of MYSQL . I installed MYSQL in different pc (windows) am i right? Please do correct me if im wrong. But when i tried to look for the unit pc windows 192.168.2.4, there is nothing really there in c:\mysql\imspector .. No logs there.. I was thinking if i could install mysql in pfsense box ( same box where i installed the package) is this possible? i dont want to messed up again in my pfsense. its my 88th reformat and install (for the record) . How to configure the database? Where to install the mysql database so that it will log all the conversations? Attached here is my configuration. Thanks in advance :)

        jigp
        Davao City

        At this time the MySQL support doesn't work.

        –Bill

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

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

          Thanks for the Reply boss Bill. Its now my 89th reformat+install pfsense :) . Same thing users disconnect after they send messages using yahoo messenger and no logs in windows pc mysql (just a follow up updates) :)

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

            I tried also to logged it in /usr/imspector (pfsense box) where lan is 192.168.1.1 and wan is my isp. Same thing. They also disconnect after sending messages after Day 3 (from fresh install). No problem from Day 1 and Day2 they dont disconnect and it logged. How to configure inside pfsense like  creating folder from there? i tried to create a directory at /usr/imspector/imspectorlog..no logs there either after exploring it.. HD of pfsense is 160 seagate sata and RAM is 3GB , Users: 30…Hope this is enough specs.. Kindly show me the way guys? Thanks

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

              @jigpe:

              I tried also to logged it in /usr/imspector (pfsense box) where lan is 192.168.1.1 and wan is my isp. Same thing. They also disconnect after sending messages after Day 3 (from fresh install). No problem from Day 1 and Day2 they dont disconnect and it logged. How to configure inside pfsense like  creating folder from there? i tried to create a directory at /usr/imspector/imspectorlog..no logs there either after exploring it.. HD of pfsense is 160 seagate sata and RAM is 3GB , Users: 30…Hope this is enough specs.. Kindly show me the way guys? Thanks

              Sounds like an IMSpector issue, you'll probably have better luck asking in their support forums.  I don't plan on debugging their code.

              –Bill

              PS the package logs to /var/imspector, not /usr and there is no provision to change that in code (nor will there be)

              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.