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