I have made some changes in openssl.cnf and wants to restart service. Normally I would just restart machine for changes to take effect but I don't want to restart machine. Tried sudo systemctl restart openssl but it didn't work as there is no such service.
How to I restart or reload openssl after making changes in configuration?
How do I setup 410 permanently deleted on nginx for a specific URL for e.g.
https://www.example.com/product/somepage.html
Or better yet how can I do it for a specific prefix for e.g.
https://www.example.com/product/
Here I want to 410 all URLs that are /product/ for e.g. /product/page1.html, /product/page2.html etc.
Here's my current conf setup.
server {
listen 80;
listen [::]:80;
server_name example.com;
return 301 https://www.example.com$request_uri;
}
server {
listen 80;
listen [::]:80;
root /var/www/example.com/html;
index portal.php index.php index.html index.htm;
server_name www.example.com;
location ~* \.(jpg|jpeg|png|gif|ico|css|js)$ {
expires 1M;
add_header Cache-Control public;
add_header Pragma public;
}
location ~ ^/\.user\.ini {
deny all;
}
#some more config here
}
I am trying to install following libraries on Oracle Linux 8 but not working. On Debian 11 after installing php8.1-fpm I run following command and it works.
sudo apt install php8.1-mysql php8.1-gd php8.1-mbstring php8.1-xml php8.1-zip php8.1-curl php8.1-imagick php8.1-soap
On Oracle Linux I have tried following but no luck. PHP FPM version installed is 7.2.24
sudo yum install php-mysql
sudo yum install php7.2-mysql
sudo yum install php7.2.24-mysql
All these commands failed saying Error: Unable to find a match:
How to install these libraries?
I have a Vultr VPS running Debian 10. It's a newly created instance with no firewall. I have installed xfce and xrdp but I am unable to connect to this machine from Windows 10 PC via RDP.
First I installed xfce:
apt install xfce4 xfce4-goodies xorg dbus-x11 x11-xserver-utils
Then I installed xrdp:
apt install xrdp
Checking xrdp status shows:
root@vultr:~# systemctl status xrdp
● xrdp.service - xrdp daemon
Loaded: loaded (/lib/systemd/system/xrdp.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2021-09-07 10:36:13 UTC; 17min ago
Docs: man:xrdp(8)
man:xrdp.ini(5)
Process: 2112 ExecStartPre=/bin/sh /usr/share/xrdp/socksetup (code=exited, status=0/SUCCESS)
Process: 2120 ExecStart=/usr/sbin/xrdp $XRDP_OPTIONS (code=exited, status=0/SUCCESS)
Main PID: 2121 (xrdp)
Tasks: 1 (limit: 1137)
Memory: 1020.0K
CGroup: /system.slice/xrdp.service
└─2121 /usr/sbin/xrdp
Sep 07 10:36:12 vultr.guest systemd[1]: Starting xrdp daemon...
Sep 07 10:36:12 vultr.guest xrdp[2120]: (2120)(140273561200448)[DEBUG] Testing if xrdp can listen on 0.0.0.0 port 3389.
Sep 07 10:36:12 vultr.guest xrdp[2120]: (2120)(140273561200448)[DEBUG] Closed socket 7 (AF_INET6 :: port 3389)
Sep 07 10:36:12 vultr.guest systemd[1]: xrdp.service: Can't open PID file /run/xrdp/xrdp.pid (yet?) after start: No such file or directory
Sep 07 10:36:13 vultr.guest systemd[1]: Started xrdp daemon.
Sep 07 10:36:14 vultr.guest xrdp[2121]: (2121)(140273561200448)[INFO ] starting xrdp with pid 2121
Sep 07 10:36:14 vultr.guest xrdp[2121]: (2121)(140273561200448)[INFO ] listening to port 3389 on 0.0.0.0
And after that when I connect from Windows 10 then I get error:
What am I doing wrong?
I have a WordPress site hosted on nginx. I am using Cloudflare reverse proxy and SSL. I have setup so site will only open in https and even if someone uses http then it will be redirected to https version. In Cloudflare the SSL setting is Flexible
But problem is, it is not working like that and when a user opens http version then it doesn't redirect to https.
This is the setting defined in my config file.
server {
listen xxx.xxx.xxx.xxx:80;
listen [::]:80;
server_name mysiteurl.com;
return 301 https://www.mysiteurl.com$request_uri;
}
server {
listen xxx.xxx.xxx.xxx:80;
listen [::]:80;
root /var/www/mysiteurl.com/html;
index portal.php index.php index.html index.htm;
location ~ \.php$ {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/var/run/php/php7.3-fpm.sock;
fastcgi_param HTTPS on;
}
}
What am I doing wrong?
My website is currently using CloudFlare reverse proxy. In my nameservers I have defined DNS provided by CloudFlare. I am having some issue with CloudFlare so want to test it by removing reverse proxy. If I write my server IP in nameservers, will site sill work?
EDIT
I am getting Error 502 Bad Gateway from CloudFlare when trying to add product in shopping cart. I am using WordPress with WooCommerce. This is happening for all products except the one which I added last time a couple of days ago. I am able to add this product in cart but no other product. Site is hosted on VPS and nothing has been changed on it.
I had a site running on Debian 9 on nginx. Today I did a fresh install of Debain 8 with nginx on same machine but now nginx -t shows following error:
Invalid number of arguments in rewrite directive
Here's my code. Please note I was using the same on Debian 9 without issues and now when I use the same on Debain 8, I get this error. The error is coming from line which says sitemap and if I comment it, then it throws error on next line and so on.
location / {
try_files $uri $uri/ = 404;
rewrite ^/([^&]*)&(.*)$ https://www.example.com/$1?$2 permanent;
rewrite ^/((?i)sitemap-([^./]+)\.xml)$/misc.php?google_seo_sitemap=$2;
rewrite ^/((?i)Forum-([^./]+))$/forumdisplay.php?google_seo_forum=$2;
rewrite^/((?i)Thread-([^./]+))$/showthread.php?google_seo_thread=$2;
rewrite^/((?i)Announcement-([^./]+))$/announcements.php?google_seo_announcement=$2;
rewrite ^/((?i)User-([^./]+))$/member.php?action=profile&google_seo_user=$2;
rewrite ^/((?i)Calendar-([^./]+))$/calendar.php?google_seo_calendar=$2;
rewrite ^/((?i)Event-([^./]+))$/calendar.php?action=event&google_seo_event=$2;
}
I am trying to install MySQL 5.7 on Debian Stretch by following this tutorial:
https://dbahire.com/how-to-install-mysql-server-on-debian-stretch/
As you know Debian Stretch comes with MariaDB instead of MySQL that's why I am doing it. Anyway I am facing issue at following step:
wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql
The error I am getting is:
The certificate of repo.myql.com is not trusted
One option is to use wget --no-check-certificate but this is not good practice.
How do I fix this issue?
I am using nginx to host a website and following is the current configuration which is defined at /etc/nginx/sites-available/mysite
Config
server {
listen 80;
root /var/www/mysite;
index.php index.htm index.html;
}
Problem is as soon as I set another page as default nginx start throwing error
unknown directive "somepage.php" in /etc/nginx/sites-enabled/mysite
New Config
server {
listen 80;
root /var/www/mysite;
somepage.php index.php index.htm index.html;
}
I don't understand what am I doing wrong here. Can you please check?
As you know when you install nginx, it comes with default pool called www and a default site called default.
How can I safely remove these two? Because I have created a new pool and site and I want to release some resources by deleting these.
I have PHP5-FPM installed on Debian with nginx. When I try to open a PHP page then I get Error 502 Bag Gateway. I found out that it is because I am using sockets which looks like is not properly configured. I have tried to fix it by applying different settings but unable to solve this issue. If I change sockets to 127.0.0.1:9000 then it works fine.
Can you please check following configuration and tell me what am I doing wrong?
pool.d/sf.conf
user = sf
group = sf
listen = /var/run/php5-fpm-sf.sock
listen.owner = sf
listen.group = sf
pm = dynamic
pm.max_children = 5
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 3
chdir =/
In above file I am using /var/run/php5-fpm-sf.sock because /var/run/php5-fpm.sock is already being used by pool.d/www.conf
php5-fpm-sf.sock permission
srw-rw-rw- 1 sf sf 0 Aug 10 12:21 /var/run/php5-fpm-sf.sock
sites-available/sf
fastcgi_pass unix:/var/run/php5-fpm-sf.sock
/var/log/nginx/error.log
2017/08/10 12:37:37 [crit] 11666#0: *3 connect() to unix:/var/run/php5-fpm-sf.sock failed (13: Permission denied) while connecting to upstream, client: 162.125.12.13, server: www.sf.com, request: "GET /phptest.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm-sf.sock:", host: "sf.com"
I have a VPS (Debian) on which I am using sendmail. Problem is sendmail takes a lot of time to actually send email. I searched and found many people are facing same issue and everyone suggested to write following line in hosts file which I have done but still same problem.
127.0.0.1 localhost localhost.localdomain myhostname
Even if I use following in hosts, problem remains the same.
127.0.0.1 localhost localhost.localdomain myhostname
25.99.12.45 localhost localhost.localdomain myhostname
By the way that 25.99.12.45 is my VPS IP (this is not real IP just dummy one)
EDIT
Aug 10 09:34:43 localhost sendmail[411]: v7BCXh8B100411: from=root, size=15, class=0, nrcpts=1, msgid=<[email protected]>, relay=root@localhost
Aug 10 09:34:43 localhost sm-mta[412]: v7BCXh8B100412: from=, size=316, class=0, nrcpts=1, msgid=<[email protected]>, proto=ESMTP, daemon=MTA-v4, relay=localhost.localdomain [127.0.0.1]
Aug 10 09:35:47 localhost sm-mta[412]: STARTTLS=client, relay=gmail-smtp-in.l.google.com., version=TLSv1/SSLv3, verify=FAIL, cipher=ECDHE-RSA-AES128-GCM-SHA256, bits=128/128
Aug 10 09:35:47 localhost sm-mta[412]: v7BCXh8B100412: to=, ctladdr= (0/0), delay=00:01:04, xdelay=00:01:04, mailer=esmtp, pri=30316, relay=gmail-smtp-in.l.google.com. [209.xxx.xxx.xxx], dsn=2.0.0, stat=Sent (OK 1502372147 a130si3247433qkg.282 - gsmtp)
Aug 10 09:35:47 localhost sendmail[411]: v7BCXh8B100411: [email protected], ctladdr=root (0/0), delay=00:01:04, xdelay=00:01:04, mailer=relay, pri=30015, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (v7BCXh8B100412 Message accepted for delivery)
In my my.cnf file there is a user defined under section mysqld called mysql as below:
[mysqld]
user = mysql
I read that this is the user under which mysqld service runs. My questions are:
mysql? Or this is something internally saved by the system and I don't need to worry about it?
I have DENIED both incoming and outgoing connections using ufw on Debian VPS. There is only one rule defined, which is to allow connection to SSH port.
ufw is enabled and working.
Yet I am still able to ping from my laptop to server using its IP. Why is ping still working if both incoming and outgoing connections are blocked (except SSH)?
I didn't know how to describe it so I am calling it semi circle. Here's what I am doing.
Server A
Server B = This is slave of Server A
Server C = This is slave of Server B
When I update something on Server A then it is reflected on Server B. But the same change is not reflected on Server C.
Only when I update something on Server B then change is reflected on Server C.
How do I make it so any changes done on Server A will come to Server B (which is already working) and then it goes to Server C?
EDIT
Upon investigation I found out that when I make some change on Server A then its log file position changes. But when those changes are reflected on Server B then Server B log file position doesn't change. It is because of this reason Server C doesn't know if there has been any change on Server B unless I explicitly change something (insert,update,delete) on Server B.
So is there a way to tell MySQL to increment log file position when Slave is receiving updates from Master?
I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file.
master-info-repository=table
relay-log-info-repository=table
These entries are needed because I am defining channels in command "CHANGE MASTER TO" as below:
change master to master_host="127.0.0.1", master_port=20000, master_user="replication",master_password="password1" for channel="master1";
Above command is showing error:
ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. Yo u must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.
SERVER ID is clearly defined in config file.
If I don't define those two properties (shown on top) in config file and start slave without "for channel" the it works fine. Only when I try to define multi source it is showing this error.
Error log file contain following entries:
2017-01-01T12:41:54.446764Z 0 [ERROR] Error in checking mysql.slave_master_info repository info type of TABLE.
2017-01-01T12:41:54.446764Z 0 [ERROR] Error creating master info: Error checking repositories. 2017-01-01T12:41:54.446764Z 0 [ERROR] Failed to create or recover replication info repository.
2017-01-01T12:41:54.446764Z 0 [ERROR] Failed to create or recover replication info repositories.
How do I fix this issue?
EDIT
One thing I came to know that this is related to 5 tables innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info. Even if I delete those tables and then create again then it still shows same error. By the way I am using multiple instance on a single machine.
I just installed MySQL 5.7 on Windows 2012 VM. I am trying to create and run multiple instances but very frustrated that such a simple thing is not working.
I installed MySQL in C:\Program Files\MySQL\MySQL Server 5.7 which is default location and then I copied the folder and made another copy of it to create another instance (I suppose this is how it works?)
Both MySQL instances are shown in image below.
Server1
Server2
INI settings for both servers are given below:
Server1
server-id=1
log-bin="mysql-bin"
binlog-ignore-db=test
binlog-ignore-db=information_schema
replicate-ignore-db=test
replicate-ignore-db=information_schema
relay-log="mysql-relay-log"
auto-increment-increment = 2
auto-increment-offset = 1
Server2
server-id=2
log-bin="mysql-bin"
binlog-ignore-db=test
binlog-ignore-db=information_schema
replicate-ignore-db=test
replicate-ignore-db=information_schema
relay-log="mysql-relay-log"
auto-increment-increment = 2
auto-increment-offset = 2
I am running both servers by opening command prompt and typing following:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
"C:\Program Files\MySQL\MySQL Server 5.7 - 2\bin\mysqld"
The command seems to run successfully as no error is shown but when I look at task manager to see if any mysql processes are running, I see none.
What am I doing wrong?
I saw this point on Technet article about RBS.
The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface (iSCSI) device. You cannot use the local RBS FILESTREAM provider on remote storage devices such as network attached storage (NAS).
Does it mean we cannot use FILESTREAM in case of SQL Failover Cluster because Failover Cluster only works on NAS? But the thing is NAS is made available locally when setting Failover Cluster so may be FILESTREAM will work but I am not sure about it.
I want to make a 2 node SQL Server 2012 cluster. Both nodes are virtual machines running Windows Server 2012 on Hyper-V.
I have a physical SAN available which I can use for clustered storage so I was hoping if someone could help about how to make clustered storage available to both nodes. Both nodes are using HBA fiber channels.
How to make it work with iSCSI
How to make it work without iSCSI
I want to be able to make several drives such as S, F, K e.t.c.
Thanks
If I have a PHP site hosted on Apache and someone hacks it using SQL injection, is there a way I can find out exactly which script caused this by looking at my web server logs?
Or using some other way?