Re: Trouble converting database

[Chris Travers <..hidden..>]

On Mon, Jun 4, 2012 at 11:39 PM, Jos Geluk <..hidden..> wrote:
> Robert James Clay schreef op 05-06-12 00:34:
>> On Sun, 2012-06-03 at 19:15 -0400, Jos Geluk wrote:
>>> Robert James Clay schreef op 03-06-12 23:40:
>>>>> After the error above, I installed the .deb file over it,
>>>>
>>>>       The 1.3.15-2 package from the Debian repository?  And over what kind
>>>> of previous installation?
>>>
>>> Yes, from
>>> http://ftp.nl.debian.org/debian/pool/main/l/ledgersmb/ledgersmb_1.3.15-2_all.deb
>>> over the 1.3.15 tarball.
>>
>>     "over the 1.3.15 tarball"?
>
> Does that sound strange? I had this one installed:
> http://sourceforge.net/projects/ledger-smb/files/ledgersmb/1.3.15/ledgersmb-1.3.15.tar.gz
>
> by untarring and installing as per the INSTALL file. Later, since that
> didn't work, to make sure I hadn't missed any requirements I downloaded
> the .deb file and did a dpkg -i of it.
>
>>> The "normal" login (login.pl) is the one that gives me the
>>> authentication errors.
>>
>>      Is that after the creation of an initial company database user,
>> which shows up at the end of the conversion process?  Or are you getting
>> that far?
>
> I don't get that far. The conversion process tells me that the database
> is ready for use and gives me a link to the login page. By then, all
> data has disappeared, and the "users" table is empty.

Just in case you ever need this, there is a 1.3-1.2.sql file in the
sql/upgrade directory.  The upgrade is actually a move-and-import
operation so this will restore you to 1.2.  Note that this does *not*
remove the old 1.3 schema.  Since we know what the problem was and no
further troubleshooting is required, you probably want to

drop schema lsmb13_fail cascade;

After you run the downgrade script.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users