Cara instalasi dan mempergunakan trixbox

Trixbox adalah sebuah VoIP server yang dibundel menjadi

satu dengan system operasi, yaitu Linux CentOS. Trixbox

bersifat open source, artinya setiap orang dapat mengetahui

source code programnya dan memperolehnya secara gratis.

Trixbox terdiri dari komponen-komponen sebagai berikut:

1. Sistem operasi   : CentOS Linux

2. Database    : MySQL

3. VoIP server      : Asterisk

4. Tampilan GUI    : FreePBX

Trixbox dapat diinstal di komputer PC biasa, tidak harus

computer server. Untuk PC biasa, kebutuhan minimal untuk

dapat menginstal Trixbox sebagai berikut:

1. Pentium II 350 MHz

2. Memory 256 MB

3. Harddisk dengan ruang minimal 4 GB

4. LAN card 10/100 Mbps

5. CD-ROM

Pada percobaan kali ini, saya mempergunakan :

[i].   1 Buah komputer untuk Server Trixbox

[ii].  1 Buah komputer untuk client (softphone)

[iii]. 1 Buah IP-Phone D-link (GLV-515)

[iv].  1 Buah Switch 10/100 Mbps

[v].   Kabel Utp secukupnya

--------------------------------------------------

Langkah-langkah menginstall trixbox, yaitu :

--------------------------------------------------

[a]. Siapkan CD instalasi Trixbox

[b]. Pastikan bahwa setting pada BIOS akan mem-boot

 CD-ROM pertama kali, ubah terlebih dahulu jika

 setting BIOS belum benar

[c]. Masukkan CD Trixbox dan restart komputer.

 Tunggu hingga muncul tampilan berikut

[1].

--------------------------------------------------

--------------------------------------------------

[2]. Selanjutnya ikuti perintah yang muncul ^_^...

 Pemilihan Keyboard Type

--------------------------------------------------

--------------------------------------------------

[3]. Pemilihan Time Zone

--------------------------------------------------

--------------------------------------------------

[4]. Pengisian root password

--------------------------------------------------

--------------------------------------------------

[5]. Memulai Proses Instalasi

--------------------------------------------------

--------------------------------------------------

[6].

--------------------------------------------------

--------------------------------------------------

[7]. Menginstall bootloader

--------------------------------------------------

--------------------------------------------------

[8]. Booting Trixbox

--------------------------------------------------

--------------------------------------------------

[9]. Pengisian user dan password login. mode CLI

--------------------------------------------------

--------------------------------------------------

[10].

--> untuk pertolongan ketikan help-trixbox

--> lalu untuk mengkonfigurasi ethernet interface,

 ketikan system-config-network

--------------------------------------------------

--------------------------------------------------

[11]. Edit Devices

--------------------------------------------------

--------------------------------------------------

[12]. Pilih interface yang akan dipergunakan

--------------------------------------------------

--------------------------------------------------

[13]. Pilih ingin static IP atau DHCP

--------------------------------------------------

--------------------------------------------------

[14].Karena di lab menggunkan DHCP, maka saya me-request

 ip dari DHCP Server, IP yang didapat adalah

 10.14.200.17/24

--------------------------------------------------

--------------------------------------------------

[15].Untuk mempermudah konfigurasi, kita akan memakai

 bantuan GUI, buka browser dari komputer lain, ketikan

 https://10.14.200.17, rubah dari mode user ke

 mode admin

--------------------------------------------------

--------------------------------------------------

[16].Jika muncul permintaan user dan password, isi dengan

 user=maint dan password=password, untuk merubah

 password maint, di cli server ketikan passwd-maint

--------------------------------------------------

--------------------------------------------------

[17].

--------------------------------------------------

--------------------------------------------------

[18].Pilih PBX Settings

--------------------------------------------------

--------------------------------------------------

[19].Pilih Extensions,Add extension, Device:Generic

 SIP device, Submit

--------------------------------------------------

--------------------------------------------------

[20].Example:

 User Extension : 2003

 Display Name   : harry

 secret         : xxxx

--------------------------------------------------

--------------------------------------------------

[21].

--------------------------------------------------

--------------------------------------------------

[22]. Submit dan Apply Configuration Changes

--------------------------------------------------

--------------------------------------------------

[23]. Continue with Reload, sampai posisi ini konfigurasi

 sederhana server trixbox selesai.

--------------------------------------------------

--------------------------------------------------

[24]. Untuk Client kita menggunakan 1 buah soft-phone

 (x-lite) dan 1 biah IP-Phone GLV-515 (D-Link)

--------------------------------------------------

--------------------------------------------------

[25]. Pada X-lite, klik kanan, Sip account settings

 Add

--------------------------------------------------

--------------------------------------------------

[26]. di Account isikan:

 example :

 Display name : harry

 User name : 2003

 password : xxxx

 dll...

--------------------------------------------------

--------------------------------------------------

[27].Jika tidak ada masalah maka di x-lite akan muncul

 tulisan Ready, "Your username is 2003"

--------------------------------------------------

 --------------------------------------------------

[28].Ip phone yang digunakan adalah produk D-link

 (GLV-515), Bentuk fisiknya adalah seperti berikut:

--------------------------------------------------

a.

b.

c.

d.

--------------------------------------------------

[29].Di Ip-phone parameter minimal yang diisi adalah

 sebagai berikut:

--------------------------------------------------

 --------------------------------------------------

[30]. Untuk pengujian, softphone (x-lite) dengan user

 2003, akan menghubungi Ip-phone GLV-515 dengan

 user 2000, berikut merupakan screenshoot di Ip-

 phone ketika dihubungi oleh user 2003 (harry)

--------------------------------------------------

 --------------------------------------------------

Sekian dan mudah-mudahan dapat bermanfaat..

Read More

How To convert or change the code and query of MySQL to MySQLi

MySQL Connection =>
$conn = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD ) or die ("Can't connect to database: " . mysql_error());
mysql_select_db (DB_NAME) or die ("tidak bisa pilih database: " . mysql_error());

MySQLi Connection =>
$conn = mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die ("Can't connect to database: " . mysqli_error());

MySQL Query =>
$sql = "SELECT blog_id FROM wp_blogs WHERE domain ='iloveu.com'";
$query = mysql_query($sql);

MySQLi Query =>
$sql = "SELECT blog_id FROM wp_blogs WHERE domain ='iloveu.com'";
$query = mysqli_query($conn, $sql);

MySQL fetch data =>
$r = mysql_fetch_array($query);

echo "hi". $r[0];

MySQLi fetch data =>
$r = mysqli_fetch_array($query);

echo "hi". $r[0];

Read More

Instalasi & Konfigurasi Aplikasi Server - Sistem Operasi Debian

Buku Instalasi & Konfigurasi Aplikasi Server - Sistem Operasi Debian sebagai bagian dari bahan penerapan dan pengajaran sistem operasi jaringan dalam bidang ilmu komputer dan bidang keahlian Teknologi Informasi dan Komunikasi.
Hadirnya buku bertujuan untuk memberi pegangan kepada siswa pada kompetensi keahlian Teknik Komputer dan Jaringan, dan mahasiswa di semua program studi ilmu komputer, guru di Sekolah Menengah Kejuruan, dosen, pengelola pendidikan ilmu komputer, mahasiswa yang sedang menyusun skripsi, serta para pemerhati jaringan komputer pada umumnya. Hadirnya buku ini juga dimaksudkan sebagai jawaban untuk memenuhi permintaan yang sering muncul ke dalam email penulis akan akses dari smkalfattah.ilearning.me (ALFiL) dan sayabisa.com serta untuk melengkapi keberadaan buku-buku teks lain yang membahas materi serupa yang pada umumnya masih dalam konten yang terpisah yang sulit dipahami dan dikoleksi oleh pengajar dan peserta didik.
Dengan demikian, setiap mengakhiri pembahasan pada masing-masing bab, para pembaca diharapkan telah memperoleh pengetahuan yang dapat diterapkan dalam merancang sebuah aplikasi dalam server serta mempunyai keterampilan untuk memecahkan persoalan yang dihadapi secara mandiri.

Adapun buku ini dibagian dengan gratis dengan link berikut

Alhamdulillah, atas kekuasaan Allah, Google memberikan kepercayaan kepada saya juga untuk membagikan buku karangan saya melalui aplikasinya. Mohon kiranya saudaraku semua dapat membagikan sebagian ilmu Allah yang sedikit ini kepada yang membutuhkan ini link-nya https://play.google.com/store/books/details/Ahmad_Roihan_Instalasi_Konfigurasi_Aplikasi_Server?id=OK5oDwAAQBAJ wa bil khusus kepala SMK dan jurusan TKJ. Bismillah barokah.

Read More

How to clear CSS cache in your browser

Hapus cache CSS lama yang selalu tampil di halaman browser pada saat develop sebuah website, atau
you try to work in your local server but you want to clear your cache every time if you want to see changes on the css rules.

There is the way to control Google Chrome cache for this CSS, check this:

• Open DevTools (F12)
• Open Settings (bottom right or use F1 shortcut)
• Check Disable cache (while DevTools is open)

It's worked.

https://developers.google.com/web/tools/chrome-devtools/ui?utm_source=dcc&utm_medium=redirect&utm_campaign=2016q3#general

Read More

How to create multiple columns in one table with a single query statement POSTGRESQL

add column in alter table how to fix it:

this is the trick in PostgreSQL

ALTER TABLE t_company ADD COLUMN
  uktp character varying(100), ADD COLUMN
  usiup character varying(100), ADD COLUMN
  utdp character varying(100), ADD COLUMN
  uakta character varying(100), ADD COLUMN
  x character varying(25), ADD COLUMN
  y character varying(25);

Then Go or execute

Read More

How to fix base url in framework

We can set the base url or url in our framework to be automatically without change it wherever you want to place it in htdocs or localhost.

In CodeIgneter we will set it in application/config/config.php

Place this

$root = "http://".$_SERVER['HTTP_HOST'];
$root .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);

$config['base_url']    = "$root";

//$config[base_url] = "http://localhost/";

In Laravel we will set it in config/app.php

$root = "http://".$_SERVER['HTTP_HOST'];
$root .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);

return [

    'debug' => env('APP_DEBUG', false),

    //'url' => 'http://localhost',

      'url' => $root,

.......

So this is easy to fix all problem in your drive/ PC and your hosting wherever you want.

Read More

Install Laravel 5.0 and Whoops, looks like something went wrong

You have any problem with composer install in laravel-master for Laravel 5. Please follow this:

F:\xampp\htdocs\master\laravel-master>composer install
←[32mLoading composer repositories with package information←[39m
←[32mUpdating dependencies (including require-dev)←[39m
←[32mPackage operations: 59 installs, 0 updates, 0 removals←[39m
  - Installing ←[32msymfony/css-selector←[39m (←[33mv3.3.6←[39m): Loading from c
ache
  - Installing ←[32mtijsverkoyen/css-to-inline-styles←[39m (←[33m2.2.0←[39m): Lo
ading from cache
  - Installing ←[32mdoctrine/inflector←[39m (←[33mv1.1.0←[39m): Loading from cac
he
  - Installing ←[32msymfony/polyfill-mbstring←[39m (←[33mv1.5.0←[39m): Loading f
rom cache
  - Installing ←[32msymfony/var-dumper←[39m (←[33mv3.3.6←[39m): Loading from cac
he
  - Installing ←[32mjakub-onderka/php-console-color←[39m (←[33m0.1←[39m): Loadin
g from cache
  - Installing ←[32mjakub-onderka/php-console-highlighter←[39m (←[33mv0.3.2←[39m
): Loading from cache
  - Installing ←[32mdnoegel/php-xdg-base-dir←[39m (←[33m0.1←[39m): Loading from
cache
  - Installing ←[32mnikic/php-parser←[39m (←[33mv3.1.0←[39m): Loading from cache

  - Installing ←[32mpsr/log←[39m (←[33m1.0.2←[39m): Loading from cache
  - Installing ←[32msymfony/debug←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32msymfony/console←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32mpsy/psysh←[39m (←[33mv0.8.11←[39m): Loading from cache
  - Installing ←[32mvlucas/phpdotenv←[39m (←[33mv2.4.0←[39m): Loading from cache

  - Installing ←[32msymfony/routing←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32msymfony/process←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32msymfony/http-foundation←[39m (←[33mv3.3.6←[39m): Loading fro
m cache
  - Installing ←[32msymfony/event-dispatcher←[39m (←[33mv3.3.6←[39m): Loading fr
om cache
  - Installing ←[32msymfony/http-kernel←[39m (←[33mv3.3.6←[39m): Loading from ca
che
  - Installing ←[32msymfony/finder←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32mswiftmailer/swiftmailer←[39m (←[33mv5.4.8←[39m): Loading fro
m cache
  - Installing ←[32mparagonie/random_compat←[39m (←[33mv2.0.10←[39m): Loading fr
om cache
  - Installing ←[32mramsey/uuid←[39m (←[33m3.7.0←[39m): Loading from cache
  - Installing ←[32msymfony/translation←[39m (←[33mv3.3.6←[39m): Loading from ca
che
  - Installing ←[32mnesbot/carbon←[39m (←[33m1.22.1←[39m): Loading from cache
  - Installing ←[32mmtdowling/cron-expression←[39m (←[33mv1.2.0←[39m): Loading f
rom cache
  - Installing ←[32mmonolog/monolog←[39m (←[33m1.23.0←[39m): Loading from cache
  - Installing ←[32mleague/flysystem←[39m (←[33m1.0.41←[39m): Loading from cache

  - Installing ←[32merusev/parsedown←[39m (←[33m1.6.3←[39m): Loading from cache
  - Installing ←[32mlaravel/framework←[39m (←[33mv5.4.33←[39m): Loading from cac
he
  - Installing ←[32mlaravel/tinker←[39m (←[33mv1.0.2←[39m): Loading from cache
  - Installing ←[32mfzaninotto/faker←[39m (←[33mv1.7.1←[39m): Loading from cache

  - Installing ←[32mhamcrest/hamcrest-php←[39m (←[33mv1.2.2←[39m): Loading from
cache
  - Installing ←[32mmockery/mockery←[39m (←[33m0.9.9←[39m): Loading from cache
  - Installing ←[32msymfony/yaml←[39m (←[33mv3.3.6←[39m): Loading from cache
  - Installing ←[32msebastian/version←[39m (←[33m2.0.1←[39m): Loading from cache

  - Installing ←[32msebastian/resource-operations←[39m (←[33m1.0.0←[39m): Loadin
g from cache
  - Installing ←[32msebastian/recursion-context←[39m (←[33m2.0.0←[39m): Loading
from cache
  - Installing ←[32msebastian/object-enumerator←[39m (←[33m2.0.1←[39m): Loading
from cache
  - Installing ←[32msebastian/global-state←[39m (←[33m1.1.1←[39m): Loading from
cache
  - Installing ←[32msebastian/exporter←[39m (←[33m2.0.0←[39m): Loading from cach
e
  - Installing ←[32msebastian/environment←[39m (←[33m2.0.0←[39m): Loading from c
ache
  - Installing ←[32msebastian/diff←[39m (←[33m1.4.3←[39m): Loading from cache
  - Installing ←[32msebastian/comparator←[39m (←[33m1.2.4←[39m): Loading from ca
che
  - Installing ←[32mdoctrine/instantiator←[39m (←[33m1.0.5←[39m): Loading from c
ache
  - Installing ←[32mphpunit/php-text-template←[39m (←[33m1.2.1←[39m): Loading fr
om cache
  - Installing ←[32mphpunit/phpunit-mock-objects←[39m (←[33m3.4.4←[39m): Loading
 from cache
  - Installing ←[32mphpunit/php-timer←[39m (←[33m1.0.9←[39m): Loading from cache

  - Installing ←[32mphpunit/php-file-iterator←[39m (←[33m1.4.2←[39m): Loading fr
om cache
  - Installing ←[32msebastian/code-unit-reverse-lookup←[39m (←[33m1.0.1←[39m): L
oading from cache
  - Installing ←[32mphpunit/php-token-stream←[39m (←[33m1.4.11←[39m): Loading fr
om cache
  - Installing ←[32mphpunit/php-code-coverage←[39m (←[33m4.0.8←[39m): Loading fr
om cache
  - Installing ←[32mwebmozart/assert←[39m (←[33m1.2.0←[39m): Loading from cache
  - Installing ←[32mphpdocumentor/reflection-common←[39m (←[33m1.0←[39m): Loadin
g from cache
  - Installing ←[32mphpdocumentor/type-resolver←[39m (←[33m0.3.0←[39m): Loading
from cache
  - Installing ←[32mphpdocumentor/reflection-docblock←[39m (←[33m3.2.2←[39m): Lo
ading from cache
  - Installing ←[32mphpspec/prophecy←[39m (←[33mv1.7.0←[39m): Loading from cache

  - Installing ←[32mmyclabs/deep-copy←[39m (←[33m1.6.1←[39m): Loading from cache

  - Installing ←[32mphpunit/phpunit←[39m (←[33m5.7.21←[39m): Loading from cache
symfony/var-dumper suggests installing ext-symfony_debug ()
symfony/console suggests installing symfony/filesystem ()
psy/psysh suggests installing ext-pcntl (Enabling the PCNTL extension makes PsyS
H a lot happier :))
psy/psysh suggests installing ext-posix (If you have PCNTL, you'll want the POSI
X extension as well.)
psy/psysh suggests installing ext-readline (Enables support for arrow-key histor
y navigation, and showing and manipulating command history.)
psy/psysh suggests installing ext-pdo-sqlite (The doc command requires SQLite to
 work.)
psy/psysh suggests installing hoa/console (A pure PHP readline implementation. Y
ou'll want this if your PHP install doesn't already support readline or libedit.
)
symfony/routing suggests installing doctrine/annotations (For using the annotati
on loader)
symfony/routing suggests installing symfony/config (For using the all-in-one rou
ter or any loader)
symfony/routing suggests installing symfony/dependency-injection (For loading ro
utes from a service)
symfony/routing suggests installing symfony/expression-language (For using expre
ssion matching)
symfony/event-dispatcher suggests installing symfony/dependency-injection ()
symfony/http-kernel suggests installing symfony/browser-kit ()
symfony/http-kernel suggests installing symfony/class-loader ()
symfony/http-kernel suggests installing symfony/config ()
symfony/http-kernel suggests installing symfony/dependency-injection ()
paragonie/random_compat suggests installing ext-libsodium (Provides a modern cry
pto API that can be used to generate random bytes.)
ramsey/uuid suggests installing ircmaxell/random-lib (Provides RandomLib for use
 with the RandomLibAdapter)
ramsey/uuid suggests installing ext-libsodium (Provides the PECL libsodium exten
sion for use with the SodiumRandomGenerator)
ramsey/uuid suggests installing ext-uuid (Provides the PECL UUID extension for u
se with the PeclUuidTimeGenerator and PeclUuidRandomGenerator)
ramsey/uuid suggests installing moontoast/math (Provides support for converting
UUID to 128-bit integer (in string form).)
ramsey/uuid suggests installing ramsey/uuid-doctrine (Allows the use of Ramsey\U
uid\Uuid as Doctrine field type.)
ramsey/uuid suggests installing ramsey/uuid-console (A console application for g
enerating UUIDs with ramsey/uuid)
symfony/translation suggests installing symfony/config ()
monolog/monolog suggests installing aws/aws-sdk-php (Allow sending log messages
to AWS services like DynamoDB)
monolog/monolog suggests installing doctrine/couchdb (Allow sending log messages
 to a CouchDB server)
monolog/monolog suggests installing ext-amqp (Allow sending log messages to an A
MQP server (1.0+ required))
monolog/monolog suggests installing ext-mongo (Allow sending log messages to a M
ongoDB server)
monolog/monolog suggests installing graylog2/gelf-php (Allow sending log message
s to a GrayLog2 server)
monolog/monolog suggests installing mongodb/mongodb (Allow sending log messages
to a MongoDB server via PHP Driver)
monolog/monolog suggests installing php-amqplib/php-amqplib (Allow sending log m
essages to an AMQP server using php-amqplib)
monolog/monolog suggests installing php-console/php-console (Allow sending log m
essages to Google Chrome)
monolog/monolog suggests installing rollbar/rollbar (Allow sending log messages
to Rollbar)
monolog/monolog suggests installing ruflin/elastica (Allow sending log messages
to an Elastic Search server)
monolog/monolog suggests installing sentry/sentry (Allow sending log messages to
 a Sentry server)
league/flysystem suggests installing league/flysystem-aws-s3-v2 (Allows you to u
se S3 storage with AWS SDK v2)
league/flysystem suggests installing league/flysystem-aws-s3-v3 (Allows you to u
se S3 storage with AWS SDK v3)
league/flysystem suggests installing league/flysystem-azure (Allows you to use W
indows Azure Blob storage)
league/flysystem suggests installing league/flysystem-cached-adapter (Flysystem
adapter decorator for metadata caching)
league/flysystem suggests installing league/flysystem-eventable-filesystem (Allo
ws you to use EventableFilesystem)
league/flysystem suggests installing league/flysystem-rackspace (Allows you to u
se Rackspace Cloud Files)
league/flysystem suggests installing league/flysystem-sftp (Allows you to use SF
TP server storage via phpseclib)
league/flysystem suggests installing league/flysystem-webdav (Allows you to use
WebDAV storage)
league/flysystem suggests installing league/flysystem-ziparchive (Allows you to
use ZipArchive adapter)
league/flysystem suggests installing spatie/flysystem-dropbox (Allows you to use
 Dropbox storage)
league/flysystem suggests installing srmklive/flysystem-dropbox-v2 (Allows you t
o use Dropbox storage for PHP 5 applications)
laravel/framework suggests installing aws/aws-sdk-php (Required to use the SQS q
ueue driver and SES mail driver (~3.0).)
laravel/framework suggests installing doctrine/dbal (Required to rename columns
and drop SQLite columns (~2.5).)
laravel/framework suggests installing guzzlehttp/guzzle (Required to use the Mai
lgun and Mandrill mail drivers and the ping methods on schedules (~6.0).)
laravel/framework suggests installing league/flysystem-aws-s3-v3 (Required to us
e the Flysystem S3 driver (~1.0).)
laravel/framework suggests installing league/flysystem-rackspace (Required to us
e the Flysystem Rackspace driver (~1.0).)
laravel/framework suggests installing nexmo/client (Required to use the Nexmo tr
ansport (~1.0).)
laravel/framework suggests installing pda/pheanstalk (Required to use the beanst
alk queue driver (~3.0).)
laravel/framework suggests installing predis/predis (Required to use the redis c
ache and queue drivers (~1.0).)
laravel/framework suggests installing pusher/pusher-php-server (Required to use
the Pusher broadcast driver (~2.0).)
laravel/framework suggests installing symfony/dom-crawler (Required to use most
of the crawler integration testing tools (~3.2).)
laravel/framework suggests installing symfony/psr-http-message-bridge (Required
to psr7 bridging features (0.2.*).)
sebastian/global-state suggests installing ext-uopz (*)
phpunit/php-code-coverage suggests installing ext-xdebug (^2.5.1)
phpunit/phpunit suggests installing phpunit/php-invoker (~1.1)
phpunit/phpunit suggests installing ext-xdebug (*)
←[32mWriting lock file←[39m
←[32mGenerating optimized autoload files←[39m
> Illuminate\Foundation\ComposerScripts::postUpdate
> php artisan optimize
←[32mGenerating optimized class loader←[39m
←[32mThe compiled services file has been removed.←[39m


so in you browser show
Whoops, looks like something went wrong


This the trick about that

copy the .env.example to .env
I propose to use the editor to make it easy.
make sure APP_ENV=local is in there
It should then show you the detailed error messaging.

So after that you will know the problem is about
(1/1) RuntimeException The only supported ciphers are AES-128-CBC and AES-256-CBC with the correct key lengths.

Then you must write in terminal with

php artisan key:generate

F:\xampp\htdocs\master\laravel-master>php artisan key:generate
←[32mApplication key [base64:yW7slxavrbUFOqpndxTdJODZNyS/151uaZ9PWI/yGZ0=] set s
uccessfully.←[39m

Read More