[freeside] Re: fs-setup chokes

Kristian Hoffmann khoff at pc-intouch.com
Thu Jan 31 15:30:52 PST 2002


You already have tables and/or data in your database.  fs-setup expects
there to be no tables and no data, hence the "Table 'cust_pkg' already
exists" error.  If you don't have any data in the database yet, just drop
the tables or the whole database and recreate it.

-Kristian

On Thu, 31 Jan 2002, Lanny Baron wrote:

> Hi,
> I did the mkdir and chown, ran fs-setup again, and now mysql error:
>
> Now enter any additional reply attributes you need to track for each user,
> separated by whitespace.
> :
> DBD::mysql::db do failed: Table 'cust_pkg' already exists at ./fs-setup line
> 282.
> CREATE error: Table 'cust_pkg' already exists
> doing statement: CREATE TABLE cust_pkg (
>  pkgnum int NOT NULL  ,
>  custnum int NOT NULL  ,
>  pkgpart int NOT NULL  ,
>  otaker varchar(8) NOT NULL  ,
>  setup int NULL  ,
>  bill int NULL  ,
>  susp int NULL  ,
>  cancel int NULL  ,
>  expire int NULL  ,
>  PRIMARY KEY (pkgnum)
> )
>
> Ivan wrote in the next thread that I did not create all dirs as per
> installation instructions. Here is a listing of the freeside dir:
>
> whirl# ll
> total 33
> drwxr-xr-x  2 freeside  wheel    512 Jan 31 03:28 conf.DBI
> drwxr-xr-x  2 freeside  wheel    512 Jan 31 04:44
> conf.DBI:mysql:host=localhost:dbname=freeside
> drwxr-xr-x  2 freeside  wheel    512 Jan 31 17:11
> counters.DBI:mysql:host=localhost;dbname=freeside
> drwxr-xr-x  2 freeside  wheel    512 Jan 31 03:55 counters.datasrc
>  -rw-r--r--  1 freeside  wheel      0 Jan 31 04:52
> dbdef.DBI:mysql:host=localhost
>  -rw-r--r--  1 freeside  wheel  26269 Jan 31 17:12
> dbdef.DBI:mysql:host=localhost;dbname=freeside
> drwxr-xr-x  2 freeside  wheel    512 Jan 31 03:55 export.datasrc
>  -rw-r--r--  1 freeside  wheel     21 Jan 31 14:21 mapsecrets
>  -rw-r--r--  1 freeside  wheel     58 Jan 31 14:22 secretfile
>
> Thanks,
> Lanny
>
>
>
>
> Jeff Finucane writes:
>
> > "Lanny Baron" <lnb at crosswind.net> wrote on 31 Jan 2002 23:01:23 GMT....
> >
> > +----------
> > | Received: (qmail 464 invoked from network); 31 Jan 2002 23:01:24 -0000
> > | Message-ID: <20020131230123.74085.qmail at crosswind.net>
> > | References: <20020131214152.43807.qmail at crosswind.net>
> > |             <20020131135232.A26765 at cleanwhisker.420.am>
> > | In-Reply-To: <20020131135232.A26765 at cleanwhisker.420.am>
> > | From: "Lanny Baron" <lnb at crosswind.net>
> > | To: ivan-freeside at sisd.com
> > | Subject: [freeside] Re: fs-setup chokes
> > |
> > | Hi Ivan,
> > | Ok, I fixed the last one...mysql needed the perl module. Running fs-setup
> > | fireside again,
> > | Can't create
> > | /usr/local/etc/freeside/counters.DBI:mysql:host=localhost;dbname=freeside/cu
> > | st_main_county.taxnum: No such file or directory at
> > | /usr/local/lib/perl5/site_perl/5.005/FS/Record.pm line 568
> > |
> > | What do I do with that?
> > +----------
> >
> >   mkdir /usr/local/etc/freeside/counters.DBI:mysql:host=localhost\;dbname=freeside
> >   chown freeside /usr/local/etc/freeside/counters.DBI:mysql:host=localhost\;dbname=freeside
> >
> >
> > --
> > jeff at cmh.net
> >
> > "There is no worse tyranny than to force a man to pay for what he does
> >  not want merely because you think it would be good for him."
> >
> >  Professor Bernardo de le Paz
> >   [ R.A. Heinlein -- "The Moon is a Harsh Mistress" ]
> >
>
>
>
> +~+~+~+~+~+~+~+~+~+~+~+
> Senior Unix Administrator,
> CrossWind Enterprises
>




More information about the freeside-users mailing list