[Kmymoney] Re: KMyMoney Digest, Vol 12, Issue 4

Thu Jul 28 06:07:59 CEST 2011

Y
El 27/07/2011 06:00, <kmymoney-request at kde.org> escribió:
> Send KMyMoney mailing list submissions to
> kmymoney at kde.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://mail.kde.org/mailman/listinfo/kmymoney
> or, via email, send a message with subject or body 'help' to
> kmymoney-request at kde.org
>
> You can reach the person managing the list at
> kmymoney-owner at kde.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of KMyMoney digest..."
>
>
> Today's Topics:
>
> 1. Re: KMyMoney Digest, Vol 12, Issue 3 (am-ph)
> 2. Re: KMyMoney Digest, Vol 12, Issue 3 (Fernando Vilas)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 26 Jul 2011 18:35:41 +0200
> From: am-ph <am_ph at gmx.de>
> Subject: [Kmymoney] Re: KMyMoney Digest, Vol 12, Issue 3
> To: kmymoney at kde.org
> Message-ID: <FC3E6042-F02E-4678-B638-18F8D54C0C5A at gmx.de>
> Content-Type: text/plain; charset="us-ascii"
>
>
> Hi Fernando,
>
> I just read that you are actually running your accounts on psql.
> After some trials I actually came to the conclusion that the whole
database connectivity issue was fake:
> - There is no problem in saving data into a database (both with mysql and
postgresql).
> - However, when trying to load data from the database, kmymoney either
crashes or hangs, with one notable exception:
> - If I save a virgin kmymoney-file (with only my name and one account
created), then I actually can load these data from the database.
> - This is not of much use either, as kmymoney then crashes as soon as I
try to open a ledger.
> So here are my questions:
> Which version of postgresql do you use: 9.1, 9.0, 8.4 or even some older
one?
> Which operating system do you use (so far I tried it on a mac via
macports)?
> Do you have to make adjustments of the database?
>
> Best wishes,
> Stefan
>
>
>
> Am 26.07.2011 um 12:00 schrieb kmymoney-request at kde.org:
>
>> Send KMyMoney mailing list submissions to
>> kmymoney at kde.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> https://mail.kde.org/mailman/listinfo/kmymoney
>> or, via email, send a message with subject or body 'help' to
>> kmymoney-request at kde.org
>>
>> You can reach the person managing the list at
>> kmymoney-owner at kde.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of KMyMoney digest..."
>> Today's Topics:
>>
>> 1. Re: Using postgresql with KMyMoney (Fernando Vilas)
>>
>> Von: Fernando Vilas <fvilas at iname.com>
>> Datum: 26. Juli 2011 04:15:33 MESZ
>> An: KMyMoney Users' mailing list <kmymoney at kde.org>
>> Betreff: [Kmymoney] Re: Using postgresql with KMyMoney
>> Antwort an: KMyMoney Users' mailing list <kmymoney at kde.org>
>>
>>
>> On Saturday, July 16, 2011 19:10:35 Sara wrote:
>>> Hi,
>>>
>>> Does anyone have any experience in getting Kmymoney to save as a
postgresql
>>> database?
>>>
>>> The option to save as postgresql is not shown in the Database Type
listbox
>>> under the File -> Save as database... menu. I am using KMyMoney version
>>> 4.5.3 and have libqsqlpsql.so installed in
/usr/lib/qt/plugins/sqldrivers.
>>> Postgresql is also installed in my system.
>>>
>>> On another note, only the SQLite Version 3 works (MySQL and Open
Database
>>> Connectivity does not).
>>>
>>
>> Sara,
>>
>> I run my accounts on a PostgreSQL server without any trouble. If you are
>> on a 64 bit system, the driver may need to be in
>> /usr/lib64/qt/plugins/sqldrivers. The list of drivers on the menu is
obtained
>> by asking Qt what drivers are available, so for some reason it is not
finding
>> it.
>>
>> We also have people who use MySQL. I test the code against it sometimes,
>> but I do not use it for KMM regularly. However, I do not know if anyone
has
>> tested ODBC at all.
>>
>> Sorry for the delay in the response. I was on vacation for a couple of
>> weeks.
>>
>> --
>> Thanks,
>> Fernando Vilas
>> fvilas at iname.com
>>
>>
>> _______________________________________________
>> KMyMoney mailing list
>> KMyMoney at kde.org
>> https://mail.kde.org/mailman/listinfo/kmymoney
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
http://mail.kde.org/pipermail/kmymoney/attachments/20110726/c8e7e795/attachment-0001.htm
>
> ------------------------------
>
> Message: 2
> Date: Tue, 26 Jul 2011 21:07:37 -0500
> From: Fernando Vilas <fvilas at iname.com>
> Subject: [Kmymoney] Re: KMyMoney Digest, Vol 12, Issue 3
> To: KMyMoney Users' mailing list <kmymoney at kde.org>
> Message-ID: <1885149.IEqKf7zdN2 at asus>
> Content-Type: text/plain; charset="us-ascii"
>
> On Tuesday, July 26, 2011 18:35:41 am-ph wrote:
>> Hi Fernando,
>>
>> I just read that you are actually running your accounts on psql.
>> After some trials I actually came to the conclusion that the whole
database
>> connectivity issue was fake: - There is no problem in saving data into a
>> database (both with mysql and postgresql). - However, when trying to load
>> data from the database, kmymoney either crashes or hangs, with one
notable
>> exception: - If I save a virgin kmymoney-file (with only my name and one
>> account created), then I actually can load these data from the database.
-
>> This is not of much use either, as kmymoney then crashes as soon as I try
>> to open a ledger. So here are my questions:
>> Which version of postgresql do you use: 9.1, 9.0, 8.4 or even some older
>> one? Which operating system do you use (so far I tried it on a mac via
>> macports)? Do you have to make adjustments of the database?
>>
>> Best wishes,
>> Stefan
>
> Stefan,
>
> I have used various pgsql versions from as far back as the 8.0 series
> with KMM. I may have used a 7.x series. I know I used it for other things,
but
> I cannot remember if I used it for KMM. Right now, I am running 9.0.4.
>
> I also remember the couple of bugs you reported to the list in March
> regarding this. I have so far been unable to duplicate the problem, but
then
> again, I do not own a Mac.
>
> The database backend has been tested on Linux against MySQL, PostgreSQL,
> and SQLite. I have tested it on Slackware (32 and 64 bit), and other devs
have
> tested it on their distributions as well.
>
> I suspect that this is a Mac-specific issue. If one of the devs has access

> to one, some help would be appreciated. And Stefan, if you want to help
debug,
> we can walk you through some of that process as well.
>
> --
> Thanks,
> Fernando Vilas
> fvilas at iname.com
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: application/pgp-signature
> Size: 198 bytes
> Desc: This is a digitally signed message part.
> Url :
http://mail.kde.org/pipermail/kmymoney/attachments/20110726/24cf5dcf/attachment-0001.sig
>
> ------------------------------
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
>
> End of KMyMoney Digest, Vol 12, Issue 4
> ***************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kmymoney/attachments/20110728/992e1489/attachment.htm