Jul
02
2015
1

UPDATE – Managing Multiple Interfaces with Fedora 21, libvirt, Qemu, NetworkManager

This post is an update to a previous post on using multiple interfaces(Ethernet cards) on the LAN, – utilizing RedHat’s popular virtualization tools – QEMU, KVM, libvirt, and virt-manager.  In this article I will demonstrate with Fedora 21, but this roughly applies to CentOS 7 as well.

I’ve resisted upgrading to recent versions of Fedora/CentOS for a long time.  The main reason is that I hate NetworkManager.  It does to much automatically; I much preferred the old ‘network’ daemon that could easily be manually set.  For instance if I create a Bridge(call it bridge1) interface assigned to my second Ethernet card(eth1) NetworkManager will automatically create a profile for each with automatic startup and DHCP enabled!  I don’t need or want a DHCP lease on either side of a bridged interface!  Among other issues are the creation of duplicate profiles when libvirt restarts.  So NetworkManger reports ‘bridge1’ & ‘bridge1’ in the NM start menu applet.

Ideally libvirt and NetworkManager would work hand in hand because Redhat sponsors both projects…

In this article we will describe the steps to allow you to connect two seperate NIC’s to a switch; assigning one of the NIC’s specifically to guest VM’s.

Goals of this post:

  • Set NetworkManager to ignore bridge and Ethernet device
  • enable systemd version of rc.local boot script to create bridge at boot
  • assign host to specific bridged Ethernet device

(more…)

Jan
28
2010
0

Windows 7 – no speakers or headphones are plugged in

I’ve been using Windows 7(Home Premium) for about a week now… and I gotta say I’m impressed.  It’s interface is almost as nice as Windows XP.  Running multiple programs doesn’t slow game frame rates nearly as bad and the desktop effects are pretty good.  Congratulations Microsoft!  You made a decent OS…  Only took 7 years, thus the name, ‘Windows 7’.  Although this is a huge leap forward there are still many, many problems.

For instance, my Soundblaster Live! Value sound card doesn’t have a driver from Microsoft or Creative Labs!  For God sake, it’s one of the most popular sound cards ever fabricated!  Are you *^&!@ing kidding me!?!?  So I ditched my card and re-enabled my Intel on-board audio.  Windows detected the driver just fine.

(more…)

Dec
27
2009
4

Ventrilo Linux Client in Fifth Year of Development

I play World of Warcraft on Linux all the time.  I boot into Windows XP for Arena and extended play, but all my causual gaming is on my work computer – that runs Linux.  So for this reason I’ve had an interest in the upcoming Ventrilo Linux client for a long time. A very long time.

Since 2005 when they first announced that the client version for Linux was on it’s way I’ve been excited!  Imagine the Linux Desktop getting support from the industry leader in VoIP group communications!  Unbuntu/Fedora Linux will benifit greatly by making it possible for more Linux gamers to communicate with fellow online gamers of any platform.  The only problem is that the Linux client was never released.  Or at least, not yet.

(more…)

Jun
07
2009
--

How to Configure Linux ODBC Connections for MS SQL

Last week at work(VoiceIP Solutions) I did some research for Asterisk PBX integration with Microsoft CRM.  The customer likes open source Asterisk because of the cost savings, but they requires screen pop-ups, and click to dial from their Customer Relationship Management software.  So while my manager worked on the TAPI middleware, I was charged with figuring out how to connect to the MS SQL database.  This article was prompted by a desire to connect an Asterisk PBX to MS SQL, but the tutorial applies to Apache, Postfix, CRM, PHP or any Linux app that needs to do a remote query.  Also, while the focus of this article is aimed at MS SQL the same steps(with a few tweaks) can be used for connecting to Postgre, Sybase, MySQL, etc…

I’m a lot more famalier with MySQL & PostgreSQL, but MS SQL I haven’t touched since I had the silly notion about 10 years ago to become a Windows 2000 MCSE.  Incidently, I never did take the exams, because I was a broke student at the time and I was becoming increasingly interested in Linux and Cisco.

The logical choice is to use the UNIX ODBC driver.  ODBC stands for Open Database Connectivity.  ODBC is a well documented set of API’s that is available on many platforms.  However, their are subtle differences in it’s implentation and the protocols that run at application layer.  In other words ODBC is encapsulated when making calls to a database over a network (in this case, the TDS protocol).

I did some googling and found a number of incomplete tutorials for connecting Linux to MS SQL.  This article is intended to clarify some common configuration errors and will present you with example files.  For my demonstration I’m running Fedora 10 with the latest updates as of this writing.  This article assumes you have a working MS SQL datebase with the proper user permissions in mixed mode.  I put this one in bold because it stumped the MCSE database guy for a while.

Again, I want to point out I’m not a Microsoft DBA and will likely not be able to help you on that side of the configuration.  Also, there are many versions of SQL out there and the syntax to pull data differs slightly from one version to the next.  So you may need to do a little research to make the proper pulls.

The Goals of this Post:

– install ODBC and TDS on Fedora 10

– verify TDS can login into MS SQL server

– configure odbcinst.ini, odbc.ini and freetds.conf configuration files

(more…)

May
12
2009
0

Xen Dom0 and Paravirtualized guest reported to work in Fedora 11 Beta

Xen 3.0 Dom0 support reported to be working

Xen 3.0 Dom0 support reported to be working

Great news everyone! Fedora Weekly News, issue 175 reports successful Dom0 integration in Fedora 11 Beta.  Here is the quote I read today:

Pasi Kärkkäinen reports[1] success with a dom0 kernel using Fedora 11 Rawhide. “I’m able to run Xen paravirtual (PV) domUs, install new domUs using virt-install and also install and manage domains with virt-manager.”



The environment used was:



– Fedora 11 (rawhide as of 2009-05-05)
– Xen included in F11, no external patches (xen-3.3.1-11.fc11)
– xen-tip/next pv_ops dom0 kernel as of 2009-05-06, Linux 2.6.30-rc3.
– All the rest was standard stuff included in Fedora 11 as well

This is all coming sooner than I previously expected.  I’ll be following up on this story next week as I compile more information and try it myself.  Paravirtualized Operations provide a significant boost to guest Operating System performance and no project implements it better than Xen.  I’m glad to read that it is working in Fedora 11.

Apr
15
2009
0

Fedora 10 and TVtime make gaming on your PC easy and affordable!

For a while I’ve been using a WinTV cable tv tuner card made by hauppauge. These cards are the best way to add TV/(console gaming) on the cheap.  WinTV cards are well supported by all major Operating Systems.  As of this writing you can only get HD tv tuner cards in the United States now, but I have an older card.  So I can’t personally vouch for the High Definition card drivers in Linux.  I’m guessing by now every major distro supports it.

My advice is to get the HD card if you can.  X-Box and PS3 are designed for HD TV’s, but in my example I’m showing Mario Kart on the Nintendo Wii.

Linux Installation is easy.  First check to see if Linux can see the device.

[matt@mattcom1 Desktop]$ lspci -vvv
07:01.0 Multimedia video controller: Brooktree Corporation Bt878 Video Capture (rev 11)
Subsystem: Hauppauge computer works Inc. WinTV Series
Control: I/O- Mem+ BusMaster+ SpecCycle- MemWINV- VGASnoop- ParErr- Stepping- SERR- FastB2B- DisINTx-
Status: Cap+ 66MHz- UDF- FastB2B+ ParErr- DEVSEL=medium >TAbort- <TAbort- <MAbort- >SERR- <PERR- INTx-
Latency: 32 (4000ns min, 10000ns max)
Interrupt: pin A routed to IRQ 22
Region 0: Memory at d2001000 (32-bit, prefetchable) [size=4K]
Capabilities: <access denied>
Kernel driver in use: bttv
Kernel modules: bttv
07:01.1 Multimedia controller: Brooktree Corporation Bt878 Audio Capture (rev 11)
Subsystem: Hauppauge computer works Inc. WinTV Series
Control: I/O- Mem+ BusMaster+ SpecCycle- MemWINV- VGASnoop- ParErr- Stepping- SERR- FastB2B- DisINTx-
Status: Cap+ 66MHz- UDF- FastB2B+ ParErr- DEVSEL=medium >TAbort- <TAbort- <MAbort- >SERR- <PERR- INTx-
Latency: 32 (1000ns min, 63750ns max)
Interrupt: pin A routed to IRQ 22
Region 0: Memory at d2000000 (32-bit, prefetchable) [size=4K]
Capabilities: <access denied>
Kernel driver in use: Bt87x
Kernel modules: snd-bt87x

You should see a video and audio capture device, for my model it is Brooktree.  Use the package manager of your Linux(in my case Fedora 10 and yum) to install TV Time.  Now hook up your Wii and start TVtime Television Viewer.  From Gnome Panel: Applications -> Sound & Video -> TVtime Television Viewer.  It’s that easy.  Enjoy.  For more information on TVtime television viewer click here.

Apr
08
2009
2

Install Queuemetrics Call Center software for Asterisk on Fedora 10


What makes Asterisk so great is the growing ecosystem of 3rd party software.  For call centers based on Asterisk PBX, the best on the market is Queuemetrics.  This solution allows for over 150 different statistics to be collected.  Here is just a few:

Number of calls
Total call length
Average call length
Average call waiting
Number of unanswered calls
Average time before disconnection
Area code
Number of calls
Total calling time
Average time per call (for taken calls)
Average wait per call
Average position at disconnection (for lost calls)
Number of available agents
Total agent time
Average agent time
Minimum/ maximum agent session duration
Agent availability

If by now you are not convinced take a look at the complete list; you can check out Loway’s site and Queuemetrics here.  I have personally helped setup several commercial call centers(while working for VoiceIP Solutions) with this software and I am impressed at the value and support for our customers purchase.  So today we are going to set up a basic Queuemetrics installation; we will not be covering the Asterisk portion.  Nothing fancy here, but I can get you started.

The goal of this post:

– install Queuemetrics

(more…)

Mar
24
2009
2

World of Warcraft won’t start under WINE after Fedora 10 update SOLVED

I did a ‘yum update’ on my Fedora 10 Linux box.  Right afterword I started WoW, but it crased and generated a error log that I saved to the desktop as, ‘imsettings-applet-bugreport.txt’  The error log complains that I’m not a member of the pulse-rt group.  I corrected that and WoW started normally.

Goals of this post:

-Describe how to add a user to the pulse-rt group for purpose of getting World of Warcraft under WINE running after a ‘yum update’

(more…)

Mar
22
2009
2

Fedora 11 will likely not include Xen Dom0 (virtualization) support

xen logo

I (like many of you) have been patiently waiting since Fedora 8 for Dom0(Domain 0) Xen support in Fedora.  Why hasn’t Red Hat or the Fedora Project made an announcement? Haven’t we been good? I mean libvirtd is great and all, but Xen PV(paravirtualized) VM’s destroy. I did some googling to get to the bottom of this. I found a fedora project page with a January 2009 status update.

Here is a snipit:

“Currently, the Fedora kernel-xen package is based on forward-porting of the XenSource patches from 2.6.18 to more recent kernel versions. This has many problems, including:

  • XenSource code has no chance of being merged upstream, in the near future, making the forward-porting work needed for all new kernel versions.
  • Lots of porting work for each new kernel version
  • Because of the above, kernel-xen has been some releases behind the non-xen kernel package, and the lag between kernel and kernel-xen has been increasing constantly”

And also:

“As of November 2007, the kernel-xen forward-porting was being finished for 2.6.22, and Linux 2.6.24 was about to be released. The effort needed for 2.6.23, 2.6.24 and later would have been even bigger with the introduction of paravirt_ops and the i386-x86_64 merge upstream. Thus, the decision was made to abandon the forward-porting effort and focus on upstream paravirt_ops.”

So where does this leave us?  Unmodified guest are old news.  Even Microsoft can do that.  Well not really, as I understand it, Microsoft’s HyperV platform contains Xensource licensed code.  But a customer of the company I work for likes HyperV a lot(incidently).  On the Xen Wiki it says that Paravirt_ops will be ported to the 2.6.30 kernel.  My prediction, Xen Dom0 support will be available toward the end of Fedora 11’s cycle or Fedora 12.

Why does Dom0 matter?  Dom0 is the specially modifed Xen-linux kernel that sits on top of the hypervisor. From Dom0 you can run fully virtualized guest and partially virtualized guest (paravirtualization).  Paravirtualized guest enjoy a method for allowing the use of a set of generic virtual device drivers provided by Dom0.  PV guest are known to have outstanding perfomance compared to their fully virtualized counterpart.  Paravirt_ops refers to Dom0 integration with the Linux kernel.

Mar
15
2009
2

Errors loading Asterisk addons, CDR(Call Detail Records) to MySQL

The other day I was doing an Asterisk 1.2 –> 1.4 upgrade.  I have a MySQL database that Asterisk records the Call Detail Record’s(CDR) too.  I deleted the asterisk 1.2 modules, then compiled/installed asterisk 1.4 & asterisk-addons 1.4.  Being that I hadn’t set up the CDR MySQL stuff in a while I loaded the res_mysql.conf, but I copied it from the cdr_addon.conf file by accident.  Because the two files have similer syntax It took me a while to figure this one out.  I checked all the passwords and I even checked the Asterisk CLI to see if the module loaded.  MySQL was populated with the same tables as before.  I also kept seeing this error (see below).

Possibly a mixed up addon file.

Possibly a mixed up addon file.

The error:

[Mar 15 03:25:44] ERROR[23793]: res_config_mysql.c:629 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on  (err 2002). Check debug for more info.

The res_mysql & cdr_mysql have very similer config files, but you can’t ‘cut & paste’ between them.

Sample configuration for res_mysql.conf:

;
[general]
;dbhost = 127.0.0.1
;dbname = asterisk
;dbuser = myuser
;dbpass = mypass
;dbport = 3306
;dbsock = /tmp/mysql.sock

; Sample configuration for cdr_mysql.conf:

[global]
;hostname=database.host.name
;dbname=asteriskcdrdb
;table=cdr
;password=password
;user=asteriskcdruser
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

Be careful not to mix the two between upgrades!