Monthly Archives: December 2008

XenServer 5 with OpenBSD

Posted on by
Reply

Here is my experience trying to run OpenBSD with XenServer 5 Enterprise.

  • XenServer console doesn’t function properly as it keeps overlaying text displayed previously or anything you have typed into the console. Makes it very difficult to read and see what you are doing. As well it appears numerpad with numlock on does not work either. The best work around is to SSH into OpenBSD.
  • Receiving the following error messages at boot up, “clock: unknown CMOS layout” and “rl0: watchdog timeout”. Yes the NIC is being detected as a Realteak 8139. If I check /var/run/dmesg.boot out of the two error messages I only see the “clock: unknown CMOS layout”. So I would assume the watchdog timeout message occurs after initial boot sequence.

The biggest question is OpenBSD on XenServer 5 Enterprise consider production ready even if the errors cannot be resolved?

I’ve tried locating some definite solutions but I have yet to find anything and it appears that the network card issue maybe due to XenServer 5 itself. Any suggestions on how to solve these error messages and fix the XenServer OpenBSD console?

Source: Nabble – OpenBSD User Misc – OpenBSD and XenSource
Source: Citrix Forums – Change network device model for guest

Source: What does “watchdog timeout” signify?
Source: watchdog(4) manpage

Christmas Wallpaper

Posted on by
Reply

Finding free quality wallpaper is hard and its even harder to find quality wallpaper for Christmas. Here is a couple sources I came across with a pretty good selection. If you have any suggestions of other sources for the holiday season drop a comment.

Source: CSSBuilt – 29 Beautiful Christmas Wallpapers
Source: CSS Count – 30 List of Stunning Christmas Wallpapers

MySQL – Can You Concatenate Strings From a Column Into a Single Row?

Posted on by
39

How would one concatenate strings from a column (multiple rows) into a single row using MySQL? I see its possible with MS SQL Server 2005 and above. Any incite into how to achieve this in MySQL would be much appreciated.

MS SQL Server 2005 – Example

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

SELECT Web_Account_ID,
GroupNameConcat = REPLACE(
	(
	SELECT
		Web_Account_Group_Name_ID AS [DATA()]
	FROM
		tblWebAccountGroup WAG
	WHERE
		WAG.Web_Account_ID = WA.Web_Account_ID
	ORDER BY
		Web_Account_Group_Name_ID
            FOR XML PATH ('')
        ), ' ', ',')
FROM tblWebAccounts WA
ORDER BY Web_Account_ID

Query Results Example

MS SQL Server 2005 query example

Source: aspfaq.com – How do I concatenate strings from a column into a single row?