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

    Libc version error at PostgreSQL Server

    Scheduled Pinned Locked Moved Development
    4 Posts 2 Posters 3.0k 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.
    • I
      ifconfig
      last edited by

      Hi everyone;

      I use freeradius2 and want to authorize Captive Portal users with PostgreSQL Server.
      My steps:

      1) pkg_add -f ftp://ftp.freebsd.com/pub/FreeBSD/ports/i386/packages-8-stable/databases/postgresql-server-9.0.9.tbz
          2) echo "postgresql_enable=YES" >> /etc/rc.conf (I know rc.conf will be removed at boot time but testing for now)
          3) /usr/local/etc/rc.d/postgresql initdb

      And get error here: /libexec/ld-elf.so.1: /lib/libc.so.7: version FBSD_1.3 required by /usr/local/bin/postgres not found
      no data was returned by command ""/usr/local/bin/postgres" -V"

      What Can it be about? I also tried on FreeBSD and get worked. Can pfSense patches cause it? or a removed library or file listed in remove.list?

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

        8-stable packages won't necessarily work on 8.1. You may need to build a package on a stock 8.1 system, copy it over, and pkg_add that.

        1 Reply Last reply Reply Quote 0
        • I
          ifconfig
          last edited by

          @cmb:

          8-stable packages won't necessarily work on 8.1. You may need to build a package on a stock 8.1 system, copy it over, and pkg_add that.

          Thank you!

          I installed postgresql90-server on FreeBSD 8.1 and run:
          pkg_create -b /var/db/pkg/postgresql-server-9.0.12 (port revision number may be different)
          postgresql-server-9.0.12.tbz is created in the same directory that you run command.
          moved it pfSense and install.

          1 Reply Last reply Reply Quote 0
          • I
            ifconfig
            last edited by

            And a little tip to who wants to use Freeradius 2 with PostgreSQL:
            Accounting operations work correctly with MySQL but with PostgreSQL, don't update the radacct table. So, some attributes like Session-Timeout don't work.

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