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

Transition from sql-l to lsmb



Hi,

This is a few comments on trying to do a transition from one to the
other, using the instructions on the Wiki.

1. Nothing told me to make sure ledgersmb.conf was set up.

2. The sl2ls.sh script didn't work very well for me. It assumes an
   installation directory, and has DOS line-endings which may or may not
   confuse things. A patch for the installation directory is below

3. I'm guessing I can't upgrade from a ledger on postgres 7.4 to a
   ledger on postgres 8.? without migrating the database over first?

cheers, Rich.


*** sl2ls.sh~	Fri Feb  9 13:43:21 2007
--- sl2ls.sh	Fri Feb  9 13:47:45 2007
***************
*** 15,20 ****
--- 14,21 ----
  LSDB=l-smb

  LSOWN=ledgersmb

  

+ # Installation directory

+ IDIR=`pwd`

  

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

  

***************
*** 25,31 ****
  

  createdb -O ${LSOWN} ${LSDB}

  

! psql ${LSDB} ${LSOWN} -c "\i /var/www/ledger-smb/sql/Pg-central.sql"

  

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

  

--- 26,32 ----
  

  createdb -O ${LSOWN} ${LSDB}

  

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

  

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

  

***************
*** 33,39 ****
  

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

  

! cd /var/www/ledger-smb/sql/legacy/

  

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

  

--- 34,40 ----
  

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

  

! cd ${IDIR}/sql/legacy/

  

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

  

***************
*** 57,63 ****
  

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

  

! cd /var/www/ledger-smb

  

  ./import_members.pl users/members

  

--- 58,64 ----
  

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

  

! cd ${IDIR}

  

  ./import_members.pl users/members

  



-- 
rich walker         |  Shadow Robot Company | ..hidden..
technical director     251 Liverpool Road   |
need a Hand?           London  N1 1LX       | +UK 20 7700 2487
www.shadowrobot.com/hand/overview.shtml