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.
    • P
      pogey
      last edited by

      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.

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

        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.

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

          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

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

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

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

              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

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

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

                1 Reply Last reply Reply Quote 0
                • 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
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.