I have money in some Vanguard funds (VTSAX and VTTSX), and track my money locally in GnuCash. Some time ago, I had it set up to automatically update the prices of these funds (Price Editor → Get Quotes). The last time this definitely worked was March of 2017. More recent attempts to autofetch prices have resulted in "There was an unknown error while retrieving the price quotes". I've finally gotten fed up with manual input and want to get the automatics working again. I already found  saying that the Yahoo Finance API is gone, but these securities are set up with the single quote source "Vanguard", not any of the Yahoo sources. Would the fix be the same as for the Yahoo issue, or is this unrelated?
I made the jump from Jumsoft's Money app to GnuCash a while back. It appealed to all my OCD tendencies. I don't know how to use Perl, or stuff of the sort, but with detailed instructions I manage to get things done... when I can find them.  I set up Finance::Quote to pull quotes after I set up GnuCash. I even managed to get it to pull quotes for Korean funds. And every thing had been working well, until tonight. I only get back a pop-up that states "There was an unknown error while retrieving the price quotes." That's where I need help. What can I do?  I dug around and found that it seems that it has something to do with Yahoo Finance ending it's API support. I also learned that Finance::Quote can pull data from many sources, so I don't really understand why one missing API would break it. I also saw that someone out there is trying to use AEX to pull the quotes instead for GnuCash specifically. I found Finance::Quote on cpan (I also first heard of cpan), but I don't understand what I'm looking at. But that's all beside the point. I don't know how to fix this.  Any help would be appreciated. I'm on Windows 10, GnuCash version 2.6.17, and have Strawberry Perl 5.18.2.2-32bit installed.  edit Thanks everyone who responded. It seems to be working more or less. The currency and Korean funds still haven't updated, but you've shown this horse to water. I'll do my best to drink it now.
Can you enter the Schengen area with a UK visa? I'm a UK passport holder; my wife isn't. We don't live in UK. If she gets a UK visit visa, does this entitle her to travel to the Schengen area or do I need to get her a separate Schengen visa? Please consider the integral:  $$\int_{-a}^{a}x^2dx=\frac{2a^3}{3}$$  I would like to know why I can't make the substitution:  $$u=x^2$$  When I make the substitution, the limits of the integral will be the same, and the integral itself will be zero, which is the wrong answer. So why does this simple change of variables not work as I have expected?  Please note that I do not want help solving the integral, I know how to solve it several ways. My question is why does this specific attempt at a solution not work? I am trying to connect to a Linode (running Ubuntu 12.04 LTS) from my local machine (also running Ubuntu 12.04 LTS)  I have created a private and public key on my local machine and copied my public key to my Linode's authorized_keys file.  However, whenever I try to ssh to my Linode I get the error message Permission denied (publickey).    It's not a problem with how ssh is set up on my Linode because I can ssh to it from my Windows machine using key authentication.    In my .ssh directory on my local Ubuntu machine, I have my id_rsa and id_rsa.pub files.  Do I need to create an authorized_keys file on my local machine?    EDIT:  This is what I get when I run ssh -vvv -i id_rsa [youruser]@[yourLinode]:  debug3: authmethod_lookup publickey debug3: remaining preferred: keyboard-interactive,password debug3: authmethod_is_enabled publickey debug1: Next authentication method: publickey debug1: Offering RSA public key: id_rsa debug3: send_pubkey_test debug2: we sent a publickey packet, wait for reply debug1: Authentications that can continue: publickey debug2: we did not send a packet, disable method debug1: No more authentication methods to try. Permission denied (publickey). I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password:  mysql -u root    it says  ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )   But it's okay when I enter mysql -u root -p   I can't figure out what the problem is. Is using only HTTPS bad in a SEO perspective? Can low-gravity planets sustain a breathable atmosphere? If astronauts could deliver a large quantity of breathable air to somewhere with lower gravity, such as Earth's moon, would the air form an atmosphere, or would it float away and disappear? Is there a minimum amount of gravity necessary to trap a breathable atmosphere on a planet? Unfortunately MyApp has stopped. How can I solve this? markdown doesn't work properly customize of autoref Transit in LA after 90 days in North America under VWP/ESTA I am from NZ and have spent 90 days in the USA with an ESTA visa waiver, and I am going to Canada before returning to NZ. My return flight is from LA but I have already used my 90 days of my ESTA and have not technically 'left' North America (Canada apparently doesn't count). My question is, how do I catch my return flight from LA? Can I get another ESTA even though I haven't left North America? Search [tag1] OR [tag2] Is there a way to search questions that are tagged with either tag1 or tag2?  Actually, I would like the general filter,      ([tag1] AND [tag2], ...) OR ([tag3]   AND [tag4], ...) OR ...   And even     [tag1] AND ([tag2] OR [tag3])   I need that because I'm looking for interesting questions and I have to search for each tag separately. How many $4$ digit even numbers have all $4$ digits distinct ?   This question has been asked if we replace even with positive.   I was solving this Problem like: For first position $1-9$ (No $0$) for next $0-9$ (leaving out the digit which has been choose) for next $0-9$ (leaving out $2$ digits), but on last digit I get stuck. From what I should choose. Will it be $0, 2, 4, 6, 8$, because number needs to be even? How should I solve it? How do I evaluate this integral $\int_0^\pi{\frac{{{x^2}}}{{\sqrt 5-2\cos x}}}\operatorname d\!x$? Show that $$\int\limits_0^\pi{\frac{{{x^2}}}{{\sqrt 5-2\cos x}}}\operatorname d\!x =\frac{{{\pi^3}}}{{15}}+2\pi \ln^2 \left({\frac{{1+\sqrt 5 }}{2}}\right).$$   I don't have any idea how to start, but . Is there a way to have Cycles skip rendering alpha? When my phone MOTOROLA G3(2015) is updated to Marshmallow, its not showing files when connected to PC. While connecting, it shows options as charing only, PTP, MTP, MIDI. When I select MTP, it shows the external card, but not showing the contents, where as internal memory is detected and all files are shown. How do I get useful SQL Server database performance statistics? We currently have several shared SQL Server servers and instances in our organization. They are going with a different architecture where business units will get their own SQL Server instances. We have SQL Server 2008R2.  In the past, databases were put on servers in a more or less random fashion -- business use and disk space were the main drivers.  I've been tasked with coming up with a plan for allocating our 50+ databases across 3 servers (one instance per server). My criteria for divvying them up is as follows:   Business critical db's should be spread across the servers. i.e. avoid lumping a bunch of business critical db's all one server.   For the remainder of the non-mission critical db's, consider: a. Disk space usage b. I/O usage -- memory, CPU, etc.     1 and 2a are easy for me to figure out. I know how to get data file sizes.   My question is with that last bit - 2b. I do not know how relevant this is, what specific stats to look at, or how to get them.   Frankly, I'm not 100% sure how to phrase this question! I think I basically want to know is, "How 'busy' is this db -- however you define 'busy'?" Or maybe, "How does this db impact the performance of the server?"  I mean, disk space is important -- but it could (in theory) have a ton of rows or binary objects in there that are not written very often, so it has little impact on the performance of the server. I think I would want to know how much impact a db within a date range.  Is there a way to get these kind of general stats? I'm not looking for expensive queries, detailed user stats, or query optimization here. I'm aware of the SSMS reports, but they seem to be more real-time. The end goal is to divide up our current databases into evenly balanced buckets, and I would think performance is one way to do that.  Thoughts? Wisdom? Any other ideas on how to divvy up the db's?  Thanks! Tom I am an Australian currently on a Netherlands working holiday visa that ends in May next year. I would like to know if when my visa ends I then get another 90 days just as a regular tourist visa as I would like to do some more travel within Europe when my visa ends before going home to Australia. Mysterious cord running from wall. Safe? Question regarding the validity of the big bounce I have several questions regarding the "big bounce" theory. It appears to be popular among LQG researchers. My questions are as as follows.  1) How one reconciles it with the fact that it is now experimentally established that the universe is expanding in an accelerating manner?  2) The entropy of the universe should have been very very low (maybe zero) at the time of the big bang/ big bounce. What was the entropy "before" that event? Was it even lower? If it was lower then doesn't that mean entropy decreases indefinitely? On the other hand if we accept the entropy was higher then doesn't that violate the second law of thermodynamics?  3) What observational evidence can confirm pre-bounce physics? According to GR there are some points near the bang/bounce where one simply can't easily define time in a meaningful way. Even for a quantum gravity theory, is it possible for any theory to extrapolate itself "before" the "bounce"? If there are no observational consequences after the bounce shouldn't one apply Occam's razor? Evaluate $\int_0^{\infty}\frac{\log x}{1+e^x}\,dx$