[freeside] Problem running fs-radius-add-reply under 1.3.1

[ivan]

See htdocs/docs/postgresql.html - you need to recompile Pg with 64
character column names.

The note at the bottom is actually out of date; I have gotten Pg working
with larger column names.

A future version of Freeside will keep all column names under 31
characters.

On Sat, Jun 09, 2001 at 09:45:45PM -0400, Robert Haskins wrote:
> I am trying to get Freeside 1.3.1 running under following configuration:
> 
> Solaris 8
> pgsql 7.1.1
> DBI-1.16
> DBD-Pg-0.95
> Perl 5.6.1
> 
> I'm re-installing freeside 1.3.1 after dropping the old database I had. 
> I'm trying to add RADIUS reply attributes and I get errors. (It doesn't 
> matter if I try to add them as part of the fs-setup script or the 
> fs-radius-add-reply; they both fail, with slightly different errors 
> though.) Here is a complete listing of what is happening when trying to 
> run the standalone fs-radius-add-reply script:
> 
> bash-2.05$ ./fs-radius-add-reply freeside
> 
> 
> Enter the additional RADIUS reply attributes you need to track for
> each user, separated by whitespace.
> :User-Service Framed-Protocol
> NOTICE:  identifier "svc_acct__radius_user_service_flag" will be 
> truncated to "svc_acct__radius_user_service_f"
> NOTICE:  identifier "svc_acct__radius_framed_protocol" will be truncated 
> to "svc_acct__radius_framed_protoco"
> NOTICE:  identifier "svc_acct__radius_framed_protocol_flag" will be 
> truncated to "svc_acct__radius_framed_protoco"
> DBD::Pg::db do failed: ERROR:  ALTER TABLE: column name 
> "svc_acct__radius_framed_protoco" already exists in table "part_svc"
> Error executing ALTER TABLE part_svc ADD 
> svc_acct__radius_Framed_Protocol_flag char(1) NULL;: ERROR:  ALTER 
> TABLE: column name "svc_acct__radius_framed_protoco" already exists in 
> table "part_svc"
> 
> 
> Now you must run dbdef-create.
> --
> Here is the error I get when I try to add the as part of the fs-setup 
> script with a clean database:
> 
> bash-2.05$ ./fs-setup freeside
> 
> Enter the maximum username length: 20
> 
> 
> Freeside tracks the RADIUS attributes User-Name, check attribute 
> Password and
> reply attribute Framed-IP-Address for each user.  You can specify additional
> check and reply attributes.  First enter any additional RADIUS check 
> attributes
> you need to track for each user, separated by whitespace.
> :
> 
> 
> Now enter any additional reply attributes you need to track for each user,
> separated by whitespace.
> :User-Service Framed-Protocol
> NOTICE:  identifier "svc_acct__radius_user_service_flag" will be 
> truncated to "svc_acct__radius_user_service_f"
> NOTICE:  identifier "svc_acct__radius_framed_protocol" will be truncated 
> to "svc_acct__radius_framed_protoco"
> NOTICE:  identifier "svc_acct__radius_framed_protocol_flag" will be 
> truncated to "svc_acct__radius_framed_protoco"
> DBD::Pg::db do failed: ERROR:  CREATE TABLE: attribute 
> "svc_acct__radius_framed_protoco" duplicated
> CREATE error: ERROR:  CREATE TABLE: attribute 
> "svc_acct__radius_framed_protoco" duplicated
> 
> doing statement: CREATE TABLE part_svc (
>    svcpart int NOT NULL  ,
>    svc varchar(80) NOT NULL  ,
>    svcdb varchar(80) NOT NULL  ,
>    svc_acct__username varchar(80)   ,
>    svc_acct__username_flag char(1)   ,
>    svc_acct___password varchar(80)   ,
>    svc_acct___password_flag char(1)   ,
>    svc_acct__popnum varchar(80)   ,
>    svc_acct__popnum_flag char(1)   ,
>    svc_acct__uid varchar(80)   ,
>    svc_acct__uid_flag char(1)   ,
>    svc_acct__gid varchar(80)   ,
>    svc_acct__gid_flag char(1)   ,
>    svc_acct__finger varchar(80)   ,
>    svc_acct__finger_flag char(1)   ,
>    svc_acct__dir varchar(80)   ,
>    svc_acct__dir_flag char(1)   ,
>    svc_acct__shell varchar(80)   ,
>    svc_acct__shell_flag char(1)   ,
>    svc_acct__quota varchar(80)   ,
>    svc_acct__quota_flag char(1)   ,
>    svc_acct__slipip varchar(80)   ,
>    svc_acct__slipip_flag char(1)   ,
>    svc_acct__seconds varchar(80)   ,
>    svc_acct__seconds_flag char(1)   ,
>    svc_acct__radius_User_Service varchar(80)   ,
>    svc_acct__radius_User_Service_flag char(1)   ,
>    svc_acct__radius_Framed_Protocol varchar(80)   ,
>    svc_acct__radius_Framed_Protocol_flag char(1)   ,
>    svc_acct_sm__domsvc varchar(80)   ,
>    svc_acct_sm__domsvc_flag char(1)   ,
>    svc_acct_sm__domuid varchar(80)   ,
>    svc_acct_sm__domuid_flag char(1)   ,
>    svc_acct_sm__domuser varchar(80)   ,
>    svc_acct_sm__domuser_flag char(1)   ,
>    svc_domain__domain varchar(80)   ,
>    svc_domain__domain_flag char(1)   ,
>    svc_www__recnum varchar(80)   ,
>    svc_www__recnum_flag char(1)   ,
>    svc_www__usersvc varchar(80)   ,
>    svc_www__usersvc_flag char(1)
> )
> --
> If I drop the database and install it (by running fs-setup) without 
> trying to add RADIUS reply attributes, it works just fine.
> 
> I've looked through the mailing list archive and there is no mention of 
> this problem. Any help you can send my way is appreciated. Thanks!
> -- 
> Robert D. Haskins
> WorldNET
> mailto:rhaskins at wn.net
> http://www.ziplink.net/~rhaskins
> 

-- 
meow
_ivan