Trying upgrade from 1.5.12 to 1.5.28
Given my difficulties with upgrading to 1.6.14, as a test, I decided to give 1.5.28 a try. I.5.28 loaded and the website came up with out an issue. However I have a problem of my own making. I cannot upgrade my DB because I have lost the password for lsmb_dbadmin. Can anyone tell me how to recover or replace the password without affecting the DB? Any help appreciated. -- Regards, Bill Ott Home: 919-363-0031 Cell: 919-434-7589 Email: Mailto:billott@theotts.org Website: http://www.theotts.org Profile: http://www.linkedin.com/in/wbott
As I submitted this I recalled the password. 1.5.28 is up and running without the grayed out screens. Regards, Bill Ott Home: 919-363-0031 Cell: 919-434-7589 Email: Mailto:billott@theotts.org Website: http://www.theotts.org Profile: http://www.linkedin.com/in/wbott On 12/2/19 12:09 PM, bill Ott wrote:
Given my difficulties with upgrading to 1.6.14, as a test, I decided to give 1.5.28 a try. I.5.28 loaded and the website came up with out an issue.
However I have a problem of my own making. I cannot upgrade my DB because I have lost the password for lsmb_dbadmin. Can anyone tell me how to recover or replace the password without affecting the DB?
Any help appreciated.
Hi Bill, On Mon, Dec 2, 2019 at 6:13 PM bill Ott <billott@theotts.org> wrote:
As I submitted this I recalled the password. 1.5.28 is up and running without the grayed out screens.
Perfect! I hope you'll enjoy some of the other ~100 fixes included in the upgrade at some point :-) In your mail below you mention issues with an upgrade to 1.6.x. Was that on the software or on the database level? Care to post about that in a separate email? Thanks in advance! Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
Hi Bill, On Mon, Dec 2, 2019 at 9:46 PM Erik Huelsmann <ehuels@gmail.com> wrote:
Hi Bill,
On Mon, Dec 2, 2019 at 6:13 PM bill Ott <billott@theotts.org> wrote:
As I submitted this I recalled the password. 1.5.28 is up and running without the grayed out screens.
Perfect! I hope you'll enjoy some of the other ~100 fixes included in the upgrade at some point :-)
In your mail below you mention issues with an upgrade to 1.6.x. Was that on the software or on the database level? Care to post about that in a separate email? Thanks in advance!
From the information you provided me out-of-band, I'm concluding that the issues you're having with 1.6 are likely caused by an incorrect path in your systemd service file: Error while loading /bin/ledgersmb-server.psgi: No such file or directory at (eval 22) line 4 note the leading forward slash on "/bin/ledgersmb-server.psgi" which likely means the file is being looked up in the wrong location. Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
Hi, Erik, You may be right about that, but I am using the systemd file provided in 1.6. The line is broken, which maybe the problem. We're headed to the west coast, so I may not get to play with this until Friday. Here is the line ExecStart=/usr/bin/starman \ --listen localhost:5762 \ -I lib \ -I old/lib \ bin/ledgersmb-server.psgi Regards, Bill Ott Home: 919-363-0031 Cell: 919-434-7589 Email: Mailto:billott@theotts.org Website: http://www.theotts.org Profile: http://www.linkedin.com/in/wbott On 12/4/19 2:14 PM, Erik Huelsmann wrote:
Hi Bill,
On Mon, Dec 2, 2019 at 9:46 PM Erik Huelsmann <ehuels@gmail.com <mailto:ehuels@gmail.com>> wrote:
Hi Bill,
On Mon, Dec 2, 2019 at 6:13 PM bill Ott <billott@theotts.org <mailto:billott@theotts.org>> wrote:
As I submitted this I recalled the password. 1.5.28 is up and running without the grayed out screens.
Perfect! I hope you'll enjoy some of the other ~100 fixes included in the upgrade at some point :-)
In your mail below you mention issues with an upgrade to 1.6.x. Was that on the software or on the database level? Care to post about that in a separate email? Thanks in advance!
From the information you provided me out-of-band, I'm concluding that the issues you're having with 1.6 are likely caused by an incorrect path in your systemd service file:
Error while loading /bin/ledgersmb-server.psgi: No such file or directory at (eval 22) line 4
note the leading forward slash on "/bin/ledgersmb-server.psgi" which likely means the file is being looked up in the wrong location.
Regards,
-- Bye,
Erik.
http://efficito.com <http://efficito.com/> -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
Hi Bill, On Wed, Dec 4, 2019 at 9:09 PM bill Ott <billott@theotts.org> wrote:
Hi, Erik, You may be right about that, but I am using the systemd file provided in 1.6. The line is broken, which maybe the problem. We're headed to the west coast, so I may not get to play with this until Friday.
Thanks for the quick reply. The standard file has a "WorkDirectory" statement ( https://github.com/ledgersmb/LedgerSMB/blob/1.6/conf/systemd/ledgersmb_starm...) which needs to be edited to point to the directory in which LedgerSMB has been installed. Did you change it to the correct path?
Here is the line
ExecStart=/usr/bin/starman \ --listen localhost:5762 \ -I lib \ -I old/lib \ bin/ledgersmb-server.psgi
-- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
I did not replace WORKING_DIR. I did export it ("export WORKING_DIR=/opt/ledgersmb" w/o the quotes). I'll try changing it in ledgerSMB_starman.service Regards, Bill Ott Home: 919-363-0031 Cell: 919-434-7589 Email: Mailto:billott@theotts.org Website: http://www.theotts.org Profile: http://www.linkedin.com/in/wbott On 12/4/19 3:26 PM, Erik Huelsmann wrote:
Hi Bill,
On Wed, Dec 4, 2019 at 9:09 PM bill Ott <billott@theotts.org <mailto:billott@theotts.org>> wrote:
Hi, Erik, You may be right about that, but I am using the systemd file provided in 1.6. The line is broken, which maybe the problem. We're headed to the west coast, so I may not get to play with this until Friday.
Thanks for the quick reply.
The standard file has a "WorkDirectory" statement (https://github.com/ledgersmb/LedgerSMB/blob/1.6/conf/systemd/ledgersmb_starm...) which needs to be edited to point to the directory in which LedgerSMB has been installed. Did you change it to the correct path?
Here is the line
ExecStart=/usr/bin/starman \ --listen localhost:5762 \ -I lib \ -I old/lib \ bin/ledgersmb-server.psgi
-- Bye,
Erik.
http://efficito.com <http://efficito.com/> -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
participants (2)
-
bill Ott -
Erik Huelsmann