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

[am-ph]

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