TruMan1's questions

I have a hosted VPS that is fully managed by the hosting company. For weeks they cannot figure out how to get DKIM working for my emails, even though in cPanel's Email Authentication section says DKIM is enabled. However, testing this shows the DKIM is failing for emails. I test this by sending an email to [email protected] and I get this:

----------------------------------------------------------
DKIM check details:
----------------------------------------------------------
Result:         fail (wrong body hash: expected 47DEQpj8HB***)
ID(s) verified: 
Canonicalized Headers:
   from:***
   content-type:text/plain'0D''0A'
   content-transfer-encoding:7bit'0D''0A'
   subject:'0D''0A'
   date:Sat,'20'10'20'Mar'20'2012'20'14:03:41'20'-0500'0D''0A'
   to:[email protected]'0D''0A'
   mime-version:1.0'20'(Apple'20'Message'20'framework'20'v1257)'0D''0A'
   dkim-signature:v=1;'20'a=rsa-sha256;'20'c=relaxed/relaxed;'20'd=***.com;'20's=mail;'20'h=From:Content-Type:'20'Content-Transfer-Encoding:Subject:Date:Message-Id:To:'20'Mime-Version;'20'bh=frcCV1k9oG9oKj3dp***;'20'b=

The hosting support said they generated the key then updated my DNS and I verified this in my Advanced DNS section in cPanel, but it still fails with the above error. I think I have shell access and know a thing or two about managing servers, so how can I try to resolve this myself or at least help the hosting support to fix it? I appreciate any help or advice.

I am getting the below error in my Azure website and am scrambling to fix it:

Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

How can I reset the pool or increase it?

I am coming from IIS and setting up virtual directories there is so pleasantly easy. You just right-click and add a "virtual directory" pointing to any path you like. This relative path gets reflected through the browser when viewing the site.

How do I accomplish the same thing with Apache? Symlinks scare me because deleting cascades through. Is there a better way to create virtual directories in Apache? I am using MAMP for Mac which uses apache2.

In my website's application pool, the identity is set to "ApplicationPoolIdentity". Normally I would use "Network Service" and give read/modify rights to "Network Service" on the website file system. However, someone told me to use "ApplicationPoolIdentity" instead because the site will have their self contained permissions (so one site cannot update files of another when all under "Network Service").

What NTFS user should I use for providing read/modify permissions to a website's "ApplicationPoolIdentity" though?

Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. Am I only stuck with installing the non-R2 SQL server to run side-by-side with my R2 database server?

I am using the native Windows 2008 backup to do nightly backups. It is using an entire drive as the backup. Can I restore the files on a different machine completely, or does it have to be on the same machine? Does it work the same way in Windows 7 / W2K8 R2?

I have the latest SQL Server 2008 R2 installed on a W2K8 server. The version number says "10.50.1600". My problem is that my backup fails to restore on the x64 machine.

I downloaded and installed the latest from Microsoft's page for a Windows 7 Ultimate 64-bit machine. The SQL Server 2008 R2 version on this one says "10.00.4000". Now I can't backup/restore databases between the machine. I get this error:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

I used the latest downloads from this page for both machines but ended up with different versions #'s: http://www.microsoft.com/express/Database/ . My question is how do I update the 64-bit machine to the "10.50.1600" version number?

EDIT:

Exact version using "SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')":

W2K8 / x86 machine = 10.50.1600.1, RTM, Express Edition with Advanced Services

W7 / x64 machine = 10.0.4000.0, SP2, Express Edition (64-bit)

In Disk Management for Windows 2008, I have an extended partition that looks like this:

|----X:\ Drive----||----Y:\ Drive----||-------Z:\ Drive-------|

I am running out of space for the Y: drive. I have a lot of space I can spare in the Z: drive. If I shrink the Z: drive, will the space be available to extend the Y: drive? Or will the empty space only be for any drives that come after the Z: drive?

I wish there was some kind of preview to this, so I am asking for help.

I have a W2K8 domain controller network and everything was working perfectly on a network router on 192.168.0.1. It is also a DHCP server.

I had to temporarily move the domain controller into another physical place. So I plugged it into a router that is in charge of 192.168.1.1. How do I make both networks work in parallel? I want some laptops to connect wirelessly to the 192.168.1.1 router, but get on the 192.168.0.1 like they were on before, so they have access to the shared files.

How can I achieve something like this?

I have a reverse DNS and SPF records correctly setup for my mail server. Sending webmail from it works perfect.

The problem is when Thunderbird sends out emails, it is using the client's IP address for the hostname. I have SMTP authentication and specified my mail server's as the outgoing SMTP. Mail is being sent, but it is not "signing" the email with the mail server's IP address.. it is using the client's.

Is there any way to fix this?

This is the spam error I get when sending from Thunderbird:

Spam: Reverse DNS Lookup, SPF_SoftFail

I have MySQL 5.0 installed on a Windows 2008 machine (3GB RAM). My server crashes on a regular basis (almost once a day) always with this only error:

Changed limits: max_open_files: 2048  max_connections: 800  table_cache: 619

I did not use the heavy InnoDB .ini file, although I am rethinking that I should have? I am worried that big configuration changes will make my current sites stop working. What should I do?

Here is my current ini settings:

default-character-set=latin1
default-storage-engine=INNODB
max_connections=800
query_cache_size=84M
table_cache=1520
tmp_table_size=30M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=30M
key_buffer_size=129M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=6M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=3M
innodb_buffer_pool_size=250M
innodb_log_file_size=50M
innodb_thread_concurrency=10

Here is some extra information from phpMyAdmin:

Server: MYSERVER (localhost via TCP/IP)
Server version: 5.0.90-community-nt
Protocol version: 10
MySQL charset: UTF-8 Unicode (utf8)
Microsoft-IIS/7.0
MySQL client version: 5.0.90
PHP extension: mysqli

From my research, it seems to me that this error is saying that the OS hard coded limits keeps getting hit and that I should use the innoDB heavy .ini file. However, I do not know what the implications will be for my sites using MySQL. Below is the heavy innoDB configurations I am thinking of replacing it with, can anyone tell me what this will mean for my sites with existing databases? They are all InnoDB and even all their tables are InnoDB. Am I on the right track?

[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock

back_log = 50
max_connections = 100
max_connect_errors = 10
table_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 8
thread_concurrency = 8
query_cache_size = 64M
query_cache_limit = 2M
ft_min_word_len = 4
default_table_type = MYISAM
thread_stack = 192K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 64M
log-bin=mysql-bin
log_slow_queries
long_query_time = 2
log_long_format
server-id = 1
key_buffer_size = 32M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
skip-federated
skip-bdb
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 8M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120

[mysqldump]
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit = 8192

I have a script I have been using on another Windows 2008 to delete the IIS7 backup of configs and create a fresh one:

SET DEST=C:\Backup\Web\IIS7
SET BACKUPNAME=IIS7-CONFIGS
%windir%\system32\inetsrv\appcmd.exe delete backup "%BACKUPNAME%"
%windir%\system32\inetsrv\appcmd.exe add backup "%BACKUPNAME%"
robocopy %windir%\system32\inetsrv\backup "%DEST%" /MIR /R:6 /W:10 /ZB

But on a new Windows 2008 server, I get an access denied on the delete:

ERROR ( hresult:80070005, message:Command execution failed.
Access is denied.
 )

I have UAC turned off and pretty much copied all the settings from the old server (including user role being an admin). What am I missing?

I currently have my web server and SQL Express / MySQL server on the same server. It is on a VPS. I have been having problems with my hosting so I am thinking of separating the web and db server into 2 VPS servers.

Does anyone recommend this? I am worried that changing my setup from a local DB server to a remote one will degrade performance heavily. They will not be on the same network, but will reference each other via an IP address. Anything I should be aware of?

I currently have MySQL 5.1.35 installed on a Windows 2008 server via the MSI installer. I need to upgrade to the latest 5.1.44 to fix a bug, but docs were not clear on how to do this.

I ran the MSI installer, but it did not give me any upgrade option so I quit it. I am weary because it's a production machine with many PHP websites running on it. Also, my data directory is not the default one, it's kept on another partition.

How can I upgrade it? Thanks for any help.