Aug
01
2017
0

BASH script to cp/mv files of a certain date

I have a client that owns a high volume call center.  For quality assurance and training purposes they record all the calls.  Periodically the volume of recorded calls grows to the point that it slows down the NFS share to the Queuematrics call center software(Tomcat app).  I wrote a script that finds files by time and moves them to a different directory.

Usage: copy-by-date.sh -i INPUT_PATH -o OUTPUT_PATH -d +DAYS_OLD

(more…)

Jul
27
2017
0

Python module for generating NPC’s in Star Wars RPG

Recently table top gaming has made a huge comeback.  For the first time in 20 years my friends and I are role playing!  We agreed on the new Star Wars RPG by Fantasy Flight games, STAR WARS: Age of Rebellion role playing game.  It’s novel in many aspects compared to the previous D6 and D20 systems.  If you like Role Playing and Star Wars I advise that you take a look!  Since I’m frequently tasked as the GM I’ve automated the process of Non Player Character creation with Python to free up more time for story development.  I developed a module toward this end.  It’s portable between scripts and is easy customize.

The code is on the page below, but you can find updated SWNPC on Github as well.

Goals of this post:

  • Introduce SWNPC module
  • Demonstrate how to customize npc() object
  • Example use

(more…)

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…)