skrewler's questions

I've got a MySQL DB running in EC2 that I've had to continually add space to the EBS volume, then grow it (using growpart/xfs_growfs). I finally hit 2TB and couldn't figure out why I could no longer grow the partition, its because of course it's an MBR partition table.

The thing is, these DBs are in a cluster w/ (what I thought was) the exact same configurations. On the others, I was able to convert to GPT without any errors. It's just this one that I'm having trouble with.

Thanks in advance

Here are the outputs of gdisk, parted, fdisk.

I'm a bit confused why the xvdn1 shows as GPT but not xvdn .. I might have screwed up somewhere in the past?

What is the best way forward? The error message says to delete/resize in another utility, I've tried that and everytime I either end up with the same error or I'm unable to mount it. It's possible I'm not using the correct values to recreate the partition 33 blocks smaller?

Here is the command, and the error message. Everything else below that is just outputs of fdisk/parted/sfdisk showing the disk. Ever

gdisk /dev/xvdn
GPT fdisk (gdisk) version 0.8.8

Partition table scan:
  MBR: MBR only
  BSD: not present
  APM: not present
  GPT: not present


***************************************************************
Found invalid GPT and valid MBR; converting MBR to GPT format
in memory. THIS OPERATION IS POTENTIALLY DESTRUCTIVE! Exit by
typing 'q' if you don't want to convert your MBR partitions
to GPT format!
***************************************************************

Warning! Main partition table overlaps the first partition by 33 blocks!
You will need to delete this partition or resize it in another utility.

Disk / Partition Table Let me know if there's any other debug info that would be helpful

parted /dev/xvdn unit s print
Model: Xen Virtual Block Device (xvd)
Disk /dev/xvdn: 5033164800s
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start  End          Size         Type     File system  Flags
 1      1s     4194298394s  4194298394s  primary  xfs

parted /dev/xvdn1 unit s print
Model: Unknown (unknown)
Disk /dev/xvdn1: 4194298394s
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start  End  Size  File system  Name  Flags

fdisk -l -u /dev/xvdn

Disk /dev/xvdn: 2577.0 GB, 2576980377600 bytes
255 heads, 63 sectors/track, 313300 cylinders, total 5033164800 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000b6274

    Device Boot      Start         End      Blocks   Id  System
/dev/xvdn1               1  4194298394  2097149197   83  Linux

lsblk /dev/xvdn
NAME    MAJ:MIN RM   SIZE RO TYPE MOUNTPOINT
xvdn    202:208  0   2.4T  0 disk
└─xvdn1 202:209  0     2T  0 part

Made backups ...

dd if=/dev/xvdn of=/root/mbrbackups/xvdnbackup.mbr bs=512 count=1

sfdisk -d /dev/xvdn > sfdiskbackup.txt
cat sfdiskbackup.txt
# partition table of /dev/xvdn
unit: sectors

/dev/xvdn1 : start=        1, size=4194298394, Id=83
/dev/xvdn2 : start=        0, size=        0, Id= 0
/dev/xvdn3 : start=        0, size=        0, Id= 0
/dev/xvdn4 : start=        0, size=        0, Id= 0

Note: I see similar questions/answers but they seem a bit different than mine. In my case, I only have 1 partition on a disk. I've also gone thru this procedure on (what I thought) was the exact same configuration, and was able to do the procedure online.

(crossposted to ubuntu forums -- will update here and vice/versa if

Versions

root@ip-10-0-2-189:~# sfdisk --version
sfdisk from util-linux 2.20.1
root@ip-10-0-2-189:~# sgdisk --version
GPT fdisk (sgdisk) version 0.8.8

These are the same versions that I did conversion on another instance.

and yes, my data is backed up, and this is actually a copy of the db i'm trying this on. this isn't the live -production DB.

Nginx allows custom log formats for access logs -- right now I'm logging http_x_forwarded_for and it's working fine.

The problem is my error log only shows the LB IP. After Googling and reading through their documentation, it seems error_log doesn't support a custom format, only setting the log level (info, alert, notice, warning, etc).

Is there any kind of workaround or module I could use to get around this?

For completeness, my setup is:

Amazon ELB -> pool of instances running nginx as a reverse proxy to php-fpm 7.0

I'm migrating from mod_php to nginx. I got everything working except for this rewrite.. I'm just not familiar enough with nginx configuration to know the correct way to do this.

I came up with this by looking at a sample on the nginx site.

server {
    server_name test01.www.myhost.com;
    root /home/vhosts/my_home/blah;

    access_log /var/log/nginx/blah.access.log;
    error_log /var/log/nginx/blah.error.log;

    index index.php;

    location / {
            try_files $uri $uri/ @rewrites;
    }

    location @rewrites {
            rewrite ^ /index.php last;
            rewrite ^/ht/userGreeting.php /js/iFrame/index.php last;
            rewrite ^/ht/(.*)$ /$1 last;
            rewrite ^/userGreeting.php$ /js/iFrame/index.php last;
            rewrite ^/a$ /adminLogin.php last;
            rewrite ^/boom\/(.*)$ /boom/index.php?q=$1 last;
            rewrite ^favicon.ico$ favico_ry.ico last;

    }

    # This block will catch static file requests, such as images, css, js
    # The ?: prefix is a 'non-capturing' mark, meaning we do not require
    # the pattern to be captured into $1 which should help improve performance
    location ~* \.(?:ico|css|js|gif|jpe?g|png)$ {
            # Some basic cache-control for static files to be sent to the browser
            expires max;
            add_header Pragma public;
            add_header Cache-Control "public, must-revalidate, proxy-revalidate";
    }
    include php.conf;
    }

The issue I'm having is with this rewrite:

rewrite ^ht\/(.*)$ /$1 last;

99% of requests that will hit this rewrite are static files. So I think maybe it's getting sent to the static files section and that's where things are being messed up?

I tried adding this but it didn't work:

    location ~* ^ht\/.*\.(?:ico|css|js|gif|jpe?g|png)$ {
            # Some basic cache-control for static files to be sent to the browser
            expires max;
            add_header Pragma public;
            add_header Cache-Control "public, must-revalidate, proxy-revalidate";
    }

Any help would be appreciated. I know the best thing to do would be to just change the references of /ht/whatever.jpg to /whatever.jpg in the code.. but that's not an option for now.

What I need:

• Anonymous user should be able to submit a new issue via email and Redmine should do it's best to parse the email and add a new issue.
• You should be able to reply to email notifications redmine sends out. Redmine should be able to handle this. At the minimum a user should be able to reply to one of these notifications and their reply will be added as a comment. More functionality would be welcome. As would the ability (w/ documentations and code examples) to hack up some ruby to create a custom parser/handler to do some other action would be awesome as well.
• If this could work with our existing Google Apps (paid/business edition) setup that would be even better

I've spent some time googling for this and even asking in #redmine on freenode with no luck. All I found was this /srv/redmine/extra/mail_handler/mail-handler.rb but no documentation anywhere and the comments aren't all that helpful.