[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 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:..hidden..
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 <..hidden..> 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
..hidden..
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users