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.2k 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

      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.