Latest Server related questions

Score: 1
Why does MariaDB CHAR_LENGTH return NULL instead of 0 when a field is NULL?
gb flag
Tim

I am trying to calculate to total size of stored metadata in a table using CHAR_LENGTH to add up the size of the relevant fields in each row to get a rough idea of the storage size of a result set.

I don't want the size of all the data in the table, only the size of a set of results.

However, some fields in the table have NULL values and as soon as CHAR_LENGTH hits one of those the whole calculation ...

Score: 0
802.1x authentication - network connection doesn't recover during user logon
cn flag

I set up the 802.1x connection in my test VM, running Win10 Pro connected to a domain. It works fine if I disable and then enable the network adapter with 802.1x port authentication setup:

enter image description here

But when I log out the user and try to log back in under the same user account, the connection always fails. And the Wired-AutoConfig server has the following error message in the event log:

Reason: 0x70006
Reason ...
Score: 2
network connectivity testing in a private network
ar flag

I have a system with 2 network cards. One connected to the public network, another is connected to a private network for testing. The port for private network is connected to a juniper switch configured dhcp service like as below:

system {
    host-name sw-juniper-4550;
    auto-snapshot;
    root-authentication {
        encrypted-password "$1$kl8CbOgC$bZZVKTwrt8xxxxxxxx"; ## SECRET-DATA
    }
    ...
Score: 1
Corobori avatar
How to block those requests?
mw flag

One of my website seems to be being under attack. I am getting requests, as shown below, from several IPs addresses. Is there a way to block them?

From event viewer

Score: 0
PHP Guru avatar
PHP can't write to /tmp folder anymore after Apache update
vn flag

Linux dist: Ubuntu 18.04.5 LTS Server version: Apache/2.4.29 PHP Version: 7.4.20 with PHP-FPM

Recently this server did an automatic upgrade of Apache and ever since PHP can't write to /tmp breaking many sites. PHP functions like tmpfile() and move_uploaded_file() are returning false. PHP's file_put_contents() and fopen() when attempting to write to that folder also fail. sys_get_temp_dir() return ...

Score: 1
FlyingPenguin avatar
Redirecting Error with google load balancer
mx flag

I'm trying to setup Google Load Balancer and couldn't get it work. It produces either 502 or 302 error.

Wanting to direct www to non-www, http to https.

This is my rewrite rule

    SetEnvIf X-Forwarded-Proto https HTTPS=on
    <VirtualHost _default_:80>
      DocumentRoot "/opt/bitnami/apache/htdocs"
      Include "/opt/bitnami/apps/letsencrypt/conf/httpd-prefix.conf"
      <IfModule mod_proxy.c ...
Score: 1
Stephen Daniel avatar
GCP service account permissions
br flag

GCP newbie here, hopefully there is a quick answer I'm missing.

I have project with a GCE VM running in it. I'd like to backup a data set from time to time to GCP's object storage. My plan is to run 'gsutil rsync ...' from a cron job.

I created a bucket for the job to use. I did not edit permissions, roles or anything on the bucket.

I run "sudo su -" so that I am running as root, as I expect a cron  ...

Score: 0
Build ansible Dockerfile results error Could not find pip3
uz flag
FROM centos:7

RUN yum check-update; \
    yum install -y gcc libffi-devel python3 epel-release; \
    yum install -y python3-pip; \
    yum install -y wget; \
    yum clean all

RUN pip3 install --upgrade pip; \
    pip3 install "ansible"; \
    wget  ...
Score: 0
John V Dole avatar
How do you generate a new encryption key for a drive that uses SED (Self Encryption Drive)
de flag

So I'm currently learning more about NVMe drives that ship with a feature called SED (Self Encrypting Drive). Take the Smasung 970 EVO for instance. It clearly states that it features SED.

The 970 EVO provides multiple advanced data encryption features. Self-Encrypting Drive (SED) security technology will help keep data safe at all times. The 970 EVO includes an AES 256-bit hardware-based encr ...

Score: 0
Alejandro Velasco Soto avatar
Joining computer to EC2 Active Directory With OpenVPN
gr flag

I currently have 2 servers configured on AWS, one is a Windows server 2019 and another is an OpenVPN Access server, on the Windows server is configured a local active directory (company.local), and on the OpenVPN server is configured the VPN, the OpenVPN service is also connected with the AD, at this point is possible connect to the VPN through a domain user.

The problem is when I try to join a c ...

Score: 0
Reid Heffner avatar
Running Chef-client on a remote server behind firewall through SSH tunnel
eg flag

I have a remote oracle linux node that needs to have chef-client ran. This node is behind a firewall. I have access to the server command line via ILO, but need to run chef to install VPN software. How can I get connectivity to my chef server through a SSH tunnel?

Score: 0
GKE load balancer "UNHEALTHY state" after multiple suggestions
in flag

I have been trying to set up a simple Kubernetes cluster with one container, a node port, and an ingres load balancer. However, no matter what I do, the ingres load balancer always shows, "Some backend services are in UNHEALTHY state." I have searched several forums and found the following suggestions:

  • Increase the size of the nodes
  • Change the externalTrafficPolicy of the node port service from
Score: 1
Adding Ciphers to Server 2012 R2
us flag

I need to add the following Ciphers to my server:

TLS_DHE_RSA_WITH_AES_128_GCM_SHA256

TLS_DHE_RSA_WITH_AES_256_GCM_SHA384

I found the following article: https://docs.microsoft.com/en-us/windows-server/security/tls/manage-tls

However, it's not too clear to me. The list I get from the "SSL Cipher Suites" field contains 39+ Ciphers and is A LOT longer than the allowed 1023 characters. While in ac ...

Score: 0
Capacity Estimation for Physical Machines Hosting Simplified Nextcloud Instances
in flag

I am writing a grant to provide students with free access to Nextcloud VMs, and I need to budget for physical machines. The question is, how can I estimate the number of VMs running just Nextcloud (with just the file sharing applications, basically--no videoconferencing or live editing or similar) that can be supported by a single physical machine? I need this to budget for the number of physical machin ...

Score: 0
Image resizing and caching in NGINX after authentication and 302 redirect
lr flag

I'm having issues with resizing and caching images. Here is my non-performant setup without caching:

  1. Client makes request for website.com/static/image.jpeg
  2. NGINX routes to API
  3. API authenticates user, generates S3 presigned URL, returns 302
  4. NGINX handles redirect, resizes image, returns image to user, ignorant of the presigned URL

I'm able to do both caching resizing, but the cache is queried before  ...

The Stunning Power of Questions

Much of an executive’s workday is spent asking others for information—requesting status updates from a team leader, for example, or questioning a counterpart in a tense negotiation. Yet unlike professionals such as litigators, journalists, and doctors, who are taught how to ask questions as an essential part of their training, few executives think of questioning as a skill that can be honed—or consider how their own answers to questions could make conversations more productive.

That’s a missed opportunity. Questioning is a uniquely powerful tool for unlocking value in organizations: It spurs learning and the exchange of ideas, it fuels innovation and performance improvement, it builds rapport and trust among team members. And it can mitigate business risk by uncovering unforeseen pitfalls and hazards.

For some people, questioning comes easily. Their natural inquisitiveness, emotional intelligence, and ability to read people put the ideal question on the tip of their tongue. But most of us don’t ask enough questions, nor do we pose our inquiries in an optimal way.

The good news is that by asking questions, we naturally improve our emotional intelligence, which in turn makes us better questioners—a virtuous cycle. In this article, we draw on insights from behavioral science research to explore how the way we frame questions and choose to answer our counterparts can influence the outcome of conversations. We offer guidance for choosing the best type, tone, sequence, and framing of questions and for deciding what and how much information to share to reap the most benefit from our interactions, not just for ourselves but for our organizations.