Libmysqlclient.so.15 not found



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



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



  • 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



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



  • 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



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



  • 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



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



  • no i dont.

    ~~anyway something strange happened now

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



  • so everything installed again, but still no logging :(



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



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



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



  • it is working now…



  • @JorgeAldoBR:

    it is working now…

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



  • 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



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



  • just checked, the file is there

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

    regards

    cc



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



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

    Just upload the file an then install manually



  • I've gotten as far as installing mysql, the mysql error is gone, but still no logging. Restarted the router, restarted imspector, still no results, what am I missing out?

    imspector -c /usr/local/etc/imspector/test.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

    cat test.conf

    plugin_dir=/usr/local/lib/imspector
    msn_protocol=on
    icq_protocol=on
    yahoo_protocol=on
    irc_protocol=on
    file_logging_dir=/var/imspector

    ====== What have I done wrong?



  • When running imspector with -d do you see the im messages going by on the console screen?



  • Nope.

    I googled a bit about pfctl, not very sure how it works so I randomly did this haha.

    pfctl -s rules | grep imspector

    anchor "imspector" all

    pfctl -a "imspector" -s rules

    pfctl -a "imspector" -sn

    pfctl -a "imspector" -s rules





  • @JorgeAldoBR:

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

    Why do this? There's a reason why the shared library version was bumped from MySQL 5.1.21 onwards, though I'm not familiar with the technical details. Symlinking in this way could introduce random brokenness.

    I would suggest a more conservative approach. If the dependency is on libmysqlclient.so.15, use the MySQL 5.0 client.

    If you really want to use MySQL 5.1 (which does have improvements over 5.0, but many of those improvements are with things like replication that won't apply to many installations, whilst MySQL 5.1 has not yet progressed from release candidate to formal release) rebuild the relevant FreeBSD packages from the underlying ports with DEFAULT_MYSQL_VER=51 in /etc/make.conf or in the command line parameters to make. Be aware that if you do this, you will likely hit problems with other pfSense packages that use MySQL, as they may use FreeBSD packages that depend on libmysqlclient.so.15.

    My suggestion would be to stick with the MySQL version that's default in the underlying FreeBSD version. MySQL 5.0 is the default version in RELENG_6_2 (which is the base for the pfSense 1.2 series) and it will be the default for RELENG_6_3 and RELENG_7_0 as well as the ports tree has already been tagged for the upcoming 6.3-RELEASE and 7.0-RELEASE.

    David



  • Even better, use /etc/libmap.conf instead of symlinking.

    But be careful, you can ROYALLY hose everything if you do the format wrong.

    Check out http://nixdoc.net/man-pages/FreeBSD/libmap.conf.5.html


Log in to reply