Libmysqlclient.so.15 not found

pogey

Hi,

I have just install imspector 0.3.1 but getting error.

imspector: dlopen(): Shared object "libmysqlclient.so.15" not found, required by "mysqlloggingplugin.so"

Also try to remove package and install again.. still the same problem.

rsw686

With the imspector package installed run the following from the console run

pkg_info
pkg_add -r mysql51-client

and let me know the output and we can see how to proceed.

coolcat1975

that what it says here:

pkg_add -r mysql51-client

Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.2-release/Latest/mysql51-client.tbz: No address record
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.2-release/Latest/mysql51-client.tbz' by URL

rsw686

That file exists though. I clicked on the link and I can download it. Try it again.

coolcat1975

yeap thats true the file exists, but for some reason ftp.freebsd.org is not resolved on my pfsense

i downloaded it manually by connecting via ftp to ip address 204.152.184.73 and installed it,
but imspector still wont log anything

i am using pfsense as bridge with traffic only in wan and opt1

regards

cc

rsw686

@coolcat1975:

i downloaded it manually by connecting via ftp to ip address 204.152.184.73 and installed it,
but imspector still wont log anything

Does file logging work? Do you receive any errors? You might try running imspector in debug mode with -d.

coolcat1975

imspector -c /usr/local/etc/imspector/imspector.conf -d

imspector: Protocol Plugin name: ICQ-AIM IMSpector protocol plugin
imspector: Protocol Plugin name: IRC IMSpector protocol plugin
imspector: Protocol Plugin name: MSN IMSpector protocol plugin
imspector: Protocol Plugin name: Yahoo IMSpector protocol plugin
imspector: Listening on 0.0.0.0:16667
imspector: Logging Plugin name: Debug IMSpector logging plugin
imspector: Logging Plugin name: File IMSpector logging plugin

no errors so far but also no logging

here is the conf:

cd /usr/local/etc/imspector/

less imspector.conf

The listening port

#port=16667

The listening address

#listenaddr=0.0.0.0

Prefered outbound interface

#interface=eth0

This is the default location of protocol and logging plugins.

#plugin_dir=/usr/local/lib/imspector

For dropping privs - you probably want to do this.

#user=imspector
#group=imspector

Location where the file logging plugin will start from.

file_logging_dir=/var/log/imspector

Will load enabled plugins in plugin_dir

icq_protocol=on
irc_protocol=on
msn_protocol=on
yahoo_protocol=on

Bad words filtering

#badwords_filename=/usr/local/etc/imspector/badwords.txt
#badwords_replace_character=*

MySQL logging plugin stuff

#mysql_server=localhost
#mysql_database=imspector
#mysql_username=imspector
#mysql_password=password

For SQLite

#sqlite_file=/path/to/file

rsw686

When running in debug mode do you see the messages from clients using AIM, MSN, etc.

coolcat1975

no i dont.

~~anyway something strange happened now

i uninstalled imspector and tried to reinstall it, but it refuses. i'll try a reboot~~

coolcat1975

so everything installed again, but still no logging :(

rsw686

@coolcat1975:

i am using pfsense as bridge with traffic only in wan and opt1

You know this may be where the problem is. imspector uses rdr pass rules to redirect the traffic to itself. I'm not sure how this works in a bridging setup. You may need to modify imspector.inc to create different rules.

JorgeAldoBR

This specific problem i solved using pkg_add -r ftp://ftp.freebsd.org/pub/FreeBSD/ports/packages/databases/mysql-client-5.1.21.tbz

after the install, there will be a libmysqlclient.so.16
then i did a link libmysqlclient.so.16 libmysqlclient.so.15

it stopped complaining about this library, but still no logging on the imspector screen of pfsense.

and im not even using mysql logging…

but, im using a second router after pfsense, on the network 192.168.1.0/24, while pfsense lan sits at 192.168.0.0/24

does this interfere with imspector rdr rules ?

coolcat1975

@rsw686:

@coolcat1975:

i am using pfsense as bridge with traffic only in wan and opt1

You know this may be where the problem is. imspector uses rdr pass rules to redirect the traffic to itself. I'm not sure how this works in a bridging setup. You may need to modify imspector.inc to create different rules.

mhm i thought that the brideging might cause this problem. i have another site where there wont be bridgeing. i'll try there and post the results

JorgeAldoBR

it is working now…

jchuerta

@JorgeAldoBR:

it is working now…

I have the same problem.. the solution ? thanks guys !

coolcat1975

as promised:

imspector works fine here

the only thing i had to do was, just like mentioned above: # pkg_add -r mysql51-client

and then restart impsector

also the mysql logging worksm but i dont know what to do with a blob ;)

regards

cc

jchuerta

@coolcat1975:

as promised:

imspector works fine here

the only thing i had to do was, just like mentioned above: # pkg_add -r mysql51-client

and then restart impsector

also the mysql logging worksm but i dont know what to do with a blob ;)

regards

cc

I got this message: ???

Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.2-release/Latest/mysql51-client.tbz: File unavailable (e.g., file not found, no access)

coolcat1975

just checked, the file is there

you can try to fetch it manually via ftp and install it

regards

cc

pogey

Yes i'm also download the file & install it manually…. now the problem solved.

jchuerta

Yes thanks !! It's working here too ..

Just upload the file an then install manually