Hasan Can Saral's questions

I have a patch panel with the following female/female CAT6 RJ45 snap-in connectors in my cabinet:

It basically serves as a pass-through for the cables at the front to the cables at the back and vice-versa.

The problem is, these connectors are extremely fragile, and if I want to connect two cables at the back via this patch panel (i.e. two of the connectors above is used):

CableBack1 -> Con1 -> CableFront1 -> Con2 -> CableBack2

to connect CableBack1 to CableBack2, the physical connection gets very fragile (I literally need to adjust the positions of the cables to get a connection, and it mostly doesn't work anyways).

So my questions are:

1. Am I having a problem because I might have a different kind of connection (e.g. crossover, etc.)?
2. Is what I'm doing wrong? Is there a better way to achieve a clean front/back connection?

I am running MySQL on CentOS 7, and don't seem to be able to connect MySQL remotely. I have:

bind-address=0.0.0.0

and certainly not #skip-networking but it doesn't matter if I bind to the actual public/local IP addresses.

I have SELinux disabled:

[root@hostname ~]# sestatus
SELinux status:                 disabled

and output for iptables -L -v:

Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         
 103K   21M ACCEPT     all  --  any    any     anywhere             anywhere             ctstate RELATED,ESTABLISHED
   13   880 ACCEPT     all  --  lo     any     anywhere             anywhere            
21423 3952K INPUT_direct  all  --  any    any     anywhere             anywhere            
21423 3952K INPUT_ZONES_SOURCE  all  --  any    any     anywhere             anywhere            
21423 3952K INPUT_ZONES  all  --  any    any     anywhere             anywhere            
  166  7863 DROP       all  --  any    any     anywhere             anywhere             ctstate INVALID
12168 3403K REJECT     all  --  any    any     anywhere             anywhere             reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 ACCEPT     all  --  any    any     anywhere             anywhere             ctstate RELATED,ESTABLISHED
    0     0 ACCEPT     all  --  lo     any     anywhere             anywhere            
    0     0 FORWARD_direct  all  --  any    any     anywhere             anywhere            
    0     0 FORWARD_IN_ZONES_SOURCE  all  --  any    any     anywhere             anywhere            
    0     0 FORWARD_IN_ZONES  all  --  any    any     anywhere             anywhere            
    0     0 FORWARD_OUT_ZONES_SOURCE  all  --  any    any     anywhere             anywhere            
    0     0 FORWARD_OUT_ZONES  all  --  any    any     anywhere             anywhere            
    0     0 DROP       all  --  any    any     anywhere             anywhere             ctstate INVALID
    0     0 REJECT     all  --  any    any     anywhere             anywhere             reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT 43729 packets, 8473K bytes)
 pkts bytes target     prot opt in     out     source               destination         
 152K   30M OUTPUT_direct  all  --  any    any     anywhere             anywhere            

Chain FORWARD_IN_ZONES (1 references)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 FWDI_public  all  --  ens160 any     anywhere             anywhere            [goto] 
    0     0 FWDI_public  all  --  +      any     anywhere             anywhere            [goto] 

Chain FORWARD_IN_ZONES_SOURCE (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FORWARD_OUT_ZONES (1 references)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 FWDO_public  all  --  any    ens160  anywhere             anywhere            [goto] 
    0     0 FWDO_public  all  --  any    +       anywhere             anywhere            [goto] 

Chain FORWARD_OUT_ZONES_SOURCE (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FORWARD_direct (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDI_public (2 references)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 FWDI_public_log  all  --  any    any     anywhere             anywhere            
    0     0 FWDI_public_deny  all  --  any    any     anywhere             anywhere            
    0     0 FWDI_public_allow  all  --  any    any     anywhere             anywhere            
    0     0 ACCEPT     icmp --  any    any     anywhere             anywhere            

Chain FWDI_public_allow (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDI_public_deny (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDI_public_log (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDO_public (2 references)
 pkts bytes target     prot opt in     out     source               destination         
    0     0 FWDO_public_log  all  --  any    any     anywhere             anywhere            
    0     0 FWDO_public_deny  all  --  any    any     anywhere             anywhere            
    0     0 FWDO_public_allow  all  --  any    any     anywhere             anywhere            

Chain FWDO_public_allow (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDO_public_deny (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain FWDO_public_log (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain INPUT_ZONES (1 references)
 pkts bytes target     prot opt in     out     source               destination         
 7423 1336K IN_public  all  --  ens160 any     anywhere             anywhere            [goto] 
    0     0 IN_public  all  --  +      any     anywhere             anywhere            [goto] 

Chain INPUT_ZONES_SOURCE (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain INPUT_direct (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain IN_public (2 references)
 pkts bytes target     prot opt in     out     source               destination         
21423 3952K IN_public_log  all  --  any    any     anywhere             anywhere            
21423 3952K IN_public_deny  all  --  any    any     anywhere             anywhere            
21423 3952K IN_public_allow  all  --  any    any     anywhere             anywhere            
    8   324 ACCEPT     icmp --  any    any     anywhere             anywhere            

Chain IN_public_allow (1 references)
 pkts bytes target     prot opt in     out     source               destination         
 9081  540K ACCEPT     tcp  --  any    any     anywhere             anywhere             tcp dpt:ssh ctstate NEW

Chain IN_public_deny (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain IN_public_log (1 references)
 pkts bytes target     prot opt in     out     source               destination         

Chain OUTPUT_direct (1 references)
 pkts bytes target     prot opt in     out     source               destination

I certainly did:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '********' WITH GRANT OPTION;
FLUSH PRIVILEGES;

But I think that it is a rather connection issue since:

telnet XXX.XXX.XXX.XXX 3306
Trying XXX.XXX.XXX.XXX...
telnet: connect to address XXX.XXX.XXX.XXX: Connection refused
telnet: Unable to connect to remote host

but:

mysql -u root -p
mysql -h localhost -u root -p
mysql -h XXX.XXX.XXX.XXX -u root -p (public IP)
mysql -h XXX.XXX.XXX.XXX -u root -p (local network IP)

all seem to work from the console of the server itself. Any thoughts?

I want to run two Django applications on the same server, with Nginx and Gunicorn. I can run them separately, but not both at the same time: When I try, one is OK, but for the other one I receive 502. Here are my configuration files:

First nginx config for the first project:

upstream app_server {
    server 127.0.0.1:9000 fail_timeout=0;
}

server {
    listen 80;
    # listen [::]:80 default_server ipv6only=on;

    root /usr/share/nginx/html;
    index index.html index.htm;

    client_max_body_size 4G;
    server_name domain1.com;

    keepalive_timeout 5;

    # Your Django project's media files - amend as required
    location /media  {
        alias /home/django/domain1/media;
    }

    # your Django project's static files - amend as required
    location /static {
        alias /home/django/domain1/static;
    }

    location / {
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header Host $http_host;
        proxy_redirect off;
        proxy_pass http://app_server;
    }
}

And for the second django project:

upstream app_server_2 {
    server 127.0.0.1:8000 fail_timeout=0;
}

server {
    listen 80;
    # listen [::]:80 default_server ipv6only=on;

    root /usr/share/nginx/html;
    index index.html index.htm;

    client_max_body_size 4G;
    server_name domain2.com;

    keepalive_timeout 5;

    # Your Django project's media files - amend as required
    location /media  {
        alias /home/django/domain2/media;
    }

    # your Django project's static files - amend as required
    location /static {
        alias /home/django/domain2/static;
    }

    location / {
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header Host $http_host;
        proxy_redirect off;
        proxy_pass http://app_server_2;
    }
}

And Gunicorn upstart script:

description "Gunicorn daemon for Django project"

start on (local-filesystems and net-device-up IFACE=eth0)
stop on runlevel [!12345]

# If the process quits unexpectedly trigger a respawn
respawn

setuid django
setgid django
chdir /home/django

exec gunicorn \
    --name=domain1 \
    --pythonpath=domain1 \
    --bind=127.0.0.1:9000 \
    --config /etc/gunicorn.d/gunicorn.py \
    domain1.wsgi:application

exec gunicorn \
    --name=domain2 \
    --pythonpath=domain2 \
    --bind=127.0.0.1:8000 \
    --config /etc/gunicorn.d/gunicorn.py \
    domain2.wsgi:application

Any suggestions?

Update 24.01.2016

While I am debugging, I have separated Gunicorn upstart scripts into two (one for each project), and renamed them. I have figured out that I am getting 4 of the following error (2 for each, one for starting, one for stopping on Gunicorn daemon restart):

/etc/gunicorn.d/gunicorn.py:2: RuntimeWarning: Parent module '/etc/gunicorn.d/gunicorn' not found while handling absolute import
    from os import environ

Here is my gunicorn.py:

"""gunicorn WSGI server configuration."""
from multiprocessing import cpu_count
from os import environ


def max_workers():
    return cpu_count() * 2 + 1

max_requests = 1000
worker_class = 'gevent'
workers = max_workers()