Imspector and MYSQL database configuration



  • 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




  • @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



  • 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) :)



  • 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



  • @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)


Locked