All Questions
130
questions
0
votes
1
answer
62
views
Changes done in mysql backend database not getting reflected neither on frontend website nor inside the server [closed]
https://stackoverflow.com/questions/45920596/update-made-in-mysql-database-does-not-reflect-on-the-webpage
I've curled inside the server itself and still the updated data was not received.
I've:
...
- 122
0
votes
0
answers
190
views
MariaDB not starting after a server restart
I'm running a LEMP stack for my websites and they were running fine. Monitoring showed that the server wasn't responding to the pings, I restarted it. Now MariaDB service isn't running, my websites ...
- 1
0
votes
1
answer
406
views
Frequent server downtime and suspicious server hits to access random Pdf files
Our Server hosting PHP web application is facing frequent downtime
Server Information [Nginx, FreeBSD] Web application [PHP 5.6, MYsql 5.7]
I have gone through the Nginx logs and below are my findings
...
- 101
1
vote
1
answer
387
views
PHP-FPM static max_children amount doesn't seem to matter much during stress tests
I've been stress testing PHP-FPM set up as static using wrk, with NGINX running on Ubuntu Server 22.04 for the past few days, writing down results for every scenario. When I look at them, it seems to ...
1
vote
0
answers
199
views
Nginx - Server dead when received many requests
we have a large Woocommerce website hosted on Google VM servers (E2 4vCPU + 32 GB RAM + 100 GB SSD Storage), recently we created a mobile application using flutter and WordPress -Woocommerce- API, but ...
google-compute-engine
1
vote
0
answers
158
views
How do I install latest iRedMail with existing Nginx
How to keep the current Nginx websites running intact when installing iRedMail?
- 1,491
12
votes
5
answers
4k
views
Is it a good idea to open up a database port for everyone?
Okay, so I'm completely new to the server stuff, but I have a VPS running with MySql.
I want to create a mobile app with Python, but I need access to a database that's available for everyone.
So now I ...
- 229
-1
votes
1
answer
95
views
Unable to get subdomain to connect to MariaDB
So far I can reach the DB from the main domain lets say example.com but connection from the subdomain lets say portal.example.com, don't work. I am currently running Nginx & Varnish & Apache ...
- 1
1
vote
1
answer
494
views
How to host an app for multiple customers?
I built a web app with NextJS that I sell b2b, where users (my clients customers) can check in to a location. They provide their name and get a check in number. The app shows client related ...
- 163
1
vote
0
answers
456
views
Can't access phpmyadmin and local localhost:8000 with two errors for each of them
Recently reinstalled Ubuntu 21.04 on my computer and installed php8 and Nginx.
I run the server for Laravel and when I go to localhost:8000 I got this error:
Illuminate\Database\QueryException
could ...
- 111
1
vote
0
answers
81
views
MySQL / Web Server Bottleneck
I’m trying to determine a MySQL / Web server bottleneck.
I have three servers. A Web server running Nginx, a remote MySQL server with my Wordpress DB and another remote MySQL server storing our data.
...
- 11
-1
votes
1
answer
264
views
Adjust server configuration [PHP, Laravel, mysql, nginx] for serve great number of user [duplicate]
I have a Laravel PHP webapp that shows analytics data in Angular frontend to users.
User can only show content, plots and tables.
I have written 3 laravel commands that hourly download and store data ...
- 101
0
votes
0
answers
320
views
Cannot make mysql database connection from php
I am not being able to make database connection from php. I'm getting HTTP 500 Internal Server Error while making database connection.
My PHP code:
<?php
$servername = "localhost";
$...
0
votes
1
answer
260
views
How to debug an unreachable (from the wan side) lemp server tunneling through an AWS based Openvpn-AS instance
Ive been wracking my brains out for weeks trying to debug a once perfectly functioning LEMP web server.
I'm using a relatively complicated setup. Lets start with my setup from the beginning when ...
- 93
1
vote
0
answers
683
views
Mysql in Nginx takes over 100% CPU
I have a Laravel application running on my Ubuntu 18.04 server and MySql 5.7.
Sometimes, it is very slow.
I have checked with "top" command and this is the result:
Some times %cpu raises ...
- 111
0
votes
2
answers
2k
views
Extremely High TTFB on Wordpress website - Not dabase or server ... what else could cause it?
I'm running a Wordpress ecommerce website on a dedicated VPS with 4CPUs and 6gb RAM, so resources are not an issue . On top of this I have VestaCP installed, with a Nginx + Apache + Php-FPM server . ...
1
vote
0
answers
421
views
wordpress + nginx + mysql: issue in getting wordpress up and running (error cannot establish database connection)
I deployed a django app with nginx and gunicorn and yesterday I tried modified my setup to include a wordpress page as the landpage.
I followed this tuto for the basic installations https://www....
- 141
0
votes
0
answers
272
views
Reocurring error! the server quit without updating pid file
Dedciated Server Linux Cenos 6 Apache + Nginx
We have had this issue happen several times now and happening after server has crashed or shut down
the server quit without updating pid file
After this ...
- 11
0
votes
0
answers
575
views
Getting 499 status from nginx log upto 2 minutes in every 3 hours interval, when memcache restarts
I have two Application servers served by an another haproxy load balancer server. The application servers are connected with a memcache server and a mysql database server.
I am observing in every 3 ...
1
vote
0
answers
46
views
Accessing HA Clusters using multiple floating IPS
I have set up two highly available clusters which are used to load balance traffic to NGINX and MySQL respectively. The clusters use NGINX and ProxySQL as the load balancing software, to make them ...
- 23
0
votes
0
answers
155
views
How to set Firewalld rules on first time and don't harm your self?
I'm running the server on CentOS and Nginx (nodejs application).
I am experiencing too many connections to my mysql database and website goes down.
My iotop log shows me that mysqld is taking to much ...
- 101
0
votes
0
answers
191
views
"fastcgi_read_timeout" doesn't stop mysql queries
I have a problem with long mysql queries. My NGINX server has a line in fastcgi section to limit script execution:
server {
location ~ \.php$ {
<..>
fastcgi_read_timeout 60; ...
- 217
0
votes
0
answers
114
views
Wordpress website hosted on nginx ubuntu isn't loading anymore
I just found out the Wordpress website isn't running anymore. When opening example.in, it simply shows the text Error establishing a database connection. The wp website is the folder /var/www/...
- 113
0
votes
1
answer
255
views
install_fastcgi.sh is missing on ubuntu 18.04
I am trying to configure hhvm, nginx and mysql in my ubuntu 18.04 system following the following tutorials
Tutorial: How to install Facebook’s HHVM on Ubuntu 18.04
How To Install HHVM with Nginx on ...
1
vote
0
answers
907
views
Server crash (Error 500) repeatedly (running nginx + gunicorn on EC2 instance)
Okay, so I'm really confused about what's happening here. I've had my server up and running for about a month and everything was fine. The server was getting very little traffic (about 50-100 requests ...
- 11
0
votes
1
answer
1k
views
Nginx not responding from outside the remote box
My website (Django/nginx/gunicorn/mysql) which is hosted on a remote box was working fine, until I decided to restart remote box for some reason. So after the restart, in the remote box when I say ...
- 11
0
votes
0
answers
64
views
How to use Mysql Workbench to figure out why scripts are so slow?
I have a laragon environment on a fairly decent machine:
I have a simple hard coded web application (no frameworks), with a Bootstrap4+jQuery front-end.
On page load, it does a few very simple and ...
- 121
0
votes
0
answers
180
views
Mysql 5.7 keeps shutting itself off randomly in a day or two?
I have a DigitalOcean Ubuntu 16.4 machine with Nginx installed. Maybe it's related to Wordpress installation, maybe not. MySQL shuts itself down randomly.
It has a 1GB swap file created. 1GB RAM. ...
- 101
1
vote
1
answer
248
views
mariadb 5.5 innodb keeps opening files up to 200k until system hangs completely
Mariadb 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as measured per database files on a disk) and 506 tables. This database is being queried by php-fpm, and ...
- 111
0
votes
0
answers
94
views
PHP application with remote MySQL and nginx load balancers ends up with a huge page load execution time
I was reading and trying to set up a proper load balancer with PHP application using nginx.
Now from the documentation I understand that I need to run on every server instance PHP and nginx, then use ...
- 1
1
vote
1
answer
241
views
Was this a hacking attempt? (Docker container -> MariaDB)
since i am completely new to web hosting and setting up web servers, please excuse my dumb questions ;)
Yesterday i uploaded my web application on digitalocean. The application is a very simple ...
- 13
0
votes
1
answer
5k
views
Yet another PDO could not find driver issue
I've been working for the last two nights to set up my own LEMP server on Amazon ec2. I'm not a server expert so it's been slow going, and the latest error "could not find driver" is given when ...
- 213
0
votes
0
answers
177
views
MariaDB opens lots of files causing PHP-FPM to fail
There is a problem I'm dealing with that under a known traffic (e.g. reaching 300 concurrent users) server doesn't handle more incoming requests due to open files. This is the current limit:
$ cat /...
- 121
0
votes
0
answers
876
views
Very high load on nginx server and crashes occasionally
I have a active site built in Codeigniter on ngnix server with medium traffic. Occasionally the server cpu usage becomes very high and site crashes. After running top it looks like mysql is causing ...
-1
votes
2
answers
1k
views
Having Trouble Setting Subdomains On NGINX
I'm currently setting up OpenMediaVault on my Rock64 Single Board PC which is based off Debian and is configured through the web GUI running from NGINX on port 80.
I'm currently trying to install ...
- 81
0
votes
2
answers
464
views
Slow Queries WordPress Site (500k visitors a month and 150k posts)
I'm running a WordPress site with 500k visitors a month and 150k posts with in average 100 pageviews every second. I am trying to figure out if the load on the server is normal or if there is ...
- 1
2
votes
3
answers
5k
views
MySQL Error: Can't create thread to handle new connection(errno= 11) triggered by many Gunicorn API requests
I'm running Ubuntu 16.04.4 LTS on a hosted Virtual Server with a MySQL DB 5.7.23 and a Gunicorn web server, which is providing the web application with an API.
Everything is running properly, however ...
- 21
2
votes
1
answer
936
views
Mariadb 1000% CPU [closed]
I have a big problem with my site (Laravel based), I have from 1000 to 1500 contemporary visitors, and I have a problem with mariadb, practically when people use filters, and other options that ...
- 21
0
votes
1
answer
300
views
Configure Apache 503 sensitivity
I Currently have a service with a very high traffic (about 1000 connections/second, and this is not reducable with optimization anymore). Until 1 week ago, I was at AWS and had twiched some of my ...
1
vote
1
answer
9k
views
404 Not Found with nginx and php
I got inside the browser:
404 Not Found
nginx/1.13.10
and in the logs I got:
$ ls logs/
nginx-access.log nginx-error.log
$ cat logs/*
172.17.0.1 - - [27/Mar/2018:02:11:35 +0000] "GET / HTTP/1.1" ...
- 225
-1
votes
1
answer
2k
views
Configure nginx for mysql remote access
I have a VPS and I'm trying to have remote access to my mysql databases.
I granted root privileges to any IP address
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT ...
1
vote
1
answer
240
views
Duplicated version of a local (WordPress) site isn't available online in an Nginx environment
In my Ubuntu 16.04 Nginx environment I tried to create an online test version of a local WordPress site. The original site works fine and is accessed in HTTPS (the lock favicon is green in all pages).
...
1
vote
1
answer
813
views
Nginx + PHP FPM + MYSQL servers going down when too much traffic
We currently have some servers hosting a e-commerce platform in Digital Ocean, we tried to optimize how much we could, but was not enough, site is going down when too much traffic, like 800~1000 users....
0
votes
1
answer
2k
views
MySQL server with Nginx
I'm currently running nginx on my server to serve a static website at example.com. I'm using a proxy pass to a node server to serve my api at example.com/api/.
I want to install and run MySQL on ...
- 103
0
votes
1
answer
123
views
Wordpress site still works when I shut down MySQL
I entered 'service mysqld stop' via SSH and noticed my site was still running. Better yet, it was running faster than ever.
"Shutting down MySQL....... SUCCESS!"
Anyone know why this is possible?
- 3
0
votes
1
answer
591
views
Using NGINX to serve images from multiple storage servers
I'm working on a project similar to Imgur but for clients only. I'm using NGINX as my webserver and PHP-FPM/MYSQL to handle the rest. One speed bump I will eventually run into is running out of server ...
- 1
2
votes
1
answer
1k
views
Very high SQL CPU on wordpress because of 404 request
I'm running a Wordpress site with Nginx, MariaDB, PHP-FPM and getting bombarded by a lot of different 404 request from a lot of IP (~10.000 different IP per hour requesting random URL which results in ...
- 513
0
votes
1
answer
663
views
I am trying to install icehrm on the host . I am getting "Primary script unknown" in nginx error.log
I am trying to install and configure ICEhrm . However I was successfully able to unzip the file.
Here is my app/config.php file
<?php
ini_set('error_log', 'data/icehrm.log');
define('...
1
vote
1
answer
2k
views
PDOException (1045) SQLSTATE[HY000] [1045] Laravel 4.2 MySQL 5.7
thanks for reading my question, I had been working on this error since a week reading questions in ServerFault, Stackoverflow and AskUbuntu but couldn't figure out the problem.
I have
Lubuntu 16.04 (...
- 115
-1
votes
1
answer
2k
views
MYSQL Log Files Eating Disk Space
I have a server that has recently had some issues and after rebooting it last night, we are back at it again today.
I noticed today however that the disk is completely full. So I used the du command ...
- 119