My HV ATL2 Server

I have a server in Hivelocity’s ATL2 datacenter that hasn’t been accessible for 1 hour. Does anyone else have a server there that’s not acce… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1818140&goto=newpost

sql server – Calculating percentiles of a FROM command

I have a query which generates a table of trials and values from a database (example pic below)

SELECT * FROM (ReMetrica).(ReMetrica_Result).(GetTrialValuesAsDouble) ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1)

which is an expression we’ve been given with this bit of software.

enter image description here

I can calculate the mean of all these trials by using:

SELECT avg(Value) FROM (ReMetrica).(ReMetrica_Result).(GetTrialValuesAsDouble) ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1)

However I’m trying to extend this to calculating percentiles as well with

SELECT percentile_cont(Value) OVER (ReMetrica).(ReMetrica_Result).(GetTrialValuesAsDouble) ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1)

which doesn’t work due to an ‘incorrect’ syntax after OVER. Could someone help me with where I’m going wrong?

linux – How to install nginx-module-brotli on ubuntu 20.04 server?

i have a server with ubuntu 20.04

I installed brotli on it, but I am unable to install nginx-module-brotli for my nginx server.

Here is my command line :

$ sudo apt install nginx-module-brotli

Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package nginx-module-brotli

How to install nginx-module-brotli on ubuntu 20.04 server ?

I tried to compile with the following commands :

$ git clone https://github.com/google/ngx_brotli.git
$ sudo ./configure --with-compat --add-dynamic-module=../ngx_brotli
$ sudo make modules
$ sudo cp objs/*.so /etc/nginx/modules-available

I have the following error :

$ sudo ./configure --with-compat --add-dynamic-module=../ngx_brotli
sudo: ./configure: command not found

UPDATE

Here are the commands I use to install Brotli for Nginx :

$ wget https://nginx.org/download/nginx-1.17.10.tar.gz
$ tar zxvf nginx-1.17.10.tar.gz
$ git clone https://github.com/google/ngx_brotli.git
$ cd nginx-1.17.10
$ ./configure --with-compat --add-dynamic-module=../ngx_brotli
$ make modules
$ sudo cp ./objs/*.so /usr/share/nginx/modules

I have a problem with this command :

ubuntu@pv-gghhghghg:~/nginx-1.17.10$ make modules
make: *** No rule to make target 'modules'.  Stop.

sql server – Converting multiple rows to one row

I have the following data coming from Finger Print devices, Each In and Out of employees are recorded.

UserId         CheckTime              CheckType
------        -----------            -----------
  2      2020-08-03 08:15:12.053          I
  2      2020-08-03 16:00:00.053          O
  2      2020-08-04 08:00:12.053          I
  2      2020-08-04 16:10:00.053          O

I want the above data to be as following:

UserId         CheckTime           CommingTime                 LeavingTime
------        -----------          -----------                -------------
  2           2020-08-03           08:15:12.053               16:00:00.053
  2           2020-08-04           08:00:12.053               16:10:00.053

**Note: ** A user can have multiple In Out record per day

I have tried the following answers but didn’t help:

How to merge multiple rows into one row with SQL?

Any idea??

How to OpenVpn Server (Docker) port fowarding to Openvpn client with Docker container service (elasticsearch)

I would like to reach a docker elasticsearch container over OpenVPN but i don’t know how to tell OPenVPN server to port forward 9200 elasticsearch port to the OpenVPN client with the service.

Network schema

Scenario:

Openvpn Server - [public AWS Ubuntu ec2 instance with docker openvpn container]

client 1 - [LAN 1] - [192.168.0.14/24] behind NAT Router
Windows Server Host [OpenVpn Client connected OK]
VirtualBox with Ubuntu LTS Guest Docker
Elasticsearch docker container port 9200
     
client 2 - [LAN 2] - [192.168.0.190/24] behind NAT Router
Windows 10 [OpenVpn client connected OK]
Wants to connect elasticsearch 9200 Client 1

Goal:

Avoid to opening ports on LAN 1 Router. Client 2 wants to reach elasticsearch docker container in Windows Server client 1 over the VPN.

I need some help on what steps i would have to follow to achieve this.

centos7 – Server is down after changing machine type in Google Cloud Platform

I changed my machine type(GCP) by stopping the instance, after increasing the machine type I restarted the instance and now server stopped working, the website is down now.
Upgraded from 1 vCPU, 1.7 GB memory to 2 vCPU, 4GB memory.
And if I select other than 1 vCPU, 1.7 GB memory, the webserver doesn’t respond.
Also, I can’t access SSH from a web browser it gives me an error that “Connection Failed. We are unable to connect to the VM on port 22.”

Log: https://pastebin.pl/view/2af02149

sql server – My SQL assignment having issues with some queries

enter image description here

The number of users, for whom the last activity was done with device_name = “phone”, but who have also at least one additional activity with another device.

Select d.device_name,COUNT(DISTINCT a.active_user_id ) from activities a INNER JOIN devices d ON a.activity_device_id=d.device_id WHERE d.device_name=“phone” and a.activity_is_last=“true” and exists(select d.device_name,DISTINCT(a.active_user_id) from activities a INNER JOIN devices d ON a.activity_device_id=d.device_id WHERE d.device_name IN (“computer”,”tablet”) and a.activity_is_last=“true”);

kubernetes – ETCD client connection to etcd servers from k8s api server issue

We expect the following issue with etcd cluster. We generated certificate with the following configuration:

{
    "CN": "client",
    "hosts": (""),
    "key": {
        "algo": "ecdsa",
        "size": 256
    },
    "names": (
        {
            "C": "US",
            "L": "CA",
            "ST": "San Francisco"
        }
    )
}

But receive this error:

error "tls: "10.105.113.108" does not match any of DNSNames ("") (lookup : no such host)", ServerName "etcd-kube-cluster-3.test.com", IPAddresses (), DNSNames (""))

But lookup is working:

;; ANSWER SECTION:
108.113.105.10.in-addr.arpa. 54 IN  PTR ip-10-105-113-108.ec2.internal

How to fix this issue?

i moved magento store from one server to another server, it is displaying only half page except for homepage and admin

i moved magento store from one server to another server, it is displaying only half page except for homepage and admin, phtml files and cms pages are not loading.
enter image description here

files – How to move a Drupal 8 site to a new server?

I have a Drupal 8 site on an Ubuntu 18.04 server and want to move my site to a new server with Ubuntu 20.04.

With Drupal 7 I did these steps

Create a set of keys (on the new server) :

$ sudo ssh-keygen -t rsa -b 4096 -C root@www-example-com
$ sudo cat /root/.ssh/id_rsa.pub

Add the public key (on the old server) :

$ sudo nano /root/.ssh/authorized_keys

Export the database (on the old server) :

mysqldump -u root -p www_example_com > /var/www/www-example-com/share/www-example-com_$(date +%F).sql

Repatriate the site file (on the new server) :

$ sudo scp -r -p root@xxx.xx.xxx.xx:/var/www/www-example-com/ /var/www/www-example-com/

Import the database (on the new server) :

mysql -u root -p www_example_com < /var/www/www-example-com/share/www-example-com_2020-08-10.sql

That’s all, with these intructions, the Drupal 7 site works.

The problem

Now with Drupal 8 there is Composer with a new folder and file tree present in the var directories and in home.

How to move a Drupal 8 site to a new server ?