Menu
▾
▴
sql-ledger-users — SQL-Ledger users
You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(68) |
Feb
(121) |
Mar
(59) |
Apr
(49) |
May
(110) |
Jun
(109) |
Jul
(146) |
Aug
(122) |
Sep
(83) |
Oct
(94) |
Nov
(90) |
Dec
(157) |
| 2002 |
Jan
(169) |
Feb
(186) |
Mar
(168) |
Apr
(353) |
May
(338) |
Jun
(278) |
Jul
(220) |
Aug
(336) |
Sep
(122) |
Oct
(183) |
Nov
(111) |
Dec
(265) |
| 2003 |
Jan
(358) |
Feb
(135) |
Mar
(343) |
Apr
(419) |
May
(277) |
Jun
(145) |
Jul
|
Aug
(134) |
Sep
(118) |
Oct
(97) |
Nov
(240) |
Dec
(293) |
| 2004 |
Jan
(412) |
Feb
(217) |
Mar
(202) |
Apr
(237) |
May
(333) |
Jun
(201) |
Jul
(303) |
Aug
(218) |
Sep
(285) |
Oct
(249) |
Nov
(248) |
Dec
(229) |
| 2005 |
Jan
(314) |
Feb
(175) |
Mar
(386) |
Apr
(223) |
May
(281) |
Jun
(230) |
Jul
(200) |
Aug
(197) |
Sep
(110) |
Oct
(243) |
Nov
(279) |
Dec
(324) |
| 2006 |
Jan
(335) |
Feb
(396) |
Mar
(383) |
Apr
(358) |
May
(375) |
Jun
(190) |
Jul
(212) |
Aug
(320) |
Sep
(358) |
Oct
(112) |
Nov
(213) |
Dec
(95) |
| 2007 |
Jan
(136) |
Feb
(104) |
Mar
(156) |
Apr
(115) |
May
(78) |
Jun
(75) |
Jul
(30) |
Aug
(35) |
Sep
(50) |
Oct
(44) |
Nov
(33) |
Dec
(35) |
| 2008 |
Jan
(90) |
Feb
(63) |
Mar
(47) |
Apr
(42) |
May
(72) |
Jun
(85) |
Jul
(25) |
Aug
(20) |
Sep
(14) |
Oct
(11) |
Nov
(25) |
Dec
(39) |
| 2009 |
Jan
(39) |
Feb
(46) |
Mar
(16) |
Apr
(27) |
May
(51) |
Jun
(66) |
Jul
(78) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(4) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Dieter S. <dsi...@sq...> - 2001-07-30 16:56:39
|
check if you installed DBD-Pg Steve sent a perl script to the list last week. You can run it to probe for the driver. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 30 Jul 2001, Nicolas Lafferty wrote: > Fo some reason i get a Compilation failed in require at /path/to/login.pl > line 65. > I'm using the private directory installation with the included server > software. > Any suggestions? > > > Nicholas Lafferty > > > > |
|
From: Nicolas L. <nla...@pe...> - 2001-07-30 16:37:01
|
Fo some reason i get a Compilation failed in require at /path/to/login.pl line 65. I'm using the private directory installation with the included server software. Any suggestions? Nicholas Lafferty |
|
From: Philip R. <p....@tu...> - 2001-07-30 15:10:21
|
Hello, I just started to use sql-ledger and I'm faszinated by all the features the program already has. But now I have one problem I need some help on: I would like to costumize the templates for invoice and packing list. I already managed to get the basic layout to fit my needs, but I have to more tricky questions. 1) I would like to add other variables to the template like costumer_id, how do I do it? 2) Even more important: If I have an invoice that spans over more than one page I would like two different layouts. One for the first page on my company paper and a second layout for the rest on blank paper. And maybe it is even possible to add some kind of subtotal on the end of each side? I hope I'm not asking for too much. Any help is highly appreciated. Thanks a lot. Ciao, Philip |
|
From: Wesley <wsh...@qx...> - 2001-07-30 02:24:54
|
Hi, I just started looking at sql-ledger, and I like the full-fledged double-entry accounting, and I like the fact that it runs on Apache, Perl, and PostgreSQL. What I'm wondering is how many current users use it for personal finances, in place of something like GnuCash or Quicken? I've been using GnuCash since last Fall, before that I used CBB, and before that I think I was still using InCharge! under OS/2. I really like GnuCash's double-entry and applying full accounting principals to personal finances. I suppose specific suitability questions would be: * Does anyone use it for personal finances, or only for business finances? * Are there any facilities for tracking the value of something like stocks or mutual funds? I'm not talking about automatic stock quote lookup, just being able to enter number of shares, cost per share at purchase, "today", and at time of sale for historical and tax purposes. * It appears to be straight Perl CGI scripts. Is the code safe to run under mod_perl? i.e., do all the variables get initialized properly, has it been tested under mod_perl, etc.? I know the docs say it will run on a P100, but I'm trying to run it on a P90. :-) It runs, but slowly, and I'll take any speedup I can get. * Although I think I have a grasp of double-entry fundamentals, some of the default accounts weren't entirely clear to me. Are these documented anywhere in any way? Specific ones that looked useful that I don't completely 'get' are: #1205 - Allowance for doubtful accounts (estimate of how much I think I'm going to be stiffed?) #1825 and #1845: "Accum. Amort." Is this the same as depreciation? #2310 and #2311: "GST" and "PST"??? #3590 and #3600: Retained Earnings from Prior years, Current Earnings. In GnuCash, I've only used Retained Earnings to balance the starting balances in various accounts at the time I started using GnuCash. It doesn't support a way to "close the books" at the end of the year. Does SQL-Ledger support closing the books at year's end? Is this the right place to balance my "starting balances"? I have both assets (checking, savings, etc.) and liabilities (various loans) to balance; should the latter have a separate "Retained Losses" account?? Thanks in advance, -- Wes Sheldahl wsh...@qx... |
|
From: Steve D. <sd...@sw...> - 2001-07-28 14:33:22
|
Hello everyone. I received the following alert on the Debian security mailing list. Since it probably applies to many sql-ledger users, I thought I would forward it. I also included Google's cache of the alert since securityfocus seems to be down this morning (how convenient). It's recommended that you upgrade Apache to a secure version immediately. -------- Original Message -------- Subject: [SECURITY] [DSA-067-1] New versions of apache, fixes index bug Resent-From: deb...@li... Date: Sat, 28 Jul 2001 02:59:23 +0200 From: Robert van der Meulen <rv...@wi...> Reply-To: sec...@de... To: deb...@li... -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - ------------------------------------------------------------------------ Debian Security Advisory DSA-067-1 sec...@de... http://www.debian.org/security/ Robert van der Meulen July 28, 2001 - ------------------------------------------------------------------------ Package : apache,apache-ssl Problem type : remote exploit Debian-specific : no We have received reports that the 'apache' http daemon, as included in the Debian 'stable' distribution, is vulnerable to the 'artificially long slash path directory listing vulnerability' as described in http://www.securityfocus.com/vdb/bottom.html?vid=2503 . This vulnerability was announced to bugtraq by Dan Harkless. Quoting the SecurityFocus entry for this vulnerability: A problem in the package could allow directory indexing, and path discovery. In a default configuration, Apache enables mod_dir, mod_autoindex, and mod_negotiation. However, by placing a custom crafted request to the Apache server consisting of a long path name created artificially by using numerous slashes, this can cause these modules to misbehave, making it possible to escape the error page, and gain a listing of the directory contents. This vulnerability makes it possible for a malicious remote user to launch an information gathering attack, which could potentially result in compromise of the system. Additionally, this vulnerability affects all releases of Apache previous to 1.3.19. **************BUGTRAQ NOTICE************************************* bugtraq id 2503 class Input Validation Error cve CVE-MAP-NOMATCH remote Yes local No published March 13, 2001 updated June 29, 2001 vulnerable Apache Group Apache 1.3.9 - Sun Solaris 8.0_x86 - Sun Solaris 8.0 + Debian Linux 2.2 sparc + Debian Linux 2.2 powerpc + Debian Linux 2.2 arm + Debian Linux 2.2 alpha + Debian Linux 2.2 68k + Debian Linux 2.2 Apache Group Apache 1.3.3 + RedHat Linux 5.2 sparc + RedHat Linux 5.2 i386 + RedHat Linux 5.2 alpha Apache Group Apache 1.3.17win32 - Microsoft Windows ME - Microsoft Windows 98se - Microsoft Windows 98 - Microsoft Windows 95 - Microsoft Windows NT 4.0SP6a + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP6 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP5 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP4 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP3 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP2 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0SP1 + Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0 - Microsoft Windows 2000 SP2 - Microsoft Windows 2000 SP1 - Microsoft Windows 2000 Apache Group Apache 1.3.17 + S.u.S.E. Linux 7.1 + OpenBSD OpenBSD 2.8 Apache Group Apache 1.3.14 + MandrakeSoft Linux Mandrake 7.2 Apache Group Apache 1.3.12 + S.u.S.E. Linux 7.0sparc + S.u.S.E. Linux 7.0 + RedHat Linux 7.0 i386 + RedHat Linux 7.0 alpha + RedHat Linux 6.2 sparc + RedHat Linux 6.2 i386 + RedHat Linux 6.2 alpha not vulnerable Apache Group Apache 1.3.19 - Sun Solaris 8.0 - Sun Solaris 7.0 - SGI IRIX 6.5.9 - SGI IRIX 6.5.8 - S.u.S.E. Linux 7.1 - S.u.S.E. Linux 7.0 - S.u.S.E. Linux 6.4 - RedHat Linux 7.1 - RedHat Linux 7.0 - RedHat Linux 6.2 - OpenBSD OpenBSD 2.9 - OpenBSD OpenBSD 2.8 - NetBSD NetBSD 1.5.1 - NetBSD NetBSD 1.5 - MandrakeSoft Linux Mandrake 8.0 - MandrakeSoft Linux Mandrake 7.2 - MandrakeSoft Linux Mandrake 7.1 - HP HP-UX 11.11 - HP HP-UX 11.0 - HP HP-UX 10.20 - FreeBSD FreeBSD 4.2 - FreeBSD FreeBSD 3.5.1 - Digital (Compaq) TRU64/DIGITAL UNIX 5.0 - Digital (Compaq) TRU64/DIGITAL UNIX 4.0g - Digital (Compaq) TRU64/DIGITAL UNIX 4.0f + Debian Linux 2.3 - Caldera eServer 2.3.1 - Caldera eDesktop 2.4 - Caldera OpenLinux 2.4 |
|
From: Dieter S. <dsi...@sq...> - 2001-07-27 14:15:14
|
The short answer is no, you cannot use it. The InnoDB table handler provides transactions in mySQL now however you will still have to rewrite many queries to get the same result. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Fri, 27 Jul 2001, Kristofer Wolff wrote: > Hi folks, > > this is my first entry in the list. I have a question about the database. in > germany (think in uk ans USA too) the webspace hostings have only mysql for > there coustomer. My intranet too. > Is it posible to run the ledger on mysql, and what have i do to change the > code ? > > > |
|
From: <ro...@su...> - 2001-07-27 12:48:22
|
> Hi folks, > > this is my first entry in the list. I have a question about the > database. in germany (think in uk ans USA too) the webspace hostings > have only mysql for there coustomer. My intranet too. > Is it posible to run the ledger on mysql, and what have i do to change > the code ? According to the FAQ (http://www.sql-ledger.org/misc/faq.html) the answer is no. I think most ISPs overlook postgres out of ignorance. What you might do is install and run it under your own userid and process space, and then perhaps show your ISP how easy it is for them to do it. -- Rod http://www.sunsetsystems.com/ |
|
From: Kristofer W. <kw...@in...> - 2001-07-27 08:14:26
|
Hi folks, this is my first entry in the list. I have a question about the database. in germany (think in uk ans USA too) the webspace hostings have only mysql for there coustomer. My intranet too. Is it posible to run the ledger on mysql, and what have i do to change the code ? |
|
From: Steve D. <sd...@sw...> - 2001-07-27 03:34:39
|
Keld J=F8rn Simonsen wrote: > Maybe we should make a script to detect if there are any problems i= n the > installation, and then report ways to remedy them > > keld This is a really good idea, but neither Keld nor I has much time to w= ork on something like this. I hacked this script together (quickly) from th= e zelerate/allcommerce project (http://allcommerce.sourceforge.net/), w= hich will check for valid drivers and available databases. It's based on their= configure.pl, which checks for drivers/dbs, allows db port/document root to be set,= and can write Apache's config for you. Not much on remedies, but it might help you narrow down the problem. = Maybe somebody else can hack zelerate's configuration script more completel= y for sql-ledger. If perl isn't there it won't run. If dbi is missing, you'll get a pa= ckage not available error. If the Pg driver is not available it will tell you.= If Postgres is installed and everything else is ok, you should get at least templ= ate1 as a db available. If you get no database available, postgres isn't installe= d. save the attached script and run it from where it's located like this= : bash-2.03$ perl dbi_check.pl Drivers available - Pg Databases Available: dbi:Pg:dbname=3Ddemo dbi:Pg:dbname=3Dosallcommerce dbi:Pg:dbname=3Dsqltest dbi:Pg:dbname=3Dtemplate1 |
|
From: Roderick A. A. <raa...@ti...> - 2001-07-26 17:55:13
|
On Thu, 26 Jul 2001, Wayne wrote:
> Dieter Simader wrote:
>
> >
> > You can also check if everything is working by using dnhttpd. cd to the
> > dnhttpd/exec directory and start the private web server (type in ./dnhttpd
>
> Thanks Dieter, this worked. Can anyone recommend a good book
> for Apache?
"Apache Server Bible", Mohammed J. Kabir, IDG Books
"Apache Server Administrator's Handbook", Mohammed J. Kabir, IDB Books
"Webmaster in A Nutshell", Stephen Spainhour & Robert Eckstein, O'Reilly
> I would also like to get sql-ledger to play nice with Apache.
Since Apache is the default webserver for many UNIX/Linux distributions
it should play nice and does.
Plays very nice with Apache for me. I even installed it in a
different location, tweaked the httpd.conf file, and away it ran.
Cheers,
Rod
--
Remove the word 'try' from your vocabulary ...
Don't try. Do it or don't do it ...
Steers try!
Don Aslett
|
|
From: John S. <js...@im...> - 2001-07-26 16:36:24
|
>Thanks Dieter, this worked. Can anyone recommend a good book >for Apache? There is plenty of superb material (faqs, documentation, etc.) for apache on their web site, starting at http://httpd.apache.org/. There is also such a thing as the Apache Support Webring (you can look up http://nav.webring.yahoo.com/hub?ring=apachesupport&id=13&hub) with tons more stuff. If you really want a book ... then wander over to http://www.oreilly.com/catalog/apache2/. There are a couple of books you may find interesting if you're going to make *heavy* use of apache. These guys publish some really good books! >I would also like to get sql-ledger to play nice with Apache. However, if you're already running dnhttpd satisfactorily you could forgo apache entirely. dnhttpd is more light-weight and come with the added advantage of not having to fiddle with an existing apache installation. Most linux and *bsd installations will have a running apache anyway, so just name your poison ... You shouldn't have *any* trouble at all getting either web server to work, Dieter's instructions are quite clear, just be careful and make sure to go through each step. Cheers, John Stoddart Caracas - Venezuela |
|
From: Wayne <inf...@pi...> - 2001-07-26 14:08:44
|
Dieter Simader wrote: > > You can also check if everything is working by using dnhttpd. cd to the > dnhttpd/exec directory and start the private web server (type in ./dnhttpd Thanks Dieter, this worked. Can anyone recommend a good book for Apache? I would also like to get sql-ledger to play nice with Apache. Thanks for all the replys. Wayne > > on the command line). Then type in http://127.0.0.1:8000/login.pl into > your web browser. To load the administration module type in > http://127.0.0.1:8000/admin.pl |
|
From: Dieter S. <dsi...@sq...> - 2001-07-25 19:41:14
|
The user form is for company information and to enter database information. The Database section can be challenging if you do not know anything about SQL servers. A good place to look for explainations is the FAQ and the screen shots page. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Wed, 25 Jul 2001, Christopher Snow wrote: > I am trying to figure out what all the fields mean on the user forms, but > its taking me a long time by trial and error. Are there any plans to > provide any user documentation? ...Can I help? > > Chris Snow > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > |
|
From: Christopher S. <nad...@ho...> - 2001-07-25 19:24:21
|
I am trying to figure out what all the fields mean on the user forms, but its taking me a long time by trial and error. Are there any plans to provide any user documentation? ...Can I help? Chris Snow _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp |
|
From: <ke...@dk...> - 2001-07-25 15:52:18
|
Maybe we should make a script to detect if there are any problems in the installation, and then report ways to remedy them keld On Tue, Jul 24, 2001 at 11:57:25PM -0500, Steve Doerr wrote: > I hope this helps those having problems. Fact is, it's not real easy to tell > what someone may have done wrong, but I think if all of the below works, you > should be set. > > Installation and configuration is distribution specific and I'll defer some > things here to source/distro documentation. > > If anyone wants to help fill in the blanks or make this prettier, maybe it > will make a nice troubleshooting guide that could be distributed with the > code. > > If you don't know you're ok on each of these steps, there is no sense going > further, because things won't work. > > Step 1. Are the following programs installed? > 1 - Perl, 5+ (depends on DBI version) > 2 - http server (Apache, dnhttpd, NCSA, httpi, ...) > 3 - SQL Server with transaction support (PostgreSQL 6.5+, ...) > 4 - DBD (DBD-Pg, ...) > 5 - DBI > 6 - Sql-ledger (unpack at DocumentRoot from Step 4.) > > If yes, go to step 2., else, install them and proceed. > > Step 2. Are the required programs running? > issue command: > ps aux > > you should see similar lines to the following in with the rest of the output > USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND > postgres xxx 0.0 0.1 5616 348 ? S Jul15 > 0:04 /usr/lib/postgres > root xxx 0.0 0.7 3720 1384 ? S > Jul15 0:05 /usr/sbin/apache > > If yes, go to step 3., else start them and check your startup scripts if you > want them to start on boot and proceed. > > Step 3. Is postgres configured for tcp/ip connectivity? > issue command: > psql -h 127.0.0.1 -d template1 > > if you get the prompt; > template1=# > you are connected to template1 thru the localhost with tcp/ip - go to step 4. > else > configure postgres for tcp/ip connectivity (see docs), or check that you > haven't removed the localhost from your system (I bellieve all distro's ship > with localhost enabled) and proceed. > > Step 4. Is Apache's httpd.conf configured properly? Adjust for web servers > other than Apache as appropriate. > Main lines (see http://httpd.apache.org/docs/mod/directives.html for more info > on Apache's runtime directives) > > #Tells Apache the VALID DNS server name for your web server (this could also > be "127.0.0.1" or "localhost"). > ServerName www.sql-ledger.com > > #This directive sets the directory from which httpd will serve files. Unless > matched by a directive like Alias, the #server appends the path from the > requested URL > #to the document root to make the path to the document. Example (note NO > trailing /). This points requests for #http://www.sql-ledger.com to > /usr/local/www > DocumentRoot /usr/local/www > > #tells Apache that perl scripts are executables AND to execute them > AddHandler cgi-script .pl > > #opens document root to public and redirects requests for files in sql-ledger/ > to the files #in/usr/local/www/sql-ledger/. The "Directory" should be > Apache's DocumentRoot with sql-ledger appended to #the end (Note NO trailing / > again). > Alias /sql-ledger/ /usr/local/www/sql-ledger/ > <Direcory /usr/local/www/sql-ledger> > Options ExecCGI Includes FollowSymlinks > </Directory> > > Now type in the server name from above into your browser location like below: > http://www.sql-ledger.com > and you should see index.html in your browser, or a directory listing of > DocumentRoot if index.html doesn't exist in that directory. > > If that works, go to step 5, > else correct Apache (or other web server) config and proceed. > > Step 5. Are permissions set correctly? > Sql-Ledger should unpack with the appropriate permissions except you want to > change users as below > > chmod 777 users templates > chmod 666 users/members > > If you've got everything working here step by step, you should be installed > and ready to create the db and visit admin and login per the bottom of the > installation instructions (see http://www.sql-ledger.com/source/readme.txt). > > It seems like most breakdowns are occuring somewhere in these first five > steps, so I hope this helps. > > Please let me know if I've overlooked anything or sql-ledger still doesn't > work if you've gone through these steps. > > Good luck! > Steve > > > |
|
From: Steve D. <sd...@sw...> - 2001-07-25 12:09:12
|
Hi Robert. It seems you're stuck on step 1 :-(.
You don't appear to have the modules (or not in the right place) for the CPAN approach.
"Dr. Robert J. Meier" wrote:
> Steve,
>
> Thank you for the install problems flowchart. It arrived too late for me
> to run it tonight, but I will try it tomorrow.
>
> How can I complete an upgrade to perl-5.6.1 started by CPAN?
>
> The current status is that I have been trying to install DBD-Pg. Installation
> from an rpm package (0.73) was accomplished with apparent success, but only
> changed the details of the error. Subsequently, as advised by others, I
> tried to use CPAN to install DBD::Pg. CPAN upgraded my installed perl from
> 5.5.3 to 5.6.1, but any attempts to make, test, or install other bundles
> now reports
I don't know if rpm's and cpan will play together very well. I know some manual installs don't
work well with Debian packages, but I can't speak for RedHat on this.
Personally, I would try to be consistent and stick with the rpm's.
Everything needed should be available as rpm's. You may want to follow the red hat install notes
per the faq (just the perl steps 2 and 6-13). Note the version dependencies from the rpm's.
It sounds like you were ok on Apache and Postgres.
Try the above and then go through the flow chart and see what happens.
I'll be gone until this evening, but would be curious to hear how this works.
Good luck,
Steve
Redhat 7.0 Installation instructions
Thanks to Jacky Fang who provided the installation instructions.
1.Install apache1.3.12-25.i386.rpm
2.Install perl5.6.0-9.i386.rpm
3.Install postgresql-7.0.2-17.i386.rpm
4.Install postgresql-server-7.0.2-17.i386.rpm
5.Install postgresql-devel-7.0.2-17.i386.rpm (POSTGRES_INCLUDE)
6.tar xvzf DBI-1.14.tar.gz
7.cd DBI-1.14
8.perl Makefile.PL
9.make
10.make install
11.cd ..
12.tar xvzf DBD-Pg-0.95
13.cd DBD-Pg-0.95
14.export POSTGRES_LIB=/usr/lib/pgsql
15.export POSTGRES_INCLUDE=/usr/include/pgsql
16.perl Makefile.PL
17.make
18.make install
19.install SQL-Ledger
Some of the applications have newer version however the installation instructions remain the
same. Just substitute the old version with a newer version.
|
|
From: Wayne <inf...@pi...> - 2001-07-25 10:37:11
|
Dieter Simader wrote: > localhost is setup in > /etc/hosts > 127.0.0.1 localhost.your_domain localhost This looks ok in my /etc/hosts 127.0.0.1 localhost.localdomain localhost > > > to use the hosts file it is specified in host.conf with a 'hosts' line > /etc/host.conf > hosts In my /etc/host.conf I have order hosts,bind Thanks. Wayne |
|
From: Dr. R. J. M. <bo...@ho...> - 2001-07-25 05:18:01
|
Steve,
Thank you for the install problems flowchart. It arrived too late for me
to run it tonight, but I will try it tomorrow.
How can I complete an upgrade to perl-5.6.1 started by CPAN?
The current status is that I have been trying to install DBD-Pg. Installation
from an rpm package (0.73) was accomplished with apparent success, but only
changed the details of the error. Subsequently, as advised by others, I
tried to use CPAN to install DBD::Pg. CPAN upgraded my installed perl from
5.5.3 to 5.6.1, but any attempts to make, test, or install other bundles
now reports
perl: error in loading shared libraries:
/usr/lib/perl5/site_perl/5.005/i586-linux/auto/Storable/Storable.so:
undefined symbol: cast_iv
/usr/lib/perl5/site_perl/5.6.1/i586-linux/auto is empty.
Attempts to make, test, or install Storable produce the error reported above.
This appears to be catch-22. It can't build Storable.so-5.6.1 with
perl-5.6.1 and 5.5.3 libraries. It can't build 5.6.1 libraries without
Storable.so-5.6.1.
perl -V now reports
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=linux, osvers=2.2.13, archname=i586-linux
uname='linux xxxxxx 2.2.13 #1 mon nov 8 15:08:22 cet 1999 i586 unknown ' config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=unde
f
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_S
OURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)',
gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize
=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldbm -ldb -ldl -lm -lc -lposix -lcrypt -lutil
perllibs=-lnsl -ldl -lm -lc -lposix -lcrypt -lutil
libc=, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
/usr/lib/perl5/site_perl/5.6.1/i586-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.005/i586-linux
/usr/lib/perl5/site_perl/5.005
/usr/lib/perl5/site_perl
.
Thanks in advance,
--
Dr. Robert J. Meier
Custom Tools
mailto:rob...@co...
|
|
From: Steve D. <sd...@sw...> - 2001-07-25 03:40:32
|
I hope this helps those having problems. Fact is, it's not real easy to tell what someone may have done wrong, but I think if all of the below works, you should be set. Installation and configuration is distribution specific and I'll defer some things here to source/distro documentation. If anyone wants to help fill in the blanks or make this prettier, maybe it will make a nice troubleshooting guide that could be distributed with the code. If you don't know you're ok on each of these steps, there is no sense going further, because things won't work. Step 1. Are the following programs installed? 1 - Perl, 5+ (depends on DBI version) 2 - http server (Apache, dnhttpd, NCSA, httpi, ...) 3 - SQL Server with transaction support (PostgreSQL 6.5+, ...) 4 - DBD (DBD-Pg, ...) 5 - DBI 6 - Sql-ledger (unpack at DocumentRoot from Step 4.) If yes, go to step 2., else, install them and proceed. Step 2. Are the required programs running? issue command: ps aux you should see similar lines to the following in with the rest of the output USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND postgres xxx 0.0 0.1 5616 348 ? S Jul15 0:04 /usr/lib/postgres root xxx 0.0 0.7 3720 1384 ? S Jul15 0:05 /usr/sbin/apache If yes, go to step 3., else start them and check your startup scripts if you want them to start on boot and proceed. Step 3. Is postgres configured for tcp/ip connectivity? issue command: psql -h 127.0.0.1 -d template1 if you get the prompt; template1=# you are connected to template1 thru the localhost with tcp/ip - go to step 4. else configure postgres for tcp/ip connectivity (see docs), or check that you haven't removed the localhost from your system (I bellieve all distro's ship with localhost enabled) and proceed. Step 4. Is Apache's httpd.conf configured properly? Adjust for web servers other than Apache as appropriate. Main lines (see http://httpd.apache.org/docs/mod/directives.html for more info on Apache's runtime directives) #Tells Apache the VALID DNS server name for your web server (this could also be "127.0.0.1" or "localhost"). ServerName www.sql-ledger.com #This directive sets the directory from which httpd will serve files. Unless matched by a directive like Alias, the #server appends the path from the requested URL #to the document root to make the path to the document. Example (note NO trailing /). This points requests for #http://www.sql-ledger.com to /usr/local/www DocumentRoot /usr/local/www #tells Apache that perl scripts are executables AND to execute them AddHandler cgi-script .pl #opens document root to public and redirects requests for files in sql-ledger/ to the files #in/usr/local/www/sql-ledger/. The "Directory" should be Apache's DocumentRoot with sql-ledger appended to #the end (Note NO trailing / again). Alias /sql-ledger/ /usr/local/www/sql-ledger/ <Direcory /usr/local/www/sql-ledger> Options ExecCGI Includes FollowSymlinks </Directory> Now type in the server name from above into your browser location like below: http://www.sql-ledger.com and you should see index.html in your browser, or a directory listing of DocumentRoot if index.html doesn't exist in that directory. If that works, go to step 5, else correct Apache (or other web server) config and proceed. Step 5. Are permissions set correctly? Sql-Ledger should unpack with the appropriate permissions except you want to change users as below chmod 777 users templates chmod 666 users/members If you've got everything working here step by step, you should be installed and ready to create the db and visit admin and login per the bottom of the installation instructions (see http://www.sql-ledger.com/source/readme.txt). It seems like most breakdowns are occuring somewhere in these first five steps, so I hope this helps. Please let me know if I've overlooked anything or sql-ledger still doesn't work if you've gone through these steps. Good luck! Steve |
|
From: Dieter S. <dsi...@sq...> - 2001-07-24 23:07:37
|
localhost is setup in /etc/hosts 127.0.0.1 localhost.your_domain localhost to use the hosts file it is specified in host.conf with a 'hosts' line /etc/host.conf hosts Netscape tries (www.) host (.com|.org) if it can't find a matching name. This is why you are getting www.localhost.com when you enter localhost. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Tue, 24 Jul 2001, Wayne wrote: > Dieter Simader wrote: > > > localhost should resolve to localhost.your_domain not localhost.com unless > > of course you own localhost.com > > I don't have a DNS yet, so my domain, I beleave, is localdomain. > > > > > > > What you are actually doing is requesting the login.pl script from > > the server running at www.localhost.com. > > Can you tell me how I'm doing this, so that I can stop doing it. > > > > > > > Also check if you have a 'AddHandler cgi-script .pl' line in your > > httpd.conf file. htdoc is not normally setup to process perl scripts. > > I put this in according to the set-up instruction of sql-ledger. > The place of the AddHandler cgi-script.pl was at the end of > httpd.conf. As I learn more I'll put them where they should > be. > > > > > > > You can also check if everything is working by using dnhttpd. cd to the > > dnhttpd/exec directory and start the private web server (type in ./dnhttpd > > on the command line). Then type in http://127.0.0.1:8000/login.pl into > > your web browser. To load the administration module type in > > http://127.0.0.1:8000/admin.pl > > If dnhttpd is a directory, then I don't have one. This is accorden to > the find command. > Thanks for your time. > Wayne > > > > > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > > DWS Systems Inc. Accounting Software Fax: 478-5281 > > =========== On a clear disk you can seek forever =========== > > > > On Tue, 24 Jul 2001, Wayne wrote: > > > > > If I cd into /usr/local/Apache/htdoc and enter the command > > > "netscape index.html.en ", the page that comes up > > > informs me that apache is installed okay. As for the > > > running of apache, the ps -ax command informs > > > me that the httpd is running. > > > What next? > > > Wayne > > > > > > > > > Richard Eicher II wrote: > > > > > > > Your web server is not running or installed. > > > > > > > > Rick > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Make international calls for as low as $.04/minute with Yahoo! Messenger > > > > http://phonecard.yahoo.com/ > > > > > > > > > > |
|
From: Wayne <inf...@pi...> - 2001-07-24 22:44:02
|
Dieter Simader wrote: > > You can also check if everything is working by using dnhttpd. cd to the > dnhttpd/exec directory and start the private web server (type in ./dnhttpd > on the command line). Then type in http://127.0.0.1:8000/login.pl into > your web browser. To load the administration module type in > http://127.0.0.1:8000/admin.pl > After I sent my last reply I relize what dnhttpd was. This would completely by pass Apache. Is that correct? My problem with Apache would not be solved. What is your thinking in starting dnhttpd? Wayne |
|
From: Wayne <inf...@pi...> - 2001-07-24 22:38:52
|
Dieter Simader wrote: > localhost should resolve to localhost.your_domain not localhost.com unless > of course you own localhost.com I don't have a DNS yet, so my domain, I beleave, is localdomain. > > > What you are actually doing is requesting the login.pl script from > the server running at www.localhost.com. Can you tell me how I'm doing this, so that I can stop doing it. > > > Also check if you have a 'AddHandler cgi-script .pl' line in your > httpd.conf file. htdoc is not normally setup to process perl scripts. I put this in according to the set-up instruction of sql-ledger. The place of the AddHandler cgi-script.pl was at the end of httpd.conf. As I learn more I'll put them where they should be. > > > You can also check if everything is working by using dnhttpd. cd to the > dnhttpd/exec directory and start the private web server (type in ./dnhttpd > on the command line). Then type in http://127.0.0.1:8000/login.pl into > your web browser. To load the administration module type in > http://127.0.0.1:8000/admin.pl If dnhttpd is a directory, then I don't have one. This is accorden to the find command. Thanks for your time. Wayne > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Tue, 24 Jul 2001, Wayne wrote: > > > If I cd into /usr/local/Apache/htdoc and enter the command > > "netscape index.html.en ", the page that comes up > > informs me that apache is installed okay. As for the > > running of apache, the ps -ax command informs > > me that the httpd is running. > > What next? > > Wayne > > > > > > Richard Eicher II wrote: > > > > > Your web server is not running or installed. > > > > > > Rick > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Make international calls for as low as $.04/minute with Yahoo! Messenger > > > http://phonecard.yahoo.com/ > > > > > > |
|
From: Dieter S. <dsi...@sq...> - 2001-07-24 21:56:49
|
localhost should resolve to localhost.your_domain not localhost.com unless of course you own localhost.com What you are actually doing is requesting the login.pl script from the server running at www.localhost.com. Also check if you have a 'AddHandler cgi-script .pl' line in your httpd.conf file. htdoc is not normally setup to process perl scripts. You can also check if everything is working by using dnhttpd. cd to the dnhttpd/exec directory and start the private web server (type in ./dnhttpd on the command line). Then type in http://127.0.0.1:8000/login.pl into your web browser. To load the administration module type in http://127.0.0.1:8000/admin.pl Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Tue, 24 Jul 2001, Wayne wrote: > If I cd into /usr/local/Apache/htdoc and enter the command > "netscape index.html.en ", the page that comes up > informs me that apache is installed okay. As for the > running of apache, the ps -ax command informs > me that the httpd is running. > What next? > Wayne > > > Richard Eicher II wrote: > > > Your web server is not running or installed. > > > > Rick > > > > __________________________________________________ > > Do You Yahoo!? > > Make international calls for as low as $.04/minute with Yahoo! Messenger > > http://phonecard.yahoo.com/ > > > |
|
From: Wayne <inf...@pi...> - 2001-07-24 20:52:05
|
Brian Johnson wrote: > OK - we think that you have Apache and PostgreSQL. > It sounds like PostgreSQL is running but not Apache > > Find the file apachectl (on my machine it's under /usr/local/apache/bin and also > under /usr/bin) > > Type ./apachectl start When I enter this command I got back "apache is already running" > > > That should start Apache - it should say something like "httpd started" > > Now try http://localhost/index.html.en and tell us if it displays a page The results from this was NOT FOUND - the reguested URL /usr/local/Apache/htdoc/index.html.en was not found on this server followed by Apache 1.3.14 server www.localhost.com Port 80 Thanks again for the help Wayne > > > My guess is that we will next have to make sure that you have the correct modules > installed > > Did you modify httpd.conf? > > Wayne (inf...@pi...) wrote: > > > >If I cd into /usr/local/Apache/htdoc and enter the command > >"netscape index.html.en ", the page that comes up > >informs me that apache is installed okay. As for the > >running of apache, the ps -ax command informs > >me that the httpd is running. > >What next? > >Wayne > >Richard Eicher II wrote: > >> Your web server is not running or installed. > >> > >> Rick > >> > >> __________________________________________________ > >> Do You Yahoo!? > >> Make international calls for as low as $.04/minute with Yahoo! Messenger > >> http://phonecard.yahoo.com/ |
|
From: Rod R. <ro...@su...> - 2001-07-24 20:05:09
|
Wayne wrote:
> If I cd into /usr/local/Apache/htdoc and enter the command
> "netscape index.html.en ", the page that comes up
> informs me that apache is installed okay.
That's just going to run netscape on a local file. The web
server would not be involved.
> As for the
> running of apache, the ps -ax command informs
> me that the httpd is running.
> What next?
It may be that apache is not configured to listen to localhost.
Check your httpd.conf to see if it's only binding to the external
IP address, or to a nonstandard port number.
-- Rod
http://www.sunsetsystems.com/
|
244 messages has been excluded from this view by a project administrator.
