Bo Wu's IT Lab

博闻精思 物我一体

Browsing Posts in Open Source

openfire How to Recover Openfire admin Password

Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. It is very well suited as corporate instant messaging solution.

After I installed the Openfire, I could not login using the admin’s password while I am 100% sure that my password was correct. I believe it is a bug of Openfire.

Here is how I recoved the admin’s password.

1. Run Openfire Installation Wizard again:
cd /usr/share/openfire/conf
vi openfire.xml
Change the true to false

Run the Installation Wizard again, which is http://your_ip_address:9090/

2. Select MySQL as the Openfire’s database during the installation. You may still select HSQLDB instead of MySQL. Because I am not familiar with HSQLDB, I selected MySQL which is easy for me to reset admin’s password.

You need to create a new MySQL database and provide the related information in the installation wizard.

After you finished the installation wizard, you can go to next step.

3. Reset admin’s password in MySQL:
Login to MySQL and use openfire database. I use the command:
mysql -u root -p openfire

Display the password for the admin user with the query:
select password from ofUser where username = ‘admin’;

The encryptedPassword field is your admin’s password. Change the admin (or any other users) password by setting password field to chosen value and encryptedPassword field to null. For example here is the query to set the admin password to 123456:
update ofUser set password=’123456′, encryptedPassword = null where username =’admin’;

This will change the current admin password to 123456. Remember to change it to a different value after you login to the admin console. This will change your password to null and encryptedPassword to an encrypted string for added security purpose.

4. Restart the Openfire and Login again:
/etc/init.d/openfire restart

http://your_ip_address:9090/

wordpress Wordpress in Ubuntu 9.10 cant be visited from Network

You have two options to install WordPress in Ubuntu 9.10. The first option is to download and install WordPress manually. If you are in a shared web hosting environment, you have to do this way.

The second option is to install it from the Ubuntu’s repository. If you are the root, you can just type:

apt-get install wordpress

Everything will be installed and configured automatically for you.

However, you need to change following configuration manually, otherwise the WordPress can only be visited at your local host, like http://localhost/wordpress/. If you visit it from network, like http://your_ip_address/wordpress, you will get an error.

You can solve it as following:

cd /etc/wordpress/

sudo cp config-localhost.php config-newhostname.php

sudo chown www-data config-newhostname.php

sugarcrm Install SugarCRM

SugarCRM is an open-source software-solution vendor which produces the Sugar Customer Relationship Management (CRM) system.

0. Prerequisites:

  • Apache Web Server
  • MySQL Database
  • PHP5 (including Pear, Curl, IMAP Modules)

1. Install PHP Pear Module

apt-get install php-pear

2. Change Permission:
chmod 766 config.php
chmod 766 -R data
chmod 766 -R cache
chmod 766 -R custom
chmod 777 -R modules

3. Create MySQL Database
mysql -u root -p
mysql> CREATE DATABASE sugarcrm;
mysql> USE sugarcrm;
mysql> GRANT ALL PRIVILEGES ON sugarcrm.* TO sugarcrm@localhost IDENTIFIED BY ‘mypassword’;

DB Name: sugarcrm
DB User: sugarcrm
DB User Password: mypassword
DB Host: localhost

4. Run Installation Wizard at http://localhost/sugarcrm/

1) Set /etc/php5/apache2/php.ini to increase:
- PHP Memory Limit from 16M to 40M
memory_limit = 40M
- Upload File Size:
upload_max_filesize = 48M

2) Install cURL for the purpose of transferring data.
apt-get install php5-curl

3) Install IMAP Module: InboundEmail and Campaigns (Email) require the IMAP libraries. Neither will be functional.
apt-get install php5-imap

4) Create an empty .htacess file under the root directory of SugarCRM and chmod it to 777.

After hitting the “Install” button, the Wizard will create all tables in MySQL. If you selected the “Sample Data”, it will also create it for you. It will also write following data to the .htaccess file created by you.

# BEGIN SUGARCRM RESTRICTIONS RedirectMatch 403 (?i).*\.log$ RedirectMatch 403 (?i)/+not_imported_.*\.txt RedirectMatch 403 (?i)/+(soap|cache|xtemplate|data|examples|include|log4php|metadata|modules)/+.*\.(php|tpl) RedirectMatch 403 (?i)/+emailmandelivery\.php RedirectMatch 403 (?i)/+cache/+upload RedirectMatch 403 (?i)/+files\.md5$ # END SUGARCRM RESTRICTIONS

Now, you can change the .htaccess permission to 644.

Congratulations! You finished the installation of SugarCRM.

You can go to http://localhost/sugarcrm to test and use it from now.

Reference: http://www.sugarcrm.com/wiki/index.php?title=Installation

500 internal server error 500 Internal Server Error & Some Plugins Not Working

When I upgraded the WordPress to 2.9.2 and enabled the Akismet plugin, I got 500 Internal Server Error. The reason is some WordPress 2.9.2 and some plugins need PHP 5. So, I solved the problem by adding Type and Handler for PHP 5 in the .htaccess file at the WordPress Root Directory.

My .htaccess file looks as following:

AddType x-mapp-php5 .php
AddHandler x-mapp-php5 .php

# BEGIN WordPress

RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

# END WordPress

I’m looking for a free video editor similar to – Adobe Premiere Pro, Apple iMovie, Final Cut Pro or Microsoft Movie Maker under Linux Desktop operating system. My tasks are pretty simple such as cutting, filtering, and encoding tasks etc. Can you provide me a list of FOSS software which can be used for video capture and video editing purposes under Fedora or Ubuntu Linux desktop systems?
A non-linear editing system (NLE) is a video editing (NLVE) or audio editing (NLAE) system which can provide editing method for video clips or frams. You will be able to access any frame in a video clip. Non-linear editing is done for film and television post-production. However, the cost of editing system gone down and non-linear editing tools (including software) are now within the reach of most home users.

MS-Windows PC included Windows Movie Maker and Apple computer comes with iMovie. Most Linux based editing software can now be downloaded free of charge from the Internet. You also need a video capture card and a FireWire connection to capture digital video from a DV camera.

Avidemux

Avidemux is a free video editor designed for simple cutting, filtering and encoding tasks. It supports many file types, including AVI, DVD compatible MPEG files, MP4 and ASF, using a variety of codecs. Tasks can be automated using projects, job queue and powerful scripting capabilities. Avidemux is available for Linux, BSD, Mac OS X and Microsoft Windows under the GNU GPL license.

Fig.01: Avidemux in Action under Ubuntu (image credit: Wikipedia)Fig.01: Avidemux in Action under Ubuntu (image credit: Wikipedia)

How Do I Install Avidemux Under Debian / Ubuntu Linux Desktop?

Type the following command:

$ sudo apt-get install avidemux

Embedding The Subtitles to AVI By Using Avidemux

=> Download Avidemux

Cinelerra

Cinelerra is the most advanced non-linear video editor and compositor for Linux. Cinelerra also includes a video compositing engine, allowing the user to perform common compositing operations such as keying and mattes. Cinelerra includes support for very high-fidelity audio and video: it processes audio using 64 bits of precision, and can work in both RGBA and YUVA color spaces, using floating-point and 16-bit integer representations, respectively. It is resolution and frame rate-independent, meaning that it can support video of any speed and size.

Fig.02: Cinelerra Rendering in Action (credit Cinelerra project)Fig.02: Cinelerra Rendering in Action (credit Cinelerra project)

Video editing in Ubuntu Using Cinelerra Part 1

Cinelerra Tutorial Capturing Desktop Screens

=> Download Cinelerra

Kdenlive

Kdenlive is an intuitive and powerful multi-track video editor, including most recent video technologies. Kdenlive supports all of the formats supported by FFmpeg (such as QuickTime, AVI, WMV, MPEG, and Flash Video), and also supports 4:3 and 16:9 aspect ratios for both PAL, NTSC and various HD standards, including HDV. Video can also be exported to DV devices, or written to a DVD with chapters and a simple menu. Kdenlive packages are freely available for GNU/Linux, FreeBSD and Mac OS X under the terms of GNU General Public License version 2 or any version later.

Fig.03: Kdenlive in Action (credit: Kdenlive project)Fig.03: Kdenlive in Action (credit: Kdenlive project)

How Do I Install Kdenlive Under Debian / Ubuntu Linux Desktop?

Type the following command:

$ sudo apt-get install kdenlive

Video Effects & Stacking – Kdenlive 0.7 – Ubuntu 8.10

=> Download Kdenlive

Kino

Kino is a non-linear DV editor for GNU/Linux. It features excellent integration with IEEE-1394 for capture, VTR control, and recording back to the camera. It captures video to disk in Raw DV and AVI format, in both type-1 DV and type-2 DV (separate audio stream) encodings.

Fig.04: Kino Main Window (image credit - Kino porject)Fig.04: Kino Main Window (image credit – Kino porject)

How Do I Install Kino Under Debian / Ubuntu Linux Desktop?

Type the following command:

$ sudo apt-get install kino

LINUX video capture – KINO Tutorial

=> Download Kino

LiVES

LiVES (LiVES is a Video Editing System) is a free software video editing program and VJ tool. LiVES mixes realtime video performance and non-linear editing in one professional quality application. It will let you start editing and making video right away, without having to worry about formats, frame sizes, or framerates. It is a very flexible tool which is used by both professional VJ’s and video editors – mix and switch clips from the keyboard, use dozens of realtime effects, trim and edit your clips in the clip editor, and bring them together using the multitrack timeline. You can even record your performance in real time, and then edit it further or render it straight away.

For the more technically minded, the application is frame and sample accurate, and it can be controlled remotely or scripted for use as a video server. And it supports all of the latest free standards.

Fig.05: Lives: Linux Video Editing System (Image: Lives project)Fig.05: Lives: Linux Video Editing System (Image: Lives project)

Demo made using LiVES Software

=> Download LiVES

Comparison Of Video Editing Software

Feature Avidemux Cinelerra Kdenlive Kino LiVES
License GPL GPL GPLv2 GPL GPLv3+
Cost Free Free Free Free Free
Paid Support N Y N N N
RAM (min) ? 256M 256M ? 128M
Hard Disk (min) ? ? 1G ? 10G
CPU ? 500Mhz 600Mhz ? 800Mhz
High Definition Video Editing ? Y Y ? Y
Non-destructive Editing ? Y Y Y Y
Full-screen Playback ? Y Y Y Y
Storyboard Mode ? N Y Y N
Video Tracks Y Y Y ? Y
Audio Tracks Y Y Y ? Y
Linear Timecode Display ? Y Y ? Y
DVD Output ? Y Y N Y
HD Output ? Y Y N Y
Smart Phone Output ? Y Y N Y
QuickTime Output ? Y Y N Y
Windows Media Output ? Y Y N Y
MPEG-4 Output ? Y Y Y Y
Web Output ? Y Y N N

Other Open Source Non-linear Video Editing Software For Linux Operating Systems

  1. Blender – 3D animation suite (cross-platform) : Blender is a 3D graphics application. It can be used for modeling, UV unwrapping, texturing, rigging, water simulations, skinning, animating, rendering, particle and other simulations, non-linear editing, compositing, and creating interactive 3D applications, including games. Blender’s features include advanced simulation tools such as rigid body, fluid, cloth and softbody dynamics, modifier based modeling tools, powerful character animation tools, a node based material and compositing system and Python for embedded scripting.
  2. OpenShot Video Editor : OpenShot Video Editor is an open-source program that creates, modifies, and edits video files.
  3. PiTiVi : PiTiVi is a program for video editing based on the GStreamer framework. It can – Capture and encode audio and video, with formats supported by GStreamer, split and trim video clips, split and trim audio, render projects in any format supported by the GStreamer framework etc.

Our Recommendation

  • Use Cinelerra for professional work. It is very fast, and can handle a heavy load. You can also obtain paid support for this product.
  • For video encoding and conversion purpose use Avidemux.

Who Uses…?

  1. Cinelerra – Recommended for Animator, Artist/Illustrator/Designer, video editor.
  2. Kino – Recommended of home user, video editor, and videographer.
  3. Avidemux (Non-Linear Editor) – Recommended videographer
  4. Kdenlive – Recommended for home user.
  5. LiVES – Recommend for home user and VJ.

What Software do you use for Digital Video Editing?