Hi I thought I give this another go I was happy to be able to see the setup.pl However http://10.0.0.231:5762/setup.pl?action=create_db&database=database3 Error!
psql: FATAL: no pg_hba.conf entry for host "10.0.0.231", 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
/var/log/starman/starman.log
2017/07/23-11:46:39 Starman::Server (type Net::Server::PreFork) starting! pid(117 54) Resolved [*]:5762 to [0.0.0.0]:5762, IPv4 Binding to TCP port 5762 on host 0.0.0.0 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 "10.0.0.231", user "lsmb_dbadmin", da tabase "database3", SSL off
APPLICATION ERROR Use of uninitialized value in concatenation (.) or string at /usr/local/www/ledgersmb/tools/../lib/LedgerSMB.pm line 507.
/var/log/messages Jul 23 11:48:10 ledgersmb postgres[12042]: [5-1] FATAL: no pg_hba.conf entry for host "10.0.0.231", 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 "10.0.0.231", user "lsmb_dbadmin", database "database3", SSL off
and this is a mess. Flondering at its best /var/db/postgres/data96/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust host postgres,template0,template1 lsmb_dbadmin 10.0.0.231/32 md5 host postgres,template0,template1 lsmb_dbadmin ::1/128 md5 host tesdatabase2 lsmb_dbadmin 10.0.0.231/32 md5 #host postgres,template0,template1 all 127.0.0.1/32 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 127.0.0.1/32 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
/usr/local/www/ledgersmb/conf/ledgersmb.conf
# 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. LSMB_CONFIG_FILE=/usr/local/www/ledgersmb/conf/ledgersmb.conf
[main] 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 DBI_TRACE = 0 # 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
[environment] # If the server can't find applications, append to the path PATH=/bin:/usr/bin:/usr/local/bin:/usr/local/bin/postgres
# 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
[programs] # 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 #
[mail] ### How to send mail. The sendmail command is used unless smtphost is set. sendmail = /usr/bin/sendmail # smtphost = 127.0.0.1 # smtptimeout = 60 # backup_email_from = backups@lsmb_hosting.com
[printers] # Available printers Laser = lpr -Plaser Epson = lpr -PEpson
[database] # 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
[debug]
# 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
[log4perl_config_modules_loglevel] LedgerSMB = INFO LedgerSMB.DBObject = INFO
any help would be appreciated
Geordie