sql-ledger-users — SQL-Ledger users

revisions, useful now that stylesheet var is enabled

[Jeff K. <jt...@ad...>]

Thanks for the quick update to enable the stylesheet variables. Here are
a couple of quick improvements that will enable us to write more precise
stylesheets:

1) replace type=submit|checkbox|radio with
class=submit|checkbox|radio type=submit|checkbox|radio

This enables optional "input.checkbox {}" granularity in our
stylesheets.

I ran these replace commands in the bin/mozilla directory and it didn't
seem to introduce any bugs:

replace 'type=radio' 'class=radio type=radio' -- *
replace 'type=submit' 'class=submit type=submit' -- *
replace 'type=checkbox' 'class=checkbox type=checkbox' -- *


2) And not really stylesheet related:
(menu.pl)
FRAME NAME="bottom_menu" SCROLL="no"

Adding the SCROLL="no" removes the unnecessary scroll on the bottom
frame, the text appears too low without it.

Could you work these into the source tree?

Re: =?iso-8859-1?Q?Re:_Error!_No_databae_drivers_available?=

[Roderick A. A. <raa...@ti...>]

On Wed, 22 Aug 2001, [iso-8859-1] Rod Roark wrote:

> > Rod Roark mentioned re-building DBD-Pg.  The new releases of the
> > PostgreSQL RPMs come with perl (and the DBD driver) ready to run. but I
> > did build PostgreSQL from the RPM source before installing.
> 
> Let me try again.  If you upgrade Postgres, then you
> *must* also compile DBD-Pg.  This includes a "make test"
> that you should run and actually look at its results.
> 

I think I found the problem.  The version of DBD-Pg I had installed was
for perl 5.005.  The version of perl installed was 5.6.0 (i386), the
version of PostgreSQL was 7.1 (i686).  Perl wasn't finding the module
because the i686-linux directories weren't in perl's search path.
   I'm down loading the perl RPM and will compile perl for the i686
platform and see how that works with the PostgreSQL i686 DBD-Pg driver.

> You can get the latest DBD-Pg from:
> http://www.perl.com/CPAN-local/modules/by-module/DBD/.
> Check its README file for troubleshooting tips.

Actually the 'almost' latest (1.0 verses 1.01) is included in the
PostgreSQL distribution.


Rod
-- 

Re: Jargon and codes

[Anders W. <aw...@kr...>]

Den 21 Aug 2001 17:52:12 -0400 skrev Kal Kolberg:

> A fairly good tutorial on accounting can be found here
> http://www.onlinewbc.org/Docs/finance/bkpg_s
> Lando


Thanks,

this is good - if you are a accounting rookie. But if you are trying to
move a software from one
context to another, ie from one accounting standard to another, from one
language to another, from one line of business to another. You need
something else.
The key is correct conception and use of terms. A "reference" whould be
helpful to understand the concepts and then how to move SQL-Ledger to a
new context and an existing knowlage.

What is COGS? Is it equivalent to the swedish term "KSV", Kostnad f=F6r
f=F6rS=E5ld Vara? What is SKU? etc. If the term COGS where defined some
where as Cost of Goods Sold it would be a much easier task to understand
this piece of software. In most dictionaries for accountants "Cost of
goods sold" is indexed but not COGS.

Anders

=?iso-8859-1?Q?Re:_Error!_No_databae_drivers_available?=

[<ro...@su...>]

> Rod Roark mentioned re-building DBD-Pg.  The new releases of the
> PostgreSQL RPMs come with perl (and the DBD driver) ready to run. but I
> did build PostgreSQL from the RPM source before installing.

Let me try again.  If you upgrade Postgres, then you
*must* also compile DBD-Pg.  This includes a "make test"
that you should run and actually look at its results.

You can get the latest DBD-Pg from:
http://www.perl.com/CPAN-local/modules/by-module/DBD/.
Check its README file for troubleshooting tips.

Cheers,

-- Rod

Re: Error! No databae drivers available

[Roderick A. A. <raa...@ti...>]

On Tue, 21 Aug 2001, Dieter Simader wrote:

> try this
> 
> perl -e 'use DBI; print join "\n", DBI->available_drivers';
> 
> That should list all the available drivers.

This is what puzzles me.

$ perl -e 'use DBI; print join "\n", DBI->available_drivers'
ADO
ExampleP
Multiplex
Pg
Proxy

By default perl (well the DBI bundle anyway) includes all the above
except Pg.

Rod Roark mentioned re-building DBD-Pg.  The new releases of the
PostgreSQL RPMs come with perl (and the DBD driver) ready to run. but I
did build PostgreSQL from the RPM source before installing.

I'm working on a clean install of RHL7.1 plus errata to determine if
the problem is the upgrade process.


Thanks,
Rod
-- 

=?iso-8859-1?Q?Re:_Error!_No_databae_drivers_available?=

[<ro...@su...>]

Did you rebuild DBD-pg?

-- Rod
http://www.sunsetsystems.com/

> Damn!  I'm havin a heck of a time.  I upgraded my system to RHL 7.1,
> installed PostgreSQL 7.1.3, installed (upgraded) to SQL-Ledger 1.6 and
> now can't get it to work.  I'm trying to get to the admin page and keep
> getting the message in the Subject line.  I know the PostgreSQL driver
> is install and perl can find it because
>
> perl -e 'use DBI::Pg; print join('\n', DBI->available_drivers())';
>
> shows Pg.
>
> The Apache log (error_log) shows
>
> Compilation failed in require at /home/httpd/sql-ledger/admin.pl line
> 89
>
> Any ideas?
>
>
> TIA,
> Rod
> --

Re: Jargon and codes

[Kal K. <lan...@cy...>]

A fairly good tutorial on accounting can be found here
http://www.onlinewbc.org/Docs/finance/bkpg_acct.html#intro

Lando

Dieter Simader wrote:

> In Canada and US you are free to choose the account numbers and
> description to best describe your business. The Default chart of account
> is basically a bare bones chart of accounts.
>
> 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, 20 Aug 2001, Anders Wallenquist wrote:
>
> > Gordon Haverland wrote:
> >
> > >A couple of questions.
> > >
> > >1) Is there a link (reference) to all the jargon used in SQL-Ledger?
> > >   I assume this is accounting jargon, and not SQL-Ledger specific.
> > >   For example, COGS.
> > >
> > I don't know if there is a reference of termes used in SQL-ledger. I
> > think a reference could sort things out, especially for us not used of
> > american/canadian (?) accouting. But COGS is a common accounting term
> > that is spelled out: Cost Of Goods Sold.
> >
> > >
> > >
> > >2) Most of what my company is going to sell can be called consulting,
> > >   and probably most of my expenses will be things like office
> > >   supplies.  I know consulting has a code, and I would be surprise
> > >   if office supplies didn't have a code (or two).  But how does one
> > >   go about finding or picking a code for something else?  I have a
> > >   couple of minor revenue streams, one where I will pass on costs
> > >   (plus a markup) for registering an IP domain and another for passing
> > >   on monthly rents on a IP domain (web site).  To me, this doesn't
> > >   really seem like codes 1530/4030/5030.
> > >
> > There is a accounting standards board for every country, that gives us
> > some differences in accounting principles. You have to check out what
> > conventions there is for the authorities that you are reporting to. (or
> > give us some hint where in the world you are :-)
> >
> > regards
> > Anders Wallenquist
> >
> >
> >

Re: Error! No databae drivers available

[Dieter S. <dsi...@sq...>]

try this

perl -e 'use DBI; print join "\n", DBI->available_drivers';

That should list all the available drivers.


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, 21 Aug 2001, Roderick A. Anderson wrote:

> Damn!  I'm havin a heck of a time.  I upgraded my system to RHL 7.1,
> installed PostgreSQL 7.1.3, installed (upgraded) to SQL-Ledger 1.6 and
> now can't get it to work.  I'm trying to get to the admin page and keep
> getting the message in the Subject line.  I know the PostgreSQL driver
> is install and perl can find it because
> 
>  perl -e 'use DBI::Pg; print join('\n', DBI->available_drivers())';
> 
> shows Pg.
> 
> The Apache log (error_log) shows
> 
>  Compilation failed in require at /home/httpd/sql-ledger/admin.pl line 89
> 
> Any ideas?
> 
> 
> TIA,
> Rod
> 

Error! No databae drivers available

[Roderick A. A. <raa...@ti...>]

Damn!  I'm havin a heck of a time.  I upgraded my system to RHL 7.1,
installed PostgreSQL 7.1.3, installed (upgraded) to SQL-Ledger 1.6 and
now can't get it to work.  I'm trying to get to the admin page and keep
getting the message in the Subject line.  I know the PostgreSQL driver
is install and perl can find it because

 perl -e 'use DBI::Pg; print join('\n', DBI->available_drivers())';

shows Pg.

The Apache log (error_log) shows

 Compilation failed in require at /home/httpd/sql-ledger/admin.pl line 89

Any ideas?


TIA,
Rod
-- 

Re: Jargon and codes

[Dieter S. <dsi...@sq...>]

In Canada and US you are free to choose the account numbers and
description to best describe your business. The Default chart of account
is basically a bare bones chart of accounts.


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, 20 Aug 2001, Anders Wallenquist wrote:

> Gordon Haverland wrote:
> 
> >A couple of questions.
> >
> >1) Is there a link (reference) to all the jargon used in SQL-Ledger?
> >   I assume this is accounting jargon, and not SQL-Ledger specific.
> >   For example, COGS.
> >
> I don't know if there is a reference of termes used in SQL-ledger. I 
> think a reference could sort things out, especially for us not used of 
> american/canadian (?) accouting. But COGS is a common accounting term 
> that is spelled out: Cost Of Goods Sold.
> 
> >
> >
> >2) Most of what my company is going to sell can be called consulting,
> >   and probably most of my expenses will be things like office
> >   supplies.  I know consulting has a code, and I would be surprise
> >   if office supplies didn't have a code (or two).  But how does one
> >   go about finding or picking a code for something else?  I have a
> >   couple of minor revenue streams, one where I will pass on costs
> >   (plus a markup) for registering an IP domain and another for passing
> >   on monthly rents on a IP domain (web site).  To me, this doesn't
> >   really seem like codes 1530/4030/5030.
> >
> There is a accounting standards board for every country, that gives us 
> some differences in accounting principles. You have to check out what 
> conventions there is for the authorities that you are reporting to. (or 
> give us some hint where in the world you are :-)
> 
> regards
> Anders Wallenquist
> 
> 
> 

Re: Stylesheets: setting in user.conf or members should work?

[Dieter S. <dsi...@sq...>]

stylesheets are not implemented yet.

there are a couple of lines of code missing and the stylesheet itself.

I'll make the variables for a stylesheet and charset available in the next
patch level.


the members file is the master file. It is only read in when there
is no conf file or when you make changes.


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 Sun, 19 Aug 2001, Jeff Kowalczyk wrote:

> I have a mycompany.css file in the sql-ledger directory. In the
> myname.conf file, I've edited the line:
> 
> stylesheet => 'mycompany.css',
> 
> and when that didn't work, the line
> 
> stylesheet=mycompany.css
> 
> in members. Neither method yeilds any visible stylesheet substitution;
> e.g. from frame "Accounting Menu":
> 
> <head>
>   <title>Accounting Menu</title>
>   
>   
> </head>
> 
> <body bgcolor="#FBFFE7">
> 
> What am I missing here? Also, in general, why do the .conf and members
> files duplicate information, and which takes precedence? Which is the
> 'master'?
> 
> 
> BTW: A change to bin/mozilla/menu.pl
> <FRAME NAME="bottom_menu" SCROLLING="no" SRC="..."
> elminates the awkward text visibility of the bottom bar. I'm going to go
> through and add CSS class attributes to tables, headers and whatnot over
> the next week. That should make it easier for a CSS file to customize
> the display. 
> 
> What's the preferred method to submit semi-trivial formatting revisions
> to the maintainer for consideration as improvements? 
> 
> 
> 

Re: Multiple users, one database - Last invoice number, etc. are global?

[Dieter S. <dsi...@sq...>]

last numbers are global to each database.

The same number cannot be used again unless you turn back the counter.

Invoice and PO numbers are incremented every time you create an invoice.


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 Sun, 19 Aug 2001, Jeff Kowalczyk wrote:

> I have one sql-ledger database, 'mycompany' and several users set up. I
> did this to control module access, and with the thought that eventually,
> it might be nice to journal the user making entries/edits as additional
> table columns.
> 
> I see the 'last numbers' for invoice and PO in user prefs. Are these
> global to each database, or will two users in the same company have
> number collisions?
> 
> 
> 

Re: Jargon and codes

[Anders W. <aw...@kr...>]

Gordon Haverland wrote:

>A couple of questions.
>
>1) Is there a link (reference) to all the jargon used in SQL-Ledger?
>   I assume this is accounting jargon, and not SQL-Ledger specific.
>   For example, COGS.
>
I don't know if there is a reference of termes used in SQL-ledger. I 
think a reference could sort things out, especially for us not used of 
american/canadian (?) accouting. But COGS is a common accounting term 
that is spelled out: Cost Of Goods Sold.

>
>
>2) Most of what my company is going to sell can be called consulting,
>   and probably most of my expenses will be things like office
>   supplies.  I know consulting has a code, and I would be surprise
>   if office supplies didn't have a code (or two).  But how does one
>   go about finding or picking a code for something else?  I have a
>   couple of minor revenue streams, one where I will pass on costs
>   (plus a markup) for registering an IP domain and another for passing
>   on monthly rents on a IP domain (web site).  To me, this doesn't
>   really seem like codes 1530/4030/5030.
>
There is a accounting standards board for every country, that gives us 
some differences in accounting principles. You have to check out what 
conventions there is for the authorities that you are reporting to. (or 
give us some hint where in the world you are :-)

regards
Anders Wallenquist

Jargon and codes

[Gordon H. <gha...@ma...>]

A couple of questions.

1) Is there a link (reference) to all the jargon used in SQL-Ledger?
   I assume this is accounting jargon, and not SQL-Ledger specific.
   For example, COGS.

2) Most of what my company is going to sell can be called consulting,
   and probably most of my expenses will be things like office
   supplies.  I know consulting has a code, and I would be surprised
   if office supplies didn't have a code (or two).  But how does one
   go about finding or picking a code for something else?  I have a
   couple of minor revenue streams, one where I will pass on costs
   (plus a markup) for registering an IP domain and another for passing
   on monthly rents on a IP domain (web site).  To me, this doesn't
   really seem like codes 1530/4030/5030.

Gord

Re: Connecting via Unix sockets?

[Dieter S. <dsi...@sq...>]

The string you want to change is in User.pm

The user.conf (older versions user.config) is created every time you make
a change, so to make it permanent change the User.pm file.

  # connect string to pass to dbi for database access
  if ($self->{dbdriver} eq "Pg") {
    $self->{dbconnect} = "dbi:Pg:dbname=$self->{dbname};host=$self->{dbhost};por
t=$self->{dbport}";
  }


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 Sun, 19 Aug 2001, Alan Hodgson wrote:

> On Mon, Aug 20, 2001 at 09:56:12AM +0800, Federico Sevilla III wrote:
> > Hi everyone,
> > 
> > I am not as much into Perl as I am into PHP4, but I was wondering, will it
> > be possible to configure SQL Ledger to possibly connect to PostgreSQL via
> > Unix sockets? Aside from a theoretical speed increase (however unfelt),
> > forcing the postmaster to not listen on TCP might be a good security move
> > for certain sites. On PHP4 this can be done by setting the protocol from
> > tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
> > Any gives?
> 
> Edit <user>.config.  Remove the host= and port= from the dbconnect string.
> I'm using an older version, but something similar should still apply.
> DBD::Pg will connect via UNIX domain socket by default. 
> 
> 
> 

Re: Connecting via Unix sockets?

[Noel C. <NO...@mi...>]

speed aside, this may be of interest;

you can tighten security by editing pg_hba.conf

#                   PostgreSQL HOST ACCESS CONTROL FILE
#
#
# This file controls what hosts are allowed to connect to what databases
# and specifies some options on how users on a particular host are
# identified. It is read each time a host tries to make a connection to
a
# database.


----- Original Message -----
From: "Federico Sevilla III" <ji...@le...>
To: "SQL Ledger Mailing List" <sql...@li...>
Sent: Monday, August 20, 2001 11:26 AM
Subject: Connecting via Unix sockets?


> Hi everyone,
>
> I am not as much into Perl as I am into PHP4, but I was wondering,
will it
> be possible to configure SQL Ledger to possibly connect to PostgreSQL
via
> Unix sockets? Aside from a theoretical speed increase (however
unfelt),
> forcing the postmaster to not listen on TCP might be a good security
move
> for certain sites. On PHP4 this can be done by setting the protocol
from
> tcp to unix. I don't know if this can be done with SQL-Ledger and
Perl.
> Any gives?
>
>  --> Jijo
>
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>
>
>

Re: Connecting via Unix sockets?

[John C. N. y L. <nj...@nt...>]

Heya,


To connect to your PostgreSQL server from PERL you'll, more often than
not, be using a Database driver, i.e. DBI:Pg or something..;-)  And
you're welcome to create or enhance the current PERL driver to support
unix sockets..

If you're thinking about security...  TCP sockets can still work for
your advantage, use your firewall rulesets to moderately block those
little script kiddies and system crackers.

By the way, how were you able to change PHP4 to use Unix Sockets for
PostgreSQL...  AFAIK, PHP used pgsql.so to connect to your PostgreSQL
server via TCP sockets...

From my "limited" experience...;-)  It would be better to separate your
DB storage facility from your Other services...  Then you can cluster
your DB's (wait for PostgreSQL 7.2+ or use some other method) and create
a HA web server cluster...  This would improve your performance.  It
does, however, depend on the amount of traffic you foresee..;-)

Cheers,


John Clark


Federico Sevilla III wrote:
> 
> Hi everyone,
> 
> I am not as much into Perl as I am into PHP4, but I was wondering, will it
> be possible to configure SQL Ledger to possibly connect to PostgreSQL via
> Unix sockets? Aside from a theoretical speed increase (however unfelt),
> forcing the postmaster to not listen on TCP might be a good security move
> for certain sites. On PHP4 this can be done by setting the protocol from
> tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
> Any gives?
> 
>  --> Jijo
> 
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>

-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3113            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: nj...@nt...                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds

Re: Connecting via Unix sockets?

[Alan H. <aho...@si...>]

On Mon, Aug 20, 2001 at 09:56:12AM +0800, Federico Sevilla III wrote:
> Hi everyone,
> 
> I am not as much into Perl as I am into PHP4, but I was wondering, will it
> be possible to configure SQL Ledger to possibly connect to PostgreSQL via
> Unix sockets? Aside from a theoretical speed increase (however unfelt),
> forcing the postmaster to not listen on TCP might be a good security move
> for certain sites. On PHP4 this can be done by setting the protocol from
> tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
> Any gives?

Edit <user>.config.  Remove the host= and port= from the dbconnect string.
I'm using an older version, but something similar should still apply.
DBD::Pg will connect via UNIX domain socket by default. 


-- 
"I don't want to achieve immortality through my work.  I want to achieve it
through not dying." -- Woody Allen

problem with AR

[Jeff M. <me...@ca...>]

I am using sql-ledger 1.6.0, and am trying to create an invoice.  I 
have a service that I have added.  When I create the invoice, 
everything seems to be going well (I put in the number, hit "Update 
Form" and the description and rate fills in fine).  However, when I 
attempt to post the invoice, I get an error:

Invalid Item in Row 1

(There is only one row on the invoice.)

In the error_log, I see:

Died at SL/Form.pm line 107.
Compilation failed in require at /usr/local/www/sql-ledger/is.pl line 65.

The error apparently is reported from the SL/Form.pm line 107. 
Looking at line 65 in is.pl, why is $form{path}/$script apparently 
nonexistent?  I opened the frame in a new window to do some 
debugging, and got this URL when starting the invoice:

http://www.caerdroia.org/acct/is.pl?path=bin/mozilla&action=add&login=MYLOGINID

I then filled in the invoice data, and hit "Update Form".  At that 
point, I suppose the program changed its method of accepting 
parameters, because from there on out the URL is:

http://www.caerdroia.org/acct/is.pl

It looks as if the problem is that rather than changing GET/POST (I 
forget which style of args indicates which method), the problem is 
that is.pl is not passing itself the required data.  Am I completely 
out to lunch, or doing something stupid, or is this a bug?

Thanks

-jeff
-- 
/------------------+-----------------------+----------------------------\
| Jeff Medcalf )O( | me...@ca... | www.caerdroia.org/~medcalf |
+------------------+-----------------------+----------------------------+
|                 God bless those Pagans. - Homer Simpson               |
\-----------------------------------------------------------------------/

Connecting via Unix sockets?

[Federico S. I. <ji...@le...>]

Hi everyone,

I am not as much into Perl as I am into PHP4, but I was wondering, will it
be possible to configure SQL Ledger to possibly connect to PostgreSQL via
Unix sockets? Aside from a theoretical speed increase (however unfelt),
forcing the postmaster to not listen on TCP might be a good security move
for certain sites. On PHP4 this can be done by setting the protocol from
tcp to unix. I don't know if this can be done with SQL-Ledger and Perl.
Any gives?

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://jijo.leathercollection.ph/jijo.gpg>

Stylesheets: setting in user.conf or members should work?

[Jeff K. <jt...@ad...>]

I have a mycompany.css file in the sql-ledger directory. In the
myname.conf file, I've edited the line:

stylesheet => 'mycompany.css',

and when that didn't work, the line

stylesheet=mycompany.css

in members. Neither method yeilds any visible stylesheet substitution;
e.g. from frame "Accounting Menu":

<head>
  <title>Accounting Menu</title>
  
  
</head>

<body bgcolor="#FBFFE7">

What am I missing here? Also, in general, why do the .conf and members
files duplicate information, and which takes precedence? Which is the
'master'?


BTW: A change to bin/mozilla/menu.pl
<FRAME NAME="bottom_menu" SCROLLING="no" SRC="..."
elminates the awkward text visibility of the bottom bar. I'm going to go
through and add CSS class attributes to tables, headers and whatnot over
the next week. That should make it easier for a CSS file to customize
the display. 

What's the preferred method to submit semi-trivial formatting revisions
to the maintainer for consideration as improvements? 

Multiple users, one database - Last invoice number, etc. are global?

[Jeff K. <jt...@ad...>]

I have one sql-ledger database, 'mycompany' and several users set up. I
did this to control module access, and with the thought that eventually,
it might be nice to journal the user making entries/edits as additional
table columns.

I see the 'last numbers' for invoice and PO in user prefs. Are these
global to each database, or will two users in the same company have
number collisions?

Re: Resolved: Setting postmaster "-i" on RH7.1, Pg7.1, Used postgresql.conf

[Thomas G. <to...@ad...>]

On Sun, 19 Aug 2001, Jeff Kowalczyk wrote:

> It turned out that the way (and a simple one at that) to get postmaster
> listening on 5432 with my RH7.1/Pg7.1 combination was to use the
> postgresql.conf option "tcpip_socket=true". That accomplished the same
> thing as '-i'. I don't know if the .conf file is a relatively new idiom
> to postgres, as most of the docs don't refer to it. 
> 
> One for the FAQ, I guess.

Jeff, Here are two other approaches.  

1) You could tweak your /etc/inittab like so:

db:5432:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster -i 
-D/usr/local/pgsql/data >> /usr/local/pgsql/postlog 2>&1" > /dev/null

Then add a line to your rc.local:
rm -f /tmp/.s.PGSQL.5432
in case of unplanned shutdown (this prevents the respawn errors)

2) Alternately, use your own script:

#!/bin/sh

#  SQL Clinic --- Version 1.0.0
#  Thomas Good <www.sqlclinic.net>
#  ident: /usr/local/clinic/pg_start

echo -n "Starting postgres service..."
echo "nohup postmaster -i > /home/postgres/postgres.log 2>&1 &" | su - postgres 
sleep 1
pid=`pidof postmaster`
echo -e "postmaster: pid [$pid] started..."

The advantage of rolling your own is that:

a) when you upgrade or move to a new box you take your utilities
with you - and -

b) I have logging enabled in both approaches (most sql-ledger errors
wind up in apache's error_log but I use Pg for other things too.)

These scripts assume that Pg env vars are set and that postgres' home
is /home/postgres.

Cheers...  


Oh.  Almost forgot...here's a shutdown script:

#!/bin/sh
# ident: /usr/local/clinic/pg_stop

echo -n "Stopping postgres service..."
pid=`pidof postmaster`
if [ "$pid" != "" ] ; then
	echo -n "postmaster: pid [$pid] killed."
	kill -TERM $pid
	sleep 1
fi

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: Resolved: Setting postmaster "-i" on RH7.1, Pg7.1, Used postgresql.conf

[Wayne B. <wb...@co...>]

Jeff,

I had to add the -i flag to postmaster.opts.default to get it to work. I
looked at pg_ctl and found the following:

# if we are in start mode, then look for postmaster.opts.default

# if we are in restart mode, then look for postmaster.opts

My postmaster.opts files look like this:

root@oldhome:/usr/local/pgsql/data# more postmaster.opts*
::::::::::::::
postmaster.opts
::::::::::::::
/usr/local/pgsql/bin/postmaster '-D' '/usr/local/pgsql/data' '-i' '-D'
'/usr/local/pgsql/data'
::::::::::::::
postmaster.opts.default
::::::::::::::
/usr/local/pgsql/bin/postmaster '-i' '-D' '/usr/local/pgsql/data'

Maybe this is worth a try.
Wayne

Jeff Kowalczyk wrote:
> 
> First, off thanks to everyone who helped me hash out my PostgreSQL '-i'
> problems. The various postmaster.opts methods would not work under any
> number of syntaxes.
> 
> It turned out that the way (and a simple one at that) to get postmaster
> listening on 5432 with my RH7.1/Pg7.1 combination was to use the
> postgresql.conf option "tcpip_socket=true". That accomplished the same
> thing as '-i'. I don't know if the .conf file is a relatively new idiom
> to postgres, as most of the docs don't refer to it.
> 
> One for the FAQ, I guess.

Resolved: Setting postmaster "-i" on RH7.1, Pg7.1, Used postgresql.conf

[Jeff K. <jt...@ad...>]

First, off thanks to everyone who helped me hash out my PostgreSQL '-i'
problems. The various postmaster.opts methods would not work under any
number of syntaxes. 

It turned out that the way (and a simple one at that) to get postmaster
listening on 5432 with my RH7.1/Pg7.1 combination was to use the
postgresql.conf option "tcpip_socket=true". That accomplished the same
thing as '-i'. I don't know if the .conf file is a relatively new idiom
to postgres, as most of the docs don't refer to it. 

One for the FAQ, I guess.