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/