Sql-ledger ebuild development

[turtles]

I opened up this thread for anyone interested in helping develop a complete sql-ledger ebuild. http://www.sql-ledger.com

NOTE: I have never maintained or developed an ebuild so any help / patience would be greatly appreciated.

Currently there is an ebuild on bugzilla. I have taken a few setps to install it outlined below.

Code: Select all

cd /usr/local/portage
mkdir app-office
cd app-office
mkdir sql-ledger
cd sql-ledger
wget http://bugs.gentoo.org/attachment.cgi?id=81899 
cp attachment.cgi\?id\=81899 sql-ledger.ebuild
nano sql-ledger.ebuild

add ppc to keywords
Add to package.keywords

Code: Select all

echo ~app-office/sql-ledger ppc >> /etc/portage/package.keywords 

Code: Select all

ebuild sql-ledger.ebuild digest  

Code: Select all

--- Invalid atom in /etc/portage/package.keywords: ~app-office/sql-ledger
!!! portage/sql-ledger does not follow correct package syntax.

Any ideas??

[turtles]

It has gotta be named sql-ledger-2.6.15.ebuild

And it worked up until here

Code: Select all

>>> Downloading http://easynews.dl.sourceforge.net/sourceforge/sql-led                                                                    ger/sql-ledger-2.6.15.tar.gz
--23:48:52--  http://easynews.dl.sourceforge.net/sourceforge/sql-ledge                                                                    r/sql-ledger-2.6.15.tar.gz
           => `/usr/portage/distfiles/sql-ledger-2.6.15.tar.gz'
Resolving easynews.dl.sourceforge.net... 69.16.168.245
Connecting to easynews.dl.sourceforge.net|69.16.168.245|:80... connect                                                                    ed.
HTTP request sent, awaiting response... 200 OK
Length: 2,954,374 (2.8M) [application/x-tar]

100%[==========================>] 2,954,374     99.83K/s    ETA 00:00

23:49:23 (95.22 KB/s) - `/usr/portage/distfiles/sql-ledger-2.6.15.tar.                                                                    gz' saved [2954374/2954374]

>>> Creating Manifest for /usr/local/portage/app-office/sql-ledger
!!! aux_get(): ebuild path for 'app-office/sql-ledger' not specified:
!!!            None
getfetchlist(): aux_get() error reading app-office/sql-ledger; abortin                                                                    g.

[PaulBredbury]

Read the wiki on how to install ebuilds.

[fidel]

I tried the ebuild, works fine until:

Code: Select all

....

 * (server owned) htdocs/spool
 * Marking Config Files
 * (config) htdocs/sql-ledger.conf
 * ebuild fault: file '/usr/portage/app-office/sql-ledger/files/postinstall-en.txt' not found
 * Please report this as a bug at http://bugs.gentoo.org/

!!! ERROR: app-office/sql-ledger-2.6.15 failed.
Call stack:
  ebuild.sh, line 1539:   Called dyn_install
  ebuild.sh, line 1013:   Called src_install
  sql-ledger-2.6.15.ebuild, line 72:   Called webapp_postinst_txt 'en' '/usr/portage/app-office/sql-ledger/files/postinstall-en.txt'
  webapp.eclass, line 169:   Called webapp_checkfileexists '/usr/portage/app-office/sql-ledger/files/postinstall-en.txt'
  webapp.eclass, line 81:   Called die

!!! ebuild fault: file '/usr/portage/app-office/sql-ledger/files/postinstall-en.txt' not found

Before I tried to setup sql-ledger on my own, just as I have about a year ago. But now I get the following error:

Code: Select all

[Thu Aug 03 14:42:44 2006] [error] Can't locate bin/mozilla/login.pl in @INC (@INC contains: /home/httpd/perl /etc/perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux /usr/lib64/perl5/vendor_perl/5.8.8 /usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux /usr/lib64/perl5/vendor_perl/5.8.7 /usr/lib64/perl5/vendor_perl /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux /usr/lib64/perl5/site_perl/5.8.8 /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux /usr/lib64/perl5/site_perl/5.8.7 /usr/lib64/perl5/site_perl /usr/lib64/perl5/5.8.8/x86_64-linux /usr/lib64/perl5/5.8.8 /usr/local/lib/site_perl . /usr/lib64/apache2) at /var/www/localhost/htdocs/ledger/login.pl line 118.\n

I haven't ever written an ebuild, I need to dig into this first, will take some time!...
On the other hand I really think SQL-Ledger is an absolute awesome tool and an ebuild would be loved for several users for sure!..
Does anybody by incident know, what is going wrong with my sql-ledger install?... What is this calling bin/mozilla.... would perhaps a virtual host instead of an alias do the trick?
Thanks for any hints!
Greets

[pjeutr]

'/usr/portage/app-office/sql-ledger/files/postinstall-en.txt' not found
just create that file or download it at http://bugs.gentoo.org/attachment.cgi?id=77573 it only contains text with postinstall instructions
emerge is running fine here

[fidel]

Thanks!
Actually, I solved my problem by installing sql-ledger manually. I had messed PERL settings that lead to problems. SQL-Ledger runs fine now! -->
Greets

[turtles]

Edit
Well updatiing a new hardened-server for sql-ledger, wouldent it be a shame if the main program on the server did not have an ebuild.

I am looking for tips on how to make the ebuild check for updates to sql-ledger.

[turtles]

I am modifying sql-ledger, where is the correct place to put the code and what should I tell the ebuild the src_uri is?

Code: Select all

SRC_URI=/usr/local/portage/overlay/sql-ledger/sql-ledger-2.7.9-r10.gz

[PaulBredbury]

Should use:

Code: Select all

SRC_URI="mirror://sourceforge/${PN}/${P}.tar.gz"

And name the ebuild: sql-ledger-2.6.7.ebuild

Are you sure that -r10 should be part of the filename of the file that is downloaded from sourceforge?

Ebuilds do not check for updates. Go to sourceforge and click on the "monitor" icon. You'll need a sourceforge account.

[turtles]

Hi thanks for the reply Paul. We have someone customising the code a bit so we have our own version. I
So I am wondering where is the best place for the custom code.
I have a local rsync server (on a lan) and I would like any box on the network to be able to build sql-ledger or anyone at all whom is interested in testing it.

In addition the author of sql-ledger does not releace the latest version to Sourceforge it has to be manualy fetched from a password protected site.

It will be customised for a service based buisness that does alot of time and material billing. It generates estimates instead of quotations. It also generates a work order from an estimate that emloyees can use to generate time cards.

Next is to generate a US payroll module.

cheers turtle

[PaulBredbury]

In that case, use SRC_URI="${P}-r10.gz" and RESTRICT="fetch" in the ebuild, and put the file in /usr/portage/distfiles.

[turtles]

Thanks that did it. I have been reading http://www.gentoo.org/proj/en/devrel/ha ... t=2&chap=1

I however seem to not be placing some files in the right places.

Code: Select all

!!! The following are listed in SRC_URI for sql-ledger:
!!!   sql-ledger-2.7.9-r1.gz
!!! The following are listed in SRC_URI for sql-ledger:
!!!   sql-ledger-2.7.9-r1.gz
>>> Unpacking source...
>>> Unpacking sql-ledger-2.7.9-r1.gz to /var/tmp/portage/sql-ledger-2.7.9-r1/work
>>> Source unpacked.
!!! The following are listed in SRC_URI for sql-ledger:
!!!   sql-ledger-2.7.9-r1.gz
>>> Compiling source in /var/tmp/portage/sql-ledger-2.7.9-r1 ...

>>> Source compiled.
!!! The following are listed in SRC_URI for sql-ledger:
!!!   sql-ledger-2.7.9-r1.gz
>>> Test phase [not enabled]: app-office/sql-ledger-2.7.9-r1
!!! The following are listed in SRC_URI for sql-ledger:
!!!   sql-ledger-2.7.9-r1.gz

>>> Install sql-ledger-2.7.9-r1 into /var/tmp/portage/sql-ledger-2.7.9-r1/image/ category app-office
 * Installing docs
dodoc: doc/* does not exist
 * Copying main files
cp: cannot stat `sql-ledger.conf.default': No such file or directory

sql-ledger.conf.default and doc/*? should they not be in the tar file?

Link to the ebuild

[PaulBredbury]

Sounds like you've forgotten to unpack ${A} in src_unpack(). What you should be doing is taking a look in /var/tmp/portage/appname...

To debug, run ebuild myebuild unpack and take a look, or add die to the ebuild.

[turtles]

I forgot the

Code: Select all

.tar

part.
I changed the ebuild to reflect the current version of sql-ledger and not any customised version.
So if you want to run the latest version of sql-ledger the ebuild in the link above works.
How ever I dont know where a change log should go? Since I added tetex as a dependency (you need it to print) and the fetch restriction.

If anyone would like to try our modifed version for a service based buisness that does time and meterials billing let me know.

Thanks for your help Paul

[PaulBredbury]

where a change log should go

That's what dodoc is for. dodoc ChangeLog.

[Joseph_sys]

Turtles, were you able to make the ebuild to work.
I would be interested in it as well.

It would be best if it was incorporated into portage.

[turtles]

Ebuild works as it is in bugzila now. I have tested it on ppc and x86.
It needs some fine tuning if it is going to be used to update, however most updates are only through the paid support version.
The paid support is quite worth it. I have a modified ebuild for the paid support version. 2.7 let me know if you want it.
It just requires you to manually fetch the latest sources.

We (Think Electric) are in the process of making a set of patches for sql-ledger that will make it work better for a time and materials based business.

TIP: Run it on a dedicated hardened server and grant no one shell access.

Experience:
I don't know perl but our programmer thinks sql-ledger is due for a major overhaul.
Someone ported the whole thing to php at one time but the project did not seem to take off.
Accounting software is not the kind of thing programmers are dyeing to volunteer lots of time to do I guess so i kinda like the idea of the paid support .

I have had no luck getting my (mac Quickbooks based) partner (the book keeper) to actually use the program for accounting. We use it for estimating and job tracking at the moment. We are hoping to start using it for everything after we get done customizing it.

Regardless it it the best thing I have used. I have tried Gnucash, and Appgen ($250 & closed source).
The bottom line is you can link an office to a POS or link 2 home offices or as many as you want.

[Joseph_sys]

Ebuild works as it is in bugzila now. I have tested it on ppc and x86.
It needs some fine tuning if it is going to be used to update, however most updates are only through the paid support version.
The paid support is quite worth it. I have a modified ebuild for the paid support version. 2.7 let me know if you want it.
It just requires you to manually fetch the latest sources.

We (Think Electric) are in the process of making a set of patches for sql-ledger that will make it work better for a time and materials based business. [snip]

sql-ledger has a setup.perl scrip and the source code available on the web-page, though it is only 2.6.26 version.
We don't have to have the latest and greatest this is not a fashion business
You pay for the support (via email/phone) and patches notification not for the software.

I haven't upgraded my (still on 2.2.7) but now I'm stuck, see my post and appreciate if you can help:
sql-ledger/login.pl: symbol lookup error
http://forums.gentoo.org/viewtopic-t-54 ... edger.html

I think it has something to do with the resent perl scripts update but I am googling and and not crack it.