#database cd

New Post has been published on http://mocco.sk/the-way-to-run-your-personal-web-sms-portal-with-pointsms/

The way to Run Your personal Web SMS Portal With PointSMS

This tutorial will show you how you can set up an SMS web site on CentOS using PointSMS.

What we need before we start is apache, mysql server, php5, wget.

Installing MySQL 5

To install MySQL:

yum install mysql mysql-server

Then we create the system startup links for MySQL (so that MySQL starts automatically whenever the system boots) and start the MySQL server:

chkconfig –levels 235 mysqld on /etc/init.d/mysqld start

Installing Apache2

Apache2 is available as a CentOS package, therefore we can install it like this:

yum install httpd

Now configure your system to start Apache at boot time…

chkconfig –levels 235 httpd on

… and start Apache:

/etc/init.d/httpd start

Installing PHP5

We can install PHP5 and the Apache PHP5 module as follows:

yum install php-mysql php-gd php-imap php-ldap php-mbstring php-odbc php-pear php-xml php-xmlrpc

We must restart Apache afterwards:

/etc/init.d/httpd restart 

Installing PointSMS

Download PointSMS:

wget http://www.pointsms.org/downloads/pointsms_1.0.1_beta.tar

Untar PointSMS in /var/www/html:

cd /var/www/html tar xf pointsms_1.0.1_beta.tar

Edit config.php:

vi includes/config.php

Edit cron.php (set your installation path):

vi cron.php

Install a cronjob for cron.php to run every minute:

* * * * * php /var/www/html/cron.php

Install the database:

cd DB mysql -u root -p create database pointsms; exit; mysql -u root -p pointsms < pointsms.sql

Rename htaccess to .htaccess:

mv htaccess .htaccess

Point your favourite browser to your server’s IP, you have to see the screen below. Default username and password are admin/admin

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

Send SMS

To start sending SMS, you have to register to globosms.com web site and then to enter your details to PointSMS in admin –> Gateway section.