Can't get secrets

[Ivan Kohler]

I'll try to clear things up.

There are three different kinds of usernames here: actual system username,
Apache usernames, and SQL usernames.  The current documentation is
probably confusing with regards to keeping this clear.  :/

System usernames, i.e. accounts in /etc/passwd.  For this, we just use one
`freeside' system user.

Apache usernames: stored in an htpasswd file, or (if you're using
Authen::DBI) stored in a separate SQL database.  (even if you store them
in an SQL database, they're _not_ the SQL usernames... we'll get to those
in a sec)

When you enter your password into your browser, It gets looked up in the
`/usr/local/etc/freeside/mapsecrets' file.  So if you've got a `mark'
Apache user, you would put the line (with no leading whitespace though):

    mark secrets

in the mapsecrets file.  The `secrets' part is a filename; it could be
`secrets.the_main_database' or `my_left_shoe'.  It is located in
/usr/local/etc/freeside/

In this file, you put (again, with no leading whitespace):

    DBI:mysql:freeside
    freeside
    password

The `DBI:mysql:freeside' is the DBI datasource, sometimes known in the DBI
documentation as `dsn' for data source name. (for Postgres, it looks like
`DBI:Pg:dbname=freeside').  The next two lines are the SQL username and
password used to log on to the SQL database.

The rest of the configuration files are located in the directory
`/usr/local/etc/freeside/conf.<datasec>', i.e.
`/usr/local/etc/freeside/conf.DBI:mysql:freeside'.

You still won't be able to clik on `New Customer' until you've setup your
configuration files, run bin/fs-setup, and added entries to the
administration section on the web interface.

Hope that helps.

On Tue, Apr 20, 1999 at 06:51:48PM -0400, mark strawser wrote:
> Hi folks, 
> 
> Been playing w/ Freeside for a week or so now, reading the mailing lists
> and working my way thru various problems. I'm now at a point where I'm
> stuck and could use some advice/help. I'm nearly at the end of the
> installation instructions, at the "configuration files" section. I find the
> instructions for setting this up vague, and have tried a few things, but
> still no dice.
> 
> I set up the file /usr/local/etc/freeside. My first attempt I used the
> (old?) format from /usr/local/fs-1.2.1/conf/secrets file, like this: 
> 
> DBI:mysql:freeside
> freeside
> freeside
> 
> "freeside" is a fully priviliged user in system (linux 2.0.35) and MySQL.
> I've also tried this w/ user "mark" pass "mark" who is auth'd thur
> .htaccess. No luck. Then tried it in the (new?) format like this: 
> 
> freeside freeside
> mark mark
> 
> Both of these give the error: 
> 
> Can't get secrets: No such file or directory at
> /usr/lib/perl5/site_perl/5.005/FS/UID.pm line 224. 
> 
> when I try to access "New Customer" on the main menu on my own server.
> 
> Like I said, I'm having trouble understanding the directions for setting
> this part up. Maybe I'm just stupid :)
> 
> Also, I've not completed the rest of the steps in the install, so just
> doing this may clear up the problem. I've not because a) I don't want to
> skip over a step when I don't believe I've set it up correctly b) I don't
> understand the instructions for "datasrc" either. (Explanation and/or
> example of this step would be helpful as well)
> 
> Hope I've provided enough info. Thanx in advance for help.
> 
> mark
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too