Menu
▾
▴
sql-ledger-users
|
From: R. Q. <rq...@gm...> - 2007-04-11 12:08:30
|
Ghana will change her currency from Cedis (CED) to New Ghana cedis (NGC), starting from 1st July 2007. 10,000 CED = 1 GHC. Both currencies will be used parallel for some time for the next six months. How do I change my default currency and how will it affect my transactions/accounts? Regards Robert |
|
From: ATM L. <atm...@km...> - 2006-05-02 15:16:13
|
I have a near dead drive, that I am able to mount via "text rescue" I have a working ethernet port. So, nothing is "running" on the dead system so no postgress. However is their a way to move the SL data from The dead system to the new system. If so, how? Thanks -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Paul Tammes Sent: May 2, 2006 12:14 AM To: sql...@li... Subject: RE: [SL] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file If the data is readable, I suggest either a local or remote login on the SQL-ledger login and then do a system backup to file. Copy to USB stick, format silly HDD and re-install a Linux system, on a new HDD if needed. I have succesfully re-created complete data from a USB stick backup to a newly installed system, so it can be done. Even from 2.4.x to the current version with the 2.4.x version plus update scripts ;-) If that does not help, copy data in sql-ledger dir plus subdirs to say USB stick, use new linux install (any major distro) Then do a chown -hR or something similar to regain read-write rights and work from there. Reminds me, Backup not found. (A)bort, (R)etry, (P)anic -----Oorspronkelijk bericht----- Van: sql...@li... [mailto:sql...@li...] Namens ATM Logic Verzonden: Tuesday, May 02, 2006 4:30 AM Aan: sql...@li... Onderwerp: RE: [SL] While installing on SME 7.rc2 I get FATAL: missing or erroneous pg_hba.conf file Well, I did get it to go, in the end, it was the wrapping and the >> that was messing things up for me... But with This going down, and a HUGE time crunch on a project I am in, I am not really on my 'A' Game... As a matter of fact, I am not even sure what the game is.. Just that I am not winning... > How do 'you' get the script from the page to your system? I am using SSH into the system from a KDE desktop. Cut & paste worked for me using nano for an editor. > 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... Where are you located? If you are in southern Ontario, our speciality is data recovery. Check our website for details. Northern Ontario... Very Northern, about 1/2 hour from Manitoba. Good to know that your in the Data Recovery biz, I don't think I would send any of my own things down, as we "normally" keep good backups (as it is, I have 92% of this system backed up in Duplicate or better... However it's the wife's job to click the backup button, and... Well... Good thing I clicked the button a Month and a half ago... Saddly I don't fully have my head around SQL well enough to sort out how to get the last bit out of the 'read only filesystem (30)' Drive that will not mount for me with anything I throw at it... Thanks, for the help. I was SSH to a remote box, using pico, did a little edit, recopy, repaste, and all was good... > > -----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-L edg >e 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 ------------------------------------------------------- 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date: 4/28/2006 ------------------------------------------------------- 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 |
|
From: Dieter S. <dsi...@sq...> - 2006-05-02 15:40:51
|
copy /usr/local/pgsql/data to a new drive and directory and point PG_DATA to it. With the same version of postgres you should be able to read the data. -- Dieter Simader http://www.sql-ledger.com (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 ============ On a clear disk you can seek forever ========== On Tue, 2 May 2006, ATM Logic wrote: > I have a near dead drive, that I am able to mount via "text rescue" I have a > working ethernet port. > So, nothing is "running" on the dead system so no postgress. However is > their a way to move the SL data from > The dead system to the new system. If so, how? Thanks > |
|
From: ATM L. <atm...@km...> - 2006-05-02 21:50:57
|
Thanks Dieter, Can you help me or 'point' me in the right direction to get a little bit more info about 'pointing to PG_DATA' Thanks, Andrew -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Dieter Simader Sent: May 2, 2006 10:41 AM To: sql...@li... Subject: Re: [SL] Where does SL keep the data, and can you move data from dead system to new system? copy /usr/local/pgsql/data to a new drive and directory and point PG_DATA to it. With the same version of postgres you should be able to read the data. -- Dieter Simader http://www.sql-ledger.com (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 ============ On a clear disk you can seek forever ========== On Tue, 2 May 2006, ATM Logic wrote: > I have a near dead drive, that I am able to mount via "text rescue" I > have a working ethernet port. > So, nothing is "running" on the dead system so no postgress. However > is their a way to move the SL data from The dead system to the new > system. If so, how? Thanks > ------------------------------------------------------- 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 |
|
From: Ted O. <te...@on...> - 2006-05-02 21:56:48
|
PG_DATA is an environment variable that tells postgres where its databases are. If you copy the data to /tmp/pgsql/data and set PG_DATA=/tmp/pgsql/data and start up postgres, you should be able to read you database. You need to make sure you are running the same version of postgres on your new box that you were running on your old box. ATM Logic wrote: > Thanks Dieter, > > Can you help me or 'point' me in the right direction to get a little > bit more info about 'pointing to PG_DATA' > > Thanks, > Andrew > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On Behalf Of Dieter > Simader > Sent: May 2, 2006 10:41 AM > To: sql...@li... > Subject: Re: [SL] Where does SL keep the data, and can you move data from > dead system to new system? > > copy /usr/local/pgsql/data to a new drive and directory and point PG_DATA to > it. With the same version of postgres you should be able to read the data. > |
|
From: Ted O. <te...@on...> - 2006-05-02 22:04:40
|
The environment variable is PGDATA (not PG_DATA) on my system. Ted Onley wrote: > PG_DATA is an environment variable that tells postgres where its > databases are. If you copy the data to /tmp/pgsql/data and set > PG_DATA=/tmp/pgsql/data and start up postgres, you should be able to > read you database. > > You need to make sure you are running the same version of postgres on > your new box that you were running on your old box. > > ATM Logic wrote: > >> Thanks Dieter, >> Can you help me or 'point' me in the right direction to get a little >> bit more info about 'pointing to PG_DATA' >> Thanks, >> Andrew >> >> -----Original Message----- >> From: sql...@li... >> [mailto:sql...@li...] On Behalf Of Dieter >> Simader >> Sent: May 2, 2006 10:41 AM >> To: sql...@li... >> Subject: Re: [SL] Where does SL keep the data, and can you move data from >> dead system to new system? >> >> copy /usr/local/pgsql/data to a new drive and directory and point >> PG_DATA to >> it. With the same version of postgres you should be able to read the >> data. >> > > > ------------------------------------------------------- > 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 > |
|
From: Angus C. <ac...@sa...> - 2006-05-02 22:29:25
|
Hi, Andrew, On my system (Fedora-based) PGDATA points by default to /var/lib/pgsql/data, but that's postgres 8.1.3. For earlier versions, it was /var/lib/pgsql You can override it by putting entries into /etc/sysconfig/pgsql/posgresql What I would do is copy the files off the old machine, then start an extra copy of postgresql to interpret the data and pgdump it to a dump file. The command line switches for the postmaster can point it to an unusual PGDATA location and an unusual port number so you can run it concurrently. You will need a corresponding version of postgresql, however, and that will be your biggest challenge, most likely. Other than that, it's fairly simple. I automate the daily dump for archiving purposes, myself. The dump gets checked into a subversion repository on another machine, and I can reconstruct a local copy for testing with no fear of back-contamination. That lets me test new revisions of SL without fear of having problems. Angus. ATM Logic wrote: > Thanks Dieter, > > Can you help me or 'point' me in the right direction to get a little > bit more info about 'pointing to PG_DATA' > > Thanks, > Andrew > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On Behalf Of Dieter > Simader > Sent: May 2, 2006 10:41 AM > To: sql...@li... > Subject: Re: [SL] Where does SL keep the data, and can you move data from > dead system to new system? > > copy /usr/local/pgsql/data to a new drive and directory and point PG_DATA to > it. With the same version of postgres you should be able to read the data. > > |
|
From: ATM L. <atm...@km...> - 2006-05-03 03:17:39
|
Thanks Angus, Yes, my data was at /var/lib/pgsql/data, however no config file at /etc/sysconfig/pgsql/posgresql (ends at pgsql) I cannot find PGDATA or PG_DATA on my system, but working remotely.. So will look harder when I get back home... Anyone know what file I have to change on a SME 7.xx box? I was able to SCP the data over to /sql-old/data ---Andrew -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Angus Carr Sent: May 2, 2006 5:29 PM To: sql...@li... Subject: Re: [SL] Where does SL keep the data, and can you move data from dead system to new system? Hi, Andrew, On my system (Fedora-based) PGDATA points by default to /var/lib/pgsql/data, but that's postgres 8.1.3. For earlier versions, it was /var/lib/pgsql You can override it by putting entries into /etc/sysconfig/pgsql/posgresql What I would do is copy the files off the old machine, then start an extra copy of postgresql to interpret the data and pgdump it to a dump file. The command line switches for the postmaster can point it to an unusual PGDATA location and an unusual port number so you can run it concurrently. You will need a corresponding version of postgresql, however, and that will be your biggest challenge, most likely. Other than that, it's fairly simple. I automate the daily dump for archiving purposes, myself. The dump gets checked into a subversion repository on another machine, and I can reconstruct a local copy for testing with no fear of back-contamination. That lets me test new revisions of SL without fear of having problems. Angus. ATM Logic wrote: > Thanks Dieter, > > Can you help me or 'point' me in the right direction to get a little > bit more info about 'pointing to PG_DATA' > > Thanks, > Andrew > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On Behalf Of > Dieter Simader > Sent: May 2, 2006 10:41 AM > To: sql...@li... > Subject: Re: [SL] Where does SL keep the data, and can you move data > from dead system to new system? > > copy /usr/local/pgsql/data to a new drive and directory and point > PG_DATA to it. With the same version of postgres you should be able to read the data. > > ------------------------------------------------------- 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 |
|
From: ATM L. <atm...@km...> - 2006-05-03 03:44:27
|
I want to change SL from /var/lib/pgsql/data to /sql-old/data Can anyone tell me where this file is? I cannot seem to find the .conf where this info is held? Even if it was very temporary so I can get in, backup my data, and then import it to the working file. Thanks |
|
From: davidc <da...@mo...> - 2006-05-01 23:54:16
|
try just host all all 192.168.0.0 255 255.255.255 trust local all all trust host all all 127.0.0.1 255.255.255.0 trust but may not be secure, !!!!, don't know! 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. > >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 > > > > > >------------------------------------------------------- >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 > > |
|
From: Dr E. L. <el...@li...> - 2006-05-01 06:10:36
|
So you need a book keeper :-)-O el on 5/1/06 7:54 AM Shawn said the following: > 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 > > > > ------------------------------------------------------- > 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X