LedgerSMB
The foundation for your business
On 08/28/2017 12:06 AM, David G wrote: > Hi Michael, > > Sorry to hear you have a problem installing. > Lets see what we can do to help. > > If you could start by answering the following questions please. > > * did you download the tarball, git repo, docker image, or debian package [MC] From the tarball. I installed into /usr/local/ledgersmb > * what do the following commands return > o [[ -x $(which apt) ]] && apt list libpgobject* || echo no apt [MC] libpgobject-perl/xenial,xenial,now 1.402.9-1 all [installed] libpgobject-simple-perl/xenial,xenial,now 1.8-1 all [installed] libpgobject-simple-role-perl/xenial,xenial,now 1.12.0-1 all [installed] libpgobject-type-bigfloat-perl/xenial,xenial,now 1.0.1-1 all [installed] libpgobject-util-dbmethod-perl/xenial,xenial,now 1.00.001-1 all [installed] > o perl -M'PGObject::Util::DBAdmin' -e 'print > "\nVERSION=$PGObject::Util::DBAdmin::VERSION\n";' [MC] VERSION=0.100.0 > o cat /etc/lsb-release /etc/issue /etc/redhat-release NAME="Ubuntu" VERSION="16.04.3 LTS (Xenial Xerus)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 16.04.3 LTS" VERSION_ID="16.04" HOME_URL="http://www.ubuntu.com/"; SUPPORT_URL="http://help.ubuntu.com/"; BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"; VERSION_CODENAME=xenial UBUNTU_CODENAME=xenial > /etc/suse-release /etc/mandrake-release /etc/os-release 2>/dev/null > o uname -ov #115-Ubuntu SMP Thu Aug 10 09:04:33 UTC 2017 GNU/Linux > o echo -e "PERL5LIB: $PERL5LIB" PERL5LIB: > o perl -I$HOME/perl5/lib/perl5 -Mlocal::lib Attempting to create directory /home/miguel/perl5 PATH="/home/miguel/perl5/bin${PATH+:}${PATH}"; export PATH; PERL5LIB="/home/miguel/perl5/lib/perl5${PERL5LIB+:}${PERL5LIB}"; export PERL5LIB; PERL_LOCAL_LIB_ROOT="/home/miguel/perl5${PERL_LOCAL_LIB_ROOT+:}${PERL_LOCAL_LIB_ROOT}"; export PERL_LOCAL_LIB_ROOT; PERL_MB_OPT="--install_base \"/home/miguel/perl5\""; export PERL_MB_OPT; PERL_MM_OPT="INSTALL_BASE=/home/miguel/perl5"; export PERL_MM_OPT; > * Stop the LedgerSMB Starman process (probably "sudo service > starman-ledgersmb stop" ) Ok, starman-ledgersmb stopped... > o *run* cd /usr/local/ledgersmb # cd to the LedgerSMB install dir Ok. Installed into "/usr/local/ledgersmb" > o *run* starman --listen 0.0.0.0:5762 --workers 1 > tools/starman.psgi # start starman manually 2017/08/28-11:08:19 Starman::Server (type Net::Server::PreFork) starting! pid(1995) Binding to TCP port 5762 on host 0.0.0.0 with IPv4 Setting gid to "1000 1000 27 1000" Starting Worker on PID 1996 Using Built Dojo > o browse to "http://$ledgersmb_server_address:5762/setup.pl"; I was able to create a company and some users! > o login with no company name using the login button not the create > button ??? > o copy the starman console output into this email user@srv2:/usr/local/ledgersmb$ starman --listen 0.0.0.0:5762 --workers 1 tools/starman.psgi 2017/08/28-11:08:19 Starman::Server (type Net::Server::PreFork) starting! pid(1995) Binding to TCP port 5762 on host 0.0.0.0 with IPv4 Setting gid to "1000 1000 27 1000" Starting Worker on PID 1996 Using Built Dojo WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress NOTICE: function je_get_default_lines() does not exist, skipping NOTICE: function je_set_default_lines(pg_catalog.int4) does not exist, skipping WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress NOTICE: table "trial_balance__account_to_report" does not exist, skipping NOTICE: table "trial_balance__heading_to_report" does not exist, skipping NOTICE: function trial_balance__list() does not exist, skipping NOTICE: table "trial_balance" does not exist, skipping psql:sql/modules/Roles.sql:122: WARNING: no privileges were granted for "public" Use of uninitialized value in string eq at /usr/local/ledgersmb/tools/../lib/LedgerSMB/Scripts/setup.pm line 183. Use of uninitialized value in concatenation (.) or string at /usr/local/ledgersmb/tools/../lib/LedgerSMB/DBObject/User.pm line 47. > o ctrl-c to kill starman > o copy the result of > *run* cat /var/log/postgresql/postgresql-9.4-main.log into this > email > (redact anything sensitive, and only show the part for the time > after you start starman) Starting starman manually seems to work, however using the systemd service file was giving me trouble so, I edited the (supplied) systemd starman-ledgersmb.service" file (installed in /etc/systemd/system) Changed: [Service] WorkingDirectory=WORKING_DIR To: WorkingDirectory=/usr/local/ledgersmb/ Reloaded the daemon "systemctl daemon-reload", then restarted the starman-ledgersmb service. Here's the postgresql-9.5 log as of Aug-29. Most of these repeated. 2017-08-29 04:55:36 UTC [12097-1] postgres@postgres FATAL: password authentication failed for user "postgres" 2017-08-29 04:55:36 UTC [12097-2] postgres@postgres DETAIL: Connection matched pg_hba.conf line 109: "host all all 0.0.0.0/0 md5" could not close temporary statistics file "/var/run/postgresql/9.5-main.pg_stat_tmp/db_0.tmp": No space left on device 2017-08-29 07:37:04 UTC [1152-147] LOG: could not fork autovacuum worker process: Cannot allocate memory > * If the above works, try re-starting starman, and creating a new > company instead of simply logging in I was able to create a company and accounts for employees. Seems to work OK. My previous experience with LSMB was only with 1.3, so the install routine with starman is new. I VERY much appreciate the help from you (David) and Chris. Regards, Michael > > We can often provide realtime assistance if you visit us in our chat room at > > #ledgersmb:matrix.org <https://riot.im/app/#/room/#ledgersmb:matrix.org> > > Regards > David G (dcg_mx in the chat room) > > > On 28/08/17 10:09, Michael Chinn wrote: >> Greetings: >> >> Version: 1.5.9 >> Environment: Ubuntu-16.04 x64 >> Apache2 + PostgreSQL-9.5 >> >> Following install instructions at: >> https://ledgersmb.org/content/installing-ledgersmb-15 >> >> Got all the way to the "setup.pl". Enter the user name "lsmb_dbadmin" + >> password + name-of-new-company-db. >> >> Got this error: >> >> Error! >> APPLICATION ERROR at >> /usr/local/share/perl/5.22.1/PGObject/Util/DBAdmin.pm line 265. >> dbversion: 1.5.9, company: >> Status: 500 Internal server error (PSGI.pm run_new) >> >> I've checked Apache2, Starman, and PostgreSQL and all are up and running >> w/o errors. >> >> Help? Hints? >> >> Regards, >> Michael > > > > _______________________________________________ > users mailing list > ..hidden.. > https://lists.ledgersmb.org/mailman/listinfo/users > -- ====================== Michael Chinn ..hidden.. ~ ~~ ~ ~ o:)^))>~< <;)^)))>~< ~ ~ ~~ ~ <:)^)))>~< <;)^)>~< ~~ ~~~ ~ ~ ~ o:)^)))>-< <;)^))>~< ~ ~~ ~~ ~~ ~ o;)^))>-< <:)^))>~< ~~ ~ ~o:)^))>~< _______________________________________________ users mailing list ..hidden.. https://lists.ledgersmb.org/mailman/listinfo/users