[freeside] Setup is impossible

[Jim Weeks]

Dennis Megarry wrote:

there is a file "fs-setup" located in one of the directories, but I can
not find any reference to this file anywhere in the doc's. I have not
found anything that helps you setup the initial mysql database

Look at the last line of  "docs/install.html"  You will find this line.

"As the freeside user, run bin/fs-setup to create the database tables. "



I created the dir "/usr/local/etc/freeside/conf.DBI:mysql:freeside" and
place the secrets file in there, still no good.


> Doesn't someone have a directory listing of where these files should
> be place?

Ok, here is what my /usr/local/etc/freeside directory contains.


total 23
-rw-r--r--  1 freeside  freeside     36 Dec  4 02:43 NewAccount
drwxr-xr-x  2 freeside  freeside    512 Dec  7 12:36 conf.DBI:mysql:freeside
drwxr-xr-x  2 freeside  freeside    512 Dec  4 20:53 counters.DBI:mysql:freeside
-rw-r--r--  1 freeside  freeside  16401 Dec  4 06:02 dbdef.DBI:mysql:freeside
drwxr-xr-x  2 freeside  freeside    512 Dec  4 02:50 export.DBI:mysql:freeside
-rw-r--r--  1 freeside  freeside     18 Dec  4 02:51 mapsecrets

freeside/conf.DBI:mysql:freeside:
total 6
-rw-r--r--  1 freeside  freeside   0 Dec  4 18:13 _home
-rw-r--r--  1 freeside  freeside  58 Dec  4 18:08 address
-rw-r--r--  1 freeside  freeside   0 Dec  4 20:49 deletecustomers
-rw-r--r--  1 freeside  freeside  13 Dec  4 18:09 domain
-rw-r--r--  1 freeside  freeside   0 Dec  4 18:10 hidecancelledpackages
-rw-r--r--  1 freeside  freeside   0 Dec  4 18:13 home
-rw-r--r--  1 freeside  freeside  40 Dec  4 18:16 invoice_from
-rw-r--r--  1 freeside  freeside  18 Dec  4 18:38 shellmachines
-rw-r--r--  1 freeside  freeside   9 Dec  4 19:40 shells
-rw-r--r--  1 freeside  freeside  10 Dec  4 18:19 smtpmachine

freeside/counters.DBI:mysql:freeside:
total 15
-rw-r--r--  1 freeside  freeside  15 Dec  4 18:23 agent.agentnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 18:22 agent_type.typenum
-rw-r--r--  1 freeside  freeside  19 Dec  4 20:49 cust_bill.invnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:53 cust_credit.crednum
-rw-r--r--  1 freeside  freeside  18 Dec  4 20:43 cust_main.custnum
-rw-r--r--  1 freeside  freeside  17 Dec  4 06:02 cust_main_county.taxnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:43 cust_main_invoice.destnum
-rw-r--r--  1 freeside  freeside  18 Dec  4 20:12 cust_pay.paynum
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:43 cust_pkg.pkgnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:43 cust_svc.svcnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:35 part_pkg.pkgpart
-rw-r--r--  1 freeside  freeside  15 Dec  4 18:24 part_referral.refnum
-rw-r--r--  1 freeside  freeside  15 Dec  4 17:30 part_svc.svcpart
-rw-r--r--  1 freeside  freeside  15 Dec  4 20:43 svc_acct.uid
-rw-r--r--  1 freeside  freeside  15 Dec  4 18:25 svc_acct_pop.popnum

freeside/export.DBI:mysql:freeside:

I am no expert on this, and have just started using it myself so bear with me.

The first thing, you have to create the files and directories listed in "docs/config.html" yourself.  You will want some of these files and some you will not.  It depends upon your desired functionality.

You might notice that I have a _home, and home directory in freeside/conf.DBI:mysql:freeside:  This is because I found that part of the instructions confusing.

The main missconception I hade was the question of the secrets file.  This seems to be one of your problems as well.  Notice I have a file named NewAccount.  Here is where the secrets file is demystified. Mapsecrets can contain several lines pointing to diferent iterations of freeside.  My first iteration is named NewAccount.  That being said, here is the contents of my mapsecrets file.

freeside NewAccount

The information the script is looking for is the username (the one that is demanded by .htaccess to authenticate the user), and the location of the actual secrets file which in this case is NewAccount. Now the contentes of NewAccount.

DBI:mysql:freeside

freeside

password

This is read as, Database engine datasource (directory), database username (MySql), and password (MySql).

I hope this helps.  If not we will try again.

--
Jim Weeks
jim at siteplus.com
http://siteplus.com