Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('icr49tuot4jrjwxolyyv100rhl9nj33u', '54.211.164.132', '1409644489', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1409644489', '0'); (The table 'swsessions' is full) Ubersmith Technical Support Options and Contact Information
Support Center » Knowledgebase » CentOS 5.x Installation Guide
 CentOS 5.x Installation Guide
Solution This article will guide you through the process of installing Ubersmith on a server running CentOS 5.6. This article makes the assumption that you are installing Ubersmith on a CentOS host with a base operating system installation already present. Installation of the CentOS operating system is outside of the scope of this document.?Please see this page?
for information on Ubersmith DE's system requirements.

Initial Setup
 

Install Apache, PHP (with related modules) and MySQL by issuing the following commands as the root user:


yum install httpd
yum install mysql mysql-server
yum install php php-mysql php-gd php-xmlrpc
yum install php-mbstring php-mcrypt php-gettext
rpm -Uvh http://www.ubersmith.com/downloads/pcre-6.6-2.7.x86_64.rpm

Start Apache and MySQL by issuing the following commands as the root user:


service httpd start
service mysqld start

Install and start the postfix mail server by issuing the following commands as the root user:

yum remove sendmail
yum install postfix

You'll need to edit postfix's default main.cf, to change the interfaces it listens on. This file is located in

/etc/postfix/main.cf

Change the line that reads

inet_interfaces = localhost

to read

inet_interfaces = all

This will ensure that outbound mail traffic can make it into the system. Start the postfix mail server like so:

service postfix start?

?Ensure that SELinux is set to?'permissive' mode or is disabled entirely, and that the system's security level allows for HTTP(S) connections. Take note that to enable HTTP(S) connections, you will need to select the "customize" option after issuing the following command:

system-config-securitylevel-tui

Update Apache Configuration 

This documentation assumes you are familiar with the process for configuring an Apache virtual host. If you are not, you can find more information at the Apache Software Foundation website, specifically the section on virtual hosts. Ensure that the Ubersmith .htaccess file has the required permissions by enabling the 'AllowOverride All' directive for the directory your Ubersmith installation is located under. This is typically done in the virtual host configuration file for the domain/subdomain where you are installing Ubersmith. For example:


<VirtualHost my.ubersmith.instance.com>
 ServerAdmin webmaster@my.ubersmith.instance.com
 DocumentRoot /var/www/html
 ServerName my.ubersmith.instance.com
 ErrorLog my.ubersmith.instance.com-error_log
 CustomLog my.ubersmith.instance.com-access_log common
</VirtualHost>

<Directory /var/www/html>
 AllowOverride All
</Directory>

Restart Apache to reload the virtual host configuration:

service httpd restart


MySQL Configuration

You'll want to create a MySQL database and user for Ubersmith to use. Since your newly installed MySQL database server likely does not have a root password, you can access MySQL by running

mysql

as root.

You can then execute:

mysql> CREATE DATABASE ubersmith;

to create the Ubersmith database, and

mysql> GRANT ALL PRIVILEGES ON ubersmith.* to 'ubersmith'@'localhost' IDENTIFIED BY 'somepassword';

where 'somepassword' is a password you've chosen. These commands will create a user 'ubersmith' that has the appropriate access to the database 'ubersmith'.

You'll use these details (the database name, user name, and password) later on in the Ubersmith setup wizard, so keep them handy.

Download Ubersmith
 

When you download the latest version of Ubersmith from

http://downloads.ubersmith.com/

you will have a selection of three different file formats. One file is zip compressed, one is a tar / gzip bundle, and one is a tar / bzip2 bundle. Depending on your selection, the method for extracting the files will differ.

For the .zip file:

unzip ubersmith-x.x.x.zip

For the .tar.gz file:

tar zxvf ubersmith-x.x.x.tar.gz

For the .tar.bz2 file:

tar jxvf ubersmith-x.x.x.tar.bz2


Copy the contents of the www directory to your apache web root, eg.


cd ubersmith-x.x.x/www
cp -a * .htaccess /var/www/html


Please ensure that the .htaccess file is copied correctly from the www directory to your apache web root. Copy the
config.ini.php and token.xml.php files to the directory above your web root and allow Ubersmith to modify them, eg.

cp token.xml.php config.ini.php /var/www
cd /var/www
chgrp apache token.xml.php config.ini.php

chmod g+w token.xml.php config.ini.php


Where
apache is the group your webserver runs as.

Install ionCube

Ubersmith requires the ionCube loaders to run. The free ionCuber loader files are available?here. Follow the instructions at the ionCube website for installation instructions specific to your platform and architecture. In most cases, you can install ionCube system wide by added the following lines to your system's

/etc/php.ini

file:

[Zend]
zend_extension=/usr/local/ioncube/ioncube_loader_lin_5.2.so

Note that the above statement assumes you have placed the ionCube loaders in?/usr/local/ioncube, and that you are running PHP 5.2.x. You will need to restart Apache after installing the ionCube loaders.

Run Ubersmith Setup 

Open the domain/subdomain where you have configured Ubersmith in your web browser, and you will see the Ubersmith setup wizard. Follow the directions in the wizard to configure your Ubersmith instance. Once finished, you must remove the setup directory before Ubersmith will run, eg.


rm -r /var/www/html/setup


Article Details
Article ID: 3
Created On: 23 Jul 2008 08:04 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Don't Register | Knowledgebase | Troubleshooter | Downloads
Language: