[freeside] Re: fs-setup chokes

ivan ivan at 420.am
Fri Feb 1 18:43:46 PST 2002


On Fri, Feb 01, 2002 at 09:40:59AM -0600, Dave Burgess wrote:
> Actually, I think he hasn't finished up the installation of the user
> components yet.

No.  The

  configuration error:  couldn't check user.  No user file?

error is from Apache.

> 
> There is a file in the /usr/local/freeside (or your equivalent) that defines which users can get
> access to the database.  If this file doesn't exist, the error shows up in the apache log.
> 
> ivan wrote:
> 
> > You need to setup Apache user authentication as documented at
> > http://httpd.apache.org/docs/misc/FAQ.html#user-authentication
> >
> > On Thu, Jan 31, 2002 at 11:35:38PM +0000, Lanny Baron wrote:
> > > 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
> >
> > --
> > _ivan
> 

-- 
_ivan



More information about the freeside-users mailing list