sql-ledger-users

[SL] Thinking of upgrading

[Jeff R. <je...@jr...>]

Hi All

First of all my system is working and stable so I probably shouldn't 
mess with it but I feel I may be missing out on features if I don't upgrade.

I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
I then have SQL-Ledger 2.6.22 running with it.

It's working OK with CUPS but I have no email capabilities available so 
I end up printing pdfs to screen, saving them and then emailing them as 
attachments.

Is it worth the aggravation to upgrade it all? I'm assuming I can't 
upgrade SQL-Ledger all the way without also upgrading PSQL and Apache so 
it's looking like a big job with possible failures and catastrophies 
along the way.

Are those of you that are working with the latest version of SQL-Ledger 
happy with the added functions and features? If you were me would you 
spend the time upgrading to get those features?

Jeff

Re: [SL] Thinking of upgrading

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

We stayed on 2.6.22 for a long time and only just recently upgraded  
for something feature or the other, (I forget what exactly!).  I.e.,  
unless you need a feature or bugfix in a newer version there's really  
no case for upgrading.
    As for the email, that's completely unrelated to the upgrade.   
However your email is now is how it will be after the upgrade.
    If you do not have email functionality currently you could  
probably post the symptoms/errors/etc here and somebody would be  
happy to chime in and help get you going in the right direction.


Thanks,

Michael


On Jan 9, 2008, at 7:07 PM, Jeff Roberts wrote:

> Hi All
>
> First of all my system is working and stable so I probably shouldn't
> mess with it but I feel I may be missing out on features if I don't  
> upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities  
> available so
> I end up printing pdfs to screen, saving them and then emailing  
> them as
> attachments.
>
> Is it worth the aggravation to upgrade it all? I'm assuming I can't
> upgrade SQL-Ledger all the way without also upgrading PSQL and  
> Apache so
> it's looking like a big job with possible failures and catastrophies
> along the way.
>
> Are those of you that are working with the latest version of SQL- 
> Ledger
> happy with the added functions and features? If you were me would you
> spend the time upgrading to get those features?
>
> Jeff
>
>
> ---------------------------------------------------------------------- 
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Thinking of upgrading

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

Jeff Roberts wrote:
> Hi All
>
> First of all my system is working and stable so I probably shouldn't 
> mess with it but I feel I may be missing out on features if I don't 
> upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities available 
> so I end up printing pdfs to screen, saving them and then emailing 
> them as attachments.
>   
FreeBSD is perhaps the easiest *nix to configure for anything (thanks to 
ports collection) when compared to CentOS or OpenSolaris (the other two 
I use). On a new server, I go to "/usr/ports/mail/postfix" and run "make 
install". Once finished, I make few changes to "/etc/rc.conf" as 
presented by post-install message and mail server is done.

Run "tail /var/log/maillog"  and "mailq" commands and let me know what 
is there so I could help you rectify this issue.

> Is it worth the aggravation to upgrade it all? I'm assuming I can't 
> upgrade SQL-Ledger all the way without also upgrading PSQL and Apache 
> so it's looking like a big job with possible failures and 
> catastrophies along the way.
>
> Are those of you that are working with the latest version of 
> SQL-Ledger happy with the added functions and features? If you were me 
> would you spend the time upgrading to get those features?
>
> Jeff
>   
I don't thing you need to upgrade postgres. Apache should be fine too 
because sql-ledger is a cgi application and does not use any web server 
functionality.

 From README.

REQUIREMENTS:
-------------
1 - Perl, 5+
2 - http server (Apache, NCSA, httpi, thttpd, ...)
3 - SQL Server (PostgreSQL 7.1+)
4 - DBD (DBD-Pg)
5 - DBI
6 - LaTeX (optional)


And you can always test your upgrade by installing latest version in a 
different folder with the copy of database and your "user" and 
"templates" folder.

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Thinking of upgrading

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

Jeff Roberts wrote:
> Hi All
>
> First of all my system is working and stable so I probably shouldn't 
> mess with it but I feel I may be missing out on features if I don't upgrade.
>
> I have Postgres 7.4.5 and Apache running on a FreeBSD 5.3 server
> I then have SQL-Ledger 2.6.22 running with it.
>
> It's working OK with CUPS but I have no email capabilities available so 
> I end up printing pdfs to screen, saving them and then emailing them as 
> attachments.
>   
FreeBSD is perhaps the easiest *nix to configure for anything (thanks to 
ports collection) when compared to CentOS or OpenSolaris (the other two 
I use). On a new server, I go to "/usr/ports/mail/postfix" and run "make 
install". Once finished, I make few changes to "/etc/rc.conf" as 
presented by post-install message and mail server is done.

Run "tail /var/log/maillog"  and "mailq" commands and let me know what 
is there so I could help you rectify this issue.

> Is it worth the aggravation to upgrade it all? I'm assuming I can't 
> upgrade SQL-Ledger all the way without also upgrading PSQL and Apache so 
> it's looking like a big job with possible failures and catastrophies 
> along the way.
>
> Are those of you that are working with the latest version of SQL-Ledger 
> happy with the added functions and features? If you were me would you 
> spend the time upgrading to get those features?
>
> Jeff
>   
I don't thing you need to upgrade postgres. Apache should be fine too 
because sql-ledger is a cgi application and does not use any web server 
functionality.

 From README.

 REQUIREMENTS:
 -------------
 1 - Perl, 5+
 2 - http server (Apache, NCSA, httpi, thttpd, ...)
 3 - SQL Server (PostgreSQL 7.1+)
 4 - DBD (DBD-Pg)
 5 - DBI
 6 - LaTeX (optional)


And you can always test your upgrade by installing latest version in a 
different folder with the copy of database and your "user" and 
"templates" folder.

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/