Updating UPGRADE docs and making sl2ls.sh script safe for many installation directories.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@807 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 6 insertions, 3 deletions

diff --git a/sl2ls.sh b/sl2ls.sh
index fcbf031f..531b8512 100644
--- a/sl2ls.sh
+++ b/sl2ls.sh
@@ -12,6 +12,9 @@ SLOWN=SQL-Ledger_Owner
 LSDB=lsmbprod

 LSOWN=ledgersmb

 

+# Installation directory

+

+IDIR=`pwd`

 

 psql template1 -c "DROP DATABASE ${LSDB};"

 

@@ -22,7 +25,7 @@ sed -i -e "s/SQL_ASCII/LATIN1/" sl2ls.sql
 

 createdb -O ${LSOWN} ${LSDB}

 

-psql ${LSDB} ${LSOWN} -c "\i /usr/local/ledger-smb/sql/Pg-central.sql"

+psql ${LSDB} ${LSOWN} -c "\i ${IDIR}/sql/Pg-central.sql"

 

 psql template1 -c "ALTER USER ${LSOWN} WITH superuser;"

 

@@ -30,7 +33,7 @@ psql ${LSDB} ${LSOWN} -c "\i sl2ls.sql"
 

 psql template1 -c "ALTER USER ${LSOWN} WITH nosuperuser;"

 

-cd /usr/local/ledger-smb/sql/legacy/

+cd ${IDIR}/sql/legacy/

 

 psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"

 

@@ -54,7 +57,7 @@ psql ${LSDB} ${LSOWN} -c "SELECT version FROM defaults;"
 

 psql ${LSDB} ${LSOWN} -c "update users_conf set password = md5('apasswrd');"

 

-cd /usr/local/ledger-smb

+cd ${IDIR}

 

 ./import_members.pl users/members