<?xml version="1.0" encoding="koi8-r"?>
<rss version="0.91">
<channel>
    <title>OpenForum RSS: Freeradius 2.1.6 не коннектится к базе PostgreSQL</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html</link>
    <description>Проблема в том, что Radius не хочет работать с PostgreSQL. Т.е. если аккаунт завести в users, radtest выполняется без проблем, как только тестирую аккаунт из БД - reject. Есть подозрение, что radius-сервер не грузит драйвер для PostgreSQL, но как исправить это - я не пойму. Пожалуйста, помогите найти решение. Вот конфиг и логи:&lt;br&gt;&lt;br&gt;raduisd -Xx:&lt;br&gt;&lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: FreeRADIUS Version 2.1.6, for host i386-portbld-freebsd7.0, built on Jul 18 2009 at 09:39:08&lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. &lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A &lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: PARTICULAR PURPOSE. &lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: You may redistribute copies of FreeRADIUS under the terms of the &lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: GNU General Public License v2. &lt;br&gt;Sat Jul 18 11:05:32 2009 : Info: Starting - reading configuration files ...&lt;br&gt;Sat Jul 18 11:05:32 2009 : Debug: includ</description>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#8</link>
    <pubDate>Sat, 18 Jul 2009 15:32:37 GMT</pubDate>
    <description>Разобрался сам... Оказалось, надо править ещё один конфигурационник ./raddb/sites-aviable/default, настроить на использование sql.&lt;br&gt;</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#7</link>
    <pubDate>Sat, 18 Jul 2009 09:42:19 GMT</pubDate>
    <description>radius.conf:&lt;br&gt;prefix = /usr/local/&lt;br&gt;exec_prefix = $&#123;prefix&#125;&lt;br&gt;sysconfdir = $&#123;prefix&#125;/etc&lt;br&gt;localstatedir = /var&lt;br&gt;sbindir = $&#123;exec_prefix&#125;/sbin&lt;br&gt;logdir = /var/log&lt;br&gt;raddbdir = $&#123;sysconfdir&#125;/raddb&lt;br&gt;radacctdir = $&#123;logdir&#125;/radacct&lt;br&gt;name = radiusd&lt;br&gt;&lt;br&gt;confdir = $&#123;raddbdir&#125;&lt;br&gt;run_dir = $&#123;localstatedir&#125;/run/$&#123;name&#125;&lt;br&gt;&lt;br&gt;db_dir = $&#123;raddbdir&#125;&lt;br&gt;&lt;br&gt;libdir = /usr/local/lib/freeradius-2.1.6&lt;br&gt;pidfile = $&#123;run_dir&#125;/$&#123;name&#125;.pid&lt;br&gt;user = freeradius&lt;br&gt;group = freeradius&lt;br&gt;max_request_time = 30&lt;br&gt;cleanup_delay = 5&lt;br&gt;max_requests = 1024&lt;br&gt;listen &#123;&lt;br&gt;type = auth&lt;br&gt;ipaddr = *&lt;br&gt;port = 1812&lt;br&gt;&#125;&lt;br&gt;&lt;br&gt;listen &#123;&lt;br&gt;ipaddr = *&lt;br&gt;port = 0&lt;br&gt;type = acct&lt;br&gt;&#125;&lt;br&gt;&lt;br&gt;hostname_lookups = no&lt;br&gt;allow_core_dumps = no&lt;br&gt;&lt;br&gt;regular_expressions= yes&lt;br&gt;extended_expressions= yes&lt;br&gt;log &#123;&lt;br&gt;destination = files&lt;br&gt;file = $&#123;logdir&#125;/radius.log&lt;br&gt;syslog_facility = daemon&lt;br&gt;stripped_names = no&lt;br&gt;auth = no&lt;br&gt;auth_badpass = no&lt;br&gt;auth_goodpass = no&lt;br&gt;&#125;&lt;br&gt;&lt;br&gt;checkrad = $&#123;sbindir&#125;/checkrad&lt;br&gt;&lt;br&gt;security &#123;&lt;br&gt;max_attributes = 200&lt;br&gt;status_server = yes&lt;br&gt;&#125;&lt;br&gt;&lt;br&gt;proxy_requests  = yes&lt;br&gt;$INCLUDE proxy.co</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#6</link>
    <pubDate>Sat, 18 Jul 2009 09:37:50 GMT</pubDate>
    <description>clients.conf: &lt;br&gt;&lt;br&gt;client localhost &#123;&lt;br&gt;ipaddr = 127.0.0.1&lt;br&gt;secret= test&lt;br&gt;require_message_authenticator = no&lt;br&gt;nastype     = other# localhost isn&apos;t usually a NAS...&lt;br&gt;&#125;&lt;br&gt;&lt;br&gt;&lt;br&gt;</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#5</link>
    <pubDate>Sat, 18 Jul 2009 09:32:23 GMT</pubDate>
    <description>ок, переделаю)&lt;br&gt;</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (PavelR)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#4</link>
    <pubDate>Sat, 18 Jul 2009 09:27:04 GMT</pubDate>
    <description>&lt;br&gt;Научись команде &quot;grep -v&quot;.&lt;br&gt;Читать портянки комментариев в конфиг файлах мало кому интересно.&lt;br&gt;</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#3</link>
    <pubDate>Sat, 18 Jul 2009 08:06:05 GMT</pubDate>
    <description>sql.conf:&lt;br&gt;&lt;br&gt;# -*- text -*-&lt;br&gt;##&lt;br&gt;## sql.conf -- SQL modules&lt;br&gt;##&lt;br&gt;##$Id$&lt;br&gt;&lt;br&gt;######################################################################&lt;br&gt;#&lt;br&gt;#  Configuration for the SQL module&lt;br&gt;#&lt;br&gt;#  The database schemas and queries are located in subdirectories:&lt;br&gt;#&lt;br&gt;#sql/DB/schema.sqlSchema&lt;br&gt;#sql/DB/dialup.confBasic dialup (including policy) queries&lt;br&gt;#sql/DB/counter.confcounter&lt;br&gt;#sql/DB/ippool.confIP Pools in SQL&lt;br&gt;#sql/DB/ippool.sqlschema for IP pools.&lt;br&gt;#&lt;br&gt;#  Where &quot;DB&quot; is mysql, mssql, oracle, or postgresql.&lt;br&gt;#&lt;br&gt;&lt;br&gt;sql &#123;&lt;br&gt;#&lt;br&gt;#  Set the database to one of:&lt;br&gt;#&lt;br&gt;#mysql, mssql, oracle, postgresql&lt;br&gt;#&lt;br&gt;database = &quot;postgresql&quot;&lt;br&gt;&lt;br&gt;#&lt;br&gt;#  Which FreeRADIUS driver to use.&lt;br&gt;#&lt;br&gt;driver = &quot;rlm_sql_$&#123;database&#125;&quot;&lt;br&gt;&lt;br&gt;# Connection info:&lt;br&gt;server = &quot;localhost&quot;&lt;br&gt;port = 5432&lt;br&gt;login = &quot;raduser&quot;&lt;br&gt;password = &quot;&quot;&lt;br&gt;&lt;br&gt;# Database table configuration for everything except Oracle&lt;br&gt;radius_db = &quot;raddatab&quot;&lt;br&gt;# If you are using Oracle then use this instead&lt;br&gt;        # radius_db = &quot;(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=loc</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#2</link>
    <pubDate>Sat, 18 Jul 2009 08:05:30 GMT</pubDate>
    <description>clients.conf:&lt;br&gt;&lt;br&gt;# -*- text -*-&lt;br&gt;##&lt;br&gt;## clients.conf -- client configuration directives&lt;br&gt;##&lt;br&gt;##$Id$&lt;br&gt;&lt;br&gt;#######################################################################&lt;br&gt;#&lt;br&gt;#  Define RADIUS clients (usually a NAS, Access Point, etc.).&lt;br&gt;&lt;br&gt;#&lt;br&gt;#  Defines a RADIUS client.&lt;br&gt;#&lt;br&gt;#  &apos;127.0.0.1&apos; is another name for &apos;localhost&apos;.  It is enabled by default,&lt;br&gt;#  to allow testing of the server after an initial installation.  If you&lt;br&gt;#  are not going to be permitting RADIUS queries from localhost, we suggest&lt;br&gt;#  that you delete, or comment out, this entry.&lt;br&gt;#&lt;br&gt;#&lt;br&gt;&lt;br&gt;#&lt;br&gt;#  Each client has a &quot;short name&quot; that is used to distinguish it from&lt;br&gt;#  other clients.&lt;br&gt;#&lt;br&gt;#  In version 1.x, the string after the word &quot;client&quot; was the IP&lt;br&gt;#  address of the client.  In 2.0, the IP address is configured via&lt;br&gt;#  the &quot;ipaddr&quot; or &quot;ipv6addr&quot; fields.  For compatibility, the 1.x&lt;br&gt;#  format is still accepted.&lt;br&gt;#&lt;br&gt;client localhost &#123;&lt;br&gt;#  Allowed values are:&lt;br&gt;#dotted quad (1.2.3.4)&lt;br&gt;#       hostname    (radius.example.com)&lt;br&gt;ipaddr = 127.0</description>
</item>

<item>
    <title>Freeradius 2.1.6 не коннектится к базе PostgreSQL (sba)</title>
    <link>https://mobile.opennet.me/openforum/vsluhforumID1/86004.html#1</link>
    <pubDate>Sat, 18 Jul 2009 08:04:22 GMT</pubDate>
    <description>radiud.conf:&lt;br&gt;# -*- text -*-&lt;br&gt;##&lt;br&gt;## radiusd.conf-- FreeRADIUS server configuration file.&lt;br&gt;##&lt;br&gt;##http://www.freeradius.org/&lt;br&gt;##$Id$&lt;br&gt;##&lt;br&gt;&lt;br&gt;######################################################################&lt;br&gt;#&lt;br&gt;#Read &quot;man radiusd&quot; before editing this file.  See the section&lt;br&gt;#titled DEBUGGING.  It outlines a method where you can quickly&lt;br&gt;#obtain the configuration you want, without running into&lt;br&gt;#trouble.&lt;br&gt;#&lt;br&gt;#Run the server in debugging mode, and READ the output.&lt;br&gt;#&lt;br&gt;#$ radiusd -X&lt;br&gt;#&lt;br&gt;#We cannot emphasize this point strongly enough.  The vast&lt;br&gt;#majority of problems can be solved by carefully reading the&lt;br&gt;#debugging output, which includes warnings about common issues,&lt;br&gt;#and suggestions for how they may be fixed.&lt;br&gt;#&lt;br&gt;#There may be a lot of output, but look carefully for words like:&lt;br&gt;#&quot;warning&quot;, &quot;error&quot;, &quot;reject&quot;, or &quot;failure&quot;.  The messages there&lt;br&gt;#will usually be enough to guide you to a solution.&lt;br&gt;#&lt;br&gt;#If you are going to ask a question on the mailing list, then&lt;br&gt;#explain what you are tryi</description>
</item>

</channel>
</rss>
