Imspector can't connect to mysql database

[fribert]

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???

[fribert]

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?

[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

[billm]

@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

[jigpe]

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

jigp
Davao

[billm]

@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

[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

[billm]

@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