[freeside] the usergroup not exported to my radius database

[maruna]

Hi all,

Though the method I adopted to get the usergroup problem fixed is not the
appropriate one. However, it worked that way and the user was finally added
to the usergroup in the radius db.

The method is when adding group under the svc_acct creation for the ppp, I
added the group 10HRS and an empty space and then selected the two groups
i.e. 10HRS and a space on the addgroup then I selected fixed and this
finally added a group to the service. And the dial-up created then falls to
that group in the radius.usergroup

I have done this in the webdemo too. It worked the way I have done it in my
own case for both mine and webdemo.

Thankz

Aruna



-----Original Message-----
From: Shivkumar [mailto:] 
Sent: Monday, May 30, 2005 2:43 AM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] the usergroup not exported to my radius database

hi,
I might have to second aruna's observation.
I also tried adding a user group to my radaius database through the 
svc_acct options, but the group does not get reflected in the usergroup 
table on the freeradius server.
I'm sorry Ivan, but I think I screwed up the webdemo too!
I tried changing the usergroup for the test account someone had created. 
after i click on apply changes, I find that the original group has also 
disappeared and all attempts to bring it back have failed!
Any clues to this one?

Regards,

Shivkumar


maruna said the following:

> Hi,
>
>  
>
> I am always afraid to post a message, however, after battling with 
> google and freeside userlist archive for a while I have to see who 
> will help.
>
>  
>
> I set up a freeside (checkout from cvs on 18-05-05) using postgresql 
> -7.38 as backend. However, all is well. When I created the ppp service 
> as instructed in the 
>
http://www.sisd.com/cgi-bin/wiki.pl?How_To_Install_Freeradius_W/Mysql_On_The
_Signup_Server_Using_Debian_For_The_Linux_Challenged 
> . What I noticed was that whenever, the account is created by the 
> agent in the selfservice machine its not created to that group (cos I 
> check the sql server in the radius server,  I only find the username 
> and password in radcheck alone not in the usergroup).
>
>  
>
> Can somehow tell me what I have done wrong?.
>
>  
>
> Aruna
>
>  
>
> Below shows the logs of the freeside as the service/package is 
> provisioned.
>
>  
>
> [root at zebra root]# tail -f 
> /usr/local/etc/freeside/queuelog.DBI\:Pg\:dbname\=freeside
>
>  
>
> [Fri May 20 15:04:34 2005] [13263] running 
> &FS::part_svc::process(@args); at /usr/local/bin/freeside-queued line 192.
>
> [Fri May 20 15:04:34 2005] [13263] $VAR1 = {
>
>           'svc_acct__popnum_flag' => '',
>
>           'svc_acct__slipip_flag' => 'F',
>
>           'svc_acct__shell_flag' => '',
>
>           'svc' => 'Expresstest',
>
>           'svc_acct__username' => '',
>
>           'svc_acct__uid_flag' => 'D',
>
>           'svc_acct__slipip' => '0e0',
>
>           'svcpart' => '',
>
>           'svc_acct__dir_flag' => '',
>
>           'svc_acct__popnum' => '',
>
>           'svc_acct__quota' => '',
>
>           'svc_acct__gid_flag' => 'D',
>
>           'exportnum2' => '1',
>
>           'svc_acct__username_flag' => '',
>
>           'svc_acct___password_flag' => '',
>
>           'disabled' => '',
>
>           'svc_acct__uid' => '',
>
>           'svc_acct__domsvc_flag' => 'D',
>
>           'svc_acct__usergroup_add' => '',
>
>           'svc_acct__seconds' => '',
>
>           'svc_acct__finger' => '',
>
>           'svc_acct__usergroup_flag' => 'F',
>
>           'svc_acct__domsvc' => '1',
>
>           'svc_acct__quota_flag' => '',
>
>           'svc_acct__dir' => '',
>
>           'svc_acct__shell' => '',
>
>           'svcdb' => 'svc_acct',
>
>           'svc_acct__finger_flag' => '',
>
>           'svc_acct__seconds_flag' => '',
>
>           'svc_acct__sec_phrase_flag' => '',
>
>           'svc_acct__sec_phrase' => '',
>
>           'svc_acct___password' => '',
>
>           'svc_acct__gid' => '',
>
>           'svc_acct__usergroup' => 'Expresstest'
>
>         };
>
> [Fri May 20 15:08:11 2005] [13281] running 
> &FS::part_export::sqlradius::sqlradius_insert(@args); at
>
> /usr/local/bin/freeside-queued line 192.
>
> [Fri May 20 15:08:11 2005] [13283] running 
> &FS::svc_acct::append_fuzzyfiles(@args); at 
> /usr/local/bin/freeside-queued line
>
> 192.
>
> [Fri May 20 15:09:31 2005] [13326] running 
> &FS::part_export::sqlradius::sqlradius_insert(@args); at
>
> /usr/local/bin/freeside-queued line 192.
>
> [Fri May 20 15:09:31 2005] [13324] running 
> &FS::part_export::sqlradius::sqlradius_insert(@args); at
>
> /usr/local/bin/freeside-queued line 192.
>
>  
>
>  
>