The foundation for your business
Fork me on GitHub
[users] Freebsd Ledgersmb 1.58 install
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[users] Freebsd Ledgersmb 1.58 install

I thought I give this another go
I was happy to be able to see the setup.pl

psql: FATAL: no pg_hba.conf entry for host "", user
"lsmb_dbadmin", database "database3", SSL off
at /usr/local/lib/perl5/site_perl/PGObject/Util/DBAdmin.pm line 265.

dbversion: 1.5.8, company: 

uname -a
FreeBSD ledgersmb 11.0-RELEASE-p1 FreeBSD 11.0-RELEASE-p1 #0: Sat May
13 12:21:07 EDT 2017 


2017/07/23-11:46:39 Starman::Server (type Net::Server::PreFork)
starting! pid(117 54)
Resolved [*]:5762 to []:5762, IPv4
Binding to TCP port 5762 on host with IPv4
No configuration file; running with default settings
No configuration file; running with default settings
No configuration file; running with default settings
No configuration file; running with default settings
No configuration file; running with default settings
psql: FATAL:  no pg_hba.conf entry for host "", user
"lsmb_dbadmin", da tabase "database3", SSL off

Use of uninitialized value in concatenation (.) or string
at /usr/local/www/ledgersmb/tools/../lib/LedgerSMB.pm line 507.

Jul 23 11:48:10 ledgersmb postgres[12042]: [5-1] FATAL:  no pg_hba.conf
entry for host "", user "lsmb_dbadmin", database "database3",
SSL off Jul 23 11:48:11 ledgersmb postgres[12047]: [5-1] FATAL:  no
pg_hba.conf entry for host "", user "lsmb_dbadmin", database
"database3", SSL off

and this is a mess.
Flondering at its best

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all               trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
host    postgres,template0,template1   lsmb_dbadmin     md5 host    postgres,template0,template1
lsmb_dbadmin         ::1/128      md5 host
tesdatabase2		         lsmb_dbadmin   md5 #host    postgres,template0,template1
all     reject #host
postgres,template0,template1   all          ::1/128      reject # Allow
replication connections from localhost, by a user with the #
replication privilege. #local   replication
postgres                                trust #host    replication
postgres            trust #host    replication
postgres        ::1/128                 trust

I have tried various times with various settings. So I have really
screwed up somewhere

/tmp/ledgersmb no logs showing


# This file is an example file for the configuration of LedgerSMB.
# A copy should be in the ledgersmb root directory, or an environment
# variable by the name LSMB_CONFIG_FILE should hold the name
# of an alternative location
# e.g.

auth = DB
logging  = 1
# Be aware of tempdir setting. If client_browser and server_apache on
same # machine, sharing tmp-dir , problems 'Permission denied' if
server tries to # write temp-file which already exists as client-owned
# Note tempdir is used as the basename of the dir, the real dirname is
equivalent to....
#    /tmp/ledgersmb-$EUID/
#  If you specify a different dir to /tmp/ledgersmb ensure it's parent
is writabl e by the running user.
tempdir = /tmp/ledgersmb

# This is the logical CSS directory.  I.e. it is what comes before the
# ledgersmb.css in the url.  Example might be /my_css_dir/ or
# http://localhost/other_css_dir/
cssdir = css/

# THis is the location on the file system where the css files are, for
editing # and selection.  An example might be /var/www/ledgersmb_css/
fs_cssdir = css/

# If set to a true value this caches templates.  Typically it will be
set to 0 # to disable or 1 to enable.

cache_templates = 0

# Set language for login and admin pages
language =

log_level = ERROR
#DBI_TRACE = 1=/tmp/dbi.trace
# For Windows, uncomment the pathsep line=
# pathsep = ;

# Maximum POST size to prevent DoS (4MB default)
max_post_size = 4194304

# Spelling of cookie name for this instance of LedgerSMB.
# Used to keep multiple instances and/or different versions
# logged in at the same time
cookie_name = LedgerSMB-1.5

# This is the string we look for in the failed connection error to
determine # if the database was not found.  For English-language
locales, this can be # left in place.  If the database server is
running a different locale, it may # need to be changed.  Any partial
match on the connection error assumes that # the failure to connect was
caused by an invalid database request. no_db_str = database

# This is the Dojo theme to be used by default -- e.g. when no other
theme # has been selected.
#dojo_theme = claro

# If the server can't find applications, append to the path

# If on Mac OS X using Fink's Perl libs, append to the path
#PERL5LIB = /sw/lib/perl5

PERL5LIB = /usr/local/lib/perl5
templates  = templates
# images base directory
images  = UI/images

# location we write backup files to on the server
backupdir = /tmp/ledgersmb/ledgersmb-backups

localepath = locale/po

# program to use for file compression
gzip       = gzip -S .gz

# For latex and pdflatex, specify  full path.  These will be used to
configure # Template::Latex so it can find them.  This can be used to
specify programs # other than vanilla latex and pdflatex, such as the
xe varieties of either one, # if unicode is required.
# If these are not set, the package defaults (set when you installed
# Template::Latex) will be used
# pdflatex = /usr/bin/pdflatex
# latex    = /usr/bin/latex
# dvips    = /usr/bin/dvips

### How to send mail.  The sendmail command is used unless smtphost is
set. sendmail   = /usr/bin/sendmail
# smtphost =
# smtptimeout = 60
# backup_email_from = backups@lsmb_hosting.com

# Available printers
Laser      = lpr -Plaser
Epson      = lpr -PEpson

# Sets database connection parameters.  Note that default_db can be
left blank # if you want to force people to enter a company name at
login. port = 5432
default_db = lsmb13
host = localhost
db_namespace = public
# sslmode can be require, allow, prefer, or disable.  Defaults to
prefer. sslmode = prefer


# This is the boolean indicating if dojo's compacted output ("built
output") # should be used or the development version [1 = 'true' ==>
'built version'] #
# this should be used in versions you download from packages, but should
# NOT be used when running directly from version control software
because # you cannot guarantee you are running the correct versions of
dojo # widgets with your aplication in that case.
dojo_built = 0

LedgerSMB = INFO
LedgerSMB.DBObject = INFO

any help would be appreciated

users mailing list