[freeside] Error creating tables with fs-setup

[David O'Connor]

BTW, I have tried deleting and re-creating the database :

[root at web9 mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 56608 to server version: 3.23.49-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> use freeside
Database changed
mysql> show tables;
Empty set (0.00 sec)

and ditched the dbdef file :

[root at web9 freeside]# pwd
/usr/local/etc/freeside
[root at web9 freeside]# ls -al
total 32
drwxr-xr-x    5 freeside root         4096 Mar  6 12:36 .
drwxr-xr-x    4 root     root         4096 Mar  5 09:30 ..
drwxrwxrwx    2 freeside freeside     4096 Mar  6 12:36 
conf.DBI:mysql:freeside
drwxr-----    2 freeside freeside     4096 Mar  6 12:16 
counters.DBI:mysql:freeside
drwxr-----    2 freeside freeside     4096 Mar  5 09:19 
export.DBI:mysql:freeside
-rwxr-----    1 freeside freeside       38 Mar  5 16:16 freeside.secret
-rwxr-----    1 freeside freeside       39 Mar  5 09:30 hostonce.secret
-rwxr-----    1 freeside freeside       50 Feb 27 14:38 mapsecrets

but I still get
[freeside at web9 freeside]$ /usr/local/freeside-1.3.1/bin/fs-setup freeside

Enter the maximum username length: 12


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.
:
DBD::mysql::db do failed: Duplicate key name 'cust_pkg1' at 
/usr/local/freeside-1.3.1/bin/fs-setup line 282.
CREATE error: Duplicate key name 'cust_pkg1'
doing statement: CREATE INDEX cust_pkg1 ON cust_pkg (custnum)


Anyone got any ideas ? Help much appreciated ;-)

Cheers,
Dave O'Connor



>From: Erich Zigler <erichz at superhero.org>
>Reply-To: ivan-freeside at sisd.com
>To: ivan-freeside at sisd.com
>Subject: Re: [freeside] Error creating tables with fs-setup
>Date: Wed, 6 Mar 2002 08:53:00 -0600
>
>On Wednesday 06 March 2002 06:19 am, you wrote:
>
> > Hey !
> > When I run fs-setp I get the following error :
> > DBD::mysql::db do failed: Duplicate key name 'cust_pkg1' at ./fs-setup
> > line 282.
>
>What version of freeside are you running?
>
>--
>Software is like sex -- it's better if RMS isn't involved -- because you'd
>have to share your partner with RedHat -- wac




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx