fs-setup chokes

Lanny Baron lnb at crosswind.net
Thu Jan 31 15:35:40 PST 2002


So I just found out. Freeside database initialized sucessfully

Now the other side of the equation. Can't get to the site (here). Server 
Error. Logs say: configuration error:  couldn't check user.  No user file?: 
/freeside
I hope i can figure this out. But at least the DB is installed properly :) 

 --Lanny
Kristian Hoffmann writes: 

> 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 
>>
> 
 


+~+~+~+~+~+~+~+~+~+~+~+
Senior Unix Administrator,
CrossWind Enterprises 



More information about the freeside-users mailing list