sql-ledger-users — SQL-Ledger users

Re: [SL] latex dilemma & blank emails

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

There is an upgrade file available for 1.8.3 which addresses the line
length for attachments. Apparently this fixed the problem Outlook was
having with decoding the attachments.


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 Thu, 11 Apr 2002, David Ratte wrote:

> This is NOT just an outlook problem, I've been complaining about this since 
> 1.8.3 came out and have not been able to figure it out myself.
> 
> I don't have any microsoft stuff in the building here and I can't read my own 
> emails using konqueror, netscape 4.75, or anything else!
> 
> I've checked the CPAN code Dieter used and can't find anything wrong with it. 
> The only difference is the maximum line length is a little shorter, but 
> changing it back to match the original does not fix the problem.
> 
> I still believe the CPAN code has an issue though, because if you look at the 
> raw output of sendmail as compared to other BASE64 documents generated by 
> other programs, documents from other programs have the code all line up in 
> neat little rows, where the CPAN code looks like a scrambled mess.
> 
> For the moment, all I was able to do to continue to function with my 
> customers, was to comment skip the base64 encoding routine (and send the 
> documents un-encoded)
> 
> But, meanwhile I have bigger fish to fry - currently I have a postgres ut-oh 
> such that my database is corrupt and after a re-index only contains 3 
> records, even though a look at the raw files shows much more... anyone know a 
> good postgres database recovery service?
> 
> -Dave Ratte
> Superior Circuit Technologies, Inc.
> dr...@su...

Re: [SL] latex dilemma & blank emails

[David R. <dr...@su...>]

This is NOT just an outlook problem, I've been complaining about this sin=
ce=20
1.8.3 came out and have not been able to figure it out myself.

I don't have any microsoft stuff in the building here and I can't read my=
 own=20
emails using konqueror, netscape 4.75, or anything else!

I've checked the CPAN code Dieter used and can't find anything wrong with=
 it.=20
The only difference is the maximum line length is a little shorter, but=20
changing it back to match the original does not fix the problem.

I still believe the CPAN code has an issue though, because if you look at=
 the=20
raw output of sendmail as compared to other BASE64 documents generated by=
=20
other programs, documents from other programs have the code all line up i=
n=20
neat little rows, where the CPAN code looks like a scrambled mess.

For the moment, all I was able to do to continue to function with my=20
customers, was to comment skip the base64 encoding routine (and send the=20
documents un-encoded)

But, meanwhile I have bigger fish to fry - currently I have a postgres ut=
-oh=20
such that my database is corrupt and after a re-index only contains 3=20
records, even though a look at the raw files shows much more... anyone kn=
ow a=20
good postgres database recovery service?

-Dave Ratte
Superior Circuit Technologies, Inc.
dr...@su...


On Friday 05 April 2002 01:17 pm, you wrote:
> I think some clarification is required. The email is not 'blank' it's j=
ust
> that Outlook, being the brain dead program that it is, doesn't recogniz=
e
> the message correctly. This is not really an SL problem, but of course =
it
> gets the blame. And of course Dieter has to make changes for ONE stupid
> program as opposed to Microsoft actually making things that work with
> standards. I could go on, but I won't.
>
> Sorry, just had to rant a bit there...but I feel much better now!
>
> Tom
>
> --On Friday, April 05, 2002 12:33 PM -0500 Maria Gabriela Fong
>
> <mg...@ce...> wrote:
> > It is happening to me too...
> >
> > Using netscape and pine works great, but when I send the emails to
> > outlook clients, it's blank
> >
> > Gaby
> >
> > Dieter Simader wrote:
> >> brackets and slashes are not in the conversion filter and caused a l=
atex
> >> error. This is all (?) fixed in 1.8.4
> >>
> >> I uploaded an upgrade file for 1.8.3 in the meantime until I release=
 the
> >> new code.
> >>
> >> The blank emails are a case of MS Outlook not being able to decipher
> >> BASE64 attachments. I am not sure what it is. I used the old BASE64 =
code
> >> from the Mailer package at CPAN. This works fine for pine and Netsca=
pe.
> >>
> >> It would be nice to have feedback from the community at large if thi=
s is
> >> just an isolated case or if everyone using MS Outlook has problems w=
ith
> >> this.
> >>
> >> I had a discussion over this with Ralph Dorr who experienced the sam=
e
> >> problem. I had no problems receiving his email attachments but he co=
uld
> >> not read the attachments from SQL-Ledger nor could he read attachmen=
ts
> >> sent with pine. So, I concluded that this is not in the code but mus=
t be
> >> something with Outlook. Perhaps a wrong setting or perhaps MS is tel=
ling
> >> the whole world again you better conform to their standards. Wouldn'=
t be
> >> the first time.
> >>
> >>
> >> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> >> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forev=
er =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> >>
> >> On Fri, 5 Apr 2002, Keith Mastin wrote:
> >>> I didn't have any non-alphanumric characters in the product numbers=
,
> >>> but do have some brackets and slashes in the product descriptions..=
. no
> >>> underscores or hashes though.  Postscript to screen still gets dvip=
s
> >>> errors (haven't got to that yet) but pdf to screen shows something.=
..
> >>> included below.
> >>>
> >>> HTML email is still blank. Printing doesn't do anything, but that c=
ould
> >>> be an unrelated issue.
> >>>
> >>> Is there anyone on the list with printing and html email working? (=
I'm
> >>> looking for a touch of hope here).
> >>>
> >>> Thanks
> >>>
> >>> %PDF-1.2
> >>> %=C7=EC?=A2
> >>> 2 0 obj
> >>> << /Type /Pages /Kids [
> >>> ] /Count 0
> >>>
> >>> endobj
> >>> 1 0 obj
> >>> << /Type /Catalog /Pages 2 0 R
> >>>
> >>> endobj
> >>> 3 0 obj
> >>> << /CreationDate (D:20020405100106)
> >>> /Producer (GNU Ghostscript 5.50)
> >>>
> >>> endobj
> >>> xref
> >>> 0 4
> >>> 0000000000 65535 f
> >>> 0000000068 00000 n
> >>> 0000000015 00000 n
> >>> 0000000117 00000 n
> >>> trailer
> >>> << /Size 4 /Root 1 0 R /Info 3 0 R
> >>>
> >>> startxref
> >>> 204
> >>> %%EOF
> >>>
> >>> Quoting Dr Default from [05/04/02 14:24 +0200]:
> >>>> Tip for user-friendly update: Have the 'add part' routine check if=
 any
> >>>> # in description and kill it ;-)
> >>>>
> >>>>> -----Original Message-----
> >>>>> From: sql...@sq...
> >>>>> [mailto:sql...@sq...] On Behalf Of
> >>>>> Carey Durbin
> >>>>> Sent: vrijdag 5 april 2002 13:58
> >>>>> To: sql...@sq...
> >>>>> Subject: Re: [SL] latex dilemma
> >>>>>
> >>>>>
> >>>>>
> >>>>> I too was getting this error when trying to print. I figured
> >>>>> it out this morning. I
> >>>>> had the # sign in one of my part descriptions. Latex did not
> >>>>> seem to like it for
> >>>>> some reason. I removed it and it works correctly now. Go figure.
> >>>>>
> >>>>> Carey Durbin
> >>>>> CD Computer Systems
> >>>>> E-Mail: cd...@sy...
> >>>>> Web: http://syscon.mine.nu

[SL] Error in Foreign Currency conversion

[Peter D. <mer...@ma...>]

Hi,
I think SL making error in Foreign Currency conversion when full number is used without fraction.
This is example:
After making AP transaction in foreign curency with conversion rate 2.0 GL rekord looks like that:
           23.10
                   11.55
It shuld look like that:

           23.10
                   11.55
                   11.55

Peter Dabrowski

   

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

[SL] Re: SLwanted: book keeper

[<raa...@ac...>]

On 25 Mar 2002, Damon Torgerson wrote:

> I'm looking for a book keeper that uses SQL-Ledger.  I will need
> references and all the usual info.  We are a software development firm
> located in Victoria, British Columbia, Canada.

Damon, did you find a book keeper yet?  How about an Accountant willing to 
use/work-with SL?


Rod
-- 
             Why is it so easy to throw caution to the wind.
            Shouldn't it be heavier and shaped like an anvil?

                                                           Jon Anderson

[SL] not responding

[lee j. <le...@im...>]

hi..

   never mind I got it..the last phase reealy could be  a little bit
more clear...the 'name/password' to get into sql-ledger is
misleasding..its actually the 'login' apparantly as when I used what I
have at top of page for 'login' it worked fine..ie: name/login..not very
clear :)

can this be updated for less confusion ?

thx for great software..also why can't the tax rate be altered to allow
US exchange to be used as well..

lee
-==

[SL] can't make database

[lee j. <le...@im...>]

using sql-ledger 1.83 or whatever is newest..
i'm in no problem to management screen but I can't seem to get database
to create..no error but it just sits trying to access...

thx anyone
lee

Re: [SL] Newbie needs help...

[kevin b. <kev...@bi...>]

just a quick note - look for similar entries in the conf files.  the 
apache file (this is /etc/apache/httpd.conf on most distros) is in 
several sections.

also - if you get a 'bible' type linux book they usually have a chapter 
on apache.

good luck - it may seem daunting at first but apache is relatively easy 
once you've got going.

i've sent my my httpd.conf file to your personal email for reference,

kev bailey

DRHogg wrote:
> Hi Folks:
> 
> I am working with Mandrake 8.2.  I have little experience editing conf 
> files.  I am using "pico" for an editor.  The 'what to edit' and 'where 
> to add bits' has me confused.(more).
> 
> edit sql-ledger.conf.........what do I need to change here?  Could 
> someone send me an
> 
> edited file?
> 
> edit httpd.conf and add........exactly where do the lines get added?  Is 
> this the file in /etc/  ? 
> 
> AddHandler cgi-script .pl
> 
> Alias /sql-ledger/ /usr/local/sql-ledger/
> 
> <Directory /usr/local/sql-ledger>
> 
> Options ExecCGI Includes FollowSymlinks
> 
> </Directory>
> 
> <Directory /usr/local/sql-ledger/users>
> 
> Options None
> 
> </Directory>
> 
> I will be grateful for any help.  If there is other documentation I 
> could read, could someone give me the tip?
> 
> Thanks in advance,
> 
> Douglas Hogg
> 
> sc...@ro... <mailto:sc...@ro...>
> 
> Rexdale, Ontario
> 
>  
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/02
> 

Re: [SL] Email invoice isn't formatted properly on all HTML email clients - SQL-Ledger 1.8.3 clean install

[Fred L. <lin...@la...>]

Okay, I applied the upgrade, but I still seem to have the same problem.  
It seems to be a problem with the attachment encoding - I also tried 
generating a PDF, and it opens fine when saved as an attachment from 
PINE, but in Outlook the attachment is mangled, so Acrobat Reader can't 
open it.

When I posted earlier, I didn't realize right away that there was a 
hyperlink there for the upgrade.  I downloaded 1.8.3 again and applied 
it before I realized that it was the same, and then realized that the 
upgrade hyperlink was a different file.  I also had a lot of trouble 
staying connected to the site to download the file.  I checked my 
connection and speedtest.com reported my connection running just over 1 
Mbps, which is normal for me.

I was downloading from the main site, sql-ledger/source/download.htm...

Thanks!

Fred

On Monday, April 8, 2002, at 05:12 PM, Dieter Simader wrote:

> There is an upgrade file in the section *Revisions* to fix the problem
> with Outlook.
>
> Where do you download the source code from? The *Revisions* section on 
> the
> download page explains which upgrades are available for 1.8.3 One of 
> them
> deals with Outlook.
>
>
> 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, 8 Apr 2002, Fred Laxton wrote:
>
>> Has anyone else been having a problem with this?  My system had a hard
>> drive fail, but before it did I was running SQL-Ledger with no
>> problems.  I don't remember if it was 1.6.x or 1.8.2, but it was one of
>> the two.  Email invoices were working beautifully.
>>
>> I set up a new SuSE install, got SQL-Ledger installed, everything 
>> seemed
>> to be working okay.  I started with a new, empty PostgreSQL database (I
>> lost the old one).
>>
>> The symptom is that the invoice displays on screen okay when I select
>> HTML, screen and click Print.  However, I get one line of garbage on
>> Outlook 2000 when I view the email it sends.  It appears to show up 
>> okay
>> on Mozilla, but not KMail.
>>
>> This is on a new install of 1.8.3.
>>
>> I tried removing "sql-ledger.css" style sheet in setup, but that didn't
>> fix the problem.
>>
>> I'm looking at going back to 1.8.2 or 1.6.x, because I have some
>> invoices I need to get out pronto.
>>
>> Any ideas?
>>
>> Thanks!
>>
>> Fred
>>
>>
>>
>
>
>
> Sponsored by http://www.ThinkGeek.com/
>
>

Re: [SL] Email invoice isn't formatted properly on all HTML email clients - SQL-Ledger 1.8.3 clean install

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

There is an upgrade file in the section *Revisions* to fix the problem
with Outlook.

Where do you download the source code from? The *Revisions* section on the
download page explains which upgrades are available for 1.8.3 One of them
deals with Outlook.


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, 8 Apr 2002, Fred Laxton wrote:

> Has anyone else been having a problem with this?  My system had a hard 
> drive fail, but before it did I was running SQL-Ledger with no 
> problems.  I don't remember if it was 1.6.x or 1.8.2, but it was one of 
> the two.  Email invoices were working beautifully.
> 
> I set up a new SuSE install, got SQL-Ledger installed, everything seemed 
> to be working okay.  I started with a new, empty PostgreSQL database (I 
> lost the old one).
> 
> The symptom is that the invoice displays on screen okay when I select 
> HTML, screen and click Print.  However, I get one line of garbage on 
> Outlook 2000 when I view the email it sends.  It appears to show up okay 
> on Mozilla, but not KMail.
> 
> This is on a new install of 1.8.3.
> 
> I tried removing "sql-ledger.css" style sheet in setup, but that didn't 
> fix the problem.
> 
> I'm looking at going back to 1.8.2 or 1.6.x, because I have some 
> invoices I need to get out pronto.
> 
> Any ideas?
> 
> Thanks!
> 
> Fred
> 
> 
> 

[SL] Email invoice isn't formatted properly on all HTML email clients - SQL-Ledger 1.8.3 clean install

[Fred L. <lin...@la...>]

Has anyone else been having a problem with this?  My system had a hard 
drive fail, but before it did I was running SQL-Ledger with no 
problems.  I don't remember if it was 1.6.x or 1.8.2, but it was one of 
the two.  Email invoices were working beautifully.

I set up a new SuSE install, got SQL-Ledger installed, everything seemed 
to be working okay.  I started with a new, empty PostgreSQL database (I 
lost the old one).

The symptom is that the invoice displays on screen okay when I select 
HTML, screen and click Print.  However, I get one line of garbage on 
Outlook 2000 when I view the email it sends.  It appears to show up okay 
on Mozilla, but not KMail.

This is on a new install of 1.8.3.

I tried removing "sql-ledger.css" style sheet in setup, but that didn't 
fix the problem.

I'm looking at going back to 1.8.2 or 1.6.x, because I have some 
invoices I need to get out pronto.

Any ideas?

Thanks!

Fred

[SL] Email invoice isn't formatted properly on all HTML email clients - SQL-Ledger 1.8.3 clean install

[Fred L. <lin...@la...>]

Has anyone else been having a problem with this?  My system had a hard 
drive fail, but before it did I was running SQL-Ledger with no 
problems.  I don't remember if it was 1.6.x or 1.8.2, but it was one of 
the two.  Email invoices were working beautifully.

I set up a new SuSE install, got SQL-Ledger installed, everything seemed 
to be working okay.  I started with a new, empty PostgreSQL database (I 
lost the old one).

The symptom is that the invoice displays on screen okay when I select 
HTML, screen and click Print.  However, I get one line of garbage on 
Outlook 2000 when I view the email it sends.  It appears to show up okay 
on Mozilla, but not KMail.

This is on a new install of 1.8.3.

I tried removing "sql-ledger.css" style sheet in setup, but that didn't 
fix the problem.

I'm looking at going back to 1.8.2 or 1.6.x, because I have some 
invoices I need to get out pronto.

Any ideas?

Thanks!

Fred

Re: [SL] can't connect to postgres

[Nicholas T. <ne...@ta...>]

Honest to Goodness wrote:
> 
> Things are looking much better. I got postgres up in 1/15 of the time it
> took to go nowhere on Mysql. I can create databases from the command
> line and Webmin is giving me a nice postgres interface. The problem is
> when I try to load admin.pl I get this error:
> 
> ERROR!
> No Database Drivers available!
> 
> I haven't tried any other postgres clients, will SL give me a log
> somewhere? Could be just a permission thing ...

Did you read the installation notes for SQL-ledger at all????

Try putting DBD and DBI on your system and making them available for SQL
Ledger, then you might not have so much trouble, but above all, read the
instructions pleeeaaase before posting any more enquiries.

Regards,.

Nicholas Tomlin.

Re: [SL] can't connect to mysql

[Kenneth G. <la...@th...>]

are you using redhat 7.1? if so, in some copies of the distro, mysql on the 
cd will not only not work, but will mess up any subsequent installation. you 
need to physically delete everything to do with mysql, and then install it 
from another source.
kg
On Sunday 07 April 2002 09:57, Honest to Goodness wrote:
> I fought all day against mysql and was thrown back in defeat. I tried
> installing from source, from rpm and through red-carpet, I have
> configured everything a dozen times and I still can't connect to port
> 3306.
>

Re: [SL] connectDBStart connect failed

[Keith M. <km...@be...>]

On Sun, 7 Apr 2002, Keith Mastin wrote:
>
>I blew away my previous install (no backup yet of course) and in trying 
>to create a dataset after the re-install I get this message:
>	Error!
>	connectDBStart() -- connect() failed: No such file or directory
>
>I installed everything (including perl, DBI and DBD-Pg) from rpms and 
>the new distro is RH7.2. I'm using the README file in the doc directory 
>as my How-To... it worked before.
>
>Any idea of what is wrong here?
Sorry about the waste of time... too late to work on this now. I got 
it... the database service was not running. !doh!
-- 
Keith Mastin	     km...@be...
BeechTree Information Technology Services Inc.
137 Laird Drive    M4G 3V5    Tel(416)696-6070
	   http://www.beechtree.ca

[SL] connectDBStart connect failed

[Keith M. <km...@be...>]

Hi,

I blew away my previous install (no backup yet of course) and in trying 
to create a dataset after the re-install I get this message:
	Error!
	connectDBStart() -- connect() failed: No such file or directory

I installed everything (including perl, DBI and DBD-Pg) from rpms and 
the new distro is RH7.2. I'm using the README file in the doc directory 
as my How-To... it worked before.

Any idea of what is wrong here?

TIA
-- 
Keith Mastin	     km...@be...
BeechTree Information Technology Services Inc.
137 Laird Drive    M4G 3V5    Tel(416)696-6070
	   http://www.beechtree.ca

RE: [SL] can't connect to postgres

[lee j. <le...@im...>]

On Sun, 2002-04-07 at 08:27, Dr Default wrote:
> You need DBD-Pg and DBI 
> Try to find them as RPM, the make make install part killed me too..
> 
> Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the
> moment, 
> I could email to you if needs be. 
----------------
could you ftp it to me?
ftp.imyourhandiman.com
put in incoming and just let me know when its there ie:
le...@im...

thx mucho
lee

RE: [SL] can't connect to postgres

[Honest to G. <h2...@sy...>]

OMG! I got it working, achhh it voiks like a chom! Thanks for all your
help!


On Sun, 2002-04-07 at 11:27, Dr Default wrote:
> You need DBD-Pg and DBI 
> Try to find them as RPM, the make make install part killed me too..
> 
> Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the
> moment, 
> I could email to you if needs be. That one got me online, it's intended
> for redhat but 
> Mandrake likes it just as well.. So do I ;-)
> 
> > -----Original Message-----
> > From: sql...@sq... 
> > [mailto:sql...@sq...] On Behalf Of 
> > Honest to Goodness
> > Sent: zondag 7 april 2002 17:02
> > To: sql...@sq...
> > Subject: [SL] can't connect to postgres
> > 
> > 
> > Things are looking much better. I got postgres up in 1/15 of 
> > the time it took to go nowhere on Mysql. I can create 
> > databases from the command line and Webmin is giving me a 
> > nice postgres interface. The problem is when I try to load 
> > admin.pl I get this error:
> > 
> > ERROR!
> > No Database Drivers available!
> > 
> > I haven't tried any other postgres clients, will SL give me a 
> > log somewhere? Could be just a permission thing ...
> > 
> > 
> 
> 

RE: [SL] can't connect to postgres

[Dr D. <drd...@ho...>]

You need DBD-Pg and DBI 
Try to find them as RPM, the make make install part killed me too..

Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the
moment, 
I could email to you if needs be. That one got me online, it's intended
for redhat but 
Mandrake likes it just as well.. So do I ;-)

> -----Original Message-----
> From: sql...@sq... 
> [mailto:sql...@sq...] On Behalf Of 
> Honest to Goodness
> Sent: zondag 7 april 2002 17:02
> To: sql...@sq...
> Subject: [SL] can't connect to postgres
> 
> 
> Things are looking much better. I got postgres up in 1/15 of 
> the time it took to go nowhere on Mysql. I can create 
> databases from the command line and Webmin is giving me a 
> nice postgres interface. The problem is when I try to load 
> admin.pl I get this error:
> 
> ERROR!
> No Database Drivers available!
> 
> I haven't tried any other postgres clients, will SL give me a 
> log somewhere? Could be just a permission thing ...
> 
> 

[SL] can't connect to postgres

[Honest to G. <h2...@sy...>]

Things are looking much better. I got postgres up in 1/15 of the time it
took to go nowhere on Mysql. I can create databases from the command
line and Webmin is giving me a nice postgres interface. The problem is
when I try to load admin.pl I get this error:

ERROR!
No Database Drivers available!

I haven't tried any other postgres clients, will SL give me a log
somewhere? Could be just a permission thing ...

Re: [SL] can't connect to mysql

[Tom L. <to...@re...>]

I too was unaware that SQL-Ledger ran with MySQL. I'm pretty sure it 
doesn't. That aside, it sounds like a privilege problem. I fought with this 
one for awhile. Although you say you can't login through command line 
either? Anyway, you need to 'grant privileges' to the host AND user that 
you want to connect from, and you need to 'flush privileges' or reload 
mysql after granting privileges. If you don't flush them, you will be 
scratching your head wondering why the settings didn't work. I don't 
remember the exact procedure, but look in the MySQL docs and it is 
described in great detail.

Tom

PS Install Postgres, that is the one that WILL work! :)

--On Saturday, April 06, 2002 11:22 PM -0600 mark hees <ma...@ac...> 
wrote:

> SL on MySQL?
> Have I missed something?
> SQL-Ledger only runs with PostgreSQL.
> Install Postgres.  You'll also need DBD/DBI I believe.  Read the docs at
> the SQL-Ledger web site to get the info you'll need. --Mark
>
>
> At 11:27 PM 4/6/2002 -0500, you wrote:
>> I fought all day against mysql and was thrown back in defeat. I tried
>> installing from source, from rpm and through red-carpet, I have
>> configured everything a dozen times and I still can't connect to port
>> 3306.
>>
>> I get this error:
>> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
>>
>> Yet mysql put that file there when the daemon started, and removes it
>> when it's stopped. The error log never shows any errors, just ok
>> startups and shutdowns. I always see the errors on the command line.
>>
>> I try to telnet to 3306 and the connection is refused. My firewall
>> allows 3306 and even with firewall disabled I get the same thing. I see
>> files created and deleted in /var/lib/mysql as I start and stop the
>> server, it looks ok.
>>
>> Webmin can't connect and neither can mysqlgui nor can root at the
>> command line. Everything looks fine but I just can't connect.
>>
>> After install I ran mysql_install_db and it seemed to work but I don't
>> see any databases. I think that's where the problem is, no databases.
>>
>> What do database tables look like? Where? How big? What extension? I
>> really need to get sql-ledger up and running. Can I use a different
>> database? How about postgres? Maybe I can get that one to work. Any help
>> will save my life ...
>
>

Re: [SL] can't connect to mysql

[Terry C. <tc...@se...>]

On 6 Apr 2002, Honest to Goodness wrote:

> I fought all day against mysql and was thrown back in defeat. I tried
> installing from source, from rpm and through red-carpet, I have
> configured everything a dozen times and I still can't connect to port
> 3306.
>
> I get this error:
> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Have you checked to see if 'skip-networking' is uncommented in the
global mysql configuration file. Mine is in /etc/mysql/my.conf.


Regards,


Terry.

tc...@se...
----------------------------------------------------------
Public PGP Key: http://www.selterra.com/pgpkey/tcarney.asc

Re: [SL] can't connect to mysql

[mark h. <ma...@ac...>]

SL on MySQL?
Have I missed something?
SQL-Ledger only runs with PostgreSQL.
Install Postgres.  You'll also need DBD/DBI I believe.  Read the docs at 
the SQL-Ledger web site to get the info you'll need.
--Mark


At 11:27 PM 4/6/2002 -0500, you wrote:
>I fought all day against mysql and was thrown back in defeat. I tried
>installing from source, from rpm and through red-carpet, I have
>configured everything a dozen times and I still can't connect to port
>3306.
>
>I get this error:
>Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
>
>Yet mysql put that file there when the daemon started, and removes it
>when it's stopped. The error log never shows any errors, just ok
>startups and shutdowns. I always see the errors on the command line.
>
>I try to telnet to 3306 and the connection is refused. My firewall
>allows 3306 and even with firewall disabled I get the same thing. I see
>files created and deleted in /var/lib/mysql as I start and stop the
>server, it looks ok.
>
>Webmin can't connect and neither can mysqlgui nor can root at the
>command line. Everything looks fine but I just can't connect.
>
>After install I ran mysql_install_db and it seemed to work but I don't
>see any databases. I think that's where the problem is, no databases.
>
>What do database tables look like? Where? How big? What extension? I
>really need to get sql-ledger up and running. Can I use a different
>database? How about postgres? Maybe I can get that one to work. Any help
>will save my life ...

[SL] can't connect to mysql

[Honest to G. <h2...@sy...>]

I fought all day against mysql and was thrown back in defeat. I tried
installing from source, from rpm and through red-carpet, I have
configured everything a dozen times and I still can't connect to port
3306.

I get this error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Yet mysql put that file there when the daemon started, and removes it
when it's stopped. The error log never shows any errors, just ok
startups and shutdowns. I always see the errors on the command line.

I try to telnet to 3306 and the connection is refused. My firewall
allows 3306 and even with firewall disabled I get the same thing. I see
files created and deleted in /var/lib/mysql as I start and stop the
server, it looks ok.

Webmin can't connect and neither can mysqlgui nor can root at the
command line. Everything looks fine but I just can't connect.

After install I ran mysql_install_db and it seemed to work but I don't
see any databases. I think that's where the problem is, no databases. 

What do database tables look like? Where? How big? What extension? I
really need to get sql-ledger up and running. Can I use a different
database? How about postgres? Maybe I can get that one to work. Any help
will save my life ...

Re: [SL] IAS chart of accounts

[Todd B. <tb...@co...>]

Hi Steve, the IASC has published a taxonomy within the XBRL framework, from
which an authoritative chart of accounts could be produced.  Please let me
know if you can't find copies or want to discuss further,
Todd www.gldialtone.com

At 06:45 AM 4/6/02, you wrote:
>Does anyone have any references or links to an IAS chart of accounts?  I
>can't find any requirements regarding a chart of accounts at
>iasc.org.uk.
>
>I would be glad to put one together, but I can't see where they require
>a specific chart of accounts.
>
>Thanks,
>Steve

[SL] email attachments & MS Outlook

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

I posted a fix for the MS Outlook problem. Attachments are now recognized
by Outlook as harmless attachments and not some executable or virus.

Revisions are available in the upgrade file, simply install over top.


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