First the problem:
I’ve now upgraded 2 servers from Lenny to Squeeze and had the same problem for both. While following the official upgrade instructions everything is fine until the dist-upgrade process. During this, mysql-server-5.0 gets removed and is replaced by mysql-server-core-5.1 – I haven’t worked out what the new -core packages is meant to be used for but it isn’t a direct replacement for mysql-server so I’m not sure why it’s being installed during an upgrade.
After this, phpmyadmin gets upgraded and wants to install a configuration database but it can’t because there’s not a working mysql server so you’re forced to abort this process.
Now the solution:
Once this dist-upgrade has finished, it’s a fairly simple task of
apt-get install mysql-server
then
dpkg-reconfigure phpmyadmin
and everything seems fine. I haven’t lost any data in this process, just seems strange that it’s happening. It’s logged as a bug from October last year.
Moving SharePoint Services
Today I needed to move our SharePoint site to a different server. A quick google pointed me to stsadm and these two sites. It took a few attempts to get working, the 2 issues I came across were:
- Source server had SharePoint Services SP2 applied, destination server didn’t
- To get security settings to transfer, -includeusersecurity needed to be included in the command
STSADM is located in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
In the end, the commands I ran where:
- On the source server
STSADM.EXE -o export -url http://cck5 -includeusersecurity -filename C:\sharepoint.cab
- On the destination server
STSADM.EXE -o deletesite -url http://cck1 STSADM.EXE -o createsite -url http://cck1 -ownerlogin domain\administrator -owneremail administrator@domain.com -title "CCK Intranet" STSADM.EXE -o import -url http://cck1 -includeusersecurity -filename C:\sharepoint.cab
Recently, 1 of my DFS replication groups stopped working with the following error:
Event Type: Error
Event Source: DFSR
Event Category: None
Event ID: 4004
Date: 14/04/2010
Time: 12:55:33
User: N/A
Computer: CCK5
Description:
The DFS Replication service stopped replication on the replicated folder at local path D:\DFS Targets\Legacy.Additional Information:
Error: 9003 (The replication group is invalid)
Additional context of the error: D:\DFS Targets\Legacy\
Replicated Folder Name: Legacy
Replicated Folder ID: B7384F60-E4B2-4686-BB69-B9BD93CF8398
Replication Group Name: villas.cck\dfs\legacy
Replication Group ID: 50A2B981-6B8E-43DD-9D53-B6DE3EC091E4
Member ID: 361EF048-BD7D-449C-A37D-657160F87FC5For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
A google search seemed to indicate that my DFS database had got corrupted on this particular server. Looking in “D:\System Volume Information\DFSR\database_300C_6040_C5F_FEEA” [1] I could see a file called $db_dirty$ whereas the other DFS server had a file called $db_clean$ so I was confident that I’d tracked down the problem.
After making sure I had all data backed up, I stopped the Distributed File System and DFS Replication services, moved the database_300C_6040_C5F_FEEA folder to the desktop then restarted the 2 services. The DFS service then re-built the database and replication started again.
Before doing this, I suggest reading through this article which talks about minimising the effect of re-initialising a DFS member
Foot notes
1 – To get access to the System Volume Information folder, you may need to edit the folder’s security settings to give your login permissions.
When setting up a Windows Server 2008 R2 server as a DNS server, you may find that DNS queries don’t work. The fix is explained here – basically, run the following command:
dnscmd /config /EnableEDNSProbes 0
For a little while I’ve had a problem with the DFS Replication service not starting on 1 of my servers. The 2 event log messages are:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 08/04/2010
Time: 07:41:38
User: N/A
Computer: CCK5
Description:
Timeout (30000 milliseconds) waiting for the DFS Replication service to connect.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 08/04/2010
Time: 07:41:38
User: N/A
Computer: CCK5
Description:
The DFS Replication service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
After various Google searches I found this so I thought I’d investigate the Anti-Virus link a bit more – I’d already disabled my Anti-Virus (Kaspersky MP4) so thought I’d try uninstalling it. As soon as I’d done that (didn’t even reboot), I was able to start the service. I should have known really, I’ve previously had problems caused by Anti-Virus software on our voicemail server.