Re: Transition from sql-l to lsmb

["Chris Travers" <..hidden..>]

Thanks.  Will review and probably apply.

On 2/9/07, Rich Walker <..hidden..> wrote:
> 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
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users