[GNC] MySQL backend

[John Ralls]

https://bugs.gnucash.org/show_bug.cgi?id=798992 Reports that after upgrading to 
MariaDB 11 on their servers, two Windows users are unable to work with their 
GnuCash databases. GnuCash appears to connect but DBI thinks that numeric 
variables are strings and, since it's expecting numbers, declines to read them.

Has anyone using GnuCash on macOS or Linux experienced this problem?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

Hi Adrien and John

Follow suggestion, I confirmed about status of SSL support @ MySQL
8.0.28 server as result below
| have_openssl| YES |
| have_ssl| YES |
It is enabled default even I have never configure about SSL (Msg: CA
certificate ca.pem is self signed).

Next, I tried to disable SSL support as result below
| have_openssl| DISABLED |
| have_ssl| DISABLED |
GnuCash @ MACOS work!

Summarize:
MySQL 8.0.23 & 8.0.28 configure same, SSL enabled as default.
In Ubuntu, MySQL 8.023 & 8.0.28 work fine.
In MACOS, MySQL 8.023 work fine, 8.0.28 work failed.

Root cause is libdbi still I guess.
Therefore I disable SSL as workaround until issue fixed.

Thanks a lot.
Neko


Neko Chang  於 2022年3月17日 週四 下午1:39寫道：
>
> All version of MySQL using  DB name = gnucash, never change.
>
> I have never setup and using SSL in MySQL.
> Remote access via SSH tunnel.
> Therefore the error message "SSL certificate issue" is strange as me
> I will try to search it.
>
> Thanks
>
>
> Adrien Monteleone  於 2022年3月17日 週四 下午1:09寫道：
> >
> > As John mentioned, the db name seems incorrect. Did you register the db
> > on MacOS?
> >
> > Error 2026 deals with SSL certificate issues.
> >
> > A web search should provide some guidance.
> >
> > Maybe try without SSL to see if that resolves it? Then you can
> > troubleshoot the SSL problem.
> >
> > -
> > And again, why do you think you need MySQL? What are you trying to
> > accomplish?
> >
> > Regards,
> > Adrien
> >
> > On 3/16/22 10:40 PM, Neko Chang wrote:
> > > Thank you for the clarification.
> > >
> > > Hi Adrien
> > > I am using MySQL @ FreeBSD remote mainly,
> > > MySQL @ MACOS for the issue tested.
> > > GNUCASH @ MACOS work fine both MySQL v8.0.23.
> > >
> > > Hi Josh
> > > Either MySQL v8.0.23 or v8.0.28, all parameter
> > > same(user/password/database name).
> > > Therefore issue caused from libdbi I guess.
> > >
> > > The issue would not be resolve.
> > > I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue.
> > >
> > > Regards
> > > Neko
> > >
> > > john  於 2022年3月17日 週四 上午11:13寫道：
> > >>
> > >> Neko,
> > >>
> > >> AFAiCT this has nothing to do with macOS but rather that your MySQL 
> > >> server doesn't recognize the database name you passed it plus another 
> > >> error, number 2026, that GnuCash doesn't know how to handle.
> > >>
> > >> As a reminder, users using the MySQL or Postgresql backends *must* be 
> > >> *expert* database administrators for the respective servers. The GnuCash 
> > >> team most emphatically are not and cannot provide any support for 
> > >> database server problems. If you are not a MySQL expert then you should 
> > >> use the SQLite3 or XML backends which don't require DB Admin skills.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> Regards,
> Wei-Jen Chang



-- 
Regards,
Wei-Jen Chang
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

All version of MySQL using  DB name = gnucash, never change.

I have never setup and using SSL in MySQL.
Remote access via SSH tunnel.
Therefore the error message "SSL certificate issue" is strange as me
I will try to search it.

Thanks


Adrien Monteleone  於 2022年3月17日 週四 下午1:09寫道：
>
> As John mentioned, the db name seems incorrect. Did you register the db
> on MacOS?
>
> Error 2026 deals with SSL certificate issues.
>
> A web search should provide some guidance.
>
> Maybe try without SSL to see if that resolves it? Then you can
> troubleshoot the SSL problem.
>
> -
> And again, why do you think you need MySQL? What are you trying to
> accomplish?
>
> Regards,
> Adrien
>
> On 3/16/22 10:40 PM, Neko Chang wrote:
> > Thank you for the clarification.
> >
> > Hi Adrien
> > I am using MySQL @ FreeBSD remote mainly,
> > MySQL @ MACOS for the issue tested.
> > GNUCASH @ MACOS work fine both MySQL v8.0.23.
> >
> > Hi Josh
> > Either MySQL v8.0.23 or v8.0.28, all parameter
> > same(user/password/database name).
> > Therefore issue caused from libdbi I guess.
> >
> > The issue would not be resolve.
> > I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue.
> >
> > Regards
> > Neko
> >
> > john  於 2022年3月17日 週四 上午11:13寫道：
> >>
> >> Neko,
> >>
> >> AFAiCT this has nothing to do with macOS but rather that your MySQL server 
> >> doesn't recognize the database name you passed it plus another error, 
> >> number 2026, that GnuCash doesn't know how to handle.
> >>
> >> As a reminder, users using the MySQL or Postgresql backends *must* be 
> >> *expert* database administrators for the respective servers. The GnuCash 
> >> team most emphatically are not and cannot provide any support for database 
> >> server problems. If you are not a MySQL expert then you should use the 
> >> SQLite3 or XML backends which don't require DB Admin skills.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
Regards,
Wei-Jen Chang
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Adrien Monteleone]

As John mentioned, the db name seems incorrect. Did you register the db 
on MacOS?


Error 2026 deals with SSL certificate issues.

A web search should provide some guidance.

Maybe try without SSL to see if that resolves it? Then you can 
troubleshoot the SSL problem.


-
And again, why do you think you need MySQL? What are you trying to 
accomplish?


Regards,
Adrien

On 3/16/22 10:40 PM, Neko Chang wrote:

Thank you for the clarification.

Hi Adrien
I am using MySQL @ FreeBSD remote mainly,
MySQL @ MACOS for the issue tested.
GNUCASH @ MACOS work fine both MySQL v8.0.23.

Hi Josh
Either MySQL v8.0.23 or v8.0.28, all parameter
same(user/password/database name).
Therefore issue caused from libdbi I guess.

The issue would not be resolve.
I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue.

Regards
Neko

john  於 2022年3月17日 週四 上午11:13寫道：


Neko,

AFAiCT this has nothing to do with macOS but rather that your MySQL server 
doesn't recognize the database name you passed it plus another error, number 
2026, that GnuCash doesn't know how to handle.

As a reminder, users using the MySQL or Postgresql backends *must* be *expert* 
database administrators for the respective servers. The GnuCash team most 
emphatically are not and cannot provide any support for database server 
problems. If you are not a MySQL expert then you should use the SQLite3 or XML 
backends which don't require DB Admin skills.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

Thank you for the clarification.

Hi Adrien
I am using MySQL @ FreeBSD remote mainly,
MySQL @ MACOS for the issue tested.
GNUCASH @ MACOS work fine both MySQL v8.0.23.

Hi Josh
Either MySQL v8.0.23 or v8.0.28, all parameter
same(user/password/database name).
Therefore issue caused from libdbi I guess.

The issue would not be resolve.
I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue.

Regards
Neko

john  於 2022年3月17日 週四 上午11:13寫道：
>
> Neko,
>
> AFAiCT this has nothing to do with macOS but rather that your MySQL server 
> doesn't recognize the database name you passed it plus another error, number 
> 2026, that GnuCash doesn't know how to handle.
>
> As a reminder, users using the MySQL or Postgresql backends *must* be 
> *expert* database administrators for the respective servers. The GnuCash team 
> most emphatically are not and cannot provide any support for database server 
> problems. If you are not a MySQL expert then you should use the SQLite3 or 
> XML backends which don't require DB Admin skills.
>
> Regards
> John Ralls
>
>
> > On Mar 16, 2022, at 6:31 PM, Neko Chang  wrote:
> >
> > Hi All
> > I have no idea how to run on MACOS still.
> > Can help/information for it?
> > Thanks a lot
> >
> >>
> >> Hi gnucash-user
> >>
> >> I had been encounter as subject, can help to resolve?
> >>
> >> Detail:
> >> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> >> @ MySQL 8.0.23
> >> After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
> >> MACOS 12 won't.
> >>
> >> Log as below, generate by
> >> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
> >> --logto stdout
> >>* 21:32:54 INFO  [QofSessionImpl::load_backend] The
> >> provider providers access_method, file, but we're loading for
> >> access_method, mysql. Skipping.
> >>* 21:32:54 INFO  [QofSessionImpl::load_backend] The
> >> provider providers access_method, sqlite3, but we're loading for
> >> access_method, mysql. Skipping.
> >>* 21:32:54 INFO  [QofSessionImpl::load_backend]
> >> Selected provider GnuCash Libdbi (MYSQL) Backend
> >>* 21:32:54 INFO  [error_handler] DBI error: -5:
> >> An invalid name was passed to libdbi
> >>* 21:32:54 INFO  [error_handler] Note:
> >> GbcDbiSqlConnection not yet initialized. Skipping further error
> >> processing.
> >>* 21:32:54 INFO  [error_handler] DBI error: 2026:
> >> SSL connection error: unknown error number
> >>* 21:32:54 INFO  [error_handler] Note:
> >> GbcDbiSqlConnection not yet initialized. Skipping further error
> >> processing.
> >>* 21:32:54 ERROR 
> >> [GncDbiBackend::session_begin()] Unable to connect
> >> to database 'gnucash'
> >>* 21:32:54 INFO  [QofSessionImpl::begin] Done running
> >> session_begin on backend
> >>
> >> Root cause version of libdbi maybe I guess.
> >> Package in Ubuntu 20 = 1.9.0
> >> Bundle in Gnucash = 1.8.? (by Google)
> >>
> >> Using package version of libdbi in MACOS possible?
> >> Or work-around/solution/fix at next version?
> >>
> >> Thanks very much.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>


-- 
Regards,
Wei-Jen Chang
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[john]

Neko,

AFAiCT this has nothing to do with macOS but rather that your MySQL server 
doesn't recognize the database name you passed it plus another error, number 
2026, that GnuCash doesn't know how to handle.

As a reminder, users using the MySQL or Postgresql backends *must* be *expert* 
database administrators for the respective servers. The GnuCash team most 
emphatically are not and cannot provide any support for database server 
problems. If you are not a MySQL expert then you should use the SQLite3 or XML 
backends which don't require DB Admin skills.

Regards
John Ralls


> On Mar 16, 2022, at 6:31 PM, Neko Chang  wrote:
> 
> Hi All
> I have no idea how to run on MACOS still.
> Can help/information for it?
> Thanks a lot
> 
>> 
>> Hi gnucash-user
>> 
>> I had been encounter as subject, can help to resolve?
>> 
>> Detail:
>> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
>> @ MySQL 8.0.23
>> After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
>> MACOS 12 won't.
>> 
>> Log as below, generate by
>> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
>> --logto stdout
>>* 21:32:54 INFO  [QofSessionImpl::load_backend] The
>> provider providers access_method, file, but we're loading for
>> access_method, mysql. Skipping.
>>* 21:32:54 INFO  [QofSessionImpl::load_backend] The
>> provider providers access_method, sqlite3, but we're loading for
>> access_method, mysql. Skipping.
>>* 21:32:54 INFO  [QofSessionImpl::load_backend]
>> Selected provider GnuCash Libdbi (MYSQL) Backend
>>* 21:32:54 INFO  [error_handler] DBI error: -5:
>> An invalid name was passed to libdbi
>>* 21:32:54 INFO  [error_handler] Note:
>> GbcDbiSqlConnection not yet initialized. Skipping further error
>> processing.
>>* 21:32:54 INFO  [error_handler] DBI error: 2026:
>> SSL connection error: unknown error number
>>* 21:32:54 INFO  [error_handler] Note:
>> GbcDbiSqlConnection not yet initialized. Skipping further error
>> processing.
>>* 21:32:54 ERROR 
>> [GncDbiBackend::session_begin()] Unable to connect
>> to database 'gnucash'
>>* 21:32:54 INFO  [QofSessionImpl::begin] Done running
>> session_begin on backend
>> 
>> Root cause version of libdbi maybe I guess.
>> Package in Ubuntu 20 = 1.9.0
>> Bundle in Gnucash = 1.8.? (by Google)
>> 
>> Using package version of libdbi in MACOS possible?
>> Or work-around/solution/fix at next version?
>> 
>> Thanks very much.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Adrien Monteleone]

You have to install MySQL/MariaDB on MacOS separately as far as I 
recall. (then save the file in that backend format)


But before you go through all of that trouble, what advantages do you 
think you will gain by using the MySQL backend vs. XML or SQLite?


Regards,
Adrien

On 3/16/22 8:31 PM, Neko Chang wrote:

Hi All
I have no idea how to run on MACOS still.
Can help/information for it?
Thanks a lot



Hi gnucash-user

I had been encounter as subject, can help to resolve?

Detail:
I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
@ MySQL 8.0.23
After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
MACOS 12 won't.

Log as below, generate by
/Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
--logto stdout
 * 21:32:54 INFO  [QofSessionImpl::load_backend] The
provider providers access_method, file, but we're loading for
access_method, mysql. Skipping.
 * 21:32:54 INFO  [QofSessionImpl::load_backend] The
provider providers access_method, sqlite3, but we're loading for
access_method, mysql. Skipping.
 * 21:32:54 INFO  [QofSessionImpl::load_backend]
Selected provider GnuCash Libdbi (MYSQL) Backend
 * 21:32:54 INFO  [error_handler] DBI error: -5:
An invalid name was passed to libdbi
 * 21:32:54 INFO  [error_handler] Note:
GbcDbiSqlConnection not yet initialized. Skipping further error
processing.
 * 21:32:54 INFO  [error_handler] DBI error: 2026:
SSL connection error: unknown error number
 * 21:32:54 INFO  [error_handler] Note:
GbcDbiSqlConnection not yet initialized. Skipping further error
processing.
 * 21:32:54 ERROR 
[GncDbiBackend::session_begin()] Unable to connect
to database 'gnucash'
 * 21:32:54 INFO  [QofSessionImpl::begin] Done running
session_begin on backend

Root cause version of libdbi maybe I guess.
Package in Ubuntu 20 = 1.9.0
Bundle in Gnucash = 1.8.? (by Google)

Using package version of libdbi in MACOS possible?
Or work-around/solution/fix at next version?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

Hi All
I have no idea how to run on MACOS still.
Can help/information for it?
Thanks a lot

>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @ MySQL 8.0.23
> After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
> MACOS 12 won't.
>
> Log as below, generate by
> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
> --logto stdout
> * 21:32:54 INFO  [QofSessionImpl::load_backend] The
> provider providers access_method, file, but we're loading for
> access_method, mysql. Skipping.
> * 21:32:54 INFO  [QofSessionImpl::load_backend] The
> provider providers access_method, sqlite3, but we're loading for
> access_method, mysql. Skipping.
> * 21:32:54 INFO  [QofSessionImpl::load_backend]
> Selected provider GnuCash Libdbi (MYSQL) Backend
> * 21:32:54 INFO  [error_handler] DBI error: -5:
> An invalid name was passed to libdbi
> * 21:32:54 INFO  [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
> * 21:32:54 INFO  [error_handler] DBI error: 2026:
> SSL connection error: unknown error number
> * 21:32:54 INFO  [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
> * 21:32:54 ERROR 
> [GncDbiBackend::session_begin()] Unable to connect
> to database 'gnucash'
> * 21:32:54 INFO  [QofSessionImpl::begin] Done running
> session_begin on backend
>
> Root cause version of libdbi maybe I guess.
> Package in Ubuntu 20 = 1.9.0
> Bundle in Gnucash = 1.8.? (by Google)
>
> Using package version of libdbi in MACOS possible?
> Or work-around/solution/fix at next version?
>
> Thanks very much.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

Hi All
I have no idea how to run on MACOS still.
Can help/information for it?

Thanks a lot

Neko Chang  於 2022年2月17日 週四 下午2:16寫道：
>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @ MySQL 8.0.23
> After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
> MACOS 12 won't.
>
> Log as below, generate by
> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
> --logto stdout
> * 21:32:54 INFO  [QofSessionImpl::load_backend] The
> provider providers access_method, file, but we're loading for
> access_method, mysql. Skipping.
> * 21:32:54 INFO  [QofSessionImpl::load_backend] The
> provider providers access_method, sqlite3, but we're loading for
> access_method, mysql. Skipping.
> * 21:32:54 INFO  [QofSessionImpl::load_backend]
> Selected provider GnuCash Libdbi (MYSQL) Backend
> * 21:32:54 INFO  [error_handler] DBI error: -5:
> An invalid name was passed to libdbi
> * 21:32:54 INFO  [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
> * 21:32:54 INFO  [error_handler] DBI error: 2026:
> SSL connection error: unknown error number
> * 21:32:54 INFO  [error_handler] Note:
> GbcDbiSqlConnection not yet initialized. Skipping further error
> processing.
> * 21:32:54 ERROR 
> [GncDbiBackend::session_begin()] Unable to connect
> to database 'gnucash'
> * 21:32:54 INFO  [QofSessionImpl::begin] Done running
> session_begin on backend
>
> Root cause version of libdbi maybe I guess.
> Package in Ubuntu 20 = 1.9.0
> Bundle in Gnucash = 1.8.? (by Google)
>
> Using package version of libdbi in MACOS possible?
> Or work-around/solution/fix at next version?
>
> Thanks very much.
> --
> Regards,
> Wei-Jen Chang



-- 
Regards,
Wei-Jen Chang
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[D. via gnucash-user]

Henrik, 

As the third David on this thread, I fully echo what the other two have said, 
but will further add that if you are hoping to access the data serially and 
singly from a common location, the default XML file format can work equally 
effectively. And you don't have to maintain a MySQL server. 

David T.


 Original Message 
From: davidcousen...@gmail.com
Sent: Sun Mar 13 18:28:45 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] MySQL

Henrik,

I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
  
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data file without significant risk of
error. The libraries and routines for SQL access currently do not have the
record locking capability to support multiple simultaneous use. You will need to
establish administrative protocols, if using several computers to access
GNuCash, to ensure such access is not simultaneous.

I would initially trial testing on a single computer which is also running the
MySQL server supplying the data, to ensure there are no server installation
problems before trying to access the server remotely.  Once this is functioning
you can then be reasonably sure that any remote access problems are
communication/permissions issues and not intrinsic issues within GnuCash.
David Cousens

On Sun, 2022-03-13 at 18:37 +, Henrik Morsing wrote:
> Hi,
> 
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though, is
> this expected? Half the time is just hangs and says "The server experienced
> and error..." even though I can connect and log in manually with no issues.
> 
> Thanks for any tips

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[davidcousens49]

Henrik,

I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
  
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data file without significant risk of
error. The libraries and routines for SQL access currently do not have the
record locking capability to support multiple simultaneous use. You will need to
establish administrative protocols, if using several computers to access
GNuCash, to ensure such access is not simultaneous.

I would initially trial testing on a single computer which is also running the
MySQL server supplying the data, to ensure there are no server installation
problems before trying to access the server remotely.  Once this is functioning
you can then be reasonably sure that any remote access problems are
communication/permissions issues and not intrinsic issues within GnuCash.
David Cousens

On Sun, 2022-03-13 at 18:37 +, Henrik Morsing wrote:
> Hi,
> 
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though, is
> this expected? Half the time is just hangs and says "The server experienced
> and error..." even though I can connect and log in manually with no issues.
> 
> Thanks for any tips

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[David Carlson]

Henrik,

The GnuCash program alone is very stable and reliable.  It can work with
local data files directly or remote data files using third party or network
software.  Whatever reliability issue you are having is most likely an
external one.

It is not required to use the mysql database format to access the same data
file from multiple computers,  but not simultaneously in that or any other
format.

The developers focus mainly on the program rather than the user's
environment,  but they or other users here can often help with specific
details in a given situation.

It would help to know what version of GnuCash you are using,  what OS you
are running it in, and, since you want to access your data remotely,  how
you are trying to do that.

On Sun, Mar 13, 2022, 1:38 PM Henrik Morsing  wrote:

>
> Hi,
>
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though,
> is this expected? Half the time is just hangs and says "The server
> experienced and error..." even though I can connect and log in manually
> with no issues.
>
> Thanks for any tips
> --
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL

[Henrik Morsing]

Hi,

I'm new to GnuCash but really wanted it to save to MySQL so I could easily access it form 
different locations. It seems extremely un-reliable though, is this expected? Half the 
time is just hangs and says "The server experienced and error..." even though I 
can connect and log in manually with no issues.

Thanks for any tips
--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[Neko Chang]

Hi gnucash-user

I had been encounter as subject, can help to resolve?

Detail:
I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
@ MySQL 8.0.23
After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
MACOS 12 won't.

Log as below, generate by
/Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra
--logto stdout
* 21:32:54 INFO  [QofSessionImpl::load_backend] The
provider providers access_method, file, but we're loading for
access_method, mysql. Skipping.
* 21:32:54 INFO  [QofSessionImpl::load_backend] The
provider providers access_method, sqlite3, but we're loading for
access_method, mysql. Skipping.
* 21:32:54 INFO  [QofSessionImpl::load_backend]
Selected provider GnuCash Libdbi (MYSQL) Backend
* 21:32:54 INFO  [error_handler] DBI error: -5:
An invalid name was passed to libdbi
* 21:32:54 INFO  [error_handler] Note:
GbcDbiSqlConnection not yet initialized. Skipping further error
processing.
* 21:32:54 INFO  [error_handler] DBI error: 2026:
SSL connection error: unknown error number
* 21:32:54 INFO  [error_handler] Note:
GbcDbiSqlConnection not yet initialized. Skipping further error
processing.
* 21:32:54 ERROR 
[GncDbiBackend::session_begin()] Unable to connect
to database 'gnucash'
* 21:32:54 INFO  [QofSessionImpl::begin] Done running
session_begin on backend

Root cause version of libdbi maybe I guess.
Package in Ubuntu 20 = 1.9.0
Bundle in Gnucash = 1.8.? (by Google)

Using package version of libdbi in MACOS possible?
Or work-around/solution/fix at next version?

Thanks very much.
-- 
Regards,
Wei-Jen Chang
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[Jim DeLaHunt]

Sure! Thank you for being willing to try new things. We are glad to help 
you learn, because more hands are better.


The right direction is the link on the main GnuCash.org page, left 
column, under "Support", labelled "Bug Reports". It points to an 
introduction page, >. Give that a read.


You may find that some of the instructions there are not clear. In that 
case, you can either improve the page yourself — it is a wiki; or report 
problems in this email thread, and we'll help you along. You may help us 
find where /we/ want to improve the instructions.


Don't worry if the bug report isn't perfect. Do your best, and then 
others can come in and polish it. The main thing is to make a record 
that the problem exists.


Thank you, Gord!
 —Jim DeLaHunt

On 2021-02-02 13:27, gnu Gord wrote:

I would be happy to open a bug report but I have no idea how to do it.
Can you point me in the right direction?


On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt > wrote:


Good catch, Gord!

On 2021-02-01 10:36, gnu Gord wrote:
> …It appears that mysql (or somewhere in the backend of gnuCash)
does not
> like a back slash character as the last character in a field.
The data I
> was trying to save had one entry with a 'notes' field that …  was
> "2 books one for A one for\".…
>
> Here are the relevant lines from the 'gnucash.trace' file:
>
> * 09:09:43 ERROR  [error_handler()] DBI error:
1064: You
> have an error in your SQL syntax; check the manual that
corresponds to your
> MariaDB server version for the right syntax to use near '1970-01-01
> 00:00:00',0,1)' at line 1
> * 09:09:43 ERROR 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error
executing SQL
> INSERT INTO
>

slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books
one for A
> one for\','1970-01-01 00:00:00',0,1)
> * 09:09:43 ERROR 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT
INTO
>

slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books
one for A
> one for\','1970-01-01 00:00:00',0,1)
> * 09:09:43 ERROR  [GncSqlTransBackend::commit()]
> Transaction Chapters dated 2011-02-21 in account Gifts not saved
due to
> Slots save failed. Check trace log for SQL errors.

I encourage you to write a bug report in the GnuCash bug tracker
about
this problem. As a general matter, GnuCash should not let any text
you
type into a Notes field turn into a syntax error for the database. It
should wrap the Notes text in a way that prevents the syntax error
from
happening. I suspect that GnuCash does this kind of wrapping the
XML way
if the backend is XML, but doesn't do it the SQL way if the
database is SQL.

It's good to have people turn up errors with nice solid evidence like
you collected. Thanks!

Best regard,
  —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

I would be happy to open a bug report but I have no idea how to do it.
Can you point me in the right direction?


On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt  wrote:

> Good catch, Gord!
>
> On 2021-02-01 10:36, gnu Gord wrote:
> > …It appears that mysql (or somewhere in the backend of gnuCash) does not
> > like a back slash character as the last character in a field. The data I
> > was trying to save had one entry with a 'notes' field that …  was
> > "2 books one for A one for\".…
> >
> > Here are the relevant lines from the 'gnucash.trace' file:
> >
> > * 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
> > have an error in your SQL syntax; check the manual that corresponds to
> your
> > MariaDB server version for the right syntax to use near '1970-01-01
> > 00:00:00',0,1)' at line 1
> > * 09:09:43 ERROR 
> > [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> > INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR 
> > [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR  [GncSqlTransBackend::commit()]
> > Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
> > Slots save failed. Check trace log for SQL errors.
>
> I encourage you to write a bug report in the GnuCash bug tracker about
> this problem. As a general matter, GnuCash should not let any text you
> type into a Notes field turn into a syntax error for the database. It
> should wrap the Notes text in a way that prevents the syntax error from
> happening. I suspect that GnuCash does this kind of wrapping the XML way
> if the backend is XML, but doesn't do it the SQL way if the database is
> SQL.
>
> It's good to have people turn up errors with nice solid evidence like
> you collected. Thanks!
>
> Best regard,
>   —Jim DeLaHunt
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[Jim DeLaHunt]

Good catch, Gord!

On 2021-02-01 10:36, gnu Gord wrote:

…It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that …  was
"2 books one for A one for\".…

Here are the relevant lines from the 'gnucash.trace' file:

* 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '1970-01-01
00:00:00',0,1)' at line 1
* 09:09:43 ERROR 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR  [GncSqlTransBackend::commit()]
Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
Slots save failed. Check trace log for SQL errors.


I encourage you to write a bug report in the GnuCash bug tracker about 
this problem. As a general matter, GnuCash should not let any text you 
type into a Notes field turn into a syntax error for the database. It 
should wrap the Notes text in a way that prevents the syntax error from 
happening. I suspect that GnuCash does this kind of wrapping the XML way 
if the backend is XML, but doesn't do it the SQL way if the database is SQL.


It's good to have people turn up errors with nice solid evidence like 
you collected. Thanks!


Best regard,
 —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[Stephen M. Butler]

On 2/1/21 10:36 AM, gnu Gord wrote:

Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace'
file, I think I have discovered the problem.
It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that had a backslash
as the last character. The text was "2 books one for A one for\". It
appears when I save this as an XML file there is no problem but if I try to
save this as a mysql I get an error message. A backslash other than at the
end of the field does not appear to cause a problem.
BTW if I remove the backslash and successfully save to a mysql file and
then go back into the register GnuCash will not let me add a backslash to a
field. However, if I save it as an XML file the backslash is allowed.



Looks like you are on a Linux/Unix box.  The backslash is the escape 
character.  It probably ate the ending quote mark.
I think you can get the backslash by escaping it!  Yes, escape the 
escape character.  \\


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace'
file, I think I have discovered the problem.
It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that had a backslash
as the last character. The text was "2 books one for A one for\". It
appears when I save this as an XML file there is no problem but if I try to
save this as a mysql I get an error message. A backslash other than at the
end of the field does not appear to cause a problem.
BTW if I remove the backslash and successfully save to a mysql file and
then go back into the register GnuCash will not let me add a backslash to a
field. However, if I save it as an XML file the backslash is allowed.

Here are the relevant lines from the 'gnucash.trace' file:

* 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '1970-01-01
00:00:00',0,1)' at line 1
* 09:09:43 ERROR 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR  [GncSqlTransBackend::commit()]
Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
Slots save failed. Check trace log for SQL errors.


On Sun, Jan 31, 2021 at 9:14 PM Cam Ellison  wrote:

> On 2021-01-31 20:05, David Cousens wrote:
> > I don't have any experience of MySQL with GnuCash but I would try and
> > look at
> > logs for the MySQL server in  /var/log/mysql. If the problem is with
> > the
> > server rather than GnuCash itself, that may indicate it. Also check the
> > Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which
> > should
> > be in /tmp but is also located in /var/tmp on some systems.
>
> Looking in the logs will work only if logging is enabled, which in
> Debian it is not, by default. He'll have to set that.
>
> It is possible that the DB was saved correctly. 3.1M in XML is not very
> large, and I seem to recall encountering an error msg of some sort when
> I converted from XML. Using PHPMyAdmin or similar, or logging into mysql
> via CL as root should allow for determining whether the tables were
> created and loaded. Alternatively, try to load the DB as a new file.
>
> HTH
>
> Cam
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[Cam Ellison]

On 2021-01-31 20:05, David Cousens wrote:
I don't have any experience of MySQL with GnuCash but I would try and 
look at
logs for the MySQL server in  /var/log/mysql. If the problem is with 
the

server rather than GnuCash itself, that may indicate it. Also check the
Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which 
should

be in /tmp but is also located in /var/tmp on some systems.


Looking in the logs will work only if logging is enabled, which in 
Debian it is not, by default. He'll have to set that.


It is possible that the DB was saved correctly. 3.1M in XML is not very 
large, and I seem to recall encountering an error msg of some sort when 
I converted from XML. Using PHPMyAdmin or similar, or logging into mysql 
via CL as root should allow for determining whether the tables were 
created and loaded. Alternatively, try to load the DB as a new file.


HTH

Cam

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[David Cousens]

I don't have any experience of MySQL with GnuCash but I would try and look at
logs for the MySQL server in  /var/log/mysql. If the problem is with the
server rather than GnuCash itself, that may indicate it. Also check the
Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which should
be in /tmp but is also located in /var/tmp on some systems.

Also see
https://www.sumologic.com/blog/mysql-log-file-location/#:~:text=Platform%2DSpecific%20UNIX%2FLinux,-The%20official%20distributions=log%20or%20mysqld.,%2Fetc%2Fmysql%2Fmysql.
for MySQL logging

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[David Carlson]

That might be a permissions issue.   Recently I have had some problems when
GnuCash doesn't know how to gain access if it doesn't already have it in
Linux.  In my case it is a Samba problem.

On Sun, Jan 31, 2021, 7:45 PM gnu Gord  wrote:

> Thank you very much for the information. It seems the problem was that I
> had not installed the libdbd-mysql package. I did have the libdbi but not
> the mysql package. I also did not have the libdbd packages for pgsql or
> sqlite3 ... but I do now! and they now show up in gnucash as options for
> the 'save as' Data Format.
>
> The only problem I have now is when I try to save a larger database (about
> 3.1M in XML) I get an error. It seems to work OK with a smaller database.
> The error just says, "An error occurred while processing
> mysql://gord@localhost/gnucash."
> I tried starting gnucash with the --debug option but I did not get any
> error messages other than the one in the gui.
>
>
>
> On Sun, Jan 31, 2021 at 4:52 PM David Cousens 
> wrote:
>
> > It will depend on whether you have installed for the distributions
> > repositories using their software manager or whether you have installed a
> > flatpak version either from the repository or the GnuCash website.
> >
> > The flatpak versions often require specific permissions granted so they
> can
> > access the computer's peripherals as they are a protected sandbox setup.
> > If
> > you search the mailing list archives you will find more info on how to do
> > this. If it is a flatpak version this may be the problem rather than
> > GnuCash
> > itself although I would still expect the database options to appear in
> the
> > File -Save As dialogue but fail on the attempt to write to the database.
> >
> > That may indicate that it has been built without the basic libdbi
> support.
> > The libddi-mysql library is a run time library (similar libraries for
> > PostGRES and SQlite3) which has to be present at runtime.  You can check
> > that the libraries are loaded using the command "dpkg -l |grep libdb" in
> a
> > terminal which should list all the related installed packages. My Linux
> > MInt
> > 20.3 system has all three libdbd-mysql, libdbd-pgsql and libdbd-sqlite3
> > installed as well as the libdbi library (I also have the development
> header
> > file libdbi-dev as I build GnuCash from the tarball on the website).
> >
> > If you can let us know which Linux distribution and version number and
> the
> > GnuCash version which is installed and how you installed it (software
> > Manager, apt, or other) we may be able to give more specific advice.
> > Usually
> > the versions maintained by the distribution repositories are built with
> all
> > the normal default build options which should include the database
> > backends.
> >
> > Building from scratch is a possibility if all else fails. See
> > https://wiki.gnucash.org/wiki/Building_On_Linux for detailed
> instructions
> >
> > David Cousens
> >
> >
> >
> > -
> > David Cousens
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

Thank you very much for the information. It seems the problem was that I
had not installed the libdbd-mysql package. I did have the libdbi but not
the mysql package. I also did not have the libdbd packages for pgsql or
sqlite3 ... but I do now! and they now show up in gnucash as options for
the 'save as' Data Format.

The only problem I have now is when I try to save a larger database (about
3.1M in XML) I get an error. It seems to work OK with a smaller database.
The error just says, "An error occurred while processing
mysql://gord@localhost/gnucash."
I tried starting gnucash with the --debug option but I did not get any
error messages other than the one in the gui.



On Sun, Jan 31, 2021 at 4:52 PM David Cousens 
wrote:

> It will depend on whether you have installed for the distributions
> repositories using their software manager or whether you have installed a
> flatpak version either from the repository or the GnuCash website.
>
> The flatpak versions often require specific permissions granted so they can
> access the computer's peripherals as they are a protected sandbox setup.
> If
> you search the mailing list archives you will find more info on how to do
> this. If it is a flatpak version this may be the problem rather than
> GnuCash
> itself although I would still expect the database options to appear in the
> File -Save As dialogue but fail on the attempt to write to the database.
>
> That may indicate that it has been built without the basic libdbi support.
> The libddi-mysql library is a run time library (similar libraries for
> PostGRES and SQlite3) which has to be present at runtime.  You can check
> that the libraries are loaded using the command "dpkg -l |grep libdb" in a
> terminal which should list all the related installed packages. My Linux
> MInt
> 20.3 system has all three libdbd-mysql, libdbd-pgsql and libdbd-sqlite3
> installed as well as the libdbi library (I also have the development header
> file libdbi-dev as I build GnuCash from the tarball on the website).
>
> If you can let us know which Linux distribution and version number and the
> GnuCash version which is installed and how you installed it (software
> Manager, apt, or other) we may be able to give more specific advice.
> Usually
> the versions maintained by the distribution repositories are built with all
> the normal default build options which should include the database
> backends.
>
> Building from scratch is a possibility if all else fails. See
> https://wiki.gnucash.org/wiki/Building_On_Linux for detailed instructions
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[David Cousens]

It will depend on whether you have installed for the distributions
repositories using their software manager or whether you have installed a
flatpak version either from the repository or the GnuCash website. 

The flatpak versions often require specific permissions granted so they can
access the computer's peripherals as they are a protected sandbox setup.  If
you search the mailing list archives you will find more info on how to do
this. If it is a flatpak version this may be the problem rather than GnuCash
itself although I would still expect the database options to appear in the
File -Save As dialogue but fail on the attempt to write to the database.

That may indicate that it has been built without the basic libdbi support.
The libddi-mysql library is a run time library (similar libraries for
PostGRES and SQlite3) which has to be present at runtime.  You can check
that the libraries are loaded using the command "dpkg -l |grep libdb" in a
terminal which should list all the related installed packages. My Linux MInt
20.3 system has all three libdbd-mysql, libdbd-pgsql and libdbd-sqlite3
installed as well as the libdbi library (I also have the development header
file libdbi-dev as I build GnuCash from the tarball on the website).

If you can let us know which Linux distribution and version number and the
GnuCash version which is installed and how you installed it (software
Manager, apt, or other) we may be able to give more specific advice. Usually
the versions maintained by the distribution repositories are built with all
the normal default build options which should include the database backends.

Building from scratch is a possibility if all else fails. See
https://wiki.gnucash.org/wiki/Building_On_Linux for detailed instructions

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

 Thanks for the reply.
When I go to 'save as' the Data Format drop-down only has XML as an option,
unlike my Windows version that has Mysql and others.
I installed the Linux version using apt so I did not build it myself.
Perhaps the official package was built without this support? If so, would I
need to build from the source code to get the MySQL option?


On Sun, Jan 31, 2021 at 3:50 PM David Cousens 
wrote:

> If you select File-Saves As from the menu, you should see a drop down box
> labelled Data Format at the top of the dialog window. "xml" is selected by
> default.Click on the down arrow and select the format you wish to use.
>
> GnuCash is normally built by default with the support for the various
> database options. You would have had to use an explicit switch to turn it
> off during the build if you built GNuCash yourself.
>
> http://www.howtodoityourself.org/set-mysql-gnucash-backend.html  This may
> help with the general setup even though a bit dated. Note "$apt install
> libdbd-mysql"  is a support library which is not necessarily present during
> the build of GNuCash and may need to be explicitly installed
>
> To setup the MYSQL server on Linux a google search should give you a
> procedure appropriate for your OS.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[David Cousens]

If you select File-Saves As from the menu, you should see a drop down box
labelled Data Format at the top of the dialog window. "xml" is selected by
default.Click on the down arrow and select the format you wish to use. 

GnuCash is normally built by default with the support for the various
database options. You would have had to use an explicit switch to turn it
off during the build if you built GNuCash yourself.

http://www.howtodoityourself.org/set-mysql-gnucash-backend.html  This may
help with the general setup even though a bit dated. Note "$apt install
libdbd-mysql"  is a support library which is not necessarily present during
the build of GNuCash and may need to be explicitly installed

To setup the MYSQL server on Linux a google search should give you a
procedure appropriate for your OS.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql setup in linux (debian)

[Michael via gnucash-user]

I believe the first thing to check is libdbi, is it installed?  Mike

On Sun, 2021-01-31 at 14:56 -0800, gnu Gord wrote:
> Having some problems with mysql setup for linux.
> 
> I got the Windows version to work but don't seem to have the option
> to
> "save as" mysql in my linux version.
> Are there some instructions somewhere that talk about using/setting
> up
> mysql in linux?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] mysql setup in linux (debian)

[gnu Gord]

Having some problems with mysql setup for linux.

I got the Windows version to work but don't seem to have the option to
"save as" mysql in my linux version.
Are there some instructions somewhere that talk about using/setting up
mysql in linux?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL Backend on Amazon AWS?

[Ciarán]

Having problems

Server setup in AWS

When 'save as' the Local host Version into the AWS endpoint Msgbox becomes
non responsive and eventually crashes GnuCash 

The tables in cloud db are setup but I can excess any data.

And I can open the cloud db in the Gnucash UI but no accounts (as expected)

Has anybody got AWS MySQL server successfully working as GnuCash backend
yet?





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[w...@theprescotts.com]

Okay. I didn't realize you are just creating a label.

Ignore my comment.

Will

On 2020 Aug 18, at 08-18 22:21:20, John Ralls  wrote:

In the alias there *should* be a space in 'local host' to keep the OS from 
mistaking it for the hardcoded 'localhost' in the networking code.

Regards,
John Ralls

> On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote:
> 
> Probably should not be a space in "localhost".
> 
> Will
> 
> On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice  wrote:
> 
> You can set up the MySQL to point to 127.0.0.1 and the alias “local host”
> 
> On Tue, Aug 18, 2020 at 4:31 PM andy ngo  wrote:
> 
>> Thank you for your help.
>> 
>> I don't remember using Flatpak back then (too long ago, couldn't remember
>> 
>> exactly).
>> 
>> However, the problem is solved with Geert's suggestion to change
>> "localhost"
>> 
>> to 127.0.0.1
>> 
>> Cheers
>> 
>> andy
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> --
>> 
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> 
>> ___
>> 
>> gnucash-user mailing list
>> 
>> gnucash-user@gnucash.org
>> 
>> To update your subscription preferences or to unsubscribe:
>> 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> 
>> -
>> 
>> Please remember to CC this list on all your replies.
>> 
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[Joseph Vernice]

Yes, you are correct.  Siri did that.
Regards

On Tue, Aug 18, 2020 at 11:27 PM John Ralls  wrote:

> In the alias there *should* be a space in 'local host' to keep the OS from
> mistaking it for the hardcoded 'localhost' in the networking code.
>
>
>
> Regards,
>
> John Ralls
>
>
>
> > On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote:
>
> >
>
> > Probably should not be a space in "localhost".
>
> >
>
> > Will
>
> >
>
> > On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice 
> wrote:
>
> >
>
> > You can set up the MySQL to point to 127.0.0.1 and the alias “local host”
>
> >
>
> > On Tue, Aug 18, 2020 at 4:31 PM andy ngo  wrote:
>
> >
>
> >> Thank you for your help.
>
> >>
>
> >> I don't remember using Flatpak back then (too long ago, couldn't
> remember
>
> >>
>
> >> exactly).
>
> >>
>
> >> However, the problem is solved with Geert's suggestion to change
>
> >> "localhost"
>
> >>
>
> >> to 127.0.0.1
>
> >>
>
> >> Cheers
>
> >>
>
> >> andy
>
> >>
>
> >>
>
> >>
>
> >>
>
> >>
>
> >>
>
> >>
>
> >> --
>
> >>
>
> >> Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
> >>
>
> >> ___
>
> >>
>
> >> gnucash-user mailing list
>
> >>
>
> >> gnucash-user@gnucash.org
>
> >>
>
> >> To update your subscription preferences or to unsubscribe:
>
> >>
>
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> >>
>
> >> If you are using Nabble or Gmane, please see
>
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> >>
>
> >> -
>
> >>
>
> >> Please remember to CC this list on all your replies.
>
> >>
>
> >> You can do this by using Reply-To-List or Reply-All.
>
> >>
>
> >>
>
> > ___
>
> > gnucash-user mailing list
>
> > gnucash-user@gnucash.org
>
> > To update your subscription preferences or to unsubscribe:
>
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> > -
>
> > Please remember to CC this list on all your replies.
>
> > You can do this by using Reply-To-List or Reply-All.
>
> >
>
> > ___
>
> > gnucash-user mailing list
>
> > gnucash-user@gnucash.org
>
> > To update your subscription preferences or to unsubscribe:
>
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> > -
>
> > Please remember to CC this list on all your replies.
>
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> ___
>
> gnucash-user mailing list
>
> gnucash-user@gnucash.org
>
> To update your subscription preferences or to unsubscribe:
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> -
>
> Please remember to CC this list on all your replies.
>
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[John Ralls]

In the alias there *should* be a space in 'local host' to keep the OS from 
mistaking it for the hardcoded 'localhost' in the networking code.

Regards,
John Ralls

> On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote:
> 
> Probably should not be a space in "localhost".
> 
> Will
> 
> On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice  wrote:
> 
> You can set up the MySQL to point to 127.0.0.1 and the alias “local host”
> 
> On Tue, Aug 18, 2020 at 4:31 PM andy ngo  wrote:
> 
>> Thank you for your help.
>> 
>> I don't remember using Flatpak back then (too long ago, couldn't remember
>> 
>> exactly).
>> 
>> However, the problem is solved with Geert's suggestion to change
>> "localhost"
>> 
>> to 127.0.0.1
>> 
>> Cheers
>> 
>> andy
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> --
>> 
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> 
>> ___
>> 
>> gnucash-user mailing list
>> 
>> gnucash-user@gnucash.org
>> 
>> To update your subscription preferences or to unsubscribe:
>> 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> 
>> -
>> 
>> Please remember to CC this list on all your replies.
>> 
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[w...@theprescotts.com]

Probably should not be a space in "localhost".

Will

On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice  wrote:

You can set up the MySQL to point to 127.0.0.1 and the alias “local host”

On Tue, Aug 18, 2020 at 4:31 PM andy ngo  wrote:

> Thank you for your help.
> 
> I don't remember using Flatpak back then (too long ago, couldn't remember
> 
> exactly).
> 
> However, the problem is solved with Geert's suggestion to change
> "localhost"
> 
> to 127.0.0.1
> 
> Cheers
> 
> andy
> 
> 
> 
> 
> 
> 
> 
> --
> 
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> 
> ___
> 
> gnucash-user mailing list
> 
> gnucash-user@gnucash.org
> 
> To update your subscription preferences or to unsubscribe:
> 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> 
> -
> 
> Please remember to CC this list on all your replies.
> 
> You can do this by using Reply-To-List or Reply-All.
> 
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[Joseph Vernice]

You can set up the MySQL to point to 127.0.0.1 and the alias “local host”

On Tue, Aug 18, 2020 at 4:31 PM andy ngo  wrote:

> Thank you for your help.
>
> I don't remember using Flatpak back then (too long ago, couldn't remember
>
> exactly).
>
> However, the problem is solved with Geert's suggestion to change
> "localhost"
>
> to 127.0.0.1
>
> Cheers
>
> andy
>
>
>
>
>
>
>
> --
>
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
> ___
>
> gnucash-user mailing list
>
> gnucash-user@gnucash.org
>
> To update your subscription preferences or to unsubscribe:
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
> -
>
> Please remember to CC this list on all your replies.
>
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[andy ngo]

Thank you very much for your help.
The problem is solved with Geert's suggestion to change from localhost to
127.0.0.1
Cheers
Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[andy ngo]

Thank you for your help.
I don't remember using Flatpak back then (too long ago, couldn't remember
exactly). 
However, the problem is solved with Geert's suggestion to change "localhost"
to 127.0.0.1
Cheers
andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[andy ngo]

Hi Geert:
Yes, it works after I changed from "localhost" to "127.0.0.1"
Thank you very much 
Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[Joseph Vernice]

Can you open any MySQL database?  Need to find out if it's mysql 
installation or a connection issue.


On 8/17/2020 1:11 PM, andy ngo wrote:

Hi there:
Up to now, I've been used
Gnucash 3.2
in Ubuntu 18.04
with mysql 5.7.31

My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
  
Gnucash 4.1

Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04
with mysql 8.0.21

Now, I can't connect to mysql anymore.

I couldn't open the old file. Then I tried to create a new one, nothing
worked.

I did install
libdbi1 libdbi-dev
libdbd-mysql

I've used Gnucash since 2013.  Every time I changed a new computer (this is
the 4th time), I had this problem. The last time was in 2018. I'm getting
old now and I couldn't remember how I did fix it.

I did found some old topics in this forum about the same problems, but they
did not help.

What did I still miss?

Thank you very much
Andy







--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[Geert Janssens]

Op maandag 17 augustus 2020 19:11:13 CEST schreef andy ngo:
> Hi there:
> Up to now, I've been used
> Gnucash 3.2
> in Ubuntu 18.04
> with mysql 5.7.31
> 
> My old laptop is now too old and needs to retire.
> So I bought a new one and install Gnucash, mysql ...
> 
> Gnucash 4.1
> Build ID: Flathub 4.1-2
> Finance::Quote: 1.49
> in Ubuntu 20.04
> with mysql 8.0.21
> 
> Now, I can't connect to mysql anymore.
> 
> I couldn't open the old file. Then I tried to create a new one, nothing
> worked.
> 
> I did install
> libdbi1 libdbi-dev
> libdbd-mysql
> 
When using the flathub package, these are irrelevant. The gnucash flatpak 
should inlcude these.

> I've used Gnucash since 2013.  Every time I changed a new computer (this is
> the 4th time), I had this problem. The last time was in 2018. I'm getting
> old now and I couldn't remember how I did fix it.
> 
What db connection settings do you use ? If you use "localhost" instead of 
"127.0.0.1", that is 
likely the cause. The former will tell the mysql client to use unix file 
sockets. These are not 
permitted by default by the flatpak sandbox. You can enable permissions for 
this on your 
gnucash flatpak, though I don't know offhand where the unix socket is located. 
You'll have to 
figure that out first (it will look like a file on your system somewhere) and 
then use the flatpak 
override commmand to tell it to allow access to that file for the 
org.gnucash.GnuCash package.

Unsing 127.0.0.1 on the other hand will force mysql to use a real network 
connection. Those are 
not restricted in the gnucash flatpak.

More details on this issue can be found here:
https://github.com/flathub/org.gnucash.GnuCash/issues/17[1] 

Regards,

Geert


[1] https://github.com/flathub/org.gnucash.GnuCash/issues/17
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql gnucash

[Adrien Monteleone]

You were using the 3.2 Flatpak and it worked?

I'd suspect something with the Flatpak sandbox would be interfering.

Note, if you had to seek help on the list in 2018, you could search the 
list archives for that time period via your favorite search engine.


prepend your search terms with:

  site:lists.gnucash.org

and you should be limited to results only from the mailing list server.

Certainly, include as one of your terms, your name or e-mail address 
with a "+" in front to only give you results involving you. Then you can 
spot the proper thread(s) and refresh your memory on the 2018 solution.


Regards,
Adrien

On 8/17/20 12:11 PM, andy ngo wrote:

Hi there:
Up to now, I've been used
Gnucash 3.2
in Ubuntu 18.04
with mysql 5.7.31

My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
  
Gnucash 4.1

Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04
with mysql 8.0.21

Now, I can't connect to mysql anymore.

I couldn't open the old file. Then I tried to create a new one, nothing
worked.

I did install
libdbi1 libdbi-dev
libdbd-mysql

I've used Gnucash since 2013.  Every time I changed a new computer (this is
the 4th time), I had this problem. The last time was in 2018. I'm getting
old now and I couldn't remember how I did fix it.

I did found some old topics in this forum about the same problems, but they
did not help.

What did I still miss?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] mysql gnucash

[andy ngo]

Hi there:
Up to now, I've been used 
Gnucash 3.2 
in Ubuntu 18.04
with mysql 5.7.31

My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
 
Gnucash 4.1
Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04 
with mysql 8.0.21

Now, I can't connect to mysql anymore. 

I couldn't open the old file. Then I tried to create a new one, nothing
worked.

I did install 
libdbi1 libdbi-dev
libdbd-mysql

I've used Gnucash since 2013.  Every time I changed a new computer (this is
the 4th time), I had this problem. The last time was in 2018. I'm getting
old now and I couldn't remember how I did fix it.

I did found some old topics in this forum about the same problems, but they
did not help.

What did I still miss? 

Thank you very much
Andy



 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Colin Law]

Have you checked you can access the server using the same credentials,
with a different mysql client?

Colin

On Fri, 29 Nov 2019 at 18:51,  wrote:
>
> Hi
>
>
>
> I used to be able to save my Gnucash file as MySQL but recently got a new
> laptop and I now get a message "the server at URL nysql://etc/etc
> experienced an error or encountered bad or corrupt data". The data can be
> stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and I've
> reinstalled MySQL so that is now 8.0. Anyone else experienced this?
>
>
>
> Cheers
>
> Mark
>
>   _
>
> : 07786 624704 |:   m...@mgillis.uk |
> 
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[mark]

Thanks Geert. I tried upgrading to 3.7 and I'm sure that will add some new
features but, unfortunately, the MySQL error persists so it looks like I
can't store data in this format any more

Cheers
Mark 

: 07786 624704 |: m...@mgillis.uk | 




-Original Message-
From: Geert Janssens  
Sent: 29 November 2019 19:55
To: gnucash-user@gnucash.org
Cc: m...@mgillis.uk
Subject: Re: [GNC] MySQL

Hi,

There was a change in the format for storing dates in MySQL. I don't know
the exact details but it may well be the source of your problem.

I'm pretty sure gnucash 2.6.19 doesn't have (all of) the patches required to
work with this new format. You could try to upgrade to gnucash 2.6.21, the
last release in the 2.6 series, or if that fails, go with gnucash 3.7, the
current stable release.

Regards,

Geert

Op vrijdag 29 november 2019 19:48:57 CET schreef m...@mgillis.uk:
> Hi
> 
> 
> 
> I used to be able to save my Gnucash file as MySQL but recently got a 
> new laptop and I now get a message "the server at URL nysql://etc/etc 
> experienced an error or encountered bad or corrupt data". The data can 
> be stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and 
> I've reinstalled MySQL so that is now 8.0. Anyone else experienced this?
> 
> 
> 
> Cheers
> 
> Mark
> 
>   _
> 
> : 07786 624704 |:  <mailto:m...@mgillis.uk> m...@mgillis.uk |
> 
> <http://www.linkedin.com/profile/view?id=11290745=en_US>





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Geert Janssens]

Hi,

There was a change in the format for storing dates in MySQL. I don't know the 
exact details but it may well be the source of your problem.

I'm pretty sure gnucash 2.6.19 doesn't have (all of) the patches required to 
work with this new format. You could try to upgrade to gnucash 2.6.21, the 
last release in the 2.6 series, or if that fails, go with gnucash 3.7, the 
current stable release.

Regards,

Geert

Op vrijdag 29 november 2019 19:48:57 CET schreef m...@mgillis.uk:
> Hi
> 
> 
> 
> I used to be able to save my Gnucash file as MySQL but recently got a new
> laptop and I now get a message "the server at URL nysql://etc/etc
> experienced an error or encountered bad or corrupt data". The data can be
> stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and I've
> reinstalled MySQL so that is now 8.0. Anyone else experienced this?
> 
> 
> 
> Cheers
> 
> Mark
> 
>   _
> 
> : 07786 624704 |:   m...@mgillis.uk |
> 
> 




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL

[mark]

Hi 

 

I used to be able to save my Gnucash file as MySQL but recently got a new
laptop and I now get a message "the server at URL nysql://etc/etc
experienced an error or encountered bad or corrupt data". The data can be
stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and I've
reinstalled MySQL so that is now 8.0. Anyone else experienced this?

 

Cheers

Mark 

  _  

: 07786 624704 |:   m...@mgillis.uk |
  

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[John Ralls]

> On Mar 7, 2019, at 7:39 AM, Jean-David Beyer via gnucash-user 
>  wrote:
> 
> On 3/7/19 7:22 AM, David G Hamblen wrote:
>> In the past, I've had problems with a mysql file, just getting
>> seqfaults.  Turned out that I was entering a transaction with a 1962
>> date.  I forget the details, but mysql stored it as a zero, which I
>> couldn't reopen.  I changed the date (to post-1970?)  with the mysql
>> command line tool.  Perhaps more recent versions of GC handle this better.
>> 
> 
> In the old days, and perhaps to this day, UNIX and Linux systems had no
> dates prior to 1970/01/01. Maybe mysql still has this limitation. In the
> early days of UNIX, it ran on 16-bit machines and they kept time to the
> second in a double-precision format.
> 
> Now, with 64-bit machines being de rigueur, time is kept more
> accurately, and will not run out in 2038. ;-)
> 

MySQL has two date-time field types, TIMESTAMP and DATETIME. TIMESTAMP uses a 
32-bit unix time and doesn't like 0, so it works only after 1970-01-01 
00:00:01. It's also subject to the 2038 bug. DATETIME is supposed to be good 
from 1000-01-01 to -12-31 and we changed the MySQL schema in GnuCash to use 
DATETIME for GnuCash 3.2.

Note that many Linux distros actually install MariaDB for their "MySQL" package 
and MariaDB's documentation says that it treats TIMESTAMP as DATETIME, but 
Mechtilde found a problem with that, see 
https://bugs.gnucash.org/show_bug.cgi?id=797121. There's also at least one case 
where the conversion either failed or didn't run, 
https://bugs.gnucash.org/show_bug.cgi?id=797112.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Jean-David Beyer via gnucash-user]

On 3/7/19 7:22 AM, David G Hamblen wrote:
> In the past, I've had problems with a mysql file, just getting
> seqfaults.  Turned out that I was entering a transaction with a 1962
> date.  I forget the details, but mysql stored it as a zero, which I
> couldn't reopen.  I changed the date (to post-1970?)  with the mysql
> command line tool.  Perhaps more recent versions of GC handle this better.
> 

In the old days, and perhaps to this day, UNIX and Linux systems had no
dates prior to 1970/01/01. Maybe mysql still has this limitation. In the
early days of UNIX, it ran on 16-bit machines and they kept time to the
second in a double-precision format.

Now, with 64-bit machines being de rigueur, time is kept more
accurately, and will not run out in 2038. ;-)

-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 10:20:01 up 4 days, 19:23, 2 users, load average: 5.19, 5.19, 4.99
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[David G Hamblen]

In the past, I've had problems with a mysql file, just getting 
seqfaults.  Turned out that I was entering a transaction with a 1962 
date.  I forget the details, but mysql stored it as a zero, which I 
couldn't reopen.  I changed the date (to post-1970?)  with the mysql 
command line tool.  Perhaps more recent versions of GC handle this better.


On 3/6/19 4:49 PM, Colin Law wrote:

On Wed, 6 Mar 2019 at 21:44, Keith Bellairs  wrote:

Yes I can connect using the mysql command line tool. No, the gnucash db has not 
been created.

But I cannot use the mysqlworkbench shell. It complains about a missing 
connector (python?)

Also, gnc get the "bad data" error even if I try to "save as" with a bad 
password, no password, or no user id. So it doesn't look like it is really hitting the db at all.

The fact that there is nothing in the trace file suggests that too I
think.  I assume you looked at the trace file immediately after the
error, it is cleared each time gnucash is run.
You could try running gnucash itself from the command line and see if
it says anything in the terminal, assuming you can do that on a Mac.
Otherwise I am out of ideas.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Colin Law]

On Wed, 6 Mar 2019 at 21:44, Keith Bellairs  wrote:
>
> Yes I can connect using the mysql command line tool. No, the gnucash db has 
> not been created.
>
> But I cannot use the mysqlworkbench shell. It complains about a missing 
> connector (python?)
>
> Also, gnc get the "bad data" error even if I try to "save as" with a bad 
> password, no password, or no user id. So it doesn't look like it is really 
> hitting the db at all.

The fact that there is nothing in the trace file suggests that too I
think.  I assume you looked at the trace file immediately after the
error, it is cleared each time gnucash is run.
You could try running gnucash itself from the command line and see if
it says anything in the terminal, assuming you can do that on a Mac.
Otherwise I am out of ideas.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Keith Bellairs]

Yes I can connect using the mysql command line tool. No, the gnucash db has
not been created.

But I cannot use the mysqlworkbench shell. It complains about a missing
connector (python?)

Also, gnc get the "bad data" error even if I try to "save as" with a bad
password, no password, or no user id. So it doesn't look like it is really
hitting the db at all.

Keith





On Wed, Mar 6, 2019 at 3:28 PM Colin Law  wrote:

> On Wed, 6 Mar 2019 at 19:09, Keith Bellairs  wrote:
> >
> > gnucash.trace is empty.
> >
> > Of some interest, I did a Save As to sqlite and it worked. So the xml
> data is acceptable to that DB.
> >
> > XML -> sqlite  OK
> > XML -> mysql NG
> > sqlite -> mysql NG
> >
> > I tried to do a Save As from the sqlite db to MySQL. That Save As ground
> away for a few minutes and then threw the same bad data error. So I am
> guessing that I have a problem with my mysql server. But of course the
> error log for mysql is clean.
> >
> > There may be some mysql magic I am missing. Since I don't live there I
> may not push on it much longer.
>
> Can you connect to the database using the command line utility with
> that user/pwd you specified?
> Has it created the database when you look from the command line?
>
> Colin
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Colin Law]

On Wed, 6 Mar 2019 at 19:09, Keith Bellairs  wrote:
>
> gnucash.trace is empty.
>
> Of some interest, I did a Save As to sqlite and it worked. So the xml data is 
> acceptable to that DB.
>
> XML -> sqlite  OK
> XML -> mysql NG
> sqlite -> mysql NG
>
> I tried to do a Save As from the sqlite db to MySQL. That Save As ground away 
> for a few minutes and then threw the same bad data error. So I am guessing 
> that I have a problem with my mysql server. But of course the error log for 
> mysql is clean.
>
> There may be some mysql magic I am missing. Since I don't live there I may 
> not push on it much longer.

Can you connect to the database using the command line utility with
that user/pwd you specified?
Has it created the database when you look from the command line?

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Keith Bellairs]

gnucash.trace is empty.

Of some interest, I did a Save As to sqlite and it worked. So the xml data
is acceptable to that DB.

XML -> sqlite  OK
XML -> mysql NG
sqlite -> mysql NG

I tried to do a Save As from the sqlite db to MySQL. That Save As ground
away for a few minutes and then threw the same bad data error. So I am
guessing that I have a problem with my mysql server. But of course the
error log for mysql is clean.

There may be some mysql magic I am missing. Since I don't live there I may
not push on it much longer.

Keith


On Wed, Mar 6, 2019 at 11:44 AM Colin Law  wrote:

> On Wed, 6 Mar 2019 at 15:36, Keith Bellairs  wrote:
> >
> > Yes, the Save As selection is not grayed out. So I assumed the drivers
> were
> > in the Mac package.
> >
> > My MySQL instance is up and running.
> >
> > But I get a gnc error when I try to do the Save As.
> >
>
> Have a look in the gnucash trace file to see if it says anything more
> helpful
>
> Colin
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[Colin Law]

On Wed, 6 Mar 2019 at 15:36, Keith Bellairs  wrote:
>
> Yes, the Save As selection is not grayed out. So I assumed the drivers were
> in the Mac package.
>
> My MySQL instance is up and running.
>
> But I get a gnc error when I try to do the Save As.
>

Have a look in the gnucash trace file to see if it says anything more helpful

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[David T. via gnucash-user]

Thanks for clarifying.

I'm probably also mixing some of this in with the whole Python on Macs issue.


David
 
 
  On Wed, Mar 6, 2019 at 10:11, John Ralls 
wrote:   David,

For 2.6 yes. For 3.x everything is in the bundle for all three database 
backends just like Windows.

Regards,
John Ralls

> On Mar 5, 2019, at 6:12 PM, David T.  wrote:
> 
> John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
> libdbd-mysql dependency added in? ISTR at some point that we needed to build 
> gnucash ourselves to add this functionality.  Or am I misremembering?
> 
> 
> David T.
> 
> 
> On Wed, Mar 6, 2019 at 3:50, John Ralls
>  wrote:
> 
> 
> > On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> > 
> > For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> > my xml file exportable to mysql? If so, is there a writeup? I tried a
> > couple of obvious things (save as, make myself a dba, create Gnucash schema
> > in mysql) and made no progress.
> 
> You need to create a user and grant it pretty much everything, then provide 
> that userid and password and let GnuCash create the database.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[John Ralls]

David,

For 2.6 yes. For 3.x everything is in the bundle for all three database 
backends just like Windows.

Regards,
John Ralls

> On Mar 5, 2019, at 6:12 PM, David T.  wrote:
> 
> John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
> libdbd-mysql dependency added in? ISTR at some point that we needed to build 
> gnucash ourselves to add this functionality.  Or am I misremembering?
> 
> 
> David T.
> 
> 
> On Wed, Mar 6, 2019 at 3:50, John Ralls
>  wrote:
> 
> 
> > On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> > 
> > For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> > my xml file exportable to mysql? If so, is there a writeup? I tried a
> > couple of obvious things (save as, make myself a dba, create Gnucash schema
> > in mysql) and made no progress.
> 
> You need to create a user and grant it pretty much everything, then provide 
> that userid and password and let GnuCash create the database.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[David T. via gnucash-user]

John, for MySQL, don't Mac users have to build Gnucash with the appropriate 
libdbd-mysql dependency added in? ISTR at some point that we needed to build 
gnucash ourselves to add this functionality.  Or am I misremembering?

David T.
 
 
  On Wed, Mar 6, 2019 at 3:50, John Ralls wrote: 
  

> On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> 
> For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> my xml file exportable to mysql? If so, is there a writeup? I tried a
> couple of obvious things (save as, make myself a dba, create Gnucash schema
> in mysql) and made no progress.

You need to create a user and grant it pretty much everything, then provide 
that userid and password and let GnuCash create the database.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[John Ralls]

> On Mar 5, 2019, at 12:56 PM, Keith Bellairs  wrote:
> 
> For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> my xml file exportable to mysql? If so, is there a writeup? I tried a
> couple of obvious things (save as, make myself a dba, create Gnucash schema
> in mysql) and made no progress.

You need to create a user and grant it pretty much everything, then provide 
that userid and password and let GnuCash create the database.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL

[David Cousens]

Keith,

See the following links for setup on MacOSX with MySQL

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html
https://wiki.gnucash.org/wiki/MacOS_Installation
https://lists.gnucash.org/pipermail/gnucash-user/2011-February/038511.html
http://www.matt-thornton.net/tech/databases/gnucash-mysql-os-x-10-10-getting-it-running

I'm not a mySQL or MacOSX user. Someone else may be able to give you more
specific information.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL

[Keith Bellairs]

For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
my xml file exportable to mysql? If so, is there a writeup? I tried a
couple of obvious things (save as, make myself a dba, create Gnucash schema
in mysql) and made no progress.

Keith
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Geert Janssens]

You can set a port number when saving to DB. If not set, GnuCash will use the 
default. There is no separate field for it, but I believe you can use a 
"host:port" format in the hostname field.

If you prefer to keep the non-default port number for your mysql server, you 
can reopen your db in gnucash using File->Open and set the proper db hostname 
and port. GnuCash should remember your settings for the next time.

Geert



Op maandag 19 november 2018 08:32:33 CET schreef Colin Law:
> I expect that gnucash assumes you are using the default mysql port.
> 
> Colin
> 
> On Mon, 19 Nov 2018, 03:31 Peter Holck  > Thanks again for your help; I think I understand my problem now.
> > 
> > GnuCash (reasonably) looks for an  instance of MySQL using the same port
> > that it used when closed (or when created? Not sure). Anyway, I had
> > assigned a different port number to my new version of MySQL (since I
> > wanted
> > to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least
> > until
> > I confirmed the new version was working correctly). Swapping the port
> > numbers so the new 8.0 version used the old 5.6 port and vice versa (via
> > editing the my.ini config file) seems to have done the trick.
> > 
> > Thanks!
> > 
> > On Sun, Nov 18, 2018 at 1:21 AM Colin Law  wrote:
> >> On Sat, 17 Nov 2018 at 22:52, Peter Holck 
> >> 
> >> wrote:
> >> > * 15:25:47  CRIT 
> >> 
> >> [GncDbiBackend::session_begin()] Unable to connect to database
> >> 'gnucash'
> >> 
> >> Please copy the list on replies, you sent this one just to me.  On
> >> gmail use Reply All when replying.
> >> 
> >> Are you able to connect to the server using the command line client
> >> mysql -u username -p
> >> and it will prompt for the password.
> >> 
> >> If that connects then
> >> show databases;
> >> will show the databases (oddly enough).  Then you can exit with
> >> exit;
> >> 
> >> Colin
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Colin Law]

I expect that gnucash assumes you are using the default mysql port.

Colin

On Mon, 19 Nov 2018, 03:31 Peter Holck  Thanks again for your help; I think I understand my problem now.
>
> GnuCash (reasonably) looks for an  instance of MySQL using the same port
> that it used when closed (or when created? Not sure). Anyway, I had
> assigned a different port number to my new version of MySQL (since I wanted
> to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until
> I confirmed the new version was working correctly). Swapping the port
> numbers so the new 8.0 version used the old 5.6 port and vice versa (via
> editing the my.ini config file) seems to have done the trick.
>
> Thanks!
>
> On Sun, Nov 18, 2018 at 1:21 AM Colin Law  wrote:
>
>> On Sat, 17 Nov 2018 at 22:52, Peter Holck 
>> wrote:
>> >
>> > * 15:25:47  CRIT 
>> [GncDbiBackend::session_begin()] Unable to connect to database
>> 'gnucash'
>>
>> Please copy the list on replies, you sent this one just to me.  On
>> gmail use Reply All when replying.
>>
>> Are you able to connect to the server using the command line client
>> mysql -u username -p
>> and it will prompt for the password.
>>
>> If that connects then
>> show databases;
>> will show the databases (oddly enough).  Then you can exit with
>> exit;
>>
>> Colin
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Peter Holck]

Thanks again for your help; I think I understand my problem now.

GnuCash (reasonably) looks for an  instance of MySQL using the same port
that it used when closed (or when created? Not sure). Anyway, I had
assigned a different port number to my new version of MySQL (since I wanted
to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until
I confirmed the new version was working correctly). Swapping the port
numbers so the new 8.0 version used the old 5.6 port and vice versa (via
editing the my.ini config file) seems to have done the trick.

Thanks!

On Sun, Nov 18, 2018 at 1:21 AM Colin Law  wrote:

> On Sat, 17 Nov 2018 at 22:52, Peter Holck  wrote:
> >
> > * 15:25:47  CRIT 
> [GncDbiBackend::session_begin()] Unable to connect to database
> 'gnucash'
>
> Please copy the list on replies, you sent this one just to me.  On
> gmail use Reply All when replying.
>
> Are you able to connect to the server using the command line client
> mysql -u username -p
> and it will prompt for the password.
>
> If that connects then
> show databases;
> will show the databases (oddly enough).  Then you can exit with
> exit;
>
> Colin
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Colin Law]

On Sat, 17 Nov 2018 at 22:52, Peter Holck  wrote:
>
> * 15:25:47  CRIT  [GncDbiBackend::session_begin()] 
> Unable to connect to database 'gnucash'

Please copy the list on replies, you sent this one just to me.  On
gmail use Reply All when replying.

Are you able to connect to the server using the command line client
mysql -u username -p
and it will prompt for the password.

If that connects then
show databases;
will show the databases (oddly enough).  Then you can exit with
exit;

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Joseph Vernice]

Check credentials in MySQL. Specifically permissions for Root@Localhost

On Sat, Nov 17, 2018 at 5:38 PM Colin Law  wrote:

> On Sat, 17 Nov 2018 at 22:31, Peter Holck  wrote:
> >
> > Thanks for your suggestion. No, with only my new instance of MySQL
> running (8.13 running, 5.6 stopped) when I use the GnuCash API to create a
> new shell database (shelldb)  and try to save as mysql, I get the same
> error: "The server at URL mysql://root@localhost/shelldb experienced an
> error or encountered bad or corrupt data". It seems to me the GnuCash API
> is looking for an instance of my old version of MySQL (5.6) and if it's not
> running, then it fails.
>
> You haven't told us what you found when you looked in the trace file.
>
> Colin
>
> >
> > On Sat, Nov 17, 2018 at 3:20 PM Colin Law  wrote:
> >>
> >> Are you able to Save As mysql with the new server?
> >> Also have a look in the trace file and see what it says, often it will
> >> give more information in the case of db problems.
> >>
> >> Colin
> >> On Sat, 17 Nov 2018 at 22:07, Peter Holck 
> wrote:
> >> >
> >> > I recently installed an updated version of MySQL Server (8.13) on my
> >> > machine. I have an established GnuCash database under an instance of
> MySQL
> >> > 5.6. I copied all GnCash db/tables from that older version of MySQL
> to an
> >> > identically named database/tables in MySQL 8.13.
> >> >
> >> > How do I get the GnuCash API to connect to my new instance of MySQL
> (8.13)
> >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13
> running,
> >> > and then attempt to start GnuCash it asks for username and password
> (also
> >> > identical for the two different MySQL versions) but then gives the
> standard
> >> > error that the server encountered bad or corrupt data.
> >> >
> >> > Thanks in advance.
> >> > ___
> >> > gnucash-user mailing list
> >> > gnucash-user@gnucash.org
> >> > To update your subscription preferences or to unsubscribe:
> >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> > -
> >> > Please remember to CC this list on all your replies.
> >> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Colin Law]

On Sat, 17 Nov 2018 at 22:31, Peter Holck  wrote:
>
> Thanks for your suggestion. No, with only my new instance of MySQL running 
> (8.13 running, 5.6 stopped) when I use the GnuCash API to create a new shell 
> database (shelldb)  and try to save as mysql, I get the same error: "The 
> server at URL mysql://root@localhost/shelldb experienced an error or 
> encountered bad or corrupt data". It seems to me the GnuCash API is looking 
> for an instance of my old version of MySQL (5.6) and if it's not running, 
> then it fails.

You haven't told us what you found when you looked in the trace file.

Colin

>
> On Sat, Nov 17, 2018 at 3:20 PM Colin Law  wrote:
>>
>> Are you able to Save As mysql with the new server?
>> Also have a look in the trace file and see what it says, often it will
>> give more information in the case of db problems.
>>
>> Colin
>> On Sat, 17 Nov 2018 at 22:07, Peter Holck  wrote:
>> >
>> > I recently installed an updated version of MySQL Server (8.13) on my
>> > machine. I have an established GnuCash database under an instance of MySQL
>> > 5.6. I copied all GnCash db/tables from that older version of MySQL to an
>> > identically named database/tables in MySQL 8.13.
>> >
>> > How do I get the GnuCash API to connect to my new instance of MySQL (8.13)
>> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running,
>> > and then attempt to start GnuCash it asks for username and password (also
>> > identical for the two different MySQL versions) but then gives the standard
>> > error that the server encountered bad or corrupt data.
>> >
>> > Thanks in advance.
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see 
>> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Peter Holck]

Thanks for your suggestion. No, with only my new instance of MySQL running
(8.13 running, 5.6 stopped) when I use the GnuCash API to create a new
shell database (shelldb)  and try to save as mysql, I get the same error:
"The server at URL mysql://root@localhost/shelldb experienced an error or
encountered bad or corrupt data". It seems to me the GnuCash API is looking
for an instance of my old version of MySQL (5.6) and if it's not running,
then it fails.

On Sat, Nov 17, 2018 at 3:20 PM Colin Law  wrote:

> Are you able to Save As mysql with the new server?
> Also have a look in the trace file and see what it says, often it will
> give more information in the case of db problems.
>
> Colin
> On Sat, 17 Nov 2018 at 22:07, Peter Holck  wrote:
> >
> > I recently installed an updated version of MySQL Server (8.13) on my
> > machine. I have an established GnuCash database under an instance of
> MySQL
> > 5.6. I copied all GnCash db/tables from that older version of MySQL to an
> > identically named database/tables in MySQL 8.13.
> >
> > How do I get the GnuCash API to connect to my new instance of MySQL
> (8.13)
> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13
> running,
> > and then attempt to start GnuCash it asks for username and password (also
> > identical for the two different MySQL versions) but then gives the
> standard
> > error that the server encountered bad or corrupt data.
> >
> > Thanks in advance.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Colin Law]

Are you able to Save As mysql with the new server?
Also have a look in the trace file and see what it says, often it will
give more information in the case of db problems.

Colin
On Sat, 17 Nov 2018 at 22:07, Peter Holck  wrote:
>
> I recently installed an updated version of MySQL Server (8.13) on my
> machine. I have an established GnuCash database under an instance of MySQL
> 5.6. I copied all GnCash db/tables from that older version of MySQL to an
> identically named database/tables in MySQL 8.13.
>
> How do I get the GnuCash API to connect to my new instance of MySQL (8.13)
> ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running,
> and then attempt to start GnuCash it asks for username and password (also
> identical for the two different MySQL versions) but then gives the standard
> error that the server encountered bad or corrupt data.
>
> Thanks in advance.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

[Peter Holck]

I recently installed an updated version of MySQL Server (8.13) on my
machine. I have an established GnuCash database under an instance of MySQL
5.6. I copied all GnCash db/tables from that older version of MySQL to an
identically named database/tables in MySQL 8.13.

How do I get the GnuCash API to connect to my new instance of MySQL (8.13)
? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running,
and then attempt to start GnuCash it asks for username and password (also
identical for the two different MySQL versions) but then gives the standard
error that the server encountered bad or corrupt data.

Thanks in advance.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[Phil Longstaff]

That may work fine for a single instance of gnucash. However, it this is 2
instances of gnucash on 2 separate computers, does libdbi provide any
notification mechanism to notify gnucash on computer #2 that computer #1
has written to the db?

On Mon, Nov 5, 2018 at 2:39 AM craigarno  wrote:

> Geert Janssens-4 wrote
> > Op zondag 4 november 2018 14:49:22 CET schreef craigarno:
> >> Geert Janssens-4 wrote
> >>
> > Whether it can work depends on
> > whether the db layer we rely on has a notification mechanism for db
> > changes we
> > can hook into. The current db layer is provided by libdbi, which is not
> > managed by the gnucash team and I haven't looked into this yet.
>
> If your call to libdbi is in the same thread and is a blocking call for
> synchronous operation, then there shouldn't be a problem with updating
> views
> after successful return from the libdbi call.  Otherwise you may have to
> look for semaphors to signal.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[craigarno]

Geert Janssens-4 wrote
> Op zondag 4 november 2018 14:49:22 CET schreef craigarno:
>> Geert Janssens-4 wrote
>> 
> Whether it can work depends on 
> whether the db layer we rely on has a notification mechanism for db
> changes we 
> can hook into. The current db layer is provided by libdbi, which is not 
> managed by the gnucash team and I haven't looked into this yet.

If your call to libdbi is in the same thread and is a blocking call for
synchronous operation, then there shouldn't be a problem with updating views
after successful return from the libdbi call.  Otherwise you may have to
look for semaphors to signal.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[craigarno]

Geert Janssens-4 wrote
> Op zondag 4 november 2018 04:36:30 CET schreef craigarno:
> The only part I have no idea about at this stage is how to tell all views
> to refresh when one user makes a change.

If you are headed toward C++, the "Observer" Design Pattern may be able to
get the "refresh views" job done for you.

Where observer pattern is used?
Observer pattern is used when there is one-to-many relationship between
objects such as if one object is modified, its dependent objects are to be
notified automatically. Observer pattern falls under behavioral pattern
category.

Hope that helps.

Sounds like a lot of work.  Thank you for your insight.

Craig



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[Geert Janssens]

Op zondag 4 november 2018 04:36:30 CET schreef craigarno:
> My application is similar, except two of my users will be outside of my
> local network, working from the Internet.  I'm a tiny one man SOHO
> operation who is off-site a lot of the time and may also be accessing my
> GnuCash database remotely and concurrently from a job site providing client
> invoices/expenses as needed/requested.
> 
> *Usecase*:
>   /Myself/:  Day to day entry of expenses, income, travel receipts, tax
> info.
>   /Bookkeeper/: weekly cleanup of my efforts, will potentially be using the
> database at the same time as I am.
>   /Accountant/: Annual tax time work, will be using the database concurrent
> with myself + bookkeeper, updating chart of accounts with changing tax law
> information, Income tax preparation, etc.  Packaging up the previous year
> while we're inputting the current year.
> 
> Ideally the internet side will use MySQL+SSL for secure connection.  And
> ideally active records would be momentarily locked for update, then released
> after update, and both other concurrent screens notified and updated as
> required for correct visual data presentation.  Given the tiny size of my
> organization, daily database transaction load will be very low, and most of
> the time each of the three of us will effectively have exclusive access to
> the database.  But there will be times when concurrency will be important.
> This is also why we need a centralized accounting database.
> 
> Is there a roadmap for GnuCash database development?
> 
Concurrent multi-user access is on the roadmap. There is no ETA on this 
however. The team is currently almost fully occupied with fixing regressions 
introduces by our force move to Gtk3.

This has taken time away from our next primary goal, converting to C++. This 
conversion also includes reviewing historical design decisions and laying the 
groundwork for true concurrency. I think our current vision does cover most of 
the use case you describe. The only part I have no idea about at this stage is 
how to tell all views to refresh when one user makes a change.

Additional hands to realize this vision are of course very welcome.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[craigarno]

My application is similar, except two of my users will be outside of my local
network, working from the Internet.  I'm a tiny one man SOHO operation who
is off-site a lot of the time and may also be accessing my GnuCash database
remotely and concurrently from a job site providing client invoices/expenses
as needed/requested.

*Usecase*:
  /Myself/:  Day to day entry of expenses, income, travel receipts, tax
info.
  /Bookkeeper/: weekly cleanup of my efforts, will potentially be using the
database at the same time as I am.
  /Accountant/: Annual tax time work, will be using the database concurrent
with myself + bookkeeper, updating chart of accounts with changing tax law
information, Income tax preparation, etc.  Packaging up the previous year
while we're inputting the current year.

Ideally the internet side will use MySQL+SSL for secure connection.  And
ideally active records would be momentarily locked for update, then released
after update, and both other concurrent screens notified and updated as
required for correct visual data presentation.  Given the tiny size of my
organization, daily database transaction load will be very low, and most of
the time each of the three of us will effectively have exclusive access to
the database.  But there will be times when concurrency will be important. 
This is also why we need a centralized accounting database.

Is there a roadmap for GnuCash database development?

Warnings of data loss using current versions of GnuCash noted.  I realize
GnuCash isn't there yet, but excited to see GnuCash is potentially headed in
this direction.

Thanks,
Craig



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MySQL on GCP

[David Cousens]

On Sat, 2018-10-20 at 14:39 -0400, Charles Gagnon wrote:
> 
> My question is around online transactions. After importing, I would
> typically spend some time in the window assigning the right accounts to the
> transactions. This process is now terribly slow with the cloud DB so I'm
> assuming it was written with lot of backend interactions. The workaround is
> fairly simple, I import the transactions as-is (with or without an account)
> and I re-visit in the register window to assign an account.

Charles,

It is hard to understand why the process of importing transactions with 
unassigned destination accounts and editing them
in the register window is actually more efficient than assigning the accounts 
in the import matcher. The register
possibly writes the data directly to the db as each account is assigned while 
the import matcher only appears to up date
the Bayesian matcher data as each account is assigned and only updates the 
actual transaction data in the db when the OK
button is pressed in the matcher window as far as I can seen in the code on a 
quick look. It may be possible that the
process of writing out the matcher data is less efficient than that of writing 
the transaction data perhaps. My
understanding of the GnuCash code is still fairly limited even though I have 
looked through hat area recently.

Is it the apparent delay in having to assign the transfer accounts singly to 
all transactions in the matcher window
which makes this process appear to be slower for you?

There is one improvment coming up in V4 which will enable multiple selection in 
the matcher window for assignment of a
single transfer account to all selected  transactions, which should at least 
speed up the initial assignment of transfer
accounts, but once the Bayesian matcher gets educated, I am finding that the 
matcher automatically assigns the correct
transfer account in many cases.

Somewhere in the changeover from 2.6.19 to v3.0, I appeared to have lost my 
previous matcher data. It may heve been that
I changed the preference on Bayesian matching in the Online Banking preferences 
during that process as well.

David Cousens


> I figured I'd share and start a conversation. I also wanted to bring up the
> online transactions situation even though it's easy to work around.
> 
> Regards,
> 
> PS: With a GCP based Linux desktop and the right packages to run gnucash
> with a mysql backend, I could end-up with a completely portable solution
> with the current codebase.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] MySQL on GCP

[Charles Gagnon]

I wanted to share something quickly and ask a question at the same time.

I've been using gnucash since ~ 2001-2002 for my personal finances. I was
"closing" and starting fresh every year until 2006 at which point I just
started accumulated into the same file. So I currently have data in a
single file dating back to 2006.

I switched to MySQL backend years ago. I recently decided it would be nice
to get rid of some of my home lab machines so I made an experiment with
Google Cloud.

I had never read of anyone trying it but I restored my MySQL DB in a GCP
instance and have been using it as my main DB for several months. It opens
slower than my local database but it seems gnucash loads up the bulk of
what it needs in memory. So for normal day-to-day operations, you really
cannot tell the difference between the local instance and the cloud
instance.

My question is around online transactions. After importing, I would
typically spend some time in the window assigning the right accounts to the
transactions. This process is now terribly slow with the cloud DB so I'm
assuming it was written with lot of backend interactions. The workaround is
fairly simple, I import the transactions as-is (with or without an account)
and I re-visit in the register window to assign an account.

I figured I'd share and start a conversation. I also wanted to bring up the
online transactions situation even though it's easy to work around.

Regards,

PS: With a GCP based Linux desktop and the right packages to run gnucash
with a mysql backend, I could end-up with a completely portable solution
with the current codebase.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mysql backend, second user (lock, for example)

[Geert Janssens]

Gnucash will put a lock on the database as long as it's in use by one user. If 
a second user tries to open it that user will be presented with a warning tje 
db is still in use by ssomeone else. So you can't accidentally be working on an 
open db with two users at once. If you ignore the warning you may end up with 
data loss though.

Regards
Geert

Jeff Abrahamson  schreef op 19 augustus 2018 07:32:08 CEST:
>I'd like to understand if gnucash + mysql supports avoiding
>simultaneous
>editors (e.g., via locks).
>
>In more detail:
>
>I want to keep accounts for a small organisation in which we've decided
>several people should have access to the books for transparency and
>distribution of work.  One possibility seems to be gnucash, which would
>suit me because I already know it among other reasons.  With a mysql
>backend, it's easy enough to set up for us.
>
>Gnucash has long (very long) noted that simultaneous editors is a
>wishlist item.  Now the chances of simultaneous editors is really small
>for us, so even a simple lock-out ("sorry, Sara is editing now, want to
>wait a few minutes?") is enough.  Even anonymous, because we know each
>other and can message to figure out who.  But I haven't found anything
>written here about whether gnucash with the mysql back end leaves
>behind
>a breadcrumb so that other instances know not to edit.  (Or maybe
>there's a compile-time option to support this, for example.  So just
>testing isn't quite good enough here.)
>
>I've seen that James Nylen has written a (possibly moribund) django
>interface, which could sort the multi-user access issue by actually
>being only a single user.  I'm not overly inclined, however, as the
>project smells of "good enough for the author but not fully production
>ready".  And I don't want to maintain a django application as well.
>
>   https://github.com/nylen/gnucash-django
>
>-- 
>
>Jeff Abrahamson
>+33 6 24 40 01 57
>+44 7920 594 255
>https://www.p27.eu/jeff/
>
>purple.com -> p27.eu
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

Sent from my smartphone. Please excuse my brevity.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] mysql backend, second user (lock, for example)

[Jeff Abrahamson]

I'd like to understand if gnucash + mysql supports avoiding simultaneous
editors (e.g., via locks).

In more detail:

I want to keep accounts for a small organisation in which we've decided
several people should have access to the books for transparency and
distribution of work.  One possibility seems to be gnucash, which would
suit me because I already know it among other reasons.  With a mysql
backend, it's easy enough to set up for us.

Gnucash has long (very long) noted that simultaneous editors is a
wishlist item.  Now the chances of simultaneous editors is really small
for us, so even a simple lock-out ("sorry, Sara is editing now, want to
wait a few minutes?") is enough.  Even anonymous, because we know each
other and can message to figure out who.  But I haven't found anything
written here about whether gnucash with the mysql back end leaves behind
a breadcrumb so that other instances know not to edit.  (Or maybe
there's a compile-time option to support this, for example.  So just
testing isn't quite good enough here.)

I've seen that James Nylen has written a (possibly moribund) django
interface, which could sort the multi-user access issue by actually
being only a single user.  I'm not overly inclined, however, as the
project smells of "good enough for the author but not fully production
ready".  And I don't want to maintain a django application as well.

   https://github.com/nylen/gnucash-django

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/

purple.com -> p27.eu

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.