WebHosting Blog

List of Open Source Content Management System

Author bob on March 28th, 2008

Name Platform Supported databases Latest release Licenses

Apache Lenya       Java, XML, Apache Cocoon         2.0     Apache License
b2evolution           PHP     MySQL     1.10.3 “Key West”     GPL
BLOG:CMS           PHP     MySQL         GPL
blosxom                 Perl   Flat-file database     2.0     MIT
Bricolage                Perl     PostgreSQL     1.10.3     BSD
CivicSpace             PHP     MySQL     0.8.3     Open source, detail unknown
CMSimple             PHP     Flat-file database     3.0.1     Affero
Contrexx              Open Source edition     PHP     MySQL   1.2 Free for non-commercial use

Cyclone3               Perl, XUL, JavaScript, C, Java     MySQL and any Perl DBI     3.0     GPL
Daisy                     Java, XML, Apache Cocoon     MySQL     2.1     Apache License
Dokuwiki             PHP     Flat-file database     2007-06-26     GPL
DotClear              PHP     MySQL Beta version 2.0 supports PostgreSQL     1.2.7.1     GPL
DotNetNuke       ASP.NET     Microsoft SQL Server   4.8.1     BSD
Drupal                  PHP     MySQL or PostgreSQL     6.1     GPL

e107                      PHP     MySQL     0.7.11     GPL
Exponent              PHP     MySQL/PostgreSQL     0.96.6     GPL
eZ Publish            PHP     MySQL/PostgreSQL/Oracle/Microsoft SQL Server 4.0.0     GPL
Fedora                 Java     MySQL or Oracle     2.2     Educational Community License
Habari                  PHP     MySQL or SQLite     0.4.1     Apache License
ImpressCMS       PHP     MySQL     1.0     GPL
Jahia                   Java HyperSonic SQL, PostgreSQL, MySQL, Oracle 5.0.3 JCDDL & JSSL
Joomla!                 PHP     MySQL     1.5.2     GPL
KnowledgeTree   Document Management System     PHP     MySQL     3.5     GPL
Lyceum                PHP      MySQL     1.0.2     GPL
Magnolia               Java     JCR     3.5.4     GPL
Mambo           PHP       MySQL     4.6.3     GPL
MediaWiki       PHP     MySQL, PostgreSQL     1.12     GPL
Midgard CMS     PHP (Midgard framework)     MySQL     1.8.4     LGPL
MODx     PHP    MySQL     0.9.6.1     GPL
MoinMoin        Python     Flat-file database     1.6.2     GPL
Movable Type    Perl, mod_perl, FastCGI     MySQL or MS SQL server or Oracle or PostgreSQL or SQLite     4.1     GPL
Nucleus CMS     PHP     MySQL     3.32     GPL
Nuxeo CPS       Python     ZODB     3.4.3     GPL
Nuxeo EP        Java     PostgreSQL, MySQL, Oracle, SQL Server, Ingres     5.1.3     LGPL
OneCMS          PHP     MySQL     2.5     GPL
OpenACS         TCL AOLserver     PostgreSQL/Oracle     5.1.5     GPL
OpenCms         Java     MySQL, Oracle, PostgreSQL, SQL Server, DB2, HSQL     7.0.4     LGPL
phpCMS          PHP     Flat-file database     1.2.2     GPL
PHP-Fusion      PHP     MySQL     6.01.13     GPL
PHP-Nuke        PHP     MySQL     8.0     GPL
phpWCMS         PHP     MySQL     1.3.3     GPL
phpWebSite      PHP     MySQL or PostgreSQL     1.1.0     LGPL
PhpWiki         PHP     Flat-file database/MySQL/PostgreSQL etc.         GPL
PmWiki          PHP     Flat-file database     2.1.27     GPL
PostNuke        PHP     MySQL     .764     GPL
PyLucid         Python     MySQL, PostgreSQL, SQLite     0.8.0     GPL
Radiant         Ruby     MySQL, PostgreSQL, SQLite     0.6.4     MIT
Scoop           Perl on mod_perl     MySQL     1.1.8     GPL
Serendipity     PHP + Smarty     SQLite, PostgreSQL, MySQL, MySQLi     1.2     BSD
SilverStripe    PHP     MySQL     2.2.1     BSD
SiteFrame       PHP + Smarty     MySQL     5.0.2     Creative Commons
Slash           Perl on mod_perl     MySQL         GPL
SPIP            PHP     MySQL     1.9.2     GPL
TangoCMS        PHP     MySQL     1.0.8-Osprey     GNU/GPL 2
Textpattern     PHP     MySQL     4.0.6     GPL
TGS             PHP     MySQL     0.3.2     GPL
TikiWiki        PHP     MySQL and others using ADOdb     1.9.10.1     LGPL
TWiki           Perl     Perl DBI compatible     4.1.2     GPL
Typo            Ruby on Rails     MySQL, PostgreSQL, SQLite         MIT
TYPO3           PHP     MySQL, PostgreSQL, Oracle     4.1.5     GPL
Quick.Cms.Lite PHP     Flat-file database     2.0     GPL
WebGUI          Perl on mod_perl     MySQL         GPL

whCMS           PHP     MySQL     0.102     GPL
WordPress       PHP     MySQL     2.3.3     GPL
Xaraya          PHP with XHTML/XML/XSLT     MySQL, PostgreSQL, SQLite using ADOdb and Microsoft SQL Server with Creole     1.1.3     GPL
XOOPS           PHP     MySQL     2.0.18     GPL
XOOPS Cube      PHP     MySQL     2.1.3     BSD
Zena            Ruby     MySQL     alpha     MIT
Freecms         PHP     MySQL     .0.1     GPL

Comments (1)

web development

Method to repair the corrupt MySQL tables

Author bob on March 28th, 2008

Since, MySQL tables have a way of corrupting themselves. However MySQL offers a quick and easy method of repairing those tables.

Check how you can repair the corrupt MySQL tables;

Login to your VDS via SSH and change directories to the database that is having problems.

cd /usr/local/mysql/var/[DBNAME]/

You will need to replace [DBNAME] with the actual name of your database.

Stop the MySQL server:

/etc/rc.d/init.d/mysql stop

NOTE: Accounts created before July 7th, 2003 will want to use:

/etc/rc.d/init.d/mysqld stop

To check the tables:

myisamchk *.MYI

To repair tables:

myisamchk -r *.MYI

Restart MySQL:

/etc/rc.d/init.d/mysql start

NOTE: Accounts created before July 7th, 2003 will want to use:

/etc/rc.d/init.d/mysqld start

Alternatively, if you do not want to shut down MySQL, you can use mysqlcheck.

mysqlcheck [DBNAME]

To repair the database tables:

mysqlcheck -r [DBNAME]

You will need to replace [DBNAME] with the actual name of your database.

For additional help and documentation you can check here:
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
http://dev.mysql.com/doc/mysql/en/Using_mysqlcheck.html

Comments (0)

Hosting Tools

Creating Your Own Server Stat Script in PHP

Author bob on March 26th, 2008

Before you create your own server stat script in PHP, it is must to check your ports are responding. You should aware when one of your services are down, such as HTTP, MySQL, POP/SMTP, etc. Also, other information you should know the current server loads, and users which will be the chief indicator of a runaway script, or process.

So let’s start.

Make sure your php script ALWAYS must start with <?php this tells your server that it is in fact a php script

<?php

//You can replace the domain with an IP if you wish

$site = “mysite.com”; //this is the site you wish to check

// Let’s check our common ports 80, 21, and 110
$http = fsockopen($site, 80);
$ftp = fsockopen($site, 21);
$pop3 = fsockopen($site, 110);

if ($http) {
$status .= “HTTP: Working ”;
}
else {
$status .= “HTTP: Not Working ”;
}

if ($ftp) {
$status .= “FTP: Working ”;
}
else {
$status .= “FTP: Not Working ”;
}

if ($pop3) {
$status .= “POP3/SMTP: Working ”;
}
else {
$status .= “POP3/SMTP: Not Working ”;
}
echo(”$status”);

echo(”<hr>”);

// Users and load information
$reguptime = trim(exec(”uptime”));
if ($reguptime) {
if (preg_match(”/, *(\d) (users?), .*: (.*), (.*), (.*)/”, $reguptime, $uptime)) {
$users[0] = $uptime[1];
$users[1] = $uptime[2];
$loadnow = $uptime[3];
$load15 = $uptime[4];
$load30 = $uptime[5];
}
} else {
$users[0] = “Unavailable”;
$users[1] = “–”;
$loadnow = “Unavailable”;
$load15 = “–”;
$load30 = “–”;
}

echo(”Current Users: $users[0] 
Current Load: $loadnow Load 15 mins ago: $load15 Load 15 mins ago: $load30 <hr>”);

// Operating system
$fp = @fopen(”/proc/version”, “r”);
if ($fp) {
$temp = fgets($fp);
fclose($fp);

if (preg_match(”/version (.*?) /”, $temp, $osarray)) {
$kernel = $osarray[1];
preg_match(”/[0-9]{5,} ($(.* *)$\))/”, $temp, $osarray);
$flavour = $osarray[2];
$operatingsystem = $flavour.” (”.PHP_OS.” “.$kernel.”)”;
if (preg_match(”/SMP/”, $buf)) {
$operatingsystem .= ” (SMP)”;
}
} else {
$result = “(N/A)”;
}
} else {
$result = “(N/A)”;
}

echo(”Operating System: $operatingsystem”);
?>

The above code when uploaded to your server, it will display the status of your services, your user and load averages.

Now you can work with this, and make it look however you want, add new ports, etc.

Remember, this is just a very basic stat script.

Key Issues
One of the key issues you should aware that your host will need to allow the exec() funtion, in order for this to work properly.

Comments (0)

web server

How to Create Remote login page for DirectAdmin

Author bob on March 26th, 2008

To create a remote DirectAdmin login page, you will have to put some HTML codes in your website.
Consider your website url is www.yourdomain.com, your DirectAdmin login url will be http://www.yourdomain.com:2222 for non-SSL or https://www.yourdomain.com:2222 for SSL login.
You need to put the following HTML from in your website HTML codes.

<form action=’http://www.yourdomain.com:2222/CMD_LOGIN/’ method=’post’>
<table border=’1′ width=’250′ cellpadding=’2′ cellspacing=’0′>
<tr>
<td align=’right’>Username:</td>
<td><input type=’text’ name=’username’></td>
</tr>
<tr>
<td align=’right’>Password:</td>
<td><input type=’password’ name=’password’></td>
</tr>
<tr>
<td colspan=’2′ align=’center’><input type=’reset’ name=’r1′ value=’Reset’><input type=’submit’ name=’s1′ value=’Login’></td>
</tr>
</table>
</form>

In the code, you should replace “www.yourdomain.com” with your website domain name.
If you want to use SSL login, you should replace “http” with “https”.
Replace “Username:” and “Password:” with your own phrase if you like to translate it or such.
Replace “Login” and “Reset” with your own phrase if you like to translate it or such.

Now just put this code in your website where ever you need.

Comments (2)

control panel

Media Streaming & Video Hosting

Author bob on March 17th, 2008

Streaming media let you to stream video content in real time, you can sway viewing or listening such as preview, video clips and can enable view again features. With modest simple equipment and viewing control, you can be capable to broadcast an audio-visual material on a worldwide.

Through Internet-connected device, or a PC or something more precise, the user can access on-line media in much the same way as it was earlier possible only with a television or radio receiver. Also through podcast you can use much variation like you can download in full the audio material and play back on a computer or shift to a digital audio player for listening. Also On -demand streams are being stored on a server for a longer period, and are made accessible at a user’s request.
YouTube, is one of the best example for video streaming since it has grown up with enormous number of daily users and achieved popularity in a short time span. Youtub is is now world number one website for free streaming video. It uses a flash-based web player which streams video files in the format FLV. Users are able to watch videos without creating an account. The users those desire to upload their video and broadcast themselves can get an unlimited amount of videos and create own personal profile and subscriber list. Millions of new videos are uploaded every day in youtube attracting viewers worldwide, which is really incredible!

For web hosting of streaming media site you need greater control and network as well as highest security features with higher bandwidth and 24×7 technical support which should be your priority while looking for video hosting providers.

Comments (0)

Hosting Tutorials