Hi Bill,
There are a few things in your script I'm not happy are correct. Unfortunately
I can't get to a machine and confirm the best changes for another 4 hours or so.
Once I'm back in the office I'll do that and responded with more info.
You may find it useful to join us in Te support
channelhttps://riot.im/app/#/room/#ledgersmb There is normally someone there
24/7 or close to.I'm in Western Australia (gmt+8) and normally around until
after midnight local time as user dcg_mx Erik (ehuelsmann) is about 7 hours
behind (gmt+1)
Regards David Godfrey
Sent from my Samsung Galaxy Note 4 on the Telstra Mobile network
-------- Original message --------
From: bill Ott <bill...@theotts.org>
Date: 28/02/2017 12:49 (GMT+08:00)
To: ledger-smb-users@lists.sourceforge.net
Subject: Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3
Eric, I am migrating to new hardware. I use a virtual machine
running the new OS as a test bed for each of the programs I am
migrating. So, starting over again is a 10 minute job. Stop the
virtual machine, delete the virtual machine file, copy the saved
virtual machine file over and restart the virtual machine. I then
run this script (script7.sh) as root on the virtual machine.
Scripts1-6 are for other apps that I have already tested on a
virtual machine. When I get all of the scripts running, I'll
install a clean OS on the new hardware and run all of the scripts.
Points of clarification
"/home/wbostore/backup/wbointi7/stage/" is on the storage
server and contains the necessary data from the old server, as
well as, new required data for the new server.
The soft references are for convenience (ln -s
/var/lib/pgsql/9.5/data/ /var/lib/pgsql/data)
To work around getting the DB users from the 1.3.30 DB to work
in 1.5.3 i changed the "peer" to "trust" (local
all all trust)
Any other changes are accidental and may be my problem. Thanks for
looking into this.
_______________________________________________
#!/bin/bash
NAME="wvointi7"
OS="CentOS_7"
LOADALL=1
#
# set up SMB Ledger- Postgres 9.5 service and Pass key
#
if [ 1 -eq $LOADALL ] ; then
cat > /etc/yum.repos.d/pgdg-95-centos.repo <<EOF
[pgdg95]
name=PostgreSQL 9.5 \$releasever - \$basearch
baseurl=https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-\$releasever-\$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-95
[pgdg95-source]
name=PostgreSQL 9.5 \$releasever - \$basearch - Source
failovermethod=priority
baseurl=https://download.postgresql.org/pub/repos/yum/srpms/9.5/redhat/rhel-\$releasever-\$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-95
EOF
cat > /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-95 <<EOF
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.4.7 (GNU/Linux)
mQGiBEeD8koRBACC1VBRsUwGr9gxFFRho9kZpdRUjBJoPhkeOTvp9LzkdAQMFngr
BFi6N0ov1kCX7LLwBmDG+JPR7N+XcH9YR1coSHpLVg+JNy2kFDd4zAyWxJafjZ3a
9zFg9Yx+0va1BJ2t4zVcmKS4aOfbgQ5KwIOWUujalQW5Y+Fw39Gn86qjbwCg5dIo
tkM0l19h2sx50D027pV5aPsD/2c9pfcFTbMhB0CcKS836GH1qY+NCAdUwPs646ee
Ex/k9Uy4qMwhl3HuCGGGa+N6Plyon7V0TzZuRGp/1742dE8IO+I/KLy2L1d1Fxrn
XOTBZd8qe6nBwh12OMcKrsPBVBxn+iSkaG3ULsgOtx+HHLfa1/p22L5+GzGdxizr
peBuA/90cCp+lYcEwdYaRoFVR501yDOTmmzBc1DrsyWP79QMEGzMqa393G0VnqXt
L4pGmunq66Agw2EhPcIt3pDYiCmEt/obdVtSJH6BtmSDB/zYhbE8u3vLP3jfFDa9
KXxgtYj0NvuUVoRmxSKm8jtfmj1L7zoKNz3jl+Ba3L0WxIv4+bRBUG9zdGdyZVNR
TCBSUE0gQnVpbGRpbmcgUHJvamVjdCA8cGdzcWxycG1zLWhhY2tlcnNAcGdmb3Vu
ZHJ5Lm9yZz6IYAQTEQIAIAUCR4PySgIbIwYLCQgHAwIEFQIIAwQWAgMBAh4BAheA
AAoJEB8W0uFELfD4jnkAoMqd6ZwwsgYHZ3hP9vt+DJt1uDW7AKDbRwP8ESKFhwdJ
8m91RPBeJW/tMLkCDQRHg/JKEAgA64+ZXgcERPYfZYo4p+yMTJAAa9aqnE3U4Ni6
ZMB57GPuEy8NfbNya+HiftO8hoozmJdcI6XFyRBCDUVCdZ8SE+PJdOx2FFqZVIu6
dKnr8ykhgLpNNEFDG3boK9UfLj/5lYQ3Y550Iym1QKOgyrJYeAp6sZ+Nx2PavsP3
nMFCSD67BqAbcLCVQN7a2dAUXfEbfXJjPHXTbo1/kxtzE+KCRTLdXEbSEe3nHO04
K/EgTBjeBUOxnciH5RylJ2oGy/v4xr9ed7R1jJtshsDKMdWApwoLlCBJ63jg/4T/
z/OtXmu4AvmWaJxaTl7fPf2GqSqqb6jLCrQAH7AIhXr9V0zPZwADBQgAlpptNQHl
u7euIdIujFwwcxyQGfee6BG+3zaNSEHMVQMuc6bxuvYmgM9r7aki/b0YMfjJBk8v
OJ3Eh1vDH/woJi2iJ13vQ21ot+1JP3fMd6NPR8/qEeDnmVXu7QAtlkmSKI9Rdnjz
FFSUJrQPHnKsH4V4uvAM+njwYD+VFiwlBPTKNeL8cdBb4tPN2cdVJzoAp57wkZAN
VA2tKxNsTJKBi8wukaLWX8+yPHiWCNWItvyB4WCEp/rZKG4A868NM5sZQMAabpLd
l4fTiGu68OYgK9qUPZvhEAL2C1jPDVHPkLm+ZsD+90Pe66w9vB00cxXuHLzm8Pad
GaCXCY8h3xi6VIhJBBgRAgAJBQJHg/JKAhsMAAoJEB8W0uFELfD4K4cAoJ4yug8y
1U0cZEiF5W25HDzMTtaDAKCaM1m3Cbd+AZ0NGWNg/VvIX9MsPA==
=au6K
-----END PGP PUBLIC KEY BLOCK-----
EOF
#
# get the necessary perl modules
#
yum -y remove perl-DBD-Pg
yum -y install perl-CGI-Emulate-PSGI perl-CGI-Simple
perl-Config-IniFiles
yum -y install perl-DBI perl-DateTime
perl-DateTime-Format-Strptime
yum -y install perl-Digest-MD5 perl-File-MimeInfo perl-JSON-XS
perl-starman
yum -y install perl-Locale-Maketext perl-App-cpanminus perl-YAML
yum -y install perl-Log-Log4perl perl-MIME-Lite
perl-Math-BigInt-GMP
yum -y install perl-Moose perl-Number-Format perl-Plack
perl-Template-Toolkit
yum -y install perl-namespace-autoclean perl-MooseX-NonMoose
perl-XML-Simple
cpan install CPAN
cpan install App::Info
cpan install Locale::Maketext::Lexicon
cpan install MIME::Base64
cpan install CGI::Simple
cpan install DBD::Pg
#
# set up postgres
#
yum -y remove postgresql
rm /var/lib/pgsql/data -Rf
yum -y install postgresql95-server postgresql95-devel
postgresql95-libs
ln -s /var/lib/pgsql/9.5/data/ /var/lib/pgsql/data
/usr/pgsql-9.5/bin/postgresql95-setup initdb
export POSTGRES_HOME=/usr/pgsql-9.5
cat > /var/lib/pgsql/data/pg_hba.conf <<EOF
local all postgres peer
local all all trust
host all postgres 127.0.0.1/32 reject
host all postgres ::1/128 reject
host postgres,template0,template1 lsmb_dbadmin
127.0.0.1/32 md5
host postgres,template0,template1 lsmb_dbadmin
::1/128 md5
host postgres,template0,template1 all
127.0.0.1/32 reject
host postgres,template0,template1 all ::1/128
reject
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
EOF
systemctl restart postgresql-9.5.service
cd /var/lib/pgsql/data
su postgres <<EOF
psql -f /home/wbostore/backup/wbointi7/stage/psqldump postgres
EOF
systemctl restart postgresql-9.5.service
#
# Install ledgersmb
#
cd /opt
cp /home/wbostore/backup/wbointi7/stage/ledgersmb-1.5.3.tar.gz
/opt/
tar -xzf ledgersmb-1.5.3.tar.gz
rm -f *.gz
cd /opt/ledgersmb
cpanm --quiet --notest --with-feature=starman --installdeps .
ln -s /usr/local/bin/starman /usr/bin/starman
cp /opt/ledgersmb/conf/systemd/* /usr/lib/systemd/system/
cp /opt/ledgersmb/conf/ledgersmb.conf.default
/opt/ledgersmb/ledgersmb.conf
chown root:root /opt/ledgersmb -Rf
sed -i 's/=WORKING_DIR/=\/opt\/ledgersmb/'
/usr/lib/systemd/system/starman-ledgersmb.service
sed -i 's/=WORKING_DIR/=\/opt\/ledgersmb/'
/usr/lib/systemd/system/plack-fcgi-ledgersmb.service
useradd -d /non-existent -r -U -c "LedgerSMB/Starman service
system user" ledgersmb
systemctl enable plack-fcgi-ledgersmb.service
systemctl enable starman-ledgersmb.service
systemctl start starman-ledgersmb.service
fi
Regards,
Bill Ott
Home: 919-363-0031
Cell: 919-434-7589
Email: Mailto:bill...@theotts.org
Website: http://www.theotts.org
Profile: http://www.linkedin.com/in/wbott
On 02/27/2017 04:27 PM, Erik Huelsmann
wrote:
Hi Bill,
On Mon, Feb 27, 2017 at 8:27 PM,
bill Ott <bill...@theotts.org>
wrote:
Hi, Erik. Apparently I am not migrating this
properly. The version from the SQl select command
was 1.3.30.
I moved the database by doing "pg_dumpall -c >
dumpdata" from the 1.3.30 system but using the
pg_dumpall program from the 1.5.3 system. I then
issued "psql -f dumpdata postgres" on the 1.5.3
system. Then logging into the 1.5.3 system with
psql and executing a "\l" shows all of the
databases. BUT, the version field from default is
1.3.30
Ok. That explains at least some of it. Which
instructions have you been using for your migration? Can
you provide some details as to how you handled each of
the steps in the instructions? Having that information
will help me understand where you're currently at with
your migration.
Very odd the every select I tried on the database
works correctly even though the version is the old
version.
Right. You made an exact copy of your database. Which
means that all queries should work as they did under
1.3.
How should I proceed? Can I just use SQl to
modify the version field, or would that just be
making things worse?
Just changing the number through an SQL statement
will not help to resolve the situation: the new software
won't know it's talking to an old database version,
leaving them in Babylon.
--
Bye,
Erik.
http://efficito.com --
Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
