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