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(a)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
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This release
contains the following fixes and improvements:
Changelog for 1.5.9
* Fix goods/services search with AR/AP invoices (Chris T, #2938)
* Fix inventory activity report drill down over-inclusive (Chris T, #2926)
* Fix Ship/Receive column alignments (Chris T)
* Fix mailing recurring invoices shows invoice in-screen (Erik H, #3004)
* Fix missing column SQL error when posting recurring invoices (Erik H)
* Show an error when page assets (Dojo) are missing (Erik H)
* Fix new welcome page being referred to by absolute path (Erik H, #2994)
* Fix 'Not an ARRAY reference' error in recurring AP processing (Erik H, #2973)
* Fix recurring AP invoices posted but 'next date' unchanged (Erik H, #3019)
* Fix the fix for '.' missing in @INC (Erik H)
* Add lighttpd example config (Yves L)
* Fix regression in setup.pl with LedgerSMB 1.2 or SQL Ledger db (Yves L)
* Fix error when adding customer-specific price to customer (Erik H, #2643)
* Fix can't edit sales & purchase quotation through web UI (Erik H, #2617)
* Fix string match operator typo in company searches (Erik H)
* Fix LedgerSMB 1.2->1.5 migration script syntax errors (Erik H)
* Add migration non-standard (gl) 'account links' for 1.2->1.5 (Erik H)
* When including code with 'do', don't silently skip errors (David G, #3020)
Chris T is Chris Travers
Erik H is Erik Huelsmann
Yves L is Yves Lavoie
David G is David Godfrey
The release can be downloaded from our download site at
http://download.ledgersmb.org/f/Releases/1.5.9/
Additionally, the release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.9
or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.5.9
These are the sha256 checksums of the uploaded files:
48977307f6bb1cd60b5d43bfe763b373402115b11435afe5fde837a9c142f5ef ledgersmb-1.5.9.tar.gz
9236a6aaf650f5918e6e1bbfe4a149e7f17917363e7a7da8e0cffd3f0fad7a88 ledgersmb-1.5.9.tar.gz.asc
It had been commented by various people that they have been seeing error
messages regarding the apt.ledgesmb.org repository key being too small or
too "week" when the repository was being accessed, like the following
example comment:
apt update returns W: http://apt.ledgersmb.org/dists/xenial/InRelease:
Signature by key 1ED705D54028F70F45E32340D0F530B7F93ECF4F uses weak digest
algorithm (SHA1) at the end
I've created a 4K RSA key for the repository and have added it to the
configuration there, and updated the home page about it. Will be using
both the old and the new key for a bit, but then the old key will be
removed from the configuration.
--
Robert J. Clay
rjclay(a)gmail.com
jame(a)rocasa.us
Greetings;
I want to install LSMB on my server. I have a small amount of experience
installing Perl scripts. I have installed both FosWiki and RT behind
Apache via fcgid, but I still have a few Perl related questions.
Here is where I am so far:
1 - I have installed the latest Postgres (9.6.2) from source, the system
(CentOS V7) doesn't have the required version (9.4 or newer) in it's
repo (it has 9.2)
2 - If I install LSMB in the default manner, I end up using the system
Perl, and cpanm installs modules listed in the cpanfile in the user's
home directory. I do not want to use the system Perl, and have already
installed a separate, Perl 5.24 instance that I use for Request Tracker
and FosWiki. I have installed local::lib and cpanm as modules in the
custom Perl 5.24
3 - My system Perl is 5.10 and the cpanfile calls for Perl 5.14
4 - There is an instance of Perl 5.10 in the home directory of the user
account that will host LSMB (probably because I have CageFS on this
server). So installing Perl 5.24 modules in the user's home directory
won't work.
5 - My understanding is that by default, cpanm installs modules in the
user’s home directory.
6 - I’m confident I can tell cpanm to install the modules somewhere else
(<ledgersmb-root>/lib/cpan).
Questions:
A - how do I tell LSMB to look for modules in <ledgersmb-root>/lib/cpan
? (I think I can use the statement "use Local::Lib
<ledgersmb-root>/lib/cpan" but where would I put it?
B - how do I tell LSMB to use the non-system Perl?
C - In FosWiki and RT, I use a script (from stackoverflow.com) that
changes the shebang statement in all Perl files. Would that work for
LSMB? (there are no shebang statements except in cpanfile).
Thanks in advance!
Paul
