From owner-freebsd-ports@freebsd.org Fri Sep 22 13:59:18 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 8F009E29FBA for ; Fri, 22 Sep 2017 13:59:18 +0000 (UTC) (envelope-from zi@FreeBSD.org) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 780286D3B7 for ; Fri, 22 Sep 2017 13:59:18 +0000 (UTC) (envelope-from zi@FreeBSD.org) Received: by mailman.ysv.freebsd.org (Postfix) id 77608E29FB8; Fri, 22 Sep 2017 13:59:18 +0000 (UTC) Delivered-To: ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 77014E29FB7 for ; Fri, 22 Sep 2017 13:59:18 +0000 (UTC) (envelope-from zi@FreeBSD.org) Received: from exodus.zi0r.com (exodus.zi0r.com [71.179.14.195]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN "exodus.zi0r.com", Issuer "Gandi Standard SSL CA 2" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 543166D3B6; Fri, 22 Sep 2017 13:59:18 +0000 (UTC) (envelope-from zi@FreeBSD.org) Received: from exodus.zi0r.com (localhost [127.0.0.1]) by exodus.zi0r.com (Postfix) with ESMTP id BAA67BD426; Fri, 22 Sep 2017 09:59:16 -0400 (EDT) X-Virus-Scanned: amavisd-new at zi0r.com Received: from exodus.zi0r.com ([127.0.0.1]) by exodus.zi0r.com (exodus.zi0r.com [127.0.0.1]) (amavisd-new, port 10026) with LMTP id 253dUWoRVFAk; Fri, 22 Sep 2017 09:59:16 -0400 (EDT) Received: from exodus.zi0r.com (syn.zi0r.com [IPv6:2001:470:8:d58:aba:ca:daba:10]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by exodus.zi0r.com (Postfix) with ESMTPSA id 4CBE6BD425; Fri, 22 Sep 2017 09:59:16 -0400 (EDT) Date: Fri, 22 Sep 2017 09:59:14 -0400 From: Ryan Steinmetz To: Igor Jankov Cc: ports@FreeBSD.org Subject: Re: FreeBSD Port: freeradius3-3.0.15_1 with mariadb102-server Message-ID: <20170922135914.GA36641@exodus.zi0r.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.8.3 (2017-05-23) X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 22 Sep 2017 13:59:18 -0000 On (09/22/17 15:46), Igor Jankov wrote: >Hello! >I have problem use MariaBD/mysql database with freeradius >on 11.1-RELEASE FreeBSD 11.1-RELEASE #0 r321309 amd64. > >config: /usr/local/etc/radius/mods-enabled/sql > ... > driver = "rlm_sql_mysql" > ... > dialect = "mysql" > ... > >in debug mode: radiusd -X >shows > >Could not link driver rlm_sql_mysql: Cannot open >"/usr/local/lib/freeradius-3.0.15/rlm_sql_mysql.so" >Make sure it (and all its dependent libraries!) are in the search path >of your system's ld >/usr/local/etc/raddb/mods-enabled/sql[20]: Instantiation failed for >module "sql" > I would test this again using only MySQL (not mariadb) and confirm that the problem is isolated to mariadb. I've used MySQL support in the past and have seen it work. You'll also need to confirm that the FreeRADIUS port was installed with the MYSQL option enabled. -r >How I can use mysql database with freeradius on FreeBSD? > >Thanks > Igor Jankov -- Ryan Steinmetz PGP: 9079 51A3 34EF 0CD4 F228 EDC6 1EF8 BA6B D028 46D7