Re: Gnucash connect to remote 1and1 database server

[Bindiya Maharjan]

 
 

 It's mysql. I want to connect gnucash to MySQL database. I do not know how to 
using command line.
 

 
 

 
 
>  
> On Aug 3, 2017 at 12:26 PM,  mailto:clan...@gmail.com)>  wrote:
>  
>  
>  
>  What sort of database is it (mysql or whatever)? Can you access it by 
> command line utilities on the PC or a simple GUI app? If so which? Colin On 3 
> August 2017 at 07:14, Bindiya Maharjan wrote:  >   >   >   >  Hi all ,  >   > 
>   >   >  I am trying to connect to remote database server without any 
> success. Do you guys have any steps or guide for this.  >   >   >   >  
> Appreciate your help.  >   >   >   >  Thanks  >   >   >   >   >   >   >   >  
> ___  >  gnucash-user mailing list 
>  >  gnucash-user@gnucash.org  >  
> 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. 
>
>  
 
 
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled Transaction Help :(

[Steve]

Sure...

 



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-Transaction-Help-tp4693019p4693030.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash connect to remote 1and1 database server

[Maf. King]

On Thursday, 3 August 2017 07:14:44 BST Bindiya Maharjan wrote:
>  Hi all ,
> 
> 
> 
> I am trying to connect to remote database server without any success. Do you
> guys have any steps or guide for this.
> 

Hi,

what have you tried, and how does it fail?  
Which GC version and OS might be useful too.

from the command line, something like

mysql -u username -p password -h server-hostname

would be a good start point for debugging the connection. ( try man mysql or 
mysql --help for more options)

Maf.


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash connect to remote 1and1 database server

[D via gnucash-user]

Having been a 1and1 customer before, I can't imagine how you would set it up to 
work with Gnucash directly. Especially if you aren't familiar with the command 
line. I admit that my account with them was a basic one, so it may be that your 
account has better features. But still...

If you want to store your data in the cloud, it is much more manageable by 
using Dropbox, which uses a local folder to mirror your cloud files. This gives 
you the benefit of a local file system but with cloud features as well.

I would also suggest you reconsider your choice to use the database back end, 
given your statement about the command line. It does take more technical savvy 
to use, and doesn't gain much benefit at this time.

David

On August 3, 2017, at 3:15 AM, Bindiya Maharjan  
wrote:

 
 

 It's mysql. I want to connect gnucash to MySQL database. I do not know how to 
using command line.
 

 
 

 
 
>  
> On Aug 3, 2017 at 12:26 PM,  mailto:clan...@gmail.com)>  wrote:
>  
>  
>  
>  What sort of database is it (mysql or whatever)? Can you access it by 
> command line utilities on the PC or a simple GUI app? If so which? Colin On 3 
> August 2017 at 07:14, Bindiya Maharjan wrote:  >   >   >   >  Hi all ,  >   > 
>   >   >  I am trying to connect to remote database server without any 
> success. Do you guys have any steps or guide for this.  >   >   >   >  
> Appreciate your help.  >   >   >   >  Thanks  >   >   >   >   >   >   >   >  
> ___  >  gnucash-user mailing list 
>  >  gnucash-user@gnucash.org  >  
> 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. 
>
>  
 
 
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[Christine Maloney via gnucash-user]

I have now uninstalled Gnucash and reinstalled a more stable version. This
has resolved the issue. However, I am having other issues, such as the
accounts will not take a small payment of £1.00 and a memo keeps showing
when before it done it all behind the scenes as it were. 

 

From: John Ralls [mailto:jra...@ceridwen.us] 
Sent: Wednesday, August 02, 2017 4:45 PM
To: Christine Maloney 
Cc: Dave H ; AC ;
gnucash-user@gnucash.org
Subject: Re: population

 

 

On Aug 2, 2017, at 2:24 PM, Christine Maloney mailto:cmalon...@talktalk.net> > wrote:

 

Yes the date and time are correct on the PC, I have windows 7 home premium.
And I got the latest I think Gnucash 2017. I wonder if there is a fix for
this. 

 

From: Dave H [mailto:hell...@gmail.com] 
Sent: Wednesday, August 02, 2017 12:00 PM
To: AC mailto:gnuc...@acarver.net> >; Christine
Maloney mailto:cmalon...@talktalk.net> >; John
Ralls mailto:jra...@ceridwen.us> >
Cc: gnucash-user@gnucash.org  
Subject: Re: population

 

 

On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user <
 gnucash-user@gnucash.org> wrote:

13/01/1899 is the exact date. I have downloaded a later version, 2017 and it
is still doing the same. The date range is amended correctly but the report
still does not show it.

 

Is the date and time correct on your pc and in other programs/apps
(clock/calendar) running on your pc ?

 

Cheers Dave H

 

 


  _  


  

This email has been checked for viruses by AVG antivirus software. 
  www.avg.com

 

Christine,

 

Windows being Windows, have you rebooted since installing GnuCash?

The tag at the end of your email suggests another possibility: Have you
tried disabling your antivirus program?

 

If neither of those resolves the problem the next test is to create a new
user and try running GnuCash while logged in as the new user. Don't
customize the new user id at all.

 

Regards,

John Ralls

 



---
This email has been checked for viruses by AVG.
http://www.avg.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[Christine Maloney via gnucash-user]

Sorry I have uninstalled the version before receiving this message. 

 

From: David Carlson [mailto:david.carlson@gmail.com] 
Sent: Wednesday, August 02, 2017 2:29 PM
To: Christine Maloney 
Cc: Dave H ; AC ; John Ralls 
; gnucash-user@gnucash.org
Subject: Re: population

 

Christine,

It seems that you are the first to report your problem.  That is why the 
developers are asking so many questions about details.  Please check the about 
gnucash screen and tell them the exact release number and build date.

David C

 

On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via gnucash-user 
mailto:gnucash-user@gnucash.org> > wrote:

Yes the date and time are correct on the PC, I have windows 7 home premium. And 
I got the latest I think Gnucash 2017. I wonder if there is a fix for this.



From: Dave H [mailto:hell...@gmail.com  ]
Sent: Wednesday, August 02, 2017 12:00 PM
To: AC mailto:gnuc...@acarver.net> >; Christine Maloney 
mailto:cmalon...@talktalk.net> >; John Ralls 
mailto:jra...@ceridwen.us> >
Cc: gnucash-user@gnucash.org  
Subject: Re: population





On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user 
mailto:gnucash-user@gnucash.org>  
 > > wrote:

13/01/1899 is the exact date. I have downloaded a later version, 2017 and it
is still doing the same. The date range is amended correctly but the report
still does not show it.



Is the date and time correct on your pc and in other programs/apps 
(clock/calendar) running on your pc ?



Cheers Dave H





---
This email has been checked for viruses by AVG.
http://www.avg.com

___
gnucash-user mailing list
gnucash-user@gnucash.org  
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.

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled Transaction Help :(

[David Carlson]

Another thing to try that once helped me to fix some old and broken SEx's
(android did tat and I can't fix it.) is to enter zero's into every empty
acccouunt value box so there are two values in each line.

Sounds crazy but it actually worked

David C

On Aug 3, 2017 2:48 AM, "Steve"  wrote:

> Sure...
>
> 
>
>
>
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Scheduled-Transaction-Help-tp4693019p4693030.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Start-date in Estimate-budget-value dialog

[D via gnucash-user]

While my understanding of the budget features lacks depth, I do believe that 
the estimating features average the transactions in the time frame you choose, 
so the start date should reflect the time period for which you want estimates 
derived. If your expenses have been stable for a long time, you could use the 
whole data set; if they have changed radically for some reason,you might wish 
to limit the averaging period to a smaller set.

David

On August 2, 2017, at 8:43 AM, Gour  wrote:

Hello!

I've asked in IRC and it's not clear to me what to put as the start date in the
dialog concerning Estimating budget-values for the accounts based from the past
history of transactions?

For instance, if I have several years of history and want to create a budget
for this 2017 year, along with 12 (monthly) periods, what should I put as the
start date for estimating budget values?



Sincerely,
Gour
 

-- 
Even a man of knowledge acts according to his own nature, for
everyone follows the nature he has acquired from the three modes.
What can repression accomplish?


___
gnucash-user mailing list
gnucash-user@gnucash.org
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[John Ralls]

> On Aug 3, 2017, at 2:59 PM, Christine Maloney  wrote:
> 
> I have now uninstalled Gnucash and reinstalled a more stable version. This 
> has resolved the issue. However, I am having other issues, such as the 
> accounts will not take a small payment of £1.00 and a memo keeps showing when 
> before it done it all behind the scenes as it were. 

Christine,

Sorry, I don't understand. Can you explain in detail (at the level of "I select 
x from the menu, enter £1.00 in field y, ...) exactly what you're doing and 
what happens at each step?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash connect to remote 1and1 database server

[John Ralls]

> On Aug 3, 2017, at 8:14 AM, Bindiya Maharjan  
> wrote:
> 
> 
> 
> 
> Hi all ,
> 
> 
> 
> I am trying to connect to remote database server without any success. Do you 
> guys have any steps or guide for this.
> 
> 
> 
> Appreciate your help.


Sorry, no, we're not able to offer database administration support. It's the 
responsibility of the user to have a qualified database administrator on hand 
to administer the database server. Users who aren't able to meet that 
requirement should use either of the file-based backends (XML or SQLite3).

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[Christine Maloney via gnucash-user]

When I add the small amount of £1.00 the system takes it in the memo entries, 
but when I press enter it disappears from the system. 

 

From: John Ralls [mailto:jra...@ceridwen.us] 
Sent: Thursday, August 03, 2017 3:52 PM
To: Christine Maloney 
Cc: GNU Cash User 
Subject: Re: population

 

 

On Aug 3, 2017, at 2:59 PM, Christine Maloney mailto:cmalon...@talktalk.net> > wrote:

 

I have now uninstalled Gnucash and reinstalled a more stable version. This has 
resolved the issue. However, I am having other issues, such as the accounts 
will not take a small payment of £1.00 and a memo keeps showing when before it 
done it all behind the scenes as it were. 

 

Christine,

 

Sorry, I don't understand. Can you explain in detail (at the level of "I select 
x from the menu, enter £1.00 in field y, ...) exactly what you're doing and 
what happens at each step?

 

Regards,

John Ralls

 



---
This email has been checked for viruses by AVG.
http://www.avg.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[Maf. King]

On Thursday, 3 August 2017 17:01:22 BST Christine Maloney via gnucash-user 
wrote:
> When I add the small amount of £1.00 the system takes it in the memo
> entries, but when I press enter it disappears from the system.
> 
> 

Hi,

Only press Enter if you are ready to commit a transaction to the register.  
Tab to move between all the various fields for data.

If you are putting a 1.00 in the memo, then what are you putting in the 
transfer account and Credit/Debit/Deposit/Withdrawal etc columns?

Which version of GC have you installed, so as to be more stable than what you 
had previously?

Maf.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: gnucash update on debian errors, then stops

[Tommy Trussell]

On Tue, Aug 1, 2017 at 8:24 PM, John Griessen 
wrote:

> I have not been able to upgrade gnucash for a while now.
>
> Will there be a usable gnucash in the next debian release?
> If not, why not?
>
> I still use this version on debian stretch/testing/frozen, soon to be the
> new released debian stable:
>

For now I presume you might switch to using the version at getdeb.net
though I don't know your particular requirements. Another option, of
course, is to build it yourself. See https://wiki.gnucash.org/wiki/Debian
though it looks like a lot on that page is kindof stale, and it doesn't
link you to the pages describing how to build from git or a tarball -- see
https://wiki.gnucash.org/wiki/Building

HOWEVER I have been seeing warnings from Debian for several weeks now about
GnuCash's impending removal from Testing.

In past years this has been because of a packaging issue, which always
seems to get resolved by the maintainer before the deadline and things go
on normally.

This time it was apparently more fundamental -- the warnings were because
GnuCash depends upon webkitgtk:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=866671

"webkitgtk: Unmaintained, not suitable for buster"

Again I presumed this is a fairly straightforward issue, but on July 31st I
saw this email:


Debian testing watch 
> to gnucash
> FYI: The status of the gnucash source package
> in Debian's testing distribution has changed.
>   Previous version: 1:2.6.17-1
>   Current version:  (not in testing)
>   Hint: 
> Bug #790204: gnucash: depends on libwebkitgtk-1.0-0 which is deprecated
> The script that generates this mail tries to extract removal
> reasons from comments in the britney hint files. Those comments
> were not originally meant to be machine readable, so if the
> reason for removing your package seems to be nonsense, it is
> probably the reporting script that got confused. Please check the
> actual hints file before you complain about meaningless removals.


Here's the link to that bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=790204

The same volunteer has maintained the Debian GnuCash package for years. I
presume he might have contacted the GnuCash developers for guidance, but I
haven't noticed any messages from him go across the gnucash-dev email list.

I HAVE seen discussions about updating the webkit dependencies, but if
there was any particular urgency I didn't notice.




> -
> 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
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: gnucash update on debian errors, then stops

[John Ralls]

> On Aug 3, 2017, at 8:37 PM, Tommy Trussell  wrote:
> 
> On Tue, Aug 1, 2017 at 8:24 PM, John Griessen 
> wrote:
> 
>> I have not been able to upgrade gnucash for a while now.
>> 
>> Will there be a usable gnucash in the next debian release?
>> If not, why not?
>> 
>> I still use this version on debian stretch/testing/frozen, soon to be the
>> new released debian stable:
>> 
> 
> For now I presume you might switch to using the version at getdeb.net
> though I don't know your particular requirements. Another option, of
> course, is to build it yourself. See https://wiki.gnucash.org/wiki/Debian
> though it looks like a lot on that page is kindof stale, and it doesn't
> link you to the pages describing how to build from git or a tarball -- see
> https://wiki.gnucash.org/wiki/Building
> 
> HOWEVER I have been seeing warnings from Debian for several weeks now about
> GnuCash's impending removal from Testing.
> 
> In past years this has been because of a packaging issue, which always
> seems to get resolved by the maintainer before the deadline and things go
> on normally.
> 
> This time it was apparently more fundamental -- the warnings were because
> GnuCash depends upon webkitgtk:
> 
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=866671
> 
> "webkitgtk: Unmaintained, not suitable for buster"
> 
> Again I presumed this is a fairly straightforward issue, but on July 31st I
> saw this email:
> 
> 
> Debian testing watch 
>> to gnucash
>> FYI: The status of the gnucash source package
>> in Debian's testing distribution has changed.
>>  Previous version: 1:2.6.17-1
>>  Current version:  (not in testing)
>>  Hint: 
>>Bug #790204: gnucash: depends on libwebkitgtk-1.0-0 which is deprecated
>> The script that generates this mail tries to extract removal
>> reasons from comments in the britney hint files. Those comments
>> were not originally meant to be machine readable, so if the
>> reason for removing your package seems to be nonsense, it is
>> probably the reporting script that got confused. Please check the
>> actual hints file before you complain about meaningless removals.
> 
> 
> Here's the link to that bug:
> 
> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=790204
> 
> The same volunteer has maintained the Debian GnuCash package for years. I
> presume he might have contacted the GnuCash developers for guidance, but I
> haven't noticed any messages from him go across the gnucash-dev email list.
> 
> I HAVE seen discussions about updating the webkit dependencies, but if
> there was any particular urgency I didn't notice.

Yes, the webkit1 dependency will be replaced with webkit2 for Unix (webkit2gtk 
doesn't support windows) in 2.8.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: population

[Christine Maloney via gnucash-user]

I am not able to add anything to the credit/debit columns I can only add 
entries to the memo lines which I do not even want there. The version is 2.6.17

-Original Message-
From: Maf. King [mailto:m...@chilwell.net] 
Sent: Thursday, August 03, 2017 5:51 PM
To: gnucash-user@gnucash.org; Christine Maloney 
Subject: Re: population

On Thursday, 3 August 2017 17:01:22 BST Christine Maloney via gnucash-user
wrote:
> When I add the small amount of £1.00 the system takes it in the memo 
> entries, but when I press enter it disappears from the system.
> 
> 

Hi,

Only press Enter if you are ready to commit a transaction to the register.  
Tab to move between all the various fields for data.

If you are putting a 1.00 in the memo, then what are you putting in the 
transfer account and Credit/Debit/Deposit/Withdrawal etc columns?

Which version of GC have you installed, so as to be more stable than what you 
had previously?

Maf.


---
This email has been checked for viruses by AVG.
http://www.avg.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash connect to remote 1and1 database server

[Plutocrat]

Looks like you'd have to enable remote access first:



After you've done that (process includes checking connection with telnet), then 
you should be able to add the database to Gnucash using the hostname (eg 
db987987686.1and1.com) given in your mysql database connection settings. And 
obviously user, password, port.

Some problems:
1) Your IP address will probably change over time. You'd have to update the 
remote access to cope with this
2) The connection is not encrypted by default. So you'd be passing logins, 
passwords and queries across the internet in plain text. Not good. 

P.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.