database design – A table containing all the identifiers associated with a user – bad idea?

I was wondering if it was a very bad idea to have a table containing all the identifiers associated with an entity?

For example, let's say I have 3 tables each containing data about a user. Should I use an extra column called user ID in profile and settings table or should I use an extra table called USER_INDEX and use joins?

[1]USER
login
E-mail
password
salt
created

[2]PROFILE
login
Full Name
organic

[3]SETTINGS
login
max_packets
delivery day

[4]USER_INDEX
user ID
indentity map
settings_id

Will this make queries slower? Is it worth the extra code? Is it even a motive? May be EAV? I mean I've seen something similar in Magento but I'm not sure it's exactly the same). Can this improve performance or just a moment of "well-being of OCD"?

In the process of using MySQL 5.7.26 and I thought about using InnoDB as a storage engine. The application will be written in PHP 7.3. Ubuntu OS 19.04.

Thank you!

privacy – Idea: With the help of a Mediawiki XML file, is it possible to create a "virtual wiki" without downloading to a server?

That is, someone sees fundamental obstacles in the development of a program that can take input XML files, and then create a browser-like interface in which a user might change that. XML file as if it was actually a wiki?

The idea would be (for example) useful if you do not have a server and want to: have a visible copy a wiki or keep a private / personal wiki on a USB stick instead of paying for a server.

If virtually "edit" the wiki (in a virtual wikieditor which only changes the XML) is too far away, so at least a virtualviewerWould seem reasonable for me? Preferably, one who can imitate hyperlinks and categories, etc. (Of course, the files / images are lost)

I am a wiki user, but I only know the basics of web development. I appreciate your help.

green addresses are "generally considered a bad idea and not advisable to implement"?

Why does the wiki say that green addresses are "generally considered a bad idea and that it is not advisable to implement them"? en.bitcoin.it/wiki/Green_address

Do you have an idea of ​​the difference between digital marketing and advertising?

I am looking for an advertising agency for my new website. I have trouble understanding the difference between advertising and digital marketing. I quote these two things for advertising and digital marketing. But in reality, what is the difference between them? I've gone through all the best resources I can find when researching, but confusion always sets them apart.

https://dashtwo.com/blog/what-is-outdoor-advertising-and-why-is-it-important/
https://blog.hubspot.com/marketing/what-is-digital-marketing
https://wpitech.com/google-rankbrain-seo/
https://www.encorenationwide.com/blog/experience-matters-brand-activation-and-experient-experial-marketing/
https://evolveactivation.com/why-brand-activation-works/

If anyone can explain me, what is the difference between advertising and digital marketing?
SEMrush

browser – Is it a good idea to mute a video during a scroll or tab change?

Recently, I see this behavior a lot and hate it with all my might.

Suppose I'm watching a video (eg on Twitter), but the only thing that interests me, it's the audio. I continue to use Twitter (or anything else), but when I scroll down the screen until the video touches the edge of the screen, I will not be able to play it. audio is disabled.

OK I understand. I repeat, leave the parchment where he wants to be and start working on another tab. Surprise! The audio is muted again.

I think it's horrible in itself, but to make matters worse, this damn video continues to play, so if I want to continue listening to it, I have to look for the post I was in, that which is already serious enough on a FHD computer screen. but is really terrible in a smartphone.

Why is it so widespread? Is it considered a good UX? Something I miss here?

authentication – LDAP can not connect with STARTTLS when implementing secure passwords, it is possible to reconnect after switching to SSL / TLS. An idea why?

A lot of substance, but the main question is:
Why can not we connect after setting up secure LDAP passwords on STARTTLS, but when we changed to SSL / TLS, can we? Previously, we could connect and we had not changed the encryption.

Our configuration:
For a small non-profit NGO, we operate a website (PHP 7.2) including a sub-domain for our volunteers. Of course, volunteers must have an account and log in. For storage of relevant files for volunteers, we have a Synology NAS configuration (and a backup, of course).
To ensure that volunteers can use the same account for the NAS and for our website, the NAS has an LDAP directory server configuration, which functions as a provider server. When a volunteer logs on to the website, the credentials are checked using LDAP. In addition, there are options to change passwords and others, all that you normally expect.

When a user changes their password on the website, it will be on the LDAP server via ldap_mod_replace ()so that the user can connect to both places with the same identification information. Until here everything is fine.

Our actions:
When you change the password via the & # 39; DSM & # 39; (Disk Station Manager, the proprietary software of Synology NAS), it is automatically salted and hashed with the help of SHA-512. However, we discovered that when switching via PHP (with ldap_mod_replace () ), it is simply stored in plain text. Obviously, a risk that we were not willing to take.

To mitigate this, we wrote code for salt and hash in PHP before replacing it. The end result should be the same as changing it via Synology. It seemed that Bcrypt, for example, was not available, so we still used SHA-512. To ensure that all users have hashed passwords, we automatically generated random passwords, hashed them and replaced current passwords, and forced everyone to change their password. Disadvantage but necessary.

The problem: After that, all the passwords were replaced by new random passwords. The connection to the website was still working, and with the admin accounts, we could still connect via software like Apache Directory Studio. However, when we tried to connect via the DSM, we received errors indicating that our username or password was invalid. Even when we changed the passwords with the help of the DSM, we still have the same mistakes. Even when we re-entered passwords in plain text, we still could not connect.

The solution: After trying a lot of things, the solution has proven quite simple. The LDAP * client on the NAS had to have encryption set to SSL / TLS instead of STARTTLS, as it was before. After that, we could reconnect. This solution was more a lucky strike than a well thought out plan.

* Client, in this case, because the NAS is running an LDAP provider but also a client, for connection and directories.

The question: Do you have an idea of ​​the cause of this problem and why did this solution work? We have not changed any LDAP server or LDAP client settings, we only changed the passwords. As far as we know, this should have had effects on the encryption used for the connection. If anyone has an idea, we would like to hear them! It works now, but why is a complete mystery for us.

Also, please let me know if this is not the place to ask for this!

nvidia – Ubuntu 18.04 crashes. I have no idea what causes it

I updated my desktop computer on June 21, according to the following specifications:

Proc: Ryzen 5 2600 (Cooler stock)
MB: MSI B450 Bazooka More
RAM: Kingston Hyper X Fury 2x8GB 2666
GPU: GTX 1050
PSU: Seasonic S12? 80+ Bronze 520 Watts

And since then, will Ubuntu crash or crash? No display, no keyboard / mouse input (no power) and the EZ DEBUG LED on the MB CPU turns on.

I've tried to contact MSI, but they give me solutions for cases where the unit does not start totally with the processor LED on and for WINDOWS (argh!)

You will find below the last part of syslog before the crash:

https://pastebin.com/vyHDDk9b

Do you have any idea of ​​the average aspect ratio of the company logos?

From the beginning, I understand that the proportions of the logos of companies vary enormously, and that the best solution will take into account when displaying the logo of the company. Therefore, do not respond with "it varies" or "just use an adaptive design and do not worry about it."

The application I design allows companies to create a profile. The most interesting element visually is their logo. Not only do I have to design pages that best display this information, but also a printed report with a heavy logo.

I understand that my design should work for both vertical and horizontal logos, but I am extremely curious to know if anyone has ever searched for the average display format of the logos. I guess it was a little horizontal. Maybe 1.5: 1. Does any one have a more evidence-based theory about it?

Is it a good idea to disable as many Samsung apps as Samsung lets you and install a Google alternative for them?

I do not know which applications consume more RAM and CPU. How will this affect performance if storage is not a problem for me?

New idea to increase website traffic

Hi guys,

do you have an idea to grow and generate more traffic
Especially for the site of finance and investments.

Happy if you can share here with me

Thank you