How to install Phpmyadmin on SME server

Installation

wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm

Uninstallation

yum remove smeserver-phpmyadmin-multiuser

Use

You can access phpmyadmin interface by opening your web browser at the address:

https://[IP or DOMAIN]/myadmin

A login and a password is needed to connect. By default, the installation process creates a user "admin" with "admin" as password.

Of course, the first thing you have to do, is change the admin password.

Use the following commands (replace newpassword with your actual desired admin password).

You can also use the same commands to reset the admin password to admin, if you have any problems connecting (ie replace newpassword with the word admin). You must be logged in as the root user.

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'newpassword' WITH GRANT OPTION"
mysql --execute="flush privileges"

Settings

By default, installation process limit access at phpmyadmin to local network.

To enable phpmyadmin to be access from internet and local network :

db configuration setprop phpmyadminmulti access public
signal-event console-save

To limit access to local network :

db configuration setprop phpmyadminmulti access private
signal-event console-save

How to install OrangeHRM on SME server

Orange Human Resources Management (OrangeHRM) aims to be the world’s leading open source HRM solution for small and medium sized enterprises (SMEs) by providing a flexible and easy to use HRM system affordable for any company worldwide. The project was started during fall 2005 and the first beta release was made in January 2006. Today OrangeHRM has users worldwide enjoying a free, stable and highly usable HRM solution

In this Howto, we will not install OrangeHRM into ibays but into /opt/orangehrm instead.

OrangeHRM needs PHP5 … too bad smeserver 7.2 have php4 installed and you are advised not to upgrade to PHP5 because it will broke SMEServer system. But don’t worry, based on this howto : http://sme.firewall-services.com/spip.php?article46 you can add PHP5 as cgi .

Step 1. Install php5 as cgi

Code: [Select]

mkdir php5-cgi
cd php5-cgi

wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-imap-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-ldap-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-mysql-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-pear-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-xmlrpc-5.1.2-1.sp.i386.rpm

yum localinstall ./*.rpm
you can ignore post-upgrade and reboot process

Code: [Select]

mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/80php5-cgi
then paste below into 80php5-cgi template fragment

Code: [Select]

ScriptAlias /php5-cgi /usr/bin/php5

order deny,allow
deny from all
allow from all
Options ExecCGI

[Ctrl-X] : Y : [Enter]

Step 2. Install OrangeHRM

Code: [Select]

wget http://optusnet.dl.sourceforge.net/sourceforge/orangehrm/orangehrm-2.2.2.tar.gz

tar xfvz orangehrm-2.2.2.tar.gz

mv orangehrm-2.2.2 /opt/orangehrm

chown -R www:www /opt/orangehrm

pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90orangehrmpaste below to the terminal

Code: [Select]

Alias /orangehrm /opt/orangehrm


AddHandler php5-cgi .php
Action php5-cgi /php5-cgi/php

Options FollowSymLinks
AllowOverride all
order deny,allow
deny from all
allow from all
php_admin_value open_basedir /opt/orangehrm

Ctrl-X : Y : [Enter]

Expand the template and restart httpd

Code: [Select]

expand-template /etc/httpd/conf/httpd.conf

svc -t /service/httpd-e-smith
create mysql user and privileges

Code: [Select]

mysql -e "grant all privileges on *.* to orangehrmuser@localhost identified by 'yourpassword' WITH GRANT OPTION"

mysql -e "flush privileges"
Enable InnoDB, smeserver disable it by default

Code: [Select]

db configuration setprop mysqld InnoDB enabled
Do post-upgrade and reboot

Code: [Select]

signal-event post-upgrade
signal-event reboot
Point your web browser to http://[smeserver IP]/orangehrm

Follow the instructions on screen..

Privileged database Username : orangehrmuser
Privileged database User password : yourpassword

You can ignore "Memory alocated for PHP Script warning"..


Actually I want to write this into Howto wiki, but until now my access to edit wiki has not granted by the developers/doc team

I think it is enough to share in this forum until I have access to edit the wiki.

How to install PHPBB/forum on SME server

phpBB 2.0.22 for SMEserver 7.x is THE internet forum. With millions of installations worldwide, it is no wonder phpBB is one of the most popular ways to create and support a community. For more information see http://www.phpbb.com/.
Download

You can download this package at smeserver-phpbb . If you would like to save it directly on your SME Server, you should give this command at a linux-prompt

Installation and Uninstall

For installation just hit the following command
wget http://mirror.contribs.org/smeserver/releases/7/smecontribs/i386/RPMS/smeserver-phpbb-2.0.22-2.el4.sme.noarch.rpm
yum --enablerepo=smecontribs install smeserver-phpbb

For uninstall just hit the following command
yum remove smeserver-phpbb

You can ignore the yum-comments signal event post-upgrade and signal-event reboot.
Use

phpBB supports multiple languages. By default English, French, German, Italian, Spanish and Sweden languages are available. You can find phpbb in the /opt/phpBB2 directory. For using phpbb start your browser with the URL http://servername/forum and logon with the user admin + password admin .

How to install Cacti on SME server

Cacti is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.

Installation
This rpm require rrdtool 1.0 minimum. You can find it here [1] or download this local copy
[root@smeserver]#wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=317"
[root@smeserver]#yum localinstall rrdtool-1.0.50-3.el4.rf.i386.rpm
[root@smeserver]#wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=319"
[root@smeserver]#yum localinstall smeserver-cacti-0.8.7a-1.noarch.rpm

Uninstall
[root@smeserver]#yum remove smeserver-cacti-0.8.7a-1

Usage
You can access cacti interface by opening your web browser at the address:
https://[IP or NAME]/cacti

A login and a password is needed to connect. By default, installation process create a user "admin" with "admin" as password.

Of course, the first thing you have to do, is to change it
Settings

By default, installation process limit access at cacti to local network.

To enable cacti to be access from internet and local network :

db configuration setprop cacti access public
signal-event console-save

To limit access to local network :

db configuration setprop cacti access private
signal-event console-save

How to start SSH on SME server

How to install Joomla on SME server

Initially check the current version available from http://mirror.contribs.org/smeserver/contribs/dberteld/joomla/ which at the time of writing is smeserver-joomla-1.5.1-2.noarch.rpm

For install Joomla
[root@smeserver]#wget http://mirror.contribs.org/smeserver/contribs/dberteld/joomla/smeserver-joomla-1.5.1-2.noarch.rpm
[root@smeserver]#yum localinstall smeserver-joomla*.rpm

For uninstall joomla
[root@smeserver]#rpm -e smeserver-joomla