分类 Open Source 下的文章

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/

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

Top 5 Linux Video Editor Software

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?

Top 10 Open Source Web-Based Project Management Software

This is an user contributed article.

Project management software is not just for managing software based project. It can be used for variety of other tasks too. The web-based software must provide tools for planning, organizing and managing resources to achieve project goals and objectives. A web-based project management software can be accessed through an intranet or WAN / LAN using a web browser. You don't have to install any other software on the system. The software can be easy of use with access control features (multi-user). I use project management software for all of our projects (for e.g. building a new cluster farm) for issue / bug-tracking, calender, gantt charts, email notification and much more.

Obviously I'm not the only user, the following open source software is used by some of the biggest research organizations and companies world wild. For example, NASA's Jet Propulsion Laboratory uses track software or open source project such as lighttpd / phpbb use redmine software to keep track of their projects.

You use the following top 10 software for personal or business use. Keep track of all your projects in one place and finish them successfully on time.

#1: Codendi

Codendi is an open-source collaborative development platform offered by Xerox. From only one interface, it gathers, all the needed tools for software development teams: management and versioning of code, bugs, requirements, documents, reporting, tests etc. It is mainly used for managing software project processes.

#2: Redmine

Redmine is a flexible project management web application. Written using Ruby on Rails framework, it is cross-platform and cross-database. It includes calendar and gantt charts to aid visual representation of projects and their deadlines.

#3: ProjectPier

ProjectPier is a Free, Open-Source, self-hosted PHP application for managing tasks, projects and teams through an intuitive web interface. ProjectPier will help your organization communicate, collaborate and get things done Its function is similar to commercial groupware/project management products, but allows the freedom and scalability of self-hosting.

#4: Trac

Trac is an open source, web-based project management and bug-tracking tool. Trac allows hyperlinking information between a computer bug database, revision control and wiki content. It also serves as a web interface to a version control system like Subversion, Git, Mercurial, Bazaar and Darcs.

#5: Project HQ

Project HQ is a collaborative open source project management tool, similar to Basecamp and activeCollab. Project HQ is built on open source technologies like Python, Pylons and SQLAlchemy and is fully database independent. Project HQ uses a structured workflow to assist you in managing your projects.

#6: Collabtive

Collabtive is a web-based project management software that is being published as Open Source software. The project was started in November 2007. It strives to provide an Open Source alternative to proprietary tools like Basecamp or ActiveCollab.

#7: eGroupWare

eGroupWare is a free open source groupware software intended for businesses from small to enterprises. Its primary functions allow users to manage contacts, appointments, projects and to-do lists.

It is used either via its native web-interface, making access platform-independent, or by using different supported groupware clients, such as Kontact, Novell Evolution, or Microsoft Outlook. It can also be used by mobile phone or PDA via SyncML.

#8: KForge

KForge is an open-source (GPL) system for managing software and knowledge projects. It re-uses existing best-of-breed tools such as a versioned storage (subversion), a tracker (trac), and wiki (trac or moinmoin), integrating them with the system

Top 5 Email Client For Linux, Mac OS X, and Windows Users

Linux comes with various GUI based email client to stay in touch with your friends and family, and share information in newsgroups with other users. The following software is similar to Outlook Express or Windows Live Mail and is used by both home and office user.

Webmail interfaces allow users to access their mail with any standard web browser, from any computer, rather than relying on an e-mail client.

However, e-mail client remains extremely popular in a large corporate environment, small business, home and power users. An e-mail client (also mail user agent (MUA)) is a frontend computer program used to manage e-mail. Mail can be stored on the client, on the server side, or in both places. Standard formats for mailboxes include Maildir and mbox.

The following are top five amazing piece of cross-platform software from various projects to make your life easy with wide variety of plug-ins / add-ons.

#1: Mozilla Thunderbird

It is an e-mail and news cross-platform client software package by Mozilla Foundation. Thunderbird can manage multiple e-mail, newsgroup and RSS accounts and supports multiple identities within accounts. Features like quick search, saved search folders , advanced message filtering, message grouping, and labels help manage and find messages. Just like Firefox, the tons of extensions and themes for this client makes it very secure and flexible to to enhance your productivity.

Fig.01: Mozilla ThunderbirdFig.01: Mozilla Thunderbird

=> Download Mozilla Thunderbird

#2: Claws Mail

Claws Mail is a free, GTK+-based, open source email and news client. It is very light lightweight. Like Firefox , the wide variety of plug-ins for this email client makes it very flexible and secure. Claws Mail runs on Windows, Mac OS X and Unix-like systems such as Linux, BSD, and Solaris.

Fig.02: Claws Mail in ActionFig.02: Claws Mail in Action

=> Download Claws Mail

#3: Spicebird

Spicebird is a collaboration client that provides integrated access to email, contacts, calendaring and instant messaging in a single application. It provides easy access to various web services while retaining all the advantages of a desktop application. It is developed by an Indian company called Synovel. It is a free, open source and cross-platform software.

Fig.03: Spicebird in Action (image credit Spicebird project)Fig.03: Spicebird in Action (image credit Spicebird project)

=> Download Spicebird

#4: Zimbra Collaboration Suite (Open Source Version)

Zimbra is a client and server platform for messaging and collaboration. The web client integrates email, contacts, shared calendar, VoIP, and online document authoring in a rich browser-based interface. This is more like MS-Exchange and Outlook combo. In other words it is compatible with proprietary clients such as Microsoft Outlook and Apple Mail, both through proprietary connectors, as well as the open-source Novell Evolution, so that mail, contacts, and calendar items can be synchronised from these to the ZCS server. Zimbra also provides native two-way sync to many mobile devices such as Nokia Eseries, BlackBerry, Windows Mobile, iPhone with 2.0 software.

Fig.04: Zimbra (credit offical Zimbra website)Fig.04: Zimbra (credit offical Zimbra website)

=> Download Zimbra Collaboration Suite (Open Source Version)

#5: Sylpheed

Sylpheed is a free, GTK+-based, open source email and news client. It is very light lightweight. Sylpheed runs on Windows, Mac OS X and Unix-like systems such as Linux, and BSD.

Fig.05: Sylpheed in ActionFig.05: Sylpheed in Action

=> Download sylpheed

Comparison of E-mail Clients - Essential Features

The following tables compare general and technical information between e-mail client programs.

Feature Thunderbird Claws Mail Spicebird Zimbra Sylpheed
Cross-platform Y Y Y Y Y
License MPL, MPL/GNU GPL/GNU LGPL GPL MPL, MPL/GNU GPL/GNU LGPL MPL (server) and ZPL (client) GPL/LGPL
Cost Free Free Free Free Free
Authentication Y Y Y Y Y
SSL and TLS Y Y Y Y Y
Image blocking Y Y Y Y Y
Junk filtering Y Y Y Y Y
Phishing filtering Y Y Y Y ?
Add-ons Y Y Y ? N
Thread view Y Y Y Y Y
PGP support Y Y Y ? Y
Label Messages Y Y ? Y Y
Spell Checking Y Y ? Y N
Signatures Y Y Y Y Y
Scheduled message Y ? ? ? ?
Message templates Y Y ? Y Y
Database mbox MH, mbox ? File system MH
POP3 Y Y Y Y Y
IMAP4 Y Y Y Y Y
SMTP Y Y Y Y Y
NNTP (News) Y Y Y Y Y
RSS Feed Y Y Y Y N
LDAP Y Y Y Y N
iCalendar Y ? Y Y N
Paid Support ? ? ? ? Y

Y = supported; N = not supported; ? = unknown; Privacy feature; Security features; Productivity features; Cross-platform - runs on Mac OS X, Windows and UNIX like operating systems.

Other Email Clients For UNIX Like Operating Systems

  1. SeaMonkey - Mozilla SeaMonkey is an all-in-one Internet application suite that includes an Internet browser, email and newsgroup client, HTML editor, IRC chat, and web development tools. It includes a pop-up blocker, junk mail controls, and a tabbed interface.
  2. Pine (Alpine) - Alpine is a rewrite of the Pine Message System that adds support for Unicode and other features. Alpine is meant to be suitable for both inexperienced email users and the most demanding of power users.
  3. Evolution or Novell Evolution - Evolution provides integrated mail, addressbook and calendaring functionality to users of the GNOME desktop.

Our Recommendations:

  1. Claws Mail - Highly recommended for netbook user due to lightweight usage.
  2. Mozilla Thunderbird - The wide variety of add-on for this email client makes it very flexible, secure and easy to use. Highly recommended for desktop and power users.
  3. Zimbra Collaboration Suite ~ Open Source Edition or Businesses Editon - Highly recommended for business and corporate users due to its support for a broad range of email clients and mobile devices via "over the air" sync.

All of the e-mail client listed above used by me at one point or another. If you know of, or use, another e-mail client that offers better features than those mentioned here, tell us in the comments.