sql-ledger-users

[SL] Re: setup on OS X

[Johnnie T. <jl...@ma...>]

On May 21, 2004, at 14:19, Johnnie Turner wrote:

> Hello:
> Trying to setup sql-ledger  on latest OS X
> Error: at /admin.pl    and login.pl
>  You don't have permission to access /sql-ledger/admin.pl on this 
> server
>
> I have followed the instructions, line by line of Paul Teeter
> very detailed how-to file, but can not seem to find the problem
>
> I set the ownership to www:www on ALL files at this point
> and added to
>
> Also: setup.pl does not work as I get an error of:
> 	 NO LWP
>
> ANY pointers would be thanked.
>
> Regards,
> John Turner
>
>
Found the problem was bad thinking on my part.

I had sql-ledger installed on a SuSE 9.1 machine
and dumped my database file from the Linux machine
and loaded it into postgresQL on the OS X machine

However, I tried to log on as my old user and had
not gone through the sql-ledger admin setup of users
and databases.

The error given in the error_log
/var/log/httpd/error_log

"Compilation failed in require at 
/Library/WebServer/Documents/sql-ledger/login.pl line 90.
Error: users/members : No such file or directory"

Of course that was a different message as reported in the Apache screen.

Also found that by default, /etc/httpd/httpd.conf looks in the 
directory /etc/httpd/users for that
sql-ledger-httpd.config
Therefore I just used the instructions per sql-ledger's README file
and did not have to edit httpd.conf

I'm a Happy camper -- now ready to find out if this thing will do the 
job for me.

Regards,
John Turner

[SL] (no subject)

[dhs <dh...@li...>]

I have read several mails reporting the use of SQL-Ledger for ISP Billing. We are  
considering the use SL as billing sistem for an ISP. The ISP will offer  
several plans: Prepaid, postpaid, montly rates and based on consume (time or  
bandwith). 
 
We plan to interface bandwith-accounting with user authentication and billing  
system.  Has anybody made experiences in this area? 
 
Thanks for your comments 
 
Enrique 
 
--  
CaribeNet S.A. - Cartagena - Colombia 
        www.caribenet.com 
 
www.caribenet.com 
-- 
______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org 
This allows you to send and receive SMS through your mailbox.


Powered by Outblaze

[SL] (no subject)

[<te...@fr...>]

Hi,

I was running sql-ledger 2.2.1 on red hat 9. Then I upgraded to fedora
core 3 and sql-ledger 2.4.7.

Now there's a server error when I'm trying to log in, and the httpd
errorlog says:

[Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Unknown error,
referer: http://aksel/sql-ledger/admin.pl
[Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Compilation failed
in require at /opt/sql-ledger/admin.pl line 91., referer:
http://aksel/sql-ledger/admin.pl
[Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Premature end of
script headers: admin.pl, referer: http://aksel/sql-ledger/admin.

Could somebody help me please?

Kind regards

Uffe A. Fredens

Re: [SL] (no subject)

[James P. K. I. <jk...@lo...>]

On Wed, 2005-01-26 at 13:53 +0100, te...@fr... wrote:
> Hi,
>=20
> I was running sql-ledger 2.2.1 on red hat 9. Then I upgraded to fedora
> core 3 and sql-ledger 2.4.7.
>=20
> Now there's a server error when I'm trying to log in, and the httpd
> errorlog says:
>=20
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Unknown error,
> referer: http://aksel/sql-ledger/admin.pl
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Compilation failed
> in require at /opt/sql-ledger/admin.pl line 91., referer:
> http://aksel/sql-ledger/admin.pl
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Premature end of
> script headers: admin.pl, referer: http://aksel/sql-ledger/admin.
>=20
> Could somebody help me please?

If you check the /var/log/messages file you will see a different error
that is related to the SELinux security settings on Fedora Core 3. FC3
requires a new level of security wizardry to make httpd talk to the
database.=20

The shortcut to hapiness here is to open the security settings wizard
tool and turn off SELinux and then reboot.
>=20
> Kind regards
>=20
> Uffe A. Fredens
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> sql-ledger-users mailing list
> sql...@sq...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20
>=20
> !DSPAM:41f7bc0116371399514773!
--=20
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jk...@lo...>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7

Re: [SL] (no subject)

[Antonio G. <aga...@ag...>]

Hi:

Some advises:

1-Did you followed the updates procedures from SQL-Ledger 2.2.1 to 2.4.7?
2-The sql-ledger.conf changed, please check the new values in the default=
.
3.Review you have DBD-Pg and DBI installed. Perhaps you will need to
update them.

Best Regards,

Antonio Gallardo



On Mie, 26 de Enero de 2005, 6:53, te...@fr... dijo:
> Hi,
>
> I was running sql-ledger 2.2.1 on red hat 9. Then I upgraded to fedora
> core 3 and sql-ledger 2.4.7.
>
> Now there's a server error when I'm trying to log in, and the httpd
> errorlog says:
>
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Unknown error,
> referer: http://aksel/sql-ledger/admin.pl
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Compilation faile=
d
> in require at /opt/sql-ledger/admin.pl line 91., referer:
> http://aksel/sql-ledger/admin.pl
> [Wed Jan 26 13:06:49 2005] [error] [client 127.0.0.1] Premature end of
> script headers: admin.pl, referer: http://aksel/sql-ledger/admin.
>
> Could somebody help me please?
>
> Kind regards
>
> Uffe A. Fredens
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> sql-ledger-users mailing list
> sql...@sq...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] (no subject)

[Scott A. <Sc...@Un...>]

Hi,

=20

I've been using QuickBooks for 5 years so it is hard to cut the cord so
for the time being I would like to operate my business using SQL-Ledger
but still pass all the financial data back to QuickBooks. I know some
people may advise against this but I really feel like a slower
transition would be better for me. I also have the QB automatic payroll,
etc which would be very difficult for me to give up. Has anyone done
this before? Is it possible and\or practical to link the two? Can I
export the financials in QB to SL and vice versa? If you have done this
before, can you shed a little light? Thanks in advance.

=20

Scott

=20

=20

[SL] (no subject)

[Colin R. <du...@ha...>]

Greetings all,
I just installed 2.6.1 (via setup.pl) and got it up and running. It's on
a FreeBSD server in the house, which also handles mail etc, so the box
is visible to the world.
---------------------------

Side note:
A most useful general tip BTW, is to *additionally* password protect the
entire sql-ledger directory using .htaccess.
 
More information on .htaccess protection, and how to implement it, can
be found here:
http://www.freewebmasterhelp.com/tutorials/htaccess/1

And additional reading here:
http://www.apacheweek.com/features/userauth

---------------------------

OK my question concerns "datasets". In my scenario I intend to create a
valid company db *and* a test company. The purpose of the test company
is to create a valid environment to test stuff without risking actual
company data.

(I assume "dataset" in our context refers to a db populated with
necessary tables and skeleton data based on preferences)

My problem is that I cannot see how to easily create additional
datasets. 
Should I:
1) create a db first in postgresql admin (webmin in this case) and then
go ahead and attempt to create a dataset? I ask this because I have one
(fairly obvious from the FAQ) user 'sql-ledger'...
Or should I: 
2) create another db_user for the second dataset and *THEN* "Create
Dataset" in admin.pl? 

The README is sort of ambiguous on this point.

Sorry for the exceptionally basic nature of the questions, and TIA for
any advice and suggestions from the gurus. 

Regards,
-Colin

Re: [SL] (no subject)

[James P. K. I. <jk...@lo...>]

You can use the same postgresql user for all datasets. The sql-ledger
user determines which dataset is being accessed.

Create a dataset for your real stuff (called businessname) and then
create a dataset fro the test stuff called businessname-test.

Now create a sql-ledger user that will access businessname and another
to access businessname-test.=20

On Mon, 2005-10-17 at 11:26 +0200, Colin Raven wrote:
> Greetings all,
> I just installed 2.6.1 (via setup.pl) and got it up and running. It's on
> a FreeBSD server in the house, which also handles mail etc, so the box
> is visible to the world.
> ---------------------------
>=20
> Side note:
> A most useful general tip BTW, is to *additionally* password protect the
> entire sql-ledger directory using .htaccess.
> =20
> More information on .htaccess protection, and how to implement it, can
> be found here:
> http://www.freewebmasterhelp.com/tutorials/htaccess/1
>=20
> And additional reading here:
> http://www.apacheweek.com/features/userauth
>=20
> ---------------------------
>=20
> OK my question concerns "datasets". In my scenario I intend to create a
> valid company db *and* a test company. The purpose of the test company
> is to create a valid environment to test stuff without risking actual
> company data.
>=20
> (I assume "dataset" in our context refers to a db populated with
> necessary tables and skeleton data based on preferences)
>=20
> My problem is that I cannot see how to easily create additional
> datasets.=20
> Should I:
> 1) create a db first in postgresql admin (webmin in this case) and then
> go ahead and attempt to create a dataset? I ask this because I have one
> (fairly obvious from the FAQ) user 'sql-ledger'...
> Or should I:=20
> 2) create another db_user for the second dataset and *THEN* "Create
> Dataset" in admin.pl?=20
>=20
> The README is sort of ambiguous on this point.
>=20
> Sorry for the exceptionally basic nature of the questions, and TIA for
> any advice and suggestions from the gurus.=20
>=20
> Regards,
> -Colin
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--=20
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jk...@lo...>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7

Re: [SL] (no subject)

[Hugh E. <he...@re...>]

And more to the point of your question I think, once you have created the pg user sql-ledger and given it the ability to create databases, you can handle all the other steps from within the sql-ledger browser admin.pl interface.  SL users are distinct from postgres users are distinct from system users.  An SL user is associated with one and only one SL dataset.  

-- Hugh 

On Mon, 17 Oct 2005 11:08:38 -0400
"James P. Kinney III" <jk...@lo...> wrote:

> You can use the same postgresql user for all datasets. The sql-ledger
> user determines which dataset is being accessed.
> 
> Create a dataset for your real stuff (called businessname) and then
> create a dataset fro the test stuff called businessname-test.
> 
> Now create a sql-ledger user that will access businessname and another
> to access businessname-test. 
> 
> On Mon, 2005-10-17 at 11:26 +0200, Colin Raven wrote:
> > Greetings all,
> > I just installed 2.6.1 (via setup.pl) and got it up and running. It's on
> > a FreeBSD server in the house, which also handles mail etc, so the box
> > is visible to the world.
> > ---------------------------
> > 
> > Side note:
> > A most useful general tip BTW, is to *additionally* password protect the
> > entire sql-ledger directory using .htaccess.
> >  
> > More information on .htaccess protection, and how to implement it, can
> > be found here:
> > http://www.freewebmasterhelp.com/tutorials/htaccess/1
> > 
> > And additional reading here:
> > http://www.apacheweek.com/features/userauth
> > 
> > ---------------------------
> > 
> > OK my question concerns "datasets". In my scenario I intend to create a
> > valid company db *and* a test company. The purpose of the test company
> > is to create a valid environment to test stuff without risking actual
> > company data.
> > 
> > (I assume "dataset" in our context refers to a db populated with
> > necessary tables and skeleton data based on preferences)
> > 
> > My problem is that I cannot see how to easily create additional
> > datasets. 
> > Should I:
> > 1) create a db first in postgresql admin (webmin in this case) and then
> > go ahead and attempt to create a dataset? I ask this because I have one
> > (fairly obvious from the FAQ) user 'sql-ledger'...
> > Or should I: 
> > 2) create another db_user for the second dataset and *THEN* "Create
> > Dataset" in admin.pl? 
> > 
> > The README is sort of ambiguous on this point.
> > 
> > Sorry for the exceptionally basic nature of the questions, and TIA for
> > any advice and suggestions from the gurus. 
> > 
> > Regards,
> > -Colin
> > 
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by:
> > Power Architecture Resource Center: Free content, downloads, discussions,
> > and more. http://solutions.newsforge.com/ibmarch.tmpl
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> -- 
> James P. Kinney III          \Changing the mobile computing world/
> CEO & Director of Engineering \          one Linux user         /
> Local Net Solutions,LLC        \           at a time.          /
> 770-493-8244                    \.___________________________./
> http://www.localnetsolutions.com
> 
> GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
> <jk...@lo...>
> Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
> 


-- 
--
Hugh Esco 
250-352-9361
he...@re...
RCK Computer Services 
http://reclaimedcomputers.ca/

[SL] (no subject)

[Bob H. <bo...@fr...>]

I'm running Version 2.6.7 on CentOS 4.2 on a secure VPS connection to the=
 host.

How can I set printing to ONLY print to PDF's? (NO way to hook up a printer=
 locally as Server is not in our office.)

Thanks in advance for your expert response!  :)

Re: [SL] (no subject)

[Jason S. <ja...@de...>]

On Wednesday 03 May 2006 01:00, Bob Holden wrote:
> I'm running Version 2.6.7 on CentOS 4.2 on a secure VPS connection to the
> host.
>
> How can I set printing to ONLY print to PDF's? (NO way to hook up a print=
er
> locally as Server is not in our office.)
>
> Thanks in advance for your expert response!  :)
>
>

In a previous question I posted here, where I was looking to make PDF the=20
default print option that showed up on each screen,  Joseph Toon gave the=20
following response:

=2D--------------------
You can change this by editing the source. To do this for the invoice scree=
n,=20
do the following:

1. Edit sql-ledger/bin/mozilla/is.pl
2. Comment line 187 (add a # at the beginning):
=A0 =A0 =A0 =A0 =A0$form->{format} =3D "postscript" if $myconfig{printer};
3. Insert a line with the following:
=A0 =A0 =A0 =A0 =A0$form->{format} =3D "pdf";

Save and test. This should now make pdf the default for the invoicing scree=
n.=20
Other files you may want to do the same change are: aa.pl (ar/ap), jc.pl (j=
ob=20
costing), oe.pl (quotations)
=2D-------------------

This will not make PDF printing the ONLY option available, just the default.


=2D-=20
Jason Shein
Director of Networking, Operations and Systems
Detached Networks
ja...@de...
( 905 ) - 876 - 4158 Voice
( 905 ) - 876 - 5817 Mobile
http://www.detachednetworks.ca
On-Site Computer Services - Available 24/7

Earn your service for FREE! Ask about our referral program.

Re: [SL] (no subject)

[Luke <sl...@li...>]

You might consider using a local machine as a print server running cups 
server, and the remote server printing to it running cups client.  That 
would work using IPP.

Just a thought.

 On Tue, 2 May 2006, Bob Holden wrote:

> I'm running Version 2.6.7 on CentOS 4.2 on a secure VPS connection to the host.
> 
> How can I set printing to ONLY print to PDF's? (NO way to hook up a printer locally as Server is not in our office.)
> 
> Thanks in advance for your expert response!  :)
> 

[SL] (no subject)

[Kevin B. <ke...@st...>]

Has anyone had any success integrating the SL-POS patch into SL 2.6.9? The 
files 
seem very different from the 2.4.12 build of SL that they were built 
against. 
SL-POS does not yet support 2.6.9, and I tried downloading version 2.4.12 
from 
like 4 different places on the web, but all had many of the perl files in 
the 
rool of sql-ledger with nothing in them except the first line specifying 
where 
perl is located, even the admin.pl file, so I cant even instal that version 
to 
try and run the patch against. I am particularly interested in the support 
for 
cash drawers, invoice printers and barcode stuff which is why I'm looking at 
the 
SL-POS package since I cant find anything out there. Thanks to all in 
advance.


Kevin Bednar
Systems Support
Stockwell Design Group
http://www.stockwelldesigngroup.com

RE: [SL] (no subject)

[Paul T. <pt...@wa...>]

SQL-Ledger has a decent POS since 2.4, so i guess no upgrade from SL-POS =
is
to be expected.

Have you tried current SQL Ledger?

=20

I use POS and barcode scanner without problems, and had not yet heard =
about
SL-POS.

=20

No pole display or cash drawer that I know of, but that would be fairly
simple to include if wanted or needed.

Maybe even copy paste from the mentioned SL-POS?

=20

=20

-----Oorspronkelijk bericht-----
Van: sql...@li...
[mailto:sql...@li...] Namens Kevin =
Bednar
Verzonden: woensdag 3 mei 2006 17:04
Aan: sql...@li...
Onderwerp: [SL] (no subject)

=20

Has anyone had any success integrating the SL-POS patch into SL 2.6.9? =
The
files=20
seem very different from the 2.4.12 build of SL that they were built
against.=20
SL-POS does not yet support 2.6.9, and I tried downloading version =
2.4.12
from=20
like 4 different places on the web, but all had many of the perl files =
in
the=20
rool of sql-ledger with nothing in them except the first line specifying
where=20
perl is located, even the admin.pl file, so I cant even instal that =
version
to=20
try and run the patch against. I am particularly interested in the =
support
for=20
cash drawers, invoice printers and barcode stuff which is why I'm =
looking at
the=20
SL-POS package since I cant find anything out there. Thanks to all in
advance.


Kevin Bednar
Systems Support
Stockwell Design Group
http://www.stockwelldesigngroup.com

RE: [SL] (no subject)

[Kevin B. <ke...@st...>]

I'll check it out and see how I make out. :)

Kevin Bednar
Systems Support
Stockwell Design Group
http://www.stockwelldesigngroup.com


-----Original Message-----
From: "Paul Tammes" <pt...@wa...>
To: <sql...@li...>
Date: Wed, 3 May 2006 18:40:59 +0200
Subject: RE: [SL] (no subject)


SQL-Ledger has a decent POS since 2.4, so i guess no upgrade from SL-POS is 
to be expected.
Have you tried current SQL Ledger?
 
I use POS and barcode scanner without problems, and had not yet heard about 
SL-POS.
 
No pole display or cash drawer that I know of, but that would be fairly 
simple to include if wanted or needed.
Maybe even copy paste from the mentioned SL-POS?
 
 
-----Oorspronkelijk bericht-----
Van: sql...@li... 
[mailto:sql...@li...] Namens Kevin Bednar
Verzonden: woensdag 3 mei 2006 17:04
Aan: sql...@li...
Onderwerp: [SL] (no subject)
 
Has anyone had any success integrating the SL-POS patch into SL 2.6.9? The 
files 
seem very different from the 2.4.12 build of SL that they were built 
against. 
SL-POS does not yet support 2.6.9, and I tried downloading version 2.4.12 
from 
like 4 different places on the web, but all had many of the perl files in 
the 
rool of sql-ledger with nothing in them except the first line specifying 
where 
perl is located, even the admin.pl file, so I cant even instal that version 
to 
try and run the patch against. I am particularly interested in the support 
for 
cash drawers, invoice printers and barcode stuff which is why I'm looking at 
the 
SL-POS package since I cant find anything out there. Thanks to all in 
advance.


Kevin Bednar
Systems Support
Stockwell Design Group
http://www.stockwelldesigngroup.com

[SL] (no subject)

[Ing. R. G. T. <rg...@so...>]

I'm protected by SpamBrave
http://www.spambrave.com/

[SL] (no subject)

[<bou...@ya...>]

http://evasionclubprive.com/572_2.html


      

[SL] (no subject)

[<bou...@ya...>]

http://www.noipasticcieri.it/572_2.html


      

[SL] (no subject)

[Walter L&#xF3;p. <wal...@ya...>]

http://graphique-com.fr/level/65Online%20business%20is%20the%20first%20step%20to%20become%20successful843