This is a detailed description about how to set up an OpenSuSE 10.2 based server that offers all services needed by ISPs and hosters (web server (SSL-capable), mail server (with SMTP-AUTH and TLS!), DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall, etc.).

French website Mac4Ever reports - thanks to Babelfish translation:. . . the few innovations of Leopard, one read these last months, several rumours on the integration of a new filing system, the ZFS, which presents a revolution in the field of the storage of data.

if I had a euro for every post written about Google’s business model, I would be very rich. Actually, if I had a euro for everytime Nick Carr writes about Google I’d be well off. Writing about Google and Wikipedia seem to be occupational hazards of blogging.

Today, in Potsdam, some serious German Government heavyweights, academics and business types are getting together to talk about the future of IT in Germany. I’ve written before (It was my very first post) that the US software industry has benefitted tremendously from state support, and it is about time that the governments in Europe started to invest in the future of IT rather than just subsidizing cows.

A reaction to Le Web 3, a conference held in Paris, by blogger and business journalist Adam Tinworth. Perhaps this was the birth pangs of a new age of conferences…

Scary story of someone who was told by his bank that he's no longer welcome as a customer, because the bank noticed a deposit that wasn't "normal."

Skype co-founders Janus Friis and Niklas Zennstrom have discovered broadband-powered TV and are busy at work on their code-named Venice Project, which aims to do for Internet-delivered video what Skype did for VoIP. The service is currently in trial mode with 6,000 people and the Financial Times’ Andrew Edgecliffe-Johnson got to see a demo of the work-in-progress at a Starbucks in London, conducted by none other than Friis himself.

TechCrunch is reporting PayPerPost is giving in to pressure to become more transparent with its network. With the FTC apparently ready to crack-down on marketers not disclosing their relationships with companies, PayPerPost will start requiring publishers to reveal whether they receive payment mentioning a company.PayPerPost’s new Terms of Service require participating content creators to [...]

Thanks to a deal between Cingular and MySpace, you’ll never have to worry about what each of your thousands of friends are doing, while you’re away from your computer. Mashable is reporting that MySpace Mobile is going live today.…allowing Cingular subscribers to add photos, blog posts and comments to their MySpace pages for $2.99/month. [...]

Last year when reports about Cyber Monday came out, I was skeptical. However, it looks as though Cyber Monday is a real phenomenon—but not exactly as Shop.org claimed when they fabricated the term last year.comScore reports that the best single day for online commerce this year was indeed a Monday—Monday, December 11. With [...]

Last week, Vertis Communications released their Consumer Focus® Tech Savvy study. The headline they ran with was “Future Plans Reveal Women to be More Tech Savvy.” That conclusion was based on their finding that 74% of Generation Y women (born 1977-1994) are planning on buying at least one electronic device in the next [...]

Just got this email on the «videos from this years Hack in The Box Security Conference have been released via Bit Torrent. The downloads are broken down into 2 packs (6.52GB and 5.66GB respectively). For those of you who want to only download certain presentations from the pack, please use a more advanced Bit Torrent client like Azureus which offers the ability to select which files within the pack to download and even allows you to set the priority of the download.

Skype to launch Web TV service - Yahoo! News

http://news.yahoo.com/s/nm/20061218/tv_nm/skype_television_internet_dc_1

Mozilla, the developer of the free Thunderbird e-mail client, has taken a good program and made it better with the release of the version 2.0 beta 1. It is rare that a beta release is not buggy, clunky, and generally a mess — especially when, as word has it, the developers are changing the code base — but I was pleasantly surprised by its stability and the dearth of issues.

Can you believe ringtones are such a big business?

Well, if you don't want to add a few more bucks to your monthly phone bill for a custom ringtone, then Magix's Ringtone Maker 2 might just be the product for you.

Aviva Directory has 99 fantastic tips for anyone looking to build, launch and brand a new web site.This is going in my bookmarks!Pilgrim Partners: Recover Lost Files - Recover files & partitions accidentally deleted on Windows XP/2000

Looks like Wengo beat Adobe to the punch in offering a Flash VoIP client. If you recall, both Om and I discussed how Adobe was planning on offering a Flash VoIP client.

Check out the news courtesy of Slashdot:
"Wengo, a French company specializing in VoIP and instant messaging, and patron of the OpenWengo project (previously featured in Free Software magazine and here on Slashdot), has just released WengoVisio — a Flash softphone that you can download and embed in your Web page, to allow readers to call you when you're available through their browser, without downloading any software. (Disclaimer: I work for Wengo, on the OpenWengo project.) It's functionally cut down from the full Wengophone, but it's enough to be able to make a phone call in a Web page for the first time."

Hat tip to Greg for forwarding.

TrackBack (0) | Comments (0) | Tag with del.icio.us | VoIP & Gadget Blog | Permalink: Wengo releases Flash VoIP client

On this, the 5th day of Christmas, I am a bit short on time, so I am going to give you a quick but handy script for website admins, plus follow up on yesterday's post regarding reporting on server attributes. I'll make it up with another management pack or two between now and Christmas.

While all of us blogged on and on about the union of the iPod and the cell phone into something we all loved to call the iPhone, Cisco has quietly been watching and waiting, no saying a word, even though they filed the trademark application for the name 10 years ago.

Okay, to finish up on our discussion yesterday, MOM's Onepoint database contains quite a bit of information on the characteristics of your agent-managed servers. Clearly, the right way to manage and report on server configuration is through a systems management package like SMS. But for the underprivileged, MOMma will do in a pinch.

Now this query performs a couple of joins to pull this data out. for a given server. To display characteristics for a given server contained in multiple database records in a single line of output, you have to go one of two ways. Most people use # temp tables to accomplish this, which is the wrong way to go. Derived tables is the new black, and holds several advantages over temp tables, including 1) it offers much better performance, because the derived tables are stored in memory and 2) It is SQL Reporting Services friendly. It takes building a stored procedure to get SQL Reporting Services to swallow a temp table.

So if you're an SRS neophite, get comfy with derived tables...if you're old school and using temp tables, consider switching. Find a tutorial on derived tables in TSQL HERE.

And here's your sample query, with some quick comments on what's happening (run against Onepoint). This returns server name, IP address, time zone bias and Active Direcory Site (this last column requires you follow steps HERE first). Dig around and see what other attributes you can find of interest to you. Given we avoided temp tables, you can turn this into a MOM Report with minimal effort.

--First derived table (aliased as a1) returns IP addresses
--Notice the left outer join - outer joins ensure we get a list of all agent-managed server even
--if we have null values in some columns
select DISTINCT a1.Server,a1_IP as [IP Address],b1_OS as [OS Version], c1_TimeZoneBias as [Time Zone Bias], d1_ADSiteName as [AD Site], e1_Misc
from (select DISTINCT b.[Name] as Server,c.Value as a1_IP from Instance a
left outer join computer b on a.instanceID = b.idComputer
left outer join attribute c on a.instanceID = c.instanceID
left outer join classattribute d on c.classattributeID = d.classattributeID
where d.ClassAttributeName = 'IPAddress' and c.Value is not NULL
Group by b.[Name], c.Value) AS a1