How To Linux

OTRS is an Open source Support Ticket System, its fairly easy to setup and has the ability to receive emails and add them automatically as tickets.

Personally I like its flexibility and they have just released OTRS 2.4.1 (Aitutaki – One Foot Island, Cook Island) which improves alot of its flexibilty.

It has great documentation at  http://doc.otrs.org/2.4/en/html/

I have version 2.3.4 installed and I want to upgrade it to the latest version OTRS 2.4.1.

Download the rpm

wget http://ftp.otrs.org/pub/otrs/RPMS/fedora/4/otrs-2.4.1-01.noarch.rpm

Change the permissions.

chmod 777 otrs-2.4.1-01.noarch.rpm

Run the rpm upgrade.

rpm -Uvh otrs-2.4.1-01.noarch.rpm

Upgrade the database Part 1

MySQL

cat /opt/otrs/scripts/DBUpdate-to-2.4.mysql.sql | mysql -p -f -u root otrs

PostgreSQL

cat /opt/otrs/scripts/DBUpdate-to-2.4.postgresql.sql | psql otrs

Run the migration script as OTRS user.

su otrs

/opt/otrs/scripts/DBUpdate-to-2.4.pl

I got this error and ignoreed it.

Message: Need Type!

Traceback (10973):

Module: Kernel::System::NotificationEvent::NotificationAdd (v1.2)

Module: main::MigrateCustomerNotification (v1.6) Line: 218

Module: /opt/otrs/scripts/DBUpdate-to-2.4.pl (v1.6) Line: 99

Update the database Part 2

MySQL

cat /opt/otrs/scripts/DBUpdate-to-2.4-post.mysql.sql | mysql -p -f -u root otrs

PostgreSQL

cat /opt/otrs/scripts/DBUpdate-to-2.4-post.postgresql.sql | psql otrs

Restart httpd and mysqld

service httpd restart

service mysqld restart

Restart otrs service

service otrs restart

Goto your otrs installation http://localhost/otrs/index.pl

NoMachine developed NX technology to handle remote X window sessions and to make a remote graphical display usable over lower connection speeds.

Google released a open source NX server called Neatx, looks pretty interesting, see it at – http://code.google.com/p/neatx/

Great news, they have released version 1.0 of VLC finally. In my opinion VLC is the best media player out there, it works! Get it here – http://www.videolan.org/vlc/

Install Ruby on Rails – Use http://www.how-to-linux.com/2008/12/how-to-install-ruby-on-rails-on-centos-52/

Create a database for Tracks

mysql -u root -p

create database tracks;

exit

Download Tracks from http://bsag.bingodisk.com/public/files/tracks-current.zip

Unzip the Tracks archive

unzip tracks-current.zip

Put tracks into /opt

mv tracks-1.7 /opt

Edit /opt/tracks-1.7/config/database.yml

vi /opt/tracks-1.7/config/database.yml

Add you mysql server details

production:

  adapter: mysql

  database: tracks

  hosts: localhost

  username: root

  password: neveruserrootpassword

Change a config in site.yml

vi /opt/tracks-1.7/config/site.yml

Add something unique in the salt parameter.

Add the Tracks data to the database

rake db:migrate RAILS_ENV=production

If you get this error;

no such file to load — mysql

Download ruby-mysql – http://rubyforge.org/frs/?group_id=4550

tar mysql-ruby-2.7.tar.gz

cd mysql-ruby-2.7

ruby extconf.rb –with-mysql-config

make

make install

Now run the server

script/server -e production

Goto http://localhost:3000

VLC media player is the best video player, it just about runs any type of media.  They have just released an update.

VLC media player is a highly portable multimedia player for various audio and video formats (MPEG-1, MPEG-2, MPEG-4, DivX, mp3, ogg, …) as well as DVDs, VCDs, and various streaming protocols. It can also be used as a server to server in unicast or multicast in IPv4 or IPv6on a high-bandwidth network.

Download it at - http://www.videolan.org/vlc/

I have been a big fan of the unleashed guides every since I purchased Mac OS X Tiger Unleashed. I loved this book as it was both great for beginners but had some reallly good advanced sections that allowed me to learn some great stuff on mac os x.

So, naturally, when I was looking for a guide to Centos, I purchased another unleashed book. As you probably know, Red Hat Enterprise Linux (RHEL) and Centos are basically the same product, minus the proprietary Redhat pieces and non GPL pieces that are not legally available for free. CentOS takes the GPL portions and repackages them as CentOS. This logically led me to Red Hat Enterprise Linux 5 Administration Unleashed. I found this to be a decent book that is great starting point for using Centos, though not as advanced as I would have liked.





Anyone have any suggestions for an advanced system admin book for Centos?

This is a list of a few twitterers I follow who write about technology and Linux or are just plain useful.

How To Linux – http://twitter.com/howtolinux
Techcrunch – http://twitter.com/TechCrunch
Chris DiBona, chief of open source at Google – http://twitter.com/cdibona
Brian Behlendorf, primary developer of the Apache Web Server – http://twitter.com/brianbehlendorf
Stormy Peters, executive director of the GNOME Foundation – http://twitter.com/storming
Matt Asay – The Open Road – http://twitter.com/mjasay
Zenoss – http://twitter.com/zenoss
Mike Culver – Amazon EC2 Cloud – http://twitter.com/MikeCulver
Linux Journal – http://twitter.com/linuxjournal
Bashcookbook – http://twitter.com/bashcookbook
Suns Open source guy – http://twitter.com/webmink
Snort Author – http://twitter.com/mroesch
IBM Open Source – http://twitter.com/bob_sutor
Sourceforge – http://twitter.com/sourceforge

There is another good post here on other people to follow - http://weblogtoolscollection.com/archives/2008/06/04/30-people-to-follow-on-twitter/

Don’t forget to follow this blog – http://twitter.com/howtolinux

Ostatic is running an article on Black Duck’s rookie of the year competition.  Worth a read to learn about some up and coming projects you might not be aware of.

http://ostatic.com/blog/10-open-source-projects-make-the-cut-as-rookies-of-the-year