EPESI adalah aplikasi web sumber terbuka dan gratis serta salah satu solusi multi-pengguna tercanggih untuk mengelola informasi bisnis seperti CRM. Ini adalah aplikasi CRM yang berfungsi penuh yang dapat digunakan untuk menyimpan, mengatur, mengakses, dan berbagi catatan bisnis. Itu dibangun di atas kerangka kerja PHP/Ajax, sehingga Anda dapat mengubahnya dan mengembangkannya sesuka Anda.
Fitur
- Sederhana, ringan, dan cepat.
- Antarmuka pengguna berbasis web yang intuitif.
- Catatan tak terbatas dan lampiran file.
- Klien email Roundcube yang terintegrasi.
- Telepon dan Pelacak Proyek.
- Kontak bersama, kalender, tugas, panggilan telepon.
Dalam tutorial ini, kita akan mempelajari cara menginstal EPESI di server Ubuntu 18.04.
Persyaratan
- Server yang menjalankan Ubuntu 18.04.
- Pengguna non-root dengan hak istimewa sudo.
Memulai
Sebelum memulai, Anda perlu memperbarui sistem Anda dengan versi terbaru. Anda dapat melakukannya dengan menjalankan perintah berikut:
sudo apt-get update -y
sudo apt-get upgrade -y
Setelah sistem Anda diperbarui, mulai ulang sistem untuk menerapkan perubahan.
Instal Server LAMP
Pertama, Anda perlu menginstal server web Apache, server MariaDB, PHP, dan modul PHP lain yang diperlukan ke sistem Anda. Anda dapat menginstal semuanya dengan menjalankan perintah berikut:
sudo apt-get install apache2 mariadb-server php7.2 libapache2-mod-php7.2 php7.2-common php7.2-mbstring php7.2-xmlrpc php7.2-soap php7.2-gd php7.2-xml php7.2-intl php7.2-mysql php7.2-cli php7.2-ldap php7.2-zip php7.2-curl php7.2-imap unzip -y
Selanjutnya, Anda perlu membuat beberapa perubahan pada file konfigurasi default PHP:
sudo nano /etc/php/7.2/apache2/php.ini
Lakukan perubahan berikut:
memory_limit = 256M upload_max_filesize = 64M post_max_size = 64M max_execution_time = 30 max_input_vars = 1500 date.timezone = Asia/Kolkata
Simpan dan tutup file. Kemudian, mulai layanan Apache dan MariaDB dan aktifkan mereka untuk memulai saat boot dengan perintah berikut:
sudo systemctl start apache2
sudo systemctl enable apache2
sudo systemctl start mariadb
sudo systemctl enable mariadb
Konfigurasi MariaDB
Secara default, MariaDB tidak diamankan. Jadi, Anda harus mengamankannya terlebih dahulu. Anda dapat mengamankannya dengan menjalankan perintah berikut:
sudo mysql_secure_installation
Perintah ini akan mengatur kata sandi root, menghapus pengguna anonim, melarang login root jarak jauh, dan menghapus database pengujian seperti yang ditunjukkan di bawah ini:
Enter current password for root (enter for none):
Set root password? [Y/n]: N
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y
Setelah MariaDB diamankan, masuk ke shell MariaDB:
sudo mysql -u root
Masukkan kata sandi root Anda saat diminta. Kemudian buat database dan user untuk EPESI dengan perintah berikut:
MariaDB [(none)]> CREATE DATABASE epesidb;
MariaDB [(none)]> CREATE USER 'epesi'@'localhost' IDENTIFIED BY 'mypassword';
Ganti string 'mypassword' dengan kata sandi yang aman. Selanjutnya, berikan hak istimewa ke database EPESI dengan perintah berikut:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON epesidb.* TO 'epesi'@'localhost' IDENTIFIED BY 'mypassword';
Ganti string 'mypassword' dengan kata sandi yang aman. Selanjutnya, siram hak istimewa dengan perintah berikut:
MariaDB [(none)]> FLUSH PRIVILEGES;
Selanjutnya, keluar dari konsol MariaDB dengan perintah berikut:
MariaDB [(none)]> exit
Instal CMS EPESI
Pertama, Anda perlu mengunduh EPESI versi terbaru dari repositori Git.
Buka direktori /tmp:
cd /tmp
Anda dapat mengunduhnya dengan perintah berikut:
git clone https://github.com/Telaxus/EPESI.git
Selanjutnya, salin direktori EPESI ke direktori root Apache dengan perintah berikut:
sudo cp -r EPESI /var/www/html/epesi
Selanjutnya, Anda perlu menginstal Komposer ke sistem Anda. Anda dapat menginstalnya dengan menjalankan perintah berikut:
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer
Selanjutnya, ubah direktori menjadi epesi dan instal dependensi yang diperlukan menggunakan Composer:
cd /var/www/html/epesi
sudo composer install
Keluaran:
Deprecation warning: require.phpFastCache/phpFastCache is invalid, it should not contain uppercase characters. Please use phpfastcache/phpfastcache instead. Make sure you fix this as Composer 2.0 will error. Do not run Composer as root/super user! See https://getcomposer.org/root for details Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Package operations: 84 installs, 0 updates, 0 removals - Installing enyo/dropzone (v5.5.0): Downloading (100%) - Installing ezyang/htmlpurifier (v4.10.0): Downloading (100%) - Installing fzaninotto/faker (v1.8.0): Downloading (100%) - Installing ifsnop/mysqldump-php (dev-master 3c5ccfe): Cloning 3c5ccfea31 from cache - Installing jakub-onderka/php-console-color (v0.2): Downloading (100%) - Installing memio/model (2.0.4): Downloading (100%) - Installing memio/validator (v2.0.3): Downloading (100%) - Installing symfony/polyfill-ctype (v1.10.0): Downloading (100%) - Installing twig/twig (v1.36.0): Downloading (100%) - Installing memio/pretty-printer (2.0.3): Downloading (100%) - Installing memio/twig-template-engine (v2.0.3): Downloading (100%) - Installing memio/linter (v2.0.3): Downloading (100%) - Installing memio/memio (v2.0.0): Downloading (100%) - Installing moneyphp/money (v3.2.0): Downloading (100%) - Installing phpdocumentor/reflection-docblock (2.0.5): Downloading (100%) - Installing psr/cache (1.0.1): Downloading (100%) - Installing predis/predis (v1.1.1): Downloading (100%) - Installing phpfastcache/phpssdb (1.0.1): Downloading (100%) - Installing phpfastcache/phpfastcache (5.0.21): Downloading (100%) - Installing psr/container (1.0.0): Downloading (100%) - Installing pimple/pimple (v3.2.3): Downloading (100%) - Installing symfony/polyfill-php72 (v1.10.0): Downloading (100%) - Installing symfony/polyfill-mbstring (v1.10.0): Downloading (100%) - Installing symfony/var-dumper (v4.0.15): Downloading (100%) - Installing psr/log (1.1.0): Downloading (100%) - Installing symfony/debug (v3.0.9): Downloading (100%) - Installing symfony/console (v2.8.49): Downloading (100%) - Installing nikic/php-parser (v3.1.5): Downloading (100%) - Installing jakub-onderka/php-console-highlighter (v0.4): Downloading (100%) - Installing dnoegel/php-xdg-base-dir (0.1): Downloading (100%) - Installing psy/psysh (v0.9.9): Downloading (100%) - Installing ircmaxell/password-compat (v1.0.4): Downloading (100%) - Installing symfony/polyfill-php55 (v1.10.0): Downloading (100%) - Installing symfony/polyfill-php54 (v1.10.0): Downloading (100%) - Installing symfony/http-foundation (v2.8.49): Downloading (100%) - Installing tecnickcom/tcpdf (6.2.26): Downloading (100%) - Installing symfony/finder (v4.2.1): Downloading (100%) - Installing sebastian/version (2.0.1): Downloading (100%) - Installing sebastian/resource-operations (2.0.1): Downloading (100%) - Installing sebastian/recursion-context (3.0.0): Downloading (100%) - Installing sebastian/object-reflector (1.1.1): Downloading (100%) - Installing sebastian/object-enumerator (3.0.3): Downloading (100%) - Installing sebastian/global-state (2.0.0): Downloading (100%) - Installing sebastian/exporter (3.1.0): Downloading (100%) - Installing sebastian/environment (4.0.1): Downloading (100%) - Installing sebastian/diff (3.0.1): Downloading (100%) - Installing sebastian/comparator (3.0.2): Downloading (100%) - Installing phpunit/php-timer (2.0.0): Downloading (100%) - Installing phpunit/php-text-template (1.2.1): Downloading (100%) - Installing phpunit/php-file-iterator (2.0.2): Downloading (100%) - Installing theseer/tokenizer (1.1.0): Downloading (100%) - Installing sebastian/code-unit-reverse-lookup (1.0.1): Downloading (100%) - Installing phpunit/php-token-stream (3.0.1): Downloading (100%) - Installing phpunit/php-code-coverage (6.1.4): Downloading (100%) - Installing doctrine/instantiator (1.1.0): Downloading (100%) - Installing phpspec/prophecy (1.8.0): Downloading (100%) - Installing phar-io/version (2.0.1): Downloading (100%) - Installing phar-io/manifest (1.0.3): Downloading (100%) - Installing myclabs/deep-copy (1.8.1): Downloading (100%) - Installing phpunit/phpunit (7.5.1): Downloading (100%) - Installing jakubledl/dissect (v1.0.1): Downloading (100%) - Installing goaop/parser-reflection (1.4.1): Downloading (100%) - Installing doctrine/cache (v1.8.0): Downloading (100%) - Installing doctrine/lexer (v1.0.1): Downloading (100%) - Installing doctrine/annotations (v1.6.0): Downloading (100%) - Installing goaop/framework (2.2.0): Downloading (100%) - Installing codeception/aspect-mock (3.0.2): Downloading (100%) - Installing symfony/yaml (v3.3.18): Downloading (100%) - Installing symfony/contracts (v1.0.2): Downloading (100%) - Installing symfony/event-dispatcher (v4.2.1): Downloading (100%) - Installing symfony/dom-crawler (v4.2.1): Downloading (100%) - Installing symfony/css-selector (v4.2.1): Downloading (100%) - Installing symfony/browser-kit (v4.2.1): Downloading (100%) - Installing ralouphie/getallheaders (2.0.5): Downloading (100%) - Installing psr/http-message (1.0.1): Downloading (100%) - Installing guzzlehttp/psr7 (1.5.2): Downloading (100%) - Installing guzzlehttp/promises (v1.3.1): Downloading (100%) - Installing guzzlehttp/guzzle (6.3.3): Downloading (100%) - Installing symfony/process (v4.2.1): Downloading (100%) - Installing facebook/webdriver (1.6.0): Downloading (100%) - Installing codeception/stub (2.0.4): Downloading (100%) - Installing codeception/phpunit-wrapper (7.6.0): Downloading (100%) - Installing behat/gherkin (v4.5.1): Downloading (100%) - Installing codeception/codeception (2.5.2): Downloading (100%) moneyphp/money suggests installing ext-bcmath (Calculate without integer limits) moneyphp/money suggests installing ext-gmp (Calculate without integer limits) moneyphp/money suggests installing florianv/exchanger (Exchange rates library for PHP) moneyphp/money suggests installing florianv/swap (Exchange rates library for PHP) moneyphp/money suggests installing psr/cache-implementation (Used for Currency caching) phpdocumentor/reflection-docblock suggests installing dflydev/markdown (~1.0) phpdocumentor/reflection-docblock suggests installing erusev/parsedown (~1.0) predis/predis suggests installing ext-phpiredis (Allows faster serialization and deserialization of the Redis protocol) phpfastcache/phpfastcache suggests installing ext-apc (*) phpfastcache/phpfastcache suggests installing ext-memcache (*) phpfastcache/phpfastcache suggests installing ext-memcached (*) phpfastcache/phpfastcache suggests installing ext-predis (*) phpfastcache/phpfastcache suggests installing ext-redis (*) phpfastcache/phpfastcache suggests installing ext-sqlite (*) symfony/console suggests installing psr/log-implementation (For using the console logger) 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. You'll want this if your PHP install doesn't already support readline or libedit.) sebastian/global-state suggests installing ext-uopz (*) phpunit/php-code-coverage suggests installing ext-xdebug (^2.6.0) phpunit/phpunit suggests installing ext-xdebug (*) phpunit/phpunit suggests installing phpunit/php-invoker (^2.0) doctrine/cache suggests installing alcaeus/mongo-php-adapter (Required to use legacy MongoDB driver) symfony/contracts suggests installing symfony/cache-contracts-implementation symfony/contracts suggests installing symfony/service-contracts-implementation symfony/contracts suggests installing symfony/translation-contracts-implementation symfony/event-dispatcher suggests installing symfony/dependency-injection symfony/event-dispatcher suggests installing symfony/http-kernel facebook/webdriver suggests installing ext-SimpleXML (For Firefox profile creation) codeception/codeception suggests installing aws/aws-sdk-php (For using AWS Auth in REST module and Queue module) codeception/codeception suggests installing codeception/phpbuiltinserver (Start and stop PHP built-in web server for your tests) codeception/codeception suggests installing codeception/specify (BDD-style code blocks) codeception/codeception suggests installing codeception/verify (BDD-style assertions) codeception/codeception suggests installing flow/jsonpath (For using JSONPath in REST module) codeception/codeception suggests installing league/factory-muffin (For DataFactory module) codeception/codeception suggests installing league/factory-muffin-faker (For Faker support in DataFactory module) codeception/codeception suggests installing phpseclib/phpseclib (for SFTP option in FTP Module) codeception/codeception suggests installing stecman/symfony-console-completion (For BASH autocompletion) codeception/codeception suggests installing symfony/phpunit-bridge (For phpunit-bridge support) Generating autoload files Do not run Composer as root/super user! See https://getcomposer.org/root for details Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Package operations: 1 install, 0 updates, 0 removals - Installing tedivm/fetch (v0.7.1): Downloading (100%) Generating autoload files Do not run Composer as root/super user! See https://getcomposer.org/root for details Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Package operations: 1 install, 0 updates, 0 removals - Installing phpoffice/phpexcel (1.8.1): Downloading (100%) Generating autoload files Do not run Composer as root/super user! See https://getcomposer.org/root for details Loading composer repositories with package information Updating dependencies (including require-dev) Nothing to install or update Writing lock file Generating autoload files Do not run Composer as root/super user! See https://getcomposer.org/root for details Generated autoload files containing 14 classes
Setelah semua dependensi yang diperlukan telah diinstal, berikan izin yang sesuai ke direktori epesi dengan perintah berikut:
sudo chown -R www-data:www-data /var/www/html/epesi
sudo chmod -R 775 /var/www/html/epesi
Konfigurasi Apache untuk EPESI
Selanjutnya, Anda perlu membuat file host virtual Apache untuk EPESI. Anda dapat melakukannya dengan membuat file epesi.conf:
sudo nano /etc/apache2/sites-available/epesi.conf
Tambahkan baris berikut:
<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/epesi
ServerName example.com
ServerAlias www.example.com
<Directory /var/www/html/epesi/>
Options +FollowSymlinks
AllowOverride All
Require all granted
</Directory>
ErrorLog ${APACHE_LOG_DIR}/epesi_error.log
CustomLog ${APACHE_LOG_DIR}/epesi_access.log combined
</VirtualHost>
Simpan dan tutup file. Kemudian, aktifkan file virtual host EPESI dengan perintah berikut:
sudo a2ensite epesi
Selanjutnya, aktifkan modul penulisan ulang Apache dan mulai ulang server web Apache untuk menerapkan semua perubahan:
sudo a2enmod rewrite
sudo systemctl restart apache2
Setelah selesai, Anda dapat melanjutkan ke langkah berikutnya.
Akses Antarmuka Web CRM EPESI
EPESI CRM sekarang terinstal dan dikonfigurasi, saatnya mengakses antarmuka web EPESI CRM.
Buka browser web Anda dan ketik URL http://example.com. Anda akan diarahkan ke halaman berikut:
Pilih bahasa Anda, Anda akan melihat halaman berikut:
Sekarang, terima perjanjian Lisensi dan klik Berikutnya tombol. Anda akan melihat halaman berikut:
Sekarang, abaikan kesalahan dan klik Oke tombol. Anda akan melihat halaman berikut:
Sekarang, berikan semua detail yang diperlukan seperti, nama basis data, nama pengguna basis data, dan kata sandi. Kemudian, klik Berikutnya tombol. Anda akan melihat halaman berikut:
Sekarang, klik tombol Lanjutkan dengan pemasangan tombol. Anda akan melihat halaman berikut:
Sekarang, berikan nama pengguna dan kata sandi admin Anda. Kemudian, klik Berikutnya tombol. Anda akan melihat halaman berikut:
Sekarang, pilih setelan Mail Anda dan klik Berikutnya tombol. Anda akan melihat halaman berikut:
Sekarang, klik Berikutnya tombol. Anda akan melihat halaman berikut:
Sekarang, berikan format tanggal dan waktu Anda dan negara. Kemudian, klik OK tombol. Anda akan melihat halaman berikut:
Sekarang, berikan nama Perusahaan Anda, nama dan alamat Anda, Negara dan Kota. Kemudian, klik OK tombol. Setelah instalasi selesai dengan sukses. Anda akan melihat halaman berikut:
Selamat! Anda telah berhasil menginstal EPESI CRM di server Anda. Sekarang Anda dapat menghosting CRM EPESI Anda sendiri di lingkungan produksi Anda dengan mudah.