Menu
▾
▴
sql-ledger-users
|
From: Lee K. <le...@ki...> - 2002-02-12 22:18:28
|
Hi there, Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2? I've followed the default install instructions and chagned httpd.conf to reflect the SQL Ledger-preferred document root of /usr/local/www but no luck. The first sign of trouble is that when I hit http://localhost/sql-ledger/admin.pl I get "file not found". In fact the file is there. What would help me a lot would be a guide to troubleshooting SQL-Ledger's perl scripts. Something with some diagnostic tests and an analysis of their results. I saw that somebody in the mailing list had planned to write a SQL-Ledger FAQ but couldn't find the actual document. Anybody gone down this SQL-Ledger on Red Hat path before and emerged scathed but knowledgeable? Thanks Lee |
|
From: Joe M. <jam...@hw...> - 2002-02-12 22:35:53
|
I got it running with out any problems. As long as your permissions are correct and apache is setup to run perl scripts then you should be okay. I found that putting an index.html file in your /sql-ledger directory helps with resolving any path and permission problems. Then just have a link in the index.html file that points to login.pl Good Luck Joe MacDonald On Tue, 2002-02-12 at 13:15, Lee Kimber wrote: > Hi there, > > Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2? > > I've followed the default install instructions and chagned httpd.conf to > reflect the SQL Ledger-preferred document root of /usr/local/www but no luck. > > The first sign of trouble is that when I hit > http://localhost/sql-ledger/admin.pl I get "file not found". In fact the > file is there. > > What would help me a lot would be a guide to troubleshooting SQL-Ledger's > perl scripts. Something with some diagnostic tests and an analysis of their > results. > > I saw that somebody in the mailing list had planned to write a SQL-Ledger > FAQ but couldn't find the actual document. > > Anybody gone down this SQL-Ledger on Red Hat path before and emerged > scathed but knowledgeable? > > Thanks > > Lee > > -- Joe MacDonald jam...@hw... Focus Computer Consulting 250-861-3798 |
|
From: John B. <Jo...@be...> - 2002-02-12 22:46:46
|
I'm currently running SQL Ledger v1.6.9 on Red Hat Linux 7.1, and had
very few problems getting started. There are really very few
differences between 7.1 and 7.2, so it /should/ Just Work(tm).
I'm assuming that admin.pl is located in the physical path
/usr/local/www/sql-ledger/admin.pl, so I'll avoid any path issues. :)
The first thing to check would be the Apache error log
(/var/log/httpd/error_log) and see what the server is telling you when
you see "file not found".
Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my
130 day uptime - I want to beat a friend's 280-some-odd day uptime. :)
Upgrading would involve a reboot, which would start my uptime back at 0
days. :(
On Tue, 12 Feb 2002, Lee Kimber wrote:
> Hi there,
>
> Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?
>
> I've followed the default install instructions and chagned httpd.conf to
> reflect the SQL Ledger-preferred document root of /usr/local/www but no luck.
>
> The first sign of trouble is that when I hit
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the
> file is there.
>
> What would help me a lot would be a guide to troubleshooting SQL-Ledger's
> perl scripts. Something with some diagnostic tests and an analysis of their
> results.
>
> I saw that somebody in the mailing list had planned to write a SQL-Ledger
> FAQ but couldn't find the actual document.
>
> Anybody gone down this SQL-Ledger on Red Hat path before and emerged
> scathed but knowledgeable?
>
> Thanks
>
> Lee
--
John Berninger
GPG Key ID: A8C1D45C
Fingerprint: B1BB 90CB 5314 3113 CF22 66AE 822D 42A8 A8C1 D45C
It is a known fact that developers cannot document. That's why we have
documentation specialists. If developers could document, they'd all be
system administrators!
--
|
|
From: Jonas S. <jo...@jo...> - 2002-02-13 00:27:54
|
On Tue, 12 Feb 2002, John Berninger wrote: > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my > 130 day uptime - I want to beat a friend's 280-some-odd day uptime. :) For the sake of ego: Switch to Debian - then you can upgrade without rebooting ;-) (sorry, this is off-topic, I just had to do it...) - Jonas -- Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ Debian GNU/Linux developer http://people.debian.org/~js/ |
|
From: Joe M. <jam...@hw...> - 2002-02-13 01:13:08
|
You can't upgrade a distro with out rebooting. On Tue, 2002-02-12 at 16:27, Jonas Smedegaard wrote: > On Tue, 12 Feb 2002, John Berninger wrote: > > > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my > > 130 day uptime - I want to beat a friend's 280-some-odd day uptime. :) > > For the sake of ego: Switch to Debian - then you can upgrade without > rebooting ;-) > > (sorry, this is off-topic, I just had to do it...) > > - Jonas > > -- > Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ > Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ > Debian GNU/Linux developer http://people.debian.org/~js/ > > > -- Joe MacDonald jam...@hw... Focus Computer Consulting 250-861-3798 |
|
From: Jake S. <js...@gr...> - 2002-02-13 01:51:48
|
I'm curious too > You can't upgrade a distro with out rebooting. > > > On Tue, 2002-02-12 at 16:27, Jonas Smedegaard wrote: > > On Tue, 12 Feb 2002, John Berninger wrote: > > > > > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my > > > 130 day uptime - I want to beat a friend's 280-some-odd day uptime. :) > > > > For the sake of ego: Switch to Debian - then you can upgrade without > > rebooting ;-) > > > > (sorry, this is off-topic, I just had to do it...) > > > > - Jonas > > > > -- > > Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ > > Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ > > Debian GNU/Linux developer http://people.debian.org/~js/ > > > > > > > -- > Joe MacDonald > jam...@hw... > Focus Computer Consulting > 250-861-3798 Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of The Gribbles Group. Thank You. Whilst every effort has been made to ensure that this e-mail message and any attachments are free from viruses, you should scan this message and any attachments. Under no circumstances do we accept liability for any loss or damage which may result from your receipt of this message or any attachment. |
|
From: Bryan J. S. <b.j...@ie...> - 2002-02-13 02:14:50
|
Jake Skinner wrote: > I'm curious too Er, I've upgraded distros without rebooting before. Use RPM to do a "live" upgrade, including GLibC. The only kicker is the kernel, but that's it. I also wouldn't try upgrading "live" when you're changing the X in X.Y RedHat releases (e.g., 6.2 to 7.0), but the Y in X.Y (e.g., 7.0 to 7.2) has been fine. In fact, I've done this with RedHat 5.x, 6.x and 7.x with fairly good results. -- Bryan -- Bryan J. Smith, Engineer mailto:b.j...@ie... AbsoluteValue Systems, Inc. http://www.linux-wlan.org SmithConcepts, Inc. http://www.SmithConcepts.com --------------------------------------------------------- 1999 IRS Data: The richer half of all US income earners pay 99% of all US taxes |
|
From: Matthew P. <mj...@ie...> - 2002-02-13 01:57:10
|
On 12 Feb 2002, Joe MacDonald wrote: > You can't upgrade a distro with out rebooting. Bull. It's difficult to upgrade a kernel without rebooting, but it's quite simple to upgrade the version of distro you're using without rebooting. > > (sorry, this is off-topic, I just had to do it...) Ditto. -- ----------------------------------------------------------------------- #include <disclaimer.h> Matthew Palmer mj...@ie... |
|
From: Ed W. <ew...@rh...> - 2002-02-12 23:05:22
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
We run SQL Ledger on Redhat 7.2 internally and administer SQL LEdger at
multiple client locations running various flavors/versions of Linux. Best I
can recall, it worked without errors for us once the correct perl modules
were installed (we actually used Redhats included RPMS and didn't download
sources). Redhat 7.2 was one of the easiest installs we have performed
sql-ledger. Not sure what your problem might be, but make sure your web
server and database are running, i.e. ps -aux Make sure you don't have a
firewall blocking the request, use tcpdump on the server to actually monitor
the request and then try to access the server from another machine using the
servers ip address.
This is in our httpd.conf
Alias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
Options ExecCGI Includes FollowSymlinks
</Directory>
Hope this information will get you started. Wish I could offer more
suggestions but don't have enough information to help further.
- --
Ed Wiget
Owner/Senior Network Security Consultant
RHP Studios
"Keeping Your Data Safe!"
http://www.rhpstudios.com
email: ew...@rh...
email2: sec...@rh...
Office: 606-564-0046
Toll Free: 866-G02-RHPS (866-402-7477)
Fax: 606-564-0076
On Tuesday 12 February 2002 04:15 pm, you wrote:
> Hi there,
>
> Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?
>
> I've followed the default install instructions and chagned httpd.conf to
> reflect the SQL Ledger-preferred document root of /usr/local/www but no
> luck.
>
> The first sign of trouble is that when I hit
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the
> file is there.
>
> What would help me a lot would be a guide to troubleshooting SQL-Ledger's
> perl scripts. Something with some diagnostic tests and an analysis of their
> results.
>
> I saw that somebody in the mailing list had planned to write a SQL-Ledger
> FAQ but couldn't find the actual document.
>
> Anybody gone down this SQL-Ledger on Red Hat path before and emerged
> scathed but knowledgeable?
>
> Thanks
>
> Lee
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE8aZ80+EoLKxIs7PwRAg+mAJ4wju30bPdV8KmCP1wGPuLtjR51cwCeLbP9
eadDhLhmWQfGHSAtNbBmNaA=
=m0Ry
-----END PGP SIGNATURE-----
|
|
From: D.Kreft <bi...@kr...> - 2002-02-13 00:10:56
|
On Tue, 12 Feb 2002, Lee Kimber wrote: > The first sign of trouble is that when I hit > http://localhost/sql-ledger/admin.pl I get "file not found". In fact the > file is there. Make sure that the path to perl in your scripts is the same as that listed in the first line of your scripts (on the 'she-bang' line). If you don't have perl in the right place, the shell will say "file not found." -dan |
|
From: Todd E. <te...@ce...> - 2002-02-28 17:37:59
|
I work for a startup which does a lot of subscription billing - $5/month for this feature, cancel that other one but upgrade to the $20 one, pretty soon you're talking about some real money. The problem is that I haven't seen reasonable, inexpensive sofware to handle and track this and the changes. Would it be worth writing an interface to sql-ledger to handle this? Or has someone already done it? Todd |
|
From: Lee K. <lee...@ki...> - 2002-02-13 02:50:59
|
Wow! You folks are amazing! I'm on the Linux Router Project mailing list and even that doesn't produce so many responses so quickly. OK, I've got to fess up to one of those doh moments here. I forgot to put the forward slash before "usr" in one of the httpd.conf lines... However, now that I have done that, hitting http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by a line of black text saying: "Permission denied: users/members" Mmmm, I've run "chown nobody:nobody users templates" and I can see that a user and group called 1000 own most of these files, including admin.pl. If I've understood this correctly, this is the script I need to run to set up users and members so I'm a bit stuck here. Thanks for any ideas. Lee At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote: >I got it running with out any problems. > >As long as your permissions are correct and apache is setup to run perl >scripts then you should be okay. > >I found that putting an index.html file in your /sql-ledger directory >helps with resolving any path and permission problems. Then just have a >link in the index.html file that points to login.pl > >Good Luck > >Joe MacDonald |
|
From: James T. <ja...@ci...> - 2002-02-13 11:11:06
|
What are the permissions of the appropriate files. I found that sql-ledger did this to me. Okay you are but a gnats whisker (do they have whiskers I thought they had probosci) from getting it going. Unfortuantely you are going to have to compromise your security for a while. at the commandline from the sql-ledger directory as the owner or su enter: chmod 777 users/memebers You may have to do this with the directory itself. chmod 777 users and hey presto your security is completely compromised. Also who does apache run as. You MAY find that it is as 'nobody' or 'apache' it is best that you match the two up. or even set it to nobody. after you have you db set up and users made, play with making it the permissions more secure until you break it again. BTW I do not reccomend doing any of this over an unsecured internet connection. Regards James ----- Original Message ----- From: "Lee Kimber" <lee...@ki...> To: "Joe MacDonald" <jam...@hw...>; "Lee Kimber" <le...@ki...> Cc: <sql...@li...> Sent: Wednesday, February 13, 2002 2:00 AM Subject: Re: SQL Ledger on Red Hat anyone? > Wow! You folks are amazing! I'm on the Linux Router Project mailing list > and even that doesn't produce so many responses so quickly. > > OK, I've got to fess up to one of those doh moments here. I forgot to put > the forward slash before "usr" in one of the httpd.conf lines... > > However, now that I have done that, hitting > http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by > a line of black text saying: > > "Permission denied: users/members" > > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a > user and group called 1000 own most of these files, including admin.pl. > > If I've understood this correctly, this is the script I need to run to set > up users and members so I'm a bit stuck here. > > Thanks for any ideas. > > Lee > > At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote: > >I got it running with out any problems. > > > >As long as your permissions are correct and apache is setup to run perl > >scripts then you should be okay. > > > >I found that putting an index.html file in your /sql-ledger directory > >helps with resolving any path and permission problems. Then just have a > >link in the index.html file that points to login.pl > > > >Good Luck > > > >Joe MacDonald > > |
|
From: Ed W. <ew...@rh...> - 2002-02-13 14:04:10
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 on redhat 7.2 it should be apache.apache > > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a > user and group called 1000 own most of these files, including admin.pl. - -- Ed Wiget Owner/Senior Network Security Consultant RHP Studios "Keeping Your Data Safe!" http://www.rhpstudios.com email: ew...@rh... email2: sec...@rh... Office: 606-564-0046 Toll Free: 866-G02-RHPS (866-402-7477) Fax: 606-564-0076 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8anHb+EoLKxIs7PwRAnHMAJ9fJttoRkZJ1jTILR0fVxEqH7Zt+wCeMiDG rb8+lSkw+tzqLlXOgTnGbWw= =iqT9 -----END PGP SIGNATURE----- |
|
From: Lee K. <le...@ki...> - 2002-02-19 05:46:28
|
This turned out to be the answer to my immediate problem. Thanks for that. To summarise installation on Red Hat: You can un tar the source into the default Red Hat html document root - /var/www/html - or into the sql-ledger default - /usr/local/www. You have to set the various sql-ledger changes in httpd.conf to reflect the www directory you *do* eventually choose to un tar the source into. Watch out for the sql-ledger manual instruction to run: # chown nobody:nobody users templates On a Red Hat system, this should read: # chown apache:apache users templates On Red Hat systems, restart apache with: # /etc/rc.d/init.d/httpd restart OK, I still haven't got mine working properly yet but the above was what I needed to do to get the admin.pl Perl script to fire up correctly. I'll add to the above as I get the rest of it going. Thanks to everyone for your help. Lee At 09:01 AM 2/13/2002 -0500, Ed Wiget wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >on redhat 7.2 it should be apache.apache > > > > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a > > user and group called 1000 own most of these files, including admin.pl. |
|
From: Steve D. <sd...@sw...> - 2002-02-13 04:23:08
|
Hi Lee. I believe your /users/members.default file failed to open or generate the new members file. Is the permission on it as follows? -rw-r--r-- 1 nobody nobody 57 Jan 24 20:04 members.default And the users directory? drwx------ 2 nobody nobody 1024 Jan 19 10:53 users That's an sql-ledger error message, so you can execute scripts (at least admin.pl - your in as far as Apache goes). Look at the above file and directory. Good luck, Steve Lee Kimber wrote: > Wow! You folks are amazing! I'm on the Linux Router Project mailing list > and even that doesn't produce so many responses so quickly. > > OK, I've got to fess up to one of those doh moments here. I forgot to put > the forward slash before "usr" in one of the httpd.conf lines... > > However, now that I have done that, hitting > http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by > a line of black text saying: > > "Permission denied: users/members" > > Mmmm, I've run "chown nobody:nobody users templates" and I can see that a > user and group called 1000 own most of these files, including admin.pl. > > If I've understood this correctly, this is the script I need to run to set > up users and members so I'm a bit stuck here. > > Thanks for any ideas. > > Lee > > At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote: > >I got it running with out any problems. > > > >As long as your permissions are correct and apache is setup to run perl > >scripts then you should be okay. > > > >I found that putting an index.html file in your /sql-ledger directory > >helps with resolving any path and permission problems. Then just have a > >link in the index.html file that points to login.pl > > > >Good Luck > > > >Joe MacDonald |
Thanks for helping keep SourceForge clean.
X