Tampilkan postingan dengan label Komputer. Tampilkan semua postingan

Quick Setting EasyHotSpot (Billing Hotspot System)

It seems like many people are having a hard time getting EasyHotspot up and running quickly. I’ll try to post an easy step by step tutorial which hopefully can used to get you on your way to a Easy to use Hotspot billing system.

Step 1

Requirements
before you can get easyhotspot up and running, you need these things:
- PC (for EHS server) that has 2 Network Interfaces (2 Ethernet Port)

- Internet Connection via Lan


- Access Point

- Get EasyHotspot Distro

From our download page or direct link here

Step 2

- Burn EasyHotspot distro to CD
- Install EasyHotspot to PC (similar to ubuntu installation process)

Step 3

- Connect the Internet Lan cable to the Eth0 PORT on your Server
Make sure you have internet connection by surfing the internet on the server.
- Connect the access point Lan cable to the Eth1 PORT on your Server
YOU DON’T HAVE TO DO ANYTHING with Eth1 , DISABLE DHCP FEATURE from your AP (if present)
If your using a Wireless Router please Disable the DHCP feature and connect Eth1 to LAN port , NOT WAN port!

Step 4

- Manage your Hotspot!
From your EasyHotspot server, open firefox and go to http://localhost/easyhotspot you can create billing and voucher plans from admin account, generate vouchers and invoice customers from cashier account.

Step 5

- Connect Clients / Customers
A client or customer can join your wireless Hotspot as usual by choosing your Network / AP name (SSID)
-  Login on the Client to browse the Web
Once a customer has join your network, they will be redirected to a login page before they can browse the web.  Login with the voucher or postpaid account  that you have created in step 4.
- Enjoy your EasyHotspot system!

Need more information or something isn’t working: visit the documentation page and the troubleshooting section and be sure to check out our forum!

Source : http://easyhotspot.wordpress.com/
Senin, 24 November 2014
Posted by Andi Kurniawan

Cara Membuat Interface SMS Gateway Server dengan PlaySMS


Install


This document explains about how to install and setup playSMS version 1.0-rc1

Requirements

Most of on the requirements on this list must be fulfilled. Please read this
part before starting the installation.
Minimum required hardware:
  • Web server capable hardware
Optional hardware or infrastructure:
  • GSM modem, single/modem pool (only when you plan to use Kannel, Gammu, Gnokii
    or smstools gateway plugins)
  • Internet connection (only when you plan to use Clickatell, Nexmo, Twilio,
    Infobip gateway plugins)
  • LAN (only when you plan to link 2 playSMS on different server in the same
    network using Uplink gateway plugin)
Minimum required softwares:
  • Operating System Linux
  • Web server software (for example Apache2, nginx or lighttpd)
  • Database Server MySQL 5.x.x or latest stable release
  • PHP 5.3 or latest stable release with mysql module enabled
  • PHP CLI (very important, do not forget this)
  • PHP PEAR and PHP PEAR-DB (very important, do not forget this)
  • PHP gettext extension (for text translation)
  • PHP mbstring extension (for unicode detection)
  • PHP GD extension (to draw graphs)
  • Access to SMTP server (playSMS will use this to send email)
  • Console browser such as lynx, wget or curl
  • Downloaded playSMS package from SF.net or latest source code from
    Github
  • Properly installed composer from https://getcomposer.org
Minimum required server administrator (or developer):
  • Understand howto make sure required softwares are installed
  • Understand howto make sure installed PHP has MySQL module
    enabled/loaded
  • Understand howto create/drop MySQL database
  • Understand howto insert SQL statements into created database
  • Basic knowledges to manage Linux (skill to navigate in console mode)

Installation

There are 2 methods explained in this document to install playSMS:
  1. Installation on Linux using install-script
  2. Installation on Linux step by step
You should pick only one method, do not do both methods.

Method 1: Installation on Linux using install-script

Install playSMS using install script install-playsms.sh
  1. Extract playSMS package somewhere (For example in /usr/local/src).
    tar -zxf playsms-1.0.0.tar.gz -C /usr/local/src
    ls -l /usr/local/src/`
    cd /usr/local/src/playsms-1.0.0/`
    
  2. Copy install.conf.dist to install.conf and edit install.conf.
    Then read install.conf and make changes to suit your system configuration
    cp install.conf.dist install.conf
    vi install.conf
    
  3. Run installer script
    ./install-playsms.sh
    
  4. Configure rc.local to get playsmsd started on boot Look for rc.local on /etc, /etc/init.d, /etc/rc.d/init.d
    When you found it edit that rc.local and put:
    /usr/local/bin/playsmsd start
    on the bottom of the file (before exit if theres an exit command).
    This way playsmsd will start automatically on boot.
Note:
  • After successful installation, please run command ps ax and see if
    playsmsd is running
    ps ax | grep playsms
    4069 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd schedule
    4071 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd dlrssmsd
    4073 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd recvsmsd
    4075 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd sendsmsd
    
  • Run several checks
    playsmsd status
    playsmsd check
    
  • Stop here and review your installation steps when playsmsd is not running
  • Consider to ask question in playSMS forum when you encountered a problem
  • If all seems to be correctly installed you may try to login from web by
    browsing http://<your web server IP>/playsms/ and login using default
    administrator user
    username: admin
    password: admin
    

Method 2: Installation on Linux step by step

Install playSMS by following step-by-step:
  1. Extract playSMS package somewhere (For example in /usr/local/src).
    tar -zxf playsms-1.0.0.tar.gz -C /usr/local/src
    ls -l /usr/local/src
    
  2. Run getcomposer.sh
    cd /usr/local/src/playsms-1.0.0
    ./getcomposer.sh
    
  3. Create playSMS web root, log, lib and set ownership to user www-data or
    web server user
    mkdir -p /var/www/playsms /var/log/playsms /var/lib/playsms
    chown -R www-data /var/www/playsms /var/log/playsms /var/lib/playsms
    
    There are Linux distributions using ‘apache’ as web server user instead of ‘www-data’.
  4. Copy files and directories inside ‘web’ directory to playSMS web root
    and set ownership again to user www-data or web server user, just to
    make sure
    cp -rR /usr/local/src/playsms-1.0.0/web/* /var/www/playsms
    chown -R www-data /var/www/playsms
    
  5. Setup database (import database)
    mysqladmin -u root -p create playsms
    mysql -u root -p playsms < /usr/local/src/playsms-1.0.0/db/playsms.sql
    
    You don’t need to use MySQL root access nor this method to setup playSMS
    database, but this is beyond our scope.
    You should read MySQL manual for custom installation method or howto insert
    SQL statements into existing database.
  6. Copy config-dist.php to config.php and then edit config.php
    cp /var/www/playsms/config-dist.php /var/www/playsms/config.php
    vi /var/www/playsms/config.php
    
    Please read and fill all fields with correct values
  7. Enter daemon/linux directory, copy files and folder inside
    cd /usr/local/src/playsms-1.0.0/daemon/linux
    cp etc/playsmsd.conf /etc/playsmsd.conf
    cp bin/playsmsd /usr/local/bin/playsmsd
    
  8. Just to make sure every paths are correct, please edit /etc/playsmsd.conf
    vi /etc/playsmsd.conf
    
    Make sure that PLAYSMS_PATH is pointing to a correct playSMS installation
    path (in this example to /var/www/playsms), and make sure that PLAYSMS_BIN
    is pointing to a correct playSMS daemon scripts path (in this example to
    /usr/local/bin)
  9. Start playsmsd now from Linux console, no need to reboot
    playsmsd start
    
  10. Configure rc.local to get playsmsd started on boot Look for rc.local on /etc, /etc/init.d, /etc/rc.d/init.d
    When you found it edit that rc.local and put:
    /usr/local/bin/playsmsd start
    on the bottom of the file (before exit if theres an exit command).
    This way playsmsd will start automatically on boot.
Note:
  • After successful installation, please run command ps ax and see if
    playsmsd is running
    ps ax | grep playsms
    4069 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd schedule
    4071 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd dlrssmsd
    4073 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd recvsmsd
    4075 pts/12  S    0:00 /usr/bin/php -q /usr/local/bin/playsmsd sendsmsd
    
  • Run several checks
    playsmsd status
    playsmsd check
    
  • Stop here and review your installation steps when playsmsd is not running
  • Consider to ask question in playSMS forum when you encountered a problem
  • If all seems to be correctly installed you may try to login from web by
    browsing http://<your web server IP>/playsms/ and login using default
    administrator user
    username: admin
    password: admin
    

Gateway Installation

Next, choose a gateway.
If you have GSM modem and plan to use it with playSMS, please continue to follow
instructions in INSTALL_SMSSERVERTOOLS to use SMS Server Tools (smstools3) as
your gateway module, or follow INSTALL_KANNEL if you want to use Kannel.
Gnokii and Gammu also supported, please follow INSTALL_GNOKII if you want to use
Gnokii as your gateway module, or INSTALL_GAMMU if you want to use Gammu.

Source : http://playsms.org/install/
Jumat, 15 Agustus 2014
Posted by Andi Kurniawan

Reset Password MySQL


Kita dapat merecover password server database MySQL dengan 5 langkah berikut:
  1. Hentikan (stop) proses server MySQL.
  2. Jalankan (start) proses server atau daemon MySQL (mysqld) dengan opsi –skip-grant-tables sehingga tidak akan menampilkan prompt password.
  3. Masuk (login melalui tool mysql) ke server MySQL sebagai pengguna root.
  4. Tulis password baru bagi root.
  5. Keluar dan restart server MySQL.
Berikut ini adalah contoh penerapan kelima langkah di atas (pastikan anda login di Linux sebagai ‘root’, kalo di Windows jadilah Administrator tertinggi):
  • Hentikan layanan MySQL:
/etc/init.d/mysql stop
killall mysqld
killall mysqld
Output:
Stopping MySQL database server: mysqld.
  • Jalankan server MySQL tanpa password:
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
  • Login ke server MySQL menggunakan client MySQL:
mysql -u root mysql
Output:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
  • Tentukan password baru bagi pengguna root MySQL:
USE mysql;
UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
quit
  • atau kalau password root 123456
use mysql;
UPDATE user SET Password = PASSWORD('123456') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
quit


  • Hentikan server MySQL:
/etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended
[1]+ Done mysqld_safe –skip-grant-tables
Jalankan server MySQL dan uji perubahan yang telah terjadi:
/etc/init.d/mysql start
mysql -u root -p

Cara Reconfigure MySQL di Debian / Ubuntu

Kalau di Debian dan anak cucunya malah lebih gampang lagi Pak, tinggal dgn satu perintah:
sudo dpkg-reconfigure mysql-server

Jika Masih belum WORK

Berikut langkah-langkah dalam melakukan reset password MySQL;
  1. Masuk kedalam mode sudoers;
    $ sudo /etc/init.d/mysql stop
    $ sudo mysqld_safe --skip-grant-tables &amp;
  2. Login kedalam mysql menggunakan user root;
    $ sudo mysql -u root
    mysql&gt; use mysql;
  3. Update password user yang akan diubah;
    mysql&gt; update user set password=PASSWORD("newrootpassword") where User='root';
    mysql&gt; flush privileges;
    mysql&gt; quit
  4. Matikan service mysql dan nyalakan kembali;
    $ sudo /etc/init.d/mysql stop
    $ sudo /etc/init.d/mysql start
  5. Untuk mengetahui apakah password yang sudah diubah tadi berhasil, lakukan perintah berikut;
    $ mysql --user=root --pass=password
Selamat mencoba

Sumber : http://opensource.telkomspeedy.com/wiki/index.php/Reset_Password_MySQL
               http://andrewdion.staff.ugm.ac.id/2012/10/cara-mereset-password-root-mysql/
Rabu, 28 Mei 2014
Posted by Andi Kurniawan

Search

Soal Latihan SMK 2013

Facebook Sisa Terakhir

Popular Post

Counter Visitor

Followers

- Copyright © Sisa Terakhir -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -