<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<font class="Apple-style-span" face="Tahoma" size="2">I have replace voip-postpaid.conf with new one but still the same. </font><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">I this configuration file (voip-postpaid.conf) is written:</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div><div><font class="Apple-style-span" face="Tahoma" size="2">uthcheck_table = "radcheck"</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"> authreply_table = "radreply"</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2"> groupcheck_table = "radgroupcheck"</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"> groupreply_table = "radgroupreply"</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2"> usergroup_table = "radusergroup"</font></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">But in readme file is written that I must import cisco_h323_db_schema.sql in postgresql.</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">In this shema (cisco_h323_db_schema.sql) there is no rad check or radreplay, only startvoip, etc.</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">Thank you very much with your help!!!</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">miha</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><br><div id="SkyDrivePlaceholder" style="font-family: Tahoma; font-size: 10pt; "></div><font class="Apple-style-span" face="Tahoma" size="2">> Date: Tue, 7 Dec 2010 22:43:32 +0700</font><br><font class="Apple-style-span" face="Tahoma" size="2">> Subject: Re: Voip database</font><br><font class="Apple-style-span" face="Tahoma" size="2">> From: work@fajar.net</font><br><font class="Apple-style-span" face="Tahoma" size="2">> To: freeradius-users@lists.freeradius.org</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> On Tue, Dec 7, 2010 at 9:39 PM, Miha Zoubek <miha_zoubek@hotmail.com> wrote:</font><br><font class="Apple-style-span" face="Tahoma" size="2">> > I put it there but still the same problem:</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> No, it's not. It's a different problem. Look at the debug log you</font><br><font class="Apple-style-span" face="Tahoma" size="2">> posted and you'll see it's a different problem altogether.</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> > [pgsql-voip] expand: %{User-Name} -> 081609000</font><br><font class="Apple-style-span" face="Tahoma" size="2">> > [pgsql-voip] sql_set_user escaped user --> '081609000'</font><br><font class="Apple-style-span" face="Tahoma" size="2">> > rlm_sql (pgsql-voip): Reserving sql socket id: 24</font><br><font class="Apple-style-span" face="Tahoma" size="2">> > [pgsql-voip] expand: -></font><br><font class="Apple-style-span" face="Tahoma" size="2">> > [pgsql-voip] Error generating query; rejecting user</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> I'd focus on the last two lines.</font><br><font class="Apple-style-span" face="Tahoma" size="2">> If the contents of your sql conf file contains something like this</font><br><font class="Apple-style-span" face="Tahoma" size="2">> (as shown in your previous debug)</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> authorize_check_query = ""</font><br><font class="Apple-style-span" face="Tahoma" size="2">> authorize_group_check_query = ""</font><br><font class="Apple-style-span" face="Tahoma" size="2">> authorize_group_reply_query = ""</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> then the simple answer is you broke the config. Look at the original</font><br><font class="Apple-style-span" face="Tahoma" size="2">> .conf file that comes with the distro/freeradius source (should be</font><br><font class="Apple-style-span" face="Tahoma" size="2">> dialup.conf or some other file under /etc/raddb/sql or its</font><br><font class="Apple-style-span" face="Tahoma" size="2">> subdirectory).</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> -- </font><br><font class="Apple-style-span" face="Tahoma" size="2">> Fajar</font><br><font class="Apple-style-span" face="Tahoma" size="2">> </font><br><font class="Apple-style-span" face="Tahoma" size="2">> -</font><br><font class="Apple-style-span" face="Tahoma" size="2">> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html</font><br></div> </body>
</html>