sql-ledger-users — SQL-Ledger users

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Armaghan S. <sa...@le...>]

On Thu, May 8, 2008 at 9:52 AM, Andrew @ ATM Logic <atm...@km...> wrote:
>  One other little thing you may be able to help me with is printing.
>  I have just gotten into the habit of printing the PDF and then after
>  Opening the PDF I send that to the printer as I have not had the
>  Postscript printer option work for a number of years...  We only
>  Invoice maybe 3-6 times a day so its not a big deal...
>  I am guessing I have some work to do with Cups.. Or something,
>  However am I missing something simple?  Do I need to plug the
>  Printer directly into the SL system?  (I normally print to Network
>  Lasers, in this case it would be a Dell Color Laser, however I have
>  Some old school laser I could plug in as well)

1. Configure a CUPS printer on your SL server.
2. Add the name to sql-ledger.conf
3. Select it before printing invoice.

I have an HP network printer configured as CUPS printer on Fedora 7
server and named it (conveniently) 'printer'. My relevant
sql-ledger.conf is:

%printer = ( Laser      => 'lpr -Plaser',
             Epson      => 'lpr -PEpson',
             printer    => 'lpr -Pprinter'
);

You can remove the unwanted printers (Laser, Epson) from this variable.

-- 
* Purpose-built SQL-Ledger Hosting
* SQL-Ledger VMware Appliance
http://www.ledger123.com/

Free trial available.
--

Re: [SL] Restoring SL from Backup?

[Luke <sl...@li...>]

In the manner of mystical falling trees:

If you know there was an error, but are not told what it was: has there 
really been an error?

Or, if you prefer, haiku style:

An error shown,
No text given us here,
Our help can not come.

Okay, sorry, I couldn't resist.

So what is this error?

Luke


On Wed, 7 May 2008, Andrew @ ATM Logic wrote:

> Ok, so I checked in the sql-ledger.conf file and the Latex was set to 0,
> changing it to 1 shows the options, however if I print to PDF Screen I get
> an error.  What should I be looking at next?
> I am going to go back through my install steps to see if/how I could have
> missed the Latex install, because as mentioned, this is the first time its
> failed in 4-5 years. 
> 
> > -----Original Message-----
> > From: sql...@li... 
> > [mailto:sql...@li...] On 
> > Behalf Of Luke
> > Sent: Wednesday, May 07, 2008 3:47 PM
> > To: sql...@li...
> > Subject: Re: [SL] Restoring SL from Backup?
> > 
> > All of that stuff would have been under /usr/local/sql-ledger 
> > (or similar), mostly in the templates directory.
> > 
> > Check sql-ledger.conf for the PDF option.
> > 
> > 
> > On Wed, 7 May 2008, Andrew @ ATM Logic wrote:
> > 
> > > THIS is what I was looking for, I was able to get the data 
> > back easy enough.
> > > However Logo's/Users/custom forms etc all lost.
> > > Also in the past every time I installed SL I was able ot 
> > get PDF working...
> > > I must have butchered a step as I do not see PDF emails or 
> > Prints  :( 
> > > Thanks for the help.  PS  I did purchace the manual last year, just 
> > > did not renew this year.... Yet....
> > > 
> > > > -----Original Message-----
> > > > From: sql...@li...
> > > > [mailto:sql...@li...] 
> > On Behalf Of 
> > > > Armaghan Saqib
> > > > Sent: Wednesday, May 07, 2008 3:41 AM
> > > > To: sql...@li...
> > > > Subject: Re: [SL] Restoring SL from Backup?
> > > > 
> > > > On Wed, May 7, 2008 at 1:23 PM, Michael Hasse <mh...@it...> 
> > > > wrote:
> > > > > The step-by-step I'm thinking of had a couple things to
> > > > watch out for
> > > > > when restoring to a server that had SL already installed.  
> > > > Something
> > > > > about removing the existing DB, (or maybe just the tables?) and 
> > > > > tweaking the database user(s).  Don't remember now.  :/ 
> >  It wasn't 
> > > > > anything earthshaking but probably easier than figuring out the 
> > > > > little gotchas on the fly.
> > > > >
> > > > 
> > > > This not-so-earthshaking information seems to be from my wiki for 
> > > > SQL-Ledger:
> > > > http://wiki.ledger123.com/index.php?n=Local.DataRestore
> > > > Regards
> > > > 
> > > > --
> > > > * Purpose-built SQL-Ledger Hosting
> > > > * SQL-Ledger VMware Appliance
> > > > http://www.ledger123.com/
> > > > 
> > > > Free trial available.
> > > > --
> > > > 
> > > > --------------------------------------------------------------
> > > > -----------
> > > > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> > > > Don't miss this year's exciting event. There's still time to save 
> > > > $100.
> > > > Use priority code J8TL2D2. 
> > > > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> > > > .sun.com/javaone
> > > > _______________________________________________
> > > > sql-ledger-users mailing list
> > > > sql...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > 
> > > 
> > > 
> > ----------------------------------------------------------------------
> > > --- This SF.net email is sponsored by the 2008 JavaOne(SM) 
> > Conference 
> > > Don't miss this year's exciting event. There's still time 
> > to save $100.
> > > Use priority code J8TL2D2. 
> > > 
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com
> > > /javaone _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > 
> > 
> > --
> > Luke
> > 
> > "When the Republicans are in office, Man oppresses Man; When 
> > the Democrats are in office, it's just the opposite."
> > 
> > --------------------------------------------------------------
> > -----------
> > This SF.net email is sponsored by the 2008 JavaOne(SM) 
> > Conference Don't miss this year's exciting event. There's 
> > still time to save $100. 
> > Use priority code J8TL2D2. 
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> > .sun.com/javaone
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

-- 
Luke

"When the Republicans are in office, Man oppresses Man; When the
Democrats are in office, it's just the opposite."

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Andrew @ A. L. <atm...@km...>]

 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Armaghan Saqib
> Sent: Wednesday, May 07, 2008 8:11 PM
> To: sql...@li...
> Subject: Re: [SL] SL working fine, imported users,and 
> restored from backup. All is well other than no PDF ?
> 
> On Wed, May 7, 2008 at 11:11 PM, Andrew @ ATM Logic 
> <atm...@km...> wrote:
> > >From what I recal, this is all done through Latex...  any quick 
> > >thoughts on
> >  what I should check that I many have missed?  I have had 
> it working 
> > in all  my other installed so I am guessing I may have 
> missed it along the way...
> >  but... to be sure, it has NOTHING to do with cpan right?  As I did 
> > have a  lot of trouble with that...
> >
> >  Also as I am not desperate for it,and plan on changing 
> servers next 
> > week can  I break anything by trying to fix it (for the 
> most part, as 
> > I know just  about anything is possable... I am just 
> looking if I do a 
> > basic rpm/install  etc... should I be worried about 
> breaking anything 
> > else in SL, not the rest  of my system.
> 
> You also need to install latex.
> 
> On redhat and similar, yum install tetex should do the trick.


Yup, that was the ticket many thanks I did a bit of googling and found it.
I am CentOS based.

One other little thing you may be able to help me with is printing.
I have just gotten into the habit of printing the PDF and then after 
Opening the PDF I send that to the printer as I have not had the 
Postscript printer option work for a number of years...  We only 
Invoice maybe 3-6 times a day so its not a big deal...
I am guessing I have some work to do with Cups.. Or something, 
However am I missing something simple?  Do I need to plug the 
Printer directly into the SL system?  (I normally print to Network
Lasers, in this case it would be a Dell Color Laser, however I have
Some old school laser I could plug in as well)


Also, could you PM off-list in regards to your other services.

Thanks,
---Andrew
ATM Logic



> I think I should update install instructions on my wiki to 
> include this information too. Though it looks too obvious to 
> me but people do miss it.
> 
> --
> * Purpose-built SQL-Ledger Hosting
> * SQL-Ledger VMware Appliance
> http://www.ledger123.com/
> 
> Free trial available.
> --
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by the 2008 JavaOne(SM) 
> Conference Don't miss this year's exciting event. There's 
> still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> .sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Armaghan S. <sa...@le...>]

On Wed, May 7, 2008 at 11:11 PM, Andrew @ ATM Logic <atm...@km...> wrote:
> >From what I recal, this is all done through Latex...  any quick thoughts on
>  what I should check that I many have missed?  I have had it working in all
>  my other installed so I am guessing I may have missed it along the way...
>  but... to be sure, it has NOTHING to do with cpan right?  As I did have a
>  lot of trouble with that...
>
>  Also as I am not desperate for it,and plan on changing servers next week can
>  I break anything by trying to fix it (for the most part, as I know just
>  about anything is possable... I am just looking if I do a basic rpm/install
>  etc... should I be worried about breaking anything else in SL, not the rest
>  of my system.

You also need to install latex.

On redhat and similar, yum install tetex should do the trick.

I think I should update install instructions on my wiki to include
this information too. Though it looks too obvious to me but people do
miss it.

-- 
* Purpose-built SQL-Ledger Hosting
* SQL-Ledger VMware Appliance
http://www.ledger123.com/

Free trial available.
--

Re: [SL] Restoring SL from Backup?

[Andrew @ A. L. <atm...@km...>]

Ok, so I checked in the sql-ledger.conf file and the Latex was set to 0,
changing it to 1 shows the options, however if I print to PDF Screen I get
an error.  What should I be looking at next?
I am going to go back through my install steps to see if/how I could have
missed the Latex install, because as mentioned, this is the first time its
failed in 4-5 years. 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Luke
> Sent: Wednesday, May 07, 2008 3:47 PM
> To: sql...@li...
> Subject: Re: [SL] Restoring SL from Backup?
> 
> All of that stuff would have been under /usr/local/sql-ledger 
> (or similar), mostly in the templates directory.
> 
> Check sql-ledger.conf for the PDF option.
> 
> 
> On Wed, 7 May 2008, Andrew @ ATM Logic wrote:
> 
> > THIS is what I was looking for, I was able to get the data 
> back easy enough.
> > However Logo's/Users/custom forms etc all lost.
> > Also in the past every time I installed SL I was able ot 
> get PDF working...
> > I must have butchered a step as I do not see PDF emails or 
> Prints  :( 
> > Thanks for the help.  PS  I did purchace the manual last year, just 
> > did not renew this year.... Yet....
> > 
> > > -----Original Message-----
> > > From: sql...@li...
> > > [mailto:sql...@li...] 
> On Behalf Of 
> > > Armaghan Saqib
> > > Sent: Wednesday, May 07, 2008 3:41 AM
> > > To: sql...@li...
> > > Subject: Re: [SL] Restoring SL from Backup?
> > > 
> > > On Wed, May 7, 2008 at 1:23 PM, Michael Hasse <mh...@it...> 
> > > wrote:
> > > > The step-by-step I'm thinking of had a couple things to
> > > watch out for
> > > > when restoring to a server that had SL already installed.  
> > > Something
> > > > about removing the existing DB, (or maybe just the tables?) and 
> > > > tweaking the database user(s).  Don't remember now.  :/ 
>  It wasn't 
> > > > anything earthshaking but probably easier than figuring out the 
> > > > little gotchas on the fly.
> > > >
> > > 
> > > This not-so-earthshaking information seems to be from my wiki for 
> > > SQL-Ledger:
> > > http://wiki.ledger123.com/index.php?n=Local.DataRestore
> > > Regards
> > > 
> > > --
> > > * Purpose-built SQL-Ledger Hosting
> > > * SQL-Ledger VMware Appliance
> > > http://www.ledger123.com/
> > > 
> > > Free trial available.
> > > --
> > > 
> > > --------------------------------------------------------------
> > > -----------
> > > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> > > Don't miss this year's exciting event. There's still time to save 
> > > $100.
> > > Use priority code J8TL2D2. 
> > > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> > > .sun.com/javaone
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > 
> > 
> > 
> ----------------------------------------------------------------------
> > --- This SF.net email is sponsored by the 2008 JavaOne(SM) 
> Conference 
> > Don't miss this year's exciting event. There's still time 
> to save $100.
> > Use priority code J8TL2D2. 
> > 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com
> > /javaone _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > 
> 
> --
> Luke
> 
> "When the Republicans are in office, Man oppresses Man; When 
> the Democrats are in office, it's just the opposite."
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by the 2008 JavaOne(SM) 
> Conference Don't miss this year's exciting event. There's 
> still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> .sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Restoring SL from Backup?

[Michael H. <mh...@it...>]

Luke's right, the SL backup is just a dump of the SQL database, (i.e.  
the raw data), it does NOT include any custom tweaks to templates  
etc.  You'll need to look at your filesystem backup for any of that.


Thanks,

Michael


On May 7, 2008, at 1:47 PM, Luke wrote:

> All of that stuff would have been under /usr/local/sql-ledger (or
> similar), mostly in the templates directory.
>
> Check sql-ledger.conf for the PDF option.
>
>
> On Wed, 7 May 2008, Andrew @ ATM Logic wrote:
>
>> THIS is what I was looking for, I was able to get the data back  
>> easy enough.
>> However Logo's/Users/custom forms etc all lost.
>> Also in the past every time I installed SL I was able ot get PDF  
>> working...
>> I must have butchered a step as I do not see PDF emails or Prints  :(
>> Thanks for the help.  PS  I did purchace the manual last year,  
>> just did not
>> renew this year.... Yet....
>>
>>> -----Original Message-----
>>> From: sql...@li...
>>> [mailto:sql...@li...] On
>>> Behalf Of Armaghan Saqib
>>> Sent: Wednesday, May 07, 2008 3:41 AM
>>> To: sql...@li...
>>> Subject: Re: [SL] Restoring SL from Backup?
>>>
>>> On Wed, May 7, 2008 at 1:23 PM, Michael Hasse
>>> <mh...@it...> wrote:
>>>> The step-by-step I'm thinking of had a couple things to
>>> watch out for
>>>> when restoring to a server that had SL already installed.
>>> Something
>>>> about removing the existing DB, (or maybe just the tables?) and
>>>> tweaking the database user(s).  Don't remember now.  :/  It wasn't
>>>> anything earthshaking but probably easier than figuring out the
>>>> little gotchas on the fly.
>>>>
>>>
>>> This not-so-earthshaking information seems to be from my wiki
>>> for SQL-Ledger:
>>> http://wiki.ledger123.com/index.php?n=Local.DataRestore
>>> Regards
>>>
>>> --
>>> * Purpose-built SQL-Ledger Hosting
>>> * SQL-Ledger VMware Appliance
>>> http://www.ledger123.com/
>>>
>>> Free trial available.
>>> --
>>>
>>> --------------------------------------------------------------
>>> -----------
>>> This SF.net email is sponsored by the 2008 JavaOne(SM)
>>> Conference Don't miss this year's exciting event. There's
>>> still time to save $100.
>>> Use priority code J8TL2D2.
>>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
>>> .sun.com/javaone
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save  
>> $100.
>> Use priority code J8TL2D2.
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
>> java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
> -- 
> Luke
>
> "When the Republicans are in office, Man oppresses Man; When the
> Democrats are in office, it's just the opposite."
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Restoring SL from Backup?

[Luke <acc...@li...>]

All of that stuff would have been under /usr/local/sql-ledger (or 
similar), mostly in the templates directory.

Check sql-ledger.conf for the PDF option.


On Wed, 7 May 2008, Andrew @ ATM Logic wrote:

> THIS is what I was looking for, I was able to get the data back easy enough.
> However Logo's/Users/custom forms etc all lost.
> Also in the past every time I installed SL I was able ot get PDF working...
> I must have butchered a step as I do not see PDF emails or Prints  :(
> Thanks for the help.  PS  I did purchace the manual last year, just did not
> renew this year.... Yet.... 
> 
> > -----Original Message-----
> > From: sql...@li... 
> > [mailto:sql...@li...] On 
> > Behalf Of Armaghan Saqib
> > Sent: Wednesday, May 07, 2008 3:41 AM
> > To: sql...@li...
> > Subject: Re: [SL] Restoring SL from Backup?
> > 
> > On Wed, May 7, 2008 at 1:23 PM, Michael Hasse 
> > <mh...@it...> wrote:
> > > The step-by-step I'm thinking of had a couple things to 
> > watch out for  
> > > when restoring to a server that had SL already installed.  
> > Something  
> > > about removing the existing DB, (or maybe just the tables?) and  
> > > tweaking the database user(s).  Don't remember now.  :/  It wasn't  
> > > anything earthshaking but probably easier than figuring out the  
> > > little gotchas on the fly.
> > >
> > 
> > This not-so-earthshaking information seems to be from my wiki 
> > for SQL-Ledger:
> > http://wiki.ledger123.com/index.php?n=Local.DataRestore
> > Regards
> > 
> > --
> > * Purpose-built SQL-Ledger Hosting
> > * SQL-Ledger VMware Appliance
> > http://www.ledger123.com/
> > 
> > Free trial available.
> > --
> > 
> > --------------------------------------------------------------
> > -----------
> > This SF.net email is sponsored by the 2008 JavaOne(SM) 
> > Conference Don't miss this year's exciting event. There's 
> > still time to save $100. 
> > Use priority code J8TL2D2. 
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> > .sun.com/javaone
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

-- 
Luke

"When the Republicans are in office, Man oppresses Man; When the
Democrats are in office, it's just the opposite."

[SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Andrew @ A. L. <atm...@km...>]

>From what I recal, this is all done through Latex...  any quick thoughts on
what I should check that I many have missed?  I have had it working in all
my other installed so I am guessing I may have missed it along the way...
but... to be sure, it has NOTHING to do with cpan right?  As I did have a
lot of trouble with that...
 
Also as I am not desperate for it,and plan on changing servers next week can
I break anything by trying to fix it (for the most part, as I know just
about anything is possable... I am just looking if I do a basic rpm/install
etc... should I be worried about breaking anything else in SL, not the rest
of my system.
 
Thanks for the support.

Re: [SL] Restoring SL from Backup?

[Andrew @ A. L. <atm...@km...>]

THIS is what I was looking for, I was able to get the data back easy enough.
However Logo's/Users/custom forms etc all lost.
Also in the past every time I installed SL I was able ot get PDF working...
I must have butchered a step as I do not see PDF emails or Prints  :(
Thanks for the help.  PS  I did purchace the manual last year, just did not
renew this year.... Yet.... 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Armaghan Saqib
> Sent: Wednesday, May 07, 2008 3:41 AM
> To: sql...@li...
> Subject: Re: [SL] Restoring SL from Backup?
> 
> On Wed, May 7, 2008 at 1:23 PM, Michael Hasse 
> <mh...@it...> wrote:
> > The step-by-step I'm thinking of had a couple things to 
> watch out for  
> > when restoring to a server that had SL already installed.  
> Something  
> > about removing the existing DB, (or maybe just the tables?) and  
> > tweaking the database user(s).  Don't remember now.  :/  It wasn't  
> > anything earthshaking but probably easier than figuring out the  
> > little gotchas on the fly.
> >
> 
> This not-so-earthshaking information seems to be from my wiki 
> for SQL-Ledger:
> http://wiki.ledger123.com/index.php?n=Local.DataRestore
> Regards
> 
> --
> * Purpose-built SQL-Ledger Hosting
> * SQL-Ledger VMware Appliance
> http://www.ledger123.com/
> 
> Free trial available.
> --
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by the 2008 JavaOne(SM) 
> Conference Don't miss this year's exciting event. There's 
> still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> .sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Restoring SL from Backup?

[Armaghan S. <sa...@le...>]

On Wed, May 7, 2008 at 1:23 PM, Michael Hasse <mh...@it...> wrote:
> The step-by-step I'm thinking of had a couple things to watch out for
>  when restoring to a server that had SL already installed.  Something
>  about removing the existing DB, (or maybe just the tables?) and
>  tweaking the database user(s).  Don't remember now.  :/  It wasn't
>  anything earthshaking but probably easier than figuring out the
>  little gotchas on the fly.
>

This not-so-earthshaking information seems to be from my wiki for SQL-Ledger:
http://wiki.ledger123.com/index.php?n=Local.DataRestore
Regards

-- 
* Purpose-built SQL-Ledger Hosting
* SQL-Ledger VMware Appliance
http://www.ledger123.com/

Free trial available.
--

Re: [SL] Restoring SL from Backup?

[Michael H. <mh...@it...>]

The step-by-step I'm thinking of had a couple things to watch out for  
when restoring to a server that had SL already installed.  Something  
about removing the existing DB, (or maybe just the tables?) and  
tweaking the database user(s).  Don't remember now.  :/  It wasn't  
anything earthshaking but probably easier than figuring out the  
little gotchas on the fly.


Thanks,

Michael


On May 7, 2008, at 1:08 AM, Bob Gustafson wrote:

> As Michael mentions, the help/howto for backup/restore is in the
> Postgresql site.
>
> Michael Hasse wrote:
>> The restore is all postgresql, nothing to do with SL per se.  (The
>> backup is just a dump of the entire contents of the sql database).
>> So as long as you've got the same (or newer) version of SL installed
>> just restore the database and enjoy!
>>     I'm pretty sure I saw a step-by-step somebody posted in the list/
>> forums awhile back but not seeing it at the moment.  Some Googling
>> may be in order, (and/or you can always purchase the paid support
>> from Dieter.  :)
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On May 6, 2008, at 8:07 PM, Andrew @ ATM Logic wrote:
>>
>>
>>> Can someone point me in the direction of the restore from backup  
>>> 101?
>>> I have a failed drive, rebuilt from scratch same OS, Same SL (or
>>> very close,
>>> think I did my last upgrade about... 2 months ago)
>>> I have the backup, I have the working new system.  Just want to get
>>> started
>>> and can work out all my invoices etc again later when I have time.
>>> Does the restore put all the tax info back etc???  What do you NOT
>>> get with
>>> the restore?  (Logo's, Users, Admins??  What happens to all that?)
>>> 	
>>> 	Thanks for any input.
>>>
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> --
>>> ---
>>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>>> Don't miss this year's exciting event. There's still time to save
>>> $100.
>>> Use priority code J8TL2D2.
>>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://
>>> java.sun.com/javaone
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save  
>> $100.
>> Use priority code J8TL2D2.
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
>> java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Restoring SL from Backup?

[Bob G. <bo...@rc...>]

As Michael mentions, the help/howto for backup/restore is in the 
Postgresql site.

Michael Hasse wrote:
> The restore is all postgresql, nothing to do with SL per se.  (The  
> backup is just a dump of the entire contents of the sql database).   
> So as long as you've got the same (or newer) version of SL installed  
> just restore the database and enjoy!
>     I'm pretty sure I saw a step-by-step somebody posted in the list/ 
> forums awhile back but not seeing it at the moment.  Some Googling  
> may be in order, (and/or you can always purchase the paid support  
> from Dieter.  :)
>
>
> Thanks,
>
> Michael
>
>
> On May 6, 2008, at 8:07 PM, Andrew @ ATM Logic wrote:
>
>   
>> Can someone point me in the direction of the restore from backup 101?
>> I have a failed drive, rebuilt from scratch same OS, Same SL (or  
>> very close,
>> think I did my last upgrade about... 2 months ago)
>> I have the backup, I have the working new system.  Just want to get  
>> started
>> and can work out all my invoices etc again later when I have time.
>> Does the restore put all the tax info back etc???  What do you NOT  
>> get with
>> the restore?  (Logo's, Users, Admins??  What happens to all that?)
>> 	
>> 	Thanks for any input.
>>
>>
>>
>> ---------------------------------------------------------------------- 
>> ---
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save  
>> $100.
>> Use priority code J8TL2D2.
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
>> java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] Restoring SL from Backup?

[Michael H. <mh...@it...>]

The restore is all postgresql, nothing to do with SL per se.  (The  
backup is just a dump of the entire contents of the sql database).   
So as long as you've got the same (or newer) version of SL installed  
just restore the database and enjoy!
    I'm pretty sure I saw a step-by-step somebody posted in the list/ 
forums awhile back but not seeing it at the moment.  Some Googling  
may be in order, (and/or you can always purchase the paid support  
from Dieter.  :)


Thanks,

Michael


On May 6, 2008, at 8:07 PM, Andrew @ ATM Logic wrote:

> Can someone point me in the direction of the restore from backup 101?
> I have a failed drive, rebuilt from scratch same OS, Same SL (or  
> very close,
> think I did my last upgrade about... 2 months ago)
> I have the backup, I have the working new system.  Just want to get  
> started
> and can work out all my invoices etc again later when I have time.
> Does the restore put all the tax info back etc???  What do you NOT  
> get with
> the restore?  (Logo's, Users, Admins??  What happens to all that?)
> 	
> 	Thanks for any input.
>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Restoring SL from Backup?

[Andrew @ A. L. <atm...@km...>]

Can someone point me in the direction of the restore from backup 101?
I have a failed drive, rebuilt from scratch same OS, Same SL (or very close,
think I did my last upgrade about... 2 months ago)
I have the backup, I have the working new system.  Just want to get started
and can work out all my invoices etc again later when I have time.
Does the restore put all the tax info back etc???  What do you NOT get with
the restore?  (Logo's, Users, Admins??  What happens to all that?)
	 
	Thanks for any input.

Re: [SL] 2.8.14: Cannot Edit Vendor Record -- RESOLVED

[Rich S. <rsh...@ap...>]

On Tue, 6 May 2008, Rolf Stöckli wrote:

> Is this correct: You get a list like this
> http://www.sql-ledger.org/feature/vendorlist.png and you're not able to
> click on the names?

Rolf,

   Nope, not correct. That's the difference: I was selecting the specific
vendor in the prior page to that, not all of them. With only a single vendor
selected I could not click on its name.

   Selecting 'all' by leaving all fields blank does the trick. Not the
behavior I anticipated, but then I don't need to change addresses too often.

Thank you,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] 2.8.14: Cannot Edit Vendor Record

[Rolf S. <in...@to...>]

Is this correct: You get a list like this
http://www.sql-ledger.org/feature/vendorlist.png
and you're not able to click on the names?

Rolf

Re: [SL] 2.8.14: Cannot Edit Vendor Record

[Rich S. <rsh...@ap...>]

On Tue, 6 May 2008, Paul Tammes wrote:

> As a user is the key.
> Open admin.pl, select the user you are using, and edit rights to
> enter/add/change vendors to the user menu.
>
> If only life was that simple ;-)

   Interesting, Paul. It was always set up that way, but must have changed
with a version upgrade. I wondered if that was the case but have been busy
with other things.

   Well, ... no changes. I am entered as an administrator and everything in
AP is checked as allowing me access. But, I still have no edit option.

   This is by following the AP main heading to Vendors -> Reports -> Search,
then entering the vendor name.

   Next idea?

Many thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] 2.8.14: Cannot Edit Vendor Record

[Paul T. <pt...@wa...>]

As a user is the key.
Open admin.pl, select the user you are using, and edit rights to
enter/add/change vendors to the user menu.

If only life was that simple ;-)


2008/5/6 Rich Shepard <rsh...@ap...>:

>   I just tried to update a vendor's address but cannot do this from the
> A/P
> Reports menu. The last time I needed to modify a vendor account (several
> versions ago) I had no problems. Now I don't see anything but the vendor's
> name displayed despite other fields having labels.
>
>   Any idea why I'm not able to access these records -- as a user?
>
> Thanks,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |  Integrity
>  Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] 2.8.14: Cannot Edit Vendor Record

[Rich S. <rsh...@ap...>]

   I just tried to update a vendor's address but cannot do this from the A/P
Reports menu. The last time I needed to modify a vendor account (several
versions ago) I had no problems. Now I don't see anything but the vendor's
name displayed despite other fields having labels.

   Any idea why I'm not able to access these records -- as a user?

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] BUG - Reconciliation on summary screen

[Kevin B. <kb...@fr...>]

Michael Hasse wrote:
> It may or may not be a bug, depending on how you look at it.  For  
> what it's worth this sort of thing happens in numerous other places  
> as well.  Best to just get in the habit of always using "detail".
>
>
>   

Hi,

Personally, I'd say it's a bug because I have not actually ticked the 
second line but the code marks the transactions as reconciled.  So it 
does something which has not been requested.

But I agree that the best policy for now is to use detail.  The extra 
work in doing so for us is that we often pay meny cheques in at the same 
time - and using the detail view means that we have to work out which 
payments add up together to match the single payment in from the bank 
statement.

Cheers,

Kevin



> Thanks,
>
> Michael
>
>
> On May 5, 2008, at 5:14 AM, Kevin Bailey wrote:
>
>   
>> Hi,
>>
>> Looks after a quick look that there is a bug when using the summary
>> screen (not detail one) to reconcile the bank statements.
>>
>> For all transactions on the same date the summary screen sums up the
>> income and expenses and shows them separately.
>>
>> However,  when I ticked the income line to mark it as reconciled the
>> system also marked as reconciled the expense line.
>>
>> On my system the expense was marked with that date because that was  
>> the
>> cheque dates.  However, the cheque was cleared much later under the  
>> next
>> statement.
>>
>> In any case, on my bank statement the income and expenses are shown
>> differently.
>>
>> This means I either
>>
>> a. use the detail screen.
>>
>> b. beware of any income/expense summary lines which have the same date
>> as the line I want to tick.
>>
>>
>>
>> Could someone confirm this as a bug please and pass it on to Dieter  
>> - we
>> used to have paid support but it has run out.
>>
>> Cheers,
>>
>> Kevin
>>
>> ---------------------------------------------------------------------- 
>> ---
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save  
>> $100.
>> Use priority code J8TL2D2.
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
>> java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] BUG - Reconciliation on summary screen

[Michael H. <mh...@it...>]

It may or may not be a bug, depending on how you look at it.  For  
what it's worth this sort of thing happens in numerous other places  
as well.  Best to just get in the habit of always using "detail".


Thanks,

Michael


On May 5, 2008, at 5:14 AM, Kevin Bailey wrote:

> Hi,
>
> Looks after a quick look that there is a bug when using the summary
> screen (not detail one) to reconcile the bank statements.
>
> For all transactions on the same date the summary screen sums up the
> income and expenses and shows them separately.
>
> However,  when I ticked the income line to mark it as reconciled the
> system also marked as reconciled the expense line.
>
> On my system the expense was marked with that date because that was  
> the
> cheque dates.  However, the cheque was cleared much later under the  
> next
> statement.
>
> In any case, on my bank statement the income and expenses are shown
> differently.
>
> This means I either
>
> a. use the detail screen.
>
> b. beware of any income/expense summary lines which have the same date
> as the line I want to tick.
>
>
>
> Could someone confirm this as a bug please and pass it on to Dieter  
> - we
> used to have paid support but it has run out.
>
> Cheers,
>
> Kevin
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save  
> $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http:// 
> java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] BUG - Reconciliation on summary screen

[Kevin B. <kb...@fr...>]

Hi,

Looks after a quick look that there is a bug when using the summary 
screen (not detail one) to reconcile the bank statements.

For all transactions on the same date the summary screen sums up the 
income and expenses and shows them separately.

However,  when I ticked the income line to mark it as reconciled the 
system also marked as reconciled the expense line.

On my system the expense was marked with that date because that was the 
cheque dates.  However, the cheque was cleared much later under the next 
statement.

In any case, on my bank statement the income and expenses are shown 
differently.

This means I either

a. use the detail screen.

b. beware of any income/expense summary lines which have the same date 
as the line I want to tick.



Could someone confirm this as a bug please and pass it on to Dieter - we 
used to have paid support but it has run out.

Cheers,

Kevin

[SL] HELP - recover from failed drive.

[Andrew @ A. L. <atm...@km...>]

If I have a a few day old backup, but I have the entire contents of my
failed drive ( was able to mount the old drive, and SCP the mounted image to
a working server)  What is the best / quickest way to get the SL back up and
running as it was?
 
e.g.  Can I install SL on the new system... then copy the folders over?  
 
My brain is already overtaxed working out how to restore the rest of
everything so details would be great.
 
My old and new system are SME 7.3  (CentOS based)
 
Thanks.

Re: [SL] help with error after restoring backup please

[Bob G. <bo...@rc...>]

I think that restore assumes that the database exists, but no tables or 
anything else, just a blank database.

Paul Tammes wrote:
> Use the upgrade scripts to get your backupfile up to speed.
> Presumably something like
> psql upgrade_2.14.0_2.16.2 < mybackupfile.sql
> and then later 2.16.2_2.18.x
>
> THEN (and not sooner) start admin.pl and update datasets.
> But see docs for exact commands.
>
> 2008/4/26 Mike <lak...@co...>:
>
>   
>> Hello,
>>
>> I recently installed (fresh installation - not distro upgrade)
>> Ubuntu 8.04 LTS. I was previously using Ubuntu 7.10 which was
>> distro upgraded from 7.04. I decided a clean fresh install was
>> the way to go this time so I backed up my sql-ledger (and
>> everything else I needed to keep) and did a clean install.
>>
>> I installed sql-ledger 2.8.14 and tried to restore my backup
>> but when launching sql-ledger I am receiving this error:
>> ---------------------------------------------
>> Upgrading to Version 2.8.14 ...
>> Error!
>>
>> create table curr (rn int, curr char(3) primary key, precision
>> int2)
>> ERROR: relation "curr" already exists
>> ---------------------------------------------
>> Could someone please explain this to me and what I need to do
>> the get this up and running again?
>>
>> Thanks very much!
>> Mike
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save $100.
>> Use priority code J8TL2D2.
>>
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>     
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] help with error after restoring backup please

[Paul T. <pt...@wa...>]

Use the upgrade scripts to get your backupfile up to speed.
Presumably something like
psql upgrade_2.14.0_2.16.2 < mybackupfile.sql
and then later 2.16.2_2.18.x

THEN (and not sooner) start admin.pl and update datasets.
But see docs for exact commands.

2008/4/26 Mike <lak...@co...>:

> Hello,
>
> I recently installed (fresh installation - not distro upgrade)
> Ubuntu 8.04 LTS. I was previously using Ubuntu 7.10 which was
> distro upgraded from 7.04. I decided a clean fresh install was
> the way to go this time so I backed up my sql-ledger (and
> everything else I needed to keep) and did a clean install.
>
> I installed sql-ledger 2.8.14 and tried to restore my backup
> but when launching sql-ledger I am receiving this error:
> ---------------------------------------------
> Upgrading to Version 2.8.14 ...
> Error!
>
> create table curr (rn int, curr char(3) primary key, precision
> int2)
> ERROR: relation "curr" already exists
> ---------------------------------------------
> Could someone please explain this to me and what I need to do
> the get this up and running again?
>
> Thanks very much!
> Mike
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>