Wikipedia:Reference desk/Computing

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

The Wikipedia Reference Desk covering the topic of computing.

Welcome to the computing reference desk.
Want a faster answer?

Main page: Help searching Wikipedia

How can I get my question answered?

  • Provide a short header that gives the general topic of the question.
  • Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
  • Post your question to only one desk.
  • Don't post personal contact information – it will be removed. All answers will be provided here.
  • Specific questions, that are likely to produce reliable sources, will tend to get clearer answers.
  • Note:
    • We don't answer (and may remove) questions that require medical diagnosis or legal advice.
    • We don't answer requests for opinions, predictions or debate.
    • We don't do your homework for you, though we'll help you past the stuck point.
    • We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.

How do I answer a question?

Main page: Wikipedia:Reference desk/Guidelines

  • The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
Choose a topic:
See also:
Help desk
Village pump
Help manual

September 10[edit]

Can't login through phpmyadmin[edit]

I've installed Ubuntu in VirtualBox and I have installed Apache, MySQL, PHP, and PHPmyadmin. It did not ask me to set a root password for MySQL but phpMyAdmin requires a password. So I opened up MySQL in a terminal and assigned a new password to root. However, I still can't login through phpMyAdmin. I get the following error messages:

  • \#1698 - Access denied for user 'root'@'localhost'
  • mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

How do I fix this? --Polyknot (talk) 15:44, 10 September 2018 (UTC)

Is this helpful? --jpgordon𝄢𝄆 𝄐𝄇 04:01, 12 September 2018 (UTC)
I have tried up to step 5. At step 6, MySQL gives the following error: "ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded". Also, the file /etc/my.cnf does not exist. I assumed he meant /etc/MySQL/my.cnf but this file had no [mysqld] so instead I found it on the file /etc/MySQL/MySQL.conf.d/mysqld.cnf. --Polyknot (talk) 14:28, 12 September 2018 (UTC)

September 12[edit]

Extra lines added[edit]

I think this is a computer problem rather than something for the Village Pump/Technical page. I'm currently editing using FF 62.0 (64-bit) on Ubuntu 18.04.01 LTS. Frequently I find extra lines added to articles when I edit them such as here which I later removed here. Why is it doing that and how do I stop it? CambridgeBayWeather, Uqaqtuq (talk), Sunasuttuq 05:12, 12 September 2018 (UTC)

Android duplicating files, known issue?[edit]

Is it a known issue that android will sometimes duplicate files? If so, how has Google not fixed this and what causes it? --Polyknot (talk) 10:08, 12 September 2018 (UTC)

  • That is terribly vague. What version of Android? Which files? Under what circumstances do files duplicate? Are you sure it's the operating system and not some other program? You might want to read how to report bugs effectively. (By comparison, your phpmyadmin request above is waaaay clearer.) TigraanClick here to contact me 13:53, 12 September 2018 (UTC)
    • Well, I assumed it was an issue with Android as it happens in both VLC (some songs are duplicated) and the Photo (some images are duplicated) app as far as I can see. I'm running the latest version on a Google Pixel 2 XL. --Polyknot (talk) 14:31, 12 September 2018 (UTC)
      • I've never used Android, but are you sure that the file is duplicated? This looks more as if there is more than one pointer to the file in the meta-data of the application. --Stephan Schulz (talk) 06:16, 14 September 2018 (UTC)
        • Maybe, that's it. I uninstalled VLC, restarted the device, then installed VLC again. The issue seems to be gone for now. Thanks. --Polyknot (talk) 08:05, 16 September 2018 (UTC)

September 16[edit]

Parallel computing on an Intel i5[edit]

I wrote a program to do some intensive calculations and use parallel processing on an Intel i5. I started it about 33 hours ago and I expect it to finish tonight. After I started it, for several hours (the rest of the day yesterday) it was using close to 100% of the CPU. Then this morning it was using only 81%. Then this afternoon it started using only 56%. Every other process combined is using less than 1% of the CPU. I'm losing a lot of CPU processing power - why? (And will it be the same on an i7?) Bubba73 You talkin' to me? 23:56, 16 September 2018 (UTC)

Of course it's impossible to know what is happening without further analysis using software tools. The first thing that's crossing my mind is that the cpu may be overheating. That's easy to check with one of the many cpu temp gadgets that are on the net. Jahoe (talk) 11:31, 17 September 2018 (UTC)
I have experienced cpu usage on a dual core dropping to 50%, and going up to 100% after a brief sleep mode. Cpu usage in parallel processing can depend on the program. Maybe some of the cpu cores have little to do because they wait for data from other cores, or the program doesn't use them at all at this stage. PrimeHunter (talk) 12:42, 17 September 2018 (UTC)
I thought of overheating, but I checked and it was in the 50-60C range, but that was after it dropped to 81%. The program finished, and I'll restart it and check the temperature after it has been running near 100% for a while.
As far as the software tools, I'm using the parallel stuff in Delphi XE 10.2, in particular the parallel for. I've used this before, but not for runs over 24 hours. The way the program is designed, it should be using all four cores until near the end of 48 cases. (I tested it on smaller cases.) Bubba73 You talkin' to me? 16:52, 17 September 2018 (UTC)
As a test, I restarted it. It has been running at 99% for a while and the CPU temps have gotten up to an average of 59C and leveled off, with individual ones never getting above 63C, which is well within specifications (< 73C, I think). Bubba73 You talkin' to me? 17:31, 17 September 2018 (UTC)
Several hours later and it is still running at 99% and averaging 59C. Bubba73 You talkin' to me? 20:20, 17 September 2018 (UTC)
It's really dangerous to speculate without more details - but the symptom described implies that your computational task can't keep the CPU busy. This almost always means that your work is "I/O bound." If you aren't explicitly doing file I/O - which you would already know about - then the next most probable culprit is file-backed paging implemented by the operating-system's virtual memory system. What does the memory usage look like? Does it all fit in physical main memory, or is the memory footprint larger than the available RAM?
Nimur (talk) 17:44, 18 September 2018 (UTC)
There is essentially no I/O. It was running 48 outer loops and wrote one line after each was finished, and then one line at the end (all to the screen). It did keep the CPU busy for several hours, then the CPU use started dropping. (I started it about 10AM and it was still running full blast late at night, but the next morning it had dropped to 81%. Later it dropped to 56%.) There were no files in use. I have something else running on that computer now, so I can't look at the memory usage, but it has 32GB and the program uses very little memory, although the EXE is about 12MB. It should have been using only a tiny fraction of the RAM. Bubba73 You talkin' to me? 18:08, 18 September 2018 (UTC)
The i5 I was running the program on is going to be busy for about 2 more days, but I did some tests on smaller cases on an i7. Memory use was 2.2MB. I was running 42 outer loops (each loop's running time is exponential in a n, which is different from the number of loops). On the i7, it starts out running 7 threads. when it finished 24 outer loops, it dropped to running 6 threads. After about 27 outer loops, it dropped to 5 threads. And after 35 outer loops, it seems to have dropped to running 4 threads. So I think this is something that the Delphi Parallel Programming Library is doing - it must think that is is using too much CPU, so lowering the number of threads it is running. Bubba73 You talkin' to me? 18:41, 18 September 2018 (UTC)
A book I have that covers Delphi says "The Thread Pool is 'self tuning' in that it automatically takes into account the number of cores your CPU has, as well as the current burden on those cores. It creates threads as needed, trying to maximize the capabilities of your machine. When the system is free it creates more threads... ". This is probably second-guessing what I am doing, but it is not working as the book describes. The i5 is a bare-bones system - everything else is taking only a fraction of a percent of the CPU (that isn't true for the i7 I was using.) It is cutting down the number of threads after about the half-way point. I will try doing the first half and then the second half and see what happens. Bubba73 You talkin' to me? 18:58, 18 September 2018 (UTC)
Breaking it into two parts made it keep the CPU as busy as it should (at least for the 4.6 minutes it took to run). Bubba73 You talkin' to me? 19:18, 18 September 2018 (UTC)

Play two audio tracks (different languages) at the same time[edit]

To watch a movie I connect my laptop through HDMI to the TV. When watching alone it's not a problem to watch a movie in the track that I wish, obviously. However, if a group is watching, some would like to hear track A and others track B. Is there a way to play track A through TV and track B through head phones? If there are 2 laptops available, it would be trivial to play both at the same time. However, how could I perfectly synchronise the audio played by each one? The two laptops could be any combination of Windows, Linux and Mac. So far the best solution I could think of is to run two Linux laptops, and through the command line set them to start playing the same file at time t. After pauses, set them to play a file from a specific minute on at a certain time. That would coordinate two copies playing different audio tracks. --Doroletho (talk) 23:57, 16 September 2018 (UTC)

This is not a common feature of free- or low-cost consumer video playback hardware and software. If you start with professional-grade commercial software, it's pretty easy to configure audio streams and route playback through different hardware outputs to different speakers - or to a software mixer and thence to a single speaker - or whatever you seek.
If your target is low- or zero- cost, you might start by developing expertise with your favorite Linux or Windows software. VLC is a popular configurable playback tool, and it has a standard procedure for multi-track audio and even has a quick tutorial for multi-instance playback if you choose to use that method. You might also want to learn how to use your system's audio mixer. On linux-like systems, JACK is a very popular audio tool suite; on Windows, the built-in system is controllable through the built-in volume control user-interface.
These procedures aren't easy, which is why there is still a market for commercial (non-free) video playback software.
Nimur (talk) 15:15, 17 September 2018 (UTC)

September 17[edit]

How to change a default setting in Microsoft Word[edit]

I am using Microsoft Office Word 365. I would like to know if -- and how -- I can change a default setting in Microsoft Word. For example, if I type a capital letter A and then hit enter/return, the Word program "thinks" that I want to make a bulleted list with sections A, B, C, D, etc. As such, Word starts to "bullet" the A (and so forth) and starts to create a bullet list. Similarly, if I type a number 1 and then hit enter/return, the Word program "thinks" that I want to make a bulleted list with sections 1, 2, 3, 4, etc. So, I have the same problem. I assume that this is some type of default in Word. Can I change it? How? Thanks. Joseph A. Spadaro (talk) 19:00, 17 September 2018 (UTC)

Click File>Options>Proofing, then click the "AutoCorrect options" at the top of the box. Choose the "AutoFormat" tab, then uncheck "Automatic bulleted lists" and "List styles" and click "OK". If you just want to undo the setting for a single instance, just press Ctrl + Z (⌘ Cmd + Z on macOS) after the list format has been automatically started. TheMrP (talk) 00:46, 18 September 2018 (UTC)
Thanks. By the way, I also noticed that when I type a symbol such as the asterisk (*), the same "automatic" bullet list occurs. I changed the default with the steps you outlined. Thank you. Now, if there is an occasion when I do indeed want to create a bullet list (with the default set to "off"), how do I do that? I looked around. I thought I would find a function that says "insert bullet list" or some such. But, I was not able to find that. Thanks. Joseph A. Spadaro (talk) 14:40, 18 September 2018 (UTC)

September 18[edit]

Why doesn't Eshell support input redirection?[edit]

(no clear answer here)

Thanks. Apokrif (talk) 00:41, 18 September 2018 (UTC)

September 19[edit]

Plotting GPS locations of pictures in a Wikimedia category[edit]

I would like to look at a Google Maps display of London, England, with the locations highlighted for each photo in this category of photos on Wikimedia. I am assuming the photos all have their geotags intact. Is there an easy way to do this? Thanks in advance - Tarcil (talk) 16:30, 19 September 2018 (UTC)