jishi's questions

I've been searching for answers for a while know but can't find any reliable source.

We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a different tablespace (residing on a different volume), which would be a no-brainer but I have no idea how this will propagate to the slave.

I need to do the same change on the slave, because it has an identical disk setup, but I'm not sure if I need to create the tablespace on the slave, beforehand (and if handled directly by the replication) or if I need to run the same alter statement on the slave (but it is readonly, and I don't know if that is allowed).

OR, do I need to make a new base backup and set up the replication from scratch after this change?

Today I do the following to sync two webservers but skip all site configuration:

msdeploy -verb:sync -source:webServer -dest:webServer,computerName=web25:8080
    -skip:objectName=section,absolutePath=system.applicationHost/sites 
    -skip:objectName=section,absolutePath=system.applicationHost/applicationPools

However, this effectively also skip the siteDefaults, which I do like to sync (system.applicationHost/sites/siteDefaults)

There doesn't seem to be a way to "include" a section, to override the skip directive. And there doesn't seem to be a way to sync only the siteDefaults section from applicationHost either, since source appHostConfig only seem to sync a specified site, and not siteDefaults.

Maybe it is possible to "skip" using an Xpath expression or similar, to only skip the nodes, but include , but I find the documentation a bit confusing and my Xpath is rusty.

I have setup pm2 to run a node.js application, and I can successfully start it and it will resurrect upon reboot.

However, the pm2 daemon is ran as root, which makes me think that all my node-scripts also runs as root? Even though I added them as a regular user in the system. The log files and stuff is created in the users home dir, /~/.pm2/logs, but the logs are owned by root.

when I invoke pm2 startup (which handles the installation of the init.d script etc), it creates /etc/init.d/pm2-init.sh which looks like this:

#!/bin/bash
# chkconfig: 2345 98 02
#
# description: PM2 next gen process manager for Node.js
# processname: pm2
#
### BEGIN INIT INFO
# Provides:          pm2
# Required-Start:
# Required-Stop:
# Should-Start:
# Should-Stop:
# Default-Start:        2 3 4 5
# Default-Stop:         0 1 6
# Short-Description: PM2 init script
# Description: PM2 is the next gen process manager for Node.js
### END INIT INFO

NAME=pm2
PM2=/usr/local/lib/node_modules/pm2/bin/pm2
NODE=/usr/local/bin/node

export HOME="/root"

start() {
    echo "Starting $NAME"
    $NODE $PM2 stopAll
    $NODE $PM2 resurrect
}

stop() {
    $NODE $PM2 dump
    $NODE $PM2 stopAll
}

restart() {
    echo "Restarting $NAME"
    stop
    start
}

status() {
    echo "Status for $NAME:"
    $NODE $PM2 list
    RETVAL=$?
}

case "$1" in
    start)
        start
        ;;
    stop)
        stop
        ;;
    status)
        status
        ;;
    restart)
        restart
        ;;
    *)
        echo "Usage: {start|stop|status|restart}"
        exit 1
        ;;
esac
exit $RETVAL

When I dump the processes (which is what it will use when resurrecting the processes), I see mentions of user "USER":"pi" but I don't think that it's actually run as user pi.

Any thoughts?

We have come across an issue on IIS 7.5 where we have a simple deploy system which consists of the following:

Create a zip-file of new webroot, consisting of three folders:

Api
Site
Manager

This is unzipped into a new folder (let's say we call it "SITE_REV1"), and contains a script which invokes the following (one for each webroot):

C:\Windows\system32\inetsrv\appcmd set vdir "www.site.com/" -physicalPath:"SITE_REV1\Site"

This usually work, in 9/10 times. In some cases, the webroot seems to be updated correctly (if I inspect basic settings in IIS Manager, the path looks correct), but the running site in question is actually pointed to the old location. The only way we have managed to "fix it", is by running an IIS-reset. It isn't enough to recycle the application pool in question.

Sometimes it seems to even necessary be to make a reboot, but I'm not 100% sure that is accurate (it hasn't always been myself that was fixing the problem).

I rewrote the script using Powershell and the Web-Administration module, hoping that there was a glitch in appcmd, but the same issue occurs.

Set-ItemProperty "IIS:\Sites\www.site.com" -Name physicalPath -Value "SITE_REV1\Site"

Has anyone experienced something like this? Do anyone have a clue on what's going on, and what I can try and do to prevent this issue? Doing an IIS reset is not really a good option for us, because that would affect all sites on the server every time we try and deploy changes on a single site.

EDIT: We have identified that a start/stop of the site (NOT the application pool) in IIS Manager resolves the errorneous physical path, but if I stop the site using appcmd, change physical path, and then start it, I still suffer from the same issues. I'm at a blank...

Let's say I want to buy a wildcard SSL that I can use for web servers, spanning across a multitude of different servers and platform.

I could issue a CSR for each and every one of them, with their own private-public key pairs, but would it be possible to distribute the private key to all of the different servers and use the same certificate? That way, only issuing 1 CSR and then deploy this to a mixture of plattforms. OR, are the certificate issued differently for different platforms?

The current farm is a mixture of:

Windows 2008 R2 and IIS Linux and Tomcat (running JIRA and Confluence) Clavister firewall (I assume I don't get an answer to this though)

I'm looking for a log file analyzer software that can collect or read log files from multiple web servers, and aggregates the traffic report for all servers in the farm.

I've been looking at SmarterStats, however my requirements are as follows:

1. I will run the analyser-server on a dedicated machine
2. I will keep the logfiles on each farm-server in a zipped format (dont know if smarterstats support this?)
3. I want to analyze multiple sites on multiple servers, but all sites will have their own individual logfolder per server
4. Preferably the farm-servers can "send" data to the analyzer server, like SmarterStats can do with their "Remote Service", instead of relying on UNC/SAMBA or FTP

Good to have would be email-reporting, or an aggregated summary view with all sites and their total bandwith usage for an administrative user

SmarterStats supports most of the above, but I'm not sure about zipped logfiles or the aggregation of multiple access logs for each day (one for each server in the farm) without needing to copy and rename them, or combining them manually into one file.

Any pointers are appreciated!

Thanks

We have a web-app that basically catches all requests for url-rewriting purposes, except for a certain sub directory (/static) which has it's own web.config (NOT a subapplication!), which defines a StaticFileModule for all files.

However, since it is the same HttpApplication, all events are still fired for these requests, including OnAuthenticateRequest which is kind of problematic for us.

I wonder if there is anything I can configure in web.config to make it bypass the event-chain, or certain events in the chain (I have been looking into to no avail), or completely detach the sub directory from the root application (preferably without configuring the sub directory as an application)?

As of now I have use a special case in my OnAuthenticateRequest in order to bypass it, but I would like to contain it into the sub directory itself (not needing to maintain code in order to have static directories).

This might belong on stackoverflow as well.

We have a site where we have trouble on our production server, but not on my dev machine with request beeing aborted (hence, zero response).

It fails after exactly 1:19 minutes each time, and the request on my dev machine takes approx 1:44.

The content length is about 650K so that shouldn't be a problem.

The production enviroment is windows 2008 with IIS7 the dev enviroment is windows 7 with IIS 7.5

The have identical web.config but the machine config differs slightly (although they should be standard from install)

What could be causing this?

When looking in the access-log, the row says 0 byte in response byt win32-code 995 which should be 0 this is the last columns from the access-row:

sc-status sc-substatus sc-win32-status sc-bytes time-taken
200       0            995             0        76933

995 seems to be related to "thread aborted" or something, hence I'm kind of confident that it's IIS that aborts the request. the w3wp.exe process seems to run for some time even after the request stopped, so I don't think the web application even notices until it's time to write to the output stream.

EDIT: Have tried now with different connections and it seems like my firewall drops the connection because of no data (prematurely). Hence the 995 code.

I'm trying to use Net-SNMP on Windows to emulate a trap that should trigger an alarm on our surveillance system.

This is the setup:

• Windows 7 client that sends the trap
• Net-SNMP as software for sending the trap
• Linux with Adventnet ManageEngine OpManager as NMS (not relevant)

This is what I'm trying to accomplish

send trap with OID .1.3.6.1.4.1.5089.1.0.1 (according to the MIB I have loaded into my NMS) and just some sort of message into it to see if I can get any alarm in my NMS. I can see that I actually send a trap in my firewall, but I have no idea what it contains.

This is my attempt so far:

snmptrap.exe -v 2c -c xxxxxxx 192.168.100.65 '' 6 0 .1.3.6.1.4.1.5089.1.0.1 s "123456"

However, I can't seem to find any reasonable documentation with examples for snmptrap. Basically, I need to know what:

• '' <- why do I need this? I can omit it and it will still send a trap
• 6 <- Enterprise gneric trap, I assume. Is this correct?
• 0 <- I have no idea, I need some sort of value for this
• .1.3.6.1.4.1.5089.1.0.1 <- the enterprise specific OID I assume, should this be followed by some more numbers
• s <- indicates string
• "123456" <- just a random test-string...

This doesn't make much sense to me, and if anyone can shed some light on this I would be very grateful.

I need to setup surveillance on all our servers to spot any RAID degradation in time. However, not all of our servers have OpenManage installed, and since they are in production I don't like the idea of installing it on them.

Therefor: Is it necessary to have it installed in order to get an event-log for any degradation of the RAID? Because, if I get an event-log I can send an SNMP trap, if I understand it correctly.

I thought it was the driver that responsible for the event-logging, but on a machine that recently had a degradation, I can't seem to find any log event for it.

EDIT: this is for a Windows enviroment.

We have several old websites running classic asp that invokes a series of HTTP-request to external systems (in this case, geo-ip-lookup). This is just a single request, resulting in a country-code as a response (2 bytes), but since a webrequest on a web-page invokes (what I assume atleast) an ActiveX-instance of IE, it will cache this in "Temporary Internet Files", assumingly as the user "NETWORK SERVICE".

It stores all these responses in C:\WINDOWS\Temp\Temporary Internet Files\Content.IE5, but I haven't figured out a way to restrict the amount of space it should be allowed to use.

I'm not even sure if that would help, since the main problem is the 2-byte response, which "disk-wise" will utilize 1kb of space (cluster size) per cached response.

I could of course schedule a task that would clear out the cache, but I would rather disable it, or just limit it to a reasonable amount of space. But how would I do that?

This is the scenario:

We host several websites on multiple webservers, and I'm thinking about a way to consolidate the log-handling for all webservers.

Would it make sense to store all logs on a common NAS-device, with a dedicated machine that does logrotation, compression as well as summaries? My initial thought was to use a SAN with iSCSI, however you cannot attach a single partition to multiple clients then.

My goal was to eliminate the need for maintenance-task on the production servers, for easier deployment of new servers etc.

Follow-up question, how do IIS respond when it cannot write to the access-log? Will it fail miserably or just stop logging?

I just tried copying a file over cifs (windows file sharing) between a server 2003 R2 and a new server 2008 SP1 and I'm getting horrible speed.

it's a 300MB file that is taking around 30 minutes to transfer. I'm getting around 1-2Mbit/s and this is on a local switch.

I have tried initiating the transfer from both servers with the same results.

Copying from the 2003 to another 2003 is less than 1 min, so it's obviously something with the 2008-server.

An even weirder behaviour is that if I simultaneously copy another file from the 2003 server to another 2003 server, the transfer rate from the 2008 server increases drastically (like 10x times, but still slow though).

Over RDP-drivesharing I get full VPN-speed, approx 20Mbit. No other services seem to be suffering from any latency.

I have seen post about tcp offloading causing trouble in win2008, could it be related?

I want to setup a single instance of sql-server as a mirror-backup for 2 production-servers, and I need to use certificate authentication because they are not part of an AD-domain.

Reading the documentation, it claims this:

All mirroring connections on a server instance use a single database mirroring endpoint, and you must specify the authentication method of the server instance when you create the endpoint. Therefore, you can use only one form of authentication per server instance for database mirroring.

does this mean that it's impossible to use one instance, to backup databases from two other instances?

Since I need to create certificates on all three machines (if I understand it correctly), and I use certificates per endpoint. Shouldn't I be able to create two endpoints on my backup-machine that uses different certificates?