[freeside] Editing Users File Format

[Ivan Kohler]

On Thu, Jul 08, 1999 at 11:54:21AM -0700, dk smith wrote:
> I am in the same boat. Any swift answers to the list will be appreciated.
> Modifying the source should not be too difficult for this, however, I am
> unsure about the $ip variable not being not equal to 0e0. Is that just an
> arbitrary flag for NULL in some particular case?

Probably could be re-coded more readably.  "0e0" is a trick I stole from
DBI (see the DBI manapge) - it evaluates to 0 but is regarded as true. 

> Where does the $ip manifest itself in the GUI??

On the account view and edit screens.

> 
> I also have a situation wherein the wrong "service type" is set on several
> accounts. For example, accounts such as root, bin, uucp are set as "Dialup
> only"  which causes the Radius user file to filled with all of those
> accounts!!! This seems like a problem to me. Can I fix it easily? Can
> someone suggest what tools I need to make the changes? Is this an
> opportunity for dbimon or is it easier to re-install/import? At this time I
> only know how to spell SQL. So basic advice would be helpful...
> 
> PS: I did not perform the original config and import. Can anyone inform me
> as to what might have been done wrong during the setup (which would cause
> all those accounts to have an erroneous service type?

I'd suggest that you start from scratch.  It should give you a better
understanding of what's going on, instead of trying to fix problems you
don't understand in the first place.

http://w3.one.net/~jhoffman/sqltut.htm is an excellent and concise SQL
tutorial.

> 
> Thanks much...
> -dk
> 
> 
> 
> However, for some reason when things got imported...
> 
> >hi...
> >How can I properly edit the svc_acct.export to eliminate the quotes from
> >the Simultaneous-Use ="1" Attribute and eliminate the Frame-Adress =
> >"0.0.0.0" Attribute.
> >My Radius Server will NOT accept the following format :
> >
> >username  Password  = "password"
> >                     Simultaneous-Use  = "1",
> >                     Framed- Address  = "0.0.0.0"
> >
> >The format tha we need to have done is :
> >
> >username Password = "password" Expiration = "Jun 30 2000",
> >Simultaneous-Use = 1
> >
> >
> >I would also need a default entry to be generated in the users file that
> >have the following format:
> >
> >Default   Password = "Unix"
> >                 User-Service = Framed-User,
> >                 Framed-Protocol = PPP,
> >                 Framed-Routing = None,
> >                 Ascend-Assign-IP-Pool = 1,
> >                  Simultaneous-Use  = 1
> 
> 
> --
> dks at spies.com   |   Perception is nine tenths of the law.
> 
> 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too