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

Imspector +mysql

Scheduled Pinned Locked Moved pfSense Packages
6 Posts 3 Posters 3.9k 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.
  • M
    mohman
    last edited by Mar 24, 2009, 1:12 PM

    I have IMspector working ok, pfsense (1.2.2) system logs says that logging is success to mysql server, and everything is fine.
    My question is more mysql related, so where I find imspector sniffed MSN messages from mysql database?

    I have phpMyadmin v3.1.3 installed to my bsd-server, and it seems to be also ok. I can see all kind of information from IMspector, and other databases I have there,  but where is the MSN conversations (texts)?

    –Mik@

    1 Reply Last reply Reply Quote 0
    • B
      billm
      last edited by Mar 29, 2009, 2:17 PM

      Probably in the eventdata column.

      –Bill

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

      1 Reply Last reply Reply Quote 0
      • M
        mohman
        last edited by Mar 30, 2009, 11:35 AM

        In the eventdata field was;
        type "blob"
        addributes "binary"
        null "none"
        default "none"

        nothing sensible text to me..

        –Mik@

        1 Reply Last reply Reply Quote 0
        • B
          billm
          last edited by Apr 5, 2009, 3:43 PM

          I haven't tried using the mysql logging personally, but the event data field probably isn't in plaintext.  I would bet it's base64 encoded, if you can post an example entry here, I could probably decipher it - or just troll through the imspector mysql plugin source ;-P

          –Bill

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

          1 Reply Last reply Reply Quote 0
          • M
            mohman
            last edited by Apr 7, 2009, 8:01 AM

            You are maybe right, but what's the point to use mySQL for IMspector anyway, if the loggings of the conversations are crypted at the MySql. Hope to get "log clear" option soon to IMspector (like at the Smoothwall was).

            –Mik@

            1 Reply Last reply Reply Quote 0
            • D
              darkfeelings
              last edited by Sep 28, 2009, 4:02 PM Sep 25, 2009, 4:50 PM

              Hi everyone.. i want to say thks to pfsense creator is a really a great firewall.
              I want to contribute a little php script that i made.
              This php scritp is a web-interfaz to see the messages logs in mysql for imspector

              imspectorphp V1.0
              Its include…
              a login page (the user y and password is user:admin password:admin) you can change it.
              a search engine to find word keys in the messages
              shows 12 results by page

              I release this v1.0 because i want you can help me to see the bugs in the php script..
              and you can help me to get it better.

              thks for reading…

              regards

              lalocespedes (darkfeelings)

              Only one little problem.. It is in spanish.. because im proudly mexican..
              But very soon i have it in english im working on it..

              How to install?

              1. Run the sql file imspector.sql in your mysql server.
              2. Unrar the imspectorphp.rar file
              3. Copy the content folder in your webserver.
              4. Have fun....

              Any questions, greatings, beers send me to my email lalocespedes@gmail.com

              download here

              http://suenachido.com/imspectorphp/imspectorphp.rar

              –-------------------------------------------------------------------------------

              Hola a todos quiero dar las gracias al creador del pfsense es un gran muro de fuego a mi me ha ayudado bastante y he aprendido mucho en este foro.
              Quiero contribuir con algo pequeño lo mucho q he aprendido, he escrito un php script que es una interfaz web para que podamos ver las conversaciones capturadas en imspector por mysql.

              imspectorphp V1.0
              incluye
              Una pagina de login (el usuario y password is user:admin password:admin) lo puedes cambiar.
              Un buscador para encontrar palabras claves dentro de las conversaciones
              y el scrip muestras 12 resultados por pagina

              Quiero darles a conocer esta version 1.0 para que me ayuden a ver los errores en esta version y asi me puedan ayudar a tenerlo mejor.
              Gracias por tu lectura y espero que les ayude mucho

              Saludos

              lalocespedes (darkfeelings)

              Como lo instalo?

              1. Ejecuta el archivo sql imspector.sql en tu servidor mysql
              2. Descomprime el imspectorphp.rar
              3. Copia el contenido de la carpeta en tu servidor web.
              4. Ahora si a divertirse!!!!!….

              Cualquier duda, felicitaciones, envio de cervezas por favor enviamelas a mi correo lalocespedes@gmail.com

              Bajalo de aqui

              http://suenachido.com/imspectorphp/imspectorphp.rar

              1 Reply Last reply Reply Quote 0
              • First post
                Last post
              Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
                [[user:consent.lead]]
                [[user:consent.not_received]]