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

    Libmysqlclient.so.15 not found

    Scheduled Pinned Locked Moved pfSense Packages
    26 Posts 9 Posters 23.3k 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.
    • C
      coolcat1975
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • R
        rsw686
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • C
          coolcat1975
          last edited by

          no i dont.

          ~~anyway something strange happened now

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

          1 Reply Last reply Reply Quote 0
          • C
            coolcat1975
            last edited by

            so everything installed again, but still no logging :(

            1 Reply Last reply Reply Quote 0
            • R
              rsw686
              last edited by

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

              1 Reply Last reply Reply Quote 0
              • J
                JorgeAldoBR
                last edited by

                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 ?

                1 Reply Last reply Reply Quote 0
                • C
                  coolcat1975
                  last edited by

                  @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

                  1 Reply Last reply Reply Quote 0
                  • J
                    JorgeAldoBR
                    last edited by

                    it is working now…

                    1 Reply Last reply Reply Quote 0
                    • J
                      jchuerta
                      last edited by

                      @JorgeAldoBR:

                      it is working now…

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

                      1 Reply Last reply Reply Quote 0
                      • C
                        coolcat1975
                        last edited by

                        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

                        1 Reply Last reply Reply Quote 0
                        • J
                          jchuerta
                          last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • C
                            coolcat1975
                            last edited by

                            just checked, the file is there

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

                            regards

                            cc

                            1 Reply Last reply Reply Quote 0
                            • P
                              pogey
                              last edited by

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

                              1 Reply Last reply Reply Quote 0
                              • J
                                jchuerta
                                last edited by

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

                                Just upload the file an then install manually

                                1 Reply Last reply Reply Quote 0
                                • B
                                  biatche
                                  last edited by

                                  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?

                                  1 Reply Last reply Reply Quote 0
                                  • R
                                    rsw686
                                    last edited by

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

                                    1 Reply Last reply Reply Quote 0
                                    • B
                                      biatche
                                      last edited by

                                      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

                                      1 Reply Last reply Reply Quote 0
                                      • M
                                        maxi
                                        last edited by

                                        This is my howto:

                                        fetch http://ftp.twaren.net/BSD/FreeBSD/ports/i386/packages-6.2-release/Latest/mysql51-client.tbz

                                        pkg_add mysql51-client.tbz

                                        1 Reply Last reply Reply Quote 0
                                        • D
                                          David_W
                                          last edited by

                                          @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

                                          1 Reply Last reply Reply Quote 0
                                          • S
                                            sullrich
                                            last edited by

                                            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

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.