New ebuild contributed for the rather nice accounting system: sql-ledger This is probably the best free "accounting system" currently available right now. Note this is a different kind of beast to kmymoney or gnucash - these are more personal accounting systems (which have some company bits as well), whereas sql-ledger is much more suitable for small to medium sized businesses. Basically it's a general ledger app and a decent alternative to Sage The ebuild "works", but the original app setup does some extra things which could be added to the ebuild. For example there is a "lock out" system by touching a file in the users directory which stops the system being used while the files are upgraded. Also it needs to add some stuff to the Apache config file. Grateful for some pointers on how best to implement these two points Oh, and Latex is an optional dependency, but not sure what to do about that...?
Created attachment 77572 [details] new ebuild
Created attachment 77573 [details] postinstall file
version bump to -2.6.7 Also There is an error in the ebuild for the keepdir command the ${D}/ needs to be removed to install correctly.
Created attachment 81899 [details] updated ebuild fixed an error in the keepdir command.
Cheers, you appear to be correct about the keepdir change. I am just testing right now with 2.6.7, but everything appears normal. Just a note to anyone using this ebuild, the upgrade ability is still not handled explicitly. It *should* upgrade the code correctly, but you really don't want to have anyone using the system while the code changes (obviously). SL *does* have an inbuilt ability to lock everyone out of the system while an upgrade is in progress and this should ideally be made use of during the part of the process where the webapp installs itself into a subdir. Not sure what the hooks are to handle this though, so patches welcome However, if you lock the system manually or if like most people it's a small shop and you just don't use the system while the upgrade is in progress (kill apache) then everything should be fine Ed
There are a few more changes still needed I think. I don't have it all working yet. It appears that there are a couple /etc... configs that could be installed via the ebuild. An update patch is needed for >=postgres-8. Also I would like to change the post-install instructions file into einfo statements. The current method does not get picked up by porthole filters. I have not had the time again this week to work on it :(
I have it working with version -2.6.9 without any difficulties just renamed the ebuild. It appears I was wrong about the >postgres-8.0 patches as they are already applied to recent versions. version 2.6.9 has been working great for me. I haven't actually entered real data yet. I have been modifying things for my use though. I have changed the invoice templates to use our logos etc. I have added a custom footer to invoices, etc.. All has been going well despite my lack of tex and html knowledge.
Created attachment 87774 [details] apache2 - sql-ledger.conf file /etc/apache2/vhosts.d/sql-ledger.conf just put this file in the above location for apache's use. No need to edit the apache file. If I knew how to add it to the ebuild properly I would. Some dev should know how and only take a few seconds to do it :)
Hi I opened up thred in unsupported software on gentoo forums [url=http://forums.gentoo.org/viewtopic-t-481957-start-0-postdays-0-postorder-asc-highlight-.html] here [/url] this proram is under constant development and would be great if it could be updated with emerge and all necessary config files installed with ebuild. I have been running sql-ledger for 6 months on gentoo ppc server using the installed supplyed find it very stable.
Created attachment 128735 [details] ebuild for latest sql-ledger Here is the latest sql-ledger ebuild for 2.8.7 Printing with tetex added as a dependency. The application will not post invioves if they are not printed to a paper printer or print checks without a printer. It has no way of printing without tetex. If someone is majorly opposed to this dep then it could be an a USE flag. It would be nice to make it a slotted app managed with eselect when it gets into portage.
Created attachment 139683 [details] updated for apache 2.2.6-r5
Created attachment 139685 [details] ebuild for sql-ledger version 2.8.11
ebuild.attachment should be named postinstall-en.txt
thanks for the ebuild! i've tested the version-bumped ebuild (just rename it to sql-ledger-2.8.12.ebuild) on my xenon/amd64 box and i can confirm that it works fine here too (hence please consider adding at least the ~amd64 keyword as well). looking forward to an ebuild that handles updates too (any idea how to accomplish this? i haven't dealt with emerge's syntax and features for quite a while now, so i'm probably the wrong person to take a look at it).
Created attachment 171470 [details] ebuild for sql-ledger version 2.8.18 untested though
The current version of sql-ledger is 2.8.23. Simply take the sql-ledger-2.8.11.ebuild (or the sql-ledger-2.8.18.ebuild, it's identical) and rename it to sql-ledger-2.8.23.ebuild. Works fine on my box, also when updating an older version (>2.8). I've updated 2.8.12 to 2.8.23 and it worked as expected. Looks like the first time you log in, sql-ledger takes care of updating the tables, if needed. My box is an AMD64 box. I can thus confirm that you can at least set KEYWORDS="x86 ppc ~amd64" (or even KEYWORDS="x86 ppc amd64") instead of KEYWORDS="x86 ppc".
(this is an automated message based on filtering criteria that matched this bug) 'EBUILD' is in the KEYWORDS which should mean that there is a ebuild attached to this bug. This bug is assigned to maintainer-wanted which means that it is not in the main tree. Heuristics show that no Gentoo developer has commented on your ebuild. Hello, The Gentoo Team would like to firstly thank you for your ebuild submission. We also apologize for not being able to accommodate you in a timely manner. There are simply too many new packages. Allow me to use this opportunity to introduce you to Gentoo Sunrise. The sunrise overlay[1] is a overlay for Gentoo which we allow trusted users to commit to and all users can have ebuilds reviewed by Gentoo devs for entry into the overlay. So, the sunrise team is suggesting that you look into this and submit your ebuild to the overlay where even *you* can commit to. =) Because this is a mass message, we are also asking you to be patient with us. We anticipate a large number of requests in a short time. Thanks, On behalf of the Gentoo Sunrise Team, Jeremy. [1]: http://www.gentoo.org/proj/en/sunrise/ [2]: http://overlays.gentoo.org/proj/sunrise/wiki/SunriseFaq
There have been multiple vulnerability reports for SQL Ledger: Name: CVE-2009-3580 URL: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3580 Name: CVE-2009-3581 URL: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3581 Name: CVE-2009-3582 URL: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3582 Name: CVE-2009-3583 URL: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3583 Name: CVE-2009-3584 URL: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3584 Please consider updating the ebuilds here and in any overlays they are in to a not vulnerable version. The initial commiter to gentoo-x86 has to make sure that these issues are fixed before importing the package. Thanks.
tetex dep should probably be replaced with texlive, since tetex is not in the tree anymore. on my system tex migration worked pretty much as drop-in replacement.
*** Bug 394943 has been marked as a duplicate of this bug. ***
*** Bug 405169 has been marked as a duplicate of this bug. ***
Created attachment 583352 [details] Update sql-ledger ebuild to 3.2.8 Added latex use flag, converted to use webapp config, EAPI 6 Test and enjoy
