Voip database

[Miha Zoubek]

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 at fajar.net
> To: freeradius-users at lists.freeradius.org
> 
> On Tue, Dec 7, 2010 at 9:39 PM, Miha Zoubek <miha_zoubek at 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
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101208/a157cf5c/attachment.html>