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