sql-ledger-users — SQL-Ledger users

Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

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

On Tue, 30 Oct 2001, Thomas Good wrote:

> be sure that all of your Pg stuff is the same version.  I will look aroun=
d
> here - I have a shell script to remove rpms and install the new ones.

> BTW, you definitely want to use pg_dump to protect any data before you
> make any sweeping changes as you will need to do a reload into 7.1
> when you upgrade.  Postgres has no upgrade path for jumps in major
> version numbers, i.e, 7.0 -> 7.1.  :-(

Oscar - here is a script I used to go from 6.5 to 7.0
If you change the version numbers, collect all of the necessary
rpms and then run the script you should be fine. =20
Just remember to back up your data first!

#!/bin/sh

rm -ir /var/lib/pgsql/data/base

rpm -e postgresql-test-6.5.2-1
rpm -e postgresql-jdbc-6.5.2-1
rpm -e postgresql-odbc-6.5.2-1
rpm -e postgresql-perl-6.5.2-1
rpm -e postgresql-python-6.5.2-1
rpm -e postgresql-tcl-6.5.2-1
rpm -e postgresql-devel-6.5.2-1
rpm -e postgresql-server-6.5.2-1
rpm -e php-pgsql-3.0.12-6
rpm -e postgresql-6.5.2-1

rpm -i postgresql-7.0.3-2.i386.rpm
rpm -i postgresql-server-7.0.3-2.i386.rpm
rpm -i postgresql-devel-7.0.3-2.i386.rpm
rpm -i postgresql-test-7.0.3-2.i386.rpm
rpm -i postgresql-jdbc-7.0.3-2.i386.rpm
rpm -i postgresql-odbc-7.0.3-2.i386.rpm
rpm -i postgresql-perl-7.0.3-2.i386.rpm
rpm -i postgresql-python-7.0.3-2.i386.rpm
rpm -i postgresql-tcl-7.0.3-2.i386.rpm
rpm -i postgresql-tk-7.0.3-2.i386.rpm

/etc/rc.d/init.d/postgresql start

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

[Oscar B. <os...@el...>]

Hi Thomas,

As  psql -V says:
psql (PostgreSQL) 7.0.3

Why then not just install: postgresql-perl-7.0.3-8 RPM for i386 ??

from: 
http://rpmfind.net/linux/RPM/redhat/7.1/i386/postgresql-perl-7.0.3-8.i386.html

This woul save me the hassle of reinstalling, pg_dumping and whatever 
else....

Is my assumption correct??

Regards,

Oscar

Thomas Good wrote:

> On Tue, 30 Oct 2001, Oscar Buijten wrote:
> 
> 
>>Hi Thomas,
>>
>>So then I thought, maybe there is some perl pgsql driver of some sort 
>>missing. This is the result:
>>rpm -i postgresql-perl-7.1.3-1mdk.i586.rpm
>>error: failed dependencies:
>>         postgresql = 7.1.3-1mdk is needed by postgresql-perl-7.1.3-1mdk
>>         libpq.so.2   is needed by postgresql-perl-7.1.3-1mdk
>>
>>Is that because of this?:
>>  psql -V
>>
> 
> Hi Oscar - yes.  You are trying to install an rpm for a diff version
> of Pg.  That will cause problems and here is another issue:
> 
> So, we must get the version mismatch sorted and then install the
> missing libraries.
> 
> 
>>Could I then just install: postgresql-libs-7.1.3-1mdk RPM for i586 ??
>>
> Dude.  I would use rpm (run man rpm to see the various options) to remove
> all 7.0 postgres stuff prior to installing any 7.1 rpms.  You want to
> be sure that all of your Pg stuff is the same version.  I will look around
> here - I have a shell script to remove rpms and install the new ones.
> 
> BTW, you definitely want to use pg_dump to protect any data before you
> make any sweeping changes as you will need to do a reload into 7.1
> when you upgrade.  Postgres has no upgrade path for jumps in major
> version numbers, i.e, 7.0 -> 7.1.  :-(
> 
> 
> 
>>>On Mon, 29 Oct 2001, Oscar Buijten wrote:
>>>
>>>
>>>
>>>>Hi!
>>>>
>>>>Yesterday I have upgraded perl 5.6.1 (installed from source).
>>>>Since then I have problems to use SQL-ledger....
>>>>
>>>>It seemed that I had lost DBI and DBD.
>>>>So I have re-installed them (how to check the correctness??)...
>>>>
>>>>
>>>Hi Oscar,
>>>
>>>If you don't have any DBI.pm somewhere in ../site_perl/
>>>(locate DBI | grep site_perl)
>>>simply reinstall your drivers:
>>>DBI first, followed by DBD-Pg
>>>
>>>It shouldn't be too much of a hassle.
>>>So how do you like 5.6.1?
>>>
>>>Cheers,
>>>Tom
>>>
>>>--------------------------------------------------------------------
>>>              Saint Vincent Catholic Medical Centers                
>>>--------------------------------------------------------------------
>>>Thomas Good                          tomg@ { admin | q8 } .nrnet.org
>>>Programmer/Analyst                              Phone:  718-818-5528 
>>>Behavioral Health Services                      Fax:    718-818-5056  
>>>Residential Services                            Mobile: 917-282-7359  
>>>--------------------------------------------------------------------
>>>/*         Rekordmeister ist nur der FC Bayern München!           */
>>>--------------------------------------------------------------------
>>>
>>>
>>>
>>
>>-- 
>>_____________________________________________________________
>>
>>Oscar Buijten
>>
>>Tel: +33.4.67.57.97.45
>>Fax: +33.4.67.57.97.46
>>GSM: +33.6.20.84.15.22
>>
>>Email: os...@el...
>>
>>Web:   www.elbie.com
>>
>>
>>
>>
>>
> 
> 
> --------------------------------------------------------------------
>               Saint Vincent Catholic Medical Centers                
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-818-5528 
> Behavioral Health Services                      Fax:    718-818-5056  
> Residential Services                            Mobile: 917-282-7359  
> --------------------------------------------------------------------
> /*         Rekordmeister ist nur der FC Bayern München!           */
> --------------------------------------------------------------------
> 
> 


-- 
_____________________________________________________________

Oscar Buijten

Tel: +33.4.67.57.97.45
Fax: +33.4.67.57.97.46
GSM: +33.6.20.84.15.22

Email: os...@el...

Web:   www.elbie.com

Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

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

On Tue, 30 Oct 2001, Oscar Buijten wrote:

> Hi Thomas,
>=20
> So then I thought, maybe there is some perl pgsql driver of some sort=20
> missing. This is the result:
> rpm -i postgresql-perl-7.1.3-1mdk.i586.rpm
> error: failed dependencies:
>          postgresql =3D 7.1.3-1mdk is needed by postgresql-perl-7.1.3-1md=
k
>          libpq.so.2   is needed by postgresql-perl-7.1.3-1mdk
>=20
> Is that because of this?:
>   psql -V

Hi Oscar - yes.  You are trying to install an rpm for a diff version
of Pg.  That will cause problems and here is another issue:

So, we must get the version mismatch sorted and then install the
missing libraries.

>=20
> Could I then just install: postgresql-libs-7.1.3-1mdk RPM for i586 ??
Dude.  I would use rpm (run man rpm to see the various options) to remove
all 7.0 postgres stuff prior to installing any 7.1 rpms.  You want to
be sure that all of your Pg stuff is the same version.  I will look around
here - I have a shell script to remove rpms and install the new ones.

BTW, you definitely want to use pg_dump to protect any data before you
make any sweeping changes as you will need to do a reload into 7.1
when you upgrade.  Postgres has no upgrade path for jumps in major
version numbers, i.e, 7.0 -> 7.1.  :-(


> > On Mon, 29 Oct 2001, Oscar Buijten wrote:
> >=20
> >=20
> >>Hi!
> >>
> >>Yesterday I have upgraded perl 5.6.1 (installed from source).
> >>Since then I have problems to use SQL-ledger....
> >>
> >>It seemed that I had lost DBI and DBD.
> >>So I have re-installed them (how to check the correctness??)...
> >>
> >=20
> > Hi Oscar,
> >=20
> > If you don't have any DBI.pm somewhere in ../site_perl/
> > (locate DBI | grep site_perl)
> > simply reinstall your drivers:
> > DBI first, followed by DBD-Pg
> >=20
> > It shouldn't be too much of a hassle.
> > So how do you like 5.6.1?
> >=20
> > Cheers,
> > Tom
> >=20
> > --------------------------------------------------------------------
> >               Saint Vincent Catholic Medical Centers               =20
> > --------------------------------------------------------------------
> > Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst                              Phone:  718-818-5528=20
> > Behavioral Health Services                      Fax:    718-818-5056 =
=20
> > Residential Services                            Mobile: 917-282-7359 =
=20
> > --------------------------------------------------------------------
> > /*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
> > --------------------------------------------------------------------
> >=20
> >=20
>=20
>=20
> --=20
> _____________________________________________________________
>=20
> Oscar Buijten
>=20
> Tel: +33.4.67.57.97.45
> Fax: +33.4.67.57.97.46
> GSM: +33.6.20.84.15.22
>=20
> Email: os...@el...
>=20
> Web:   www.elbie.com
>=20
>=20
>=20
>=20


--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

[Oscar B. <os...@el...>]

Hi Thomas,

So then I thought, maybe there is some perl pgsql driver of some sort 
missing. This is the result:
rpm -i postgresql-perl-7.1.3-1mdk.i586.rpm
error: failed dependencies:
         postgresql = 7.1.3-1mdk is needed by postgresql-perl-7.1.3-1mdk
         libpq.so.2   is needed by postgresql-perl-7.1.3-1mdk

Is that because of this?:
  psql -V
psql (PostgreSQL) 7.0.3

Could I then just install: postgresql-libs-7.1.3-1mdk RPM for i586 ??
Or would that destroy my smoothly functioning server?

Thanks!!

Oscar

Thomas Good wrote:

> On Mon, 29 Oct 2001, Oscar Buijten wrote:
> 
> 
>>Hi!
>>
>>Yesterday I have upgraded perl 5.6.1 (installed from source).
>>Since then I have problems to use SQL-ledger....
>>
>>It seemed that I had lost DBI and DBD.
>>So I have re-installed them (how to check the correctness??)...
>>
> 
> Hi Oscar,
> 
> If you don't have any DBI.pm somewhere in ../site_perl/
> (locate DBI | grep site_perl)
> simply reinstall your drivers:
> DBI first, followed by DBD-Pg
> 
> It shouldn't be too much of a hassle.
> So how do you like 5.6.1?
> 
> Cheers,
> Tom
> 
> --------------------------------------------------------------------
>               Saint Vincent Catholic Medical Centers                
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-818-5528 
> Behavioral Health Services                      Fax:    718-818-5056  
> Residential Services                            Mobile: 917-282-7359  
> --------------------------------------------------------------------
> /*         Rekordmeister ist nur der FC Bayern München!           */
> --------------------------------------------------------------------
> 
> 


-- 
_____________________________________________________________

Oscar Buijten

Tel: +33.4.67.57.97.45
Fax: +33.4.67.57.97.46
GSM: +33.6.20.84.15.22

Email: os...@el...

Web:   www.elbie.com

Re: Vendor Invoices etc.

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

On Wed, 24 Oct 2001, Dieter Simader wrote:

> You have to setup a service item for the phone charges in order to use on
> a vendor invoice. You could also split the phone bill into fixed and
> variable charges to keep track of i.e telephone rental and long distance.

Thanks Dieter.


Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: Upgraded to perl v5.6.1 => result: Error! No database drivers available

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

On Mon, 29 Oct 2001, Oscar Buijten wrote:

> Hi!
>=20
> Yesterday I have upgraded perl 5.6.1 (installed from source).
> Since then I have problems to use SQL-ledger....
>=20
> It seemed that I had lost DBI and DBD.
> So I have re-installed them (how to check the correctness??)...

Hi Oscar,

If you don't have any DBI.pm somewhere in ../site_perl/
(locate DBI | grep site_perl)
simply reinstall your drivers:
DBI first, followed by DBD-Pg

It shouldn't be too much of a hassle.
So how do you like 5.6.1?

Cheers,
Tom

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Upgraded to perl v5.6.1 => result: Error! No database drivers available

[Oscar B. <os...@el...>]

Hi!

Yesterday I have upgraded perl 5.6.1 (installed from source).
Since then I have problems to use SQL-ledger....

It seemed that I had lost DBI and DBD.
So I have re-installed them (how to check the correctness??)...

I do get the login.pl to see, but when I login I get an Internal Server 
Error. Trying to show the admin page I get Error! No database drivers 
available.

Other applications like phpPgAdmin, phpgroupware and relata do work 
correctly.

Here is the apache error_log

[Mon Oct 29 21:33:25 2001] [notice] Apache-AdvancedExtranetServer/1.3.19 
(Linux-Mandrake/3mdk) PHP/4.0.4pl1 mod_ssl/2.8.2 OpenSSL/0.9.6 
configured -- resuming normal operations
[Mon Oct 29 21:33:25 2001] [notice] suEXEC mechanism enabled (wrapper: 
/usr/sbin/suexec)
Unknown error
Compilation failed in require at /var/www/sql-ledger/login.pl line 77.
[Mon Oct 29 21:33:40 2001] [error] [client 192.168.1.6] Premature end of 
script headers: /var/www/sql-ledger/login.pl
Error: No database drivers available
Compilation failed in require at /var/www/sql-ledger/admin.pl line 104.



Can anyone help?? Pleeeeaaase!!

Thanks,

Oscar
-- 
_____________________________________________________________

Oscar Buijten

Tel: +33.4.67.57.97.45
Fax: +33.4.67.57.97.46
GSM: +33.6.20.84.15.22

Email: os...@el...

Web:   www.elbie.com

Charts of Accounts??

[Marko S. <Mar...@we...>]

Is anyone using the german SKR 03?

Marko

Upgrade from 1.4.5 to 1.6

[Neil J. <ne...@jo...>]

I'm trying to upgrade my sql-ledger version from 1.4.5 to 1.6. I ran 
psql database < upgrade-1.4-1.6.sql with no errors, moved the new sql-ledger 
directoryand files to the same location as the original, and then logged into 
http://localhost/sql-ledger/admin.pl to add a user. No probels until I try to 
save the user, at which time I get the following error:

Error!

User=HASH(0x82521f8).
I don't suppose anyone would know where I went wrong here would they?

Neil

migration to redhat 7.2

[Neil J. <ne...@jo...>]

I'm considering migrating my machine to redhat 7.2. As I understand it the 
postgresql rpms have changed with 7.2, and require a dump & restore. Are 
there any special procedures I need to do to eliminate any data lose?

Neil

FYI - Account Names

[Matt B. <ma...@li...>]

Sql Ledger Folks,

We found that putting double quote character (a pair, actually) in a GL
account name causes that account, and all succeeding accounts in account
number order, not to appear in the GL->Add Transaction drop down boxes.

We deleted our bad quotes, but maybe some extra escaping could be done.

Regards,


Matt


Matt Benjamin

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
pgr. 734-431-0118

Re: MySQL and sql-ledger?

[<gha...@fr...>]

On Wed, 24 Oct 2001, Ilkka . wrote:

> Actually I'm back to square one, and even a bit farther than that. I just 
> noticed that PostgreSQL server doesn't work with Win98. Oh well.

It doesn't work with Win98, or on Win98?  The machine running
Apache and SQL-Ledger doesn't have to be the machine running
PostgreSQL.  I have a picture library here which uses one machine
for the web server part, and another machine for PostgreSQL to
store names, descriptions, etc.

Re: MySQL and sql-ledger?

[Ilkka . <gon...@ho...>]

Actually I'm back to square one, and even a bit farther than that. I just 
noticed that PostgreSQL server doesn't work with Win98. Oh well.

I think I'll just start hacking Sql-ledger again. Somebody had mentioned a 
success, and it doesn't sound that impossible thing to do...(famous last 
words?).

Ilkka

>From: Dieter Simader <dsi...@sq...>
>To: "Ilkka ." <gon...@ho...>
>CC: sql...@li...
>Subject: Re: MySQL and sql-ledger?
>Date: Mon, 22 Oct 2001 15:17:59 -0600 (MDT)
>
>Make a list of what you actually need to have available for your webshop.
>Then decide how to go about tying in with SL or vice versa.
>
>If you just need to have current pricing information available at the
>webshop you can easily hack in another DBI connection to simultaneously
>update mySQL or go from the other side and update the SL tables from your
>webshop.
>
>
>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, 22 Oct 2001, Ilkka . wrote:
>
> >
> > I think this would not be that convienient, because the information in 
>those
> > databases are connected to each other. It's a web shop..
> >
> > >From: "Rod Roark" <ro...@su...>
> > >To: <sql...@li...>
> > >Subject: Re: MySQL and sql-ledger?
> > >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
> > >
> > >There's nothing to prevent you from running MySQL and PostgreSQL
> > >concurrently.  It would be a lot easier than hacking the code.
> > >
> > >Cheers,
> > >
> > >-- Rod
> > >    http://www.sunsetsystems.com/
> > >
> > >Ilkka . said:
> > > > Hi!
> > > >
> > > > My problem is that I really need to make to sql-ledger work with 
>MySQL.
> > >Not  because
> > > > MySQl would be better (probably it isn't) but because my other  
>software
> > >use MySQL,
> > > > and I don't want to change those.
> > > >
> > > > So, it would be great if womeone would write a brief list to point 
>out
> > >things and
> > > > files that should be modified. I guess Perl is not that big a  
>problem,
> > >but that list
> > > > would help a lot this searching-debugging-testing  process.
> > > >
> > > > Thanks,
> > > > Ilkka
> > >
> > >
> > >
> > >
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at 
>http://explorer.msn.com/intl.asp
> >
> >
> >
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: Vendor Invoices etc.

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

On Wed, 24 Oct 2001, tom poe wrote:

> Hi, Rod:  Try thinking about it this way:
> 
> Suppose your phone service was a subscription for a part number each month.  
> Would that make it easier?

Some.  Problem is when I try to create it I don't get Telephone as an
Expense 'Link' account and it wants an Income Account.  My take is a
service can only be something I provide not something I purchase and
don't resell.

Could it be in a later version of SL?  I'm running 1.6.6

Of course I could just whimp out and do an 'Add Transaction' in A/P
which works but what should go into the Invoice Number and the Order
Number is my other question.

I realize it is my understanding (what is a 'Vendor Invoice') getting in
the way.

> Or, better yet.  Do you have a setup [I haven't been able to get Apache to 
> recgonize sql-ledger, yet, so haven't looked], that is already in place for a 
> vendor invoice for something?

My business is 99% service.  The few things I've had to buy and then
resell either haven't been posted yet (...) or have been kludged in
while I tried to figure out what I'm doing.


Thanks for your help on this,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: Vendor Invoices etc.

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

You have to setup a service item for the phone charges in order to use on
a vendor invoice. You could also split the phone bill into fixed and
variable charges to keep track of i.e telephone rental and long distance.


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 Wed, 24 Oct 2001, Roderick A. Anderson wrote:

> As some back ground I finally took a basic book-keeping class offered by
> the local college.  It was totally paper based and sure gave me an
> appreciation of how much a computer helps.  :-)
> 
> One thing I haven't been able to figure out is how to post a bill for a
> service.  My phone service is provided by Verizon.  I get a bill early
> in the month with a due date near the end of the month.  I'd like to
> post the bill when it arrives and then pay it a little later - closer to
> the due date.
> 
> When I tried to create a Vendor Invoice it insisted on having a part
> number.  Do I need to create a part/service item for phone service?
> 
> Attempts to just do it as an Add Transaction in A/P confused me (not
> hard to do) about what to put in Invoice Number and Order Number.  An
> Add Transaction in the General Ledger just seemed the wrong thing to do.
> 
> Any points or thoughts?
> 
> 
> TIA,
> Rod
> 

Vendor Invoices etc.

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

As some back ground I finally took a basic book-keeping class offered by
the local college.  It was totally paper based and sure gave me an
appreciation of how much a computer helps.  :-)

One thing I haven't been able to figure out is how to post a bill for a
service.  My phone service is provided by Verizon.  I get a bill early
in the month with a due date near the end of the month.  I'd like to
post the bill when it arrives and then pay it a little later - closer to
the due date.

When I tried to create a Vendor Invoice it insisted on having a part
number.  Do I need to create a part/service item for phone service?

Attempts to just do it as an Add Transaction in A/P confused me (not
hard to do) about what to put in Invoice Number and Order Number.  An
Add Transaction in the General Ledger just seemed the wrong thing to do.

Any points or thoughts?


TIA,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Congratulations SQL-Ledger

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

Congratulations to Dieter and the others working on SQL-Ledger as a
Zonker's Product Pick in the November 2001 issue of Linux Magazine.
   Not sure what criteria is used but the blurp about SQL-Ledger was
quite nice.  Also it was the only product GNU GPL'd of the the eight
selected.


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: MySQL and sql-ledger?

[Tommie M. J. <tj...@at...>]

How do I unsubscribe to this list.
I've tried going here
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
to 'edit options' but I get a broken link.


http://www.atlantageek.com
Get inside Atlanta's Tech scene

Re: MySQL and sql-ledger?

[Ilkka . <gon...@ho...>]

It seems that I will write my code to use any SQL database through ODBC and 
let Sql-ledger use PostgreSQL.

Thanks for the input..helped to make this decision.

Sql-ledger using ODBC would be too cool though :)

>From: Dieter Simader <dsi...@sq...>
>To: "Ilkka ." <gon...@ho...>
>CC: sql...@li...
>Subject: Re: MySQL and sql-ledger?
>Date: Mon, 22 Oct 2001 15:17:59 -0600 (MDT)
>
>Make a list of what you actually need to have available for your webshop.
>Then decide how to go about tying in with SL or vice versa.
>
>If you just need to have current pricing information available at the
>webshop you can easily hack in another DBI connection to simultaneously
>update mySQL or go from the other side and update the SL tables from your
>webshop.
>
>
>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, 22 Oct 2001, Ilkka . wrote:
>
> >
> > I think this would not be that convienient, because the information in 
>those
> > databases are connected to each other. It's a web shop..
> >
> > >From: "Rod Roark" <ro...@su...>
> > >To: <sql...@li...>
> > >Subject: Re: MySQL and sql-ledger?
> > >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
> > >
> > >There's nothing to prevent you from running MySQL and PostgreSQL
> > >concurrently.  It would be a lot easier than hacking the code.
> > >
> > >Cheers,
> > >
> > >-- Rod
> > >    http://www.sunsetsystems.com/
> > >
> > >Ilkka . said:
> > > > Hi!
> > > >
> > > > My problem is that I really need to make to sql-ledger work with 
>MySQL.
> > >Not  because
> > > > MySQl would be better (probably it isn't) but because my other  
>software
> > >use MySQL,
> > > > and I don't want to change those.
> > > >
> > > > So, it would be great if womeone would write a brief list to point 
>out
> > >things and
> > > > files that should be modified. I guess Perl is not that big a  
>problem,
> > >but that list
> > > > would help a lot this searching-debugging-testing  process.
> > > >
> > > > Thanks,
> > > > Ilkka
> > >
> > >
> > >
> > >
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at 
>http://explorer.msn.com/intl.asp
> >
> >
> >
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: MySQL and sql-ledger?

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

Make a list of what you actually need to have available for your webshop.
Then decide how to go about tying in with SL or vice versa.

If you just need to have current pricing information available at the
webshop you can easily hack in another DBI connection to simultaneously
update mySQL or go from the other side and update the SL tables from your
webshop.


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, 22 Oct 2001, Ilkka . wrote:

> 
> I think this would not be that convienient, because the information in those 
> databases are connected to each other. It's a web shop..
> 
> >From: "Rod Roark" <ro...@su...>
> >To: <sql...@li...>
> >Subject: Re: MySQL and sql-ledger?
> >Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
> >
> >There's nothing to prevent you from running MySQL and PostgreSQL
> >concurrently.  It would be a lot easier than hacking the code.
> >
> >Cheers,
> >
> >-- Rod
> >    http://www.sunsetsystems.com/
> >
> >Ilkka . said:
> > > Hi!
> > >
> > > My problem is that I really need to make to sql-ledger work with MySQL. 
> >Not  because
> > > MySQl would be better (probably it isn't) but because my other  software 
> >use MySQL,
> > > and I don't want to change those.
> > >
> > > So, it would be great if womeone would write a brief list to point out  
> >things and
> > > files that should be modified. I guess Perl is not that big a  problem, 
> >but that list
> > > would help a lot this searching-debugging-testing  process.
> > >
> > > Thanks,
> > > Ilkka
> >
> >
> >
> >
> 
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> 
> 

=?iso-8859-1?Q?Re:_MySQL_and_sql-ledger=3F?=

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

Well obviously you have about 3 different ways to approach the problem: (1) rewrite sql-
ledger, (2) rewrite your mysql apps, or (3) write code that talks to both.  For what it's
worth the following is from the FAQ:

    "Although transactions are now supported with the InnoDB
    table handler the backend would still require a major
    rewrite to work with mySQL"

But maybe it's not that bad... best of luck...

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

Ilkka . said:
>
> I think this would not be that convienient, because the information in those
> databases are connected to each other. It's a web shop..
>
>>From: "Rod Roark" <ro...@su...>
>>To: <sql...@li...>
>>Subject: Re: MySQL and sql-ledger?
>>Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
>>
>>There's nothing to prevent you from running MySQL and PostgreSQL
>>concurrently.  It would be a lot easier than hacking the code.
>>
>>Cheers,
>>
>>-- Rod
>>    http://www.sunsetsystems.com/
>>
>>Ilkka . said:
>> > Hi!
>> >
>> > My problem is that I really need to make to sql-ledger work with MySQL.
>>Not  because
>> > MySQl would be better (probably it isn't) but because my other  software
>>use MySQL,
>> > and I don't want to change those.
>> >
>> > So, it would be great if womeone would write a brief list to point out
>>things and
>> > files that should be modified. I guess Perl is not that big a  problem,
>>but that list
>> > would help a lot this searching-debugging-testing  process.
>> >
>> > Thanks,
>> > Ilkka

Re: MySQL and sql-ledger?

[Ilkka . <gon...@ho...>]

I think this would not be that convienient, because the information in those 
databases are connected to each other. It's a web shop..

>From: "Rod Roark" <ro...@su...>
>To: <sql...@li...>
>Subject: Re: MySQL and sql-ledger?
>Date: Mon, 22 Oct 2001 13:26:14 -0700 (PDT)
>
>There's nothing to prevent you from running MySQL and PostgreSQL
>concurrently.  It would be a lot easier than hacking the code.
>
>Cheers,
>
>-- Rod
>    http://www.sunsetsystems.com/
>
>Ilkka . said:
> > Hi!
> >
> > My problem is that I really need to make to sql-ledger work with MySQL. 
>Not  because
> > MySQl would be better (probably it isn't) but because my other  software 
>use MySQL,
> > and I don't want to change those.
> >
> > So, it would be great if womeone would write a brief list to point out  
>things and
> > files that should be modified. I guess Perl is not that big a  problem, 
>but that list
> > would help a lot this searching-debugging-testing  process.
> >
> > Thanks,
> > Ilkka
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

=?iso-8859-1?Q?Re:_MySQL_and_sql-ledger=3F?=

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

There's nothing to prevent you from running MySQL and PostgreSQL
concurrently.  It would be a lot easier than hacking the code.

Cheers,

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

Ilkka . said:
> Hi!
>
> My problem is that I really need to make to sql-ledger work with MySQL. Not  because
> MySQl would be better (probably it isn't) but because my other  software use MySQL,
> and I don't want to change those.
>
> So, it would be great if womeone would write a brief list to point out  things and
> files that should be modified. I guess Perl is not that big a  problem, but that list
> would help a lot this searching-debugging-testing  process.
>
> Thanks,
> Ilkka

MySQL and sql-ledger?

[Ilkka . <gon...@ho...>]

Hi!

My problem is that I really need to make to sql-ledger work with MySQL. Not 
because MySQl would be better (probably it isn't) but because my other 
software use MySQL, and I don't want to change those.

So, it would be great if womeone would write a brief list to point out 
things and files that should be modified. I guess Perl is not that big a 
problem, but that list would help a lot this searching-debugging-testing 
process.

Thanks,
Ilkka


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: Creating Database Problem

[Paulo R. <pro...@vi...>]

> Peter Dabrowski wrote:
>=20
> Hi
>=20
> I was installing Sql-ledger v.1.6.8 During creation of new database
> I've got error:
>=20
> ERROR:parse error at or near "select" insert into tax (chart_id, rate)
> values ((select id from chart where
>=20
> accno=3D2310,0.0.7.);
>=20
> I could not progres any futher. I go back and selected Delete Database
> . New database was listed there
>=20
> So, it looks like there was uncompleted data base created. I was
> selecting Default chart of Accounts
>=20
> Regards
>=20
> Peter

Hello Peter,

which postgres version? under 7.1.3? Upgrade?

Cheers,
Paulo

--=20
Paulo Rodrigues
Professional Services / MIS
pro...@vi...

VIA NET.WORKS Portugal
http://www.vianetworks.pt
local touch global reach
-------------------------
Sabe quem tem acesso =E0 rede da sua empresa?
http://security.vianetworks.pt/sig/