<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" style="font-size: 10pt; ">Thank you for your help!</font><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; ">I included dailup.conf in voip-postpaid.conf.</div><div style="font-family: Tahoma; font-size: 10pt; ">Now I getting different error:</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">I have put this in tables:</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-size: 10pt; "><font class="Apple-style-span" face="arial, tahoma, verdana, helvetica, sans-serif, serif"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Nas: nasname: intraswitch, shortname: intraswitch, type: other, port: 1812: sercet: b, server: 1.2.3.4 (ip server), nad for comunity and dicription null</span></font></div><div style="font-size: 10pt; "><font class="Apple-style-span" face="arial, tahoma, verdana, helvetica, sans-serif, serif"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Radcheck: id: 1, username: 081609000, attribure: </span></font><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">Cleartext-Password, Value: 12345, op: :=</span></div><div><font class="Apple-style-span" face="arial, tahoma, verdana, helvetica, sans-serif, serif"><span class="Apple-style-span" style="font-size: 11px; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Radreply: id:1 , username: 081609000: atributte: </span></font><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">Fall-Through, op: =, vaule: yes</span></div><div><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><br></span></div><div><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><br></span></div><div><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">Thank you!</span></div><div><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><br></span></div><div><span class="Apple-style-span" style="font-size: 11px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; white-space: nowrap; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><br></span></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; "><div>ecv: Access-Request packet from host 212.13.228.58 port 38380, id=198, length=206</div><div> Acct-Multi-Session-Id = "1291817780502"</div><div> Cisco-Attr-130 = 0x683332332d63616c6c696e672d656e74657270726973652d69643d656e74504258</div><div> Calling-Station-Id = "81609000"</div><div> NAS-Identifier = "intraswitch"</div><div> NAS-IP-Address = 212.13.228.58</div><div> 3GPP2-Prepaid-acct-Capability = 0x010600000002</div><div> 3GPP2-Session-Termination-Capability = 1</div><div> h323-conf-id = "h323-conf-id=1291817780502"</div><div> Vendor-Specific = 0x00000009</div><div> Event-Timestamp = "Dec 8 2010 15:16:20 CET"</div><div> User-Name = "081609000"</div><div> User-Password = "12345"</div><div># Executing section authorize from file /etc/raddb/sites-enabled/default</div><div>+- entering group authorize {...}</div><div>++[preprocess] returns ok</div><div>++[chap] returns noop</div><div>++[mschap] returns noop</div><div>++[digest] returns noop</div><div>[suffix] No '@' in User-Name = "081609000", looking up realm NULL</div><div>[suffix] No such realm "NULL"</div><div>++[suffix] returns noop</div><div>[eap] No EAP-Message, not doing EAP</div><div>++[eap] returns noop</div><div>[pgsql-voip] expand: %{User-Name} -> 081609000</div><div>[pgsql-voip] sql_set_user escaped user --> '081609000'</div><div>rlm_sql (pgsql-voip): Reserving sql socket id: 24</div><div>[pgsql-voip] expand: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '081609000' ORDER BY id</div><div>rlm_sql_postgresql: Status: PGRES_TUPLES_OK</div><div>rlm_sql_postgresql: query affected rows = 1 , fields = 5</div><div>[pgsql-voip] expand: SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority -> SELECT GroupName FROM radusergroup WHERE UserName='081609000' ORDER BY priority</div><div>rlm_sql_postgresql: Status: PGRES_TUPLES_OK</div><div>rlm_sql_postgresql: query affected rows = 0 , fields = 1</div><div>rlm_sql (pgsql-voip): Released sql socket id: 24</div><div>[pgsql-voip] User 081609000 not found</div><div>++[pgsql-voip] returns notfound</div><div>++[expiration] returns noop</div><div>++[logintime] returns noop</div><div>[pap] WARNING! No "known good" password found for the user. Authentication may fail because of this.</div><div>++[pap] returns noop</div><div>ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user</div><div>Failed to authenticate the user.</div><div>Using Post-Auth-Type Reject</div><div># Executing group from file /etc/raddb/sites-enabled/default</div><div>+- entering group REJECT {...}</div><div>[attr_filter.access_reject] expand: %{User-Name} -> 081609000</div><div> attr_filter: Matched entry DEFAULT at line 11</div><div>++[attr_filter.access_reject] returns updated</div><div>Delaying reject of request 0 for 1 seconds</div><div>Going to the next request</div><div>Waking up in 0.9 seconds.</div><div>rad_recv: Access-Request packet from host 212.13.228.58 port 38380, id=198, length=206</div><div>Waiting to send Access-Reject to client intraswitch port 38380 - ID: 198</div><div>Sending delayed reject for request 0</div><div>Sending Access-Reject of id 198 to 212.13.228.58 port 38380</div><div>Waking up in 4.9 seconds.</div><br>> Date: Wed, 8 Dec 2010 16:29:27 +0700<br>> Subject: Re: Voip database<br>> From: work@fajar.net<br>> To: freeradius-users@lists.freeradius.org<br>> <br>> On Wed, Dec 8, 2010 at 2:55 PM, Miha Zoubek <miha_zoubek@hotmail.com> wrote:<br>> > I have replace voip-postpaid.conf with new one but still the same.<br>> > I this configuration file (voip-postpaid.conf) is written:<br>> > uthcheck_table = "radcheck"<br>> > authreply_table = "radreply"<br>> > groupcheck_table = "radgroupcheck"<br>> > groupreply_table = "radgroupreply"<br>> > usergroup_table = "radusergroup"<br>> <br>> Perhaps we started on the wrong assumptions.<br>> What do you intend to use postgresql for? Is it<br>> (a) only to store accounting data, or<br>> (b) to store user names/password AND accounting data<br>> <br>> if it's (a), then there should be nothing wrong with your first<br>> config. You simply need to place user data for "081609000" in whatever<br>> "database" you choose (whether it's users file, or something else).<br>> The error could simply be because you haven't define that user yet.<br>> <br>> <br>> If it's (b), then you need to forget for a moment that you're using it<br>> for voip. It doesn't really matter with regards to the problem you're<br>> facing. Get freeradius working with postgresql first.<br>> <br>> Your debug log says<br>> <br>> authorize_check_query = ""<br>> authorize_group_check_query = ""<br>> authorize_group_reply_query = ""<br>> <br>> when the they should not be empty. Fix that first. Worry about the<br>> rest later, after you fix that.<br>> <br>> The easiest way to do that, IMHO, is forget about voip-postpaid.conf<br>> and cisco_h323_db_schema.sql for the moment. Stick to the default<br>> sql.conf, sql/postgresql/dialup.conf, and sql/postgresql/schema.sql.<br>> <br>> <br>> AFTER you get it to work, then you can try to get that particular conf<br>> and sql scheme working. Perhaps the author might be able to help.<br>> <br>> The default sql.conf/dialup.conf and schema should work for voip or<br>> whatever. Probably not as efficient, but it'd still work.<br>> <br>> -- <br>> Fajar<br>> <br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></div> </body>
</html>