David's questions

I've recently reduced a site from a huge wordpress blog to a single page (homepage) and one other page.

I'd like to 301 redirect all pages which aren't the homepage or /confirmed to the homepage. I've tried a few things, but they all end in a redirect loop. Here is what I have in my conf.

Thanks for the help!

location / {
   try_files $uri $uri/ $uri/index.php?$args;
}

location /confirmed {
   try_files $uri $uri/ /confirm-user.php?$args;
}

With this config, all other urls are going to the homepage, but it's not a 301.

Firstly, i've recently taken on the management of a proxmox cluster which I have had no experience managing previously (i'm completely new to cluster management, but not too bad at linux).

pve-manager/5.1-46/ae8241d4 (running kernel: 4.13.13-6-pve)

I have 2 xen nodes which run a number of containers and VMs within them. Yesterday, a container on Xen2, which runs a mysql database, stopped responding. I was able to log in to the container via ssh and attempted to restart mysql only to receive an error along the lines that it was unable to connect to the mysql.sock. So I decided to simply shutdown the container and start it back up. I chose 'shutdown' in proxmox UI for the container, which it then shutdown. Then I clicked 'start', in which proxmox logs recorded:

CT 110 - Start          ERROR: command 'systemctl start pve-container@110' failed: exit code 1

So, I've tried running the 'system start ...' via ssh. It takes a while, and then I get the following:

Job for [email protected] failed because a timeout was exceeded.
See "systemctl status [email protected]" and "journalctl -xe" for details.

Here is the output of 'systemctl status ...':

● [email protected] - PVE LXC Container: 110
   Loaded: loaded (/lib/systemd/system/[email protected]; static; vendor preset: enabled)
   Active: failed (Result: timeout) since Thu 2018-06-07 08:35:22 BST; 43s ago
     Docs: man:lxc-start
           man:lxc
           man:pct
  Process: 1603366 ExecStart=/usr/bin/lxc-start -n 110 (code=killed, signal=TERM)
    Tasks: 1 (limit: 4915)
   CGroup: /system.slice/system-pve\x2dcontainer.slice/[email protected]
           └─1532500 [lxc monitor] /var/lib/lxc 110

Jun 07 08:33:52 xen2 systemd[1]: Starting PVE LXC Container: 110...
Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Start operation timed out. Terminating.
Jun 07 08:35:22 xen2 systemd[1]: Failed to start PVE LXC Container: 110.
Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Unit entered failed state.
Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Failed with result 'timeout'.

and 'journalctl -xe':

Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Start operation timed out. Terminating.
Jun 07 08:35:22 xen2 systemd[1]: Failed to start PVE LXC Container: 110.
-- Subject: Unit [email protected] has failed
-- Defined-By: systemd
--
-- Unit [email protected] has failed.
--
-- The result is failed.
Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Unit entered failed state.
Jun 07 08:35:22 xen2 systemd[1]: [email protected]: Failed with result 'timeout'.

Shortly after attempting to restart the container the first time, the entire xen2 node started displaying grey questions marks along side all it's VM/containers and they lost their labels (see screenshot):

Despite this, all the other VMs/Containers within xen2 are still functioning fine. So, I've then decided to run the following commands to see what would happen:

service pvedaemon restart (nothing changed) service pveproxy restart (nothing changed) service pvestatd restart (The VMs started showing names within proxmox UI (but not containers), but this only lasted 10-15 minutes)

I'm hesitant to upgrade or restart the entire xen node due to the unknown side of configuration and what potential pitfalls may lie ahead and that its business critical to have at least something running. Furthermore, i've ran through /var/log/syslog and didn't see anything that indicated why the container crashed.

Ideally, I want to achieve: Determine why the database container crashed (110) Successfully start up the database container again Determine why the xen2 node isn't reporting data to the UI about it's VM/Containers Fix the reporting data in the UI for the node Again, please appreciate i'm new to proxmox, but I do know my away around linux.

Thank you for any tips/knowledge on troubleshooting this problem. If there is any other info you'd like me to share, please let me know.

Cheers, David

I've been trying to find a free way to monitor mysql status variables and push a slack notification when certain variables hit a threshold (ie: large number of connections).

At the moment, all the out-of-the-box solutions require massive monitoring tools setting up and some have a cost involved.

Surely its relatively easy just to write a script, but I'm unsure where would be the best place to start this. I'd imagine it would be a cron which would run every 5sec which would get the status variables, if they hit the threshold, call the webhook.

Can anyone make suggestions on the best approach to do this?

Our current setup has the following environments:

• development
• testing
• staging
• production

We are finding that things are being held back at the testing phase due to UAT taking longer than expected due to time available of the user.

I was thinking that creating multiple test environments to deploy to might be the answer, but I wanted to see if there was a more standard approach to handling multiple user acceptance test at once withing a testing environment.

Cheers, David

I have the following directory structure:

mysite.com
- /api (codeigniter RESTful API Server)
- /app (backbonejs app)

I'm trying to configure NGINX to point all requests for mysite.com/api* to the api directory and use Codeigniter's setup.

Everything i've found works fine, if CI is in the root directory. But, the moment you try to put it in a sub-directory, it fails.

This is what I currently have:

server {
        listen 80;
        server_name local.mysite.com;
        root /Users/me/Sites/mysite;
        autoindex on;
        index index.html index.php;

        location /api {
            try_files $uri $uri/ /api/index.php;

            location ~ \.php$ {
                root /Users/me/Sites/mysite/api;
                fastcgi_pass 127.0.0.1:9000;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                include fastcgi_params;
            }


        }



    }

Doing this just gives me a 'File not found' error. Not even a proper nginx 404. How do I configure NGINX for CodeIgniter in a subdir of a server?

Thanks!

I have a url path defined in rewrite rules ('/admin') which I would like to restrict access to only 1 ip address. I'd image the best way would to use .htaccess rather than coding it in. I've tried this but it didn't work. It blocked all urls, not just urls with /admin.

<Location /admin>
    Deny from all
    Allow from x.x.x.x
</Location>

Ever since iOS8, the sites I managed are experiencing an intermittent problem in which images are swapping locations with other images. This has been mentioned in a number of places, but with no apparent solution:

https://discussions.apple.com/thread/6574663

http://tech.vg.no/2011/12/14/safari-on-ios-5-randomly-switches-images/

http://tech.vg.no/2012/02/01/safari-on-ios-5-randomly-switches-images-part-3/

it appers it was a problem in iOS5 in the past. Our server is running Lightspeed with pipe-lining and keep-alive. My server admin has confirmed that pipe-lining is returning assets in the order they were requested. He's mentioned disabling keep-alive may resolve the issue, but would massively increase server load, which would be a really bad thing.

All my assets are passing content-length correctly too.

I'm really at a dead-end now for a solution to this. With so many of my users using iOS, its beginning to be extremely frustration for everyone.

It only started occurring with the introduction of iOS8 which has some pretty heavy changes to Safari. In every release, of 8, the problem is still there. As I said, it's intermittent and our users are starting to blame us as 'no other site has the problem'.

I was wonder if anyone could shed some light on this? Has anyone else experienced this problem and/or found a solution?

Here is a link to my site in question.

I have a local development server (centos) which I develop a number of websites on. Occasionally I need to test email sending scripts.

I want to avoid the development server from sending emails to anyone who doesn't have an email address with a particular domain (ie: [email protected], [email protected], etc). So, I would like to create a white list or rule on the server which prevents emails being sent to any email address that doesn't match mydomain.com.

I'm currently using PHP's built-in mail() function. But I imagine this is something more on the server level and I would like something that will manage ANY emails sent out from the server from any program/app/script/etc.

I can confirm that PHP is using /usr/sbin/sendmail.sendmail

I'm running centos and have a rediculous amount of emails in the mailqueue due to a script error. Is there any way to remove messages that have a certain subject line in sendmail's mailqueue.

At a certain time we run a few backup scripts to backup:

• code/files
• databases
• other important files on the server

During this time the websites on the server grind to a hault giving timeouts and database connection issues.

So, i imagine im doing this wrong. What is the bets way to perform nightly backups without affecting the performance of sites on the server?

OS: Centos applications: MySQL, Rsync

Backups are to a remote server.

I have a 15GB sql file which is a backup of a database. The problem I have is that half way through it, it failed. Luckily, I know which table to pick up from.

Is there a way I can split this SQL file by the starting point of the table I need to pick up from or perhaps get mysql to do this itself?

Thanks

I am getting the following error on the odd occasion on our web server:

Warning: session_start(): open(/tmp/sess_7ifl201pvdd91rr6tr4015n5k4, O_RDWR) failed: No space left on device (28) in /home/some/script/on/my/site/script.php on line ##

My server admin tells me that it must be something on the site that is causing this such as someone uploading a large file via PHP. But i'm a bit sceptical as it's only started happening the past couple of days.

So, I was wondering if anyone else knew of reasons why this might occur? I am running lightspeed (not apache), centos. Let me know if there is any more information required.

I have a centos 5 linux box which is currently running off an IDE drive. I want to install a couple of SATA drives as backup drives for now. I have googled that there can be complications with SATA and might need to re-install centos.

Is there a way to 'enable' SATA support in Centos 5 without needing to re-install it?

Is there a way to check to see if this support is already available in the current install?

The drives are on there way, so I can't just plug'n'play.

I have a server which has 4 drives which are each mounted to different areas. I have 2 drives which are giving me trouble and would like to run fsck on them. Can I unmount those drives, run fsck on the partitions without stopping access to the other 2 drives from other users?

I am trying to remove an rdiff backup folder as some problems occured during the backup and need to remove it's history and try again. However, when I run:

rm -r -f rdiff-backup-data 

I get the following on some of the files:

rm: cannot remove `X': Read-only file system

Here is what I get when I run mount:

/dev/sdb1 on /media/usbdisk type ext3 (rw)

So that shows the drive is rw?

ls -la /media/usbdisk gives the following:

[root@localhost v5]# ls -la /media/usbdisk
total 36
drwxr-xr-x  5 root root  4096 Mar 31  2010 .
drwxrwxrwx  9 root root  4096 Dec 15  2009 ..
drwxrwxrwx 39  501  501  4096 Aug 19 09:04 development-backup
drwx------  2 root root 16384 Mar 30  2010 lost+found
drwxr-xr-x  8 root  501  4096 Aug 19 00:00 officeshare-backup

Anyone know what is going on and how to fix it?

UPDATE

found out the drive was ro in /proc/mounts so ran the remount command mentioned below and got the following:

ext3_abort called.
EXT3-fs error (device sda1): ext3_remount: Abort forced by user
mount: block device LABEL=USBDISK1 is write-protected, mounting read-only
ext3_abort called.
EXT3-fs error (device sda1): ext3_remount: Abort forced by user

I had a drive fail of sorts. Now when I try to umount it is says the device is busy despite the device not being in /dev/

Any ideas how I can umount it.

I have the following rsync command:

0 0  * * *  rsync -av --delete /media/VIDEOS/ /media/lacie1/backup/videos/

I want to set it so instead of doing a replication like what it's doing now, it does a normal backup and only deletes file from the destination only after they haven't been found on the source for X days (like 7 days). This is to give a larger window of recovery if files go missing, but without keeping loads of duplicate files as the files being backed up get moved around a lot.

I have an rsync command which does replication of sorts:

0 0  * * *  rsync -av --delete /media/VIDEOS/ /media/lacie1/backup/videos/

Is there a way to stop the rsync command from running if the source is not accessible (ie: not online/mounted)?

I have a mailq which is getting backed up with multiple emails with the same subject line. I would like to delete all emails in the mailq that match a particular subject line so they don't get sent. Any ideas how to do this? Pretty urgent as its spam related.

I have added 2 virtual hosts to my apache2 conf file as below:

<VirtualHost *:80>
    DocumentRoot /var/www/html/site1
    ServerName www.site1.com
    ServerAlias site1.com
</VirtualHost>


<VirtualHost *:80>
    DocumentRoot /var/www/html/site2
    ServerName www.site2.com
    ServerAlias site2.com
</VirtualHost>

I then got the error after restarting apache i get:

[warn] default VirtualHost overlap on port 80, the first has precedence

Searched google and they said to uncomment the line below, so I did:

NameVirtualHost *:80

Restart, and now I don't get the error, but both sites go to the first site.

running Centos5. How do I fix this problem?