Thread: [SL] OT: Calgary accountant familiar with SQL-Ledger?

Brought to you by: dsimader, turt1e

sql-ledger-users

[SL] OT: Calgary accountant familiar with SQL-Ledger?

From: Shawn <sg...@op...> - 2006-04-30 03:31:38

Sorry for the blatant request, but the other message looking for an accountant 
in Toronto got me thinking...

So, I'm hoping there might be an account on the mailing list in Calgary, 
Alberta who I might be able to speak with by phone.  If you are in the area, 
an interested, please contact me off list.  Thanks.

Now back to our regularly scheduled programming... :)

Shawn

Re: [SL] OT: Calgary accountant familiar with SQL-Ledger?

From: Patrick R. <pa...@pa...> - 2006-04-30 13:49:06

On April 29, 2006 11:31 pm, Shawn wrote:
> Sorry for the blatant request, but the other message looking for an
> accountant in Toronto got me thinking...
>
> So, I'm hoping there might be an account on the mailing list in Calgary,
> Alberta who I might be able to speak with by phone.  If you are in the
> area, an interested, please contact me off list.  Thanks.
Isn't Deiter himself out that way? I thought he was in Edmonton. It isn't that 
long a drive between Edmonton and Calgary.
-- 
Patrick Rea
Toronto, ON, CA
http://www.patrickrea.org

Ask me how to end your virus problems. Today!

Re: [SL] OT: Calgary accountant familiar with SQL-Ledger?

From: Shawn <sg...@op...> - 2006-04-30 19:31:24

On Sunday 30 April 2006 07:48, Patrick Rea wrote:
> Isn't Deiter himself out that way? I thought he was in Edmonton. It isn't
> that long a drive between Edmonton and Calgary.

Yep, it's only 3 hours from Edmonton to Calgary.  And it is a nice drive.  But 
I'm looking for an accountant who can work with SL to help with setting up 
books and processes, and to help out at tax time.  So someone local would be 
a better fit.

Shawn

Re: [SL] OT: Calgary accountant familiar with SQL-Ledger?

From: Dr E. L. <el...@li...> - 2006-04-30 20:34:56

I don't understand this, really.

Unless I am mistaken, doesn't have CA GIFI? If so there is nothing
really to set up, use the CA tables.

My auditor has no clue what software I am using, other than that he
likes what I bring him.

So why does one need an accountant who knows SL?

el


on 4/30/06 9:31 PM Shawn said the following:
> On Sunday 30 April 2006 07:48, Patrick Rea wrote:
>> Isn't Deiter himself out that way? I thought he was in Edmonton. It isn't
>> that long a drive between Edmonton and Calgary.
> 
> Yep, it's only 3 hours from Edmonton to Calgary.  And it is a nice drive.  But 
> I'm looking for an accountant who can work with SL to help with setting up 
> books and processes, and to help out at tax time.  So someone local would be 
> a better fit.
> 
> Shawn
> 
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] OT: Calgary accountant familiar with SQL-Ledger?

From: Shawn <sg...@op...> - 2006-05-01 05:54:52

On Sunday 30 April 2006 13:32, Dr Eberhard Lisse wrote:
> I don't understand this, really.
>
> Unless I am mistaken, doesn't have CA GIFI? If so there is nothing
> really to set up, use the CA tables.
>
> My auditor has no clue what software I am using, other than that he
> likes what I bring him.
>
> So why does one need an accountant who knows SL?
>
> el

Mainly because I am NOT an accountant, or book keeper.  I am a computer 
consultant/programmer/network engineer.  I did try to do my books myself, but 
I've come to the realization, I do not know the "right" way to do it, nor 
have the time to learn it on my own.  But, I do like SL, and the time card 
system (which is perfect for my business), and can use SL- once I've had an 
experienced accountant/book-keeper help get me started the "right" way, and 
to understand the accounting concepts/procedures.  In the mean time, I have 
last year's books that are in varying states of entry - which I again do not 
have time to do myself (I'm expecting the tax hit, but it won't be too bad).  
So I'm also interested in a bookkeeper who can take care of this part for me, 
and an accountant to help get the most out of my taxes.  (though I do 
understand the accountant in this case does not need to know SL).  The best 
possible outcome would be to find a single accountant who could handle these 
roles for me.

LOL.. I think the real telling point is that I had to read your first 
paragraph 3 times before I understood what you were saying.  Not due to 
language or accent issues, but due to the fact that I have only a very very 
vague idea what GIFI is and how it releates to my books.  (and yes, my books 
have been set up with the Canadian tables.. That was easy as I have a 
thorough understanding of databases.  <grins>)

I'm still looking though, any leads would be appreciated - off list though.

Shawn

[SL] How to Import SQL-Ledger Data without a backup?

From: ATM L. <atm...@km...> - 2006-05-01 13:38:39

I have about a month old backup, however I have yesterdays data on a "mostly
failed" hard drive.  Short version of the story is after looking at the
"Critical Updates are available" for a few weeks, I decided to click the
button on my SME Server...  That was the last I seen of it other than
thousands of missing files, and Runlevel 7, and nothing to do, and issues
with inodes... (Ok, getting into the longer story)

In any case, although I have not tried yet (other than with Knoppix, and
that did not work either) I think I might be able to mount the drive in a
working system and copy the sql-ledger data over...  What am I looking for,
how can I do it, I suspect I am somehow getting the postgresql data
somehow...??

Any input now would be great.

Thanks,

[SL] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file

From: ATM L. <atm...@km...> - 2006-05-01 15:51:58

While reinstalling (see other post)

Everything seems to go fairly smooth till this...

su - postgres -c "createuser -a -d sql-ledger"
createuser: could not connect to database template1: FATAL:  missing or
erroneous pg_hba.conf file
HINT:  See server log for details.

This is my pg.hba.conf file below:

# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of seven forms:
#
# local      DATABASE  USER  METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
#
# (The uppercase quantities should be replaced by actual values.)
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
# DATABASE can be "all", "sameuser", "samegroup", a database name (or
# a comma-separated list thereof), or a file name prefixed with "@".
# USER can be "all", an actual user name or a group name prefixed with
# "+" or a list containing either.  IP-ADDRESS and IP-MASK specify the
# set of hosts the record matches.  CIDR-MASK is an integer between 0
# and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of
# significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent
# to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent
# to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject",
# "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam".  Note
# that "password" uses clear-text passwords; "md5" is preferred for
# encrypted passwords.  OPTION is the ident map or the name of the PAM
# service.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".

# Put your actual configuration here
# ----------------------------------
#
# CAUTION: The default configuration allows any local user to connect
# using any PostgreSQL user name, including the superuser, over either
# Unix-domain sockets or TCP/IP.  If you are on a multiple-user
# machine, the default configuration is probably too liberal for you.
# Change it to use something other than "trust" authentication.
#
# If you want to allow non-local connections, you need to add more# "+" or a
list containing either.  IP-ADDRESS and IP-MASK specify the
# set of hosts the record matches.  CIDR-MASK is an integer between 0
# and 32 (IPv6) or 128(IPv6) inclusive, that specifies the number of
# significant bits in the mask, so an IPv4 CIDR-MASK of 8 is equivalent
# to an IP-MASK of 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent
# to an IP-MASK of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject",
# "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam".  Note
# that "password" uses clear-text passwords; "md5" is preferred for
# encrypted passwords.  OPTION is the ident map or the name of the PAM
# service.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".

# Put your actual configuration here
# ----------------------------------
#
# CAUTION: The default configuration allows any local user to connect
# using any PostgreSQL user name, including the superuser, over either
# Unix-domain sockets or TCP/IP.  If you are on a multiple-user
# machine, the default configuration is probably too liberal for you.
# Change it to use something other than "trust" authentication.
#
# If you want to allow non-local connections, you need to add more
# "host" records.  Also, remember TCP/IP connections are only enabled
# if you enable "tcpip_socket" in postgresql.conf.

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

# IPv4-style local connections:
#host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
#host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)

#local all all             ident   sameuser
host all all echo -n "Enter the IP mask of this server (probably
255.255.255.0) "  trust
host all all 0.0.0.0 255.255.255.255 reject
host all all echo -n "Enter the IP mask of this server (probably
255.255.255.0) "  trust
host all all 0.0.0.0 255.255.255.255 reject
host all all echo -n "Enter the IP mask of this server (probably
255.255.255.0) "  trust
host all all 192.168.0.254 255.255.255.0 trust
host all all 0.0.0.0 255.255.255.255 reject
local all all trust
host all all 127.0.0.1 255.255.255.255 trust

Re: [SL] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file

From: Jason S. <ja...@de...> - 2006-05-01 19:55:15

On Monday 01 May 2006 11:50, ATM Logic wrote:
> While reinstalling (see other post)
>
> Everything seems to go fairly smooth till this...
>
> su - postgres -c "createuser -a -d sql-ledger"
> createuser: could not connect to database template1: FATAL:  missing or
> erroneous pg_hba.conf file
> HINT:  See server log for details.
>


Did you follow the HowTo? 
http://contribs.org/modules/phpwiki/index.php/How%20to%20install%20SQL-Ledger%20on%20SME%207.0

I have used this method many times without issue on SME7.

-- 
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] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file

From: ATM L. <atm...@km...> - 2006-05-02 00:54:26

Yes, this is the how to I used... However... I know the script is where
things got a little odd...

	I know things fell off the rail on the how to... As "clearly stated"
in the how to, I think my copy paste did me in with the whole  >> on the
same line thing...

	How do 'you' get the script from the page to your system?

	Myself I did a butchered job of copy, start pico, paste, save,
./script, oops, make runable, ./script, big load of errors..., ok, copy
line, paste, copy line, paste...  Etc etc... Welcome to my nightmare...

As mentioned in other post that got sent direct to Gordon (oops... Really
not on my 'A' Game)  I totally hosed my system (Two days before a highly
involved project) and have had to start from scratch... On a good day.., I
get by just fine however, I am really behind the eight ball on this one, and
at my witts end... 

	Even if I get SL back up, I am still done, all my data is on a drive
that ... Just does not want to play fair anymore...

	Anyhow...  Any and all help is good.
	Thanks,




-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Jason
Shein
Sent: May 1, 2006 2:55 PM
To: sql...@li...
Subject: Re: [SL] While installing on SME 7.rc2 I get FATAL: missing or
erroneous pg_hba.conf file

On Monday 01 May 2006 11:50, ATM Logic wrote:
> While reinstalling (see other post)
>
> Everything seems to go fairly smooth till this...
>
> su - postgres -c "createuser -a -d sql-ledger"
> createuser: could not connect to database template1: FATAL:  missing 
> or erroneous pg_hba.conf file
> HINT:  See server log for details.
>


Did you follow the HowTo? 
http://contribs.org/modules/phpwiki/index.php/How%20to%20install%20SQL-Ledge
r%20on%20SME%207.0

I have used this method many times without issue on SME7.

--
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.


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users