LedgerSMB
The foundation for your business
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 _______________________________________________ users mailing list ..hidden.. https://lists.ledgersmb.org/mailman/listinfo/users